1
vote
1answer
26 views

POSTGIS Raster - Merge polygon onto raster

I have two tables, SCHEDULE contains polygon geometries and RASTER contains raster tiles I want to take a polygon from the SCHEDULE table and overlay it on top of a set of RASTER tiles that intersect ...
0
votes
0answers
18 views

Text in POSTGIS Raster

Is it possible to add text/annotation to a raster generated in Postgis raster? Specifically I need to do this within the database if possible and am looking for an option that does not require an ...
1
vote
1answer
69 views

Mapnik + OpenStreetMap + Shapefile with Raster Images + Mod Tile + PostGIS

I am new to GIS. I have a Shapefile (.shp, .shx and .pbf). The .pbf file contains path to PNG files located on my machine only. I was able to save the Shp data to PostGis via Shape2Gis tool. Now ...
0
votes
1answer
18 views

How to export query result on raster table in PostGIS

I did success query on a raster table in postGIS(raster data clipped by a vector polygon), now I want to view the query result in QGIS. But how to export the query result to another table. In vector ...
0
votes
0answers
36 views

rasterize table polygon postgis 2.1

I would like to rasterize a postgis 2.1 polygon table, but I don't undersand how to create the SQL function syntax for ST_AsRaster. My vector table has 3 fields: gid, recharge, and geom. The SQL ...
0
votes
0answers
25 views

Is there a Raster2pgsql GUI?

Has anyone ever attempted to create a raster2pgsql gui (like the shp2pgsql gui). As I am sometimes lazy to use command line, this could be a very nice to have.
1
vote
0answers
48 views

PostGIS raster connection is not closed by MapServer

I'm using PostGIS raster in MapServer like this: TYPE RASTER DATA "PG:port=6432 dbname='mydb' user='postgres' password='1234' schema='public' table='truemarble' mode='2'" PROCESSING ...
1
vote
0answers
26 views

Import raster to postgis and add a foreign key constraint

I use raster2pgsql to import raster files into a table with this command line: C:\Program Files\PostgreSQL\9.3\bin>raster2pgsql -s 4326 -M -F -a c:\temp\mun.tif public.basqui_raster | psql -U ...
0
votes
1answer
63 views

Import raster into PostGIS using Python

I am trying to import information from a Bathymetric Attributed Grid (BAG) file into PostGIS using Python and psycopg2. I'm working, for now, on a Windows box with pre-compiled packages, so I don't ...
2
votes
1answer
34 views

Postgis Raster merge geometry

