Featured Projects

City of Melbourne Water Utility Geometric Network

Jones Edmunds created a water utility geometric network within an ESRI enterprise geodatabase for the City of Melbourne. This network serves as a single comprehensive database of the City’s water utility network that was assembled from the City’s various data sources. It includes scanned water utility maps, digital AutoCAD files, digital as-built drawings, GPS points, and other data sources. The database is a robust inventory of the water utility infrastructure that can integrate into the City’s asset management system. The database can also bring all of these information sets back in line with current real-world facilities and reconciling duplicate data. During the process, the City wanted to maintain the actual live and working/editing geodatabase on their network in ArcSDE. To accomplish this, we accessed their network remotely and performed our edits in a version of their water geodatabase.

Destin Water Users, Inc. Cityworks Computerized Maintenance Management System (CMMS) Implementation

Keeping the utility’s infrastructure in top working order has always been a high priority for Destin Water Users, Inc. (DWU). Developing and implementing Cityworks as their AMS has helped them do just that. DWU is a member-owned utility cooperative that serves all of incorporated Destin and portions of unincorporated Okaloosa County. DWU handles the operations of all water, wastewater, and reclaimed water infrastructure for up to 45,000 people. They operate a 6.2-MGD water treatment plant, a 6.0-MGD wastewater treatment plant, 79 lift stations, 678 fire hydrants, and over 2,000 water valves. DWU identified a need for an AMS and asked Jones Edmunds to establish and implement this AMS using Cityworks Server. Jones Edmunds performed a phased implementation of Cityworks consisting of three installments. Phase I focused on Lift Stations and Warehouse (Inventory); Phase II focused on the Safety Group, Finance Group, and Field Operations; and Phase III focused on Plant Operations and the Laboratory Group. Jones Edmunds also developed a web-based purchase order application that communicated directly with Cityworks Storeroom and SQL Reporting Services. From enhanced communications and response times to better transparency and accountability, Cityworks is helping improve DWU’s ability to manage their assets and resources. For example, DWU staff are using Cityworks to track their backflow prevention inspections, capturing a potential multi-step pass or fail inspection process and all the associated pertinent information. The knowledge they are accumulating through their AMS helps DWU make more informed decisions on how to manage their assets.

Sarasota County Water and Wastewater Data Migration

Jones Edmunds updated the Sarasota County Wastewater GIS network by performing a comprehensive review of existing GIS data against scanned and rectified as-built documents, which included 208 record sets consisting of 1,484 sheets. Utility assets mapped during this effort include:

• 3,700+ water meters
• 500+ fire hydrants
• 90 miles of water distribution and transmission lines
• 375+ manholes
• 35+ lift stations and vacuum pumps
• 18+ miles of force main and vacuum sewer lines
• 587+ reclaimed water meters
• 24+ miles of reclaimed water lines

Our efforts also included migrating the underlying wastewater data from as-built documents (scanned TIFFs) into the County’s existing geodatabase. In addition, we spatially adjusting the scanned as-builts provided by the County and digitizing relevant utility data into the geodatabase.

Charlotte County Enterprise GIS Implementation/GIS Spatial Assessment

Jones Edmunds developed a comprehensive geodatabase of Charlotte County Utilities’ (CCU) water, reclaimed water, and wastewater networks. The effort involved geodatabase design and data migration (from AutoCAD and several non-spatial data sources) as well as utility-wide field data collection. The resulting work products also serve as a cornerstone for the County’s asset and work order management system, DataStream. The following steps were required to develop and deploy the CCU water/wastewater (W/WW) geodatabase:

• Project Initiation and Data Research
• Geodatabase Design and Development
• Including conducting Geodatabase Workshops with CCU
• Migration Plan and Protocol
• Data Migration
• Field Data Collection (Sub-Foot GPS) – 19,000 Points
• Horizontal Adjustment
• Application Development Feasibility Analysis
• Including developing a CAD Data-Migration Tool
• Final Geodatabase Spatial Refinement
• Including developing a fully connected geometric network
• Geodatabase Implementation
• Develop Standard Operating Procedures (Office and Field)
• Provide Training

Jones Edmunds deployed an Enterprise Geodatabase and provided CCU with the tools and training to further maintain and develop their W/WW data. The developed Standard Operating Procedures provided CCU with a detailed and repeatable approach to continue field data collection efforts along with desktop data integration and editing of Geographic Information System data. The W/WW geodatabase has been integrated with the DataStream product to allow work orders to be issued against W/WW facilities in the geodatabase, resulting in an Enterprise solution for Charlotte County Utilities.

St. Augustine Geodatabase Implementation

High-tech GIS is thriving in a city founded in 1565. The quaint historic city of St. Augustine, Florida is running today on geospatial information that enhances operations, improves decision making, and provides better public service. The city needed a technology enhancement by converting from a personal geodatabase for their GIS to one based on central enterprise. Jones Edmunds was selected to put together a plan and a strategy for implementation. To begin this information upgrade, we attended multiple on-site meetings with city personnel to discuss current work and data flows and our team delivered thorough recommendations to streamline a once cumbersome, inefficient process. After rolling out an upgrade to software, new servers, and training, St. Augustine was able to make well-informed decisions and better serve its residents as well as its many visitors.