Skip to Content
avatar image
Former Member

Convert co-ordinates to well know text format in PI

hello Experts,

we have co-ordinates in WKT format in the table. e.g. 010100000000000088D326444000000064CCE154C0

When read the data from table, we are using standard function ST_ASGEOJSON() and we get the output as below

"type": "Point",

"coordinates": "[40.30333, -83.5281]"

Is there a way to reverse this, so we can convert co-ordinates to WKT format.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers