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 Application Design, Geodatabase Design, Implementation Plan, Infor Hansen Integration, Mobile Application Development, Project Scheduling, Resource Planning, Stakeholder Interviews, System Architecture, System Design, System Integration, Water Wastewater Utility, Workplan Development
Tagged ArcGIS, design, drainage, EID, El Dorado Irrigation District, ESRI, geodatabase, GeoIT, GIS, Hansen, hydro, hydro-power, implementation, Infor, integration, plan, Psomas, recycled, sewer, water
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 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
Tagged ESRI, integration, CMMS, Cityworks, needs, workflow, user, training, Sacramento, utilities, Anywhere, AMS, 2013, ArcGIS Server, 10.1, stakeholder, business process, PeopleSoft, configuration, administrator, phased, rollout
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 Geodatabase Design, System Design, Data Development, Data Conversion, Application Design, System Implementation, Software Installation, User Training, End User Training, Administrator Training, Needs Assessments, Stakeholder Interviews, System Architecture, Project Management, Project Scheduling, Needs Assessment Report, Desktop Application Development, Web Application Development, RDBMS Setup, Strategic Plan, Water Wastewater Utility, Planning Department
Tagged ESRI, GeoIT, ArcGIS, water, sewer, GIS, plan, desktop, transportation, atlas, City, Williams, Online, general, land, use, zoning, Upgrade, user, training, system, administration, requirements, report, maps
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 Geodatabase Design, System Design, Workplan Development, Data Development, GPS Data Collection, Data Conversion, System Implementation, Software Installation, System Integration, User Training, End User Training, System Architecture, Pilot Development, Project Management, Project Scheduling, Web Application Development, Client Type, Water Wastewater Utility
Tagged ESRI, GeoIT, GDPUD, GPS, trimble, ArcGIS, irrigation, CIS, integration, water, sewer, public, utility, GIS, GeoXH, Pathfinder
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 ESRI, ArcGIS, integration, public, GIS, CMMS, enterprise, design, infrastructure, stormwater, assessment, Cityworks, AVL, Panasonic, Toughbook, Network Fleet, service request intake, streets, sidewalks, traffic signals, trees, parks, medians, redundancy, fail-over, virtualizaion, information, management
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 Application Design, Client Type, Communcation Plan, Geodatabase Design, Implementation Plan, Needs Assessment Report, Needs Assessments, Project Management, Project Scheduling, Stakeholder Interviews, Strategic Plan, System Architecture, System Design, Transportation Agency, Workflow Analysis, Workplan Development
Tagged ArcGIS, assessment, Caltrans, design, enterprise, ESRI, geodatabase, GeoIT, GIS, highways, integration, needs, oriented, plan, service, SOA, transportation, web
California Healthcare Atlas
Mr. Hoefer was the manager for several projects supporting the Office of Statewide Health Planning and Development that culminated in the development of the California Healthcare Atlas.
The public-facing website provides healthcare facility patient data and statistics to healthcare professionals throughout California, allowing them to better understand their service markets. The back-end of the website is a robust dynamic data warehouse of summarized patient data constructed in Oracle.
In a later project, also managed by Mr. Hoefer, the site was expanded to include live earthquake data feeds and hospital status information so that it could be used internally within the OSHPD Emergency Operations Center.
Posted in System Design, Workplan Development, Data Development, Data Conversion, Application Design, System Implementation, Software Installation, System Integration, User Training, Administrator Training, Needs Assessments, System Architecture, Pilot Development, Project Management, Project Scheduling, Needs Assessment Report, Web Application Development
Tagged ArcGIS, integration, public, GIS, portal, enterprise, geodatabase, design, warehouse, healthcare, atlas
Water Rights Information Management System
Mr. Hoefer was the system architect and senior manager for a project to develop a web-based mapping software component to the Water Rights Information Management System replacement project (eWRIMS). The web-mapping application allows Water Board Division of Water Rights staff to more efficiently manage and query spatial information about water rights.
In a significant follow-on project, Mr. Hoefer managed a team that developed a set of desktop and GPS tools that support the digitization and field-based capture of place-of-use information associated with each water right.
Posted in Geodatabase Design, System Design, Workplan Development, Data Development, GPS Data Collection, Data Conversion, Application Design, System Implementation, Software Installation, System Integration, User Training, End User Training, Administrator Training, Needs Assessments, Application Seminar, Stakeholder Interviews, System Architecture, Pilot Development, Project Management, Project Scheduling, Risk Assessment, Needs Assessment Report, Hardware Installation, Desktop Application Development, Web Application Development, RDBMS Setup, Mobile Application Development
Tagged ESRI, ArcGIS, integration, GIS, portal, enterprise, geodatabase, web, NHD, water rights, place of use, SWRCB, eWRIMS, information, management, Server
GIS Upgrade Support Services
Mr. Hoefer was the project manager that worked with the City of Richmond, California to upgrade its existing GIS infrastructure to incorporate the latest releases of ESRI GIS software. Also requested were upgrades to the underlying foundation software (Microsoft Windows, Internet Server, and SQL Server). During this project, two new servers were added, along with some limited fail-over capacity and other backup / recovery mechanisms. One of the servers added was a reverse proxy server, which will add an extra layer of security to the City’s Internet applications.
The team completed a thorough business and user needs analysis, identifying the requirements that were unique to the City of Richmond. The team created a new design for their GIS architecture and then installed, configured, and tested the upgraded software. Once implementation was completed, the team provided on-site training, as well as administrative documentation to facilitate technology transfer.
In a follow-up effort, Mr. Hoefer was the Senior Consultant for a project to upgrade eight of the Richmond’s internal and external ArcIMS-based websites to ArcGIS Server using Latitude Geographic’s GeoCortex application software framework.
Posted in System Design, Workplan Development, Application Design, System Implementation, Software Installation, System Integration, User Training, Administrator Training, Needs Assessments, System Architecture, Project Management, Project Scheduling, Hardware Installation, Networking, Web Application Development, RDBMS Setup, Geocortex Implementation
Tagged ArcGIS, public, portal, enterprise, design, web, Server, website, GeoCortex, implementation, ArcIMS, Richmond