dhis2-users team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

On Wed, Nov 30, 2011 at 11:13 AM, Jan Henrik Øverland <
janhenrik.overland@xxxxxxxxx> wrote:

>
>
> On Wed, Nov 30, 2011 at 10:55, Sam Kasozi <kasozis@xxxxxxxxx> wrote:
>
>> ---------- Forwarded message ----------
>> From: Bogere, Tonny <inx3@xxxxxxxxxx>
>> Date: Wed, Nov 30, 2011 at 11:36 AM
>> Subject: Health Facility coordinates in DHIS2
>> To: kasozis@xxxxxxxxx
>>
>>
>> **
>>
>> I have an inventory of health facilities with longitude and latitude
>> values stored as decimal degrees. I entered some longitudes and latitudes
>> of some health facilities but they do not display in the map as points when
>> i generate the thematic layers and the facility layers
>> Questions:
>> 1. How do i import all the coordinates to the coordinates field into DHIS2
>>
> This process is documented in chapter 17 of the user manual:
> http://dhis2.org/doc/snapshot/en/user/html/ch17.html
>

The process is a bit cumbersome and needs to be improved. It assumes that
your data are in ESRI Shape format which can be converted to GML using for
example ogr2ogr. (It also assumes that you have made sure the names in your
file match exactly the names you already have in DHIS2)

In order to convert a CSV file or spreadsheet to the shape format, you can
make use of Quantum GIS
http://support.mapbox.com/kb/mapping-101/using-quantumgis-converting-a-spreadsheet-with-coordinates-for-use-in-tilemill

If you are comfortable with MS Access, may be faster to link both the
coordinate table and  the Postgres organisationunit table into Access using
an ODBC connection, but you have to make sure you enter in the right format

Knut

2. How do i get the facilities to display as points in the GIS module in
>> the thematic and health facility layers after adding them manually.
>>
> If you enter longitude and latitude for facilities through the
> organisation unit module interface they are ready to use in the GIS
> immediately. If you enter the coordinates directly in the database you will
> have to restart the server.
>
>

>
>>
>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Knut Staring
Informatics, U. of Oslo
http://hisp.uio.no
+4791880522