Specifications include, but are not limited to: Phase I – Data Conversion The current 911 database shared by the three Counties will need to be transformed to meet the WLIA NG911 standard schema. Once the new schema is set, an automated workflow (ETL) will be required, for each of the three Counties, to update the current database for current 911 systems, from the NG911 schema. Current 911 systems Outagamie County: Motorola Spillman FLEX Winnebago County: Motorola PremierOne Calumet County: Motorola PremierOne The ETL script/tool will need to run in the ArcGIS Pro environment, utilizing model builder and the interoperability extension if needed. The ETL script/tool will need to be able to run within each County’s local GIS environment. Additional fields may be required, in the new schema, to support current operations and applications for local 911 systems. Phase II – Data Cleanup (optional) All relevant GIS data pertaining to the NG911 accuracy requirements will need to be manually edited to meet the new standard, with the potential exception of site/structure address points. GIS data will include, but not be limited to, the data layers listed below: ‐ Site/Structure Address Points ‐ Street Centerlines ‐ Provisioning Boundary ‐ PSAP Boundary ‐ County Boundary ‐ Fire Boundary ‐ EMS Boundary ‐ Law Boundary ‐ Incorporated Municipalities ‐ ESN ‐ MSAG ‐ ALI Effort and services required for each County will need to be monitored and recorded for billing purposes. Work directly with MSAG provider to incorporate and update MSAG data. Fully incorporate MSAG data into GIS format, resolving differences in a manner consistent with NG911 standards and ordinances. Track all record changes and identify any modification which would change a street name, address, or other record that would require public notification.
