Showing 0 projects in 00 States



Focus Areas




  By State By Project
  • Environmental Health Warehouse Hawaii State Dept. of Health
    • Zoom Out
      There are no projects in this viewport.
      Zoom out to see more.

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.


CLIENT: Hawaii State Dept. of Health
DISCIPLINES: Cross-discipline

Interested in learning more?

Jason Bunker

Contact Jason Bunker
Windsor Solutions
808.447.3100 x203