Re: [postgis-users] ERROR: rt_raster_from_two_rasters:

2014-06-05 Thread Guido Lemoine
Jason, I would swap the ST_UNION and ST_CLIP, which would be more logical (though assuming you store the rasters in small tiles). You would first ST_UNION all tiles that are in the transformed polygon and clip that result (again with the transformed polygon). On the other hand, the

Re: [postgis-users] ERROR: rt_raster_from_two_rasters:

2014-06-05 Thread Jason Mathis
Guido!!  I believe you have solved this. I switched the st_union and st_clip and reworked the query a bit and voila all the queries that were failing before now work. This is great!  Re: alignment problem. I loaded 14 states with a python script that looped through each shape file that did

[postgis-users] ST_AsGDALRaster() error

2014-06-05 Thread Jayson Gallardo
We just ran a package update or our Debian machine last night, and now this morning our app doesn't work. I've narrowed it down to this: ERROR: rt_raster_to_gdal: Could not load the output GDAL driver production=# select postgis_full_version(); postgis_full_version

Re: [postgis-users] Versioning system to use with QGIS + Postgis

2014-06-05 Thread Alexandre Neto
I forgot the link: https://github.com/SrNetoChan/PGHP/blob/master/new_versioning_system.sql Alexandre Neto On Thu, Jun 5, 2014 at 5:43 PM, Alexandre Neto senhor.n...@gmail.com wrote: Hello all, I have been working on a versioning system to be used with QGIS. This is probably a very naive

Re: [postgis-users] ST_SelectByValue

2014-06-05 Thread Pierre Racine
Try ST_Reclass(). -Original Message- From: postgis-users-boun...@lists.osgeo.org [mailto:postgis-users- boun...@lists.osgeo.org] On Behalf Of David Haynes Sent: Friday, May 30, 2014 10:49 AM To: postgis-users@lists.osgeo.org Subject: [postgis-users] ST_SelectByValue Hello, I

Re: [postgis-users] raster support

2014-06-05 Thread Pierre Racine
These variables are system variables, not PostgreSQL variables. to know how to set them in your system search for set environment variable os x. Pierre -Original Message- From: postgis-users-boun...@lists.osgeo.org [mailto:postgis-users- boun...@lists.osgeo.org] On Behalf Of John

Re: [postgis-users] ST_SelectByValue

2014-06-05 Thread Pierre Racine
If you set the values you're looking for to themselves and other pixels to nodata, ST_Reclass is equivalent to ST_SelectByValue. -Original Message- From: postgis-users-boun...@lists.osgeo.org [mailto:postgis-users- boun...@lists.osgeo.org] On Behalf Of David Haynes Sent: Thursday,

Re: [postgis-users] Versioning system to use with QGIS + Postgis

2014-06-05 Thread Alexandre Neto
Hello José, I already knew about pgversion, but I haven't been able to see its code or use the plugin. Do you know if it is still working? Thanks, Alexandre Neto Em 05/06/2014 18:01, José Carlos Martínez Llario jomar...@cgf.upv.es escreveu: Hi, pgversion is a nice approach and there is a