Database Reference
In-Depth Information
Chapter 1. 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 the 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 com-
mands
Introduction
Inthischapter,wewillshowyouasetofrecipescoveringdifferenttoolsandmethod-
ologies to import and export geographic data from the PostGIS spatial database.