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



PostGIS in Action: (ed. #1) Chapter 7 - 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

In this chapter we cover using PostGIS/PostgreSQL command line and gui tools, OGR2OGR commandline, QuantumGIS Shapefile PostGIS import tool (SPIT), 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 and pgsql2shp. We demonstrate how to export in various formats: (KML,GPX, ESRI Shapefile, MapInfo)

In this chapter we briefly mention the shp2pgsqlgui packaged with PostGIS 1.4/1.5. You can get more details about how to integrate it in PgAdmin from Registering PostGIS Shapefile and DBF Gui loader in PgAdmin III or watch our screen cast Screen Cast: Installing PostGIS GUI in PgAdmin III and loading data

OpenStreetMap
OpenStreetMap

pgRouting: A Practical Guide is now available in Hardcopy from Hardcopy from Amazon. E-Book or Bulk discounts on Hard-copy from Locate Press.

PostGIS in Action,2nd edition MEAP    PostgreSQL: Up and Running       D3.js in Action 2nd Edition   PostGIS Cookbook Beginning Databases with PostgreSQL   
Node JS In Action, 2nd Edition