I posted a CURRENT $5 usa zipcode db with lat/lon earlier, beware of the free ones because they are usually old.
Also remember for finding distance between zipcodes isnt tricky just not accurrate in all cases. Here is a situation i just went through. i bought the database which gave me lats/lons, so the user enters their zipcode and it would go to the zipcode db and get lat/lon then do the calculations thru the dealer db by zipcode and get the lat/lon. Ok but the problem is that you are getting the zipcodes center lat/lon of both the user and the shops and say the zipcode is 20 miles square on both and the user is in one corner of their zipcode and the shop is in opposite corner of their zipcode, then the distance could be almost 40 miles off, which isnt good. Now you cant get an EXACT distance unless the use inputs their exact address and you use the exact address to get lat/lon on both the user and shops. my problem was i am also showing a google map and if the shop wasnt in or near the middle of the zipcode then the marker wouldnt be on the screen since its marking the address. So what I had to do was add lat and lon fields to the dealer table and when someone searchs the dealers it sends a request out to google with the address and gets a page back with lat/lon on it and then i use cfhttp to parse the page and get lat & lon and enter them into that dealers db so that the map is correctly displayed and the distance locator uses the correct lat & lon and not the center of the lat & lon of zipcode. Now you could probably use a geoservice and pay about $40 a month to make that a bit easier (but not much). Im sure i didnt describe this too well since im way behind today but i was thinking of doing the whole dealor locator on a tut at easycfm soon. > Wanted to leave it open, as I may rather have driving distance in the > future. > But also, we want to do this for our UK offices as well. Seems at > least M$'s mapping api's took postal code as well as zip. > > What would a table of worldwide postal/zip codes and lat/long cost? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250245 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
