Eastern Virginia Regional GIS Repository (RRCL)

Project Summary

The Middle Peninsula region of Virginia is situated with the Chesapeake Bay to the East and the York River to the West. This geographic exclusivity lends itself to sharing and coordinating resources, such as emergency response, in the goal of being fiscally conservative and providing better services. King and Queen, Gloucester, Essex, Matthews, and Middlesex Counties were awarded a PSAP Grant from VITA, to establish a seamless regional GIS repository to support NG911.

This project will leverage Esri technology to consolidate GIS data into a regional data set using extract, transform and load (ETL) processes; quality assurance and control to validate and correct data; and a web portal that allows localities to exchange data.

Phase 1 Tasks:

  • Detailed documentation of how the system and tools will be integrated.
  • Develop a common model that represents all the locality’s geospatial needs and all CAD systems. This will consist of workshops to identify requirements of the data model and quality control.
  • Develop quality control and assurance (QAQC) methods to assess errors and warnings in both regional model and locality models.
  • QAQC issues will be corrected in locality data before migration to and from regional model will begin. Localities without GIS staff will have data corrected by Timmons Group.
  • ETL processes will convert the locality’s data into the regional model.
  • ETL processes will take the full regional data set and convert it to each localities model. The result will be a locality’s schema with all data.
  • Testing and quality assurance of processes and integration of troubleshooting methods.

Phase 2 Tasks:

  • Python Intake/output process.
  • Reporting templates and standards for data or web errors and warnings.
  • A weekly or daily digest of updated information from the web portal.
  • Testing and quality assurance of processes and integration of troubleshooting methods.
  • Server environment configured for secure services and web portal.
  • Hosting of GIS data through ArcGIS Server technologies.
  • Relational database configured with unique logins, historical backups, and versioning.
  • Portal to be used by localities to upload and download GIS data. This is the graphical interface to the intake and output processes. The dashboard will contain a web map, statistics on latest county updates, and an interface to use the tools in previous tasks.