Data -> Map. The Good Parts.

Spatial data manipulation!

Cleaning

Normalizing

Formatting

File formats

• Shapefile (shp)
• Keyhole Markup Language (kml)
• GeoJSON (geojson)
• Comma Separated Values (csv)
• Geodatabase (gbd)

• Portable Document Format (pdf)
• Excel (xls)
• [Application Programming Interfaces (APIs)]

Clean & Compact

Toolbox

Command line doesn't bite

A note on open...

Example #1: Reproject

Senate districts 2013

NAD 1983 StatePlane Kentucky Statewide (2001) FIPS 1600

wtf?

ogr2ogr senate_4326.shp -t_srs "EPSG:4326" SH001A02.shp

ogr2ogr -f "GeoJSON" senate.geojson -t_srs "EPSG:4326" SH001A02.shp

Example #2: Join Attributes

Natural Earth Admin 1 States 110m

State diabetes estimates (CDC)

ogr2ogr -sql "select ne_110m_admin_1_states_provinces.*, diabetes_2012.* from ne_110m_admin_1_states_provinces left join 'diabetes_2012.csv'.diabetes_2012 on ne_110m_admin_1_states_provinces.name = diabetes_2012.state" diabetes.shp ne_110m_admin_1_states_provinces.shp

mapshaper.org

Example #4: Lexington restaurants

Thanks!