Featured Projects

Charlotte County Enterprise GIS Implementation/GIS Spatial Assessment

• 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

St. Augustine Geodatabase Implementation

Florida Keys Aqueduct Authority Cityworks Server Implementation and Enterprise GIS Services

Jones Edmunds was selected to support the Florida Keys Aqueduct Authority (FKAA) for a multi-phase Cityworks implementation. The first phase was a utility-wide review of business processes related to GIS and work and asset management, which included discovery meetings with 10 different departments including IT, Finance, Customer Service, and their entire operations group including lift stations, wastewater collection, water distribution, fleet, and water production. FKAA has many disparate systems including their finance and customer service software (Cogsdale), Esri GIS, CCTV, and SCADA. One of the primary outcomes of the review was the need for a Cityworks integration with their Cogsdale to reconcile fixed assets, customers and meter related work orders. Phase 2, a Cityworks implementation for their linear water system, fleet, and customer service, included the Cogsdale integration. Phase 2 also included implementation of an Enterprise GIS that included GIS database re-design, deployment, and configuration to cloud servers on Azure to ensure high availability, including ArcGIS Server and Web Adaptor. Phase 3 includes an implementation of Cityworks for their wastewater and water vertical assets, technical services, engineering, and backflow prevention with integrations with SCADA and Neptune.

Gainesville Regional Utilities Water and Wastewater/ArcFM Cityworks Implementation

Gainesville Regional Utilities (GRU) selected Jones Edmunds to conduct a needs/workflow assessment and develop an implementation plan. This implementation plan served as the roadmap to the roll-out of Azteca Cityworks and included database design, data migration, workflow re-engineering, software implementation, and training.

In addition to the existing GIS and work-order data, the GIS-centric database design had numerous considerations to be evaluated. Several independent legacy Oracle databases had to be reconciled and migrated into a common relational database. Subsequent to the enterprise deployment of Cityworks, GRU has gained considerable benefits, including but not limited to a significant reduction of the time associated with entry, analysis, and report generation of service requests and work orders. GRU now plans to make further use of the benefits gained by the Cityworks implementation.  Jones Edmunds worked with GRU to update the initial needs assessment and implementation plan.  GRU has been improving system monitoring, planning, and proactive maintenance by further using Cityworks, saving the utility and its customers money.

Jones Edmunds helped implement an ArcFM 8.2/CityWorks 4.0-based solution for updating and maintaining the GRU Water and Wastewater Facilities Mapping and Work-Order Management Systems, converting existing coverage and hardcopy data to a GeoDatabase.  The project used a single geodatabase to support facilities management software (ArcFM 8.2), work-order management software (Azteca Systems’ CityWorks 4.0), and future applications such as hydraulic modeling.

ArcGIS and ArcFM serve as the principal mapping and data management tools for GRU’s water and wastewater infrastructure.  Existing ArcInfo coverage and hardcopy data were converted to a geodatabase that is administered by ArcSDE within Oracle.  The GDB is available to users of ArcFM and Cityworks to support facility-mapping, work-order, and facility-maintenance functions. We developed custom procedures to enable GRU staff to incorporate as-built data into the GeoDatabase—a process currently contracted out.