Some notes and refs about a possible raster-in-db implementation == References == * [http://www.gdal.org CHIP driver for GDAL] - Contains the PGCHIP driver, recently fixed to avoid use of reserved CHIP fields. Can be used to import and export grayscale, single band, 8 and 16 bpp rasters. * [http://portal.opengeospatial.org/files/?artifact_id=6628 OpenGIS Grid Coverage Service Implementation Specification] * [http://www.gdal.org/gdal_drivertut.html GDAL Driver implementation tutorial] - for pgchip fixes or new work. * [http://download.oracle.com/docs/pdf/B10827_01.pdf Oracle GeoRaster] for example of a raster database API (requires authentication) * [http://www.oracle.com/technology/products/spatial/pdf/10gr2_collateral/spatial_twp_georaster_10gr2.pdf Oracle Database 10g, Managing Spatial Raster Data Using GeoRaster—Technical White Paper (PDF)] - no authentication required * [http://www.varlena.com/GeneralBits/44.php Smart BLOBS on General Bits] - Contains tips on how to wrap large_objects into custom datatypes. == PostGIS WKT Raster == * [wiki:WKTRaster Pierre Racine's proposal] - and related thread [http://postgis.refractions.net/pipermail/postgis-users/2008-December/022076.html http://postgis.refractions.net/pipermail/postgis-users/2008-December/022076.html] == PGRaster == * [wiki:UsersWikiPgRasterDesign PGRaster design document] * [http://code.google.com/p/google-summer-of-code-2007-osgeo/downloads/detail?name=Xing_Lin.tar.gz geotiff2pgraster] (PGRaster) at Google Summer of Code 2007 * [http://svn.refractions.net/postgis/branches/gSoC2007_raster/ Code Branch] == Discussions about raster integration on the postgis-users list (with number of post). == (*) denotes important threads. * [http://postgis.refractions.net/pipermail/postgis-users/2008-December/022075.html 04 December 2008 - PostGIS WKT Raster call for funding] (5*) * [http://postgis.refractions.net/pipermail/postgis-users/2008-July/020486.html 07 July 2008 - PostGIS WKT Raster] (10*) * [http://postgis.refractions.net/pipermail/postgis-users/2008-March/018760.html 08 March 2008 - Raster suggestions?] (7) * [http://postgis.refractions.net/pipermail/postgis-users/2007-December/017891.html 05 December 2007 - Storing raster data in postgis?] (4) * [http://postgis.refractions.net/pipermail/postgis-users/2007-November/017833.html 28 November 2007 - Raster data] (2) * [http://postgis.refractions.net/pipermail/postgis-users/2007-October/017288.html 07 October 2007 - Raster Data Problem] (3) * [http://postgis.refractions.net/pipermail/postgis-users/2007-October/017232.html 02 October 2007 - indexing images stored in PostGres] (10*) * [http://postgis.refractions.net/pipermail/postgis-users/2007-September/017188.html 26 Septembre 2007 - Raster in databases ?] (2) * [http://postgis.refractions.net/pipermail/postgis-users/2007-August/016719.html 16 August 2007 - import of Raster data] (6*) * [http://postgis.refractions.net/pipermail/postgis-devel/2007-July/002652.html 11 July 2007 - Xing Lin's SoC project (raster support)] (19*) * [http://postgis.refractions.net/pipermail/postgis-users/2007-May/015573.html 07 May 2007 - raster] (4) * [http://postgis.refractions.net/pipermail/postgis-users/2007-February/014811.html 20 February 2007 - satellite data (MODIS) into PostgreSQL - PostGIS database as points or grids?] (4) * [http://postgis.refractions.net/pipermail/postgis-users/2007-February/014732.html 14 February 2007 - Need help to load data in PostGIS] (8) * [http://postgis.refractions.net/pipermail/postgis-users/2006-December/014059.html 05 December 2006 - Proposed SQL interface for PGRaster] (25*) * [http://postgis.refractions.net/pipermail/postgis-users/2006-October/013628.html 26 October 2006 - Raster in DB] (5) * [http://postgis.refractions.net/pipermail/postgis-users/2006-October/013577.html 24 October 2006 - A PostGIS-Raster data proposal] (30*) * [http://postgis.refractions.net/pipermail/postgis-users/2006-August/012928.html 17 August 2006 - Raster Support...] (25*) * [http://postgis.refractions.net/pipermail/postgis-users/2006-July/012540.html 03 July 2006 - Raster images] (2) * [http://postgis.refractions.net/pipermail/postgis-users/2006-May/012274.html 31 May 2006 - PgChip] (1) * [http://postgis.refractions.net/pipermail/postgis-users/2006-April/011899.html 24 April 2006 - Roadmap for raster support in PostGIS] (1) * [http://postgis.refractions.net/pipermail/postgis-users/2006-March/011536.html 22 March 2006 - help in storing tif file] (6) * [http://postgis.refractions.net/pipermail/postgis-users/2005-October/009634.html 15 October 2005 - Rasters (once more)] (6) * [http://postgis.refractions.net/pipermail/postgis-users/2005-September/009468.html 30 September 2005 - Rasters - fields] (2) * [http://postgis.refractions.net/pipermail/postgis-users/2005-September/009445.html 29 September 2005 - Rasters] (12) * [http://postgis.refractions.net/pipermail/postgis-users/2005-September/009444.html 29 September 2005 - rasters in PostGIS...] (15) * [http://postgis.refractions.net/pipermail/postgis-users/2005-September/009397.html 24 September 2005 - when rasters in Postgis?] (19) * [http://postgis.refractions.net/pipermail/postgis-users/2005-September/009222.html 12 September 2005 - adding raster caps to postgis] (3) * [http://postgis.refractions.net/pipermail/postgis-users/2005-July/008742.html 23 July 2005 - bring PostGIS into the raster world] (2) * [http://postgis.refractions.net/pipermail/postgis-users/2005-April/007843.html 28 April 2005 - How to access raster data?] (3) * [http://postgis.refractions.net/pipermail/postgis-users/2005-April/007700.html 15 April 2005 - Support for Raster Data] (3) * [http://postgis.refractions.net/pipermail/postgis-users/2005-January/006709.html 25 January 2005 - raster chip] (1) * [http://postgis.refractions.net/pipermail/postgis-users/2005-December/010344.html 16 December 2005 - pgchip] (1) * [http://postgis.refractions.net/pipermail/postgis-users/2004-March/004417.html 25 March 2004 - spatial analysis of raster data from postgis] (2) * [http://postgis.refractions.net/pipermail/postgis-users/2003-July/002703.html 07 July 2003 - Insert data larger than 1 Gig...] (3) * [http://postgis.refractions.net/pipermail/postgis-users/2003-May/002437.html 08 May 2003 - POSTGIS DTED...] (9) * [http://postgis.refractions.net/pipermail/postgis-users/2003-March/002179.html 10 March 2003 - Raster data] (5) * [http://postgis.refractions.net/pipermail/postgis-users/2002-May/000960.html 08 May 2002 - General Question on Raster within PostGIS] (5) In the GDAL list * [http://lists.osgeo.org/pipermail/gdal-dev/2006-February/007870.html 03 February 2006 - PostGIS CHIP Support - Tiled Pyramids?] (1) * [http://lists.osgeo.org/pipermail/gdal-dev/2005-August/006310.html 30 August 2005 - GDAL Postgis Raster Driver] (4)