19 votes

Batch geocoding in R

API conditions constantly change, but this should work right now. OSM: devtools::install_github("hrbrmstr/nominatim") library(nominatim) b1 <- osm_geocode("Berlin, Germany") b1[...
  • 3,234
15 votes

Obtaining up-to-date list of US ZIP Codes with Latitude and Longitude Geocodes?

Try this: http://download.geonames.org/export/zip/ It is licensed under a Creative Commons Attribution 3.0 License. They even have zip codes of various other countries around the world.
  • 151
12 votes
Accepted

Meaning of dash in house address number in USA?

In my experience, it usually means what you think it means: a range of address numbers. I've also seen it used as a way of writing an apartment or suite number, so 136-39 37 AVE would be 136 37th Ave, ...
  • 12.1k
11 votes
Accepted

How to Geocode a Google Sheet?

1) There's a bit of code you can add to your spreadsheet and run a macro. The instructions are detailed here: https://vilimpoc.org/blog/2013/07/11/google-spreadsheet-geocoding-macro/ with the code ...
10 votes
Accepted

Address searching/geocoding using Leaflet

I tried too and failed. Here is an option that uses OSM and has other options. https://github.com/perliedman/leaflet-control-geocoder and a HTML page that works using it. <!DOCTYPE html> <...
9 votes
Accepted

Finding out if coordinate is within shapefile (.shp) using pyshp?

PyShp will let you read the shapefile, but won't help you figure out if a point is in a boundary. You'll have to combine it with something like Shapely to do the geometric calculations. Luckily, the ...
  • 3,997
8 votes

Getting longitude/latitude coordinates from Addresses

So you want to geocode your file ("translate" adresses to xy coordinates). You can search by yourself using this "geocode" keywords and you'll find plenty information. However, in France, there is a ...
7 votes

How fast should I expect PostGIS to geocode well-formatted addresses?

I've spent a lot of time experimenting with this, I think it's better to post separately since they are from different angle. This is really a complex topic, see more details in my blog post about ...
  • 370
7 votes

Is there any geocoding for better international support?

Finally I found the service best shoot my need, Here MAP API. They support mulitiple language and has good zh-hant/zh-hans matching; eventhough, they don't have compelete translate, but well matched, ...
7 votes
Accepted

Can USA streets have both, name and number?

ST in an address suffix usually refers to the suite of a sub location. In this instance it means Suite 200. https://en.wikipedia.org/wiki/Suite_(address)
  • 1,239
7 votes
Accepted

Reverse geocoding in QGIS Graphical Modeller

There is a possibility of using a "Field calculator" inside the Graphical Modeler. Let's assume there is a point layer 'test' with some features in it, see the image below Thereafter I ...
  • 26k
6 votes

Seeking full list of ISO ALPHA-2 and ISO ALPHA-3 country codes?

On many Linux distributions, a list of iso country codes is installed by default under: /usr/share/xml/iso-codes/iso_3166.xml Under Fedora/CentOS/RHEL/Debian, the package that contains this file is ...
6 votes

How to Geocode a Google Sheet?

I found this Google Sheets formula in an answer in the Google Forums useful - =IMPORTXML("http://maps.googleapis.com/maps/api/geocode/xml?address="&C1, "/GeocodeResponse//location") Replace "C1" ...
  • 171
6 votes
Accepted

Georeferencing 1990 U.S. county names / FIPS for CartoDB?

