I have two multiband raster files and i'm trying to load these data into PostGIS using "raster2pgsql". Here is the syntax that i used:
raster2pgsql -c -s 4326 -I -t 100x100 *.tif public.deforested_rasters | psql -d r342471958 It works without error, but i don't know if the command loads correctly both raster files. The database in PostGIS has two columns, one with the spatial index and the other one with raster information. I'm trying to visualize the resultant database in QGIS, but for some reason it doesn't open the raster layer. I've tried to solve this problem using this idea: https://duncanjg.wordpress.com/2012/11/20/the-basics-of-postgis-raster/, transforming the raster data to geometry data through DB manager using this command: select rid,rast::geometry from deforested_rasters but when visualized in QGIS, only returns a rectangular area without the original characteristics. Any ideas of how can i confirm that the "raster2pgsql" command loads correctly the raster files? Or a different way to load these data into PostGIS? The raster files are available in:https://www.dropbox.com/sh/nu8nl6cigv8viz1/AADTrr_w8SCstDHOu6AiGeJta?dl=0 Thanks, Roberto
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
