[postgis-users] raster table extent

[Stephen Crawford]

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: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-
>> bounces at postgis.refractions.net] 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
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-- 
Stephen Crawford
Center for Environmental Informatics
The Pennsylvania State University
src176 at psu.edu
814.865.9905