Showing 0 projects in 00 States



Focus Areas




  By State By Project
  • Regulated Storage Tanks Data Manage... Arkansas Dept. of Environmental Qua...
    • Zoom Out
      There are no projects in this viewport.
      Zoom out to see more.

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.



CLIENT: Arkansas Dept. of Environmental Quality

Interested in learning more?

Simon Watson

Contact Simon Watson
Windsor Solutions
(503) 675-7833 ext. 206