Exhibit B - Draft Statement of Work.docx

EXHIBIT B

DRAFT STATEMENT OF WORK

I. Project Description This project serves to develop a unified data dissemination tool in a web application format for the Colorado Department of Public Health and Environment’s Air Pollution Control Division. In order to better and more transparently disseminate information gathered by the Division, or readily available to the Division, to residents of Colorado, this project will build a series of hierarchical webpages and data dashboards to create a one-stop shop for all publicly available information for all relevant stakeholders in Colorado.

The value of developing this tool is to centralize all of the many data types collected by the Division for public dissemination in an easily digestible, intuitive, and educational manner. This tool will simplify access to the Division's public data by creating a single access point for this information. Having a single access point for all public information also allows to better synthesize all of the many disparate data types currently within the Division, which will provide more holistic information for stakeholders to support more informed data driven decisions.

This is an environmental and health project. Public health, safety, and welfare are endangered by the emission of air pollutants into the ambient air. Reducing pollution and improving air quality is a key part of the strategic plan for the Colorado Department of Public Health and Environment, with a vision of making Colorado the healthiest state with the highest quality environment.

II. Definitions

1. APCD – Air Pollution Control Division

2. API - Application Programming Interface

3. ATMD - Air Toxics Monitoring Database

4. ATOPs - Air Toxics and Ozone Precursor Program

5. AWS - Amazon Web Services

6. CDPHE – Colorado Department of Public Health and Environment

7. OIT - Office of Information Technology

8. PM - Project Management

III. Work Plan

Goal #1 To improve and protect the air quality in Colorado through the development and implementation of cost-effective and efficient air pollution control measures that are consistent with the requirements of state and federal law.

Objective #1 No later than the expiration date of the Contract, provide the APCD with a data dissemination web application that allows for the communication, visualization, and download functionality of a wide variety of air quality information and data that is compatible with the existing data ecosystem within CDPHE. The “system” shall include both the public-facing webpage and the supporting back-end components.

Primary Activity #1 The awarded vendor shall develop the system’s project development plan

Sub-Activities #1

1. The awarded vendor must work collaboratively with the APCD PM team to develop a project plan that includes a clear achievable phased timeline that meets the project’s deliverables and requirements of the project.

2. The awarded vendor must work collaboratively with the APCD PM team to identify key project work-groups that will be responsible for steering the development of that portion of the system development.

3. The awarded vendor must work collaboratively with the APCD PM team to establish regular project development status protocols that meet the requirements of the state.

4. The awarded vendor must work collaboratively with the APCD OIT team to ensure that the project plan meets and adheres to all security and ecosystem requirements for incorporation into the State’s existing web environment.

Primary Activity #2 The awarded vendor shall develop the overall system’s technology architecture diagram(s) and website navigation roadmap

Sub-Activity #2

1. The awarded vendor shall develop an architecture diagram that must include diagrams for all identified root level tabs shown in Exhibit D System Mockup.

2. The awarded vendor shall design a web application that includes tabs and for each tab the following must be identified on the diagram:

a. Technology connections to existing backend databases needed, and

b. Tools used to process data for display on the front-end web-page.

Primary Activity #3 The awarded vendor shall design and develop the primary infrastructure to support all of the functionality identified for the Overview tab (page 2-15) of the Mockup (Exhibit D).

Sub-Activity #3

1. The awarded vendor will build an Overview tab to include dynamic scalable panels where

a. One panel is for map customization and filtering menus,

b. One panel is a map, and

c. One panel allows for various pre-defined tiles (page 2 of Exhibit D) to communicate specific information/data/figures depending on what icon has been clicked on the map. Other layout ideas proposed will be considered.

2. The awarded vendor will design a map customization panel including, at a minimum, the menus identified on pages 3-5 of Exhibit D with the identified customization and filtering functionality.

3. The awarded vendor shall build a final product allowing APCD technical staff to modify, or update these menus and parameters as needed, which are listed below

a. The Base Map Layer Map menu, which should include selectable multiple base layer maps: at a minimum, satellite imagery (e.g. Google/ESRI...etc), hybrid map imagery (e.g. google/openstreetmaps…etc) with ability to turn on/off roads layer,

b. The Date Selection Menu, which should filter the icons on the map based on what facilities, or monitoring locations were present at the time selected,

c. The Emission Sources and Air Monitoring menus, which should filter for selected parameters and only show the relevant icons on the map.

d. The Modeling and Other Useful Layers, which will turn on and off specific modeled layers in an intelligent manner (i.e. the individual layers are additive in a methodology that makes sense), and

e. The Air Pollutant filters, which should filter for only those facilities and air monitoring locations that are permitted and are monitored for, respectively, for the specified pollutant.

4. The awarded vendor shall design the system such that the map panel is

a. the focal point of the page,

