[postgis-users] PostGIS - Simple Raster Point Query

Tim-Hinnerk Heuer th.heuer at gmail.com
Sat Dec 8 14:36:56 PST 2012


raster2pgsql -b 1 -t 1200x1200 -C -I -M -s 2193 -R /mnt/nfs/data/nzdem3.img
> nzdem3-raster-C-I-M-s_2193.sql

is the command I ran for this. (Of course I imported the .sql file into
PostGIS with psql -f ...

Tim-Hinnerk Heuer

Twitter: @geekdenz
Blog: http://www.thheuer.com



On 9 December 2012 01:00, Pierre Racine <Pierre.Racine at sbf.ulaval.ca> wrote:

> Could you do this:
>
> SELECT (ST_Metadata(rast)).* FROM nzdem3;
>
> Pierre
>
> > -----Original Message-----
> > From: postgis-users-bounces at lists.osgeo.org [mailto:postgis-users-
> > bounces at 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
> 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 <http://www.thheuer.com/>
> >
> >
> >
> > On 9 December 2012 00:49, Pierre Racine <Pierre.Racine at sbf.ulaval.ca>
> wrote:
> >
> >
> >       select st_value(rast,ST_SetSRID(ST_Point(1821416, 5649720), 2193))
> > from nzdem3
> >
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20121209/887de8e4/attachment.html>


More information about the postgis-users mailing list