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
Sorry it didn't work :-( . Can you check that temp_id is not always 1?
It is more that this approach is flawed
_depending on the raster resolution and the small turn in your line (fixe =
simplify line).
_anyway, you are constructing a new line from centroid, and not putting the
height information
Done!
http://geospatialelucubrations.blogspot.ca/2014/05/a-guide-to-rasterization-of-vector.html
Pierre
-Original Message-
From: postgis-users-boun...@lists.osgeo.org [mailto:postgis-users-
boun...@lists.osgeo.org] On Behalf Of georgew
Sent: Monday, April 21, 2014 6:37 PM
To:
Create a new table with the extents of the raster tiles and check if it
overlaps with your points:
CREATE TABLE rastextets AS
SELECT rast::geometry
FROM tbl_raster
Pierre
-Original Message-
From: postgis-users-boun...@lists.osgeo.org [mailto:postgis-users-
boun...@lists.osgeo.org]
Thank you Pierre, this will be of great help not just to me but to countless
others as well, I hope it receives the widest possible circulation.
--
View this message in context:
http://postgis.17.x6.nabble.com/Postgis-raster-tutorial-tp5006124p5006287.html
Sent from the PostGIS - User mailing
Hi Pierre,
Thanks so much for super quick response. You will have to forgive me I am
fairly new to postgis.
Creating the table is no problem but how would I check if it overlaps with my
points?
thanks!
On May 13, 2014 at 4:08:40 PM, Pierre Racine (pierre.rac...@sbf.ulaval.ca)
wrote:
Remi, you replied before the edits I made to my last posting were accepted by
the forum. It actually did work!, with very minor adjustments to your code.
But I accept that my approach may not the best way to go about this problem,
so I'll try your latest suggestion and let you know the results.