Memorandum

City of Lawrence

Utilities Department

TO:	David Corliss – City Manager Diane Stoddard – Assistant City Manager Casey Toomay – Assistant City Manager
FROM:	Clint Miller – GIS Analyst, Utilities Micah Seybold – GIS Coordinator
CC:	Dave Wagner – Director of Utilities Mike Lawless – Deputy Director of Utilities
DATE:	December 10, 2014
RE:	Agenda Item - Data Consultation Services for the Utilities GIS Data Integration with Esri Local Government Information Model

Project Description

GIS and Utilities Staff have identified the ongoing need for the City’s water and sewer utilities infrastructure to be integrated with and maintained in the Esri Local Government Information Model (LGIM) format. Esri is the industry leader in geospatial software and data solutions. The LGIM is the current GIS data standard that State and Local entities are adopting in an effort to utilize additional applications and functionality available for their geospatial data. The water and sewer data integration with the LGIM would enhance the field staff’s ability to identify valves needed to isolate sections of water main during repair operations, geolocate water sampling data to track water quality issues in relation the water mains, and use tracing tools to identify contaminants or inflow and infiltration sources in the sanitary collections system from the field. To gain the benefits that the LGIM data integration offers, the City’s existing GIS data must be integrated with the LGIM database format and the tools configured for the City’s water and sewer data. To assist with the data integration process, GIS staff has prepared a Request for Proposal for consultation and data migration services related to the LGIM data integration project.

Project History

Utilities GIS Staff currently maintains 510 miles of water distribution and 442 miles of sanitary collection infrastructure and all related asset information within GIS and Lucity, a 3rd party integrated software and Esri Business Partner. The city’s current GIS water and sewer database structure was implemented in 2003. Esri has made numerous enhancements over the past 12 years to improve performance and functionality of the database structure. Many infrastructure tools and mapping templates have been created in the recent years that are specifically designed for the LGIM format. Lucity and other Esri Business Partners now develop GIS tools with the assumption that clients are using the current LGIM data model. Those clients not using the current LGIM format must create custom scripts or workarounds to interface with those 3rd party software solutions.

Project Details

GIS Staff has prepared a Request for Proposal to move the city’s water and sewer GIS data from its existing database format to the Esri Local Government Information Model format. The scope of services requested:

Perform a GIS Health Check to evaluate the current status and condition of the existing GIS Water and Sewer data prior to data integration.
Provide process consultation for implementation of the LGIM in our organization, given our workflow and data deployment methods.
Guide the data migration process.
Assist in setup of the Data Interoperability, an Esri extension software, to facilitate schema transformations and loading of data into the LGIM.
Recommend workflow enhancements and best practices for GIS staff that maximize data functionality and availability to staff and public.

See list of prospective service providers.

Actual project scopes, budgets and schedules will be determined as part of the requested data services.

Funding

This project will be funded by the Utilities Department 2015 Operating & Maintenance Budget.

Action

Authorization for staff to advertise a Request for Proposals, RFP# R1416, for data consultation services for the Utilities GIS Data Integration with Esri Local Government Information Model.