That did the trick, thanks.
On 6/15/2011 9:51 AM, Pierre Racine wrote:
If you imported all of your rasters with one raster2pgsql command the "extent" column in
the "raster_column" table should correspond to the global extent.
If you imported with many commands, added or deleted tiles afterward, "extent"
is not up to date.
You can play with the ST_Extent aggregate.
SELECT ST_Extent(rast)
FROM your table
That would be the preferred way to get an uptodate extent. If it's slow, create
an index on your raster column.
Pierre
-----Original Message-----
From: [email protected] [mailto:postgis-users-
[email protected]] On Behalf Of Stephen Crawford
Sent: Tuesday, June 14, 2011 7:04 PM
To: PostGIS Users Discussion
Subject: [postgis-users] raster table extent
Is there a function that can provide the extent for an entire raster table? I
see
there is BOX2D for each raster in a table, but how about the entire table?
Basically I think I loaded my raster in a way that the extent isn't where it
should
be, but I'm having trouble proving it.
Thanks,
Steve
_______________________________________________
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
--
Stephen Crawford
Center for Environmental Informatics
The Pennsylvania State University
[email protected]
814.865.9905
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
