Hi team,
how can I query (SQL view) and display geo-coordinates in 2.33 like it used to be in previous versions like this:
select ou.name, ou.uid, ou.code, ou.coordinates, oustr.level, gsstr.“Facility Type” as factype, gsstr.“Facility Ownership” as facownership, (select name from organisationunit where organisationunitid=oustr.idlevel2) as chiefdom, (select name from organisationunit where organisationunitid=oustr.idlevel3) as district from _orgunitstructure as oustr join organisationunit as ou on oustr.organisationunitid=ou.organisationunitid join _organisationunitgroupsetstructure as gsstr on ou.organisationunitid=gsstr.organisationunitid where oustr.level >= 4 order by chiefdom, district, factype, facownership, ou.name limit 300;
I have replaced coordinates with geometry but I can’t get it to work, and a normal query brings unreadable format in results.
I need to get the latitude and longitude in the results.
Thanks