The Vendor is required to provide professional services to migrate the city’s existing geometric network and implement an ESRI UN data model for the city’s water distribution system.
- The database readiness assessment must identify:
• Data quality issues that must be resolved prior to migration
• Pre-migration data enhancements that would optimize data workflow and performance
• Missing data elements
• Minimum hardware requirements for locally hosted and/or cloud environments that will support the activities within the testing strategy plan
• Strategies to assist with installation, use, and modification of tools, scripts, etc. to improve data quality prior to data migration.
- Development and Finalization of Implementation Plan
• Utilizing the Database Readiness Assessment, the selected proposer will be required to develop an Implementation Plan that includes project scheduled with tasks and timelines, major milestones and dependencies, risk management considerations, project budget, and resource and staffing requirements for each of the phases of the project.  
- Data Model Design, Migration Plan and Management Plan
• Provide a data model design that best addresses the current and future needs of the City along with known future model enhancements.
• The data model design should be based on business needs, technical requirements, and industry best practices, and provide recommendations on how best to model the City’s GIS data in the Utility Network.
• Provide recommendations for, and guidance, on water modeling and a long-term strategy for Utility Network modeling scenarios.
• The data migration plan must map key elements of the database (i.e., future assets, attributes, network connectivity, relationships, 3D, and domains).
- This data migration plan must:
• Identify software applications or tools required for migrating data to the UN.
• Provide a checklist to the city of all database requirements certified as complete for approval prior to the final migration
• Include a plan to incorporate elevations from existing LIDAR sets and existing survey data into feature attributes
• Test staging database with final city approval prior to final load into the production environment
• Review and document current water distribution system GIS data management practices and workflows, including data editing, processing, publishing, and sharing.
• Recommend approach for migrating and editing workflows from ArcMap with attribute assistant to ArcGIS pro with attribute/topology rules,
• Provide recommendations for ESRI tools and processes required for ongoing data quality assurance and quality control.
• Recommend initial and future utility network data management practices including:
1. Web services for editing, publishing, viewing, and sharing UN data
2. Database administration
3. Nightly scheduled automated data processing workflows, backups, and synchronization.
- GIS system infrastructure
• Recommend server and desktop hardware and software based on current and anticipated usage patterns for the utility network.
• Recommend ArcGIS enterprise and enterprise geodatabase configuration for utility network
• Use existing city ArcGIS enterprise and enterprise geodatabase or implement separate servers and databases for UN
• Recommend utility network licensing, extensions, user types, and roles needed to support data editing and network tracing in the office and in the field.
- Provide a rate for on-site presentations.
- Contract Period/Term: 1 year
- Questions/Inquires Deadline: April 3, 2025