I have a raster table and a geometry table in postgis. My goal is to create a single raster merging elements from both:- WITH geom_raster AS ( SELECT wkb_geometry, ST_AsRaster(wkb_geometry, ...
2
votes
0answers
140 views

Raster slightly displaced after exporting from PostGIS database

With the following queries I've exported a raster (GTiff) from my postgis database: 1.Creating a large object: WITH buffer AS ( SELECT id, ST_Buffer(geom,50) AS geom FROM ...
1
vote
2answers
96 views

Conversion of point grid to a raster with open source tools (Gdal, QGIS …)

I'm looking to do something which seem simple to me, but I haven't found a solution since 2 days I looked for. I've got a Postgis DB with lot of points (WGS84) spaced of 100 meters which cover a ...
0
votes
0answers
71 views

Create Image Mosaic JDBC datastore in command line

I would like to publish raster from PostGIS database, and I found this tutorial http://docs.geoserver.org/2.1.4/user/tutorials/imagemosaic-jdbc/imagemosaic-jdbc_tutorial.html , everything works fine, ...
4
votes
1answer
106 views

PostGIS: convert point data to raster

I have a table of points and I'm trying to visualize their distributions. Each point has a POINT geometry (WGS84) and some numeric attributes: a, b, c. | id | geom | a | b | c | ...
0
votes
1answer
22 views

Is rid=2 significant in PostGIS raster structure?

It seems that in most, if not all, examples with raster appear to include the WHERE rid=2 statement in the query. http://postgis.net/docs/RT_ST_Value.html Is there something about the rast structure ...
0
votes
1answer
121 views

Cannot read postgis RASTER into ArcGIS using the interoperability extension, either directly by Query Layer

This post accessing postgis raster data using Query layer in ArcGIS was created in Jul-12. Since then, I have not found any other related-post published. Using QGIS with DBManager ON, my postGIS ...
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 ...
0
votes
2answers
49 views

how to specify -t critical dowloading raster with raster2pgsql

I'm trying to download a raster into postgres/postgis. So far I wrote: raster2pgsql -s 3006 -I -C -M -R filename.tif -F -t 463.313x463.313 schema.rastername | psql -h localhost -U postgres -d db ...
2
votes
1answer
83 views

PostGIS Raster: Outputting raster into GDAL supported file?

I have import a raster into my postGIS database via raster2pgsql. My raster tiled to 100x100. Now I'm trying to export (output) the raster to GDAL supported file (for example: PNG). Following the ...
1
vote
0answers
80 views

PostGIS Raster: raster2pgsql was not found in /usr/lib/postgresql/9.3/bin

I have installed sucessfully Postgresql-9.3-postgis on Ubuntu 12.04, following this instructions: http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS21UbuntuPGSQL93Apt Having done that, I have ...
2
votes
3answers
258 views

How to export raster from PostGIS enabled DB as GTiff with gdal_translate

When I want to export a GTiff from my PostGIS DB with this code: gdal_translate -of GTiff PG":host='localhost' port:'5432' dbname='landslide' user='postgres' password='pass' schema='public' ...
2
votes
2answers
1k views

Loading PostGIS raster layer into QGIS

I am unable to load a PostGIS raster layer into QGIS. I have looked through previous posts Loading raster from PostGIS DB into QGIS and Cannot add the PostGIS raster layer with QGIS but was not able ...
0
votes
0answers
40 views

Intersect two rasters with similar scale in PostGIS

I'm working on a project in which we have a ~100x100km grid with ~1x1km cell sizes to which we are trying to aggregate other data, including point, polygon, and raster data. This grid is a collection ...
1
vote
0answers
43 views

Selecting a rectangle box from a raster tiled table in PostGis 2.1

I am new to PostGIS as well as SQL queries for rasters. I have imported a raster .tif file into PostGIS with tiles. I would need to select a bounded rectangle from within this raster using SQL ...
3
votes
1answer
303 views

How to join 2D polylines and DEM into 3D polylines?

I got a simple question but could not find a satisfactory answer yet: I have a road network in 2D/PostGIS and a DEM. I want to turn the road network into 3D by retrieving the Z-value from the DEM. ...
2
votes
0answers
65 views

Add attribute table to a raster in postGIS

I would like to add attributes to a raster stored in a postgis database. I use the following command to insert the raster in the database: raster2pgsql -s 4236 -I -C -M ...
0
votes
0answers
51 views

Is anyone else working on PostGIS rasters for Ruby?

This is more of an answer looking for a question, really. If you're writing Ruby (and especially ActiveRecord) code and want to use those tasty pixels from PostGIS rasters, you've probably had to deal ...
5
votes
2answers
311 views

10 GB Raster Aerial Image in Quantum and POSTGIS

I have a problem... I have been successful in uploading the raster in postgis but when I access it through Qgis. it does not open even after several hours. I have 10GB aerial image raster and ...
1
vote
0answers
265 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 ...
0
votes
1answer
81 views

Multiple Rasters into PostGIS

This may have been asked before, but A) what software/libraries etc do I need to B) load multiple rasters into PostGIS? I have Python 2.7.5, QGIS 1.9 (latest Weekly Build), PostGIS (whatever the ...
3
votes
2answers
396 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 ...
0
votes
1answer
198 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 ...
6
votes
0answers
337 views

What is the correct syntax for using gdal_rasterize with a PostGIS datasource [closed]

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 ...
0
votes
1answer
88 views

What's regular blocking arrangement ? (GDAL)

I am using GDAL tools to retrieve PostGiS raster. The code(command line) I am using is as follows : gdal_translate -of AAIGrid "PG:host=localhost dbname='database' user='postgres' password='admin' ...
3
votes
0answers
929 views

Loading raster from PostGIS DB into QGIS: succeeded yesterday, fails now [closed]

I have a PostgreSQL(v.9.2)/Postgis(v.2.0.3) database which includes raster layers (added through raster2pgsql). To open them in QGIS (v.1.8.0-Lisboa), the "Add Postgis layer" menu will not work; ...
3
votes
1answer
329 views

How to get Lon/Lat values from the postgis raster type column

I have a tiff raster in my PostGIS 2.0 database. I want to get the value lat/lon and extra data like temperature from the raster type column in postgis table. I want the table with columns ...
2
votes
1answer
267 views

Raster Tile Merge Performance of PostGIS 2.0

I'm attempting to intersect Australian Census boundary polygons with the 1" SRTM DEM (10.5bn points across Australia), and output the result as a single raster image on the fly. The DEM is stored in ...
2
votes
1answer
540 views

Problem in importing raster data from PostGIS to Geoserver

I am using Opengeo Suite 3.0.2, PostGIS 2.0.3 and PostgreSQl 9.2. I am trying to import raster data from PostGIS to Geoserver but facing an error. I follow this tutorial link to import the raster ...
3
votes
1answer
232 views

Visualizing Spatial Query

I'm new to GIS applications and trying to figure out what options I have for visualizing spatial query results that combine raster and vector data using OpenLayers/GeoExt/GeoServer/PostGIS. A ...
2
votes
2answers
276 views

Can Geoserver return the raster value of a lat/lon point

I have a GeoTIFF published by Geoserver 2.2 and being used by Leaflet via WMS. How can I get Geoserver to return the raster value at a lat/long point? I'm guessing it has to do with using WCS, but ...
3
votes
1answer
956 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
119 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 ...
6
votes
1answer
187 views

Assigning costs to a road network : use raster or vector?

I have a road network in a PostGis database (db_routing). In another database (db_environment), I have some spatial features of the surrounding environment (trees as points and water bodies as ...
3
votes
1answer
224 views

raster tile - find the correct tile for a given coordinate

I have a large raster map which I loaded into postgis with 1000x1000 meter tiles... the corresponding table has about 200 rows, each row representing a tile. I want to get the raster value for a ...
1
vote
0answers
115 views

Are there limitations with gdal virtual raster option?

I am new at Postgis and I'm groping... I pretend to rasterize some weighty vector layers in Postgis, do some map algebra and reclassification with them and visualize intermediate as well as final ...
1
vote
1answer
94 views

Problem loading raster to PostGIS using QGIS

I am having trouble loading a raster (.asc) file to PostGIS 2.0.1 using the plugin Database - PostGIS Raster - Load raster to postgis in QGIS 1.8.0 on Win Vista 64 bit. I get the following error ...
1
vote
2answers
302 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
425 views

Importing grib, grib2, netcdf to PostGIS

According to grib2 to raster? (grib2 -> raster2pgsql -> PostGIS 2.0 -> GeoServer), it seems like that grib2 can be treated as raster directly. Is it the so called "standard" way? How about ...
3
votes
1answer
145 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| ...
10
votes
3answers
740 views

How to speed up queries for raster databases?

I have a raster database in postgresql/postgis with these columns: (ID, rast, data_of_data). 'rast' is the column that has raster files in WKT format. An example query to find the DN value of a ...