As-Needed GIS Professional Support Services

Project implementation as-needed support services for migrating to ArcGIS Utility Network and Geographic Information Services (GIS) technical services to transfer historical as-built information and editing of the existing GIS database to have all worked on information available to Operations and Engineering staff that use GIS.
- Typical scope of works to be performed – updating and Quality Assurance of field staff entered data and shapefiles that are contractor provided.
a) Tasks and updates to the data will include but not be limited to:
i. Updating spatial location to various water feature classes
ii. Updating/correcting attributes to various water feature classes
iii. Adhering to line split rules
iv. Correcting asset active/abandoned status
v. Updating connectivity/topology
vi. Focus to specific fields for attribute updates and add values to other fields when able
b) Feature classes to update include the following:
i. WFitting, WHydrant, wValve, wWaterMain, wStopbox (to maintain connectivity to service lines)
ii. SUBTYPE ◦Type of watermain – distribution, service, etc.
iii. OWNERSHIP ◦DWSD, GLWA, Other
iv. DIAMETER ◦Size of pipe in inches
v. LENGTH ◦Recorded length of pipe segment from as-built
vi. MATERIAL ◦Material of pipe
vii. INSTALLDATE ◦Date of installation
viii. STATUS ◦Active, Abandoned, Out of Service, etc.
ix. COMMENTS ◦Any comments about features as needed
x. YEARRETIRED ◦Year pipe was put out of service, removed or abandoned
xi. OPERATEDBY ◦Operator of asset – DWSD, GLWA
xii. SOURCETYPE ◦Where the information came from – as-builts, field books, section map, etc.
xiii. SOURCEREFERENCEDET ◦Name of source type from above field
xiv. INSTALLCONTRACTNUM ◦Name of contract for initial install
xv. LOCATIONDESCRIPTION ◦ Describes the location of the asset relative to the property line
- Scanning Drawings and Data Extraction (to be performed under allocated hours)
a) Conversion of an estimated 1,000 paper as-build drawings and permit cards to digital format will be performed by a consultant. The Consultant will deliver individual images for each water or sewer drawing in PDF and/or TIFF format, of sufficient resolution for the image extraction. Utilizing the converted images, the Consultant will utilize script to automate the extraction of key data from each card as necessary to update the DWSD GIS database.
b) The Consultant GIS Engineer will provide QA/QC on the scanned drawings to confirm the quality of the scans and completeness of the scanned documents. QA/QC will also be performed on the GIS database to ensure that the features that have been updated or created are accurate, complete and compliant with DWSD GIS standards and the requirements as outlined in this Scope of Work. The Consultant GIS Engineer will develop a standard set of data checks (using Data Reviewer for ArcGIS or similar tools) to validate the data, and a subset of the features will be manually reviewed. A workshop or training session will also be conducted, which will include DWSD GIS staff and other key staff as necessary and will include a review of the data and recommendations for data maintenance and update moving forward. A general technical guidance document will be provided to DWSD to accompany the final delivery of data into the DWSD GIS database.
-GIS Architect's scope of work for a Utility Network migration that will involve strategic planning, data assessment, target system design, and migration execution, ensuring a smooth transition to the new network model. This includes defining the migration strategy, assessing data readiness, designing the target system architecture, and migrating the data to the Utility Network, while also considering system performance, security, and user access:
i. Define the overall approach, including timelines, tools (like the Utility Network Migration toolset), and methods for migrating existing GIS data into the Utility Network
ii. Evaluate the quality and completeness of existing data to identify any issues that need to be resolved before migration. This might involve using tools like the UN Readiness App to pinpoint data quality problems
iii. Work with data owners to correct errors, inconsistencies, and missing information in the source data. This may involve automated or manual data cleaning processes
iv. Based on the assessment, design the new Utility Network architecture, considering factors like domain changes, authentication, security rules, and system performance.
v. Determine the structure and organization of the new Utility Network, including feature classes, attributes, domains, and relationships
vi. Map the existing data model to the new Utility Network data model, ensuring proper alignment of features, attributes, and relationship
vii. Set up the Utility Network in ArcGIS Pro or Enterprise, including enabling subnetworks and configuring advanced capabilities like tracing and editing workflows
viii. If existing applications need to be adapted to the new Utility Network, develop or modify them to ensure seamless integration with the new system
ix. If existing applications need to be adapted to the new Utility Network, develop or modify them to ensure seamless integration with the new system
x. Verify that the data has been migrated correctly, and that the Utility Network functions as expected. This includes validating network connectivity, tracing capabilities, and other key functionalities
xi. Recreate or update existing maps and web applications to utilize the new Utility Network feature service and its associated layers.
xii. Make the new Utility Network available to users, ensuring proper access and security configurations.