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

5
votes
1answer
1k 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 ...
4
votes
3answers
408 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 ...
2
votes
1answer
89 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
1answer
84 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 ...
1
vote
1answer
352 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
1answer
148 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 ...
1
vote
1answer
148 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 ...
1
vote
0answers
100 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
266 views

Cannot add the PostGIS raster layer with QGIS

I've imported some raster data in PostGIS database with the following command: raster2pgsql -s 31468 -I -C -M -t 50x50 /home/stefan/Quantum\ GIS/Neumarkt/NM_NW.tif public.demelevation | psql -U ...
1
vote
0answers
524 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
0answers
75 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 ...
0
votes
1answer
141 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 ...
0
votes
1answer
62 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
1answer
60 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 ...
0
votes
0answers
63 views

execute raster2pgsql in php script

I have a geotiff Rasterimage and I want to import it to PostGIS via php. I'm using windows server 2008 with ms4w 3.0.6 installed. My php code looks like this: include ("db.php"); ...