Skip to Content
0
Jun 08 at 02:42 PM

Function ST_Centroid() does not support geometries of type ST_Point

70 Views

Hi Experts,

I am currently working on creating custom hierarchy to drill down from Country -> City on SAC geo map using HANA live. I am referring following blogs to create custom hierarchy:

HANA Live Custom Regions.pdf (sap.com)

SAC: Geo-spatial custom map hierarchy | SAP Blogs

While executing the procedure, I am facing below error :

exception 1600600: Function ST_Centroid() does not support geometries of type ST_Point at "st_centroid" function

Kindly provide your valuable inputs on how this error can be fixed.

Please note that I am populating data to "Shape" field using function "ST_GeomFromText('POINT(' || "LONG" || ' ' || "LAT" ||')', 4326).ST_Transform(3857)" not through ESRI shape files.

Regards,

Shruti