MINT Examples and Exercises

In each participant's organisation, a Data Source named Staging Area Tajikistan has been created. A domain called Land has been created in the /Ad Hoc Components/Domains folder in each organization's repository. This domain contains attributes of Land (hazards) from the IMSMA staging area from Tajikistan.
Create an Ad Hoc View based on the Land Domain and get familiar with the available data. Then, explore the data in more detail in order to find answers to the following questions:

Creating a Land Domain

1. Create a domain accessing the Staging Area Tajikistan
2. Include the following tables in the domain:
1. Hazard
2. Organisation
3. Join the two tables (which type of join? on which attribute?)
4. For now, no derived table, no calculated field and no pre-filter
5. Include and display the following attributes:

   

   

   

   

Exploring the Land Domain

1. How many hazards are there in total, by status?
2. What is the total (sum) of the areasize by hazard status?
3. Same question for the calculated area?
4. Identify those hazards where the difference between the areasize and the calculated area is big. Hint: use a table, create a custom field, sort the records
5. Is this difference somehow related to the estimation method and/or the existence of a sketch map?
6. List all the open hazards that have a high priority assigned. If you had to prioritize those now, which other attribute could you consider? This question is not about how a prioritization should be made, but about how data can be analysed in order to inform the prioritization process.
7. Based on the data available in the Land domain, which organisations seem to be active in the country?
8. Show the extent of contamination by province in an appropriate chart

One of the indicators mentioned during the brainstorming on the first day of the training is the following: Sqkm by province and device. Let's try to get this displayed step-by-step:

1. What data is missing in the Land domain to get to this indicator?
2. Edit the domain and add the required data
3. Before producing a chart, describe the relationship between a hazard and devices (in terms of one-to-one, one-to-many, etc.). What could that mean for the analysis. Hint: have a closer look at the hazard with the ID HZ TJ-24 for example.
4. What is the issue here and how could it be solved? After thoughts and discussion, click here for a possible solution.
5. Are there any other interesting measures/indicators that you would like to show based on the available data?

Including Activities (hazard reduction)

Now that we have explored the Land attributes, we would like to analyse which activities have been carried out on the hazards.

1. Edit the Land domain and include attributes from activities
1. Which tables do you need to join to the existing ones? Take into account that we would like to look into NTS efficiency, thus numbers of devices are an interesting measure too.
2. Inspect the available attributes for activities and choose pertinent ones. Hint: be sure to include the following (and others):
• end_report_period
• reduced_manual
• cleared_manual
• cleared_mdd
• area_released
• type_of_report
3. Create a new set with activity attributes, at the same level as the Land set (not a sub-set)
2. Test and explore the domain, dragging attributes from Land only, from Activity only, and then from both sets.

Template:NavBox Hub