Skip to Content
0
Jun 07, 2017 at 08:28 PM

HANA Spatial Predicate - ST_Covers

166 Views

I am trying to use the ST_Covers predicate in HANA to check if a particular point is covered by a shape. The point has the lat/long information for the city of San Francisco and the shape is the State of California from the "SAP_SPATIAL"."SHAPE_LEVEL_5" table. Here's the point information,

<?xmlversion="1.0" standalone="no"?><!DOCTYPE svg PUBLIC"-//W3C//DTD SVG 1.1//EN""http://www.w3.org/Graphics/SVG/1.1/DTD/svg11.dtd"><svg xmlns="http://www.w3.org/2000/svg" version="1.1" viewBox="37.774930 -122.419416 .0002 .0002"><rect width="0.1%" height="0.1%" fill="lightgrey" stroke="none" x="38.71669" y="121.36442"/></svg>
SELECT A."CITY" FROM "<schema>"."GEOPOINTS" AS AINNERJOIN"SAP_SPATIAL"."SHAPE_LEVEL_5" AS CAONCA."SHAPE_4326".ST_Covers(A."POINT_4326") = 1WHERECA."AREA_ID" = '21009408';

But I do not get any output. Isn't this how the ST_Covers predicate works?