NYC-WTC_000232249

NYC 9/11 Public Portal Document

Data Management Program

An environmental data management program will be provided that facilitates the processing of current and historical analytical data collected across multiple work areas. Contractor Environmental Subcontractor will provide analytical sampling results via EDD’s compatible to ® export results to a standardized Microsoft Access datamart for end-users of the data. The datamarts can be accessed to provide interactive data queries, charting, and summaries.

Automated Data Collection

Contractor Environmental Subcontractor’s system will be used to automate data collection from the real-time monitoring network (PMio monitors, as well as the meteorological station) by sending the data via a wireless phone connection to a secure Internet database. The data can then be viewed in real time over secure Web pages in tabular, graphical, and spatial formats. The system architecture consists of three tiers: field data collection, database storage, and Web-based data access and reporting.

The system uses digital data loggers and software for data collection and retrieval. These loggers were described previously and will transmit their data to Contractor Environmental Subcontractor via wireless modems.

Contractor Environmental Subcontractor developed a standard database structure that is the system’s foundation for maximizing efficient transfer and management of data. For example, the database uses stored procedures to send e-mail notifications when incoming data trigger alarm conditions, and to warn when data are not received on schedule. Because monitoring data are stored in standardized databases, information retrieval and editing processes are very efficient. Data reside on a secure server that is backed up daily and stored off-site. Through Contractor Environmental Subcontractor’s system, data can be manipulated and viewed in real time in tabular, graphical, or spatial formats.

CITY_DEP_WORBY_CANNATA_SUBP_000114911

NYC-WTC_000232280