almost forgot: PostGIS 2.0.1, on PG 9.1.4. PPC OS X. On Aug 23, 2012, at 8:46 AM, William Kyngesburye wrote:
> I created a raster table for a large area of DEM data, with index and > constraints, no overviews. When I run gdalinfo on the table, it takes about > 15m to query to get the extents, which are then wrong. > > Original 32bit float geotiffs = 27GiB (uncompressed), 84W, 36N to 71W, 45.5N > (not complete coverage) > > In PostGIS = 25GiB, 74W, 33.5N to 61W, 43N > > There are 15936 records in the table, which matches the number of input TIFFs > and the tile size I used (actually 22 more than the input), so it looks like > all the data was imported. > > It looks like the data was shifted 10 deg east and 2.5 deg south. > > When I try to extract a region from that with gdal_translate, it takes the > 15m to check the extants again, then extracts garbage. > > I'm just getting started with PG rasters and don't know enough about the SQL > needed to check within PG if everything is OK there or not (extents, extract > some data to tif) or if it's a GDAL problem. > > A GDAL vrt of the geotiffs processes quickly and reports the correct extents. > > ----- > William Kyngesburye <kyngchaos*at*kyngchaos*dot*com> > http://www.kyngchaos.com/ > > "Time is an illusion - lunchtime doubly so." > > - Ford Prefect > > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users ----- William Kyngesburye <kyngchaos*at*kyngchaos*dot*com> http://www.kyngchaos.com/ "I ache, therefore I am. Or in my case - I am, therefore I ache." - Marvin _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users