Note: 'Needs Inspection' status is currently under review. This dashboard shows the process from inspection to treatment.
Air Site Status Map
Status Summary
Status Definitions
Air Site Status Definitions:
- Not Insp: Sites that have not been inspected or have no recent inspection data
- Insp - Under Threshold: Sites inspected with larvae count below threshold (no treatment needed)
- Needs ID: Sites with Dip >= threshold, samples sent to lab for red/blue bug identification
- Needs Treatment: Sites with red bugs found in lab analysis (require treatment)
- Active Treatment: Sites who received treatment < effect_days ago according to material type
Treatment Logic:
- Sites with Dip >= threshold -> lab for species identification
- Red bugs found -> treatment required (species that bite humans)
- Blue bugs found -> no treatment needed (species that don't bite humans)
- Active treatments last for BTI effect days (default varies by material)
Site Details
Status filter only affects the flow chart visualization.
Calculation Notes
Treatment Process Metrics:
- Treatment Rate: Active Treatments / (Needs Treatment + Active Treatment) x 100%
- Treatment Completion: Active Treatments / (Needs Treatment + Active Treatment) x 100%
- Inspection Coverage: (Insp + In Lab + Needs Treatment + Active Treatment) / Total Sites x 100%
Lab Processing Metrics:
- Total Insp Samples: Number of inspected sites with completed lab results
- Red Bug Detection Rate: (Red Bugs Found / Total Samples) x 100%
Note: Total samples = only completed lab samples with timestamps. Pending samples are excluded.
Treatment Flow by Facility
Process Summary
Facility Treatment Process Details
This analysis shows inspection history and treatment volumes over the selected date range.
Calculation Notes
What is Counted:
- Inspections: Action code 4 (AIR inspection) from dblarv_insptrt tables
- Treatments: Action codes 3 (Ground), A (AIR), D (Drone) from dblarv_insptrt tables
- Red Bug Inspections: Inspections where lab samples show has_red_bugs = TRUE
Metric Calculations:
- Total Inspections: Count of all AIR inspection records within date range
- Total Treatments: Count of all treatment records within date range
- Red Bug Ratio: (Red Bug Inspections / Total Inspections) x 100%
- Treatment/Inspection Acres: Sum of site acres for respective records
Note: Only includes air sites (air_gnd = 'A') that were active during the operation date.
Treatment Volume Trends
Red Bug Detection Over Time
Site Inspection History
Red Bug Ratio = (Red Bug Inspections / Total Inspections) x 100%