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

8
votes
1answer
435 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
1answer
36 views

How to speed up raster2pgsql?

I'm trying to upload a 37 GB raster dataset to PostGIS. The raster is out-of-db (-R option), so the actual pixel values are not stored in PostGIS. I'm using this command: raster2pgsql -s 25833 -C -I ...
1
vote
1answer
98 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
55 views

Clipping raster with Postgis raster

I'm using Postgis 2.1.5 on Ubuntu 15.04. In my system there is a second disk mounted with the raster data as /media/name1/data/rasters/*.tif. The *.tif are good looking when I watch the metadata with ...
1
vote
0answers
54 views

raster2pgsql stops at line 53 at RETURN

I am importing some very large rasters (in the tif format) into Postgres SQL (9.3) using raster2pgsql on the command line. Most of the rasters imported fine, some had to be converted to the img format ...
1
vote
0answers
131 views

raster2pgsql error

I am attempting load ~500 rasters in a PostGIS table. They are .Hdr/.dat files. I am using raster2pgsql. I am able to load the first 260 rasters, but the remaining rasters fail with the following ...
1
vote
0answers
2k 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
27 views

Raster2PGSql - Naming Issues

I'm using Python to execute Raster2PGSql on a number of GeoTiffs in a directory. I'd like the resulting tables to be named after each file, but currently I can only get DB Manager in QGIS to ...
0
votes
0answers
88 views

Problems with serving PostGIS Raster and Geoserver

i have the following problem: i serve raster tiles (jpg / png), loaded into PostgreSQL/PostGIS with raster2pgsql, with Geoserver imagemosaic-jdbc plug-in. Which is working, but from the 25 GB file ...
0
votes
0answers
39 views

How to share constraints between tables in a PostGIS database?

I have a PostGIS (v2.1) database that contains several tables, each representing a raster that I loaded by calling raster2pgsql. I'd like to ensure that the rasters contained by these tables have the ...
0
votes
0answers
237 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
391 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
235 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, ...