[Resolved] Geo coding Help

Ray · Sep 19, 2007

Geo coding Help

Im am working on a website that will index restaurants in the United States. I seem to be stuck on search for the end-user. I was wondering if anyone could help me.

Basically, I want the user to be able to search for a restaurant in an (x) amount of miles from there zipcode. Now i understand that this task is caled geo coding. Meaning, I have to get the latitude and logitude coordinates from a particular address.

I was wondering if anyone knows a free script that i could use or if anyone knows how to accomplish this task.

Peter · Sep 19, 2007

Have you got a database already that has the geo coding information (ie the longitude and latitude of each zip)

If you have this data already within a database then you could get the database to do the calculations while doing your select query

The following shows calculations needed to do it:-

http://www.meridianworlddata.com/Distance-Calculation.asp

Also http://www.zipcodeworld.com/docs/distance.pdf has php code that can do it.

Ray · Sep 19, 2007

I have a database with every zip code in the United States with the corisponding information such as town, city, state, and latitude and logitude. I was looking for an address base...

SO basically, i need a script that will determine the cordinates on an address.

Ive been looking throught the google maps api, it looks like it can do the job.. but i dont want to be involved with all the tos..

EX: Search within 5 miles of zip 33333

Address street, town, city, is 3.2m from zip.

Peter · Sep 19, 2007

your best bet would be to have a close look at the pdf i supplied the link too and look how they calculate the distance, You can then translate that into sql and use it within a queries where clause (stating the distance should not be over x)

Ray · Sep 20, 2007

I solved my own problem.. I used Google Maps API. I coded the following script.

PHP:

<?php

$addressfind = "address here";

$key = "api key here";
$addresssend = urlencode($addressfind);
$url = "http://maps.google.com/maps/geo?q=".$addresssend."&output=csv&key=".$key;

$ch = curl_init();

curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_HEADER,0);
curl_setopt($ch, CURLOPT_USERAGENT, $_SERVER[‘HTTP_USER_AGENT’]);
curl_setopt($ch, CURLOPT_FOLLOWLOCATION, 1);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);

$data = curl_exec($ch);
curl_close($ch);
if (strstr($data,'200'))
{
$data = explode(",",$data);

$precision = $data[1];
$latitude = $data[2];
$longitude = $data[3];

echo "Latutide: ".$latitude." Longitude: ".$longitude;

} 

else 

{
echo "There was an error in your request!";
}

?>

kuehlschrankexperte.de

hdhub4u2.run

ispr-ip.fr

tmrholdings.co.za

warflix.nl

librio.jp

i-do-apply.co.za

efesirlamtakeaway.co.uk

lusiva.pt

anagram.si

[Resolved] Geo coding Help

VIP Member

VIP Member

VIP Member

VIP Member

VIP Member

SunSlick.com

Particles.com

Arivu.com

core.co

MainDish.com

exploitdb.com

VisitBali.com

NetUSA.com

AriWallet.com

Similar threads

We're social

SunSlick.com

Particles.com

Arivu.com

core.co

MainDish.com

exploitdb.com

VisitBali.com

NetUSA.com

AriWallet.com

Pinned

Appreciation

Preference

Appreciation

Upvoting

Agreement

Answers

Decisions

Relevance

Reaction

Facial expressions

Vocal expressions

Status

Workflow

Clarification

Feeling

Sympathy