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 <http://earthexplorer.usgs.gov/>
_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
