Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Geospatial CSV Imports Hidden Complexity

Kartones
October 27, 2015

Geospatial CSV Imports Hidden Complexity

@ Mindcamp 7.0 2015, Madrid

Kartones

October 27, 2015
Tweet

More Decks by Kartones

Other Decks in Programming

Transcript

  1. @Kartones WKT: Well-Known Text POINT (30 10) LINESTRING (30 10,

    10 30, 40 40) POLYGON ((30 10, 40 40, 20 40, 10 20, 30 10)) MULTIPOINT ((10 40), (40 30), (20 20), (30 10)) MULTIPOLYGON (((30 20, 45 40, 10 40, 30 20)), ((15 5, 40 10, 10 20, 5 10, 15 5))) https://en.wikipedia.org/wiki/Well-known_text
  2. @Kartones GeoJSON { "type": "Feature", "geometry": { "type": "Point", "coordinates":

    [125.6, 10.1] }, "properties": { "name": "Dinagat Islands" } } http://geojson.org/
  3. @Kartones DB-Specific Leave DB indexes as last step Prefer big

    INSERT to multiple UPDATE GDAL’s ogr2ogr > Ruby/Python scripts http://www.gdal.org/ogr2ogr.html