CalGIS2016 has ended
Welcome to the 22nd Annual California GIS Conference. CalGIS 2016 will take place May 10-12 at the Sheraton Park Hotel at the Anaheim Resort.

Creating an attendee profile within Sched DOES NOT REGISTER you for the conference or specific workshops. You must register for the conference here
Back To Schedule
Wednesday, May 11 • 11:45am - 12:05pm
Geocoding in Excel

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Through a variety of methods, it is possible to geocode your data live in Excel or Google Sheets. This has many useful applications, including automated geocoding, geocoding with multiple geocoders (e.g. The Census Geocoder and Google’s Geocoder), as well as the ability to have numerous people working on one set of data to manually geocode more rapidly.

This presentation could discuss but isn't limited to the following topics: methods used to prepare the data for geocoding using Powershell ISE, how to make API calls from Excel, how to structure API calls, formulas used for prioritizing various geocoders in Excel, using Google Sheets to geocode as a team, as well as using Excel macros and batch files to expedite the process.

Presenter: Ben Harloe, GIS Technician, Evari GIS Consulting, San Diego, CA

avatar for Ben Harloe

Ben Harloe

GIS Technician, Evari GIS Consulting
Ben Harloe is a recent graduate from the University of Redlands, where he studied Business, Mathematics, and GIS. During his time there he interned at ESRI for 6 months. He now lives in San Diego and works at Evari GIS Consulting performing a variety of beginner and intermediate technical... Read More →

Wednesday May 11, 2016 11:45am - 12:05pm PDT
Palm East