Re: [postgis-users] PostGIS - Simple Raster Point Query

[mailto:postgis-users- boun...@lists.osgeo.org] On Behalf Of Tim-Hinnerk Heuer Sent: Friday, December 14, 2012 7:32 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] PostGIS - Simple Raster Point Query Good point and apologies I haven't been more clear. We want to achieve

Re: [postgis-users] PostGIS - Simple Raster Point Query

: Tuesday, December 18, 2012 3:09 AM To: PostGIS Users Discussion Subject: Re: [postgis-users] PostGIS - Simple Raster Point Query Hi Pierre, Sorry, I might not have been 100% clear. What you say is exactly what I want to achieve. That's the reason I'm posting the question here, because I do

Re: [postgis-users] PostGIS - Simple Raster Point Query

Thanks Pierre! That works like a charm (with some minor changes because of projections and different point values). It is noticeably faster now too. Thanks, again. :-) Cheers, Tim Tim-Hinnerk Heuer Twitter: @geekdenz Blog: http://www.thheuer.com On 19 December 2012 10:56, Pierre Racine

Re: [postgis-users] PostGIS - Simple Raster Point Query

Maybe it would be better to describe more generally what you are trying to achieve. Most complex processing can normally be achieved in one complex query. PostgreSQL should cache what was loaded in previous queries so that it does not necessarily reload tiles at each query. Pierre We query

Re: [postgis-users] PostGIS - Simple Raster Point Query

Good point and apologies I haven't been more clear. We want to achieve this: http://npm.landcareresearch.co.nz/elevation/ with Open Source technology and our own data. Also, instead of doing a single line, we want to implement a LineString which can have multiple control points in it. So far

[postgis-users] PostGIS - Simple Raster Point Query

Hi, I'm new to PostGIS, at least in the backend, so please excuse my naive question, but I couldn't figure this out Googling. So, I've got it all working (PostGIS 2.0, imported the raster file and got the right projection information etc). SELECT PostGIS_full_version(); postgis_full_version

Re: [postgis-users] PostGIS - Simple Raster Point Query

Thanks Pierre for your quick answer, however it didn't work :-(. Also tried reversing the coordinates to no success. The raster is tiled already. Is there another way maybe? Thanks, TIm Tim-Hinnerk Heuer Twitter: @geekdenz Blog: http://www.thheuer.com On 9 December 2012 00:49, Pierre Racine

Re: [postgis-users] PostGIS - Simple Raster Point Query

Subject: Re: [postgis-users] PostGIS - Simple Raster Point Query Thanks Pierre for your quick answer, however it didn't work :-(. Also tried reversing the coordinates to no success. The raster is tiled already. Is there another way maybe? Thanks, TIm Tim-Hinnerk Heuer Twitter

Re: [postgis-users] PostGIS - Simple Raster Point Query

; Pierre -Original Message- From: postgis-users-boun...@lists.osgeo.org [mailto:postgis-users- boun...@lists.osgeo.org] On Behalf Of Tim-Hinnerk Heuer Sent: Saturday, December 08, 2012 6:57 AM To: PostGIS Users Discussion Subject: Re: [postgis-users] PostGIS - Simple Raster Point

Re: [postgis-users] PostGIS - Simple Raster Point Query

: Saturday, December 08, 2012 6:57 AM To: PostGIS Users Discussion Subject: Re: [postgis-users] PostGIS - Simple Raster Point Query Thanks Pierre for your quick answer, however it didn't work :-(. Also tried reversing the coordinates to no success. The raster is tiled already. Is there another

Re: [postgis-users] PostGIS - Simple Raster Point Query

[mailto:postgis-users- boun...@lists.osgeo.org] On Behalf Of Tim-Hinnerk Heuer Sent: Saturday, December 08, 2012 6:57 AM To: PostGIS Users Discussion Subject: Re: [postgis-users] PostGIS - Simple Raster Point Query Thanks Pierre for your quick answer, however it didn't work :-(. Also

Re: [postgis-users] PostGIS - Simple Raster Point Query

I made the tile size 1200x1200 and used the -R option when doing the raster2pgsql import because the raster is a .img/.ige file which is 26GB. But this query result tells me it got the right geo transform. If your coverage is tiled, your query should look like: SELECT

Re: [postgis-users] PostGIS - Simple Raster Point Query

Hi Pierre, Great! Thank you so much, that worked! You're a genius! In case you are wondering. That point is Mount Ruhapehu and it gave me the answer: 2611.7314453125 (m) which is indeed correct. Kind regards, Tim Tim-Hinnerk Heuer Twitter: @geekdenz Blog: http://www.thheuer.com On 9