dhis2-kenya team mailing list archive

[Ola Hodne Titlestad <olati@xxxxxxxxxx>]

Hi again,

I didn't get any response from the team in Kenya on this, but I hope you are
acting on this.

Just today I removed another 30 invalid facility coordinates that were all
causing the GIS facility layer to fail. To make sure GIS is working I delete
all coordinates on the wrong format almost every day.

Please tell all the districts that they need to be very careful when putting
in coordinates and follow the rules I described in my previous email (see
below).

Especially, call Tharaka district as they have put in invalid coordinate
formats for almost all their facilities in the last few days.

This is the format they have used:

0.28010
37.92109

Instead it has to be like this:
[0.28010,37.92109]


Please tell them to put these back in using the correct format.

Thanks,

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>


On 30 September 2011 15:06, Ola Hodne Titlestad <olati@xxxxxxxxxx> wrote:

> 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>
>