[postgis-users] PostGIS - Simple Raster Point Query

[Tim-Hinnerk Heuer]

 upperleftx | upperlefty | width | height | scalex | scaley | skewx | skewy
| srid | numbands
------------+------------+-------+--------+--------+--------+-------+-------+------+----------
    1084000 |    6234000 |  1200 |   1200 |     15 |    -15 |     0 |     0
| 2193 |        1
    1102000 |    6234000 |  1200 |   1200 |     15 |    -15 |     0 |     0
| 2193 |        1
    1120000 |    6234000 |  1200 |   1200 |     15 |    -15 |     0 |     0
| 2193 |        1
    1138000 |    6234000 |  1200 |   1200 |     15 |    -15 |     0 |     0
| 2193 |        1
    1156000 |    6234000 |  1200 |   1200 |     15 |    -15 |     0 |     0
| 2193 |        1
    1174000 |    6234000 |  1200 |   1200 |     15 |    -15 |     0 |     0
| 2193 |        1
    1192000 |    6234000 |  1200 |   1200 |     15 |    -15 |     0 |     0
| 2193 |        1
    1210000 |    6234000 |  1200 |   1200 |     15 |    -15 |     0 |     0
| 2193 |        1
    1228000 |    6234000 |  1200 |   1200 |     15 |    -15 |     0 |     0
| 2193 |        1
    1246000 |    6234000 |  1200 |   1200 |     15 |    -15 |     0 |     0
| 2193 |        1
    1264000 |    6234000 |  1200 |   1200 |     15 |    -15 |     0 |     0
| 2193 |        1
    1282000 |    6234000 |  1200 |   1200 |     15 |    -15 |     0 |     0
| 2193 |        1
    1300000 |    6234000 |  1200 |   1200 |     15 |    -15 |     0 |     0
| 2193 |        1
    1318000 |    6234000 |  1200 |   1200 |     15 |    -15 |     0 |     0
| 2193 |        1
    1336000 |    6234000 |  1200 |   1200 |     15 |    -15 |     0 |     0
| 2193 |        1
    1354000 |    6234000 |  1200 |   1200 |     15 |    -15 |     0 |     0
| 2193 |        1
    1372000 |    6234000 |  1200 |   1200 |     15 |    -15 |     0 |     0
| 2193 |        1
    1390000 |    6234000 |  1200 |   1200 |     15 |    -15 |     0 |     0
| 2193 |        1
    1408000 |    6234000 |  1200 |   1200 |     15 |    -15 |     0 |     0
| 2193 |        1
    1426000 |    6234000 |  1200 |   1200 |     15 |    -15 |     0 |     0
| 2193 |        1
    1444000 |    6234000 |  1200 |   1200 |     15 |    -15 |     0 |     0
| 2193 |        1
    1462000 |    6234000 |  1200 |   1200 |     15 |    -15 |     0 |     0
| 2193 |        1
    1480000 |    6234000 |  1200 |   1200 |     15 |    -15 |     0 |     0
| 2193 |        1
    1498000 |    6234000 |  1200 |   1200 |     15 |    -15 |     0 |     0
| 2193 |        1
    1516000 |    6234000 |  1200 |   1200 |     15 |    -15 |     0 |     0
| 2193 |        1
    1534000 |    6234000 |  1200 |   1200 |     15 |    -15 |     0 |     0
| 2193 |        1
    1552000 |    6234000 |  1200 |   1200 |     15 |    -15 |     0 |     0
| 2193 |        1
    1570000 |    6234000 |  1200 |   1200 |     15 |    -15 |     0 |     0
| 2193 |        1
    1588000 |    6234000 |  1200 |   1200 |     15 |    -15 |     0 |     0
| 2193 |        1
    1606000 |    6234000 |  1200 |   1200 |     15 |    -15 |     0 |     0
| 2193 |        1
    1624000 |    6234000 |  1200 |   1200 |     15 |    -15 |     0 |     0
| 2193 |        1
    1642000 |    6234000 |  1200 |   1200 |     15 |    -15 |     0 |     0
| 2193 |        1
    1660000 |    6234000 |  1200 |   1200 |     15 |    -15 |     0 |     0
| 2193 |        1
    1678000 |    6234000 |  1200 |   1200 |     15 |    -15 |     0 |     0
| 2193 |        1
    1696000 |    6234000 |  1200 |   1200 |     15 |    -15 |     0 |     0
| 2193 |        1
    1714000 |    6234000 |  1200 |   1200 |     15 |    -15 |     0 |     0
| 2193 |        1
    1732000 |    6234000 |  1200 |   1200 |     15 |    -15 |     0 |     0
| 2193 |        1
    1750000 |    6234000 |  1200 |   1200 |     15 |    -15 |     0 |     0
| 2193 |        1
...
(4704 rows)

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.

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/6c4bd33a/attachment.html>