Azteca Cityworks Upgrade Project
The 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.
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, Public Works Agency, 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 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.
Posted in Data Development, Data Conversion, Application Design, System Integration, End User Training, Needs Assessments, Desktop Application Development, Implementation Plan, Water Wastewater Utility, Public Works Agency
Tagged ArcGIS, water, public, GIS, geodatabase, design, editing, drainage, user, training, Alameda, County, Works, Agency, network, toolbar, storm, hydrologic, hydraulic, modeling, migration
Planning GIS Upgrade Project
GeoIT 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.
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 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
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.
Posted in Geodatabase Design, Data Development, Data Conversion, Water Wastewater Utility
Tagged ESRI, GeoIT, water, sewer, GIS, geodatabase, design, stormwater, Seal, Beach, Psomas, schema, distibution, collection, drainage, City
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.
Posted in Geodatabase Design, Needs Assessments, Needs Assessment Report, Water Wastewater Utility
Tagged ESRI, ArcGIS, water, utility, GIS, geodatabase, design, infrastructure, assessment, Martinez
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.
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 ArcGIS, CIS, ESRI, GDPUD, GeoIT, GeoXH, GIS, GPS, integration, irrigation, Pathfinder, public, sewer, trimble, utility, water
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 Geodatabase Design, System Design, Workplan Development, Data Development, Application Design, System Implementation, Software Installation, User Training, End User Training, Administrator Training, Needs Assessments, Application Seminar, Pilot Development, Project Management, Needs Assessment Report, Desktop Application Development, Client Type, Public Works Agency, Transportation Agency
Tagged ESRI, GeoIT, ArcGIS, geodatabase, design, infrastructure, desktop, tools, editing, stormwater, channel
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
Work Management System Development
Mr. Hoefer was the project manager and system architect for the development of a 200+ user work management system for the City of Oakland, Public Works Agency utilizing Cityworks software from Azteca Systems as the foundation CMMS software. The $1.2M, two-year project included:
- Deployment of Cityworks Desktop and Server in a high-reliability system configuration two sets of parallel (redundant) servers
- Setup of an equivalent virtualized development, test, and training system using VMware
- System configuration, including: 500 employees, 68 different work groups, 280 service request templates, 300 work order templates, 340 unique tasks, and 16 department-specific map services (ArcGIS Server)
- User training for over 200 call takers, work supervisors, and work crew leaders
- System rollover from an aging call system and paper-based systems (log books) for work activities
- Deployment of over 100 field-based laptops (Panasonic Toughbook C-19) connected through Sprint Wireless
- 125-vehicle AVL deployment (Network Fleet) and ArcGIS Server integration
- Development, testing and deployment of a public service request intake website
The City of Oakland was one of the first major users of Cityworks Server in the country. The System has been well-received by City users, with new roles and users being added each year, and has provided significant financial and logistic benefits to the City.
Posted in Administrator Training, Application Design, Application Seminar, Cityworks Implementation, Client Type, Communcation Plan, Data Conversion, Data Development, Desktop Application Development, End User Training, Geodatabase Design, Hardware Installation, Implementation Plan, Mobile Application Development, Needs Assessment Report, Needs Assessments, Networking, Pilot Development, Project Management, Project Scheduling, Public Works Agency, RDBMS Setup, 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 ArcGIS, assessment, AVL, Cityworks, CMMS, design, enterprise, ESRI, fail-over, GIS, information, infrastructure, integration, management, medians, Network Fleet, Panasonic, parks, public, redundancy, service request intake, sidewalks, stormwater, streets, Toughbook, traffic signals, trees, virtualizaion
Information Technology Assessment
Mr. Hoefer was the lead consultant and project manager for an in-depth information technology assessment of a complex electronic database (system) being used by several divisions of Caltrans. He directed the technical research, conducted dozens of team interviews, compiled the resulting information, and progressively presented the results to a steering committee over the course of the 10-month project. Mr. Hoefer developed a series of enhancement recommendations that could accomplished within the available implementation funding and time window, as well as a long-term vision for an eventual replacement component architecture based upon Server Oriented Architecture (SOA) design principles. The project was well-received by the steering committee as the team was able to present highly complex subject material in an easily digestible fashion leading to a full consensus on the technological path forward.
Posted in Geodatabase Design, System Design, Workplan Development, Application Design, Needs Assessments, Stakeholder Interviews, Workflow Analysis, System Architecture, Project Management, Project Scheduling, Communcation Plan, Needs Assessment Report, Strategic Plan, Implementation Plan, Client Type, Transportation Agency
Tagged ESRI, GeoIT, ArcGIS, integration, GIS, plan, enterprise, geodatabase, design, assessment, Caltrans, highways, needs, SOA, service, oriented, web, transportation
Asset Management Workflow Review
Mr. Hoefer provided Anchorage Water and Wastewater Utility (AWWU) with an assessment of their geographic information system (GIS) and Maximo (IBM, Inc.) integration workflow environment. Mr. Hoefer performed a technical evaluation, reviewing the business processes, data models, and IT practices from the perspective of his knowledge of the GIS/IT industry as it applies to water utilities. The assessment was to find where AWWU may have departed from mainstream practices and make recommendations as to specific steps AWWU might need to take to make adjustments and move forward with its IT development.
Mr. Hoefer first conducted a onsite review of the existing asset management workflows. The review consisted of a series of meetings and staff interviews that engaged management and end users in discussions about the workflow and data models that would show any areas of concern.
After conducting the on site review, Mr. Hoefer provided AWWU with an Asset Management Workflow Review Report, which provided an assessment of AWWU’s workflows and GIS data model as compared to other utilities and recommended steps to remedy the issues discovered and presented technical alternatives as applicable. The document was well-received by both the Engineering and IT departments at AWWU.
Posted in System Design, Needs Assessments, Stakeholder Interviews, Workflow Analysis, System Architecture, Needs Assessment Report, Client Type, Water Wastewater Utility
Tagged ESRI, ArcGIS, integration, water, sewer, utility, GIS, CMMS, enterprise, geodatabase, design, infrastructure, editing, information, management, AWWA, Maximo, workflow