Fields Available
The following table shows all the fields currently available for creating templates. If you want to add new fields, please contact an administrator.
| ID | name | definition | var type | unit | rules | present in |
|---|---|---|---|---|---|---|
| 9 | publication_year | The publication year of the reference(s) associated with the data. For multiple references, enter the requested data for individual references in consecutive columns, retaining the same order as that indicated in other 'reference' fields (author_s, publication_year, title, edition, reference_type, publication_repository) | int | YYYY | No rules associated | IRBAS |
| 14 | availability | Indicates whether the data are available to users other than the provider and IRBAS administrators | int | unitless | No rules associated | IRBAS |
| 25 | USconfluence_distance | distance from location or station to nearest upstream confluence | float | km | No rules associated | IRBAS |
| 26 | source_distance | distance from location or station to source of stream/river if no upstream confluence(s) | float | km | No rules associated | IRBAS |
| 27 | mouth_distance | distance from location or station to river mouth (at coastline) | float | km | No rules associated | IRBAS |
| 28 | DSconfluence_distance | distance from location or station to nearest downstream confluence (or river mouth if no downstream confluences) | float | km | No rules associated | IRBAS |
| 37 | discharge_mean_annual | Mean annual discharge over a set time period as indicated in the associated 'timespan' field. Data are derived from a flow-gauging station | float | m3 s^⁻1 | No rules associated | IRBAS |
| 39 | discharge_min_annual | Mean minimum annual discharge over a set time period as indicated in the associated 'timespan' field. Data are derived from a flow-gauging station | float | m3 s^⁻1 | No rules associated | IRBAS |
| 41 | discharge_max_annual | Mean maximum annual discharge over a set time period as indicated in the associated 'timespan' field. Data are derived from a flow-gauging station | float | m3 s^⁻1 | No rules associated | IRBAS |
| 43 | ZFD_mean_annual | Mean annual number of zero flow days over a set time period as indicated in the associated 'timespan' field. Data are derived from a flow-gauging station | int | days | No rules associated | IRBAS |
| 45 | ZFD_min_annual | Mean minimum annual number of zero flow days over a set time period as indicated in the associated 'timespan' field. Data are derived from a flow-gauging station | int | days | No rules associated | IRBAS |
| 47 | ZFD_max_annual | Mean maximum annual number of zero flow days over a set time period as indicated in the associated 'timespan' field. Data are derived from a flow-gauging station | int | days | No rules associated | IRBAS |
| 49 | rainfall_mean_annual | Mean annual precipitation over a set time period as indicated in the associated 'timespan' field. Data are derived from a rainfall-gauging station | float | mm | No rules associated | IRBAS |
| 51 | rainfall_min_annual | Mean minimum annual precipitation over a set time period as indicated in the associated 'timespan' field. Data are derived from a rainfall-gauging station | float | mm | No rules associated | IRBAS |
| 53 | rainfall_max_annual | Mean maximum annual precipitation over a set time period as indicated in the associated 'timespan' field. Data are derived from a rainfall-gauging station | float | mm | No rules associated | IRBAS |
| 55 | temperature_mean_annual | Mean annual temperature over a set time period as indicated in the associated 'timespan' field. Data are derived from a temperature-gauging station | float | °C | No rules associated | IRBAS |
| 57 | temperature_min_annual | Mean minimum annual temperature over a set time period as indicated in the associated 'timespan' field. Dare are derived from a temperature-gauging station | float | °C | No rules associated | IRBAS |
| 59 | temperature_max_annual | Mean maximum annual temperature over a set time period as indicated in the associated 'timespan' field. Data are from a temperature-gauging station | float | °C | No rules associated | IRBAS |
| 69 | mean_annual_ZF_dur | mean duration of zero fow at the location per year, in months, and as applicable to the period indicated in the associated 'timespan' field | float | unitless | No rules associated | IRBAS |
| 71 | mean_annual_dry_dur | mean duration of dry conditions (no surface water) at the location per year, in months, and as applicable to the period indicated in the associated 'timespan' field | float | unitless | No rules associated | IRBAS |
| 79 | replicat_number | number of replicat | int | unitless | No rules associated | IRBAS |
| 93 | number_samples | number of individual samples from which the data corresponding to this sample is derived (1 when the sample is a unique replicate, >1 when the sample data is a mean of mulitple replicates). Leave blank if this does not apply (but do not delete the column) | int | unitless | No rules associated | IRBAS |
| 94 | quantitative_sampling_depth | quantitative depth in water, soil or sediment at which sample was taken (from the water surface for water samples, from the bed or soil surface if sediment or soil samples). Leave blank if this does not apply (but do not delete the column) | float | m | No rules associated | IRBAS |
| 96 | area_sampled | area from which the sample was obtained. Leave blank if this does not apply (but do not delete the column) | float | m² | No rules associated | IRBAS |
| 97 | volume_sampled | volume from which the sample was obtained. Leave blank if this does not apply (but do not delete the column) | float | m³ | No rules associated | IRBAS |
| 98 | time_per_sample | time taken to obtain the sample. Leave blank if this does not apply (but do not delete the column) | float | min | No rules associated | IRBAS |
| 99 | TN | Total nitrogen concentration in a water sample determined in the laboratory using standard methods | float | mg L^⁻1 | No rules associated | IRBAS |
| 100 | TKN | Total Kjeldahl nitrogen concentration in a water sample determined in the laboratory using standard methods | float | mg L^⁻1 | No rules associated | IRBAS |
| 101 | TP | Total phosphorus concentration in a water sample determined in the laboratory using standard methods | float | mg L^⁻1 | No rules associated | IRBAS |
| 102 | TC | Total carbon concentration in a water sample determined in the laboratory using standard methods | float | mg L^⁻1 | No rules associated | IRBAS |
| 103 | TON | Total organic nitrogen concentration in a water sample determined in the laboratory using standard methods | float | mg L^⁻1 | No rules associated | IRBAS |
| 104 | TOP | Total organic phosphorus concentration in a water sample determined in the laboratory using standard methods | float | mg L^⁻1 | No rules associated | IRBAS |
| 105 | TOC | Total organic carbon concentration in a water sample determined in the laboratory using standard methods | float | mg L^⁻1 | No rules associated | IRBAS |
| 106 | DOP | Dissolved organic phosphorus concentration in a water sample determined in the laboratory using standard methods | float | mg L^⁻1 | No rules associated | IRBAS |
| 107 | DOC | Dissolved organic carbon concentration in a water sample determined in the laboratory using standard methods | float | mg L^⁻1 | No rules associated | IRBAS |
| 108 | NH4 | ammonium nitrogen (NH4-N) concentration in a water sample measured in the laboratory using standard methods | float | mg L^⁻1 | No rules associated | IRBAS |
| 109 | NOX | nitrate plus nitrite nitrogen concentration in a water sample measured in the laboratory using standard methods | float | mg L^⁻1 | No rules associated | IRBAS |
| 110 | NO2 | nitrite nitrogen concentration in a water sample measured in the laboratory using standard methods | float | mg L^⁻1 | No rules associated | IRBAS |
| 111 | NO3 | nitrate nitrogen concentration in a water sample measured in the laboratory using standard methods | float | mg L^⁻1 | No rules associated | IRBAS |
| 112 | SP | soluble phosphorus (soluble reactive plus soluble unreactive phosphorus, or orthophosphate) concentration in a water sample measured in the laboratory using standard methods | float | mg L^⁻1 | No rules associated | IRBAS |
| 113 | DIP_SRP | dissolved inorganic phosphorus (soluble reactive phosphorus) concentration in a water sample measured in the laboratory using standard methods | float | mg L^⁻1 | No rules associated | IRBAS |
| 114 | SO4 | sulfate sulfur concentration in a water sample measured in the laboratory using standard methods | float | mg L^⁻1 | No rules associated | IRBAS |
| 115 | Cl | chloride concentration in a water sample measured in the laboratory using standard methods | float | mg L^⁻1 | No rules associated | IRBAS |
| 116 | DL_TN | Lower detection limit for TN. Mandatory if a TN value has been provided | float | mg L^⁻1 | No rules associated | IRBAS |
| 117 | DL_TKN | Lower detection limit for TKN. Mandatory if a TKN value has been provided | float | mg L^⁻1 | No rules associated | IRBAS |
| 118 | DL_TP | Lower detection limit for TP. Mandatory if a TP value has been provided | float | mg L^⁻1 | No rules associated | IRBAS |
| 119 | DL_TC | Lower detection limit for TC. Mandatory if a TC value has been provided | float | mg L^⁻1 | No rules associated | IRBAS |
| 120 | DL_TON | Lower detection limit for TON. Mandatory if a TON value has been provided | float | mg L^⁻1 | No rules associated | IRBAS |
| 121 | DL_TOP | Lower detection limit for TOP. Mandatory if a TOP value has been provided | float | mg L^⁻1 | No rules associated | IRBAS |
| 122 | DL_TOC | Lower detection limit for TOC. Mandatory if a TOC value has been provided | float | mg L^⁻1 | No rules associated | IRBAS |
| 123 | DL_DOP | Lower detection limit for DOP. Mandatory if a DOP value has been provided | float | mg L^⁻1 | No rules associated | IRBAS |
| 81 | sampling_date_start | date sampling began for this sample | varchar | yyyy-mm-dd | No rules associated | IRBAS |
| 77 | discrete_ZF_period_timespan | The time period describing an individual zero-flow event at the location, as indicated by a start date (commencement of the zero-flow period) and an end date (end of the zero-flow period) | varchar | unitless | No rules associated | IRBAS |
| 78 | discrete_dry_period_timespan | The time period describing an individual no-surface-water event (i.e. when the riverbed is dry) at the location, as indicated by a start date (commencement of the dry period) and an end date (end of the dry period) | varchar | unitless | No rules associated | IRBAS |
| 124 | DL_DOC | Lower detection limit for DOC. Mandatory if a DOC value has been provided | float | mg L^⁻1 | No rules associated | IRBAS |
| 125 | DL_NH4 | Lower detection limit for NH4. Mandatory if a NH4 value has been provided | float | mg L^⁻1 | No rules associated | IRBAS |
| 126 | DL_NOX | Lower detection limit for NOX. Mandatory if a NOX value has been provided | float | mg L^⁻1 | No rules associated | IRBAS |
| 127 | DL_NO2 | Lower detection limit for NO2. Mandatory if a NO2 value has been provided | float | mg L^⁻1 | No rules associated | IRBAS |
| 128 | DL_NO3 | Lower detection limit for NO3. Mandatory if a NO3 value has been provided | float | mg L^⁻1 | No rules associated | IRBAS |
| 129 | DL_SP | Lower detection limit for SP. Mandatory if a SP value has been provided | float | mg L^⁻1 | No rules associated | IRBAS |
| 130 | DL_DIP_SRP | Lower detection limit for DIP_SRP. Mandatory if a DIP_SRP value has been provided | float | mg L^⁻1 | No rules associated | IRBAS |
| 131 | DL_SO4 | Lower detection limit for SO4. Mandatory if a SO4 value has been provided | float | mg L^⁻1 | No rules associated | IRBAS |
| 132 | DL_Cl | Lower detection limit for Cl. Mandatory if a Cl value has been provided | float | mg L^⁻1 | No rules associated | IRBAS |
| 133 | mean_depth_thalweg | mean water depth at thalweg | float | m | No rules associated | IRBAS |
| 134 | mean_wetted_width | mean width of wetted channel | float | m | No rules associated | IRBAS |
| 135 | SWGW_difference | height difference between the stream water level immediately outside of the piezometer(tube) and the water level in the piezometer(tube) sunk into the saturated sediments beneath the streambed. Positive values indicate the water level in the piezometer is is higher than the stream stage (groundwater is moving into the stream) and negative values that the water level is lower (stream water is moving into the saturated sediments) | float | cm | No rules associated | IRBAS |
| 136 | VHG | SWGW_difference divided by the depth (in cm) from the streambed to the bottom of piezometer for a solid pipe open at the bottom (or to the midpoint of the perforations or screened section for a piezometer with a slotted or perforated design). A positive value indicates upwelling and a negative value indicates downwelling | float | unitless | No rules associated | IRBAS |
| 137 | pH | pH of the water measured in situ with standard equipment | float | unitless | No rules associated | IRBAS |
| 138 | electrical_conductivity | electrical conductivity of the water measured in situ with standard equipment | float | uS cm^⁻1 | No rules associated | IRBAS |
| 139 | specific_conductance | electrical conductivity at 25 degrees Celcius of the water measured in situ with standard equipment | float | uS cm^⁻1 | No rules associated | IRBAS |
| 140 | temperature | temperature of the water collected with standard equipment | float | °C | No rules associated | IRBAS |
| 141 | dissolved_oxygen_saturated | dissolved oxygen (as % saturation) of the water collected with standard equipment | float | % | No rules associated | IRBAS |
| 142 | dissolved_oxygen_ppm | dissolved oxygen concentration of the water collected with standard equipment | float | mg L^⁻1 | No rules associated | IRBAS |
| 143 | Secchi | Water transparancy measured by Secchi disc | float | m | No rules associated | IRBAS |
| 144 | turbidity | Turbidity of the water column using the Nephelometric method in situ | float | NTU | No rules associated | IRBAS |
| 145 | discharge | discharge in the water column measured in situ | float | m3 s^⁻1 | No rules associated | IRBAS |
| 146 | discharge_from_gauge | discharge in the water column as derived from a flow gauge | float | m³ s^⁻2 | No rules associated | IRBAS |
| 147 | chlorophyll_fluorescence | Chlorophyll a in the water column measured by optical fluorescence in situ | float | % | No rules associated | IRBAS |
| 148 | alkalinity | bicarbonate plus carbonate concentration in a water sample determined in the laboratory using standard methods | float | meq L^⁻1 | No rules associated | IRBAS |
| 149 | hardness | calcium plus magnesium concentration in a water sample determined in the laboratory using standard methods | float | mg L^⁻1 | No rules associated | IRBAS |
| 150 | total_suspended_solids | Sum of all suspended solids in a water sample determined in the laboratiry using standard methods | float | mg L^⁻1 | No rules associated | IRBAS |
| 151 | chlorophyll_concentration | Chlorophyll a concentration in a water sample determined spectrophometrically in the laboratory using standard methods | float | mg L^⁻1 | No rules associated | IRBAS |
| 152 | fine_sediment | Mean percentage of fine sediment (clay, silt, sand) in the location sampled | float | % | No rules associated | IRBAS |
| 153 | clay | Mean percentage of clay (<0.004mm) in the location sampled | float | % | No rules associated | IRBAS |
| 154 | silt | Mean percentage of silt (0.004-0.06mm) in the location sampled | float | % | No rules associated | IRBAS |
| 155 | sand | Mean percentage of sand (0.06-2mm) in the location sampled | float | % | No rules associated | IRBAS |
| 156 | gravel | Mean percentage of gravel (2-16mm) in the location sampled | float | % | No rules associated | IRBAS |
| 157 | pebble | Mean percentage of pebble (16-64mm) in the location sampled | float | % | No rules associated | IRBAS |
| 158 | cobble | Mean percentage of cobble (64-256mm) in the location sampled | float | % | No rules associated | IRBAS |
| 159 | boulder | Mean percentage of boulder (>256mm) in the location sampled | float | % | No rules associated | IRBAS |
| 160 | bedrock | Mean percentage of bedrock in the habitat sampled | float | % | No rules associated | IRBAS |
| 161 | macrophytes | Mean percentage of aquatic macrophytes in the habitat sampled | float | % | No rules associated | IRBAS |
| 162 | bare | Mean percentage of bare riverbed in the habitat sampled | float | % | No rules associated | IRBAS |
| 163 | detritus | Mean percentage of leaf litter (detritus) in the location sampled | float | % | No rules associated | IRBAS |
| 164 | canopy_cover | Mean percentage of the wetted channel shaded by the riparian canopy | float | % | No rules associated | IRBAS |
| 167 | velocity40 | the water column velocity measured at 40% of the water depth above the bed | double | m s^-1 | From -4m s-1 to +4 m s-1 | Not use |
| 168 | strahler_stream_order | Strahler stream order which assesses the stream size based on a hierarchy of tributaries | int | unitless | From 1 to 12 | Not use |
| 171 | cpom_conservation | CPOM removal during sample cleaning on the field | boolean | unitless | No rules associated | Not use |
| 173 | sieve_63_value | counted or mesured value in sieve 63 µm | double | unitless | No rules associated | Not use |
| 174 | sieve_250_value | counted or mesured value in sieve 250 µm | double | unitless | No rules associated | saisie_labo |
| 175 | sieve_500_value | counted or mesured value in sieve 500 µm | double | unitless | No rules associated | saisie_labo |
| 176 | sieve_2000_value | counted or mesured value in sieve 2000 µm | double | unitless | No rules associated | saisie_labo |
| 177 | slope_perc | slope in percentage (distance up per 100 meters) | double | % | From 0 to 10 000 | Not use |
| 178 | slope_deg | slope in degree | double | ° | From 0 to 180 | Not use |
| 180 | velocity_0 | the water column velocity measured at 0% of the water depth above the bed | double | m s^-1 | From -3 to +3 m s-1 | Not use |
| 181 | velocity_20 | the water column velocity measured at 20% of the water depth above the bed | double | m s^-1 | From -3 to +3 m s-2 | Not use |
| 182 | velocity_40 | the water column velocity measured at 40% of the water depth above the bed | double | m s^-1 | From -3 to +3 m s-3 | Not use |
| 183 | velocity_60 | the water column velocity measured at 60% of the water depth above the bed | double | m s^-1 | From -3 to +3 m s-4 | Not use |
| 184 | velocity_80 | the water column velocity measured at 80% of the water depth above the bed | double | m s^-1 | From -3 to +3 m s-5 | Not use |
| 185 | velocity_100 | the water column velocity measured at 100% of the water depth above the bed | double | m s^-1 | From -3 to +3 m s-6 | Not use |
| 187 | velocity_time_integration | fixed period averaging | double | second | No rules associated | Not use |
| 189 | afdw | ash free dry mass in mg/cm2 | double | mg/cm^2 | No rules associated | Not use |
| 190 | photosynthetic_efficiency | photosynthetic efficiency mesured with Phyto-PAM (Pulse Amplitude Modulated) fluorometer | double | unitless | No rules associated | Not use |
| 191 | cyanobacteria_cover | Cyanobacteria cover in % | double | % | From 0 to 100 % | Not use |
| 192 | green_algea_cover | Green algea cover in % | double | % | From 0 to 100 % | Not use |
| 193 | brown_algea_cover | Brown algea cover in % | double | % | From 0 to 100 % | Not use |
| 194 | algal_growth_rate | algal growth in µg/cm2/day | double | µg/cm2/day | No rules associated | Not use |
| 195 | om_decomposition | Organic matter decomposition in g/day | double | g/day | No rules associated | Not use |
| 196 | cpom | Coarse Particulate Organic Matter in g | double | g | No rules associated | Not use |
| 197 | fpom | Fine (<1 mm in diameter Particulate Organic Matter in g | double | g | No rules associated | Not use |
| 198 | Pfankuch | Pfankuch index (substrate stability index) => Pfankuch 1975 | double | unitless | No rules associated | Not use |
| 199 | min_wetted_width | site's minimum wetted width | double | m | No rules associated | Not use |
| 200 | max_wetted_width | site's maximum wetted width | double | m | No rules associated | Not use |
| 201 | moss_cover | Mean percentage of moss cover | double | % | From 0 to 100 % | Not use |
| 202 | filamentous_algae_cover | Mean percentage of filamentous_algae cover | double | % | From 0 to 100 % | Not use |
| 203 | incrusted_algae_cover | Mean percentage of incruste algae cover | double | % | From 0 to 100 % | Not use |
| 204 | wood_cover | Mean percentage of wood cover | double | % | From 0 to 100 % | Not use |
| 205 | cd_transect | Unique code of the transect | int | unitless | No rules associated | Not use |
| 206 | max_depth | maximum depth of the site | double | cm | No rules associated | Not use |
| 207 | pool_depth | depth of the pool | double | cm | No rules associated | Not use |
| 208 | pool_area | area of the pool | double | m² | No rules associated | Not use |
| 209 | phototrap | presence of a photo trap on the site | boolean | unitless | No rules associated | Not use |
| 211 | installation_date | date of installation of the measuring device | date | yyyy-mm-dd | No rules associated | Not use |
| 212 | uninstallation_date | date of uninstallation of the measuring device | date | yyyy-mm-dd | No rules associated | Not use |
| 213 | intermittence_logger | presence of a logger of intermittence on the site | boolean | unitless | No rules associated | Not use |
| 214 | glacier_presence | presence of glacier in the catchment | boolean | unitless | No rules associated | Not use |
| 215 | glacier_influence_perc | percentage of glacier in the catchment (glacial area /catchment area) | double | % | No rules associated | Not use |
| 216 | catchment_size | area of the catchment in km² | double | km² | No rules associated | Not use |
| 225 | weight | length in cm | double | g | No rules associated | Not use |
| 226 | lengtht | weight in g | double | cm | No rules associated | Not use |
| 234 | date_of_identification | date of identification | date (yyyy-mm-dd) | yyyy-mm-dd | No rules associated | Not use |
| 236 | id_protocol | id of the protocol used to sample the data (biologic, physic, chemical, geographic,etc...) | int | unitless | No rules associated | saisie_labo |
| 237 | id_device | id of the device used to sample the data (biologic, physic, chemical, geographic,etc...) | int | unitless | No rules associated | saisie_labo |
| 1 | data_provider | The person and/or company who provided the data. For multiple providers, enter individual providers in consecutive columns | varchar | unitless | No rules associated | IRBAS |
| 2 | contact_name | The person to contact about the data. For multiple contacts, enter individual contacts in consecutive columns | varchar | unitless | No rules associated | IRBAS |
| 3 | contact_email | The contact email of the person to contact about the data. For multiple email addresses, enter individual email addresses in consecutive columns | varchar | unitless | No rules associated | IRBAS |
| 4 | collector | The person(s) responsible for sampling. Enter names of different people in consecutive columns | varchar | unitless | No rules associated | IRBAS |
| 5 | identifier | The person(s) who identified the biota. Enter names of different people in consecutive columns | varchar | unitless | No rules associated | IRBAS saisie_labo |
| 6 | coder | The person(s) who entered the data into the IRBAS templates. Enter names of different people in consecutive columns | varchar | unitless | No rules associated | IRBAS |
| 7 | project | The project associated with the sampling. For multiple projectss, enter individual projects in consecutive columns | varchar | unitless | No rules associated | IRBAS |
| 8 | author_s | The author(s) of the reference(s) associated with the data For multiple authors of the same reference, separate their names with commas. For multiple references, enter the requested data for individual references in consecutive columns, retaining the same order as that indicated in other 'reference' fields (author_s, publication_year, title, edition, reference_type, publication_repository) | varchar | unitless | No rules associated | IRBAS |
| 186 | velocity_processing | velocitymeter brand and model | varchar | unitless | No rules associated | Not use |
| 10 | title | The title of the reference(s) associated with the data. For multiple references, enter individual references in consecutive columns, retaining the same order as that indicated in other 'reference' fields (author_s, publication_year, title, edition, reference_type, publication_repository) | varchar | unitless | No rules associated | IRBAS |
| 11 | edition | The edition parameters of the reference(s) associated with the data. For multiple references, enter the requested data for individual references in consecutive columns, retaining the same order as that indicated in other 'reference' fields (author_s, publication_year, title, edition, reference_type, publication_repository) | varchar | unitless | No rules associated | IRBAS |
| 12 | reference_type | The reference type of the reference(s) associated with the data. For multiple references, enter the requested data for individual references in consecutive columns, retaining the same order as that indicated in other 'reference' fields (author_s, publication_year, title, edition, reference_type, publication_repository) | varchar | unitless | No rules associated | IRBAS |
| 13 | publication_repository | The physical or electronic location of the reference(s) associated with the data. For multiple references, enter the requested data for individual references in consecutive columns, retaining the same order as that indicated in other 'reference' fields (author_s, publication_year, title, edition, reference_type, publication_repository) | varchar | unitless | No rules associated | IRBAS |
| 15 | site_name | name of the site | varchar | unitless | No rules associated | IRBAS |
| 16 | location_name | name of the location sampled within the site | varchar | unitless | No rules associated | IRBAS |
| 17 | flow_station_name | name of the flow gauging station | varchar | unitless | No rules associated | IRBAS |
| 18 | flow_station_code | code name of the flow gauging station | varchar | unitless | No rules associated | IRBAS |
| 19 | rainfall_station_name | name of the rainfall gauging station | varchar | unitless | No rules associated | IRBAS |
| 20 | rainfall_station_code | code name of the rainfall gauging station | varchar | unitless | No rules associated | IRBAS |
| 21 | temperature_station_name | name of the temperature gauging station | varchar | unitless | No rules associated | IRBAS |
| 22 | temperature_station_code | code name of the temperature gauging station | varchar | unitless | No rules associated | IRBAS |
| 23 | catchment_name | name of the catchment (= watershed = river basin) in which the site and river are located | varchar | unitless | No rules associated | IRBAS |
| 24 | climate | The climate class for the location, based on its co-ordinates and the updated world map of the Köppen-Geiger climate classification by Peel et al. (2007) (available at: http://www.hydrol-earth-syst-sci.net/11/1633/2007/hess-11-1633-2007.html). You can download a Google-Earth layer of this map (available at: http://people.eng.unimelb.edu.au/mpeel/koppen.html) so you can quickly check the climate class of your sampling locations based on their coordinates | varchar | unitless | No rules associated | IRBAS |
| 29 | lat_station | The latitude of the flow, rainfall or temperature station (datum : WGS84). Mandatory if a flow, rainfall or temperature station_name or station_code has been provided | varchar | dec.deg. | No rules associated | IRBAS |
| 30 | long_station | The longitude of the flow, rainfall or temperature station (datum : WGS84). Mandatory if a flow, rainfall or temperature station_name or station_code has been provided | varchar | dec.deg. | No rules associated | IRBAS |
| 31 | flow_regime | The flow regime (perennial flow or otherwise) at the location or flow-station location over the period indicated in the associated 'timespan' field. Perennial implies surface water does not cease to flow at the location; non-perenial that surface water ceases to flow at the location. | varchar | unitless | No rules associated | IRBAS |
| 32 | flow_regime_timespan | The relevant time span to which the 'flow-regime' information applies | varchar | unitless | No rules associated | IRBAS |
| 33 | water_regime | The water regime (permanent presence of water or otherwise) at the location over the period indicated in the associated 'timespan' field. If the flow regime is perennial, the water regime must be permanent. If the flow regime is non-perennial, the water regime can be permanent (e.g. locations that are persistant pools) or non-permanent (e.g. locations in which streambeds dry) | varchar | unitless | No rules associated | IRBAS |
| 34 | water_regime_timespan | The relevant timespan to which the 'water-regime' information applies | varchar | unitless | No rules associated | IRBAS |
| 35 | geoclass | Geographic and geologic class of intermittency for the location, as defined by Larned et al. 2010 (does not apply to those perennially flowing) | varchar | unitless | No rules associated | IRBAS |
| 36 | intermittency_origin | Primary mechanism(s) controlling water loss at the location, as defined by Larned et al. 2010 (does not apply to those perennially flowing) | varchar | unitless | No rules associated | IRBAS |
| 38 | discharge_mean_annual_timespan | The relevant timespan and timestep to which the 'discharge_mean_annual' statistic applies | varchar | unitless | No rules associated | IRBAS |
| 40 | discharge_min_annual_timespan | The relevant timespan and timestep to which the 'discharge_min_annual' statistic applies | varchar | unitless | No rules associated | IRBAS |
| 42 | discharge_max_annual_timespan | The relevant timespan and timestep to which the 'discharge_max_annual' statistic applies | varchar | unitless | No rules associated | IRBAS |
| 44 | ZFD_mean_annual_timespan | The relevant timespan and timestep to which the 'ZFD_mean_annual' statistic applies | varchar | unitless | No rules associated | IRBAS |
| 46 | ZFD_min_annual_timespan | The relevant timespan and timestep to which the 'ZFD_min_annual' statistic applies | varchar | unitless | No rules associated | IRBAS |
| 48 | ZFD_max_annual_timespan | The relevant timespan and timestep to which the 'ZFD_max_annual' statistic applies | varchar | unitless | No rules associated | IRBAS |
| 50 | rainfall_mean_annual_timespan | The relevant timespan and timestep to which the 'rainfall_mean_annual' statistic applies | varchar | unitless | No rules associated | IRBAS |
| 52 | rainfall_min_annual_timespan | The relevant timespan and timestep to which the 'rainfall_min_annual' statistic applies | varchar | unitless | No rules associated | IRBAS |
| 54 | rainfall_max_annual_timespan | The relevant timespan and timestep to which the 'rainfall_max_annual' statistic applies | varchar | unitless | No rules associated | IRBAS |
| 56 | temperature_mean_annual_timespan | The relevant timespan and timestep to which the 'temperature_mean_annual' statistic applies | varchar | unitless | No rules associated | IRBAS |
| 58 | temperature_min_annual_timespan | The relevant timespan and timestep to which the 'temperature_min_annual' statistic applies | varchar | unitless | No rules associated | IRBAS |
| 60 | temperature_max_annual_timespan | The relevant timespan and timestep to which the 'temperature_max_annual' statistic applies | varchar | unitless | No rules associated | IRBAS |
| 61 | LULC | main land/water use or land cover at the location or station (in the riparian zone and surrounding lands within a 1km radius of the sampling location, taken from each river bank) and as applicable to the period indicated in the associated 'timespan' field | varchar | unitless | No rules associated | IRBAS |
| 62 | LULC_timespan | The relevant timespan to which the 'LULC' information applies. The timespan will usually equal the period over which your study was conducted. | varchar | unitless | No rules associated | IRBAS |
| 63 | human_mod_level | qualitative assessment of degree of human modification to flow regime and/or environmental habitat at and surrounding the location or station, as applicable to the period indicated in the associated 'timespan' field | varchar | unitless | No rules associated | IRBAS |
| 64 | human_mod_level_timespan | The relevant timespan to which the 'human_mod_level' information applies. The timespan will usually equal the period over which your study was conducted. | varchar | unitless | No rules associated | IRBAS |
| 65 | flow_impact_US | qualitative determination that the flow regime at the location is under significant impact from upstream human activities (e.g. major dam, groundwater abstraction), as applicable to the period indicated in the associated 'timespan' field | varchar | unitless | No rules associated | IRBAS |
| 66 | flow_impact_US_timespan | The relevant timespan to which the 'flow_impact_US' information applies. The timespan will usually equal the period over which your study was conducted. | varchar | unitless | No rules associated | IRBAS |
| 67 | WQ_impact_US | qualitative determination that the water quality at the location is under significant impact from upstream human activities (e.g. mining, dredging), as applicable to the period indicated in the associated 'timespan' field | varchar | unitless | No rules associated | IRBAS |
| 68 | WQ_impact_US_timespan | The relevant timespan to which the 'WQ_impact_US' information applies. The timespan will usually equal the period over which your study was conducted. | varchar | unitless | No rules associated | IRBAS |
| 70 | mean_annual_ZF_dur_timespan | The relevant timespan to which the 'mean_annual_ZF_dur' information applies. The timespan will usually equal the period over which your study was conducted. | varchar | unitless | No rules associated | IRBAS |
| 72 | mean_annual_dry_dur_timespan | The relevant timespan to which the 'mean_annual_dry_dur' information applies. The timespan will usually equal the period over which your study was conducted. | varchar | unitless | No rules associated | IRBAS |
| 73 | ZF_season | the most common flow-cessation season for the location, using seasons as previously defined, and as applicable to the period indicated in the associated 'timespan' field | varchar | unitless | No rules associated | IRBAS |
| 74 | ZF_season_timespan | The relevant timespan to which the 'ZF_season' information applies. The timespan will usually equal the period over which your study was conducted. | varchar | unitless | No rules associated | IRBAS |
| 75 | ZF_regularity | regularity of flow cessation events at the location, and as applicable to the period indicated in the associated 'timespan' field | varchar | unitless | No rules associated | IRBAS |
| 76 | ZF_regularity_timespan | The relevant timespan to which the 'ZF_regularity' information applies. The timespan will usually equal the period over which your study was conducted. | varchar | unitless | No rules associated | IRBAS |
| 80 | sample_name | name of the sample replicate (a unique identifier that follows naming convention rules) | varchar | unitless | No rules associated | IRBAS |
| 82 | sampling_date_end | date sampling ended for this sample (leave blank if same date as the start date but do not delete the column) | varchar | yyyy-mm-dd | No rules associated | IRBAS |
| 83 | sampling_season | season of sampling based on the date (month) in which sampling was conducted, using the meteorological seasons only (starting on the 1st day of Dec, Mar, Jun, Sep) and according to southern or northern hemisphere location | varchar | unitless | No rules associated | IRBAS |
| 84 | water_state | water state of sampling location across entire width of wetted or active channel | varchar | unitless | No rules associated | IRBAS |
| 85 | flow_state | flow state of sampling location across entire width of wetted or active channel | varchar | unitless | No rules associated | IRBAS |
| 86 | sampling_strategy | overall strategy (design) used to locate samples of this type (i.e. how were the positions of individual samples within a location chosen?) | varchar | unitless | No rules associated | IRBAS |
| 87 | sampling_strategy_coverage | strategy used to collect samples of this type (additional information to sampling_strategy) | varchar | YYYY | No rules associated | IRBAS |
| 88 | sampling_strategy_processing | strategy used to collect and/or process samples of this type (additional information to sample_strategy_coverage) | varchar | unitless | No rules associated | IRBAS |
| 89 | sampling_strategy_treatment | experimental treatment subjected or applicable to samples of this type. Leave blank if this does not apply (but do not delete the column) | varchar | unitless | No rules associated | IRBAS |
| 90 | sampling_protocol | method used to collect samples of type "physicochemsity" and "cover description". Leave blank if this does not apply to your sample type e.g. "waterbody dimensions" (but do not delete the column) | varchar | unitless | No rules associated | IRBAS |
| 91 | sampling_zone | the general type of environment ('zone') in which the sample was taken | varchar | unitless | No rules associated | IRBAS |
| 92 | sampling_habitat | type of habitat(s) sampled to collect this type of sample | varchar | unitless | No rules associated | IRBAS |
| 95 | qualitative_sampling_depth | qualitative depth at which sample was taken. Leave blank if this does not apply (but do not delete the column) | varchar | unitless | No rules associated | IRBAS |
| 165 | type_of_abundance_data | type of abundance data | varchar | unitless | No rules associated | IRBAS |
| 166 | life_stage | life stage | varchar | unitless | CHOICES: larva, adult, exuvia, pupa, undetermined | saisie_labo |
| 169 | watertype | watertype | varchar | unitless | CHOICES: running_water, standing_water, wetland, ground_water, terrestrial | Not use |
| 170 | weather | prevailing weather trend at the time of sampling | varchar | unitless | No rules associated | Not use |
| 172 | type_of_value | modalité possible: count/estimation | varchar | unitless | No rules associated | saisie_labo |
| 179 | comments | general comment | varchar | unitless | No rules associated | saisie_labo saisie_labo saisie_labo |
| 188 | preservation | name of the preservative method used | varchar | unitless | No rules associated | Not use |
| 210 | cd_phototrap | Unique code of the phototrap | varchar | unitless | No rules associated | Not use |
| 217 | identification_protocol | name of the protocol used for identification of the taxon | varchar | unitless | CHOICES: Morphology, Genetic, Accoustic, Behaviour | saisie_labo |
| 218 | catchment | name of studied catchment | varchar | unitless | No rules associated | Not use |
| 219 | collection_permit | name/number of the permit | varchar | unitless | No rules associated | Not use |
| 220 | nagoya_permit | name/number of the permit | varchar | unitless | No rules associated | Not use |
| 221 | handling_permit | name/number of the permit | varchar | unitless | No rules associated | Not use |
| 222 | protected_area | name of the protected area | varchar | unitless | No rules associated | Not use |
| 223 | studied_area | name of the studied area (i.e. geographical location or spatial extent of the study) | varchar | unitless | No rules associated | Not use |
| 224 | funding_agency | name of the funders (funding agencies) | varchar | unitless | No rules associated | Not use |
| 227 | typology_IB63 | typology according to Illies and Botosaneanu (1963) | varchar | unitless | CHOICES: eucrenal, hypocrenal, epirhithral, metarhithral, hyporhithral, epipotamal, metapotamal, hypopotamal, littoral, profundal | Not use |
| 228 | device_brand | device desciption (Brand, name of the model) | varchar | unitless | No rules associated | Not use |
| 229 | device_ref | device reference | varchar | unitless | No rules associated | Not use |
| 230 | device_type | name of the type of data recorded among the three main modalities | varchar | unitless | CHOICES: Biology, Physico-chemistry, Geography | Not use |
| 231 | device_name | name of the device | varchar | unitless | No rules associated | Not use |
| 232 | storage_id | id of the storage place, should refer to ID_storage used in an external source (eg. Collect-science, or personnal file...). | varchar | unitless | No rules associated | Not use |
| 233 | sorter | first name_last name of the person who sorted the biota. | varchar | unitless | No rules associated | saisie_labo |
| 235 | sensu | meaning "in the sense of" | varchar | unitless | CHOICES: lato, stricto, amplo | saisie_labo |
| 238 | protocol_name | name of the protocol used to sample the data (biologic, physic, chemical, geographic,etc...) | varchar | unitless | No rules associated | Not use |