City of Sacramento Department of Utilities

Posted on June 13, 2013 | Comments Off

Azteca Cityworks Upgrade Project

City of Sacramento LogoThe City of Sacramento Department of Utilities has awarded a contract to GeoIT Resources, Inc. to perform a system-wide upgrade of the Department’s existing Computerized Maintenance Management System (CMMS) based upon Cityworks Anywhere 4.5 (desktop based)  to  server-based Cityworks AMS 2013.

As part of the upgrade effort, the development team will be conducting a stakeholder needs assessment and workflow analysis to fully leverage the new environment and significantly streamline maintenance management workflows.  Major tasks to be performed on the eight-month project include:

  • Project Team Assessment and Risk Planning
  • Stakeholder Needs Analysis
  • Business Process Analysis
  • System Configuration and Integration Design
  • Configuration and Integration Development Testing
  • Server Installation and Pilot Study (test rollout)
  • System Wide User Training and Phased Roll-out
  • Project Closeout

As part of the upgrade effort, GeoIT will also be updating the Department’s Esri ArcGIS software environment from 9.3 to the latest release (10.1) and provide full CMMS integration with the City’s existing enterprise ArcSDE server.

GeoIT’s primary subcontractor on this project is Environmental Engineering & Contracting, Inc. that brings proven experience at configuring and customizing both Cityworks Anywhere and Cityworks AMS, as well as excellent workflow analysis skills.

Comments Off

Posted in System Design, Workplan Development, Data Conversion, Application Design, System Implementation, Software Installation, System Integration, User Training, End User Training, Administrator Training, Needs Assessments, Stakeholder Interviews, Workflow Analysis, System Architecture, Pilot Development, Project Management, Project Scheduling, Resource Planning, Risk Assessment, Communcation Plan, Needs Assessment Report, Web Application Development, Cityworks Implementation, Implementation Plan, Water Wastewater Utility, Public Works Agency

Tagged , , , , , , , , , , , , , , , , , , , , ,

Alameda County Public Works Agency

Posted on December 19, 2012 | Comments Off

Stormwater Geodatabase Upgrade Project

GeoIT Resources is supporting 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 to be completed by GeoIT are:

  • 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 version control and GIS data maintenance using ArcGIS 10.1 and the customized toolbar
  • Performing on-site delivery of the finalized geodatabase and tools
  • Providing on-site end-user training to ACPWA GIS storm water database maintenance staff in the new geodatabase, methods, and tools

The anticipated project duration is three to six months.

Comments Off

Posted in Application Design, Data Conversion, Data Development, Desktop Application Development, End User Training, Implementation Plan, Needs Assessments, Public Works Agency, System Integration, Water Wastewater Utility

Tagged , , , , , , , , , , , , , , , , , , , ,

City of Williams

Posted on October 30, 2012 | Comments Off

Planning GIS Upgrade Project

williamsarchlogoGeoIT has started a project to significantly upgrade the GIS system capabilities at the City of Williams, CA.   Major tasks to be completed by GeoIT are:

  • 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 tool
  • 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

The agreed upon project schedule is less than three months from start to finish.

Comments Off

Posted in Administrator Training, Application Design, Data Conversion, Data Development, Desktop Application Development, End User Training, Geodatabase Design, Needs Assessment Report, Needs Assessments, Planning Department, Project Management, Project Scheduling, Public Works Agency, RDBMS Setup, Software Installation, Stakeholder Interviews, Strategic Plan, System Architecture, System Design, System Implementation, User Training, Water Wastewater Utility, Web Application Development

Tagged , , , , , , , , , , , , , , , , , , , , , , , ,

City of Seal Beach

Posted on October 30, 2012 | Comments Off

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.

Comments Off

Posted in Data Conversion, Data Development, Geodatabase Design, Water Wastewater Utility

Tagged , , , , , , , , , , , , , , ,

City of Martinez

Posted on August 22, 2012 | Leave a comment

Water System GIS Project

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

GeoIT staff will also be providing continued as-needed technical support and guidance throughout the project.

→ Leave a comment

Posted in Geodatabase Design, Needs Assessment Report, Needs Assessments, Water Wastewater Utility

Tagged , , , , , , , , ,

Georgetown Divide Public Utility District

Posted on February 7, 2012 | Leave a comment

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.

→ Leave a comment

Posted in Client Type, Data Conversion, Data Development, End User Training, Geodatabase Design, GPS Data Collection, Pilot Development, Project Management, Project Scheduling, Software Installation, System Architecture, System Design, System Implementation, System Integration, User Training, Water Wastewater Utility, Web Application Development, Workplan Development

Tagged , , , , , , , , , , , , , , ,

Rancho California Water District

Posted on February 7, 2012 | Leave a comment

GIS Strategic Plan

GeoIT supported Psomas Engineering in their development of an Enterprise GIS Strategic Plan for the Rancho California Water District.   GeoIT staff participated in the on-site needs assessment workshops, contributed to the Enterprise Requirements and Strategic Vision documents,  and were the primary authors of the Implementation (project definitions) and Technology Trends / Recommendations sections.

Twenty four (24) different design, data development, application development, and operations projects were recommended over a five-year window.  Each project description included a definition of: objectives, participants, implementation methods, resources, deliverables (outcomes), and continuing operations for each project.

GeoIT’s primary area of focus was GIS and CMMS  (Hansen) integration, as well as the overall GIS infrastructure strategic design.   GeoIT staff also provided detailed input into the budget, schedule, governance, and operations sections of the document.

→ Leave a comment

Posted in Application Design, Client Type, Geocortex Implementation, Implementation Plan, Needs Assessment Report, Needs Assessments, Project Management, Resource Planning, Stakeholder Interviews, Strategic Plan, System Architecture, System Design, Water Wastewater Utility

Tagged , , , , , , , , , , , , , , , , , , , ,