clanstyles Posted March 29, 2011 Share Posted March 29, 2011 I've been developing an application for some time now. It's come to the point to populate the database with accurate information. I've been searching for a list of City, State, Zip, Long & Lat for each. How can I find something like this? I see tons of them for sale, 79 bucks or so, but I don't want to pay. How do most of these people get their data? Thank you Quote Link to comment Share on other sites More sharing options...
Skewled Posted March 30, 2011 Share Posted March 30, 2011 http://jesseprice.com/mysql-city-state-zip-latitude-longitude-database/ Google is your friend. I attached the referened material to this post so you can download the table structure, and zip code information from it. They can also be found at the URL above, I didn't read everything on the page except that it contained all the information you seem to be looking for. [attachment deleted by admin] Quote Link to comment Share on other sites More sharing options...
Zane Posted March 30, 2011 Share Posted March 30, 2011 Here's a valuable thread for you http://www.phpfreaks.com/forums/index.php?topic=208965.0 Quote Link to comment Share on other sites More sharing options...
clanstyles Posted April 6, 2011 Author Share Posted April 6, 2011 Thank you guys! So assuming I want to do a radius search based on Address OR City or Zip, i felt that a longitude & latitude search would be best. The reasons I came up with were: Most accurate MySQL can handle doing all the math. I'm not completely sure about this if it's the best way, but.. what do you guys think? Thank you! Quote Link to comment Share on other sites More sharing options...
BlueSkyIS Posted April 6, 2011 Share Posted April 6, 2011 What other ways are there for performing a radius search? Quote Link to comment Share on other sites More sharing options...
clanstyles Posted April 6, 2011 Author Share Posted April 6, 2011 I was going to do like Cities, just by location. Quote Link to comment Share on other sites More sharing options...
clanstyles Posted April 6, 2011 Author Share Posted April 6, 2011 I can't edit my above post. My best option I see is use Google, Yahoo and Bing's API to grab lat and long then store them in our database. I think this is against their TOS though. I'd like a more "proper" way to do this even if we have to pay. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.