Zipcodes with latitude and longitude

Discussion in 'Databases' started by Divvy, Jan 14, 2011.

0
  1. #1
    Hello,

    Can someone help me?

    I have an list of all zipcodes from Portugal and I need all Latitude and Longitude of each one.

    Zipcodes list:
    http://www.enigmashare.com/v0wzawadldc4

    This list have too many informations... I only need to extract zipcodes.

    Line Example:
    15;02;1446;Alcochete;910215;Rua;dos;;;Fundadores;Bairro Coophabital;;;;2890;107;ALCOCHETE

    I need the last number:
    2890;1047 = 2890-107

    Like that:
    2890-107

    And also the latitude and longitude. I use this website:
    http://geocoder.pinguimcomfrio.net

    Example of latitude and longitude of 2890-107 zipcode:
    38.7560327, -8.9610319

    What I really need:
    2890-107
    38.7048942, -8.9511663

    I need the list in CSV or MySQL database format.
    Please PM me and let me know your price for that.

    Thank you
     
    Divvy, Jan 14, 2011 IP
  2. olddocks

    olddocks Notable Member

    Messages:
    3,275
    Likes Received:
    165
    Best Answers:
    0
    Trophy Points:
    215
    #2
    try geocoding the addresses with google maps and you can store it in mysql or elsewhere. i think google allows 2500 geocoding daily. checkout their site.
     
    olddocks, Jan 14, 2011 IP
  3. nicky821

    nicky821 Member

    Messages:
    95
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    41
    #3
    I wrote myself a tool for that. You need to enter the destination name and you'll get the longitude + latitude from google. You are able to crawl bulk lists. private mail me if you need it. I can provide the output just like you want to.
     
    nicky821, Jan 14, 2011 IP