Check what data we have available

Database with sample data is available from http://dhis2.org/downloads (select simple database h2 (version 2.0.5 under sample data)

For setting up the database: http://dhis2.org/development#databasesetup

To view the database content: http://h2database.com/ and get the download for your platform.

Go into /h2/bin and type: sh h2.sh

Set the JDBC URL to the directory of your database file i.e. dir/demo, and you're good to go.

The most relevant table: organisationunit

One organisation unit have one parent, and many children. An organisation unit can range from Ministry of Health, Province, Districts, Hospitals and Wards.

The organisationunit classes can be found under: facility/dhis-2/dhis-api/src/main/java/org/hisp/dhis/organisationunit

In order to list all organisations with the name of their organisationunit:
SELECT * FROM ORGANISATIONUNIT u, ORGUNITGROUPMEMBERS m, ORGUNITGROUP g
WHERE (m.ORGANISATIONUNITID = m.ORGANISATIONUNITID)
AND (m.ORGUNITGROUPID = g.ORGUNITGROUPID);