Follow these steps: Download a us counties shapefile. Here's one that will work. Import the zipped UScounties file into CartoDB as a new table. Change the fips column's data type to number. (click on ...
  • 1,735
6 votes
Accepted

What is the name of the 3 word address system?

The website is called what3words which says on its website that: what3words is a unique combination of just 3 words that identifies a 3mx3m square, anywhere on the planet. It’s far more ...
  • 64.3k
6 votes

How do I address this error message in QGIS, "CSV file must be in UTF-8 encoding"?

Describes use of MMQGIS, a set of Python vector map layer plugins for Quantum GIS MMQGIS assumes that input and output shapefiles and CSV files are encoded in the UTF-8 character set. MMQGIS uses the ...
  • 11.9k
6 votes
Accepted

How to merge a dataset with geometry an another with number data?

You and your friend are using different versions of CARTO. While your friend is on the older UI, CARTO Editor, you're using the newer CARTO Builder. In CARTO Builder, dataset merges or joins are not ...
  • 456
6 votes

MMQGIS Geocode is failing in QGIS 3

I have found the solution. As the error suggests: the SSL in Python is not correctly installed. If you go to /application/python(your version) and then click "Install Certificates.command" ...
5 votes

Bulk geocoding 20 million US addresses

I'm geocoding 18 millions addresses right now so I want to share my setup. Basically I used an ansible playbook to setup Amazon EC2 instance as a PostGIS Tiger Geocoder server, then use script to ...
  • 370
5 votes

Geocoding addresses to coordinates in QGIS

You might try the plugin MMQGIS, which has geocoding functionality that will output a points shapefile. (You may have to add a COUNTRY column to your XLS file, as well as reproject the output points ...
  • 563
5 votes

How do you geocode addresses in R?

Use the R Library: ggmap. You will also need ggplot2 as well. Here's example code: library(ggmap) geocode("Toronto Ontario", output = "latlon" , source = "google")
  • 147
5 votes

How do you geocode addresses in R?

You could also use the photon package to geocode from other sources like OSM https://github.com/rCarto/photon # installation require(devtools) devtools::install_github(repo = 'rCarto/photon') ...
  • 7,568
5 votes
Accepted

Which geocoding providers allow storing of geocoded data?

Ah, this question. First, let me say that I work for an address validation company, SmartyStreets, but I will try to be objective. US Geocode data generally comes from two basic sources, FREE and ...
  • 1,464
5 votes
Accepted

Leaflet OSM Geocoder not working

As already pointed out in the comments, the problem is that you are directly opening the HTML file in your browser. This will show up like file:///C:/map.html in your address bar. The OSMGeocoder ...
  • 2,605
5 votes

MMQGIS Plugin error in QGIS 2.18

Libreoffice calc: You can choose the encoding with libreoffice calc: MS Excel Follow: https://help.surveygizmo.com/help/encode-an-excel-file-to-utf-8-or-utf-16 When saving as, click tools -> Web ...
  • 1,812
5 votes
Accepted

Geocoding single address with Leaflet?

As per the Leaflet Control Geocoder plugin API documentation, you should: Attach an event on the "markgeocode" event of the L.Control.geocoder object. Read the event.geocode.center LatLng object that ...
  • 6,953
5 votes
Accepted

Geocoding address involving non-ASCII characters in PyQGIS

IMHO the issue with non-ASCII characters shall not arise anymore, due to improvements that were done in software since 2017 year. Perhaps the problem was about the PyQGIS's version or OS settings. ...
  • 26k
5 votes

Free Open Source Geocoders using Local Address Data

You should definitely look closer at the Mapzen Pelias geocoder. We have been having this same issue for several years, and recently discovered that one of the back-end sources for Pelias is ...
5 votes
Accepted

Getting lat/lng from wkid, latestwkid and x y coordinates

You could use the ArcGIS server REST endpoint to convert to wkid 4326 (lat/lon). Here's a URL for one of Esri's sample servers: https://sampleserver1.arcgisonline.com/ArcGIS/rest/services/Geometry/...
  • 4,252
5 votes

Is geocoding with Nominatim available for all the countries?

Based on Nominatim FAQ, there are many reasons of why your search didn't get any result: Why wasn't anything found for my search? There are a number of reasons why no result may have been ...
  • 38.1k

Only top scored, non community-wiki answers of a minimum length are eligible