Need to find latitude and longitude of postcodes and store into my database

Posted by Matt on Stack Overflow See other posts from Stack Overflow or by Matt
Published on 2010-04-15T09:17:05Z Indexed on 2010/04/15 9:23 UTC
Read the original article Hit count: 399

Filed under:

latitude-longitude

|

google-maps

|

postcode

|

php

|

open-source

Hey guys, Ive got a database full of UK Postcodes, now i'd like to be able to store the latitude and longitude of these specific postcodes along with the record with the database. Is there anyway that i can obtain this data free without violating any T&C's?

I know i could do this using google maps api for each postcode, but i have way over 20,000 postcodes in this database and to get the lat and lng for each of these postcodes each time is not an option really.

Thanks in advance, M

© Stack Overflow or respective owner

Related posts about latitude-longitude

how to find latitude longitude from the address?

as seen on Stack Overflow - Search for 'Stack Overflow'
I am using MapKit for google map?How to find latitude longitude using address? >>> More
Fastest distance lookup given latitude/longitude?

as seen on Stack Overflow - Search for 'Stack Overflow'
I currently have just under a million locations in a mysql database all with longitude and latitude information. With this I use another lat/lng to find the distance of certain places in the database but it's not as fast as I want it to be especially with 100+ hits a second. Is there a faster formula… >>> More
Determine if a point is inside a triangle formed by 3 points with given latitude/longitude

as seen on Stack Overflow - Search for 'Stack Overflow'
I have 3 points ( lat , lon ) that form a triangle.How can i find if a point is inside this triangle? >>> More
SQL 2003 Distance Latitude Longitude

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a table full of Dealers along with their latitude and longitude. I am trying to determine the top n closest dealers to any given lat and lon. I already have the function to calculate distance between locations, but I want to do as few calculations as possible (my table can contain many thousands… >>> More
geo-indexing: efficiently calculating proximity based on latitude/longitude

as seen on Stack Overflow - Search for 'Stack Overflow'
My simple web app (WSGI, Python) supports text queries to find items in the database. Now I'd like to extend this to allow for queries like "find all items within 1 mile of {lat,long}". Of course that's a complex job if efficiency is a concern, so I'm thinking of a dedicated external module that… >>> More

Related posts about google-maps

DirectionsDistance in google maps API v3

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey, I'm trying to work out how to use this to get the distance from the successful directions: http://code.google.com/apis/maps/documentation/v3/reference.html#DirectionsDistance This is the code I have so far: var googleMaps = { // HTML Nodes fromInput: google_maps_from, toInput: google_maps_to… >>> More
Why does Internet Explorer break "pegman" display in Google Maps API v3?

as seen on Stack Overflow - Search for 'Stack Overflow'
On my site here, the SteetView control, aka "Pegman", works great under Firefox. Under IE (7 in this case, but tested on 8 as well - same result) it breaks the display of the pegman control. Here's my map code: var directionsDisplay; var directionsService = new google.maps.DirectionsService(); var… >>> More
How can I put multiple markers on Google maps with Javascript API v3?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I'd like to know how to put multiple markers for Google Maps using Javascript API v3. I tried the solution posted here: http://stackoverflow.com/questions/1621991/multiple-markers-in-googe-maps-api-v3-that-link-to-different-pages-when-clicked but it does not work for me for some reason. var… >>> More
Multiple markers in Googe Maps API v3 that link to different pages when clicked

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a map with multiple markers, which I populate via an array. Each marker is clickable and should take the user to a different url per marker. The problem is that all the markers, while displaying the correct title, all use the url of the last entry in the array. Here is my code: var myOptions… >>> More
Problem to display 3D google map.

as seen on Stack Overflow - Search for 'Stack Overflow'
hello friends, I have implemented one Flex application in which I want to display 3D google map.In which I am getting the error the NUll object reference during map display. Here is my code:- import com.google.maps.controls.MapTypeControl; import adobe.utils.XMLUI; import mx.rpc… >>> More