Latitude Longitude Finder

Is there some type of pre existing PHP app that I can include on my site that will allow a user to enter a street address, city, state, zip etc and then get the lattiude and longitude of that address?

OR

My page records address, city, etc. and writes it to a database. Is there code I can add to the write process that will add lattitude and longitude points to the database by using the data that the user inputs?
lvollmerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

TomeeboyCommented:
Hm... that's kind of a complex thing to add to a web site, or at least I would think so.  You could look into Google Maps, but I don't think they support the actual conversion to latitude/longitude:
http://www.google.com/apis/

There's is a site called Geocoder that has an available web service that you can subscribe to for getting regular coordinates from mailing addresses:
http://geocoder.us/

Other sites that give latitude/longitude, but may not have any kind of developer options:
http://www.hmssurprise.org/Resources/whereami.html

Hope that helps ;)

0
lvollmerAuthor Commented:
Tomee,
I am learning that this is a real pain, and something that a lot of developers are looking for.
0
TomeeboyCommented:
If you want to do it yourself, without paying for a service, then see this tutorial, which shows you how to do geocoding with PHP and MySQL in a step-by-step process:
http://blog.tooleshed.com/?p=16

There's also a Perl module that is specifically for getting the latitude/longitude:
http://search.cpan.org/~sderle/Geo-Coder-US/
 
Both of these use TIGER/Line data provided for free by the US Census Bureau:
http://www.census.gov/geo/www/tiger/
http://www2.census.gov/geo/tiger/

All of this may be a major headache for anyone other than an experienced programmer, though.  However, I have not personally tried implementing a feature like this before, so perhaps it's easier than it looks ;)
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
lvollmerAuthor Commented:
I have really lucked out. Turns out the data I am using has a seperate table with a unique key that links lat's and long's.

Thanks for the help!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
PHP

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.