SQL Data For Sale
Networking Tools
Text Related Tools
Other Tools Etc
www.whatsmyip.org
L801 Postal AADC Data in SQL Form: $50

NOTE: L801 data is available free on the post office web site. I am not selling the data, I am performing the service of putting the data in an SQL file for you.

L801 data lists zip codes into groups for bulk mailing purposes. If you are making a system for organizing addresses for bulk mail, you need to group your addresses by AADC region (Automated Area Distribution Center), where the 3 digit codes are the first three digits of the address zip codes.

The data comes in the form of two tables. The first tables list each AADC zone by name, with a corresponding unique id number. The second table lists each 3 digit zip code individually, with an id number that corresponds to the AADC zone that zip belongs to. The data is based on the August 2nd, 2007 update of the AADC data.

Table 1 Sample: aadc (166 Total Rows)

5 AADC CENTRAL MA 015
6 AADC MIDDLESEX-ESX MA 018
7 AADC BOSTON MA 021

Table 2 Sample: aadc_codes (931 Total Rows)

5 014
5 015
5 016
5 017
6 018
6 019
6 055
7 021
7 022
7 024

If you are interested in purchasing this data, use the contact form at the bottom of the page to email me.

USA Zip Code Longitude & Latitude: $50

This table contains Longitude and latitude data for 43,187 zip codes. This is nearly all (possibly all) of the zip codes in the USA. Specifically, each row contains a zip code, that zip code's longitude and latitude. Then it contains three trigonometric fields that help shorten up the math required to calculate distances between zip codes. That is the sine and cosine of the latitude, and the radion of the longitude. If these extra fields are not needed, you can simply delete the columns.

Table Sample: zipcodes (43,187 Total Rows)

zip
lat
lon
sinlat
coslat
radlon
24217
37.0823
-82.1898
0.602962
0.79777
-1.43448
24218
36.7339
-83.0635
0.598099
0.801422
-1.44973
24219
36.852
-82.7706
0.59975
0.800187
-1.44462
24220
37.1385
-82.2564
0.603744
0.797178
-1.43564
24221
36.6278
-82.9646
0.596614
0.802528
-1.44801

If you are interested in purchasing this data, use the contact form at the bottom of the page to email me.

L801 Postal AADC Data in SQL Form &
USA Zip Code Longitude & Latitude: $80

Buy both data sets for $80 and save some cash.

If you are interested in purchasing this data, use the contact form at the bottom of the page to email me.

Obama '08

©2000-2008 / Contact Us / RSS / MySpace / @ Forum