PostGIS in Action (2nd)
Where the adventure begins
Translate:



PostGIS in Action: (ed. #2) Chapter 4 - Working with real data

1st Edition Chapters    PostGIS In Action 2nd Edition Chapters
Download chapter code and data

  • Tools for importing/exporting spatial data
  • Importing data from various file/types
First draft is complete and available on MEAP

In this chapter we cover using PostGIS/PostgreSQL command line and gui tools such as shp2pgsql, pgsql2shp and raster2pgsql, OGR2OGR commandline, OSM2PGSQL (OpenStreetMap XML to PostGIS) command line loader. We then provide exercises for downloading, commandline steps for importing in various formats of data with these tools.

The next section of the chapter covers exporting data out of PostGIS with OGR2OGR, GDAL tools such as gdal_translate and pgsql2shp. We demonstrate how to export in various formats: (KML,GPX, ESRI Shapefile, MapInfo, GTIF).

In this chapter we briefly mention the shp2pgsqlgui packaged with PostGIS 1.5+ and augmented in 2.0 to support data export and multi file import / export. You can get more details about how to integrate it in PgAdmin from Registering PostGIS Shapefile and DBF Gui loader in PgAdmin III

OpenStreetMap
OpenStreetMap

Stay tuned for our next book pgRouting: A Practical Guide published by Locate Press due out in hard-copy 4th quarter 2017. Content is now feature complete and can purchase e-Book draft and get final when goes to print.

PostGIS in Action,2nd edition MEAP      PostGIS Cookbook    PostgreSQL: Up and Running,2nd Edition    PostGIS 2 Análisis Espacial Avanzado (Spanish Edition)   
Node JS In Action, 2nd Edition    D3.js in Action