PHP uye SQL: Verenga kana Query Yakakura Denderedzwa Kure Pakati Pakati Pepfungwa dzeLatitude uye Longitude Neiyo Haversine Fomula

Haversine Fomula - Verenga Great Circle Kure nePHP kana MySQL

Mwedzi uno ndanga ndiri kuronga zvishoma muPHP neMySQL zvine chekuita neGIS. Kutarisa kwakatenderedza mambure, ini ndaitove nenguva yakaoma kuwana zvimwe zve Geographic kuverenga kuti ndiwane chinhambwe pakati penzvimbo mbiri saka ndaida kugovana apa

Ndege Mepu Europe Nedenderedzwa Denderedzwa

Nzira yakapusa yekuverenga chinhambwe pakati pemapoinzi maviri iri kushandisa fomati yePythagorean kuverenga fungidziro yetriangle (A² + B² = C²). Izvi zvinozivikanwa se Euclidean chinhambwe.

Uku ndiko kunakidza kutanga asi hakushande neGeography nekuti nhambwe iri pakati pemitsetse yenharaunda nehurefu iri kwete daro rakaenzana parutivi. Sezvaunoswedera padhuze nequator, mitsara yeparutivi inowedzera kuenda kure. Kana iwe ukashandisa imwe mhando yeakareruka triangulation equation, inogona kuyera kureba nenzira kwayo mune imwe nzvimbo uye zvakashata zvakashata mune imwe, nekuda kwekukomberedza kwePasi.

Yakakura Denderedzwa Kure

Nzira dzinofambwa nzendo refu kutenderera Nyika dzinozivikanwa se Yakakura Denderedzwa Kure. Ndiko kuti… chinhambwe chipfupi pakati pemapoinzi maviri pane chimwe chikamu chakasiyana nemapoinzi ari mumepu yakati sandara. Sanganisa icho pamwe nenyaya yekuti iyo latitude uye mitsetse yehurefu haina kuenzana ... uye une kuverenga kwakaoma.

Heino yakanakisa vhidhiyo tsananguro yemashandiro eGreat Circles

Iyo Haversine Fomula

Iyo daro uchishandisa yakakomberedza yePasi inosanganisirwa mu Haversine fomula, iyo inoshandisa trigonometry kubvumira kutenderera kwepasi. Paunenge uchitsvaga chinhambwe pakati penzvimbo mbiri pasi (sekunguruka kwegungu), tambo yakatwasuka iri arc.

Izvi zvinoshanda mukubhururuka nendege - wakambotarisa pamepu chaiyo yendege ukaona kuti arched? Imhaka yekuti ipfupi kubhururuka mune arch pakati pemapoinzi maviri pane zvakananga kunzvimbo.

PHP: Verenga Daro Pakati Pakati pe2 Pfungwa dzeLatitude uye Longitude

Chero zvazviri, heino iyo PHP fomula yekuverenga iyo nhambwe pakati pemapoinzi maviri (pamwe neMile vs. Kilometre kutendeuka) yakakomberedzwa kunzvimbo mbiri dzekupedzisira.

function getDistanceBetweenPointsNew($latitude1, $longitude1, $latitude2, $longitude2, $unit = 'miles') {
  $theta = $longitude1 - $longitude2; 
  $distance = (sin(deg2rad($latitude1)) * sin(deg2rad($latitude2))) + (cos(deg2rad($latitude1)) * cos(deg2rad($latitude2)) * cos(deg2rad($theta))); 
  $distance = acos($distance); 
  $distance = rad2deg($distance); 
  $distance = $distance * 60 * 1.1515; 
  switch($unit) { 
    case 'miles': 
      break; 
    case 'kilometers' : 
      $distance = $distance * 1.609344; 
  } 
  return (round($distance,2)); 
}

SQL: Kudzorera Zvese Zvinyorwa Mukati meRange Nekuverenga Kureba Mumamirimita Uchishandisa Latitude uye Longitude

