Re: [postgis-users] Error browsing database

2012-05-25 Thread Paolo Cavallini
Il 25/05/2012 18:39, Bborie Park ha scritto: > On 05/25/2012 08:57 AM, Paolo Cavallini wrote: >> you better believe it ;) >> Faunalia (Giuseppe Sucameli) is the maintainer of it. >> All the best. >> > Really?! I'll have to try that out. > sure you should. comments, tickets, fixes and improvements

Re: [postgis-users] Error browsing database

2012-05-25 Thread Bborie Park
On 05/25/2012 08:57 AM, Paolo Cavallini wrote: > Il 25/05/2012 17:32, Bborie Park ha scritto: >> I don't believe the DB Manager in QGIS works for PostGIS Raster. > you better believe it ;) > Faunalia (Giuseppe Sucameli) is the maintainer of it. > All the best. > Really?! I'll have to try that ou

Re: [postgis-users] Error browsing database

2012-05-25 Thread Paolo Cavallini
Il 25/05/2012 17:32, Bborie Park ha scritto: > I don't believe the DB Manager in QGIS works for PostGIS Raster. you better believe it ;) Faunalia (Giuseppe Sucameli) is the maintainer of it. All the best. -- Paolo Cavallini See: http://www.faunalia.it/pc _

Re: [postgis-users] Error browsing database

2012-05-25 Thread Bborie Park
On Fri, May 25, 2012 at 3:24 AM, Paolo Cavallini wrote: > Il 25/05/2012 11:22, Paolo Cavallini ha scritto: >> So, for the record, there were 2 different issues: - id and column >> naming (rid, rast) - irregular blocks. Thanks for help in clarifying. > > next step: loading the raster in QGIS (DB Ma

Re: [postgis-users] Error browsing database

2012-05-25 Thread Paolo Cavallini
Il 25/05/2012 11:22, Paolo Cavallini ha scritto: > So, for the record, there were 2 different issues: - id and column > naming (rid, rast) - irregular blocks. Thanks for help in clarifying. next step: loading the raster in QGIS (DB Manager, drag&drop) hangs PG: 8 postgres 20 0 403m 123m 1

Re: [postgis-users] Error browsing database

2012-05-25 Thread Paolo Cavallini
Il 24/05/2012 22:22, Bborie Park ha scritto: > Correct. That and when each tile is transformed, the output isn't > aligned with the rest of the transformed tiles. There has been > discussion about adding a reference raster to ensure the transformed > tiles are aligned. So, for the record, there wer

Re: [postgis-users] Error browsing database

2012-05-24 Thread Bborie Park
On 05/24/2012 01:08 PM, Paolo Cavallini wrote: > Il 24/05/2012 20:28, Bborie Park ha scritto: >> Double checking your query, the table created doesn't have an "rid" >> column and the raster column must be called "rast". These are >> limitations of the GDAL PostGIS Raster driver... > OK, so now: >

Re: [postgis-users] Error browsing database

2012-05-24 Thread Paolo Cavallini
Il 24/05/2012 20:28, Bborie Park ha scritto: > Double checking your query, the table created doesn't have an "rid" > column and the raster column must be called "rast". These are > limitations of the GDAL PostGIS Raster driver... OK, so now: CREATE TABLE dtm_wgs84c

Re: [postgis-users] Error browsing database

2012-05-24 Thread Bborie Park
Double checking your query, the table created doesn't have an "rid" column and the raster column must be called "rast". These are limitations of the GDAL PostGIS Raster driver... -bborie On 05/24/2012 11:14 AM, Paolo Cavallini wrote: > Il 24/05/2012 20:07, Bborie Park ha scritto: >> I just teste

Re: [postgis-users] Error browsing database

2012-05-24 Thread Paolo Cavallini
Il 24/05/2012 20:07, Bborie Park ha scritto: > I just tested that gdalinfo (from gdal-trunk) on one of my rasters and > it doesn't have any issues. Could there be privilege issues with > "corso" not having access? I'm also fine with most of my rasters - just an issue with the ones produced with S

Re: [postgis-users] Error browsing database

2012-05-24 Thread Bborie Park
On 05/24/2012 10:26 AM, Paolo Cavallini wrote: > Il 24/05/2012 19:21, Bborie Park ha scritto: >> Which version of GDAL are you using? > 1.9.0-2 on Debian >> I'm assuming the CREATE TABLE >> statement runs successfully? >> > yes. > thanks. > I just tested that gdalinfo (from gdal-trunk) on one o

Re: [postgis-users] Error browsing database

2012-05-24 Thread Paolo Cavallini
Il 24/05/2012 19:21, Bborie Park ha scritto: > Which version of GDAL are you using? 1.9.0-2 on Debian > I'm assuming the CREATE TABLE > statement runs successfully? > yes. thanks. -- Paolo Cavallini See: http://www.faunalia.it/pc ___ postgis-users ma

Re: [postgis-users] Error browsing database

2012-05-24 Thread Bborie Park
Which version of GDAL are you using? I'm assuming the CREATE TABLE statement runs successfully? -bborie On 05/24/2012 09:32 AM, Paolo Cavallini wrote: > Hi all. > > A simple > > CREATE TABLE dtm > AS SELECT ST_Transform(rast,4326, 'Bilinear') AS rast > FROM hdr; > > results in > > gdalin

[postgis-users] Error browsing database

2012-05-24 Thread Paolo Cavallini
Hi all. A simple CREATE TABLE dtm AS SELECT ST_Transform(rast,4326, 'Bilinear') AS rast FROM hdr; results in gdalinfo "PG:host=localhost dbname=postgis2 user=corso table=dtm mode=2 password=***" ERROR 1: Error browsing database for PostGIS Raster properties Similar tables are read without