Zip Code Tables

tj2653 · August 11th, 2006, 08:45 PM

It seems like all of the latitudes in the databases (at least the ones I checked) are actually longitudes, and vice versa. I noticed this when it gave me a distance of 61 miles from NJ to Virginia. When I changed the 2 zip codes lat/long data to their correct values, the distance was correctly shown as 162. What's the best way to fix this?

Chuck S · August 11th, 2006, 09:18 PM

Do you have example zipcodes as a test? I get proper distance in my testing. We use a free zipcode database.

tj2653 · August 12th, 2006, 12:01 AM

Quote:

Originally Posted by Chuck S

Do you have example zipcodes as a test? I get proper distance in my testing. We use a free zipcode database.

For example:
23336
lon: 37.91312 (these are backwards in the database)
lat: 75.35419

08837
lon: 40.50570 (backwards again)
lat: 74.35418

http://www.buyzips.com/zip/Edison/NJ/08837/Edison.htm <-- link showing these numbers are flip-flopped

Chuck S · August 12th, 2006, 08:32 AM

Our fields are not backwards. on a default install this is the zipcode table

Code:

Content visible to verified customers only.

here is the insert for edison

Code:

Content visible to verified customers only.

Latitude is the last column on an install and look at the insert above 74.35418 therefore our zipcode database is correct

tj2653 · August 13th, 2006, 01:35 AM

Quote:

Originally Posted by Chuck S

Our fields are not backwards. on a default install this is the zipcode table

Code:

Content visible to verified customers only.

here is the insert for edison

Code:

Content visible to verified customers only.

Latitude is the last column on an install and look at the insert above 74.35418 therefore our zipcode database is correct

Right, but as shown on http://www.buyzips.com/zip/Edison/NJ/08837/Edison.htm, the 74.35418 is supposed to be the longitude.

Chuck S · August 13th, 2006, 11:46 AM

You may alter things as you like this is a free zipcode database posted on the internet so this is not something we support. We support our code not the authenticity of third party stuff. However I would tell you in my testing it works fine cause edison new jersey is 125 miles from me and when I place a product with that zip and enter my zipcode to compare I get 125 miles

If you think all of the things are backwards try issuing these queries in your database

Code:

Content visible to verified customers only.

tj2653 · August 13th, 2006, 08:30 PM

Quote:

Originally Posted by Chuck S

You may alter things as you like this is a free zipcode database posted on the internet so this is not something we support. We support our code not the authenticity of third party stuff. However I would tell you in my testing it works fine cause edison new jersey is 125 miles from me and when I place a product with that zip and enter my zipcode to compare I get 125 miles

If you think all of the things are backwards try issuing these queries in your database

That fixed everything. 95% of the distances are now pretty spot-on, whereas before about 50% were close to correct, and the other 50% were way off. Thanks.

oldengine · November 20th, 2006, 12:12 AM

13126 to 34240 brings up 451 miles. Ny to FL is more like 1200 miles.

Has any procedure been written to incorporate a better zipcode database. paid or otherwise?

Chuck S · November 20th, 2006, 10:10 AM

You can try using the queries above and see what comes up for you. The next version will have this correction

oldengine · November 20th, 2006, 09:29 PM

I ran the queries and now the distance is 1,161 miles. Much closer to target. Thanks!