Izvo zvakare zvinoita kushandisa SQL kuita kuverenga kuti uwane zvese zvinyorwa mukati meicho chinhambwe. Mumuenzaniso uyu, ini ndiri kuenda kunotsvaga MyTable muMySQL kuti nditsvage zvese zvinyorwa zviri pasi kana zvakaenzana nemadhora akachinjika (muMiles) kunzvimbo yangu ku $ latitude uye $ longitude:

Mubvunzo wekutora ese marekodhi mukati meimwe yakatarwa mufambo nekuverenga chinhambwe mumakiromita pakati pemapoinzi maviri ehurefu uye kureba ndeiyi:

$query = "SELECT *, (((acos(sin((".$latitude."*pi()/180)) * sin((`latitude`*pi()/180)) + cos((".$latitude."*pi()/180)) * cos((`latitude`*pi()/180)) * cos(((".$longitude."- `longitude`)*pi()/180)))) * 180/pi()) * 60 * 1.1515) as distance FROM `table` WHERE distance <= ".$distance."

Iwe unofanirwa kugadzirisa izvi:

  • $ longitude - uku ndiko kusiyaniswa kwePHP uko ini ndiri kupfuudza hurefu hwenzvimbo yacho.
  • $ latitude - uku ndiko kusiyaniswa kwePHP uko ini ndiri kupfuudza hurefu hwenzvimbo yacho.
  • $ chinhambwe - iyi ndiyo nhanho iwe yaungade kuti uwane zvese zvinyorwa zvishoma kana zvakaenzana nazvo.
  • tafura - iyi ndiyo tafura ... iwe uchazoda kutsiva izvo nezita rako retafura.
  • latitude - uyu ndiwo munda wenharaunda yako.
  • kureba - uyu ndiwo munda wekureba kwako.

SQL: Kudzorera Zvese Zvinyorwa Mukati meRange Nekuverenga Kureba Mumakiromita Uchishandisa Latitude uye Longitude

Uye heino mubvunzo weSQL uchishandisa makiromita muMySQL:

$query = "SELECT *, (((acos(sin((".$latitude."*pi()/180)) * sin((`latitude`*pi()/180)) + cos((".$latitude."*pi()/180)) * cos((`latitude`*pi()/180)) * cos(((".$longitude."- `longitude`) * pi()/180)))) * 180/pi()) * 60 * 1.1515 * 1.609344) as distance FROM `table` WHERE distance <= ".$distance."

Iwe unofanirwa kugadzirisa izvi:

  • $ longitude - uku ndiko kusiyaniswa kwePHP uko ini ndiri kupfuudza hurefu hwenzvimbo yacho.
  • $ latitude - uku ndiko kusiyaniswa kwePHP uko ini ndiri kupfuudza hurefu hwenzvimbo yacho.
  • $ chinhambwe - iyi ndiyo nhanho iwe yaungade kuti uwane zvese zvinyorwa zvishoma kana zvakaenzana nazvo.
  • tafura - iyi ndiyo tafura ... iwe uchazoda kutsiva izvo nezita rako retafura.
  • latitude - uyu ndiwo munda wenharaunda yako.
  • kureba - uyu ndiwo munda wekureba kwako.

Ini ndaishandisa kodhi iyi mune yepamabhizimusi mepu chikuva chatakashandisa kuchitoro chekutengesa chine nzvimbo dzinopfuura chiuru kuNorth America uye chakashanda zvakaomarara.

