REPORTING RELATIONAL DATABASES

LTE routinely conducts projects that involve repetitive tasks for several hundred sites at a time such as Spill Prevention, Control and Countermeasure (SPCC) Plan preparation and stormwater inspections.  In order to do this efficiently, we have developed complex relational database systems to track information and prepare reports. 

The relational databases are generally combined with a geographic information system (GIS) to provide our clients with site maps and clear, concise data presentation.

LTE has over 15 staff members who conduct routine stormwater inspections for a variety of sites, including housing developments, oil and gas facilities, and industrial sites and carry laptop computers with LTE's relational databases. Stormwater inspections are required every 14 or 30 days or within 72 hours of a storm event. The site inspections and site maps are directly input into the database while our personnel are in the field.                                                                         

   Relational Database Layout                   

 Facility Layout for SPCC

Once the information is entered by the field personnel, several reports are instantaneously generated for our clients including the inspection report, calculations of containment volumes, a list of inadequacies, identification of BMPs that are needed or have been completed, and dates of completion of work.

These reports contain all of the site-specific information required by the regulations.  In effect, we can complete the inspection and prepare all of the site-specific information for a site in a matter of minutes

 SPCC dB Project