Skip to Content
0
Nov 21, 2017 at 03:10 PM

Convert co-ordinates to well know text format in PI

70 Views Last edit Nov 21, 2017 at 03:11 PM 2 rev

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.