Hi Wilkomez,
your postcode does crash my system. It appears that some crash & some don`t..strange!.
The street names are relatively easy, just find yourself a nice House Price Comparison Web Site, the one I have gives all the outer postcodes with a list of the inner codes by street names in alphabetical order. Just work your way through grabbing the data.
The data comes in the format "Street Name (HU5 3SS)" so a little jigging with a formula in excel is needed to extract the Streetname & postcode but I have the formula for that also.
I have a Spreadsheet set up with the postcode data I acquired & a VBA script that goes & gets the Lat/Long for each postcode automatically from Streetmap.
Of course these are all copyrighted materials from both sites so I am a bit edgy about posting the sites. If you PM me I will drop you the links,formula & the VBA script.
hope In7ane can help with getting the data into a geodata.dat file in the right order for us to use.
![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks