QGIS - formerly Quantum GIS

Geocoding addresses QGIS

UPDATE April 11, 2013: Updated the directions because the “Add delimited text layer” function moved from the Plugins to Layer menu.

UPDATE March 24, 2011: I updated the directions to use GPS Visualizer instead of BatchGeocode.com because BG stopped giving geographic coordinates in its output.

QGIS is an open-source Geographic Information Systems (GIS) application that has been gaining ground since 2004. It runs on all operating systems (it began as a Linux project) and you can download it for free.

I use it often because ESRI doesn’t make the popular ArcGIS software for Mac. That’s unfortunate, but like I said here, software, technology and mapping issues can be easily overcome – we can use QGIS to create maps. QGIS, though, is missing one major feature for basic map building: geocoding.

Here’s a step-by-step tutorial on how to bring in multiple street addresses and their XY coordinates into your QGIS map en masse:

To get “batch geocoding” in QGIS:
  1. Go to Plugins>Manage Plugins
  2. Check the checkbox next to “Add Delimited Text Layer
  3. Click Okay to add the plugin to your QGIS

Now you’re ready to do your batch geocoding which you’ll import into QGIS.

  1. In a spreadsheet, create the following columns in a header row (at a minimum): address, city, state. Other fields you can use: description, name, url, zip, image url
  2. Input your data into the appropriate columns
  3. Save the Excel document as a Tab Delimited Text file.
  4. Open the newly created Tab Delimited Text file in a text-only editor (like Notepad for Windows, TextEdit for Mac, or vi for Linux). Select all the text (including the headers) and copy to clipboard
  5. In the first text field, paste your text (ideally, you should only process 150 rows at a time)
  6. Set your options: Select whether your text is tabbed data with a header row, or just one address per line (no header). Then choose your geocoder, either Yahoo! or Google. Select the delimiter.
  7. Click Start Geocoding.
  8. Copy your now geocoded data back into your text-only editor and save.*

Now you’re ready to import this geocoded data into QGIS.

  1. In your QGIS document, select Layer>Add delimited text layer.
  2. In the dialog box, click Browse and find your newly created file.
  3. Create a layer name – the default is ugly, but you can change it later.
  4. Since your text file is tab-delimited, make “t” your delimiter for this import
  5. Click the Parse button to validate your input (Parse will also attempt to find your columns that hold the latitude and longitude)
  6. Ensure the X and Y fields have selected the appropriate columns in your text.
  7. Press OK!

Now you’ll see in your layer list the new layer with the data you batch geocoded. If you want to change the style, right click the layer and click Properties.

You might also like
How to use the AddressDoctor Excel Plugin
How to use the AddressDoctor Excel Plugin
LocateXL: Quick Geocoder in Excel
LocateXL: Quick Geocoder in Excel

Help with geocoding

by aoompaloompa

Morning-I'm trying to plot a list of addresses on a map using yahoo's service for that. Problem is, the data requires it being in a specific form according to an excel template they've provided as an example.
Now i'd like to know ;
1. General advice on the proccess
2. A way for excel to 'intelligently' break up data into corresponding cells
The problem is my data looks like this:
B & B Real Estate
7525 Auburn Boulevard
Citrus Heights, CA 95610-2239
And needs to look like this: (| being cell lines)
1600 Pennsylvania Avenue NW | Washington | DC | 20500 |The White House

Vintage History 1871 Map of Brazil, Bolivia, Paraguay, Uruguay & Chili of Brazil, Bolivia, Parag
Home (Vintage History)
  • 1871 Map of Brazil, Bolivia, Paraguay, and Uruguay ; Map of Chili. Scale ca. 1:10,, (W 74, W 69/S 24, S 42). Relief shown by hachures. Scale ca. 1:20,, (W 73, W...
  • Map size: 2 foot x 18 inches
  • Beautiful and Rare Historic Map
  • Archival Quality Reproduction

7 Game of Thrones Apps That Will Get You Through the Much-awaited Winter  — Gizmodo India
.. or Winterfell, you get a dialog box, which asks you to buy more maps. Unfortunately, you can't dismiss the dialogue box, leading to the obstruction of the cartography. ..

Flagstaff's rocky lava field became a little piece of the moon  — azcentral
If American know-how could put a man on the moon, the man should bring back rocks to study. The government agreed, and in 1963, the .. Volcanoes were chosen because of the moon's volcanic history, the test site for its impact craters.

Vintage History 1864 Civil War Map Petersburg shows Federal forces of the environs of Petersburg
Home (Vintage History)
  • 1864 Map of the environs of Petersburg from the Appomattox River to the Jerusalem Plank Road showing entrenchments occupied by Federal forces / Engineer Department...
  • Map size: 2 foot x 18 inches
  • Beautiful and Rare Historic Map
  • Archival Quality Reproduction

Missing in Alaska without a trace  — Anchorage Daily News
The official version of events, according to a still active missing person's bulletin from the Alaska State Troopers is that Griffis went into the wild "to test out a survival 'cocoon' that he had invented.

Vintage History 1895 Map of Knox County, Tennessee
Home (Vintage History)
  • 1895 Map of Knox County, Tennessee
  • Map size: 2 foot x 18 inches
  • Beautiful and Rare Historic Map
  • Archival Quality Reproduction
Vintage History 1746 map of Camarones Bay, Argentina, showing Camarones Bay and adjoining capes,
Home (Vintage History)
  • 1746 Map showing Camarones Bay and adjoining capes, Argentina. Oriented with north to the right.
  • Map size: 2 foot x 18 inches
  • Beautiful and Rare Historic Map
  • Archival Quality Reproduction
Lowrance Lowrance Elite-7 Gold CHIRP Fishfinder/Chartplotter with 83/200 KHz and 455/800 KHz Transducer and Navionics Cartography
GPS or Navigation System (Lowrance)
  • 7 Widescreen LCD
  • Includes Navionics Gold Cartography
  • Broadband CHIRP and Hi-Def. Down Imaging Sonar
  • Includes 83/200+455/800KHz transom mount transducer
  • Built-in GPS
Related Posts