﻿_id	Original Header	Type	Cleaned Variable Name	CanWIN Common Name	Units	Data Provider Description	Standardized Source Term	Standardized Source Term Link	Notes	media_type	result_value_type	statistic_applied
1	The exact column name as it appeared in the raw file before any cleaning.	The variable’s data type (text, numeric, timestamp, etc.) after cleaning.	The standardized, machine‑friendly name produced following data best practices, for e.g., using the CSV Studio’s header cleaning function. Used in the final dataset.	A human‑readable name. Helps non‑technical users understand the variable.	The physical units associated with the variable (e.g., m, PSU, °C).	Description explaining what the variable represents.	Standardized scientific term selected from an authoritative vocabulary (e.g., BODC, CF). Ensures consistent meaning across datasets.	Link to standardized scientific term and definition.	Any notes about how the variable was processed or derived.Extracted from the header or assigned manually.	The medium from which the measurement was taken (e.g., water, air, sediment). Extracted from the header or assigned manually.	Whether the value is a direct measurement or a calculated value.	Any statistical operation applied to the variable (e.g., mean, max, min). “none” if no statistic was applied.
2		timestamp	date-time	Date-Time	UTC	String corresponding to format 'YYYY-MM-DDThh:mm:ss.sssZ' or other valid ISO8601 string	UT_ISO8600	http://vocab.nerc.ac.uk/collection/P01/current/DTUT8601/	Added from metadata rows	Freshwater	actual	None
3		timestamp	lattitude	Latitude	decimal degrees	Latitude north	Lat	http://vocab.nerc.ac.uk/collection/P01/current/ALATZZ01/	Added from metadata rows	Freshwater	actual	None
4		timestamp	longitude	Longitude	decimal degrees	Longitude east	Lon	http://vocab.nerc.ac.uk/collection/P01/current/ALONZZ01/	Added from metadata rows	Freshwater	actual	None
5	Depth	numeric	depth (m)	Depth	m	Depth of the CTD in meters derived from pressure using salt water equations.	BATH	http://vocab.nerc.ac.uk/collection/P09/current/BATH/		Freshwater	actual	None
6	Temperature	numeric	temperature (degC)	Water Temperature	degC	Water temperature measured by the CTD and reported on the ITS-90 temperature scale.	WC_temp_CTD	http://vocab.nerc.ac.uk/collection/P01/current/TEMPS901/		Freshwater	actual	None
7	SpecificConductance	numeric	specific_conductance (uS cm-1)	Conductivity	uS cm^-1	Conductivity of seawater measured by the CTD, used to calculate salinity.	CTDCond	http://vocab.nerc.ac.uk/collection/P01/current/CNDCST01/		Freshwater	actual	None
8	DissolvedOxygen	numeric	dissolved_oxygen (mg l-1)	Oxygen (Mass-Based) - Water	mg L^-1	Dissolved oxygen (mg L⁻¹) is the mass of molecular oxygen dissolved in seawater, expressed as milligrams of O₂ per liter. On Sea‑Bird CTD systems, this value is derived from the SBE43 electrochemical oxygen sensor, which measures oxygen partial pressure and converts it to concentration using temperature, salinity, and pressure corrections.	DissO2_Mass	https://vocab.nerc.ac.uk/collection/P01/current/DOXMZZXX/		Freshwater	actual	None
9	DissolvedOxygen	numeric	dissolved_oxygen (percent_sat)	Oxygen (Saturation) - Water	%sat	Oxygen saturation (%) describes how much dissolved oxygen is present in seawater compared to the maximum amount the water could hold at the same temperature, salinity, and pressure.	O2_Sat_SBE43	https://vocab.nerc.ac.uk/collection/P01/current/OXYSSU01/		Freshwater	actual	None
10	Turbidity	numeric	turbidity (ntu)	Turbidity	NTU	Turbidity is a measure of how much light is scattered by particles suspended in seawater. On a Sea‑Bird CTD, turbidity is typically measured using an optical backscatter sensor (such as a WET Labs ECO FLNTU or ECO NTU module). The sensor emits light into the water and detects the amount that is scattered back toward the instrument. Higher turbidity values indicate more suspended particles, such as sediment, plankton, or organic matter.	Turbidity	https://vocab.nerc.ac.uk/collection/P01/current/TURBXXXX/		Freshwater	actual	None
11	Chlorophyll	numeric	chlorophyll (rfu)	Chlorophyll-a Flourescence	RFU	Chlorophyll fluorescence (RFU) represents the intensity of light emitted by chlorophyll‑a pigments in phytoplankton when they are excited by a specific wavelength of light. On a Sea‑Bird CTD, this measurement is typically made using a WET Labs ECO fluorometer integrated into the package. The sensor shines blue light into the water and detects the red fluorescence emitted by chlorophyll‑a in suspended phytoplankton cells.	chl-a_water_ISfluor_manufctrcal_sensor1	https://vocab.nerc.ac.uk/collection/P01/current/CPHLPM01/		Freshwater	actual	None
12	UnderwaterPAR	numeric	underwater_par (uE m-2 s-1)	Photosynthetically Active Radiation (Water)	uE m^-2 s^-1	"Underwater PAR represents the amount of photosynthetically active radiation (light in the 400–700 nm range) reaching a point beneath the water surface. On a Sea‑Bird CTD, this measurement is collected using an in‑situ cosine‑collector PAR sensor (typically a Biospherical or LI‑COR instrument integrated into the CTD package). The sensor counts the number of photons arriving from above and reports the result as a photon flux density in units of µmol photons m⁻² s⁻¹ (µE m⁻² s⁻¹).
 
 This measurement reflects how much usable light is available for photosynthesis at depth. PAR decreases with depth due to absorption and scattering by water, dissolved substances, and suspended particles, making it a key indicator of underwater light climate and primary productivity potential."	SubsurVPAR	https://vocab.nerc.ac.uk/collection/P01/current/IRRDUV01/		Freshwater	actual	None
13	DescentRate	numeric	descent_rate (m s-1)		m s^-1	Descent rate (m s⁻¹) is the vertical speed of the CTD package as it is lowered through the water column. It describes how quickly the instrument is moving downward during a cast.				Freshwater	actual	None
14	SurfacePAR	numeric	surfacepar (uE m-2 s-1)	Photosynthetically Active Radiation (Air)	uE m^-2 s^-1	Surface PAR represents the downwelling photosynthetically active radiation (400–700 nm) measured at the air–sea interface by the surface PAR sensor (deck cell) on a Sea‑Bird system. The cosine‑collector radiometer detects the flux of incoming photons from the sky and reports the photon irradiance in µmol photons m⁻² s⁻¹ (µE m⁻² s⁻¹). This measurement characterizes the amount of usable light available to drive photosynthesis at the surface.	SurfVPAR	https://vocab.nerc.ac.uk/collection/P01/current/IRRDSV01/		Freshwater	actual	None
