Environmental Health Warehouse
The Hawaii State Environmental Health Administration (EHA) and Windsor Solutions (Windsor) partnered to implement a facility data warehouse. The Environmental Health Warehouse (EHW) aggregates and centralizes information about facilities/sites in the state that are regulated by the administration due to activities that affect the environment. The following objectives were defined for this implementation project:
- To establish an administration-wide data sharing and reporting foundation and environment
- To assist with internal program coordination needs (e.g., permit reviews, inspections, enforcement, etc.)
- To facilitate data quality improvements
- To define and set up a common technical infrastructure for cross-administration use
Naturally, some facilities are duplicated across multiple systems. Information about these facilities is most likely stored in separate databases operated by different programs within EHA. When the information is loaded into the EHW database, the facility is also then listed twice. Windsor's implemented solution allows for the reconciliation of any duplicate facilities. This advanced capability allows the administration to make sure the best information is presented to the systems users. Most users will access the EHW using the Inquiry or Map Viewer applications that reflects the final, cleaned and corrected facility information viewpoint.
EHW includes the following main components:
- Enterprise level geospatial information system
- Sophisticated tabular and geospatial search engine
- Graphing capabilities
- Data reconciliation engine
- Application administration
- ETL sub-system
The EHW implementation demonstrates Windsor's ability to work with a client to establish the appropriate strategic direction and infrastructure that will satisfy their integrated data access needs and do so with the foresight for future development and integration of new systems and solutions.
Details
CLIENT: Hawaii State Dept. of Health
DISCIPLINES: Cross-discipline
SERVICES:
PRODUCTS: