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 <[email protected]> wrote: > > Hi, > > Here is the attached file containing coordinates that I have set up in my > dhis2 instance. > > > > Kind regards > > > > *From:* Calle Hedberg [mailto:[email protected]] > *Sent:* 11 December 2014 10:33 > *To:* Pamod Amarakoon > *Cc:* Joao Mazuze; [email protected]; 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 <[email protected]> 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 <[email protected]> > 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 : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > > > > -- > > Pamod > > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : [email protected] > 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: [email protected] > > 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: [email protected] Skype: calle_hedberg *******************************************
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
