Environmental sampling data dictionary or schema documentation

NYC 9/11 Public Portal Document

Variable Name Description Response Options Field Type

UniqueJD A number that is assigned to the record after it is entered into Numeric the main spreadsheet________________________________ Documentld The number we assign to a document we receive that helps Numeric DOH find the sample within all of the documents (see binder).

SamplelD Sample Identification/Number, usually included by the Text reporting agency. If it isn't, please create one and indicate so on the hard copy___________________________________ Analyte The substance(Analyte) that the Laboratory is testing for. Asbestos Text Formerly compound_name VOC Lead Coliform PM 2.5 PM 10 SO2 CO NO2 03 Pesticide/PCB

Sub_Analyte If noted, the specific subtype of compound. Chrysotile Text Example: Asbestos samples can have "subtypes" like Amosite Chrysotile, Amosite, etc. VOC's can be specific, like Benzene, Toluene, Acetone. Formerly Compound sub-type

Agency The Agency that is reporting the samples. Samples can either EPA Text be collected by the Testing Agency or contracted out to a DEP company (not yet rec'd data from NIOSH) Formerly ConEd Testing_Agency DEC NYCDOH NYSDOH OSHA SCA Union of Operating Engineers Lab The Laboratory that was responsible for analyzing the sample Text Formerly Testing Lab________________________________ Date_Sampled The date that the sample was collected in the field Date StartTinie_Sampled The time (or time frame) that the sample was taken________ Military Time County If not NYC borough, please list city and state Manhattan Text Brooklyn Queens Bronx New Jersey S i telMame_or_Address Description of area where sample was taken or name of Text sample location (if sentinel site then Location #A, or else corner of Murray between W. Broadway and Church) Build Floor The floor where the sample was taken (if applicable) Text 1_North/south street or The primary street that runs in a North/South Direction see pull down list Text avenue 2_North/south street or The secondary street that runs in a North/South Direction see pull down list Text avenue 1_East/West street The primary street that runs in a EastAA/est Direction see pull down list Text 12 East/West street The secondary street that runs in a EastA/Vest Direction see pull down list Text

Data Dictionary for Sampling Log, 9/25/01,2:33 PM, Page: 1 Of 2

CITY_21MC100_006814655

NYC-WTC_000186115