b. dynamically scalable (relative to the other panels), and

c. containing a map toolbar.

5. The awarded vendor will incorporate custom icons provided to the contractor to use for all facilities and different types of monitoring locations; including:

a. Stationary,

b. Mobile,

c. Temporary (deployed in one location for a finite period of time), and

d. Aerial.

6. The awarded vendor shall optimize the usability of the system by incorporating the following features:

a. The facility icons that have clustering functionality as the user zooms out for clarity (example),

b. The map toolbar that includes (see page 5 of Exhibit D), at a minimum:

i. A pop-out legend identifying what is currently being viewed on the map (show/hide),

ii. A reset button,

iii. A Download data button; which downloads the information currently being viewed on the map,

iv. Mapping features to include:

1. The ability for public users to add marker with label, where marker type and color are selectable and label text color, background color, and box line are user customizable,

2. The ability for public users to draw: line, circle, box, shape (where object color can be selected), and

3. The ability to stop drawing.

v. A full screen toggle, and

vi. The ability for public users to generate and save map current view image in a common image format (e.g., .jpeg, .png, .pdf, other).

vii. A user-friendly and intuitive layout that includes the content and features of Exhibit D, but is organized and built for optimal UX design

7. The awarded vendor will design a system such that all icons on the map will act as triggers to update information shown in the third dynamic panel. Based on what icon has been selected, the menus, and sub-menus will display certain pre-defined information. Examples are provided on pages 6-15 of Exhibit D.

8. The awarded vendor will deliver a system where APCD technical staff shall have the ability to modify the layers to include additional or modified facility information, updated census tract, or modelled layers that the system uses to display this information.

Primary Activity #4 The awarded vendor shall design and develop the primary infrastructure to support all of the functionality identified on the My Air Quality tab of the Mockup (page 16 of Exhibit D).

Sub-Activity #4

1. The awarded vendor will build a My Air Quality tab that will have identical functionality as the Overview Tab, but will include additional inputs to allow a user to enter an address and select a radius. Upon this selection everything outside this geofence should be filtered out.

2. The awarded vendor will enhance the My Air Quality tab by building additional intermediate data products supporting the need for additional:

a. summary information,

b. statistics, and

c. plots based on the user selected radius.

Primary Activity #5 The awarded vendor shall design and develop the primary infrastructure to support all of the functionality identified on the hot-topics tabs of the Mockup (pages 17-23 of Exhibit D). The mockup currently identifies 5 hot-topics to build for this project: criteria pollutants, air toxics, ozone, and methane. Each hot-topic tab will have a similar UI/UX. (Deliverable #5) Sub-Activities #5

1. The awarded vendor shall design each hot-topic tab to have a similar look and feel when interacting with the information presented on these tabs, including the following elements (e.g. the [Hot-topic] 101 box on pages 17-23 of Exhibit D):

a. A field to provide a high-level summary of the hot topic,

b. A field to link to educational content about the content,

c. A field to link to source content,

d. A field to link to content that addresses the question, “how is the hot-topic pollutant impacting the user?” (potentially linking back to the My Air Quality tab applying a set of pre-defined filters to only show information about the specific hot-topic), and

e. A field that links to content that addresses the question, “how is Colorado addressing [hot-topic]?” through 2 independent sections, ‘Through Regulation’ and ‘Through Monitoring’ (see page 19 of Exhibit D).

2. The awarded vendor shall develop the hot-topic tabs such that the Division will have complete control and ability to:

a. edit all content on all tabs created through this project, and

b. add and delete tabs as needed.

Primary Activity #6 The awarded vendor shall implement updates and potential enhancements to the system.

Sub- Activities #6

1. The awarded vendor shall:

a. Implement updates requested by CDPHE staff during the development and UAT.

i. CDPHE staff will submit update requests to a UAT Tracking Report.

ii. The awarded vendor shall provide updates via a UAT Tracking Report.

iii. CDPHE staff will confirm items are complete in the UAT Tracking Report.

b. Implement modifications requested by CDPHE staff during the development and UAT.

i. CDPHE staff will submit modification requests to the UAT Tracking Report.

ii. The awarded vendor shall provide updates via the UAT Tracking Report.

iii. CDPHE staff will confirm items are complete in the UAT Tracking Report.

2. The awarded vendor shall:

a. Record anomalous issues identified by CDPHE staff during UAT.

b. Implement fixes for the issues.

c. Review the fixes with CDPHE staff.

d. Save written confirmation that CDPHE staff have accepted the fix to the UAT Tracking Report.

3. The awarded vendor shall:

a. Identify compatibility of software updates to the system on notification by OIT.

b. Implement required software updates to the system.

c. Summarize these updates in the UAT Tracking Report.

4. The awarded vendor shall:

a. Identify opportunities to integrate AI to enhance user experience with the system

