× ×

Who We Are

Markets

Services

× ×

About EA

About EA

× ×

Careers

Careers

× ×

Subcontractors/Suppliers

Subcontractors/Suppliers

×

Extend the Value of Your Stimulus Funding with Asset Management

EA’s business analysts and IT professionals are also consultants, scientists, and engineers, who work directly with local governments on a daily basis to address their infrastructure needs. EA combines exceptional technical capabilities with an understanding of local government workflows and requirements along with expertise in applying best practices, solutions for asset management, database development/management, and software customization.

  • Inventory Development & Mapping
  •  
  • Workflow Analysis
  •  
  • Performance Audits
  •  
  • Application Development
  •  
  • Reporting and Documentation
  •  
  • Public-Facing Portals
  •  
  • Training
  •  
  • Financial Fiscal Forecasting

Frederick County

Enterprise Asset Management (EAM) Project Management

The county purchased a Computerized Maintenance Management System (CMMS) focused water and sewer utilities, public works, and parks & recreation. EA is served as the county’s project manager for the implementation effort and developed a cohesive statement of qualifications and high-level plan to document near-term objectives and long-term vision for the EAM. More than a dozen discovery meetings were held with over 50 county stakeholders remotely using Microsoft Teams to discuss associated services and needs. A phased approach to the CMMS implementation was defined to meet EAM objectives. The roadmap outlined procurement of other software solutions to augment the CMMS and availability of county resources for implementation.

Harford County

Meter Group Workflow Optimization

EA observed and documented the Harford County Water and Sewer Division Meter Group’s current Cityworks workflows and provided recommendations on ways to streamline and optimize those workflows. The Meter Group has 36 Service Request types and 44 active Work Order Templates.  In the Division’s current Cityworks Environment, the Meter Group has over 300,000 Work Orders.  EA recommendation included enhanced search functionality, reconfiguring service request and work order templates, developing an xml script for calculating labor rates, and GIS data configuration.

Harford County

Cityworks Schema Migration

EA performed the transformation of the existing GIS data to the esri Local Government Information Model and reconfigured the GIS data in Harford County’s Division of Water and Sewer’s Cityworks platform. The extract transfer load process included 16 sewer models and 12 water models that transferred over 140,000 water assets and 115,000 sewer assets to the new GIS schema. EA developed the quality assurance/quality control process for the transferred data to verify all models were executed as expected. Review batch job files were built to enforce business rules in the new GIS schema. EA published 38 rest services from the county’s ArcServer Environment for the new GIS features services for use in the Division’s Cityworks.  More than 20 assets were configured in the Cityworks Designer, and seven asset aliases set up for services that were using a Server Object Extension. EA transferred more than 210 work order templates to reference the new the GIS services, and migrated over 145,000 historic work orders to reference the correct specific asset from the new GIS services. 

Harford County

Department of Public Works Cityworks Implementation (Phase 1-3)

The Watershed Protection and Restoration Office (MS4 Office) had expressed an interested in exploring the use of Cityworks to manage the stormwater management triennial maintenance inspections. EA held a series of requirements meetings to document the county’s current stormwater management inspection procedures and GIS database management, identify required configuration/data manipulation, and document the current Esri platform environment. Based on the resulting requirement document, EA created a BMP Geodatabase, populated as-built information, and made the data set available via web services. The scheme was developed to allow the county’s stormwater construction inspection staff to view BMP data on a mobile device while in the field performing their triennial inspections. Using the esri field application they can track status of inspection from their MS4 reporting, and connect BMPs to as-built plans and maintenance agreements. A data dictionary documents attribute values, data sources, and data types. To assist in MS4 reporting, an Extract Transfer Load Tool and a series of Python scripts transfers the data from the BMP geodatabase to the MDE MS4 geodatabase. Two separate ETL models were created because numbering processes in the MDE MS4 Geodatabase needs to occur after the input of the new BMPs but before the input of the inspections data.  Using two separate models allows the user to populate the MDE MS4 geodatabase with the new BMPs, run the MDE BMP_ID unique primary ID for all the new BMPS, and then create new inspection entries off of the MDE BMP_ID for the inspections data.  The following section describes the models and data transfer/manipulation from the BMP geodatabase to the MDE MS4 geodatabase.

Carroll County

Utilities Asset Management System

EA supported requirements identification and validation for an asset management system for the county’s water and wastewater system. The project advanced the existing GIS into new platforms (Azteca Cityworks and Innovyze InfoMaster) to improve accessibility and usability utilities staff. With the use of Innovyze’s InfoMaster, the county gained critical insight to the condition of the utilities in order to analyze, plan for, and achieve higher productivity, quality, and operational flexibility in an optimal cost-effective manner. 

City of Winston-Salem

Asset Management

EA assisted with management and quality control for the development/migration of an asset management program from an existing technical solution to an alternative solution (Hansen to Cityworks). The project also integrated multiple city systems into the asset management program and converted legacy data. The work involved redesign of existing workflows and an implementation plan, along with a sustainment strategy, full training, and ongoing support services for the City’s asset- and work order-management program and its community development program.

×

Contact Us

EA Engineering, Science, and Technology, Inc., PBC headquarters
Name