To import raster data into PostGIS as raster type one has to use gdal2wktraster.py which uses GDAL. To export PostGIS raster type it's GDAL too.
=> What's now the current and future state of the art for importing/exporting PostGIS Raster? There are two sentences in the PostGIS book regarding this (chap. 13.3.2, page 409: "Currently GDAL PostGIS WKT Raster can only read PostGIS raster data type and export to other raster formats." and chap. 13.9.1, page 437: "Currently the PostGIS WKT Raster GDAL driver can only export to other raster formats." To me it's as follows: For importing there's GDAL and gdal2wktraster. gdal2wktraster takes any GDAL supported raster format as input and writes SQL (in PostGIS Raster WKT syntax) - similar how shp2pgsql functions for vector formats. gdal2wktraster is a Python script which uses GDAL and the "GDAL PostGIS WKT Raster driver". Since many API tools build on top of GDAL, these tools are already capable of using PostGIS raster data (input) if their GDAL library is compiled with PostGIS WKT Raster support. => Correct? What would be a better import (embedded SQL command? An .exe/.so program like raster2pgsql without GDAL)? Regarding export - meaning exporting from a Postgres table containing PostGIS raster attribute - to any raster format, it's unclear to me: First, there's gdal_translate (given GDAL and the above mentioned driver is installed). => Correct? What would be a better export (embedded SQL command? An .exe/.so program like pgsql2raster)? => What is the relationship and status of the project PGCHIP (http://simon.benjamin.free.fr/pgchip/ )? Yours, S. _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
