dhis2-kenya team mailing list archive

[Ola Hodne Titlestad <olati@xxxxxxxxxx>]

Hi all,

I have been doing some cleaning in the database, more precisely removed all
duplicate or not valid MFL codes (orgunit code) and all invalid GIS
coordinates. The main work is now to start putting in the missing codes and
coordinates, *in the correct and valid formats*.

*Facility codes*
I have been cleaning up the duplicate and invalid orgunit codes in the
database and as of now there should be no duplicate codes.

There are now 278 facilities in the DHIS that are missing the MFL code. See
the attached spreadsheet (first tab) for the list of facilities with missing
codes. This should probably be split up by district and distributed so that
the district can fill in the missing codes themselves.

I have removed all codes from orgunits at other levels as only facilities
(level 5) actually have valid 5 digit MFL codes. It would probably also be
useful to have some kind of coding system also for province, county,
district, and community units (level 6), but for now I kept these blank.

Unfortunately the DHIS 2 does not require a code to be put in when adding a
new orgunit (some countries do not have such a facility coding system), but
we need to enforce the practice at the districts to do so. And it is
important that the code is the MFL code and nothing they just make up (this
has happened!). If the facility is not in MFL then it must be added there
first. I know this is the procedure you have already been pushing at the
districts, but I think some districts need a reminder.


*Facility coordinates*
I have also cleaned up the facility coordinates which had many problems.
There were around 300-400 invalid facility coordinates in the database, all
leading to the facility layer to fail loading in GIS (any area/boundary with
at least 1 invalid coordinate failed to load). You will now see that you can
load the facility layer for any boundary, even using Kenya to see all
facilities in the country. There are only about 1200 facilities in the
database, so a lot of work is still needed to get a fully functional
facility layer in the GIS. The same attached spreadsheet (second tab)
includes a list of the facilities that are missing GIS coordinates, totally
6721. When filling in, or asking the districts to fill in the missing
coordinates remember to use the correct format for these coordinates. Any
invalid format will again cause the GIS to fail loading the facility layer.
I have a script at the server that I can run to remove all invalid
coordinates, and I will continue to run this regularly to make sure GIS is
working fine.

The correct format for a facility (Point) coordinate is:

[longitude,latitude]  e.g. [39.85,2.83]  (more decimals are allowed)

*These are not allowed:*
Trailing 0's e.g.  [039.85,2.83]
'+' symbols e.g. [39.85,+2.83]
Numbers without brackets: e..g  39.85,2.83 or (39.85,2.83)
Too many '.' e.g. [39.85.1,2.83]
Missing ',' separator [39.85 2.83]
Any non-numeric character e.g. [Ola39, Lars2.83]

Believe me, I have seen all these invalid types already, and they keep
coming in....
I am discussing with Jan, the GIS developer how to make it easier for the
users to put in valid coordinates, and I think we will have a better
solution in place for the next release (mid October), but we need to tell
the districts right away how to do this correctly.

Ola
--------


----------------------------------
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps
link<http://maps.google.com/maps?f=q&source=s_q&hl=en&geocode=&q=Vetlandsvn.+95B,+0685+Oslo,+Norway>

Attachment: facilities_missing_code_and_coordinates.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet