From eb9326918ee51fcc786c0c936d97450b0793b90b Mon Sep 17 00:00:00 2001 From: Regina Obe Date: Sun, 18 Dec 2011 18:05:01 +0000 Subject: [PATCH] add in some missing raster2pgsql switches and provide an example of the -G list drivers option. git-svn-id: http://svn.osgeo.org/postgis/trunk@8453 b70326c6-7e19-0410-871a-916f4a2858ee --- doc/using_raster_dataman.xml | 160 ++++++++++++++++++++++++++++++++--- 1 file changed, 148 insertions(+), 12 deletions(-) diff --git a/doc/using_raster_dataman.xml b/doc/using_raster_dataman.xml index b969fdee0..e311ada82 100644 --- a/doc/using_raster_dataman.xml +++ b/doc/using_raster_dataman.xml @@ -11,8 +11,7 @@ The raster2pgsql is a raster loader executable that loads GDAL supported raster formats into sql suitable for loading into a PostGIS raster table. It is capable of loading folders of raster files as well as creating overviews of rasters. Since the raster2pgsql is compiled as part of PostGIS most often (unless you compile your own GDAL library), the raster types supported - by the executable will be the same as those compiled in the GDAL dependency library. To get a list of raster types your particular PostGIS install - supports, refer to . + by the executable will be the same as those compiled in the GDAL dependency library. To get a list of raster types your particular raster2pgsql supports use the -G switch. These should be the same as those provided by your PostGIS install documented here if you are using the same gdal library for both. The older version of this tool was a python script. The executable has replaced the python script. If you still find the need for the Python script Examples of the pyhton one can be found at GDAL PostGIS Raster Driver Usage @@ -31,6 +30,15 @@ + + -G + + + Print the supported GDAL raster formats. + + + + (c|a|d) These are mutually exclusive options: @@ -67,19 +75,44 @@ - + + Raster processing: Applying contraints for proper registering in raster catalogs + + + + + -C + + + Apply raster constraints -- srid, pixelsize etc. to ensure raster is properly registered in raster_columns view. + + + + + -x + + + Disable setting the max extent constraint. Only applied if -C flag is also used. + + + + + -r + + + Set the regular blocking constraint. Only applied if -C flag is also used. + + + + + + + + + Raster processing: Optional parameters used to manipulate input raster dataset - - - -C - - - Apply raster constraints -- srid, pixelsize etc. to ensure raster is properly registered in raster_columns view. - - - -s <SRID> @@ -223,6 +256,109 @@ psql -d gisdb -f elev.sql into a schema called aerial and create a full view, 2 and 4 level overview tables and directly insert to database. Break up the rasters into 100x100 pixel tiles and apply raster constraints. Use copy mode instead of table insert. (-F) Include a field called filename to hold the name of the file the tiles were cut from. raster2pgsql -I -C -Y -F -s 26986 -t 100x100 -l 2,4 bostonaerials2008\*.jpg aerials.boston | psql -U postgres -d gisdb -h localhost -p 5432 + --get a list of raster types supported: +raster2pgsql -G + +The -G commands outputs a list something like + +Available GDAL raster formats: + Virtual Raster + GeoTIFF + National Imagery Transmission Format + Raster Product Format TOC format + ECRG TOC format + Erdas Imagine Images (.img) + CEOS SAR Image + CEOS Image + JAXA PALSAR Product Reader (Level 1.1/1.5) + Ground-based SAR Applications Testbed File Format (.gff) + ELAS + Arc/Info Binary Grid + Arc/Info ASCII Grid + GRASS ASCII Grid + SDTS Raster + DTED Elevation Raster + Portable Network Graphics + JPEG JFIF + In Memory Raster + Japanese DEM (.mem) + Graphics Interchange Format (.gif) + Graphics Interchange Format (.gif) + Envisat Image Format + Maptech BSB Nautical Charts + X11 PixMap Format + MS Windows Device Independent Bitmap + SPOT DIMAP + AirSAR Polarimetric Image + RadarSat 2 XML Product + PCIDSK Database File + PCRaster Raster File + ILWIS Raster Map + SGI Image File Format 1.0 + SRTMHGT File Format + Leveller heightfield + Terragen heightfield + USGS Astrogeology ISIS cube (Version 3) + USGS Astrogeology ISIS cube (Version 2) + NASA Planetary Data System + EarthWatch .TIL + ERMapper .ers Labelled + NOAA Polar Orbiter Level 1b Data Set + FIT Image + GRIdded Binary (.grb) + Raster Matrix Format + EUMETSAT Archive native (.nat) + Idrisi Raster A.1 + Intergraph Raster + Golden Software ASCII Grid (.grd) + Golden Software Binary Grid (.grd) + Golden Software 7 Binary Grid (.grd) + COSAR Annotated Binary Matrix (TerraSAR-X) + TerraSAR-X Product + DRDC COASP SAR Processor Raster + R Object Data Store + Portable Pixmap Format (netpbm) + USGS DOQ (Old Style) + USGS DOQ (New Style) + ENVI .hdr Labelled + ESRI .hdr Labelled + Generic Binary (.hdr Labelled) + PCI .aux Labelled + Vexcel MFF Raster + Vexcel MFF2 (HKV) Raster + Fuji BAS Scanner Image + GSC Geogrid + EOSAT FAST Format + VTP .bt (Binary Terrain) 1.3 Format + Erdas .LAN/.GIS + Convair PolGASP + Image Data and Analysis + NLAPS Data Format + Erdas Imagine Raw + DIPEx + FARSITE v.4 Landscape File (.lcp) + NOAA Vertical Datum .GTX + NADCON .los/.las Datum Grid Shift + NTv2 Datum Grid Shift + ACE2 + Snow Data Assimilation System + Swedish Grid RIK (.rik) + USGS Optional ASCII DEM (and CDED) + GeoSoft Grid Exchange Format + Northwood Numeric Grid Format .grd/.tab + Northwood Classified Grid Format .grc/.tab + ARC Digitized Raster Graphics + Standard Raster Product (ASRP/USRP) + Magellan topo (.blx) + SAGA GIS Binary Grid (.sdat) + Kml Super Overlay + ASCII Gridded XYZ + HF2/HFZ heightfield raster + OziExplorer Image File + USGS LULC Composite Theme Grid + Arc/Info Export E00 GRID + ZMap Plus Grid + NOAA NGS Geoid Height Grids Creating rasters using PostGIS raster functions -- 2.40.0