dhis2-users team mailing list archive

[Calle Hedberg <calle.hedberg@xxxxxxxxx>]

sorry, addon:

the Excel file has three sheets:
Sheet 1 is what you sent
Sheet 2 has the facility column, LON, LAT (note: DHIS2 requires LON then
LAT) - I rounded to 4 decimals at the same time. NOTE also that I checked
all the rows, and highlighted illegal/absurd coordinates in red.
Sheet 3 is a cleaned version, pure text, with all illegal/absurd coordinate
rows removed. This sheet was then saved as the .csv file.

I then imported the .csv file into ArcGIS and created the attached
shapefile.

What you now need to do is to convert that shapefile to GLM, AND MAKE SURE
THAT ALL THE NON-ASCII CHARACTERS YOU FIND IN PORTUGUESE ARE CODED PROPERLY
IN THE GLM FILE. See for instance
http://www.periodni.com/unicode_utf-8_encoding.html#german_special_characters
if you need to know the codes for various characters.

Finally, I have obviously skipped one step that you always should do before
creating the shapefile - and that is to compare the list of OrgUnits with
the DHIS2 OrganisationUnit table. You can do that using e.g. MS Access, or
PostgreSQL, or whatever other database software that supports joins. I must
admit that if your list is what you have in DHIS2, you might consider
cleaning it up quite a bit: remove full stops, colons, and other special
characters. They tend to cause problems sooner or later....

Regards
Calle

On 15 December 2014 at 17:09, Joao Mazuze <Joao_Mazuze@xxxxxxxxxxxx> wrote:
>
>  Hi,
>
> Here is the attached file containing coordinates that I have set up in my
> dhis2 instance.
>
>
>
> Kind regards
>
>
>
> *From:* Calle Hedberg [mailto:calle.hedberg@xxxxxxxxx]
> *Sent:* 11 December 2014 10:33
> *To:* Pamod Amarakoon
> *Cc:* Joao Mazuze; dhis2-users@xxxxxxxxxxxxxxxxxxx; DHIS 2 developers
> *Subject:* Re: [Dhis2-devs] Invalid coordinates GIS
>
>
>
> Pamod,
>
>
>
> Latitudes south of the equator is always negative (at least in the typical
> geographical coordinate systems normally used in dominant GIS systems).
>
>
>
> Joao,
>
>
>
> Can you please post the complete list of coordinates - seeing one sample
> does not really help (your sample definitely looks like it's somewhere in
> Moz). Also post the complete list of Organisational Units.
>
>
>
> Jan Henrik's suggestion might work, but it's very cumbersome - I prefer to
> ensure perfect alignment of OrgUnits + verify the validity of all
> coordinates (as far as you can go - occasionally funny things seems happen
> when e.g. converting to GML) BEFORE importing the data
>
>
>
> Regards
>
> Calle
>
>
>
> On 10 December 2014 at 17:03, Pamod Amarakoon <pamodm@xxxxxxxxx> wrote:
>
> Hi Joao,
>
> The lattitude value you have entered in point coordinate is a negative
> value. It needs to be corrected. Are u using a local coordinate or WGS84?
>
> Regards,
>
> Pamod
>
>
>
>
>
> On Wed, Dec 10, 2014 at 8:28 PM, Joao Mazuze <Joao_Mazuze@xxxxxxxxxxxx>
> wrote:
>
>   Dear all,
>
> I have recently set up coordinates for my health facilities, but when I am
> trying to visualize in GIS at the health facility level dhis2 throws: *“invalid
> coordinates”, *can someone help on this? I have attached a picture
> showing how my coordinates look like.
>
>
>
> Kind regards
>
>
>
>
>
> *Melhores Cumprimentos*
>
>
>
> *João Gabriel Mazuze*
>
> *National Database Manager*
>
> CHASS-SMT Project
>
> Abt Associates Inc.
>
> Av. Marginal  nº 4067
>
> Maputo -  Mozambique
>
> Fax: (+ 258) 21493525/6/8
>
> Tel:  (+ 258) 21486767
>
> Cell: (+258) 824236279
>
> www.chasssmt.com
>
>
>
> [image: Description: Description: Description: Description: Description:
> Description: Description: Description: Logotipo CHASS-SMT]
>
> *We are a project founded by PEPFAR-II  through USAID to strengthen  the
> Health System in Sofala, Manica and Tete Provinces.*
>
> *Our aim is to improve  linkages and integration of HIV to  primary health
> care and other related services in coordination with the Provincial Health
> Directorates and partners. *
>
> *Through CHASS-SMT project, the US Government supports the Mozambican
> Governament to improve  quality of health care services in the country.*
>
>
>
>
>  ------------------------------
>
> This message may contain privileged and confidential information intended
> solely for the addressee. Please do not read, disseminate or copy it unless
> you are the intended recipient. If this message has been received in error,
> we kindly ask that you notify the sender immediately by return email and
> delete all copies of the message from your system.
>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>
>
>
> --
>
> Pamod
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>
>
>
>
> --
>
> *******************************************
>
> Calle Hedberg
>
> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>
> Tel/fax (home): +27-21-685-6472
>
> Cell: +27-82-853-5352
>
> Iridium SatPhone: +8816-315-19274
>
> Email: calle.hedberg@xxxxxxxxx
>
> Skype: calle_hedberg
>
> *******************************************
>
>
>
>
> ------------------------------
> This message may contain privileged and confidential information intended
> solely for the addressee. Please do not read, disseminate or copy it unless
> you are the intended recipient. If this message has been received in error,
> we kindly ask that you notify the sender immediately by return email and
> delete all copies of the message from your system.
>


-- 

*******************************************

Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19274

Email: calle.hedberg@xxxxxxxxx

Skype: calle_hedberg

*******************************************