Re: [Dhis2-devs] [Dhis2-users] Export hierarchy coordinates

2015-12-17 Thread Pepe Ken Mvulu
Hi Jim, Great, query worked perfectly ! Thanks a lot, Pepe Ken Mvulu 2015-12-17 16:28 GMT+01:00 Jim Grace : > Hi Pepe, > > The resource table _orgunitstructure can help you out. There is one row in > this table for every organisation unit in the system, and it has references > to all the high

Re: [Dhis2-devs] [Dhis2-users] Export hierarchy coordinates

2015-12-17 Thread Jim Grace
Hi Pepe, The resource table _orgunitstructure can help you out. There is one row in this table for every organisation unit in the system, and it has references to all the higher-level organisation units (if any) above that org unit. Just make sure that the resource tables are refreshed after you

Re: [Dhis2-devs] [Dhis2-users] Export hierarchy coordinates

2015-12-17 Thread Pepe ken mvulu
Hi Jim, Currently we are using version 2.20, we have 7 levels of organisation unit, a map is available at Level 4 (Zone de Santé), level 6 contains the coordinates of the villages that I want to export as CVS or Excel format using a query or other procedure available. Here is a screenshot of

Re: [Dhis2-devs] [Dhis2-users] Export hierarchy coordinates

2015-12-16 Thread Jim Grace
Hi Pepe, Can you say more about what you mean by "hierarchy coordinates"? Are you talking about the GIS location of the organisation units? Or the path of ancestor organisation units from each organisation unit up to the root? What exactly would you like to see and, ideally, in what format? (An ex