1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

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

Discussion in 'PHP' started by o2pb, Oct 29, 2007.

  1. #1
    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.
    SEMrush
     
    o2pb, Oct 29, 2007 IP
    SEMrush
  2. Vamsi Krishna Yenigalla

    Vamsi Krishna Yenigalla Guest

    Messages:
    44
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    I recommend you go to www.queryready.com and take a look they have latitude longitude zip codes for different countries in different formats
     
    Vamsi Krishna Yenigalla, Nov 16, 2007 IP
  3. BluCava

    BluCava Peon

    Messages:
    50
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    what country are you looking for the postal/zip codes. US or other countries?
     
    BluCava, Nov 16, 2007 IP
  4. datamine

    datamine Peon

    Messages:
    12
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    hi

    i have india postal code with std code and longitude and latitude any body intested pm me
     
    datamine, Dec 30, 2007 IP
  5. kmap

    kmap Well-Known Member

    Messages:
    2,215
    Likes Received:
    29
    Best Answers:
    2
    Trophy Points:
    135
    #5
    I can do this for $200

    You will provide me the DB

    50% advance

    work will be done in 1 day

    Regards

    Alex
     
    kmap, Dec 30, 2007 IP
  6. dataman

    dataman Peon

    Messages:
    94
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    0
    #6
    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...
     
    dataman, Dec 30, 2007 IP
  7. point2point

    point2point Peon

    Messages:
    15
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #7
    point2point, Oct 4, 2008 IP