This metadata record describes water quality data collected during a water-quality mapping project. Project data are an aggregation of data collected during twenty-eight year 2016 DATAFLOW mapping cruises.
The data are contained in six related entities (tables): Station_Information, Monitoring_Event_Data, Water_Quality_Data, Light_Attenuation_Data, SONDE_DATA and BGA_DATA. Each table contains attributes (fields). NOTE: SONDE_DATA and BGA_DATA were not served by the Chesapeake Bay Program at the time this metadata record was developed.
The entity Station_Information is comprised of the attributes: CBSeg2003, CBSeg2003Description, CBSegmentShed2009, CBSegmentShed2009Description, CountyCity, FallLine, FIPS, HUC12, HUC8, Latitude, LLDatum, Longitude, State, Station, StationDescription, USGSGage, UTMX, and UTMY.
The entity Monitoring_Event_Data is comprised of the attributes: Agency, CloudCover, Cruise, Details, EventId, FieldActivityEventType, FieldActivityRemark, FlowStage, GaugeHeight, Latitude, Longitude, LowerPycnocline, MonitoringStation, PrecipType, Pressure, Program, Project, SampleDate, SampleTime, Source, Station, TideStage, TotalDepth, UpperPycnocline, WaveHeight, WindDirection, and WindSpeed.
The entity Water_Quality_Data is comprised of the attributes: Agency, BiasPC, Cruise, Depth, Details, EventId, Lab, Latitude, Layer, Longitude, LowerPycnocline, MeasureValue, Method, MonitoringStation, Parameter, PrecisionPC, Problem, Program, Project, Qualifier, SampleDate, SampleReplicateType, SampleTime, SampleType, Source, Station, TotalDepth, Unit, and UpperPycnocline.
The entity Light_Attenuation_Data is comprised of the attributes: Depth, Details, EventId, HUC8, LowerPycnocline, Method, Parameter, Program, Project, SampleDate, SampleReplicateType, SampleTime, Source, Station, TotalDepth, Unit, and UpperPycnocline.
The entity SONDE_DATA is comprised of the attributes: SAMPLE_DATE, SAMPLE_TIME, WATER_BODY, SECTION, PRI_SEG, SONDE, LATITUDE, LONGITUDE, TOTAL_DEPTH, BOAT_SPEED, BATT, WTEMP, SPCOND, SALINITY, DO_SAT, DO, PH, TURB_NTU, FLUOR, TCHL_PRE_CAL and COMMENTS.
Cyanobacteria are commonly referred to as Blue Green algae (BGA). YSI 6600 sondes are not configured with enough sensor ports to measure water quality and Cyanobacteria with a single instrument so two sondes are used. Cyanobacteria sonde data are merged with primary sonde data by aligning record timestamps.
The entity BGA_DATA is comprised of the attributes: BGA_PE_ConcCells_ml, BGA_PE_RFU, bgaDate, bgaTime, BOAT_SPEED, bridgeDate, bridgetime, COMMENTS, DEPTH, DO, DOpctSat, FLUOR, LATITUDE, LONGITUDE, PH, PRI_SEG, SALINITY, SAMPLE_DATE, SAMPLE_TIME, SONDE, SPCOND, STATION, TChlPreCal, TurbNTU, WATER_BODY and WTEMP.
Maps created by interpolating the Dissolved Oxygen, Turbidity, Chlorophyll a, Salinity and Temperature data acquired during monthly mapping cruises show spatial distribution of water quality parameter values on the day of the survey. The maps may be viewed and downloaded from <
http://eyesonthebay.dnr.maryland.gov/sim/DataflowDataMenu.cfm>.