New answers tagged geocoding
Your Nominatim query includes a place_id field which has the value 4828147 in your example. This field serves as an internal identifier for Nominatim (so it is not globally unique). But it can be used to view Nominatim's internal address hierarchy for this place. This hierarchy also contains boundary relations, for example relation 1875245 and several other. ...
OK, solved. like most others having problems using this plugin i did not understand you must use UTF8 csv files as input. once this is done-no problem
I'm also working with global placenames and boundaries data (including historical) at present so I understand what you're going through! However, I think there's really two steps to your problem: 1. use a fuzzy name search to turn the name of an admin area into something standard, then 2. look up the boundaries of that place in databases of boundaries. ...
Cool project! You might take a look at MapIt: Global: MapIt is a service that maps geographical points to administrative areas. This edition is based on source data from the totally amazing OpenStreetMap project, so add your boundaries there if they’re missing. If you’re in the UK our MapIt UK with open Ordnance Survey data will probably be more useful. ...
IGN France has a good equivalent the Ordnance Survey MasterMap formally AddressPoint now Address Layer 2 database. http://www.ordnancesurvey.co.uk/business-and-government/products/address-layer-2.html based from many years of working very closely with OS addressing, it is in conjunction with Royal Mail (privatised in October 2013). Accuracy, it is ...
The US Census Bureau has Gazetteer files: http://www.census.gov/geo/maps-data/data/gazetteer.html For each year, there is an accompanying webpage. Select "Zip Code Tabulation Areas", and you will see a download link for a file. For example, the 2013 file is named "2013_Gaz_zcta_national.zip", which unzips into a tab-separated file. The schema for this file ...
MapBox also provides geocoding as part of their REST API and is probably worth considering. Mapbox API
One of the great things about structured text like this (generally fixed width data) is that it is pretty easy to parse out using a programming language. I used almost the same approach that @congrene used, but I wrote it with Python, which is widely used in the GIS community. You'll note that in many cases the City and State are not fully populated. ...
I know you asked for a solution using excel, but here is a short ruby script to parse this data. To use, you'll have to install ruby (https://www.ruby-lang.org/en/downloads/). Once set up, put the data and the script in the same folder and run: ruby munge.rb My result from running this on a portion of the sample data provided: ...
You could try converting the addresses to lat/lng via an open-source application like GPS visualizer - that could be a solution. However, I am not sure how much more efficient this would be and it may depend on where these addresses are located.
Given the fields that are of interest to you are in 3 different typical lines, and given your lack of programming skills, I might suggest you make a first pass at removing useless lines. You may be able to do that with a better text editor. As an example, the following command in Vim or GVim will delete all lines not containing either of these 3 conditions: ...
If you just want to create your own service (and not the processing itself, which is complex as posted above), you might like to setup your own Nominatim instance: http://wiki.openstreetmap.org/wiki/Nominatim
Please check out http://www.datasciencetoolkit.org/ a ready to use virtual machine(VM) for geocoding and reverse geocoding, it provides useful information including FIPS codes. i hope it will help.
Top 50 recent answers are included