About Us:
The City of Lawrence Utilities Department is a municipality owned water / wastewater operator that supplies service to approximately 89,000 residents and wholesale water services to two state universities and five rural water districts.
The department maintains two water treatment plants, two wastewater treatment plants, 510 miles of water distribution infrastructure and 442 miles of sanitary collection system piping.
Our GIS System:
Our organization is currently on the Enterprise Licensing agreement with ESRI. We maintain a SQL / SDE database in a multi-editor, versioned database environment with a default database with master and edit child versions. GIS data is reconciled and posted, then published to all users via a one-way read only replica. All GIS Data is edited by two GIS staff, with data being collected by field staff via ArcGIS Online using android tablets and precisions GPS rovers.
Objective:
The City of Lawrence Utilities Department seeks to move its Water and Sewer data from a much earlier version (pre-water 8.0) of the ESRI water and sewer data model to the current LGIM format (10.2). GIS staff currently maintains one way connectivity between our SDE water / sewer network with Lucity, a 3rd party CMMS system used for work order management. The primary objective is the migration of our existing GIS data to the LGIM. Some of the functionality that we expect to gain by migrating to the LGIM are:
· Enhanced functionality of the Utility Network Editing and Reporting toolsets, specifically the valve isolation and tracing functionality for field staff.
· Establishment of feature creation and validation rules to reduce errors when editing features and ensure connectivity within the geometric network.
· Utilize the Infrastructure Operations dataset to map and track water leaks, sanitary overflows, manhole inspection, hydrant and valve inspections, call reporting, SCADA reporting, etc.
· Utilize the Capital Planning Dataset and related tools to map pipe defects, pipe criticality, service area reports, etc.
Qualification Requirements:
· Consultant must be a current Esri Business Partner.
· Must have documented experience with Esri LGIM format (10.1 or later) that includes successful data migration, integration and deployment within a SDE/SQL Server environment.
· Must have experience in Esri/FME Data Interoperability Extension.
· Experience in 3rd party software integration with the LGIM (Lucity).
· Experience in data collection and deployment with ArcGIS Online.
Scope of Services Requested:
· Provide data migration services for implementation of the LGIM in our organization, given our workflow and data deployment methods.
· Perform a GIS Health Check of existing Water and Sewer GIS data and provide support/assistance for issue resolution.
· Assist in setup of the Data Interoperability schema transformations and loading of data into the LGIM, including the addition of any required fields that currently exist in our existing data model.
· Assist in the implementation and configuration of data reviewer, and configuring validation rules for editing workflows.
· Recommend workflow enhancements, template implementation, and best practices for GIS staff that allows us to maximize data functionality and availability to staff and public.
Deliverables:
· Our existing Water, Sewer (alternate Stormwater) data, geometric networks, subtypes (or domains) populated in the LGIM 10.2 model, provided in both File Geodatabase and XML (Schema and Data) formats.
· Any Data Interoperability (Export, Transform and Load) tools or Scripts used or created for the purposes of the data migration process.
· A Database diagram \ schematic UML, that diagrams the Datasets, Feature Classes and Relationships of our data within the LGIM.
· A “GIS Health Check” or review of our existing GIS data to identify any issues that may need to be addressed prior to data migration.
· Provide post-implementation consultation and support for a period of 90 days after live implementation of the LGIM.
Data Review:
An interactive map of our GIS data can be viewed directly on the city web site: http://www.lawrenceks.org/city_maps
A geodatabase file will also be placed on our FTP Site Located here XXXXXXXXXXXXXXXXX for data review.
If there are any questions please contact, Micah Seybold or Clint Miller at the emails below.
Micah Seybold, GISP GIS Coordinator – mseybold@lawrenceks.org
Information Technology | City of Lawrence, KS
P.O. Box 708, Lawrence, KS 66044
office (785) 832-3325 | fax (785) 832-3329
Clint J. Miller, KGISD | GIS Analyst - cmiller@lawrenceks.org
Department of Utilities | City of Lawrence, KS
720 W. 3rd St., Lawrence, KS 66044
Office (785) 832-7827 | Cell (785) 423-0485