[postgis-users] Dted elevations

[Gold, Jack L (US SSA)]

We solved the issue.  It turns out that searching for elevation on DTED level 2 takes a long time in comparison to DTED Level 1. This is not surprising considering the density of the data.  I'm wondering if anyone has looked into optimizing this kind of elevation searching?

--Jack

-----Original Message-----
From: postgis-users-bounces at lists.osgeo.org [mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of Gold, Jack L (US SSA)
Sent: Friday, May 09, 2014 11:01 AM
To: 'postgis-users at lists.osgeo.org'
Subject: [postgis-users] Dted elevations

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 ( select st_transform ( st_SetSRID( st_MakePoint('106','32'), 4326) as geom) select st_value(dted_elevations.rast, f.geom) from dted_elevations cross join f where st_intersects ( dted_elevations.rast , f.from) and st_value (dted_elevations.rast, f.geom) is not null) as st_value;

Any help is greatly appreciated.

Jack Gold
_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users