One Tam Report #2 Documentation

Updated May 9, 2018

Algorithm for Treatment Related Values

1. The treatment record search: Read record id, root record id, taxon, gross area, cover class, group, and treatment type (chemical, mechanical, other) from the specified groups in the specified date range, optionally in the One Tam area, and optionally of a particular list of plants. This search only includes treatment records.
2. Convert all area values to acres.
3. Sort by taxon. For each taxon, make a summary record for that taxon containing mechanical treated infested acres, chemical treated infested acres, other treated infested acres, GPRA treated infested acres, total treated infested acres, total treated gross acres, total gross acres, and total infested acres. The summary record accumulates observation/treatment record numbers for the three different kinds of treatment.
4. For each root record id, make a history stack summary record. Process the observation records so that each history stack record contains the largest value of gross area of any record in the stack. Combine all of the history stack records for a taxon to calculate total treated infested acres and total treated gross acres.
   Infested area is calculated from gross area and cover class. When cover class is a range, the midpoint is used, as per NAWMA standard. For instance, for the class "5 - 25" the midpoint "15" is used.
5. The summary record accumulates observation/treatment record numbers for the hours spent doing each of the three kinds of treatment. From these observation record numbers, a sum of the hours in each category is calculated as follows. There may be one or more work session records associated with an observation/treatment record, each containing person hours. The total hours spent doing a treatment is calculated by adding up the person hours of each associated work session record.

Algorithm for Mapped Values

1. The mapped record search: For each taxon, read record id, root record id, gross area, and cover class. This search uses some of the same criteria as the treatment search above (groups, optionally inside the One Tam area, optional list of taxa), but does not limit results by any time factor, and includes both treatment records and assessment records. Thus for any particular taxon, this search will always find the same or more records than the treatment search.
2. For each root record id, make a history stack summary record. Process the observation records so that each history stack record contains the largest value of gross area of any record in the stack. Combine all of the history stack records for a taxon to calculate total mapped infested acres and total mapped gross acres.

Specific Report Columns

1. Mapped Gross Acres
Sum of the largest gross area of each history stack meeting the criteria of the mapped record search.

2. Mapped Infested Acres
Sum of the infested area, calculated from the largest gross area and associated percent cover, of each history stack meeting the criteria of the mapped record search.

3. Treated Gross Acres
Sum of the largest gross area of each history stack meeting the criteria of the treatment record search.

4. Treated Infested Acres
Sum of the infested area, calculated from the largest gross area and associated percent cover, of each history stack meeting the criteria of the treatment record search.

5. Mechanical Treated Infested Acres
Same as 4. but limited to mechanical treatment.

6. Chemical Treated Infested Acres
Same as 4. but limited to chemical treatment.

7. Other Treated Infested Acres
Same as 4. but limited to other treatment.

8. Percent of Infested Acres Treated
Treated Infested Acres (4.) divided by Mapped Infested Acres (2.)

9. GPRA Treated Infested Acres
This is similar to 4., but if the same patch is treated more than once during the time period, the treated infested acres will be included each time they were treated.

10. Total Treatment Hours
Total hours spent doing any treatment.

11. Mechanical Treatment Hours
Total hours spent doing mechanical treatment.

12. Chemical Treatment Hours
Total hours spent doing chemical treatment.

13. Other Treatment Hours
Total hours spent doing other treatment.