How to fetch ST_POINTS from table?

[Former Member]

Hi,

Have created a column in a table, using datatype st_point. And inserted the latitude and longitude values accordingly:

create column table Geo (LL_POINT ST_POINT(4326));

insert into Geo values ( new ST_POINT(13.091517,80.2922916));

insert into Geo values (new ST_POINT(13.0831568,80.2827644));

Now, how to select a particular latitude and longitude record from the Geo table?

Because I can able to fetch the records using:

select LL_POINT.ST_AsWKT()  from schema.Geo;

But unable to retrive particulare records using below spatial funtions, which gives error

select LL_POINT.ST_AsWKT()  from schema.Geo where LL_POINT.ST_Contains( new ST_POINT(13.091517,80.2922916)) ) = 1;

Error:

Could not execute 'select LL_POINT.ST_AsWKT()  from schema.Geo where LL_POINT.ST_Contains( new ...' in 3 ms 323 µs .

SAP DBTech JDBC: [7]: feature not supported: Unsupported function: st_within() on the round earth Spatial Reference System: 4326 at function st_contains()

Thanks in advance!!

[Former Member]

I've run into the same problem and the unfortunate answer appears to be that most of the methods you'd want to use to calculate intersections don't work in the round-earth SRID. 

This thread seems to have turned into a collection point for what's working and what isn't in HANA geospatial:

I've tried your experiment on my brand new SPS09 and was able to reproduce it.

As for workarounds, the only suggestion I have is to use the flat-earth version, SRID=1000004326, but be aware that distance and area calculations will not be accurate.