[postgis-users] Inserting New SRID into spatial_ref_sys Table
elliott
elliott at cpi.com
Mon Oct 24 10:11:29 PDT 2011
I have inserted a new SRID (4978) into the spatial_ref_sys table.
However, when I run the following query, it gives an out of range
error. What I want to do is get the altitude in ECEF coordinates, but
perhaps my query is not correct.
select ST_Value(rast, ST_Transform(ST_SetSRID(ST_Point(126.5,37.5),
4326), 4978)) from srtm3 where filename='N37E126.hgt';
ERROR: value "-3616486790" is out of range for type integer
CONTEXT: PL/pgSQL function "st_world2rastercoordx" while casting return
value to function's return type
PL/pgSQL function "st_value" line 13 at RETURN
More information about the postgis-users
mailing list