b. Establish an implementation plan for the inclusion of AI with CDPHE staff, based on OIT’s latest AI policies

Primary Activity #7 The awarded vendor shall provide knowledge transfer.

Sub- Activity #7

1. The awarded vendor shall develop Guidance Documents, reflecting the final version of the system, to include:

a. An internal User Manual for CDPHE staff,

b. An external User Manual for the public,

c. Video tutorials for CDPHE Staff,

d. Runbooks, and

e. Architecture Diagrams.

Primary Activity #8 The awarded vendor shall provide Monthly Summary Reports.

Sub- Activity #8

2. The awarded vendor shall develop Monthly Summary Reports that include:

a. A summary of meetings and discussions with CDPHE staff,

b. A list of tasks completed,

c. A list of tasks in progress,

d. A progress assessment, and

e. A summary of hours spent by each project staff.

Standards and Requirements

1. The content of electronic documents located on CDPHE and non-CDPHE websites and information contained on CDPHE and non-CDPHE websites may be updated periodically during the contract term. The awarded vendor shall monitor documents and website content for updates and comply with all updates.

2. The awarded vendor shall comply with OIT policies, standards and guides pertaining to AWS and OnBase Contractors.

3. The awarded vendor shall comply with OIT policies, standards and guides with regard to security procedures and accessibility needs.

4. The awarded vendor shall adhere to the needs defined in Exhibit D.

5. The awarded vendor shall comply with supporting the following:

a. Connections developed to existing data sources (e.g., the CDPHE ATMD),

b. Connections from intermediary data products to the final application,

c. Relevant connections in use by awarded vendor-developed systems, and

d. MuleSoft integrations.

6. The awarded vendor shall build intermediary data products that:

a. Apply computations,

b. Create summaries,

c. Or manipulate the original data to produce an appropriately formatted data product needed for display in the public-facing application.

7. The awarded vendor shall build intermediary data products including the following:

a. Visualizations,

b. Plots,

c. Statistics,

d. Data files, or

e. Data tables.

8. The awarded vendor shall develop guidance documents and trainings such that CDPHE may be able to manage the back-end of the application in the future, including the following:

a. Developing new connections to existing data sources (e.g., APIs),

b. Modifying existing connections to existing data sources (e.g., APIs),

c. Developing new intermediary data products,

d. Modifying existing intermediary data products,

e. Developing new connections from data products to the front-end application, or

f. Modifying existing connections from data products to the front-end application.

9. The awarded vendor shall provide the capability for CDPHE to manage the final application, including:

a. Removing existing tabs,

b. Designing new tabs,

c. Adding the connections to intermediary data products for these new tabs, and

d. Integrating these new tabs to the final application.

10. The awarded vendor shall provide role-based access to the system in compliance with CDPHE user authentication requirements.

11. The awarded vendor shall include tracking of changes implemented by CDPHE staff modifying the system.

12. The awarded vendor shall submit all deliverables to the CDPHE representative of record.

13. The awarded vendor shall adhere to state accessibility requirements.

Expected Results of Activity(s)

1. Public-facing webpage producing data visualization data exploration and data download capabilities

2. Ability for staff to add to and modify the system as needs evolve over time

3. A back-end to support this system.

Measurement of Expected Results

1. Meeting the milestones as outlined in the deliverables section below.

Deliverables

2. Scoping Summary & Plan (incl. technologies and timeline) Timeline proposed in bid.

IV. Monitoring CDPHE’s monitoring of this contract for compliance with performance requirements will be conducted throughout the contract period by the APCD ATOPs Data and Quality Assurance Unit Manager. Methods used will include a review of documentation determined by CDPHE to be reflective of performance to include progress reports, chain of custody forms, data files, data validation files, and laboratory analysis results and other fiscal and programmatic documentation as applicable. The Contractor’s performance will be evaluated at set intervals and communicated to the Contractor. A Final Contractor Performance Evaluation will be conducted at the end of the life of the contract.

V. Resolution of Non-Compliance The Contractor will be notified in writing within five (5) calendar days of discovery of a compliance issue. Within fifteen (15) calendar days of discovery, the Contractor and the State will collaborate, when appropriate, to determine the action(s) necessary to rectify the compliance issue and determine when the action(s) must be completed. The action(s) and time line for completion will be documented in writing and agreed to by both parties. If extenuating circumstances arise that requires an extension to the time line, the Contractor must email a request to the APCD Stationary Air Toxics Unit Manager and receive approval for a new due date. The State will oversee the completion/implementation of the action(s) to ensure time lines are met and the issue(s) is resolved. If the Contractor demonstrates inaction or disregard for the agreed upon compliance resolution plan, the State may exercise its rights under the provisions of this contract.

Choose an item. Click or tap here to enter text. Ver.2.15.24 image8.png