Batch geocode CSV files in a nice visual interface
Geocoding is a pain in the neck. If you're just looking at US addresses, though, Little Geocoder is here to help! Latitude and longitude, just for you.
Little Geocoder takes in CSV files and geocodes them with the Census Bureau's Batch Geocoding service - all without knowing Python or using the command line!
It's more or less a very thin later on top of the LA Times' Census Batch Geocoder, with the addition of a few simple tools to help you break out street addresses and city names.
As a fun bonus, you don't need to upload your data into
Using Little Geocoder
You can download the latest release from GitHub - just pick the one that's appropriate for your system.
Browse...to select your file
- Pick your columns that contain address, city, state and zipcode (state and zipcode are optional)
- Click the
Geocodebutton and pick a destination for your new geocoded CSV
- Wait and wait and wait
- A brand-new CSV file shows up, full of latitudes and longitudes!
🎉 🎉 🎉
How long does it take?
It's a mystery to me, but it took a little under ten minutes for the 3000-row
schools.csv file, and a little over 1 minute for the 30-row
What platforms does it work on?
OS X and Windows, at the very least. It might work on Linux if you build it yourself.
Cleaning your data with "Adjustments"
The Census Bureau requires you do split
zipcode into separate fields. But what if your addresses aren't all in one column and look like this?
|Your House||540 NW Avenue, Townsville, NC|
|My House||101 Rock St, Apt 3, Guitar City, NV|
Oh no! Do we need to split it apart? Do we need to fight against that
Apt 3C? No! No! We're too lazy for that!
Little Geocoder has built-in data cleaning tools called Adjustments to make splitting long addresses up easy. You just pick an adjustment from a dropdown and it'll clip out the part you're interested in.
|540 NW Ave, Townsville, NC||101 Rock St, Apt 3, Guitar City, NV||Use as|
|Comma split: first section||540 NW Ave||101 Rock St||
|Comma split: second||Townsville||Apt 3||-|
|Comma split: third||NC||Guitar City||-|
|Comma split: second-to-last||Townsville||Guitar City||
|Comma split: last||NC||NV||
See, it's easy to pick out the parts you're interested in! You can also split on newlines/linebreaks if you want.
Have another kind of adjustment you'd like to see? Create an issue and I'll take a peek.
Help! I can't open it on OS X because my computer is scared of it!
Try to right-click (control+click) and select Open.
You can also go into
System Preferences > Security & Privacy and change Allow apps downloaded from: to be
App Store and identified developers. You might need to click the lock on the bottom-left corner of the window before it'll let you change anything.
Help! I'm building this app on my own and it's HUGE!
Anaconda on Windows installs versions of numpy & friends that include something called MKL. MKL is big. Anaconda doesn't play nice with
venv so the only way I could figure out to get around it was to just uninstall Anaconda and install everything from Python.org instead.