Tagged Questions
1
vote
0answers
24 views
How to load a raster from in-memory bitmap (not from file) into PostgreSQL
I have a bitmap in memory that I would like to load as a raster to PostgreSQL.
An unfavorable option is saving the bitmap to file and then use raster2pgsql, but as we
have several cameras that ...
0
votes
1answer
57 views
It seems there is a bug in St_Clip function of PostGIS
The code I am using for clip feature is :
raster ST_Clip(raster rast, geometry geom, double precision[] nodataval=NULL, boolean crop=true);
I tried clip a shape depends on the polygon from the ...
3
votes
0answers
27 views
What is the correct syntax for using gdal_rasterize with a PostGIS datasource
I have a multipolygon layer in PostGIS and I would like to use gdal_rasterize to generate a raster. I cannot find the correct syntax to specify PostGIS as the data source.
$ gdal_rasterize -a ...
3
votes
1answer
146 views
How to import QGIS Raster into PostGIS
I have created a IDW heatmap using QGIS 1.8.0 and need to import the raster into PostGIS 2.0.1. QGIS saves the raster layer as a .asc file.
How do you import the raster into PostGIS as a Raster? What ...
1
vote
1answer
40 views
Difference in raster size using raster2pgsql
I use the PostGIS-build-in raster2pgsql to load SAGA-raster into the db. I tried to grid them into 100x100-tiles, just as seen in the code:
/usr/lib/postgresql/9.2/bin/raster2pgsql -s 32632 -a -F ...
1
vote
1answer
115 views
Stuck in loading raster to PostGIS
I am running running Mac OS X (10.7.5), PostgreSQL (9.2) and PostGIS (2.0.2) (installed via Postgres.app).
The PostGIS extension seems to work perfectly with vector and raster layers. Once I enable ...
3
votes
1answer
103 views
Creating a vector based design from a raster database
I have a raster table that I've created using Postgis raster. It has 365 records and the table looks like this:
+-----+------------+---------+------------+
| rid | rast |filename |date_of data|
...
3
votes
1answer
134 views
raster2pgsql: Strange error when creating a table
Hi GIS Stackexchange people,
When I try to load a asc file into my psql setup, I get a strange error message.
I have created the sql input file via
raster2pgsql -s 4236 -I -C -M gis_data.asc -F ...
16
votes
1answer
158 views
Can we create views over a raster table in Postgis2.0?
Is it possible to create PostgreSQL views over a table that contains raster data?
I have succeeded in creating the view but the entry in raster_columns is not correct (all the raster info is ...
2
votes
2answers
432 views
raster2pgsql part of PostGIS?
Hi GIS Stackoverflow people,
I wanted to use the PostGIS functionality [raster2pgsql][1], but I had to discover that the Python function was not installed with my PostGIS installation.
Do you know ...
5
votes
1answer
319 views
How to view a 155 MB raster stored in PostGIS?
I am using the following command to load a raster into a postgres database:
raster2pgsql -I -C -e -Y -F -s 3086 -I -C -M myraster.tif myraster -F -t 30x30 | psql -U postgres -d database -h localhost ...
4
votes
1answer
229 views
Are there limitations using a PostGIS out-db raster?
I have been trying to import a large raster into a PostGIS 2.0 database and hit a few stumbling blocks.
Initially when I tried to import the raster using raster2pgsql, I would receive the following ...
9
votes
3answers
4k views
Loading a raster into a PostGIS 2.0 database on Windows
I'm trying to figure out how to load a raster into a PostGIS2.0 database (I have asked previous questions on this topic here and here). I am trying to use the raster2pgsql.exe program provided with ...
4
votes
1answer
1k views
Loading a raster using QGIS into a PostGIS2.0 enabled database
Following on from my attempt to install a postgresql 9.1 db with postgis 2.0 on windows 7, I am trying to figure out how to load a raster. I have successfully loaded a shapefile, and am trying to do ...
4
votes
1answer
2k views
How to import a raster into PostGIS?
I'm trying to follow the instructions here to load a raster into a PostGIS database:
python raster2pgsql.py -s 4269 -I -r *.tif -F myschema.demelevation -o elev.sql
I understand that I replace * ...
6
votes
1answer
730 views
QGIS WKT Raster Plugin error, what does this mean?
I have been playing with the WKT Raster plugin. I have installed the WKT Raster experimental binaries in PostGIS successfully and followed the instructions in the read me to the letter.
When i am in ...
