Moving Data In and Out of PostGIS

In this chapter, we will cover:

  • Importing nonspatial tabular data (CSV) using PostGIS functions
  • Importing nonspatial tabular data (CSV) using GDAL
  • Importing shapefiles with shp2pgsql
  • Importing and exporting data with the ogr2ogr GDAL command
  • Handling batch importing and exporting of datasets
  • Exporting data to a shapefile with the pgsql2shp PostGIS command
  • Importing OpenStreetMap data with the osm2pgsql command
  • Importing raster data with the raster2pgsql PostGIS command
  • Importing multiple rasters at a time
  • Exporting rasters with the gdal_translate and gdalwarp GDAL commands

Get PostGIS Cookbook - Second Edition now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.