Sample SQL script for insert/update facility coordinate in DHIS2

Dear Altruist,

How can I insert / update facility coordinate directly in DHIS2(2.32), Postgres(10) database. Any sample query? I have tried following query directly in database but this does not work.

update organisationunit set featuretype=‘POINT’, coordinates=’[23.39513,90.68354]’ where name=‘Matlab-026’;

Thanks,
Sohel

1 Like