Skip to Content

Convert co-ordinates to well know text format in PI

Nov 21, 2017 at 03:10 PM


avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers