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
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
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
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
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
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
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,
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