Zip, postal code, area code, city name lookup DBs

I need to build a feature to look up these items, and find distances between area and postal codes. What kind databases would you recommend? I need something to work with mysql and php.

 

I recommend you go to www.queryready.com and take a look they have latitude longitude zip codes for different countries in different formats

 

what country are you looking for the postal/zip codes. US or other countries?

 

hi

i have india postal code with std code and longitude and latitude any body intested pm me

 

I can do this for $200

You will provide me the DB

50% advance

work will be done in 1 day

Regards

Alex

 

If you need the latest POST OFFICE database USA Dec 17, 2007 (valid until March 24), or CANADA Dec 3, 2007 (valid until Feb 15, 2008), just PM me and I'll give one of them for free.

USA dataset has all Post offices (locations) + zip codes handled by Post office (6 day hours of operation, lat, long <- front door, fax & phone, +4) + the zip code dataset (41,675 records)

CANADA dataset has all Post offices (locations) + Postal codes handled by Post office (6 day hours of operation, lat, long <- front door, fax & phone) + the postal code dataset (892,874 records)

example data... (post offices)

record_number, office_closing_flag, zip_code, city_name, postoffice_name, proper_address, mapping_address, postoffice_phone, postoffice_fax, postoffice_hours_table_relation, postoffice_frontdoor_latitude, postoffice_frontdoor_longitude, +4

24889', '', '31648', 'GA', 'Statenville', 'Statenville', '113 GA Highway 94 E', '113 GA Highway 94 E', '8002758777', '8002758777', '8524', '30.703400', '-83.024696', '9998
24890', '', '31649', 'GA', 'Stockton', 'Stockton', 'Highway 84 E', 'Highway 84 E', '8002758777', '8002758777', '1505', '30.924400', '-83.037201', '9998
24891', '', '31625', 'GA', 'Barney', 'Barney', '13841 GA Highway 122', '13841 GA Highway 122', '2297752437', '8002758777', '1443', '31.008499', '-83.514297', '9998
24892', '', '31637', 'GA', 'Lenox', 'Lenox', '44 South Depot Street', '44 S Depot ST', '2295464289', '8002758777', '8525', '31.241100', '-83.423599', '9998
24893', '', '31769', 'GA', 'Mystic', 'Mystic', '224 Jackson Street', '224 Jackson ST', '8002758777', '8002758777', '8526', '31.621599', '-83.333000', '9998
24894', '', '31757', 'GA', 'Thomasville', 'Tall Timbers Village Station', '15 Liberty Street', '15 Liberty ST', '2292285839', '8002758777', '282', '30.838699', '-83.942398', '9998
24895', '', '39870', 'GA', 'Newton', 'Newton', '343 Sunset Boulevard', '343 Sunset Blvd', '8002758777', '8002758777', '1395', '31.313499', '-84.347504', '9998
24896', '', '31787', 'GA', 'Smithville', 'Smithville', '103 LE Conte Street', '103 LE Conte ST', '8002758777', '8002758777', '8527', '31.889601', '-84.224899', '9998
24897', '', '31824', 'GA', 'Preston', 'Preston', '190 Montgomery Street', '190 Montgomery ST', '8002758777', '8002758777', '1301', '32.066799', '-84.537003', '9998
24898', '', '31733', 'GA', 'Chula', 'Chula', '3272 US Highway 41 N', '3272 US Highway 41 N', '8002758777', '8002758777', '8528', '31.550699', '-83.549797', '9998
24899', '', '31760', 'GA', 'Irwinville', 'Irwinville', '121 Jeff Davis Park Road', '121 Jeff Davis Park RD', '8002758777', '2298316675', '2303', '31.648500', '-83.382797', '9998

Code (markup):

example data... (zip codes)

zip_record_number, sate_name_abber, geo_region, state_name_full, city_name, zip_code, latitude_name, latitude_position, longitude_name, longitude_position, county_name, zip_code_type, phone_area_code, time_zone_name, dst_flag, hours_from_gmt, zip_code_population, zip_code_elevation, state_fips, county_fips

12659', 'GA', '1', 'Georgia', 'Brooklet', '30415', 'N', '32.371609', 'W', '-81.670181', 'Bulloch', 'D', '912', 'Eastern', '1', '-5', '1113', '258', '13', '031
12660', 'GA', '1', 'Georgia', 'Claxton', '30417', 'N', '32.161476', 'W', '-81.909332', 'Evans', 'D', '912', 'Eastern', '1', '-5', '2276', '187', '13', '109
12661', 'GA', '1', 'Georgia', 'Cobbtown', '30420', 'N', '32.256462', 'W', '-82.124237', 'Tattnall', 'D', '912', 'Eastern', '1', '-5', '311', '207', '13', '267
12662', 'GA', '1', 'Georgia', 'Collins', '30421', 'N', '32.175266', 'W', '-82.110870', 'Tattnall', 'D', '912', 'Eastern', '1', '-5', '528', '207', '13', '267
12663', 'GA', '1', 'Georgia', 'Daisy', '30423', 'N', '32.150208', 'W', '-81.839203', 'Evans', 'P', '912', 'Eastern', '1', '-5', '9553', '187', '13', '109
12664', 'GA', '1', 'Georgia', 'Dover', '30424', 'N', '32.576786', 'W', '-81.715721', 'Screven', 'P', '912', 'Eastern', '1', '-5', '250', '236', '13', '251
12665', 'GA', '1', 'Georgia', 'Garfield', '30425', 'N', '32.599426', 'W', '-82.070816', 'Emanuel', 'D', '478', 'Eastern', '1', '-5', '7177', '332', '13', '107

Code (markup):

I'll also give you a few scripts (PHP & Perl, C++) to do the database lookups (MySQL, MSSQL or Oracle)


Offer is only given to the original poster...

 

Might be nice to provide demographics by zip code along with latitude/longitude information.