GIS Implementation Plan
GeoIT is supporting the El Dorado Irrigation District in their development of a tactical GIS Implementation Plan. The effort will build upon the existing GIS Strategic Plan with specific technology recommendations and implementation steps focusing on GIS geodatabase development, software platform / architecture, and applications, with a particular emphasis on achieving full Esri ArcGIS integration with Infor Hansen.
Posted in Geodatabase Design, System Design, Workplan Development, Application Design, System Integration, Stakeholder Interviews, System Architecture, Project Scheduling, Resource Planning, Mobile Application Development, Implementation Plan, Water Wastewater Utility, Infor Hansen Integration
Tagged ESRI, GeoIT, ArcGIS, integration, water, sewer, GIS, plan, geodatabase, design, implementation, Hansen, Psomas, drainage, recycled, Infor, hydro, hydro-power, El Dorado Irrigation District, EID
Azteca Cityworks Upgrade Project
GeoIT 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.
As 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).
One 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).
Another 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.
Posted in Administrator Training, Application Design, Cityworks Implementation, Communcation Plan, Data Conversion, End User Training, Implementation Plan, Needs Assessment Report, Needs Assessments, Pilot Development, Project Management, Project Scheduling, Resource Planning, Risk Assessment, Software Installation, Stakeholder Interviews, System Architecture, System Design, System Implementation, System Integration, User Training, Water Wastewater Utility, Web Application Development, Workflow Analysis, Workplan Development
Tagged 10.1, 2013, administrator, AMS, Anywhere, ArcGIS Server, business process, Cityworks, CMMS, configuration, ESRI, integration, needs, PeopleSoft, phased, rollout, Sacramento, stakeholder, training, user, utilities, workflow
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.
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 Agency, Alameda, ArcGIS, County, design, drainage, editing, geodatabase, GIS, hydraulic, hydrologic, migration, modeling, network, public, storm, toolbar, training, user, water, Works
Planning GIS Upgrade Project
GeoIT 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
The project was completed within six months and within the allocated budget.
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, RDBMS Setup, Software Installation, Stakeholder Interviews, Strategic Plan, System Architecture, System Design, System Implementation, User Training, Water Wastewater Utility, Web Application Development
Tagged administration, ArcGIS, atlas, City, desktop, ESRI, general, GeoIT, GIS, land, maps, Online, plan, report, requirements, sewer, system, training, transportation, Upgrade, use, user, water, Williams, zoning
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.
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 application, ArcGIS, California, CMMS, data, development, district, enterprise, ESRI, GeoCortex, GeoIT, GIS, Hansen, integration, plan, portal, Rancho, sewer, SOA, strategic, water
Stormwater GIS Development
Supporting a significant upgrade of the existing storm water GIS database at the City of Phoenix, GeoIT staff performed the following tasks:
- Conducted a database design and data maintenance application needs assessment through a series of on site workshops
- Authored a Findings Memorandum with the results of the workshops
- Created a new geodatabase design and database dictionary for Stormwater data using the UML template for Visio
- Created an application design documentation for a set of custom data maintenance tools based upon the ESRI Infrastructure Desktop Tools as a framework
- Programmed and QC tested the specified tools using C#.Net
- Created a pilot (training) dataset following the new geodatabase design
- Developed User and Installation & Configuration guides
- Provided train-the-trainer assistance
The tools were immediately then put into production use on the project and have been performing admirably.
Posted in Administrator Training, Application Design, Application Seminar, Client Type, Data Development, Desktop Application Development, End User Training, Geodatabase Design, Needs Assessment Report, Needs Assessments, Pilot Development, Project Management, Public Works Agency, Software Installation, System Design, System Implementation, Transportation Agency, User Training, Workplan Development
Tagged ArcGIS, channel, design, desktop, editing, ESRI, geodatabase, GeoIT, infrastructure, stormwater, tools
Strategic and Implementation Planning
GeoIT staff are on-call consultants to the Otay Water District and have provided timely GIS strategy and implementation planning support on an as-needed basis for many years. GeoIT has assisted with the District’s GIS Strategic Plan, as well as provided input on GIS and CMMS integration, cloud-based services, work management system implementation, and other topics.
Posted in Application Design, Client Type, Geodatabase Design, Implementation Plan, Needs Assessment Report, Needs Assessments, Project Management, Resource Planning, Strategic Plan, System Architecture, System Design, System Implementation, System Integration, Water Wastewater Utility
Tagged ArcGIS, assessment, Cityworks, CMMS, design, enterprise, ESRI, GeoIT, GIS, infrastructure, integration, plan, strategic, tools, utility, water