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’
1 Like