On Sat, Sep 4, 2010 at 10:36 PM, Shaun Langley <[email protected]> wrote: > I have loaded a bunch of TIFF files into my database, but now I have to > verify that all the pertinant metadata has been preserved. I want to > compare with the output from gdalinfo; however, only some of the data seems > to be accessible from within postgres. Is all the information there and I > just can't see it? Is there an easy way to generate a table formatted in > the same way as that generated by gdalinfo? > > Cheers, > Shaun
Hello Shaun, Metadata stored in WKT Raster are: upper left corner, width, height, pixel size, skew, srid and numbands. http://postgis.refractions.net/documentation/manual-svn/RT_ST_MetaData.html With other formats, you can use gdal_translate to add metadata to your raster by using "-co" option, but with PostGIS WKT Raster you can't, just now, for 2 reasons: - WKT Raster only keeps basic raster metadata (of course, you always can add new columns to a raster table, with additional information) - Even if WKT Raster could store more metadata, you can't use gdal_translate with "-co" option, because GDAL WKT Raster is a readonly driver, right now. I'm going to improve it in the next months. Best regards, -- Jorge Arévalo Internet & Mobilty Division, DEIMOS [email protected] http://mobility.grupodeimos.com/ http://gis4free.wordpress.com > -------------------------- > Shaun Langley > Graduate Student, PhD > Department of Geography > Michigan State University > Home: (517) 974-9346 > > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
