Hazardous Waste System Migration
Missouri Department of Natural Resources partnered with Windsor to redesign the structure of its Hazardous Waste information system and to migrate this system into DB2. Additionally Windsor worked with the agency to implement the RCRA data flow on the Missouri Java version of OpenNode2 (ON2) via the exchange network into RCRAInfo v5.
Windsor worked with Missouri staff to understand their existing data structure and to then design a new database structure in compliance with the RCRAInfo v5 data structure whilst also permitting an easy migration of legacy data into the new model.
Having completed the creation of the new data structure and having populated the system with legacy data Windsor then established the Handler data flow as well as the Compliance Monitoring and Enforcement data flow to the EPA via the Missouri Java ON2 exchange network node.
Windsor then established the interface to populate the Facility Profiler environmental data warehouse with Hazardous Waste Facility records allowing for the RCRA facilities to be viewed geospatially alongside other relevant Missouri environmental interests.
Details
CLIENT: Missouri Dept. of Natural Resources
DISCIPLINES: Land
SERVICES:
PRODUCTS: