8b. Memo - EDMS Replacement Project

COMMISSION 
AGENDA MEMORANDUM                        Item No.          8b 
ACTION ITEM                            Date of Meeting       April 27, 2021 

DATE:     April 16, 2021 
TO:        Stephen P. Metruck, Executive Director 
FROM:    Arlyn Purcell, Interim Senior Director, Engineering, Environment & Sustainability 
Sandra Kilroy, Director Maritime Environmental and Planning 
Matt Breed, Chief Information Officer, Information and Communication Technology 
SUBJECT:  Environmental Data Management System (EDMS) Replacement (CIP#801136) 
Amount of this request:               $1,215,000 
Total estimated project cost:          $1,215,000 
ACTION REQUESTED 
Request Commission authorization for the Executive Director to (1) proceed with the EDMS
replacement  project;  (2)  execute  contract(s)  for  software,  equipment,  and  vendor
implementation services; (3) use Port staff for implementation; and (4) execute a contract for up
to ten years for software license, service, and/or maintenance fees estimated at $800,000. The
amount requested for project implementation is $415,000 for a total authorization of
$1,215,000. Recurring fees will be funded in the annual operating budget. 
EXECUTIVE SUMMARY 
This project will competitively procure and implement a system that will serve as the Port's
central repository of environmental information  that includes chemistry data from soil,
sediment, and surface and ground water sampling related to environmental compliance activities
on Port properties. The new system will be used by Aviation and Maritime Environmental teams
as well as Facility and Project Management teams that rely on accurate and timely data to meet
regulatory obligations and support business needs and construction processes. 
The current system, first implemented in 2001 with only minor improvements in the last twenty
years, no longer meets Port requirements for environmental data management and vendor
support for the system is ending due to an aging technology platform. 
Information and Communication Technology (ICT) and Environment and Sustainability (ENV)
organizations will complete this project with a vendor selected through a request for proposal
(RFP) process. The capital project, originally estimated at $350,000, was included in the 2021-
2025 capital budget and plan of finance. The additional $65,000 will be added to the capital

Template revised January 10, 2019.

COMMISSION AGENDA  Action Item No. 8b                                  Page 2 of 5 
Meeting Date: April 27, 2021 
budget and plan of finance for 2022. Recurring costs estimated at $80,000 per year for up to ten
years ($800,000 total) will be budgeted in the Aviation Environment & Sustainability and
Maritime Environment & Sustainability annual operating budgets. 
JUSTIFICATION 
In 2001, after  finding  no  adequate  off-the-shelf  solutions,  the Port designed, built, and
implemented an Environmental Management Information System (EMIS) to meet Port 
Environmental Program business needs. EMIS is a relational database application based on
Microsoft Access and SQL Server technology.  It serves as the Port's central repository for 
environmental chemistry data generated from soil, sediment, surface water and groundwater
sampling activities on Port properties. Staff use EMIS's data management, analysis, and reporting
features to meet a broad range of environmental compliance tasks including regulatory agency
submittals, contaminated site assessment and remediation, stormwater discharge permit
compliance, and environmental monitoring and remediation budgeting for construction projects. 
After two decades of use, EMIS is near the end of its functional lifespan. An ageing platform and
history of ad-hoc additions to meet evolving needs has created a complicated and burdensome 
system to maintain. Retirement of the original system developer and a lack of adequate vendor
support poses non-compliance risks in the event of system failure.  The Port also seeks to
evaluate  modern  technologies  to  gain  efficiencies  and  support  current  and  emerging
environmental data management needs, objectives, and priorities. 
This project provides important benefits to meet regulatory requirements, support construction
projects, and advance the Port's environmental and sustainability goals, including: 
(1)   A fully supported system on a current technology platform will ensure continued
availability. 
(2)   Data analysis capabilities will better support contaminated site management, permit
compliance, and construction. 
(3)   Enhanced  environmental  compliance  communication  for  internal  and  external
stakeholders will improve situational awareness. 
(4)   Self-service access to prepare, submit, and search environmental information with
appropriate approval and tracking will streamline processes and reduce lag time
between collection and reporting. 
(5)   Improved controls will ensure fidelity of regulated data submittals and accuracy of
information. 
Diversity in Contracting 
Project staff are working with the Diversity in Contracting Department to determine if a direct
women-and-minority-owned business enterprise (WMBE) aspirational goal should be assigned.
Typically, subcontracting opportunities under technology projects are limited. 

Template revised June 27, 2019 (Diversity in Contracting).

COMMISSION AGENDA  Action Item No. 8b                                  Page 3 of 5 
Meeting Date: April 27, 2021 

DETAILS 
Scope of Work 
(1)   Competitively procure and implement a new EDMS system 
(2)   Migrate historical sample data into new EDMS system 
(3)   Integrate with the Port's Enterprise Geographic Information System (GIS) 
Schedule 
Commission authorization                      2021 Quarter 2 
Procurement Complete                       2021 Quarter 4 
In-use date                                       2022 Quarter 4 
Cost Breakdown                                     This Request           Total Project 
Software and Vendor Services                             $230,000              $230,000 
Port Labor                                                  $185,000               $185,000 
Total                                                           $415,000                $415,000 
ALTERNATIVES AND IMPLICATIONS CONSIDERED 
Alternative 1  Delay the purchase and implementation of a modern EDMS. 
Cost Implications: $0 
Pros: 
(1)   Capital funds are available for other projects 
Cons: 
(1)   Port staff and contractors will continue to rely on an aging technology platform with
increased risk of failure and inefficient processes. 
(2)   Improvements in data accessibility, mobile field data collection, and GIS integration are
postponed. 
(3)   Increased risk of regulatory non-compliance or additional cost if current system fails or
technology becomes deprecated beyond use. 
This is not the recommended alternative. 
Alternative 2  Purchase and implement a full-featured Environmental Health & Safety solution 
Cost Implications: $1,000,000-$2,500,000 Capital 
Pros: 
(1)   Solution potentially provides more powerful analytical reporting and forecasting tools. 
Cons: 
(1)   Cost is significantly higher than the recommended alternative. 

Template revised June 27, 2019 (Diversity in Contracting).

COMMISSION AGENDA  Action Item No. 8b                                  Page 4 of 5 
Meeting Date: April 27, 2021 
(2)   The system includes features not required by Port staff or that are covered by other
Port systems. 
(3)   Increased complexity will extend schedule and require more system administration. 
This is not the recommended alternative. 
Alternative 3  Purchase and implement an EDMS 
Cost Implications: $415,000 Capital/$800,000 Recurring Costs over 10 years 
Pros: 
(1)   Meets  Aviation  and  Maritime  requirements  for  best-practice  environmental data
management. 
(2)   Improves efficiency and effectiveness of Environmental staff and contractors who
routinely use the system. 
(3)   Leverages modern technology to improve accessibility, performance, compatibility,
scalability, security, and maintenance. 
Cons: 
(4)   Capital funds are not available for other projects. 
This is the recommended alternative. 
FINANCIAL IMPLICATIONS 
Cost Estimate/Authorization Summary              Capital        Expense           Total 
COST ESTIMATE 
Original estimate                                   $350,000               $0        $350,000 
Current change                                    $65,000               0         $65,000 
Revised estimate                                  $415,000                0        $415,000 
AUTHORIZATION 
Previous authorizations                                    0                0                0 
Current request for authorization                  $415,000                0        $415,000 
Total authorizations, including this request         $415,000                0        $415,000 
Remaining amount to be authorized                    $0             $0             $0 
Annual Budget Status and Source of Funds 
This project was included in the 2021-2025 capital budget and plan of finance estimated at
$350,000. The additional $65,000 will be requested in the funding for the 2022-2026 capital
budget and plan of finance. The project will be funded 50% Airport Development Fund and 50%
General Fund. 


Template revised June 27, 2019 (Diversity in Contracting).

COMMISSION AGENDA  Action Item No. 8b                                  Page 5 of 5 
Meeting Date: April 27, 2021 
Financial Analysis and Summary 
Project cost for analysis              $415,000 
Business Unit (BU)                  Corporate division allocations 
Effect on business performance    NOI after depreciation will increase due to inclusion of
(NOI after depreciation)             capital (and operating) costs in airline rate base. 
IRR/NPV (if relevant)                NA 
CPE Impact                       Less than $.01 in 2023 
Future Revenues and Expenses (Total cost of ownership) 
Ten-year recurring service, license, or maintenance fees, estimated at $800,000, will be budgeted
in annual operating budgets beginning in 2022. 
ATTACHMENTS TO THIS REQUEST 
None 
PREVIOUS COMMISSION ACTIONS OR BRIEFINGS 
None 











Template revised June 27, 2019 (Diversity in Contracting).

Limitations of Translatable Documents

PDF files are created with text and images are placed at an exact position on a page of a fixed size.
Web pages are fluid in nature, and the exact positioning of PDF text creates presentation problems.
PDFs that are full page graphics, or scanned pages are generally unable to be made accessible, In these cases, viewing whatever plain text could be extracted is the only alternative.