The raster2pgsql is a raster loader executable that loads GDAL supported raster formats into sql suitable for loading into a PostGIS raster table.

learn more… | top users | synonyms

0
votes
3answers
313 views

Import DEM into PostGIS for QGIS

I'm a complete GIS newbie so sorry if I'm using the wrong terminology in searching for a solution to this... I'm trying to import a DEM into PostGIS and display it in QGIS. The data is from the EU-DEM ...
1
vote
1answer
22 views

PostGIS raster2pgsql problem

I ran into this problem in PostGIS: raster2pgsql -c -I -C -s 4326 -N -9999 -M -Y -F ./test2/*.tif rdem2 > rdem2.sql Processing 84/84: ./test2/dem2_4326_06_14.tif ERROR: ...
3
votes
0answers
225 views

How to fix “Raster layer: Provider is not valid” error when loading PostGIS rasters?

I compiled and installed the current QGIS master as usual and I imported some raster data into my postgres 9.3 database with postgis 2.0.2 extension. Whenever I try to import the raster data into qgis ...
1
vote
0answers
1k views

“Schema does not exist” error trying to load raster using raster2pgsql

I receive a "schema does not exist" error when trying to load a raster to a PostGIS database (see full error at the bottom). The schema does exist in the database. This is the syntax I'm using: ...
0
votes
0answers
52 views

Problem to visualize raster data from PostGIS in QGIS

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 ...
0
votes
0answers
167 views

numeric issue while loading floating point-valued GeoTIFF into PostGIS

I am trying to import a floating point GeoTIFF image into PostGIS (2.1), using the following command: raster2pgsql -s 4326 -I -M -F -C tif_dir/*.tif public.map | psql -U postgres -h localhost -d ...
0
votes
0answers
92 views

Find correct SRID

I'm learning PostGIS raster, and importing GeoTiff with raster2pgsql. This command line tool states: -s <srid> Set the raster's SRID. Defaults to 0. If SRID not provided or is 0, ...
0
votes
0answers
73 views

uploading raster format tif to postgis through raster2pgsql

I have the same problem Uploading raster format(*.tif) to postgis through raster2pgsql How to you fix it, if it is a problem? Because my raster column is empty. Of if it's ok, what does it mean? ...