From 58b928ca9297cf537523ba58063ed8374c0ff7aa Mon Sep 17 00:00:00 2001 From: Regina Obe Date: Wed, 14 Dec 2011 02:54:17 +0000 Subject: [PATCH] Add stub section describing the raster_columns and raster_overview catalog views. Also fix typo. More coming. git-svn-id: http://svn.osgeo.org/postgis/trunk@8400 b70326c6-7e19-0410-871a-916f4a2858ee --- doc/using_raster_dataman.xml | 19 ++++++++++++++++--- 1 file changed, 16 insertions(+), 3 deletions(-) diff --git a/doc/using_raster_dataman.xml b/doc/using_raster_dataman.xml index 42e4d2e63..6971ba7ab 100644 --- a/doc/using_raster_dataman.xml +++ b/doc/using_raster_dataman.xml @@ -214,9 +214,22 @@ psql -d gisdb -f elev.sql raster2pgsql -s 4236 -I -C -M *.tif -F -t myschema.demelevation | psql -d gisdb - Load rasters Massachusetts state plane feet aerial tiles - 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. - raster2pgsql -I -C -Y -s 26986 -t 100x100 bostonaerials2008\*.jpg -l 2,4 aerials.boston | psql -U postgres -d gisdb -h localhost -p 5432 + Load rasters Massachusetts state plane meters aerial tiles + 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 bostonaerials2008\*.jpg -l 2,4 aerials.boston | psql -U postgres -d gisdb -h localhost -p 5432 + + Raster Catalog Views + There are two raster catalog views that come package with PostGIS. Both views utilize information embedded in the constraints of the raster tables. As a result + the catalog views are always consistent with the raster data in the tables since the constraints are enforced. + + + raster_columns this view catalogs all the raster tables in your database. + + + raster_overviews this view catalogs all the rasters tables in your database that server as overviews for a finer grained table. Tables of this type are generated when you use the -l switch during load. + + + -- 2.49.0