ny-gov/synthesis-of-environmental-mercury-loads-in-new-2ei4-24ka
Icon for Socrata external plugin
 
Readme
Updated over 1 year ago
Indexed 2 hours ago

Synthesis of Environmental Mercury Loads in New York State (1969-2017): Chemical Data

This dataset includes information from a statewide synthesis effort, involving the compilation, analysis, and synthesis of existing data on environmental mercury (Hg) concentrations and loads in New York State, with an emphasis on Hg data collected during recent NYSERDA-sponsored monitoring and research efforts. Compiling existing mercury data is a vital step to understanding the broad spatial and temporal patterns of mercury across the landscape. This dataset includes the chemical results from both biotic and abiotic samples used as part of this analysis and is one of eight datasets from the statewide synthesis database.

The New York State Energy Research and Development Authority (NYSERDA) offers objective information and analysis, innovative programs, technical expertise, and support to help New Yorkers increase energy efficiency, save money, use renewable energy, and accelerate economic growth. reduce reliance on fossil fuels. To learn more about NYSERDA’s programs, visit nyserda.ny.gov or follow us on Twitter, Facebook, YouTube, or Instagram.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
Convert_Chem_Value_Fishadjconvert_chem_value_fishadjconvert_chem_value_fishadjNumberChemical value standardized for species-specific fish length. Blank cells represent data that were not required or are not currently available.
Chem_Valuechem_valuechem_valueNumberChemical data value for the sample analyzed
ww_dw_fwww_dw_fwww_dw_fwTextChemical analysis tissue preparation method (ex. dry weight (dw), fresh weight (fw), wet weight (ww), etc.). Blank cells represent data that were not required or are not currently available.
RMKrmkrmkTextAny remarks on the chemical value or the laboratory analysis. Blank cells represent data that were not required or are not currently available.
METHODmethodmethodTextCode relating further information on methodology used for chemical analysis. Blank cells represent data that were not required or are not currently available.
Chem_Unitschem_unitschem_unitsTextUnits for chemical data value; either micrograms per gram (µg/g), micrograms per kilogram (µg/kg), micrograms per liter (µg/l), micrograms per deciliter (µg/dl), parts per million (ppm), milligram per kilogram (mg/kg), nanogram per gram (ng/g), or nanogram per liter (ng/l).
Chemical_Typechemical_typechemical_typeTextChemical analyzed; either methylmercury (MeHg), selenium (Se), or total mercury (THg).
YearyearyearNumberYear sample was collected. Blank cells represent data that were not required or are not currently available.
SAMPLE_IDsample_idsample_idTextUnique sample identifier
ORG_IDorg_idorg_idTextUnique identifier for each individual organism from which a sample was collected.
Capture_Eventcapture_eventcapture_eventTextUnique spatial and temporal collection point identifier
Capture_Loccapture_loccapture_locTextUnique spatial collection point identifier
LatitudelatitudelatitudeNumberLatitude of data collection point. Blank cells represent data that were not required or are not currently available.
LongitudelongitudelongitudeNumberLongitude of data collection point. Blank cells represent data that were not required or are not currently available.
Site_IDsite_idsite_idTextUnique site identifier
Project_IDproject_idproject_idTextUnique project identifier
Org_HG_IDorg_hg_idorg_hg_idTextOriginal sample ID assigned by the researcher. Blank cells represent data that were not required or are not currently available.
BDatebdatebdateCalendar dateDate of sample collection
LIMIT_DESClimit_desclimit_descTextThis field defines the type of LIMIT that was quantified. Blank cells represent data that were not required or are not currently available.
LAB_CODElab_codelab_codeTextThis is an additional identifier used in some datasets to track lab samples assigned by the lab. Blank cells represent data that were not required or are not currently available.
Lab_abbrevlab_abbrevlab_abbrevTextAbbreviation of lab where sample was processed. Blank cells represent data that were not required or are not currently available.
LIMITlimitlimitNumberValue of the lower detection limit, average detection limit, reporting limit, method limit, or other limit reported by the lab conducting the sample analysis. Blank cells represent data that were not required or are not currently available.
RMK_DESCrmk_descrmk_descTextFurther explanation or definitions of remarks on the chemical value or the laboratory analysis, if needed. Blank cells represent data that were not required or are not currently available.
PcodepcodepcodeTextCode for the medium, type of sample (wet, dry or fresh weight), type of Hg measured, and measurement units. Blank cells represent data that were not required or are not currently available.
Steps_ReasonNotConvertedsteps_reasonnotconvertedsteps_reasonnotconvertedTextThe steps taken to convert the original chemical value to the final standardized value or reasoning for not converting the original value
duplicate1duplicate1duplicate1NumberSpecifies chemical value if a sample duplicate was run. Blank cells represent data that were not required or are not currently available.
Final_ConvertedTissuefinal_convertedtissuefinal_convertedtissueTextThe equivalent tissue type that each chemical value was converted into for standardized analysis. Blank cells represent data that were not required or are not currently available.
Final_Chem_Standardizedfinal_chem_standardizedfinal_chem_standardizedNumberFinal chemical value used in analysis after converting to standardized units (parts per million; ppm) with an appropriate wet, dry, or fresh weight (ww, dw, and fw, respectively) Hg measurement for the converted tissue type. Blank cells represent data that were not required or are not currently available.
AnalysisTissue%Moistanalysis_tissue_moistanalysis_tissue_moistNumberMoisture percentage of tissue sample analyzed. Blank cells represent data that were not required or are not currently available.
Hg_Commentshg_commentshg_commentsTextRelevant comments related to the chemical analysis. Blank cells represent data that were not required or are not currently available.
Analysis_Tissue_Wgt (g)analysis_tissue_wgt_ganalysis_tissue_wgt_gNumberWeight of the tissue sample analyzed, measured in grams. Blank cells represent data that were not required or are not currently available.
Band_Numberband_numberband_numberTextNumber of band placed on sample
TissueCollectedtissuecollectedtissuecollectedTextType of tissue or subject sampled (ex. Blood, Egg, Fat, Sediment, Water, etc.).
Analysis_Tissueanalysis_tissueanalysis_tissueTextType of tissue or subject analyzed (ex. Blood, Egg, Fat, Sediment, Water, etc.).
 
Preview
  • synthesis_of_environmental_mercury_loads_in_new
     
Upstream Metadata