Tool for Compiling and ReportingInspection Data

For Provision C.6

Provision C.6

• Track all inspections in an electronic database or tabular format– Site name– Inspection date– Weather– Specific Problems– Resolution of Problems– Rationales for longer compliance time, escalation

of enforcement, etc.

Provision C.6

• Annual Reporting– Active sites < 1 acre requiring inspection– Active sites > 1 acre– Number of inspections – Number and percentage of violations– Number and percentage of enforcement actions– Number of discharges of sediment or pollutants– Number and percentage of violations corrected before next

rain event but not longer than 10 days– Number and percentage of violations not fully corrected

within 30 days

Data Management Options

• Manual transfer from inspection reports• Customized relational database• Capture information entered on forms – Manipulate captured data in Excel