Specifications include, but are not limited to: The City of Columbus, Ohio is soliciting Proposals (hereon referred to as RFP) pursuant to Columbus City Codes from experienced professional consulting/geospatial firms to migrate from the geometric network (GN) data model and implement Esri’s Utility Network Model (UNM). DPU maintains separate geodatabases for sewerage (sanitary, combined, and stormwater), water, and electric -- each with its own existing geometric network (GN). The scope of services follows; however, the consultant is encouraged to suggest deletions or additions within their Understanding of the Project/Project Approach if they believe changes will better meet the objectives of the project. 2.1. Perform Data Readiness Assessment: Identify gaps, irregularities, data cleanup efforts in city's technical environment and data structures to develop a high-level implementation plan. Identify level of effort to match UNM connectivity rules. Identify schema 'mapping' for layers, asset types, attribute fields, domains, relationships, tables, etc. Identify steps to take before go-live such as feature class layer consolidation, etc.; 2.2. Perform Preliminary Assessment: Produce a deliverable of recommended project approaches along with pros/cons of each; 2.3. Perform Organizational Readiness Assessment: Assess the organization’s readiness, review its geospatial data model. 2.4. System Architecture Review: Provide Columbus’ Department of Technology information to properly configure its servers and desktops to handle the UNM’s capabilities; 2.5. Implementation Planning: Create implementation plan with details relating to configuration, data schema and settings, and identify additional functionality of benefit to our users. Note: We are interested in using Esri’s planned 'Combined' sewer and stormwater UNM data model once released (2024 target); 2.6. Data Migration: Perform migration of data into UNM compliant format. Notes: Coordination with ongoing Cityworks asset migration project team will be required. Consultation with Schneider Electric is expected due to ArcFM data model for Electric; 2.7. Integrations & Third Party Applications: Support integrations with applications currently using the GN for tracing, listed above in in Section 1.3.2; 2.8. Training: Provide on-site and/or virtual training for approximately 20 users/ data editors before, during and after go-live; 2.9. Schedule & Cost: A Statement of Work (SOW), including schedule and cost will need to be developed by the selected consultant; 2.10. Desired Go-Live: Go live by October 1st, 2027 in all three utilities.
