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

1
vote
1answer
26 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: ...
1
vote
1answer
42 views

How to get pixel values/cell values for stored raster files in postgis?

Raster files in tiff format are storing into database.However I gets only an attribute table. Is there any way to retrieve pixel values/cell values in the table. I have used raster2pgsql command for ...
0
votes
0answers
54 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
169 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
96 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? ...
1
vote
1answer
149 views

raster2pgsql does nothing

I try to load rasters through raster2pgsql. I try to call it through pgAdmin command line, but when I call any raster2pgsql command (even raster2pgsql -G), it does nothing, I just get another line to ...
2
votes
1answer
468 views

How to load image tiff to postgresql without use raster2pgsql

I can loading raster data by raster2pgsql. But i don't want use command line. I want build a desktop application. I want use C# or Java or matlab to loading raster data without use raster2pgsql. Can ...
0
votes
3answers
325 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 ...
3
votes
0answers
229 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
250 views

Postgis 2.1.1 compilation issue

Hi I tried to compile postgis-2.1.1 in RedHat 6.3 with: # ./configure --with-pgconfig=/usr/local/pgsql/bin/pg_config --with-gdalconfig=/usr/local/bin/gdal-config ...
2
votes
1answer
214 views

Cannot upload an IMG file into PostGIS using raster2pgsql

I cannot upload into PostGIS a raster with the following code: raster2pgsql -s 4326 -I -C -M "C:\lyr\gebco.img" -F public.gebco ¦ psql -d test -U postgres -W It says ERROR: Unable to read raster ...
2
votes
1answer
128 views

How to change table name of command raster2pgsql

I am completely newbie with GIS and PostGIS as well I'm trying to load raster into postgreSQL with raster2pgsql. It runs well. However, the table name of the raster is generated automatically. For ...
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: ...
1
vote
1answer
199 views

Can't view PostGIS rasters after changing schemas

I have loaded a few rasters into the Public schema of a PostGIS 2.0 database. Using the db manager in QGIS 1.8.0 I can add the rasters to the map canvas. After moving the rasters to another schema in ...
4
votes
3answers
816 views

Loading raster data to postgis

I'm a newbie in GIS technology and need some help in loading a rainfall radar raster data into PostGIS. The raster image is shown here: What I need is to store in the database the radar ...
6
votes
1answer
3k views

How to import GeoTIFF via postGIS into GeoServer?

As a simple test case, I'm trying to configure the software stack of OpenGeo such that I can display a GeoTIFF as an overlay to a normal map like OSM. So I perform the following steps: Create a ...
0
votes
1answer
181 views

Which is better for tiling: raster2pgsql or GeoWebCache?

We have some raster image data stored as GeoTIFF which we would like to make available online as an overlay using the OpenGeo framework. As the data covers only a spatially restricted area and we ...
1
vote
1answer
544 views

raster2pgsql missing in Opengeo-suite installation

I installed opengeo-suite 3.0.2 on Ubuntu 12.04 and although the stack seems to be working fine, raster2pgsql is no where to be seen! root@mywebsite:/usr/local/lib/postgresql/9.2# locate raster2pgsql ...
1
vote
0answers
85 views

blank preview image for ImageMosaicJDBC (postgis raster) layer [duplicate]

In geoserver, while publishing ImageMosaicJDBC layer seems no problem, the preview of this layer does not give me an meaningful overview image, only a blank image with the correct lat lon extend. Also ...