pgraster2geotiff(1)                 PostGIS                  pgraster2geotiff(1)



NAME
       	pgraster2geotiff - postgis/pgraster to geotiff exporter


SYNTAX
       	pgraster2geotiff [options] [schema.]table [geotiff-file]


DESCRIPTION
       	The pgraster2geotiff data exporter converts a table of  PostGIS/PGRaster 
       	database directly into GeoTIFF(georeferenced image).

       	Version: 0.0.1 (2007/08/22)

REFERENCE
	This programe  learn  some  of  its  functionality  from  these   similar 
	programs:

	   1. psql - standard PostgreSQL client programe
	   2. shp2pgsql/pgsql2shp - PostGIS loader programmes for  Shape   files.
	   3. GDAL GeoTIFF - geotiff reader for GDAL programe.


USAGE
       	The <table> is the(optionally  schema-qualified) name  of  the   database 
       	table the data is being stored in in the database. 

       	The <geotiff-file> is the pathname of the geotiff file where the  geotiff
       	will be saved to. You can specify a full path for the desitinate  geotiff
       	file. Otherwise this program will use the table name as the filename  and
       	save the geotiff file in current fold(e.g. PWD).

	For examples:
	   pgraster2geotiff [options...] us_tm19900710 ~/us_tm19900710.tif
	   
	Then the us_tm19900710 pgraster table in PostGIS/PGRaster database   will
 	be exported into the geotiff file named us_tm19900710.tif in  the    home
	directory.

	(TO BE CONTINUE...)

OPTIONS
       The  loader  has  several operating modes  distinguished  by  command  line
       flags:

	   #######################  (NOT SUPPORTED YET)  #########################
	   (Note that -a, -c, -d and -p are mutually exclusive.)

	   -d     Drops the database table before creating a new  table  with  the
                  data in the geotiff file. 
	   
 	   -a     Appends  data  from the geotiff file into the existing database 
	          table. Although it is not recommended to store raw data of sever
		  ral raster dataset into one raster data table (sharing). But if 
		  you insist, you can do it by this option.
	  
	   -c     Creates a new table and populates it from the geotiff file. This
                  is the default mode.

       	   -p     Only produces the table creation SQL code,  without  adding  any
                  actual  data.   This can be used if you need to completely sepa-
                  rate the table creation and data loading steps.
		  (NOT SUPPORTED YET)

       	   -D     Use the PostgreSQL "dump" format for the output data.  This  can
                  be  combined  with -a, -c and -d. It is much faster to load than
                  the default "insert" SQL format. Use this for  very  large  data
                  sets. If this option is set, then the following options could be
	          ignored.	   

	   #######################  (NOT SUPPORTED YET)  #########################

	   -h <host>
                  The database host to connect to. If ignored, the default address
		  of host will be "localhost/127.0.0.1". If no database running on
		  this host, the program will exit immediately with a error msg.

           -p <port>
               	  The port  to connect to  on the  database  host. If ignored, the
		  standard port number of 5432 will be used.If no database running
		  on this port, the program will exit immediately with a error msg.

	   -d <database>
	   	  The database to use when connecting. If ignored, the current  OS
		  username will be used the name of database to login into. If this 
		  database is refused to login, the program will exit immediately 
		  with a error message.

       	   -P <password>
                  The password to use when connecting to the database. This option
		  can't be ignored. If this password is refused to login, the pro-
		  gram will exit immediately with a error message.

           -u <user>
                  The username to use when connecting to the database. If ignored,
		  the current OS username will be used to login into the database.
		  If this username  is  refused to login, the  program  will  exit 
		  immediately with a error message.
		
           -k     Keep idendifiers case (don't uppercase field names).				

           -q/-v  Work in quite mode/Work in verbose mode

           -?/--help	
	          Display version and usage information.

INSTALLATION

       To compile the program from source, simply run   "make"   in   the   source
       directory.  Then copy the binary in your shell  search  path ( or  wherever
       you like). This text is also available as  a man  page in  the  ../doc/man/
       directory,  ready for copying it into the manual  search  path  on  unixoid
       systems. 
		
       You might also need to change the Makefile script file to  specified  where 
       you save/install your GeoTIFF library and PostgreSQL database/lib.


EXAMPLES
       
       An example session using the export to export an data table  and  export it 
       to local geotiff file. The sample might look like this:

       # pgraster2geotiff -d pgraster -h localhost -p 5432 -u postgres 
			  -P "password" public.us_tm1990 
			  "~/us_images/us_tm1990.tiff" -q

AUTHORS

       Originally written and maintained by Xing Lin <solo.lin@gmail.com>.
       
SEE ALSO
       
       geotiff2pgraster(1)
	
       More information is available at http://postgis.refractions.net
       Any problem with this programe, do contact xing <solo.lin@gmail.com>.



                                                                pgraster2geotiff(1)