This dataset contains in situ water column data at offshore monitoring stations using a Conductivity Temperature Depth (CTD) sensor for the Whidbey Basin. A CTD is a multi-sensor array that measures dissolved oxygen, salinity, temperature, density (calculated), nitrate + nitrite, and fluorescence (as a measure of chlorophyll).
This dataset has the following 31 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
Depth (meters) | depth_meters | number | Sensor depth when measurement was taken. | 2.0 1.5 2.5 3.0 3.5 view top 100 |
Locator | locator | text | Unique geographic identifier used by King County to describe the location of the sensor reading. | SARATOGACH Poss DO-2 PSUSANENT PSUSANKP SARATOGAOP view top 100 |
CH Qual | ch_qual | text | ch_qual | E view top 100 |
DO Qual | do_qual | text | do_qual | E view top 100 |
NO23 Qual | no23_qual | text | no23_qual | R E view top 100 |
SA Qual | sa_qual | text | sa_qual | E view top 100 |
Sample Date | sample_date | calendar_date | The date of the observation. | 2023-11-07T11:11:40.000 2023-09-28T12:37:51.000 2022-05-11T11:43:35.000 2023-11-07T11:11:15.000 2022-03-30T08:12:35.000 view top 100 |
Summ Row ID | summ_row_id | text | An internal numbering system used to track related observations from a given sample day. | view top 100 |
Up Down | up_down | text | Description of whether the sensor was on the down or up cast. | Down Up view top 100 |
Chlorophyll (µg/L) | chlorophyll_g_l | number | Chlorophyll (µg/L) | 0.16 0.26 0.27 0.25 0.15 view top 100 |
Density field | density_field | number | Density | 1023.4740 1023.4450 1023.4640 1023.3130 1023.4480 view top 100 |
Dissolved Oxygen (mg/L) | dissolved_oxygen_mg_l | number | Dissolved Oxygen (mg/L) | 6.421 6.851 6.402 6.395 6.404 view top 100 |
Light Transmission | light_transmission | number | Light Transmission | 92.72 92.93 92.65 92.76 92.61 view top 100 |
Nitrate + Nitrite (mg N/L) | nitrate_nitrite_mg_n_l | number | Nitrate + Nitrite (mg N/L) | -0.0570 0.4170 0.4224 0.4154 0.4108 view top 100 |
PAR field | par_field | number | PAR field | 0.04 0.05 0.06 0.03 0.07 view top 100 |
PAR Surface | par_surface | number | PAR Surface | 0.0 331.8 93.5 2252.9 287.8 view top 100 |
Salinity (PSU) | salinity_psu | number | Salinity (PSU) | 30.0647 29.8480 29.7899 30.2712 30.6410 view top 100 |
Scan | scan | number | An internal numbering system used to describe the scan. | view top 100 |
Sigma-Theta Density (kg/m3) | sigma_theta_density_kg_m3 | number | Sigma-Theta Density (kg/m3) | 23.1738 23.1737 22.9308 23.1721 23.1736 view top 100 |
Temperature (°C) | temperature_c | number | Temperature (°C) | 8.300 8.323 8.368 8.310 12.232 view top 100 |
Turbidity Field | turbidity_field | text | Turbidity Field | view top 100 |
Loaddate | loaddate | calendar_date | This field shows on what date the data was loaded into the CTD database. Occasionally, revisions occur and the load date is the column which signifies that data was later corrected. | view top 100 |
LT_qual | lt_qual | text | Light Transmission Qualifier | E view top 100 |
data_row_id | data_row_id | text | This is an internal database identifier used to uniquely identify each observation of data. | view top 100 |
dn_qual | dn_qual | text | dn_qual | E view top 100 |
tb_qual | tb_qual | text | tb_qual | E view top 100 |
st_qual | st_qual | text | st_qual | E view top 100 |
sd_qual | sd_qual | text | sd_qual | E view top 100 |
pas_qual | pas_qual | text | pas_qual | R view top 100 |
pa_qual | pa_qual | text | pa_qual | E view top 100 |
Cast Notes | cast_notes | text | KCEL notes from the CTD cast | Depth reading shallow by approx. 2-3%. Utilized the R/V Magister, which did not have a Surface PAR cable. SUNA data rejected- Instrument at factory. Cast was not allowed to equilibrate before sending down to 5.5 meters on the downcast. Downcast data from 1 m to 5.5 meters is suspect. All other bins 6 meters and below and the entire upcast are fine. view top 100 |