[postgis-users] ST_Value

[Mateusz Łoskot]

On 25 October 2011 17:39, maduako ikechukwu <iykemadu84 at gmail.com> wrote:
>  I tried to extract the elavation value of a particular location on the SRTM
> data i loaded on my database
> using the following command
> SELECT ST_Value(rast,ST_Point(-106.2,38.6)) AS Elevation
>  From srtm;
>
> but it only brought out a long  elevation column with no value shown.
> What could be the issue?

There is no issue here. You get integer value as it is expected.

ST_Value(raster, location) => value of pixel at given location of given raster

Best regards,
-- 
Mateusz Loskot, http://mateusz.loskot.net
Charter Member of OSGeo, http://osgeo.org
Member of ACCU, http://accu.org