Eastern Municipal Water District

Eastern Municipal Water DistrictGeoIT is supporting Psomas Engineering, Inc. in their project to provide Eastern Municipal Water District with documentation and training in the use of Global Positioning Satellite (GPS) methods and procedures to enhance their Geographic Information System (GIS) water distribution valve locations.
GeoXHdownload

GeoIT staff has developed and documented procedures to download/upload valve data to and from an Esri geodatabase using Trimble GPS Pathfinder Office, including post-processing of GPS information for improved accuracy.   GeoIT staff has also developed procedures supporting in-the-field capture of improved GIS valve locations using TerraSync running on the district’s existing GeoXH GPS units.

City of Sacramento Department of Utilities

Azteca Cityworks Upgrade Project

DOU LogoGeoIT Resources, Inc. is supporting the City of Sacramento Department of Utilities in a system-wide upgrade of the their existing Computerized Maintenance Management System (CMMS) based upon Cityworks Anywhere 4.5 (desktop based)  to  server-based Cityworks AMS 2013.

SacDouWorkflowsAs part of the upgrade effort, the development team conducted a stakeholder needs assessment and workflow analysis to fully leverage the new environment and significantly streamline maintenance management workflows.

The upgraded Cityworks Server AMS 2013  servers are now in production and being utilized by the Wastewater group.  GeoIT is currently supporting City staff  during Q2 2014 as they take over the user training and rollout the system to the Drainage, Water Distribution, and Water Conservation groups (over 100 additional users).

City of Sacramento PM LayerOne of the many highlights of the project is a GIS-based preventive maintenance (PM) scheduling layer created for the Wastewater group. The City expressed the need for a better way of managing preventive maintenance schedules on individual assets. Utilizing work history and condition data within Cityworks directly-linked to the GIS gives the Wastewater group a dynamic visual of where they need to prioritize their preventive maintenance work. Work order schedulers can logically group assets into preventative maintenance work orders more efficiently based on their maintenance status within their individual target windows and proximity (geography).

Sacramento User Interface ModificationsAnother project highlight are the customized forms and panels that have been deployed. Some basic changes to the XML and CSS files made work forms more legible and utilize highlight colors to which City users were already accustomed. In addition, custom Quality Assurance panels were developed that provide a quick summary of the completion status of a work order or service request. The QA panels are useful to both the work crews in the field as an easy-to-use, color-coded, checklists and to supervisors reviewing the satisfactory completion of a work order (or service request) prior to closing.

GeoIT’s primary subcontractor on this project is Environmental Engineering & Contracting, Inc., providing proven experience at configuring and customizing Cityworks AMS.

Alameda County Public Works Agency

Stormwater Geodatabase Upgrade Project

GeoIT Resources supported Psomas Engineering, Inc. in their project to significantly upgrade the Stormwater Drainage GIS database at the County of Alameda Public Works Agency, including updated data maintenance tools / procedures and improved support for hydrologic/hydraulic modeling capabilities.   Major tasks completed by GeoIT were:

  • Project kickoff / database and application needs assessment
  • Assessment of existing GIS and modeling datasets
  • Creating a new, modernized, geodatabase design for storm water drainage and hydrology, with emphasis on support for hydrologic / hydraulic modeling
  • Developing a migration plan and source/target matrix
  • Executing the data migration from existing data sources into the new geodatabase design
  • Developing and configuring a customized Network Editing toolbar to facilitate stormwater drainage GIS editing and database integrity
  • Developing a data dictionary, including procedures for GIS data maintenance using ArcGIS 10.1 and the customized toolbar
  • Delivery of the finalized geodatabase and tools
  • On-site end-user training to ACPWA GIS storm water database maintenance staff in the new geodatabase, methods, and tools

The project was highly successful and ACPWA is now moving forward with a project to enhance it hydraulic/hydraulic modeling environment leveraging the updated stormwater drainage GIS database.

City of Williams

Planning GIS Upgrade Project

williamsarchlogoGeoIT has completed a project that significantly upgraded the GIS system capabilities at the City of Williams, CA.   Major tasks completed by GeoIT were:

  • Project Initiation and Requirements Meeting
  • Author:  User Requirements Report
  • Author:  GIS Upgrade Plan
  • Update GIS data from third-party sources (e.g. Colusia County, others)
  • Develop a new upgraded  geodatabase schema for administrative boundaries, hydrography, water distribution, sewer collection, general plan land use, zoning, and transportation
  • Migrate existing GIS data into the new upgraded design
  • Upgrade the GIS system architecture to use one centralized geodatabase and new virtualized GIS workstations
  • Update ArcGIS Desktop from 9.2 to 10.1
  • Develop and deliver new owner notification process
  • Upgrade atlas mapping tools and create new atlas maps
  • Upgrade mapping templates and create new wall maps
  • Facilitate transition to using ArcGIS Online for web mapping
  • Develop System Maintenance Guide
  • Provide user orientation seminars and training sessions

williams_fluThe project was completed within six months and within the allocated budget.

City of Seal Beach

GeoIT staff provided support to Psomas, Inc. in their project to develop an upgraded GIS for the City of Seal Beach, CA.   GeoIT developed three customized geodatabase designs and generated ready-to-load, schema-only,  databases for the City’s water distribution, sewer collection, and storm water drainage systems based upon existing City GIS datasets, design requirements from City staff and Psomas,  and industry best practices.

City of Martinez

Water System GIS Project

GeoIT Resources, Inc. supported Psomas Engineering, Inc. in their project to develop a Water System Geographical Information System (GIS) for the City of Martinez, California.   GeoIT staff led the GIS Needs Assessment and developed the Water Distribution Feature Dataset geodatabase design and working schema for the ongoing development project.

GeoIT staff have also provided as-needed technical (design) support and guidance throughout the project.

Georgetown Divide Public Utility District

GIS and Facility Mapping

GeoIT led a project and provided the majority of human resources to develop a GIS system for the Georgetown Divide Public Utility District.   Major tasks were:

  • Conducted a Project Kickoff and Geodatabase Design on-site workshop
  • Created geodatabase designs for the irrigation, water distribution, and sewer systems
  • Created a design and implementation plan for GIS and CIS integration
  • Provided GPS data collection user training to District staff
  • Supported the collection and post-processing of over 4,000 meter locations by District staff
  • Converted existing AutoCAD data into the new geodatabase
  • Produced draft atlas map books for client review of converted data
  • Processed red-line markups of draft atlas sheets, along with outstanding map updates
  • Developed procedures for export of GIS data to AutoCAD format
  • Produced new wall maps
  • Installed ESRI software and new geodatabase
  • Tested system installation and integrated with CIS (following plan)
  • Published new GIS data to ArcGIS On-line supporting field-based access
  • Recommended and provided user training

Part of the on-going project scope is to support the system for one year after project acceptance (May 2012), which includes GIS and mapping updates.