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

Geospatial CSV Imports Hidden Complexity

Sponsored · SiteGround - Reliable hosting with speed, security, and support you can count on. →
Kartones
October 27, 2015

Geospatial CSV Imports Hidden Complexity

@ Mindcamp 7.0 2015, Madrid

Kartones

October 27, 2015

Transcript

18 slides
  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

More Decks by Kartones

Other Decks in Programming