Regulated Storage Tanks Data Management System
Windsor was engaged by the Arkansas Department of Environmental Quality (ADEQ) to redesign and integrate a new Regulated Storage Tanks Data Management System (RST) into the ADEQ's Permit Data Management System (PDS).
The project required Windsor to convert the existing legacy Storage Tanks Data Management application into a new architecture that integrates with the existing Permit Data Management System. Permit Data Management Systemprovides users with a fresh, user friendly interface and takes advantage of many features offered by newer technologies. The result is an easy to navigate and use application that provides enhanced functionality with improved data validation and integrity checking.
Windsor conducted a traditional waterfall Systems Development Life Cycle (SDLC) including current systems assessment alongside requirements analysis and then application design activities to ensure that required legacy functions were not overlooked as part of the redesign process.
The new design adhered to existing ADEQ design standards however the application architecture adopted a style to position the ADEQ for future technological advances.
As part of the project Windsor utilized its Facility Profiler data warehouse application (nSite) to perform address cleansing and to identify duplicate facilities within and between Storage Tanks Data Management and Permit Data Management System. This resulted in a significant number of duplicate facilities being merged into single facilities.
Windsor also created and implemented a Microsoft .NET based GPS Data Import application that uploads and validates geospatial information from files generated by handheld GPS units and allows for QA/QC to be performed before loading the data to the production database;
The Regulated Storage Tanks system supports a wide array of business workflows including:
- Management of facilities.
- Management of above ground storage and underground tank information.
- Separate management of leaking underground storage tank (LUST) information.
- Management of corrective actions for leaking underground storage tanks.
- Management of eligibility certifications
- Records of tank removal and decommissioning.
- Managing compliance inspections (Substantial Operational Compliance (SOC)).
- Invoicing support
- Management of complaints
- Management of compliance including enforcement actions (CAO/NOV)
- Advanced reporting capabilities.
ADEQ now has its Tank data integrated with other program areas such as Air Quality, Mining, Tires, Solid Waste, Water and Hazardous Waste, as well as Inspections, Invoicing and Complaints and is planning to implement the FRS data flow to make this Facility data available as part of the Exchange Network.
Details
CLIENT: Arkansas Dept. of Environmental Quality
DISCIPLINES: Land
SERVICES:
PRODUCTS: