Re: [postgis-users] Dted elevations

2014-05-13 Thread Gold, Jack L (US SSA)
-Original Message- From: postgis-users-boun...@lists.osgeo.org [mailto:postgis-users-boun...@lists.osgeo.org] On Behalf Of Gold, Jack L (US SSA) Sent: Friday, May 09, 2014 11:01 AM To: 'postgis-users@lists.osgeo.org' Subject: [postgis-users] Dted elevations I know this question has already been

[postgis-users] Dted elevations

2014-05-09 Thread Gold, Jack L (US SSA)
I know this question has already been answered a hundred times but I am at a remote location currently with only email access right now and I hope someone can help. The following query is taking close to a second to run and I think it should be much faster. Select st_value from (with f as (

Re: [postgis-users] Dted elevations

2014-05-09 Thread Pierre Racine
...@lists.osgeo.org [mailto:postgis-users- boun...@lists.osgeo.org] On Behalf Of Gold, Jack L (US SSA) Sent: Friday, May 09, 2014 1:01 PM To: 'postgis-users@lists.osgeo.org' Subject: [postgis-users] Dted elevations I know this question has already been answered a hundred times but I am

Re: [postgis-users] Dted elevations

2014-05-09 Thread Gold, Jack L (US SSA)
Message- From: postgis-users-boun...@lists.osgeo.org [mailto:postgis-users-boun...@lists.osgeo.org] On Behalf Of Pierre Racine Sent: Friday, May 09, 2014 1:26 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] Dted elevations What happened when you remove and st_value