Hi Pierre,
this postgis databases are defect with raster import:
1. POSTGIS=2.1.5 r13152 GEOS=3.4.2-CAPI-1.8.2 r3921 PROJ=Rel.
4.8.0, 6 March 2012 GDAL=GDAL 1.9.2, released 2012/10/08
LIBXML=2.7.8 LIBJSON=UNKNOWN TOPOLOGY RASTER
with pg 9.4 on ubuntu 12.04
raster2pgsql: RELEASE: 2.1.5
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
Hello,
To display raster data, you can try ST_DumpAsPolygons into Arcgis or OpenJump
(if it is just a test, you could add a where clause on tile id).
WITH a AS (select ST_DumpAsPolygons(rast) AS mydump from deforested_areas
–where rid = 1)
SELECT (mydump).val, (mydump).geom FROM a
Hey,
I would recommand gdalinfo.
You may need a recent gdal to properly display raster in QGIS (with a
recent QGIS version also)
Cheers,
Rémi-C
2015-03-31 16:05 GMT+02:00 Hugues François hugues.franc...@irstea.fr:
Hello,
To display raster data, you can try ST_DumpAsPolygons into Arcgis or
Just
SELECT (ST_DumpAsPolygons(rast)).*
FROM deforested_areas
-–WHERE rid = 1
-Original Message-
From: postgis-users-boun...@lists.osgeo.org [mailto:postgis-users-
boun...@lists.osgeo.org] On Behalf Of Hugues François
Sent: Tuesday, March 31, 2015 10:05 AM
To: PostGIS Users