CPJ has extensive experience in the design and implementation of database managements systems (DBMS). We have designed and implemented severalprivate stormwater management inspection programs for local jurisdictions in Maryland to assist them with meeting the National Pollutant Discharge Elimination System (NPDES) Permitting Program requirements.

The DBMS was designed to facilitate the collection of field data and photo's taken in the field. This data collected includes the condition of the structure based on a ratings system that is used to identify the severity of the deficiency or failure. In addition the database also contains the owner, property, and structure information for the facility. Some examples of the data stored would be GPS coordinates, property address, owner address, directions to the facility with map references, type of structure, inspection frequency, each date a structure was inspected and the type and results of that inspection.

Any of this data can be used for queries and reporting making it an extremely robust informational tool. The program is also used to generate future inspection schedules based on Inspections Cycles that are defined for the different type of Stormwater Management facilities. It also completely automates the process of generating correspondence letters and envelope labels to the owners of the facilities and allows the County to record their replies. In addition it allows the County to keep track of the repairs that are required to be made to each structure and the date on which they are completed. This allows the County to identify through predefined reports the facility owner's compliance status as defined by the NDPES requirements.

Another powerful feature of this DBMS is the redlining tools that are built into the program. The program provides a toolbar with different redlining tools such as lines, arrow, boxes, circles, text boxes, rubber stamps, audio clips, etc. This allows the field inspector to markup scanned as-builts of the structure noting the areas of deficiencies or failures so that the appropriate repairs can be better identified. These files are then reviewed by the County and can be used to identify recurring weaknesses in structures. This information can then be used to proactively suggest repairs or replacements for the future prevention of deficiencies or failures providing a cost savings for both the County and the facility owner.

Charles P. Johnson & Associates, Inc. is also nearing completion of a DBMS software solution for other jurisdictions interested in automating their Inspections process for meeting the NDPES requirements.