geocode-csv: Geocode a CSV file using the SmartyStreets API

(This project is not associated with SmartyStreets.)

WARNING: This project geocodes CSV files thousands of rows per second, which can use up your SmartyStreets quota very quickly. This may cost you money.

If you have a CSV file that appears as follows:

csv name,street1,street2,city,state,zip Resident,1600 Pennsylvania Avenue NW,,Washington DC,20500

...and an address_spec.json file that appears as follows:

json { "geocoded": { "street": ["street1", "street2"], "city": "city", "state": "state", "zipcode": "zip" } }

...then you can geocode it using:

```sh

Set up credentials.

export SMARTYSTREETSAUTHID=... export SMARTYSTREETSAUTHTOKEN=...

Geocode the CSV.

geocode-csv --spec address_spec.json < in.csv > out.csv ```

This will add a series of columns starting with geocoded_, which will contain various postal delivery information, plus estimated latitude and longitude. If geocoding succeeds, geocode-csv will return 0. If it fails, it will return a non-zero error code and print a human-readable error message to standard error.

You can geocode multiple addresses per row as follows:

json { "geocoded_shipping": { /* ... */ }, "geocoded_billing": { /* ... */ } }

This will insert two sets of columns, one beginning with geocoded_shipping_ and the other with geocoded_billing_.