77 Comments

  1. 1

    Ndatenda zvikuru nekugovana. Iri raive nyore kutevedzera uye kunama basa uye rinoshanda zvikuru. Makandichengetera nguva zhinji.
    FYI kune chero munhu anotumira kuC:
    double deg2rad (double deg) {return deg * (3.14159265358979323846 / 180.0); }

  2. 2

    Chidimbu chakanakisa chekutumira - chakashanda zvakanakisa - ini ndaifanira kungochinja zita retafura rakabata lat-refu. Inoshanda nekukasira kusvika .. Ndine nhamba diki inonzwisisika yemal lat (<400) asi ndinofunga izvi zvinokwira zvakanaka. Nice saiti zvakare - ini ndangoiwedzera kune yangu del.icio.us account uye ndinotarisa kumashure nguva zhinji.

  3. 4
  4. 5
  5. 8

    ndinofunga SQL yako inoda chirevo chine chirevo.
    pachinzvimbo CHENYU kure <= $ chinhambwe chaungangoda iwe
    shandisa HAVING chinhambwe <= $ chinhambwe

    kana zvisina kudaro ndinotenda nekundiponesa boka renguva nesimba.

  6. 10
  7. 11
  8. 12

    Ndatenda zvikuru nekugovana kodhi iyi. Zvakandichengetera yakawanda nguva yekuvandudza. Zvakare, nekutenda kune vaverengi vako nekunongedzera kuti HAVING chirevo chakakosha kune MySQL 5.x. Inobatsira kwazvo.

  9. 14
  10. 15

    Mhoro,

    Mumwe mubvunzo. Iko kune fomu yeiyo NMEA tambo senge iri pazasi?

    1342.7500, N, 10052.2287, E

    $GPRMC,032731.000,A,1342.7500,N,10052.2287,E,0.40,106.01,101106,,*0B

    Ndatenda,
    Harry

  11. 16

    Ndakaona zvakare kuti WHERE haina kundishandira. Yakachinja icho kuva HAVING uye zvese zvinoshanda zvakakwana. Pakutanga handina kuverenga makomendi uye ndikanyorazve ndichishandisa nested nest. Ose achashanda zvakanaka.

  12. 17
  13. 18

    Zvinoshamisa kubatsira, maita basa kwazvo! Ini ndanga ndine mamwe matambudziko neiyo itsva "KUSVIRA", pane kuti "PAPI", asi pandakangoverenga zvataurwa pano (mushure mehafu yenguva yekugeda mazino angu mukushushikana = P), ndakaiwana ichishanda zvakanaka. Ndatenda ^ _ ^

  14. 19
  15. 20

    Ramba uchifunga kuti chirevo chakasarudzwa senge chichava chakanyanya kuverenga uye nekudaro chinononoka. Kana iwe uine yakawanda yeaya mibvunzo, inogona kubhowa zvinhu pasi nekukurumidza.

    Maitiro akanyanya kushomeka ndeyekumhanyisa yekutanga (isina kuchena) sarudza uchishandisa nzvimbo yeSEQUARE inotsanangurwa nenzvimbo yakaverengerwa kureva "sarudza * kubva pazita retafura panotenderera pakati pe lat1 ne lat2 uye kureba pakati pe lon1 ne lon2". lat1 = yakatarwa - latdiff, lat2 = yakatarwa + latdiff, yakafanana ne lon. latdiff ~ = chinhambwe / 111 (chemakiromita), kana chinhambwe / 69 zvemamaira kubva padanho rekupamhama iri ~ 1 km (musiyano mushoma kubvira pasi riine denderedzwa zvishoma, asi rakakwanira chinangwa ichi). londiff = chinhambwe / (abs (cos (deg111rad (latitude)) * 2)) - kana makumi matanhatu emakiromita (unogona kutora chikwere chakati kurei kuitira kuti uwane musiyano). Wobva watora mhedzisiro yeiyo ndokudyisa iyo mune yakasarudzika sarudza Ingo usakanganwe kuodha zvekunze-kwe-miganho zvinongedzo - kureva huwandu hwenzvimbo inogamuchirwa ndeye -111 kusvika +69 uye huwandu hwenzvimbo inogamuchirwa iri -180 kusvika +180 - kana latdiff yako kana londiff ikamhanya kunze kweiyi renji . Ziva kuti muzviitiko zvakawanda izvi zvinogona kusashanda nekuti zvinongokanganisa kuverenga pamusoro pemutsara nepacific yegungwa kubva padanda kuenda padanda, kunyange ichipindirana chikamu chechukotka uye chikamu cheasaska.

    Izvo isu zvatinoita neizvi kudzikisira kwakakosha muhuwandu hwemapoinzi aunopikisa iyi kuverenga. Kana iwe uine mamirioni epasi rose mapoinzi mudhatabhesi akagoverwa zvakaenzana zvakaenzana uye iwe uchida kutsvaga mukati mezana remakiromita, ipapo yako yekutanga (nekukurumidza) yekutsvaga ndeye nharaunda 100 sq km uye ingangoburitsa zvingangoita makumi maviri mhedzisiro (zvichibva pakatogovaniswa pamusoro pe pamusoro penzvimbo inosvika mazana mashanu emamirimita sq km), zvinoreva kuti unomhanya daro rakaomarara kuverenga kakapetwa makumi maviri pamubvunzo uyu panzvimbo yemiriyoni nguva.

    • 21

      Kukanganisa kudiki mumuenzaniso… izvo zvinogona kunge zviri zvemakiromita makumi mashanu (kwete zana) sezvo tiri kutarisa "nharaunda" yeyedu… sikweya.

      • 22

        Anonakidza kuraira! Ini ndakanyatso shanda nemusimudziri uyo akanyora basa rakadhonza nzvimbo yemukati uyezve nekudzokorodza basa raigadzira 'zvikwere' kutenderedza mukombero kuti ubatanidze uye kusiyanisa mapoinzi asara. Mhedzisiro yacho yaive mhedzisiro inokurumidza zvisingaite - aigona kuyera mamirioni epfungwa muma microseconds.

        Maitiro angu pamusoro apa 'haana kuchena' asi anokwanisa. Thanks zvekare!

        • 23

          Doug,

          Ndanga ndichiedza kushandisa mysql uye php kuongorora kana lat yakareba poindi iri mukati mepoloni. Iwe unoziva kana yako yekuvandudza shamwari yakaburitsa chero mienzaniso yekuti ungaite sei iri basa. Kana iwe unoziva chero yakanaka mienzaniso. Kutenda mberi.

  16. 24

    Mhoroi vanhu vese iyi ndiyo bvunzo yangu yeSQL chirevo:

    SELECT DISTINCT area_id, (
    (
    (
    acos( sin( ( 13.65 * pi( ) /180 ) ) * sin( (
    `lat_dec` * pi( ) /180 ) ) + cos( ( 13.65 * pi( ) /180 ) ) * cos( (
    `lat_dec` * pi( ) /180 )
    ) * cos( (
    ( 51.02 - `lon_dec` ) * pi( ) /180 )
    )
    )
    ) *180 / pi( )
    ) *60 * 1.1515 * 1.609344
    ) AS distance
    FROM `post_codes` WHERE distance <= 50

    uye Mysql arikundiudza kuti chinhambwe, hachiripo sekoramu, ndinogona kushandisa kurongeka na, ndinogona kuzviita pasina KWAPI, uye zvinoshanda, asi kwete nazvo…

  17. 26

    Izvi zvakanaka, zvisinei hazvo sekungobhururuka kunoita shiri. Zvingave zvakanaka kuyedza uye kuisa iyo google mamepu API kune iyi neimwe nzira (pamwe kushandisa migwagwa etc.) Kungopa zano uchishandisa imwe nzira yekufambisa. Ndichine basa rekumisikidza yekubatanidza basa muPHP iyo yaizokwanisa kupa mhinduro inoshanda kudambudziko remutengesi. Asi ini ndinofunga kuti ndinogona kuzoshandisa imwe yekodhi yako kuzviita.

  18. 27
  19. 28

    Chinyorwa chakanaka! Ndakawana akawanda ezvinyorwa achitsanangura maitiro ekuenzanisa chinhambwe pakati pemapoinzi maviri asi ini ndanga ndichinyatsotsvaga iyo SQL snippet.

  20. 29
  21. 30
  22. 31
  23. 32
  24. 36

    2 mazuva ekutsvaga kuti pakupedzisira uwane iri peji rinogadzirisa dambudziko rangu. Zvinoita sekunge ini zvirinani kupururudza WolframAlpha yangu ndokwesha pamaths dzangu. Iko shanduko kubva KUNO kuenda KUNA KUTI ine chinyorwa changu mukushanda kurongeka. WAITA HAKO

  25. 37
    • 38

      Ndatenda Georgi. Ini ndakaramba ndichiwana column 'distance' isingawanikwe. Pane imwe nguva ini ndikachinja IYO KUNA KUSVIRA iyo yakashanda kunge chishongo!

  26. 39

    Ndinoshuva dai iri raive peji rekutanga randakawana pane iri. Mushure mekuyedza mirairo yakawanda yakasiyana iyi ndiyo yega yaifanira kushanda nemazvo, uye neshanduko diki diki kuti dzigone dhatabhesi rangu.
    Kutenda kwazvo!

  27. 40

    Ndinoshuva dai iri raive peji rekutanga randakawana pane iri. Mushure mekuyedza mirairo yakawanda yakasiyana iyi ndiyo yega yaifanira kushanda nemazvo, uye neshanduko diki diki kuti dzigone dhatabhesi rangu.
    Kutenda kwazvo!

  28. 41
  29. 42
  30. 43
  31. 45
  32. 46
  33. 47
  34. 49
  35. 50
  36. 52
  37. 53
  38. 55
  39. 56
  40. 58

    Ndatenda nekutumira chinyorwa ichi chinobatsira,  
    asi nekuda kwechimwe chikonzero ndinoda kubvunza
    nzira yekuwana sei chinhambwe pakati pemakosi mukati meybq db uye makosi akaiswa kune php nemushandisi?
    kutsanangura zvakajeka:
    1.user anofanirwa kuisa [id] yekusarudza yakatarwa dhata kubva ku db uye mushandisi wega makooni
    2. iyo php faira inowana iyo yakanangwa data (coords) uchishandisa [id] wozoverenga chinhambwe pakati pemushandisi uye chinangwa poindi

    kana unogona kungoita kure nekodhi iri pazasi?

    $ qry = “Sarudza *, (((acos (sin ((“. $ latitude. ”* pi () / 180)) * sin ((` Latitude` * pi () / 180)) + cos ((“. $ latitude. ”* pi () / 180)) * cos ((` Latitude` * pi () / 180)) * cos (((“. $ longitude.” - `Longitude`) * pi () / 180) ))) * 180 / pi ()) * 60 * 1.1515 * 1.609344) sedaro Kubva `MyTable` WHERE chinhambwe> =“. $ Distance. ” >>>> ndinogona "kubvisa" chinhambwe kubva pano?
    ndatenda futi,
    Timmy S

  41. 60

    ok, zvese zvandakaedza hazvisi kushanda. Ndiri kureva, izvo zvandinazvo zvinoshanda, asi madaro ari kure.

    Pane chero munhu angaone zviri kutadza nekodhi iyi?

    kana (isset ($ _ POST ['yakatumirwa'])) {$ z = $ _POST ['zipcode']; $ r = $ _POST ['nharaunda']; echo "Mhedzisiro ye". $ z; $ sql = mysql_query ("Sarudza DISTINCT m.zipcode, m.MktName, m.LocAddSt, m.LocAddCity, m.LocAddState, m.x1, m.y1, m.verified, z1.lat, z2.lon, z1. guta, z1.state KUBVA mrk m, zip z1, zip z2 APO m.zipcode = z1.zipcode NEZ2.zipcode = $ z UYE (3963 * acos (truncate (sin (z2.lat / 57.2958) * sin (m. y1 / 57.2958) + cos (z2.lat / 57.2958) * cos (m.y1 / 57.2958) * cos (m.x1 / 57.2958 - z2.lon / 57.2958), 8))) <= $ r ") kana kufa (mysql_error ()); nepo ($ row = mysql_fetch_array ($ sql)) {$ chitoro1 = $ mutsara ['MktName']. ""; $ store = $ row ['LocAddSt']. ”"; $ store. = $ row ['LocAddCity']. ",". $ row ['LocAddState']. " ". $ Mutsara ['zipcode']; $ latitude1 = $ mutsara ['lat']; $ longitude1 = $ mutsara ['lon']; $ latitude2 = $ mutsara ['y1']; $ longitude2 = $ mutsara ['x1']; $ guta = $ mutsara ['guta']; $ mamiriro = $ mutsara ['nyika']; $ dis = getnew ($ latitude1, $ longitude1, $ latitude2, $ longitude2, $ unit = 'Mi'); // $ dis = chinhambwe ($ lat1, $ lon1, $ lat2, $ lon2); $ yakasimbiswa = $ mutsara ['yakasimbiswa']; kana ($ verified == '1') {echo "”; echo "". $ chitoro. ""; echo $ dis. "Maira (ma) kure"; echo ""; } zvimwe {echo "". $ chitoro. ""; echo $ dis. "Maira (ma) kure"; echo ""; }}}

    mabasa angu.php kodhi
    basa getnew ($ latitude1, $ longitude1, $ latitude2, $ longitude2, $ unit = 'Mi') {$ theta = $ longitude1 - $ longitude2; $ chinhambwe = (chivi (deg2rad ($ latitude1)) * chivi (deg2rad ($ latitude2))) + (cos (deg2rad ($ latitude1)) * cos (deg2rad ($ latitude2)) * cos (deg2rad ($ theta)) ); $ daro = maacos (madhora madhora); $ chinhambwe = rad2deg ($ chinhambwe); $ chinhambwe = $ chinhambwe * 60 * 1.1515; chinja ($ unit) {kesi 'Mi': kutyora; kesi 'Km': $ chinhambwe = $ chinhambwe * 1.609344; } kudzoka (kutenderera ($ chinhambwe, 2)); }

    Ndinokutendai mberi

  42. 61
  43. 62

    Hei Douglas, chinyorwa chikuru. Ndakawana tsananguro yako yemamiriro epasi uye kodhi yacho inonakidza kwazvo. Zano rangu chete ndere kungova nzvimbo uye indent kodhi yekuratidzira (seStackoverflow, semuenzaniso). Ini ndinonzwisisa kuti iwe unoda kuchengetedza nzvimbo, asi zvakajairika kodhi spacing / induction zvinoita kuti zvive nyore kwazvo kwandiri, semupurogiramu, kuverenga uye kupatsanura. Zvisinei, icho chinhu chidiki. Chengetedza basa rakakura.

  44. 64
  45. 65
  46. 66
  47. 67
  48. 68
  49. 69
  50. 70

    zvinoita kunge nekukurumidza (mysql 5.9) kushandisa kaviri fomura musarudzo uye kupi:
    $ formula = “(((acos (sin ((“. $ latitude. ”* pi () / 180)) * sin ((` Latitude` * pi () / 180)) + cos ((“. $ latitude. ”* Pi () / 180)) * cos ((` Latitude` * pi () / 180)) * cos (((“. $ Longitude.” - `Longitude`) * pi () / 180))))) * 180 / pi ()) * 60 * 1.1515 * 1.609344) ”;
    $ sql = 'Sarudza *,'. $ fomula. ' sedaro KUBVA patafura WHERE '.. $ formula.' <= '. $ chinhambwe;

  51. 71
  52. 72

    Ndatenda zvikuru neshear ichi chinyorwa.inobatsira kwazvo.
    PHP yakatanga kugadzirwa seyakareruka scripting chikuva chinonzi "Yega Peji Peji". Mazuva ano PHP (ipfupi yeiyo Hypertext Preprocessor) ndeimwe nzira yeiyo Microsoft's Inoshanda Server Mapeji (ASP) tekinoroji.

    PHP ndeye yakavhurwa sosi server-parutivi mutauro uyo unoshandiswa kugadzira akasimba mapeji ewebhu. Inogona kuiswa mukati meHTML. PHP inowanzo shandiswa pamwe chete neMySQL dhatabhesi paLinux / UNIX seva webhu. Iyi ingangove mutauro unonyanya kufarirwa kunyora.

  53. 73

    Ndakawana pamusoro mhinduro isiri kushanda nemazvo.
    Ini ndoda kuchinja ku:

    $ qqq = “Sarudza *, (((acos (sin ((“. $ latitude. ”* pi () / 180)) * sin ((` latt` * pi () / 180)) + cos ((”. $ latitude. "* pi () / 180)) * cos ((` latt` * pi () / 180)) * cos (((". $ longitude." - `longt`) * pi () / 180) ))) * 180 / pi ()) * 60 * 1.1515) sedaro Kubva `kurejista``;

  54. 75
  55. 76

    Mhoro, ndapota ndichanyatsoda rubatsiro rwako pane izvi.

    Ndakagadzira chikumbiro kune yangu webhu-server http://localhost:8000/users/findusers/53.47792/-2.23389/20/
    53.47792 = Latitude
    -2.23389 = kureba kwemadhora
    uye 20 = daro randinoda kutora

    Nekudaro ichishandisa iwe fomula, inotora mitsara yese mu db yangu

    $ results = DB :: sarudza (DB :: mbishi (“Sarudza *, (((acos (sin ((“. $ latitude. ”* pi () / 180)) * sin ((lat * pi () / 180) )) + cos ((“. $ latitude.” * pi () / 180)) * cos ((lat * pi () / 180)) * cos (((“. $ longitude.” - lng) * pi ( ) / 180)))) * 180 / pi ()) * 60 * 1.1515 * 1.609344) sedaro Kubva KUMAKI KUVAKA chinhambwe> = “. $ Chinhambwe));

    [{"Id": 1, "zita": "Frankie Johnnie & Luigo Too", "kero": "939 W El Camino Real, Mountain View, CA", "lat": 37.386337280273, "lng": - 122.08582305908, "Chinhambwe": 16079.294719663}, {"id": 2, "zita": "Amici's East Coast Pizzeria", "kero": "790 Castro St, Mountain View, CA", "lat": 37.387138366699, "lng": -122.08323669434, ”distance”: 16079.175940152}, {“id”: 3, ”name”: ”Kapp's Pizza Bar & Grill”, ”address”: ”191 Castro St, Mountain View, CA”, ”lat”: 37.393886566162, "Lng": - 122.07891845703, "distance": 16078.381373826}, {"id": 4, "zita": "Round Table Pizza: Mountain View", "address": "570 N Shoreline Blvd, Mountain View, CA", "Lat": 37.402652740479, "lng": - 122.07935333252, "distance": 16077.420540582}, {"id": 5, "name": "Tony & Alba's Pizza & Pasta", "address": ”619 Escuela Ave, Mountain Wona, CA "," lat ": 37.394012451172," lng ": - 122.09552764893," chinhambwe ": 16078.563225154}, {" id ": 6," zita ":" Pizza yeFired-Pired yaOregano "," kero ":" 4546 El Camino Real, Los Altos, CA "," lat ": 37.401725769043," lng ": - 122.11464691162," chinhambwe ": 16077.937560795}, {" id ": 7," zita ":" Mabhawa uye grills "," kero ":" 24 Whiteley Street, Manchester "," lat ": 53.485118865967," lng ": - 2.1828699111938," distance ": 8038.7620112314}]

    Ini ndoda kutora mitsara chete nemakiromita makumi maviri asi inounza mitsara yese. Ndokumbirawo kuti chii chandiri kutadza

  56. 77

    Ndiri kutsvaga mubvunzo wakafanana asi ndakakwidza zvishoma - muchidimbu uku kuronga zvese zvinongedzo mukati memakiromita maviri kubva kune yega bato uye wobva waverenga kuti mangani marongero muboka rega uye anoburitsa boka rimwe chete rine makonati mazhinji - kunyangwe une anopfuura rimwe chete boka pakati pemapoka ane huwandu hwakawanda hweanoratidzira - chingoburitsa rakasarudzika boka kubva kumapoka ane iwo akaenzana nhamba -

Unofungei?

Nzvimbo iyi inoshandisa Akismet kuderedza spam. Dzidza kuti sei deta yako inoshandiswa.