Orgunit coordinates

Hello all,
which table stores coordinates to the orgunits, querying the organisaztionunit table, no such column exists.

Hi @kupa,
form version 3.32 coordinates column has been replaced by geometry in OrganisationUnit table.
This query will do the job:

SELECT name, ST_X(geometry) AS LONG, ST_Y(geometry) AS LAT FROM organisationunit where ST_GeometryType(geometry)=‘ST_Point’

@mutali Thank you, issue solved.

1 Like