coordinates not found

Support - Assistance technique
#1

​Hi all,

Trying to set up GIS in my DHIS2 instance. The GML import is successful, but then when I try to add the layer in GIS, it says “valid coordinates not found”. Any ideas of what to check?

Thanks,

Natalie

···

Natalie Tibbels, MSPH

Senior Research Assistant

410.370.5048 (cell) • natalietib (Skype)

Johns Hopkins Bloomberg School of Public Health

Center for Communication Programs • ccp.jhu.edu

#2

Hi Natalie

To which organization units have you imported coordinates? and which ones are you trying to access in GIS module?

In other words, describe what you have done. May be you are missing something. Or give example.

···

On Thu, Feb 8, 2018 at 6:57 PM, Natalie Tibbels ntibbel1@jhu.edu wrote:

​Hi all,

Trying to set up GIS in my DHIS2 instance. The GML import is successful, but then when I try to add the layer in GIS, it says “valid coordinates not found”. Any ideas of what to check?

Thanks,

Natalie

Natalie Tibbels, MSPH

Senior Research Assistant

410.370.5048 (cell) • natalietib (Skype)

Johns Hopkins Bloomberg School of Public Health

Center for Communication Programs • ccp.jhu.edu

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

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

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

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

–

Patrick Albert Chikumba
Computing & IT Department - The Malawi Polytechnic
+265 885 123 533, patrick_chikumba@yahoo.com

PhD Student
University of Oslo - Dept. of Informatics
OSLO, Norway
Cell: +47 9575 4367
Email: patricc@ifi.uio.no

#3

Hi Natalia,

in addition to Patrick’s comments, it is useful to have a look in the organisationunit table in your database and see what actually got imported, e.g. with this SQL:

select uid,name,coordinates from organisationunit;

The points should look something like this:

[-12.66,9.38]

best,

Lars

···

On 9 February 2018 at 03:41, Patrick Albert Chikumba pchikumba@poly.ac.mw wrote:

Hi Natalie

To which organization units have you imported coordinates? and which ones are you trying to access in GIS module?

In other words, describe what you have done. May be you are missing something. Or give example.

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

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

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

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

–

On Thu, Feb 8, 2018 at 6:57 PM, Natalie Tibbels ntibbel1@jhu.edu wrote:

​Hi all,

Trying to set up GIS in my DHIS2 instance. The GML import is successful, but then when I try to add the layer in GIS, it says “valid coordinates not found”. Any ideas of what to check?

Thanks,

Natalie

Natalie Tibbels, MSPH

Senior Research Assistant

410.370.5048 (cell) • natalietib (Skype)

Johns Hopkins Bloomberg School of Public Health

Center for Communication Programs • ccp.jhu.edu

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

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

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

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

Patrick Albert Chikumba
Computing & IT Department - The Malawi Polytechnic
+265 885 123 533, patrick_chikumba@yahoo.com

PhD Student
University of Oslo - Dept. of Informatics
OSLO, Norway
Cell: +47 9575 4367
Email: patricc@ifi.uio.no

–

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

#4

Thank you all. Looks like the import didn’t actually work (ignored). I’ve attached two files I tried, one simply adding a line ogr:NAMEname</ogr:NAME> and one replacing it. These are simply gml files converted from gadm.com.

Thanks for any help!​

regions_gml2.gml (91 KB)

SWZ_adm0.gml (77.3 KB)

···

Natalie Tibbels, MSPH

Senior Research Assistant

410.370.5048 (cell) • natalietib (Skype)

Johns Hopkins Bloomberg School of Public Health

Center for Communication Programs • ccp.jhu.edu

From: Lars Helge Øverland lars@dhis2.org

Sent: Sunday, February 11, 2018 10:53 PM

To: Patrick Albert Chikumba

Cc: Natalie Tibbels; dhis2-users@lists.launchpad.net

Subject: Re: [Dhis2-users] coordinates not found

Hi Natalia,

in addition to Patrick’s comments, it is useful to have a look in the organisationunit table in your database and see what actually got imported, e.g. with this SQL:

select uid,name,coordinates from organisationunit;

The points should look something like this:

[-12.66,9.38]

best,

Lars

On 9 February 2018 at 03:41, Patrick Albert Chikumba
pchikumba@poly.ac.mw wrote:

Hi Natalie

To which organization units have you imported coordinates? and which ones are you trying to access in GIS module?

In other words, describe what you have done. May be you are missing something. Or give example.

On Thu, Feb 8, 2018 at 6:57 PM, Natalie Tibbels ntibbel1@jhu.edu wrote:

​Hi all,

Trying to set up GIS in my DHIS2 instance. The GML import is successful, but then when I try to add the layer in GIS, it says “valid coordinates not found”. Any ideas of what to check?

Thanks,

Natalie

Natalie Tibbels, MSPH

Senior Research Assistant

410.370.5048 (cell) • natalietib (Skype)

Johns Hopkins Bloomberg School of Public Health

Center for Communication Programs • ccp.jhu.edu

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

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

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

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

Patrick Albert Chikumba

Computing & IT Department - The Malawi Polytechnic

+265 885 123 533, patrick_chikumba@yahoo.com

PhD Student

University of Oslo - Dept. of Informatics

OSLO, Norway

Cell: +47 9575 4367

Email: patricc@ifi.uio.no

–

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

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

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

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

–
Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

#5

Hi Natalie,

