Variables

Variable Standardisation

Fundamental to the data collation program is the concept of data standardisation. All data contained within the data lake is processed nightly into standardised data products.

As part of this standardisation, all incoming variables need to be converted into a common variable name and unit. To facilitate this, a global variable translation glossary is being developed, which will allow the data engineers to quickly and transparently create importation scripts to process new datasets.

CSIEM Variables

Variable ID	Name	Units	Symbol	Programmatic Name
var00001	E coli	cfu/100mL	C_{ecoli}	e_coli
var00002	Enterococci	cfu/100mL	C_{entercocci}	enterococci
var00003	TN:TP	mg N / mg P	TN:TP	tn_tp_ratio
var00004	Organic Nitrogen	mg/L	ON	organic_nitrogen
var00005	Organic Phosphorus	mg/L	OP	organic_phosphorus
var00006	Salinity	psu	S	salinity
var00007	Temperature	C	T	temperature
var00008	Depth	m	D	depth
var00009	Total Nitrogen	mg/L	TN	total_nitrogen
var00010	Total Phosphorus	mg/L	TP	total_phosphorus
var00011	Total Organic Carbon	mg/L	TOC	total_organic_carbon
var00012	Total Suspended Solids	mg/L	TSS	total_suspended_solids
var00013	Turbidity	NTU	C_T	turbidity
var00014	Chlorophyll-a	µg/l	Chl-a	tchl_a
var00015	Ruppia Biomass	mmol C/m^2	Ruppia	ruppia_biomass
var00016	Suspended Solids #1	mg/L	SS_1	suspended_solids_1
var00017	Sediment Mass (SS1)	g/m^2	SS_1_{SED}	sediment_mass_ss1
var00018	Suspended Solids #2	mg/L	SS_2	suspended_solids_2
var00019	Sediment Mass (SS2)	g/m^2	SS_2_{SED}	sediment_mass_ss2
var00020	Suspended Solids #3	mg/L	SS_3	suspended_solids_3
var00021	Sediment Mass (SS3)	g/m^2	SS_3_{SED}	sediment_mass_ss3
var00022	Water Age	days	\tau_{age}	water_age
var00023	Oxygen	mg/L	O_2	oxygen
var00024	Reactive Silica	mg/L	RSi	reactive_silica
var00025	Ammonium	mg/L	NH_4	ammonium
var00026	Nitrate	mg/L	NO_3	nitrate
var00027	Filterable Reactive Phosphate	mg/L	FRP	filterable_reactive_phosphate
var00028	Adsorped Phosphate	mg/L	FRP_{ads}	adsorped_phosphate
var00029	Dissolved Organic Carbon	mg/L	DOC	dissolved_organic_carbon
var00030	Dissolved Organic Carbon (refractory)	mg/L	DOC_R	dissolved_organic_carbon_refractory
var00031	Particulate Organic Carbon	mg/L	POC	particulate_organic_carbon
var00032	Dissolved Organic Nitrogen	mg/L	DON	dissolved_organic_nitrogen
var00033	Particulate Organic Nitrogen	mg/L	PON	particulate_organic_nitrogen
var00034	Dissolved Organic Nitrogen (refractory)	mg/L	DON_R	dissolved_organic_nitrogen_refractory
var00035	Dissolved Organic Phosphorus	mg/L	DOP	dissolved_organic_phosphorus
var00036	Particulate Organic Phosphorus	mg/L	POP	particulate_organic_phosphorus
var00037	Dissolved Organic Phosphorus (refractory)	mg/L	DOP_R	dissolved_organic_phosphorus_refractory
var00038	Phytoplankton Biomass (greens)	mmol C/m^3	PHY_{grn}	phytoplankton_biomass_greens
var00039	Phytoplankton Biomass (crypt)	mmol C/m^3	PHY_{crypt}	phytoplankton_biomass_crypt
var00040	Phytoplankton Biomass (diatom)	mmol C/m^3	PHY_{diatom}	phytoplankton_biomass_diatom
var00041	Phytoplankton Biomass (dino)	mmol C/m^3	PHY_{dino}	phytoplankton_biomass_dino
var00042	Filamentous Algae (floating)	mmol C/m^3	M_{ulva:(float)}	filamentous_algae_floating
var00043	Filamentous Algae Nitrogen (floating)	mmol N/m^3	MIN_{ulva:(float)}	filamentous_algae_nitrogen_floating
var00044	Filamentous Algae Phosphorus (floating)	mmol P/m^3	MIP_{ulva:(float)}	filamentous_algae_phosphorus_floating
var00045	Filamentous Algae Biomass (total)	g DW/m^2	M_{ulva}	filamentous_algae_biomass_total
var00046	Filamentous Algae Biomass (total)	g DW/m^2	M_{ulva}	filamentous_algae_biomass_total
var00047	Filamentous Algae Biomass (total)	g DW/m^2	M_{ulva}	filamentous_algae_biomass_total
var00048	O2 Dissolved Sediment Flux	mmol O_2/m^2	F_{sed}^{oxy}	o2_dissolved_sediment_flux
var00049	DIC Dissolved Sediment Flux	mmol C/m^2	mmol C/m^2	dic_dissolved_sediment_flux
var00050	NH4 Dissolved Sediment Flux	mmol N/m^2	mmol N/m^2	nh4_dissolved_sediment_flux
var00051	NO3 Dissolved Sediment Flux	mmol N/m^2	mmol N/m^2	no3_dissolved_sediment_flux
var00052	FRP Dissolved Sediment Flux	mmol P/m^2	mmol P/m^2	frp_dissolved_sediment_flux
var00053	POC Dissolved Sediment Flux	mmol C/m^2	mmol C/m^2	poc_dissolved_sediment_flux
var00054	DOC Dissolved Sediment Flux	mmol C/m^2	F_{dsf}^{doc}	doc_dissolved_sediment_flux
var00055	PON Dissolved Sediment Flux	mmol N/m^2	mmol N/m^2	pon_dissolved_sediment_flux
var00056	DON Dissolved Sediment Flux	mmol N/m^2	mmol N/m^2	don_dissolved_sediment_flux
var00057	POP Dissolved Sediment Flux	mmol P/m^2	mmol P/m^2	pop_dissolved_sediment_flux
var00058	DOP Dissolved Sediment Flux	mmol P/m^2	mmol P/m^2	dop_dissolved_sediment_flux
var00059	Photosynthetically Active Radiation	W/m^2	W/m^2	photosynthetically_active_radiation
var00060	Ruppia Gross Primary Productivity	mmol C/m^3/d	mmol C/m^3/d	ruppia_gross_primary_productivity
var00061	Ruppia Net Primary Productivity	mmol C/m^3/d	mmol C/m^3/d	ruppia_net_primary_productivity
var00062	Ruppia Biomass	mmol C/m^2	mmol C/m^2	ruppia_biomass
var00063	Ruppia Leaf Area Index	m^2/m^2	m^2/m^2	ruppia_leaf_area_index
var00064	Ruppia Biomass (above-ground)	mmol C/m^2	mmol C/m^2	ruppia_biomass_ag
var00065	Ruppia Biomass (below-ground)	mmol C/m^2	mmol C/m^2	ruppia_biomass_bg
var00066	Ruppia Root Depth	m	m	ruppia_root_depth
var00067	Ruppia O2 Injection Rate	mmol O_2/m^2	mmol O_2/m^2	ruppia_o2_injection_rate
var00068	Sedimentation Velocity (SS1)	m/d	m/d	sedimentation_velocity_ss1
var00069	Sedimentation Rate (SS1)	g/m^3/d	g/m^3/d	sedimentation_rate_ss1
var00070	Sedimentation Velocity (SS2)	m/d	m/d	sedimentation_velocity_ss2
var00071	Sedimentation Rate (SS2)	g/m^3/d	g/m^3/d	sedimentation_rate_ss2
var00072	Sedimentation Velocity (SS3)	m/d	m/d	sedimentation_velocity_ss3
var00073	Sedimentation Rate (SS3)	g/m^3/d	g/m^3/d	sedimentation_rate_ss3
var00074	Sediment Mass	g/m^2	g/m^2	sediment_mass
var00075	Critical Shear Stress	N/m^2	N/m^2	critical_shear_stress
var00076	Resuspension Rate	g/m^2/d	g/m^2/d	resuspension_rate
var00077	Sediment Fraction (SS1)	v/v	v/v	sediment_fraction_ss1
var00078	Sediment Fraction (SS2)	v/v	v/v	sediment_fraction_ss2
var00079	Sediment Fraction (SS3)	v/v	v/v	sediment_fraction_ss3
var00080	Sedimentation Rate (SS)	g/m^3/d	g/m^3/d	sedimentation_rate_ss
var00081	SS Net SWI Flux	g/m^2/d	g/m^2/d	ss_net_swi_flux
var00082	Change in SWI Position	m	m	change_in_swi_position
var00083	Resuspension Rate (SS)	g/m^2/d	g/m^2/d	resuspension_rate_ss
var00084	Bottom Shear Stress	N/m^2	N/m^2	bottom_shear_stress
var00085	O2 Saturation	%	%	o2_saturation
var00086	O2 Dissolved Sediment Flux	mmol O_2/m^2	mmol O_2/m^2	o2_dissolved_sediment_flux
var00087	O2 Atmospheric Flux	mmol O_2/m^2	mmol O_2/m^2	o2_atmospheric_flux
var00088	O2 Dissolved Sediment Exchange Rate	mmol O_2/m^3	mmol O_2/m^3	o2_dissolved_sediment_exchange_rate
var00089	O2 Atmospheric Exchange Rate	mmol O_2/m^3	mmol O_2/m^3	o2_atmospheric_exchange_rate
var00090	Si Dissolved Sediment Flux	mmol Si/m^2	mmol Si/m^2	si_dissolved_sediment_flux
var00091	NH4 Dissolved Sediment Flux	mmol N/m^2	mmol N/m^2	nh4_dissolved_sediment_flux
var00092	NO3 Dissolved Sediment Flux	mmol N/m^2	mmol N/m^2	no3_dissolved_sediment_flux
var00093	Nitrification Rate	mmol N/m^3/d	mmol N/m^3/d	nitrification_rate
var00094	Denitrification Rate	mmol N/m^3/d	mmol N/m^3/d	denitrification_rate
var00095	Annamox Rate	mmol N/m^3/d	mmol N/m^3/d	annamox_rate
var00096	DNRA Rate	mmol N/m^3/d	mmol N/m^3/d	dnra_rate
var00097	DIN Atmospheric Deposition Flux	mmol N/m^2/d	mmol N/m^2/d	din_atmospheric_deposition_flux
var00098	PIP Sedimentation Rate	mmol P/m^3/d	mmol P/m^3/d	pip_sedimentation_rate
var00099	PIP Resuspension Rate	mmol P/m^2/d	mmol P/m^2/d	pip_resuspension_rate
var00100	PIP Net SWI Flux	mmol P/m^2/d	mmol P/m^2/d	pip_net_swi_flux
var00101	FRP Sorption Rate	mmol P/m^3/d	mmol P/m^3/d	frp_sorption_rate
var00102	FRP Dissolved Sediment Flux	mmol P/m^2/d	mmol P/m^2/d	frp_dissolved_sediment_flux
var00103	DIP Atmospheric Deposition Flux	mmol P/m^2/d	mmol P/m^2/d	dip_atmospheric_deposition_flux
var00104	POC Sedimentation Rate	mmol C/m^3/d	mmol C/m^3/d	poc_sedimentation_rate
var00105	PON Sedimentation Rate	mmol N/m^3/d	mmol N/m^3/d	pon_sedimentation_rate
var00106	POP Sedimentation Rate	mmol P/m^3/d	mmol P/m^3/d	pop_sedimentation_rate
var00107	Sediment OM Fraction	v/v	v/v	sediment_om_fraction
var00108	Chromophoric DOM	/m	/m	chromophoric_dom
var00109	Sediment Total Organic Carbon	mmol C/m^2	mmol C/m^2	sediment_total_organic_carbon
var00110	Sediment Total Organic Nitrogen	mmol N/m^2	mmol N/m^2	sediment_total_organic_nitrogen
var00111	Sediment Total Organic Phosphorus	mmol P/m^2	mmol P/m^2	sediment_total_organic_phosphorus
var00112	POC Net SWI Flux	mmol C/m^2/d	mmol C/m^2/d	poc_net_swi_flux
var00113	DOC Net SWI Flux	mmol C/m^2/d	mmol C/m^2/d	doc_net_swi_flux
var00114	PON Net SWI Flux	mmol N/m^2/d	mmol N/m^2/d	pon_net_swi_flux
var00115	DON Net SWI Flux	mmol N/m^2/d	mmol N/m^2/d	don_net_swi_flux
var00116	POP Net SWI Flux	mmol P/m^2/d	mmol P/m^2/d	pop_net_swi_flux
var00117	DOP Net SWI Flux	mmol P/m^2/d	mmol P/m^2/d	dop_net_swi_flux
var00118	POC Resuspension Rate	mmol C/m^2/d	mmol C/m^2/d	poc_resuspension_rate
var00119	PON Resuspension Rate	mmol N/m^2/d	mmol N/m^2/d	pon_resuspension_rate
var00120	POP Resuspension Rate	mmol P/m^2/d	mmol P/m^2/d	pop_resuspension_rate
var00121	POC Hydrolysis Rate	mmol C/m^3/d	mmol C/m^3/d	poc_hydrolysis_rate
var00122	PON Hydrolysis Rate	mmol N/m^3/d	mmol N/m^3/d	pon_hydrolysis_rate
var00123	POP Hydrolysis Rate	mmol P/m^3/d	mmol P/m^3/d	pop_hydrolysis_rate
var00124	DOC Mineralisation Rate	mmol C/m^3/d	mmol C/m^3/d	doc_mineralisation_rate
var00125	DON Mineralisation Rate	mmol N/m^3/d	mmol N/m^3/d	don_mineralisation_rate
var00126	DOP Mineralisation Rate	mmol P/m^3/d	mmol P/m^3/d	dop_mineralisation_rate
var00127	DOC Mineralisation Rate (anaerobic)	mmol C/m^3/d	mmol C/m^3/d	doc_mineralisation_rate_anaerobic
var00128	DOC Mineralisation Rate (denitrification)	mmol C/m^3/d	mmol C/m^3/d	doc_mineralisation_rate_denitrification
var00129	Wind Direction	ø	ø	wind_direction
var00130	Wind Speed	m/s	m/s	wind_speed
var00131	Chlorophyll-b	µg/L	Chl-b	tchl_b
var00132	Chlorophyll-c	µg/L	Chl-c	tchl_c
var00133	Cloud Cover	%	%	cloud_cover
var00134	Conductivity	µS/cm	µS/cm	conductivity
var00135	Flow Status			flow_status
var00136	Total TKN	mg/L	TKN	total_tkn
var00137	pH		pH	ph
var00138	Phaeophytin a	mg/L	mg/L	phaeophytin_a
var00139	Total Alkalinity	mg/L	CaCO_3	total_alkalinity
var00140	Secchi depth	m	m	secchi_depth
var00141	Tide status			tide_status
var00142	Max Discharge	m/s	m/s	max_discharge
var00143	Mean Discharge	m/s	m/s	mean_discharge
var00144	Min Discharge	m/s	m/s	min_discharge
var00145	Discharge	ML	ML	discharge
var00146	Max Stage Height CTF	m	m	max_stage_height_ctf
var00147	Mean Stage Height CTF	m	m	mean_stage_height_ctf
var00148	Min Stage Height CTF	m	m	min_stage_height_ctf
var00149	Max Stage Height	m	m	max_stage_height
var00150	Mean Stage Height	m	m	mean_stage_height
var00151	Min Stage Height	m	m	min_stage_height
var00152	Precipitation	m	m	precipitation
var00153	Air Temperature	C	C	air_temperature
var00154	Wet Bulb Air Temperature	C	C	wet_bulb_air_temperature
var00155	Dew Point Temperature	C	C	dew_point_temperature
var00156	Relative Humidity	%	%	relative_humidity
var00157	Max Wind Speed	m/s	m/s	max_wind_speed
var00158	Cloud amount of first group in eighths	oktas	oktas	cloud_amount_of_first_group_in_eighths
var00159	Cloud height of first group	ft	ft	cloud_height_of_first_group
var00160	Cloud amount of second group in eighths	oktas	oktas	cloud_amount_of_second_group_in_eighths
var00161	Cloud height of second group	ft	ft	cloud_height_of_second_group
var00162	Cloud amount of third group in eighths	oktas	oktas	cloud_amount_of_third_group_in_eighths
var00163	Cloud height of third group	ft	ft	cloud_height_of_third_group
var00164	Cloud amount of fourth group in eighths	oktas	oktas	cloud_amount_of_fourth_group_in_eighths
var00165	Cloud height of fourth group	ft	ft	cloud_height_of_fourth_group
var00166	Ceilometer cloud amount of first group	oktas	oktas	ceilometer_cloud_amount_of_first_group
var00167	Ceilometer cloud height of first group	ft	ft	ceilometer_cloud_height_of_first_group
var00168	Ceilometer cloud amount of second group	oktas	oktas	ceilometer_cloud_amount_of_second_group
var00169	Ceilometer cloud height of second group	ft	ft	ceilometer_cloud_height_of_second_group
var00170	Ceilometer cloud amount of third group	oktas	oktas	ceilometer_cloud_amount_of_third_group
var00171	Ceilometer cloud height of third group	ft	ft	ceilometer_cloud_height_of_third_group
var00172	Ceilometer sky clear flag			ceilometer_sky_clear_flag
var00173	Horizontal visibility	km	km	horizontal_visibility
var00174	AWS visibility	km	km	aws_visibility
var00175	Present weather in code			present_weather_in_code
var00176	Mean sea level pressure	hPa	hPa	mean_sea_level_pressure
var00177	Station level pressure	hPa	hPa	station_level_pressure
var00178	Chlorophyll sample volume	mL	mL	chlorophyll_sample_volume
var00179	Bottom Depth	m	D	bottom_depth
var00180	Tidal Height	m	m	tidal_height
var00181	PAR	µmol/m2/s	µmol/m2/s
var00182	Tilt	deg	deg
var00183	WL - 410	µW/cm2/nm	µW/cm2/nm
var00184	WL - 440	µW/cm2/nm	µW/cm2/nm
var00185	WL - 490	µW/cm2/nm	µW/cm2/nm
var00186	WL - 510	µW/cm2/nm	µW/cm2/nm
var00187	WL - 550	µW/cm2/nm	µW/cm2/nm
var00188	WL - 590	µW/cm2/nm	µW/cm2/nm
var00189	WL - 635	µW/cm2/nm	µW/cm2/nm
var00190	WL - 660	µW/cm2/nm	µW/cm2/nm
var00191	WL - 700	µW/cm2/nm	µW/cm2/nm
var00192	ACCELERATIONX	m s-2	m s-2
var00193	ACCELERATIONY	m s-2	m s-2
var00194	ACCELERATIONZ	m s-2	m s-2
var00195	AMPLITUDE1	counts	counts
var00196	AMPLITUDE2	counts	counts
var00197	AMPLITUDE3	counts	counts
var00198	CELL	m	m
var00199	DENSITY ANOMALY	kg m-3	kg m-3
var00200	FREE	FREE	FREE
var00201	HEADING	Degrees clockwise from true North	Degrees clockwise from true North
var00202	LOWER_UCUR	m s-1	m s-1
var00203	LOWER_VCUR	m s-1	m s-1
var00204	MIDDLE_UCUR	m s-1	m s-1
var00205	MIDDLE_VCUR	m s-1	m s-1
var00206	Pitch	deg	deg
var00207	PRESSURE	dbar	dbar
var00208	PRESSURE_SENSOR_DEPTH	metres	metres
var00209	ROLL	degrees	degrees
var00210	SPEED_OF_SOUND	m s-1	m s-1
var00211	UCUR	m s-1	m s-1
var00212	UPPER_UCUR	m s-1	m s-1
var00213	UPPER_VCUR	m s-1	m s-1
var00214	VCUR	m s-1	m s-1
var00215	WCUR	m s-1	m s-1
var00216	light attenuation coefficient	m-1	m-1	light_attenuation_coefficient
var00217	cell	cm	cm	cell
var00218	density	kg m-3	kg m-3	density
var00219	fluorescence	-	-	fluorescence
var00220	Prochlorococcus	cellsmL	cellsmL	Prochlorococcus
var00221	Synechococcus	cellsmL	cellsmL	Synechococcus
var00222	Picoeukaryotes	cellsmL	cellsmL	Picoeukaryotes
var00223	Allo	mg/m3	mg/m3	Allo
var00224	AlphaBetaCar	mg/m3	mg/m3	AlphaBetaCar
var00225	Anth	mg/m3	mg/m3	Anth
var00226	Asta	mg/m3	mg/m3	Asta
var00227	BetaBetaCar	mg/m3	mg/m3	BetaBetaCar
var00228	BetaEpiCar	mg/m3	mg/m3	BetaEpiCar
var00229	Butfuco	mg/m3	mg/m3	Butfuco
var00230	Cantha	mg/m3	mg/m3	Cantha
var00231	CphlA	mg/m3	mg/m3	CphlA
var00232	CphlB	mg/m3	mg/m3	CphlB
var00233	CphlC1	mg/m3	mg/m3	CphlC1
var00234	CphlC2	mg/m3	mg/m3	CphlC2
var00235	CphlC3	mg/m3	mg/m3	CphlC3
var00236	CphlC1C2	mg/m3	mg/m3	CphlC1C2
var00237	CphlideA	mg/m3	mg/m3	CphlideA
var00238	Diadchr	mg/m3	mg/m3	Diadchr
var00239	Diadino	mg/m3	mg/m3	Diadino
var00240	Diato	mg/m3	mg/m3	Diato
var00241	Dino	mg/m3	mg/m3	Dino
var00242	DvCphlA+CphlA	mg/m3	mg/m3	DvCphlA_CphlA
var00243	DvCphlA	mg/m3	mg/m3	DvCphlA
var00244	DvCphlB+CphlB	mg/m3	mg/m3	DvCphlB_CphlB
var00245	DvCphlB	mg/m3	mg/m3	DvCphlB
var00246	Echin	mg/m3	mg/m3	Echin
var00247	Fuco	mg/m3	mg/m3	Fuco
var00248	Gyro	mg/m3	mg/m3	Gyro
var00249	Hexfuco	mg/m3	mg/m3	Hexfuco
var00250	Ketohexfuco	mg/m3	mg/m3	Ketohexfuco
var00251	Lut	mg/m3	mg/m3	Lut
var00252	Lyco	mg/m3	mg/m3	Lyco
var00253	MgDvp	mg/m3	mg/m3	MgDvp
var00254	Neo	mg/m3	mg/m3	Neo
var00255	Perid	mg/m3	mg/m3	Perid
var00256	PhideA	mg/m3	mg/m3	PhideA
var00257	PhytinA	mg/m3	mg/m3	PhytinA
var00258	PhytinB	mg/m3	mg/m3	PhytinB
var00259	Pras	mg/m3	mg/m3	Pras
var00260	PyrophideA	mg/m3	mg/m3	PyrophideA
var00261	PyrophytinA	mg/m3	mg/m3	PyrophytinA
var00262	Viola	mg/m3	mg/m3	Viola
var00263	Zea	mg/m3	mg/m3	Zea
var00264	Nitrite	mg/L	mg/L	Nitrite
var00265	TSSorganic	mg/L	mg/L	TSSorganic
var00266	TSSinorganic	mg/L	mg/L	TSSinorganic
var00267	DIC	mg/L	mg/L	DIC