Invalid coordinates GIS

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

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.

image

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

image

···

On Wed, Dec 10, 2014 at 8:28 PM, Joao Mazuze Joao_Mazuze@chasssmt.com 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

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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Pamod

Hi Joao,

the coordinates in your image seems OK to me. Latitude must be within 90 to -90.

I guess a different orgunit is messing up. You can e.g. try to use the boundary layer, select facility level and then select a single province/district in the tree. If it works you can go district by district to localize the error.

image

···

On Wed, Dec 10, 2014 at 4:03 PM, Pamod Amarakoon pamodm@gmail.com 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


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

On Wed, Dec 10, 2014 at 8:28 PM, Joao Mazuze Joao_Mazuze@chasssmt.com 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

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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Pamod

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

image

···

On 10 December 2014 at 17:03, Pamod Amarakoon pamodm@gmail.com 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


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

On Wed, Dec 10, 2014 at 8:28 PM, Joao Mazuze Joao_Mazuze@chasssmt.com 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

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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Pamod


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@gmail.com

Skype: calle_hedberg


Hi,

Here is the attached file containing coordinates that I have set up in my dhis2 instance.

Kind regards

Locations export.xlsx (205 KB)

···

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@gmail.com 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@chasssmt.com 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

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@lists.launchpad.net

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@lists.launchpad.net

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@gmail.com

Skype: calle_hedberg


Hi,

Take a look at the attached files (7-zipped):

  • XLS file:

sheet 1 is what you sent out

MOZ_GIS.7z (120 KB)

···

On 15 December 2014 at 17:09, Joao Mazuze Joao_Mazuze@chasssmt.com 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@gmail.com]

Sent: 11 December 2014 10:33

To: Pamod Amarakoon

Cc: Joao Mazuze; dhis2-users@lists.launchpad.net; 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@gmail.com 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@chasssmt.com 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

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@lists.launchpad.net

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@lists.launchpad.net

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@gmail.com

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@gmail.com

Skype: calle_hedberg


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

image

···

On 15 December 2014 at 17:09, Joao Mazuze Joao_Mazuze@chasssmt.com 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@gmail.com]

Sent: 11 December 2014 10:33

To: Pamod Amarakoon

Cc: Joao Mazuze; dhis2-users@lists.launchpad.net; 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@gmail.com 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@chasssmt.com 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

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@lists.launchpad.net

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@lists.launchpad.net

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@gmail.com

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@gmail.com

Skype: calle_hedberg