We'll need a bit more info before any viable advice can be given. How big is that polygon for the overlaps? Any error messages in the postgresql logs? Is there just one date's scenes in the table or is it longitudinal?
-bborie On Mar 17, 2014 9:16 AM, "Jackie" <[email protected]> wrote: > Hi PostGIS users, > I have a PostGIS database, which stores raster from Landsat 8. Each scene > was divided with tile-size 500x500. Then each row in database will keep 1 > tile with 11 bands (except band No. 8). > I'm trying to ST_Union() about 1179 raster-tiles with 3 bands (2,3,4) and > pgAdminIII shows a window said "Connection lost - Try to reconnect > database"; > Here's my query: > SELECT ST_Union(rast, ARRAY[ROW(2,'LAST'),ROW(3,'LAST'),ROW(4,'LAST')]:: > unionarg[]) > FROM landsat8 > WHERE ST_Overlaps(polygon, rast_geom_4326) > > I'm using PostGIS 2.1, my raster is retrieved from earthexplorer.usgs.gov > > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