I have included one of the backend developers from the Oslo team, Henning, in this thread. He will try to help you out.

···

On Tue, Feb 13, 2018 at 3:27 PM, Natalie Tibbels ntibbel1@jhu.edu wrote:

Thank you all. Looks like the import didn’t actually work (ignored). I’ve attached two files I tried, one simply adding a line ogr:NAMEname</ogr:NAME> and one replacing it. These are simply gml files converted from gadm.com.

Thanks for any help!​

Natalie Tibbels, MSPH

Senior Research Assistant

410.370.5048 (cell) • natalietib (Skype)

Johns Hopkins Bloomberg School of Public Health

Center for Communication Programs • ccp.jhu.edu

From: Lars Helge Øverland lars@dhis2.org

Sent: Sunday, February 11, 2018 10:53 PM

To: Patrick Albert Chikumba

Cc: Natalie Tibbels; dhis2-users@lists.launchpad.net

Subject: Re: [Dhis2-users] coordinates not found

Hi Natalia,

in addition to Patrick’s comments, it is useful to have a look in the organisationunit table in your database and see what actually got imported, e.g. with this SQL:

select uid,name,coordinates from organisationunit;

The points should look something like this:

[-12.66,9.38]

best,

Lars

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

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

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

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

–

On 9 February 2018 at 03:41, Patrick Albert Chikumba
pchikumba@poly.ac.mw wrote:

Hi Natalie

To which organization units have you imported coordinates? and which ones are you trying to access in GIS module?

In other words, describe what you have done. May be you are missing something. Or give example.

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

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

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

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

–
Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

On Thu, Feb 8, 2018 at 6:57 PM, Natalie Tibbels ntibbel1@jhu.edu wrote:

​Hi all,

Trying to set up GIS in my DHIS2 instance. The GML import is successful, but then when I try to add the layer in GIS, it says “valid coordinates not found”. Any ideas of what to check?

Thanks,

Natalie

Natalie Tibbels, MSPH

Senior Research Assistant

410.370.5048 (cell) • natalietib (Skype)

Johns Hopkins Bloomberg School of Public Health

Center for Communication Programs • ccp.jhu.edu

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

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

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

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

Patrick Albert Chikumba

Computing & IT Department - The Malawi Polytechnic

+265 885 123 533, patrick_chikumba@yahoo.com

PhD Student

University of Oslo - Dept. of Informatics

OSLO, Norway

Cell: +47 9575 4367

Email: patricc@ifi.uio.no

–

Stian Sandvold
Software developer, DHIS2

University of Oslo

http://www.dhis2.org

#6

Hi Natalie

I have looked at the supplied files and noticed that there are coordinates in the list which are not separated with ‘,’. This applies for both files. I would try to go through the files and verify that all coordinates are properly separated and try to import the files another time. If this does not work, please reply - if you can get the logs from the server that would help.

Regards

Henning Håkonsen

henning@dhis2.org

···

On Tue, Feb 13, 2018 at 3:27 PM, Natalie Tibbels ntibbel1@jhu.edu wrote:

Thank you all. Looks like the import didn’t actually work (ignored). I’ve attached two files I tried, one simply adding a line ogr:NAMEname</ogr:NAME> and one replacing it. These are simply gml files converted from gadm.com.

Thanks for any help!​

Natalie Tibbels, MSPH

Senior Research Assistant

410.370.5048 (cell) • natalietib (Skype)

Johns Hopkins Bloomberg School of Public Health

Center for Communication Programs • ccp.jhu.edu

From: Lars Helge Øverland lars@dhis2.org

Sent: Sunday, February 11, 2018 10:53 PM

To: Patrick Albert Chikumba

Cc: Natalie Tibbels; dhis2-users@lists.launchpad.net

Subject: Re: [Dhis2-users] coordinates not found

Hi Natalia,

in addition to Patrick’s comments, it is useful to have a look in the organisationunit table in your database and see what actually got imported, e.g. with this SQL:

select uid,name,coordinates from organisationunit;

The points should look something like this:

[-12.66,9.38]

best,

Lars

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

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

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

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

–

On 9 February 2018 at 03:41, Patrick Albert Chikumba
pchikumba@poly.ac.mw wrote:

Hi Natalie

To which organization units have you imported coordinates? and which ones are you trying to access in GIS module?

In other words, describe what you have done. May be you are missing something. Or give example.

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

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

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

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

–
Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

On Thu, Feb 8, 2018 at 6:57 PM, Natalie Tibbels ntibbel1@jhu.edu wrote:

​Hi all,

Trying to set up GIS in my DHIS2 instance. The GML import is successful, but then when I try to add the layer in GIS, it says “valid coordinates not found”. Any ideas of what to check?

Thanks,

Natalie

Natalie Tibbels, MSPH

Senior Research Assistant

410.370.5048 (cell) • natalietib (Skype)

Johns Hopkins Bloomberg School of Public Health

Center for Communication Programs • ccp.jhu.edu

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

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

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

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

Patrick Albert Chikumba

Computing & IT Department - The Malawi Polytechnic

+265 885 123 533, patrick_chikumba@yahoo.com

PhD Student

University of Oslo - Dept. of Informatics

OSLO, Norway

Cell: +47 9575 4367

Email: patricc@ifi.uio.no

–

Stian Sandvold
Software developer, DHIS2

University of Oslo

http://www.dhis2.org