Wiki source code of TerraIndex ReleaseNotes
Last modified by Roelof Zwaan on 2023/07/24 15:58
Hide last authors
| author | version | line-number | content |
|---|---|---|---|
 |
1.1 | 1 | == Changes and updates: == |
| 2 | |||
| |
8.1 | 3 | **26-07-2023** |
| 4 | |||
| 5 | (% class="table-hover" %) | ||
| 6 | |**Labeltext in English**|**Remarks**|**Definition and process how this field will be used and when it will be filled.**|((( | ||
| 7 | **Change/Add/** | ||
| 8 | |||
| 9 | **Delete** | ||
| 10 | )))|**DB Type | ||
| 11 | (String (length) / Float / Lookupvalue / Integer / DateTime)**|**DBTable in dsFieldProject**|**DBFieldname in dsFieldProject** | ||
| 12 | |Name inspector| |Field where the name of the fieldworker that performed the field inspection can be selected.|Add|String|tblSublocations|SlNameInspector | ||
| 13 | |Coverage removed?| |Yes/No field to indicate whether or not any vegetation was removed in order to perform a field inspection.|Add|Lookupvalue (73)|tblSublocations|((( | ||
| 14 | SlCoverageRemoved | ||
| 15 | ))) | ||
| 16 | |((( | ||
| 17 | Density (ton/m3) | ||
| 18 | )))| |Field where the name of the fieldworker that performed the field inspection can be selected.|Add|Float|tblLayers|LaDensity | ||
| 19 | |pH-value| |Field to enter the measured Ph value of this soil layer. Often used to map out contamination from drug waste.|Add|Float|tblLayers|LaPhValue | ||
| 20 | |CH4 (ppm)| |The CH4 (methane) value measured during the sampling of a soil air or ambient air sample. Measured in parts per million (ppm).|Add|Float|tblObservations|METINGCODE 162 | ||
| 21 | |((( | ||
| 22 | CO (ppm) | ||
| 23 | )))| |The CO (Carbonmonoxide) value measured during the sampling of a soil air or ambient air sample. Measured in parts per million (ppm).|Add|Float|tblObservations|METINGCODE 161 | ||
| 24 | |CH4 (ppm) Series value| |The CH4 (methane) value measured during the sampling of a soil air or ambient air sample. Measured in parts per million (ppm).|Add|Float|tblObservations|METINGCODE 162 | ||
| 25 | |((( | ||
| 26 | CO (ppm) Series value | ||
| 27 | )))| |The CO (Carbonmonoxide) value measured during the sampling of a soil air or ambient air sample. Measured in parts per million (ppm).|Add|Float|tblObservations|METINGCODE 161 | ||
| 28 | |((( | ||
| 29 | Reference of the Flow-measurement device | ||
| 30 | )))| |The reference number of the device used in this sampling of soil air.|Add|String|tblWatersamples|WsDebitReference | ||
| 31 | |((( | ||
| 32 | Reference of the explosimeter | ||
| 33 | )))| |The reference number of the device used in this sampling of soil air.|Add|String|tblWatersamples|((( | ||
| 34 | WsExplosimeterReference | ||
| 35 | ))) | ||
| 36 | |((( | ||
| 37 | Reference of the barometer | ||
| 38 | )))| |The reference number of the device used in this sampling of soil air.|Add|String|tblWatersamples|((( | ||
| 39 | WsBarometerReference | ||
| 40 | ))) | ||
| 41 | |((( | ||
| 42 | Reference of the O2/ Co2 sensor | ||
| 43 | )))| |The reference number of the device used in this sampling of soil air.|Add|String|tblWatersamples|((( | ||
| 44 | WsOxygenSensorReference | ||
| 45 | ))) | ||
| 46 | |((( | ||
| 47 | Reference PID-instrument | ||
| 48 | )))| |The reference number of the device used in this sampling of soil air.|Add|String|tblWatersamples|((( | ||
| 49 | WsPIDMeterReference | ||
| 50 | ))) | ||
| 51 | |((( | ||
| 52 | Reference of the hygrometer | ||
| 53 | )))| |The reference number of the device used in this sampling of soil air.|Add|String|tblWatersamples|((( | ||
| 54 | WsHygrometerReference | ||
| 55 | ))) | ||
| 56 | |((( | ||
| 57 | Reference of the pump | ||
| 58 | )))| |The reference number of the device used in this sampling of soil air.|Add|String|tblWatersamples|((( | ||
| 59 | WsPumpReference | ||
| 60 | ))) | ||
| 61 | |((( | ||
| 62 | Drilling fluid used | ||
| 63 | )))| |If a fluid was used to aid the drilling, that fluid can be specified in this field. Required by Spanish ENAC standards.|Add|Lookupvalue (293)|tblMeasurementPoints|((( | ||
| 64 | MpDrillingFluid | ||
| 65 | ))) | ||
| 66 | |((( | ||
| 67 | Reference PID-instrument | ||
| 68 | )))| |The referencecode of the used PID-instrument.|Add|String|tblMeasurementPoints|((( | ||
| 69 | MpPIDReference | ||
| 70 | ))) | ||
| 71 | |((( | ||
| 72 | Gravel grain size from (mm) | ||
| 73 | )))| |The median of the type of gravel that has been used in the finishings of a filtertube.|Add|Float|tblFinishings|((( | ||
| 74 | FiGravelSizeFrom | ||
| 75 | ))) | ||
| 76 | |Gravel grain size to (mm)| |The median of the type of gravel that has been used in the finishings of a filtertube.|Add|Float|tblFinishings|((( | ||
| 77 | FiGravelSizeTo | ||
| 78 | ))) | ||
| 79 | |((( | ||
| 80 | Type of rod grease used | ||
| 81 | )))| |The type of grease used to connect different parts of the filtertubes.|Add|Lookupvalue (295)|tblFilterTubes|((( | ||
| 82 | FtRodGrease | ||
| 83 | ))) | ||
| 84 | |((( | ||
| 85 | Reference of the purging water filter | ||
| 86 | )))| |The reference number of the device used in this sampling of soil air.|Add|String|tblWatersamples|((( | ||
| 87 | WsFilterReference | ||
| 88 | ))) | ||
| 89 | |((( | ||
| 90 | Reference of the multi-parameter sensor | ||
| 91 | )))| |The reference number of the device used in this sampling of soil air.|Add|String|tblWatersamples|((( | ||
| 92 | WsMultiParameterSensorReference | ||
| 93 | ))) | ||
| 94 | |((( | ||
| 95 | Reference of the waterlevel sensor | ||
| 96 | )))| |The reference number of the device used in this sampling of soil air.|Add|String|tblWatersamples|((( | ||
| 97 | WsGroundwaterSensorReference | ||
| 98 | ))) | ||
| 99 | |((( | ||
| 100 | n/a | ||
| 101 | )))| |Technical field for the exchange of field samples (air / water)|Add|GUID|tblWatersamples|WsFieldSampleGuid | ||
| 102 | |Reason| |Field t indicate the reason for starting the research|Add|Lookupvalue (294)|tblSummaryConclusion|((( | ||
| 103 | SmReasonCode | ||
| 104 | ))) | ||
| 105 | | | | | | | | | ||
| 106 | |||
| 107 | |||
| |
4.1 | 108 | **05-04-2023** |
| 109 | |||
| 110 | (% class="table-hover" %) | ||
| 111 | |**Labeltext in English**|**Remarks**|**Definition and process how this field will be used and when it will be filled.**|((( | ||
| 112 | **Change/Add/** | ||
| 113 | |||
| 114 | **Delete** | ||
| 115 | )))|**DB Type | ||
| 116 | (String (length) / Float / Lookupvalue / Integer / DateTime)**|**DBTable in dsFieldProject**|**DBFieldname in dsFieldProject** | ||
| 117 | |HDOP| |Precision value for the GPS coordinates.|Add|Float|tblMeasurementPoints|((( | ||
| 118 | MpHDOP | ||
| 119 | ))) | ||
| 120 | |VDOP| |Precision value for the GPS coordinates.|Add|Float|tblMeasurementPoints|((( | ||
| 121 | MpVDOP | ||
| 122 | ))) | ||
| 123 | |PDOP| |Precision value for the GPS coordinates.|Add|Float|tblMeasurementPoints|((( | ||
| 124 | MpPDOP | ||
| 125 | ))) | ||
| 126 | |Number of satellites used| |Field to note the amount of sattelites that where used for the GPS measurement in this measurement point.|Add|Integer|tblMeasurementPoints|((( | ||
| 127 | MpNumberOfSatellites | ||
| 128 | ))) | ||
| 129 | |HRMS| |Precision value for the GPS coordinates.|Add|Float|tblMeasurementPoints|((( | ||
| 130 | MpHRMS | ||
| 131 | ))) | ||
| 132 | |VRMS| |Precision value for the GPS coordinates.|Add|Float|tblMeasurementPoints|((( | ||
| 133 | MpVRMS | ||
| 134 | ))) | ||
| 135 | |((( | ||
| 136 | Gps pole height (m) | ||
| 137 | )))| |((( | ||
| 138 | Field to fill in the height of the GPS pole | ||
| 139 | )))|Add|Float|tblMeasurementPoints|((( | ||
| 140 | MpGPSPoleHeight | ||
| 141 | ))) | ||
| 142 | |((( | ||
| 143 | Antenna height (cm) | ||
| 144 | )))| |((( | ||
| 145 | Field to fill in the height of the antenna on the GPS machine | ||
| 146 | )))|Add|Float|tblMeasurementPoints|((( | ||
| 147 | MpAntennaHeight | ||
| 148 | ))) | ||
| |
5.1 | 149 | |Weather conditions| |((( |
| 150 | Field to fill in the weather conditions during the drilling process | ||
| 151 | )))|Add|Float|tblMeasurementPoints|MPWeatherConditions | ||
| 152 | |Ambient temperature (°C) | |((( | ||
| 153 | Outside temperature during the drilling process | ||
| 154 | )))|Add|Float|tblMeasurementPoints|((( | ||
| 155 | MpAmbientTemperature | ||
| 156 | ))) | ||
| 157 | |((( | ||
| 158 | CO (ppm) | ||
| 159 | )))| |((( | ||
| 160 | Field to save the measurement of carbon monoxide in the layer | ||
| 161 | )))|Add|Float|tblLayers|LaCO | ||
| 162 | |((( | ||
| 163 | Oxygen ~(%) | ||
| 164 | )))| |((( | ||
| 165 | Field to save the measurement of oxygen in the layer | ||
| 166 | )))|Add|Float|tblLayers|((( | ||
| 167 | LaOxygenPercentage | ||
| 168 | ))) | ||
| 169 | |((( | ||
| 170 | H2S (ppm) | ||
| 171 | )))| |Field to save the measurement of hydrogen sulfide in the layer|Add|Float|tblLayers|((( | ||
| 172 | LaH2S | ||
| 173 | ))) | ||
| 174 | |((( | ||
| 175 | LEL ~(%) | ||
| 176 | )))| |((( | ||
| 177 | Field the save the lower explosive level measurement in the layer | ||
| 178 | )))|Add|Float|tblLayers|((( | ||
| 179 | LaLEL | ||
| 180 | ))) | ||
| 181 | |Inspectie efficiency ~(%)| |The amount of soil in the layer that was able to be inspected properly for the purpose of asbestos research.|Add|Float|tblLayers|((( | ||
| 182 | LaInspectionEfficiencyPercentage | ||
| 183 | ))) | ||
| 184 | |Mixing of soil| |((( | ||
| 185 | Field to denote the amount of mixing in this soil layer | ||
| 186 | )))|Add|Integer (codelist 291)|tblLayers|((( | ||
| 187 | LaDegreeOfSoilMixingCode | ||
| 188 | ))) | ||
| 189 | |((( | ||
| 190 | CO (ppm) | ||
| 191 | )))| |((( | ||
| 192 | Field to save the measurement of carbon monoxide in the air sample | ||
| 193 | )))|Add|Float|tblObservations|METINGCODE 161 | ||
| 194 | |Jar type| |Soil sample ring added to the codelist|Add codelist value| | | | ||
| |
4.1 | 195 | |
| |
3.3 | 196 | **25-11-2022:** |
| 197 | |||
| 198 | (% class="table-hover" %) | ||
| 199 | |**Labeltext in English**|**Remarks**|**Definition and process how this field will be used and when it will be filled.**|((( | ||
| 200 | **Change/Add/** | ||
| 201 | |||
| 202 | **Delete** | ||
| 203 | )))|**DB Type | ||
| 204 | (String (length) / Float / Lookupvalue / Integer / DateTime)**|**DBTable in dsFieldProject**|**DBFieldname in dsFieldProject** | ||
| 205 | |Status| |((( | ||
| 206 | This field is for planned measurement points, and can be used to determine the status (to be done, done, removed etc) | ||
| 207 | )))|Add|Lookup value (codelist 289)|tblMeasurementPoints|((( | ||
| 208 | MpStatusCode | ||
| 209 | ))) | ||
| 210 | |((( | ||
| 211 | Penetrometer compaction strength (kg/cm2) | ||
| 212 | )))| |((( | ||
| 213 | This field is a numeric field for field tests to determine the compaction strength of the soil | ||
| 214 | )))|Add|numberfield|tblMeasurementPoints|MpPenetrometerCompaction | ||
| 215 | |((( | ||
| 216 | Accreditation number | ||
| 217 | )))| |((( | ||
| 218 | This field can be used to fill in the accreditation number of the fieldworker, which needs to be filled in by walloon customers | ||
| 219 | )))|Add|text field (30)|tblMeasurementPoints|((( | ||
| 220 | MpAccreditationNumber | ||
| 221 | ))) | ||
| 222 | |Moisture Class Soil| |((( | ||
| 223 | This field is for giving moisture classes in soil, these are present in the NEN 6693 and also used for french research. | ||
| 224 | )))|Add|Lookup value (codelist 290)|tblLayers|((( | ||
| 225 | LaMoistureClass | ||
| 226 | ))) | ||
| 227 | |Sediment Sump Length (cm)| |((( | ||
| 228 | Field to input the length within the tube that is used as a sand / silt catchment below the filter | ||
| 229 | )))|Add|numberfield|tblFilterTubes|FtSedimentSumpLength | ||
| 230 | |Length / Width|Multi edit turned on in grid vierw| |Change|numberfield|tblMeasurementPoints|((( | ||
| 231 | MpTrialPitLength & MpTrialPitWidth | ||
| 232 | ))) | ||
| 233 | |Length / Width|Multi edit turned on in grid vierw| |Change|numberfield|tblLayers|((( | ||
| 234 | LaTrialPitLength & LaTrialPitWidth | ||
| 235 | ))) | ||
| 236 | |Initial function| |((( | ||
| 237 | Field to input the function of the filtertube when it was installed | ||
| 238 | )))|Add|Lookup value (codelist 288)|tblFilterTubes|FtInitialFiltertubeFunction | ||
| 239 | |Weather conditions| |((( | ||
| 240 | Remarkable weather conditions can be noted here as part of a location inspection | ||
| 241 | )))|Add|String|tblSublocations|((( | ||
| 242 | SlCoverRatePostRemoval | ||
| 243 | ))) | ||
| 244 | |Sampling procedure| |Field to fill in the used sampling procedure|Add|Lookup value (codelist 287)|tblWatersamples|WsSamplingProcedure | ||
| |
3.4 | 245 | |Starttime & Endtime sampling|Already existed for airsamples, no as well for watersamples| |Change|Datetime|tblWatersamples|((( |
| 246 | WsStartSampleTime & WsPostSampleTime | ||
| 247 | ))) | ||
| 248 | |Radioactive ionisation (cps)| |((( | ||
| 249 | Numberfield to input the cps (counts per second) of a meter that reacts to ionisation (like a geiger counter) | ||
| 250 | )))|Add|numberfield|tblJars|((( | ||
| 251 | JrIonisationCount | ||
| 252 | ))) | ||
| 253 | |Sample water content ~(%)| |((( | ||
| 254 | Percentage field for sample humidity | ||
| 255 | )))|Add|numberfield|tblJars|JrHumidityPercentage | ||
| 256 | |((( | ||
| 257 | Volume weight dry Yd (Kn/M3) | ||
| 258 | )))| |((( | ||
| 259 | Geotechnical field for the dry weight of the sample, different unit than the other weight sample fields which are more simplistic | ||
| 260 | )))|Add|numberfield|tblJars|JrDryVolumeWeight | ||
| 261 | |Liquit limit water content ~(%)| |The liquid limit used within the attenbergs limits|Add|numberfield|tblJars|JrLiquidLimit | ||
| 262 | |Plasticity index ~(%)| |((( | ||
| 263 | Geotechnical field for the plasticity index | ||
| 264 | )))|Add|numberfield|tblJars|JrPlasticityIndex | ||
| 265 | |((( | ||
| 266 | Semi-Solid limit (water content %) | ||
| 267 | )))| |The semi-solid limit used within the attenbergs limits|Add|numberfield|tblJars|JrSemiSolidLimit | ||
| 268 | |((( | ||
| 269 | Plastic limit (water content %) | ||
| 270 | )))| |The plastic limit used within the attenbergs limits|Add|numberfield|tblJars|JrPlasticLimit | ||
| 271 | |((( | ||
| 272 | Undrained shear strength (kPa) | ||
| 273 | )))| |The shear strength of the soil|Add|numberfield|tblJars|JrUndrainedShearStrength | ||
| 274 | |Void ratio ~(%)| |The ratio of void (air) in the soil|Add|numberfield|tblJars|JrVoidRatio | ||
| 275 | |Saturation ~(%)| |The percentage of moisture saturation in the soil|Add|numberfield|tblJars|JrSaturationPercentage | ||
| 276 | |Soil sampes (several fields)|Multi edit turned on| |Change| |tblJars|Several | ||
| 277 | |Destination Type| |Field for destination type for the OVAM|Add|Lookup value (codelist 49)|tblProjects|PrDestinationType | ||
| 278 | |Groundwater vulnerability| |Field for groundwater vulnerability for the OVAM|Add|Lookup value (codelist 92)|tblProjects|PrGroundwaterVulnerability | ||
| 279 | |Percentage Fractrion >20mm| |Asbestos fields now als on layer level|Add|numberfield|tblLayers|LaCourseFractionPercentage | ||
| 280 | |Weight fraction >20 mm| |Asbestos fields now als on layer level|Add|numberfield|tblLayers|LaCourseFractionWeight | ||
| 281 | |Weight fraction <20 mm| |Asbestos fields now als on layer level|Add|numberfield|tblLayers|LaFineFractionWeight | ||
| 282 | |Type plate material| |Asbestos fields now als on layer level|Add|Lookup value (281)|tblLayers|LaPlateMaterialTypeCode | ||
| 283 | |Number of pieces plate material| |Asbestos fields now als on layer level|Add|numberfield|tbLLayers|LaPlateMaterialPieces | ||
| 284 | |Weight plate material (g)| |Asbestos fields now als on layer level|Add|numberfield|tblLayers|LaPlateMaterialWeight | ||
| |
3.5 | 285 | |Special component gradation|Add codelist "A little (bit of)"| |Add Codelist value| | | |
| 286 | |Sand sorting codes|Add extra sand and gravel sorting codes| |Add Codelist value| | | | ||
| 287 | |Geological interpretation|All new belgium geological interpretation options added| |Add Codelist value| | | | ||
| 288 | |End prepump citeria|New prepump ending condition added| |Add Codelist value| | | | ||
| 289 | |Finishing Type|Type 'Asfalt' added| |Add Codelist value| | | | ||
| 290 | |Project Type|New French Project types added| |Add Codelist value| | | | ||
| 291 | |Colour Type|Colour 'Pink' added| |Add Codelist value| | | | ||
| 292 | |Use of location|Additional location uses added| |Add Codelist value| | | | ||
| |
3.3 | 293 | |
| |
2.3 | 294 | **03-08-2022:** |
| 295 | |||
| 296 | (% class="table-hover" %) | ||
| 297 | |**Labeltext in English**|**Remarks**|**Definition and process how this field will be used and when it will be filled.**|((( | ||
| 298 | **Change/Add/** | ||
| 299 | |||
| 300 | **Delete** | ||
| 301 | )))|**DB Type | ||
| 302 | (String (length) / Float / Lookupvalue / Integer / DateTime)**|**DBTable in dsFieldProject**|**DBFieldname in dsFieldProject** | ||
| 303 | |Special or invasive vegetation(1, 2, 3)| |Field to note invasive species found on the release location. New codelist with species from the dutch invasive species list added.|Add|Lookup value (codelist 285)|tblSublocations|((( | ||
| |
3.2 | 304 | SlSpecialVegetationCode |
| |
2.3 | 305 | ))) |
| 306 | |Sieved material inspection hole| |Field to note the total amount of sieved material at the measurementpoint level of an asbestos inspection hole|Add|Float|tblMeasurementPoints|MpSievedMaterial | ||
| 307 | |Water depth (cm-gl)| |Field to describe the column of water above the waterbed, if chosen not to add a water layer as the first layer.|Add|Float|tblMeasurementPoints|MpWaterDepth | ||
| 308 | |Special component in layer (mass%)| |Can be used to note the total mass % of foreign (non-soil) material in a layer.|Add|Float|tblLayers|LaSpecialComponentPercent | ||
| 309 | |Suspected Asbestos pollution| |Field by which a fieldworker can remark if a layer is suspect of containing asbestos|Add|Lookup value (codelist 73)|tblLayers|LaSuspectedAsbestosCode | ||
| 310 | |Measurement point type|New codelist options added|Canister, Ambient air measurement added|Change|Lookup value (codelist 24)|tblMeasurementpoints|MpTypeCode | ||
| 311 | |Reference plane|New codelist options added|Sea level added|Change|Lookup value (codelist 15)|tblMeasurementpoints|MpReferencePointTypeCode | ||
| |
2.5 | 312 | |Finishing Type|New codelist options added|Surface box plasic, Surface box stainless steel added|Change|Lookup value (codelist 32)|tblFinishings|FiTypeCode |
| 313 | |Horizon|New codelist options added|Unit R0, Unit R1, Unit R2 added|Change|Lookup value (codelist 109)|tblLayers|LaHorizonCode | ||
| 314 | |Soil / Rock Type|New codelist options added|Granodiorite added|Change|Lookup value (codelist 163 and 35)|tblLayers|LaRockTypeCode | ||
| 315 | |Special component type|New codelist options added|((( | ||
| 316 | Construction and demolition waste, Calcium nodules, calcium crusts, Stones >50MM added | ||
| 317 | )))|Change|Lookup value (codelist 11)|tblLayers|LaSc1TypeCode | ||
| 318 | |Drilling System|New codelist options added|Tubed edelman, tubed pulse drill, tubed percussion gouge added|Change|Lookup value (codelist 23)|tblLayers|LaDrillingSystemTypeCode | ||
| 319 | |Clarity|New codelist options added|None, Low, medium, high clarity codes added|Change|Lookup value (codelist 252)|tblWatersamples|LaClarityCode | ||
| 320 | |Stop prepumping|New codelist options added|1x volume of drilling well + parameters stabilisation added|Change|Lookup value (codelist 200)|tblWatersamples|WsPrepumpingEndedTypeCode | ||
| 321 | |Sampling method|New codelist options added|multi support active sampling|Change|Lookup value (codelist 259)|tblWatersamples|WsSamplingMethodCode | ||
| 322 | |Placed in serie|New codelist options added|New codelist: Unique, in paralel, in series added|Change|Lookup value (codelist 284)|WsPackagings|BoPlacedInSerie | ||
| 323 | |Air sample Type|New codelist options added|Impregnated filter added|Change|Lookup value (codelist 272)|WsPackagings|BoSampleTypeCode | ||
| 324 | |Field matrix|New codelist options added|Waterbed (solid part) added|Change|Lookup value (codelist 6)|WsAnalysisSamples|MatrixTypeCode | ||
| |
2.3 | 325 | |
| |
2.2 | 326 | **27-01-2022:** |
| 327 | |||
| 328 | (% class="table-hover" %) | ||
| 329 | |**Labeltext in English**|**Remarks**|**Definition and process how this field will be used and when it will be filled.**|((( | ||
| 330 | **Change/Add/** | ||
| 331 | |||
| 332 | **Delete** | ||
| 333 | )))|**DB Type | ||
| 334 | (String (length) / Float / Lookupvalue / Integer / DateTime)**|**DBTable in dsFieldProject**|**DBFieldname in dsFieldProject** | ||
| 335 | |Use of location| |To add the current use of the location to a measurement point|Add|Lookupvalue|tblMeasurementPoints|MpLocationUsageCode | ||
| 336 | |Type|New codelist optios added |-|Change|Lookupvalue|tblMeasurementPoint|MpType | ||
| 337 | |Interior location| |Yes / no field for if the sample is an interior location|Add|Lookupvalue|tblMeasurementPoints|MpIsIndoorsCode | ||
| 338 | |FlowTypesSurfaceWater| |Describes the flowing pattern of the surface water sampling location|Add|Lookupvalue|tblObservations|METINGCODE 148 | ||
| 339 | |Location flow rate| |The flow rate of the sampling location|Add|Lookupvalue|tblObservations|METINGCODE 149 | ||
| 340 | |Special conditions| |Remark field for special sampling conditions to print in report|Add|String|tblWatersamples|JrStreamlineGUID | ||
| 341 | |Pump type|Codelist used for several fields|New options added to codelist|Change|Lookupvalue|Multiple fields|Multiple fields | ||
| 342 | |Pump connection| |Field for the power connection of a pump|Add|LookupValue|tblObservations|METINGCODE 150 | ||
| 343 | |Matrix| |Added codelist options|Change|Lookupvalue|tblWatersamples|WsMatrix | ||
| 344 | |Mesh size (mm)| |Field for the mesh size of a monitoring well filter|Add|Float|tblFiltertubes|FtMeshSize | ||
| 345 | |Type|Project level|New codelist options|Change|Lookupvalue|tblProjects|PrType | ||
| 346 | |Type|Finishing level|New codelist options|Change|Lookupvalue|tblFinishings|FiType | ||
| 347 | |Measurement duration| |Field for the duration of a series of a measurements, mostly used to estimate the time when a tube is dry|Add|Float|tblObservations|METINGCODE 154 (Series), METINGCODE 153 (Stable value) | ||
| 348 | |Pumped volume series| |Field for the total pumped volume during a single series|Add|Float|tblObservations|METINGCODE 152 (Series), METINGCODE 151 (Stable value) | ||
| 349 | |||
| |
1.1 | 350 | **22-11-2021:** |
| 351 | |||
| 352 | |**Screen to add the extra field**|**Labeltext of field in English**|**Labeltext in Dutch**|**Examples of values and how it should be printed in a report.**|**Definition and process how this field will be used and when it will be filled.**|**Codelist CategoryID**|**Change/Add/Delete**|**DB Type**|**DBTable in dsFieldProject**|**DBFieldname in dsFieldProject** | ||
| 353 | | | | | | | | | | | | ||
| 354 | |Soil samples|Length core sampler|Lengte steekbuis (mm)|Length core sampler (mm)|The length of a core sampler may vary and defines volume| |Add|Integer|tblJars|JrLengthCoreSampler | ||
| 355 | |Measurement Point|Diameter|Diameter (mm)|Diameter (mm)|(% colspan="2" %)Information is available on layer level, but may sometimes be consistent over the entire measurement point|Add|Integer|tblMeasurementPoints|MpDiameter | ||
| 356 | |Air Samples packaging|Placed in serie|In serie geplaatst|Yes/no|Two packages for air samples can be placed in serie or not| |Add|Lookupvalue (Yes/No)|tblBottles|BoPlacedInSerie | ||
| 357 | |Water samples|Surrounding humidity|Omgevingsvochtigheid|Licht vochtig, Zeer vochtig, Vochtig op bodem, Vochtig op plaatsen|The circumstances when sampling| |Add|Codelist|((( | ||
| 358 | * tblObservations | ||
| 359 | * tblWatersampleMeasurements | ||
| 360 | )))|Metingcode: 147 / WsSurroundingHumidity | ||
| 361 | |||
| 362 | **18-10-2021:** | ||
| 363 | |||
| 364 | |=(% colspan="1" rowspan="1" %)((( | ||
| 365 | **Labeltext in English** | ||
| 366 | )))|=(% colspan="1" rowspan="1" %)((( | ||
| 367 | **Remarks** | ||
| 368 | )))|=(% colspan="1" rowspan="1" %)((( | ||
| 369 | **Definition and process how this field will be used and when it will be filled.** | ||
| 370 | )))|=(% colspan="1" rowspan="1" %)((( | ||
| 371 | **Change/Add/Delete** | ||
| 372 | )))|=(% colspan="1" rowspan="1" %)((( | ||
| 373 | **DB Type** | ||
| 374 | **(String (length) / Float / Lookupvalue / Integer / DateTime)** | ||
| 375 | )))|=(% colspan="1" rowspan="1" %)((( | ||
| 376 | **DBTable in dsFieldProject** | ||
| 377 | )))|=(% colspan="1" rowspan="1" %)((( | ||
| 378 | **DBFieldname in dsFieldProject** | ||
| 379 | ))) | ||
| 380 | |(% colspan="1" rowspan="1" %)StreamlineGUID|(% colspan="1" rowspan="1" %)Does not have to be unique|(% colspan="1" rowspan="1" %)To facilate synchronisation between Streamline and Classic|(% colspan="1" rowspan="1" %)Add|(% colspan="1" rowspan="1" %)Unique identifier |(% colspan="1" rowspan="1" %)tblProjects|(% colspan="1" rowspan="1" %)PrStreamlineGUID | ||
| 381 | |(% colspan="1" rowspan="1" %)StreamlineGUID|(% colspan="1" rowspan="1" %)Does not have to be unique|(% colspan="1" rowspan="1" %)To facilate synchronisation between Streamline and Classic|(% colspan="1" rowspan="1" %)Add|(% colspan="1" rowspan="1" %)Unique identifier |(% colspan="1" rowspan="1" %)tblMeasurementPoint|(% colspan="1" rowspan="1" %)MpStreamlineGUID | ||
| 382 | |(% colspan="1" rowspan="1" %)StreamlineGUID|(% colspan="1" rowspan="1" %)Does not have to be unique|(% colspan="1" rowspan="1" %)To facilate synchronisation between Streamline and Classic|(% colspan="1" rowspan="1" %)Add|(% colspan="1" rowspan="1" %)Unique identifier |(% colspan="1" rowspan="1" %)tblWaterSample |(% colspan="1" rowspan="1" %)WsStreamlineGUID | ||
| 383 | |(% colspan="1" rowspan="1" %)StreamlineGUID|(% colspan="1" rowspan="1" %)Does not have to be unique|(% colspan="1" rowspan="1" %)To facilate synchronisation between Streamline and Classic|(% colspan="1" rowspan="1" %)Add|(% colspan="1" rowspan="1" %)Unique identifier |(% colspan="1" rowspan="1" %)tblFiltertubes|(% colspan="1" rowspan="1" %)FtStreamlineGUID | ||
| 384 | |(% colspan="1" rowspan="1" %)StreamlineGUID|(% colspan="1" rowspan="1" %)Does not have to be unique|(% colspan="1" rowspan="1" %)To facilate synchronisation between Streamline and Classic|(% colspan="1" rowspan="1" %)Add|(% colspan="1" rowspan="1" %)Unique identifier |(% colspan="1" rowspan="1" %)tblLayers|(% colspan="1" rowspan="1" %)LaStreamlineGUID | ||
| 385 | |(% colspan="1" rowspan="1" %)StreamlineGUID|(% colspan="1" rowspan="1" %)Does not have to be unique|(% colspan="1" rowspan="1" %)To facilate synchronisation between Streamline and Classic|(% colspan="1" rowspan="1" %)Add|(% colspan="1" rowspan="1" %)Unique identifier |(% colspan="1" rowspan="1" %)tblJars|(% colspan="1" rowspan="1" %)JrStreamlineGUID | ||
| 386 | |(% colspan="1" rowspan="1" %)PackagingStreamlineGUID|(% colspan="1" rowspan="1" %)Does not have to be unique|(% colspan="1" rowspan="1" %)To facilate synchronisation between Streamline and Classic|(% colspan="1" rowspan="1" %)Add|(% colspan="1" rowspan="1" %)Unique identifier |(% colspan="1" rowspan="1" %)tblJars|(% colspan="1" rowspan="1" %)JrPackagingStreamlineGUID | ||
| 387 | |(% colspan="1" rowspan="1" %)StreamlineGUID|(% colspan="1" rowspan="1" %)Does not have to be unique|(% colspan="1" rowspan="1" %)To facilate synchronisation between Streamline and Classic|(% colspan="1" rowspan="1" %)Add|(% colspan="1" rowspan="1" %)Unique identifier |(% colspan="1" rowspan="1" %)tblFinishings|(% colspan="1" rowspan="1" %)FiStreamlineGUID | ||
| 388 | |(% colspan="1" rowspan="1" %)StreamlineGUID|(% colspan="1" rowspan="1" %)Does not have to be unique|(% colspan="1" rowspan="1" %)To facilate synchronisation between Streamline and Classic|(% colspan="1" rowspan="1" %)Add|(% colspan="1" rowspan="1" %)Unique identifier |(% colspan="1" rowspan="1" %)tblBottles|(% colspan="1" rowspan="1" %)BoStreamlineGUID | ||
| 389 | |(% colspan="1" rowspan="1" %)StreamlineGUID|(% colspan="1" rowspan="1" %)Does not have to be unique|(% colspan="1" rowspan="1" %)To facilate synchronisation between Streamline and Classic|(% colspan="1" rowspan="1" %)Add|(% colspan="1" rowspan="1" %)Unique identifier |(% colspan="1" rowspan="1" %)tblLocations|(% colspan="1" rowspan="1" %)LcStreamlineGUID | ||
| 390 | |(% colspan="1" rowspan="1" %)StreamlineGUID|(% colspan="1" rowspan="1" %)Does not have to be unique|(% colspan="1" rowspan="1" %)To facilate synchronisation between Streamline and Classic|(% colspan="1" rowspan="1" %)Add|(% colspan="1" rowspan="1" %)Unique identifier |(% colspan="1" rowspan="1" %)tblSublocations|(% colspan="1" rowspan="1" %)SlStreamlineGUID | ||
| |
2.1 | 391 | |
| 392 | **07-10-2021:** | ||
| 393 | |||
| 394 | |=(% colspan="1" rowspan="1" %)((( | ||
| 395 | **Screen to add the extra field** | ||
| 396 | )))|=(% colspan="1" rowspan="1" %)((( | ||
| 397 | **Labeltext in English** | ||
| 398 | )))|=(% colspan="1" rowspan="1" %)((( | ||
| 399 | **Labeltext in Dutch** | ||
| 400 | )))|=(% colspan="1" rowspan="1" %)((( | ||
| 401 | **Examples of values and how it should be printed in a report.** | ||
| 402 | )))|=(% colspan="1" rowspan="1" %)((( | ||
| 403 | **Definition and process how this field will be used and when it will be filled.** | ||
| 404 | )))|=(% colspan="1" rowspan="1" %)((( | ||
| 405 | **Change/Add/Delete** | ||
| 406 | )))|=(% colspan="1" rowspan="1" %)((( | ||
| 407 | **DB Type** | ||
| 408 | **(String (length) / Float / Lookupvalue / Integer / DateTime)** | ||
| 409 | )))|=(% colspan="1" rowspan="1" %)((( | ||
| 410 | **DBTable in dsFieldProject** | ||
| 411 | )))|=(% colspan="1" rowspan="1" %)((( | ||
| 412 | **DBFieldname in dsFieldProject** | ||
| 413 | ))) | ||
| 414 | |(% colspan="1" rowspan="1" %)Measurement Points Details|(% colspan="1" rowspan="1" %)Sample Moisture|(% colspan="1" rowspan="1" %)Monstervochtigheid|(% colspan="1" rowspan="1" %)Dried out|(% colspan="1" rowspan="1" %)Explains humidity condition of measurment point|(% colspan="1" rowspan="1" %)Add Field|(% colspan="1" rowspan="1" %)string (10)|(% colspan="1" rowspan="1" %)tblMeasurementPoint|(% colspan="1" rowspan="1" %)MpSampleHumidityCode | ||
| 415 | |(% colspan="1" rowspan="1" %)Air sample details|(% colspan="1" rowspan="1" %)Special conditions|(% colspan="1" rowspan="1" %)Bijzondere omstandigheden|(% colspan="1" rowspan="1" %)Normal, used standard protocol|(% colspan="1" rowspan="1" %)Description of deviation from protocol|(% colspan="1" rowspan="1" %)Add Field|(% colspan="1" rowspan="1" %)string (2000)|(% colspan="1" rowspan="1" %)tblWaterSample|(% colspan="1" rowspan="1" %)WsSpecialConditions | ||
| 416 | |(% colspan="1" rowspan="1" %)Air sample details|(% colspan="1" rowspan="1" %)Field conditions|(% colspan="1" rowspan="1" %)Maaiveld omstandigheden|(% colspan="1" rowspan="1" %)Damp, easy to drill|(% colspan="1" rowspan="1" %)Description of field/location at time of sampling|(% colspan="1" rowspan="1" %)Add Field|(% colspan="1" rowspan="1" %)string (2000)|(% colspan="1" rowspan="1" %)tblWaterSample|(% colspan="1" rowspan="1" %)WsFieldConditions | ||
| 417 | |(% colspan="1" rowspan="1" %)Air sample details|(% colspan="1" rowspan="1" %)Calibration - O2|(% colspan="1" rowspan="1" %)Kalibratie Zuurstof ~(%)|(% colspan="1" rowspan="1" %)25%|(% colspan="1" rowspan="1" %)Filled in when performing the leaking test before prepumping|(% colspan="1" rowspan="1" %)Add Field|(% colspan="1" rowspan="1" %)float|(% colspan="1" rowspan="1" %)tblObservations/tblWatersampleMeasurements|(% colspan="1" rowspan="1" %)Metingcode: 136 / WsCalibrationO2 | ||
| 418 | |(% colspan="1" rowspan="1" %)Air sample details|(% colspan="1" rowspan="1" %)Calibration - CO2|(% colspan="1" rowspan="1" %)Kalibratie koolstofdioxine/CO2 (ppm)|(% colspan="1" rowspan="1" %)25ppm|(% colspan="1" rowspan="1" %)Filled in when performing the leaking test before prepumping|(% colspan="1" rowspan="1" %)Add Field|(% colspan="1" rowspan="1" %)float|(% colspan="1" rowspan="1" %)tblObservations/tblWatersampleMeasurements|(% colspan="1" rowspan="1" %)Metingcode: 137 / WsCalibrationCO2 | ||
| 419 | |(% colspan="1" rowspan="1" %)Air sample details|(% colspan="1" rowspan="1" %)Start-sampling time|(% colspan="1" rowspan="1" %)Tijdstip start bemonstering|(% colspan="1" rowspan="1" %)11:30:00|(% colspan="1" rowspan="1" %)Time when the actual sampling has started|(% colspan="1" rowspan="1" %)Add Field|(% colspan="1" rowspan="1" %)datetime|(% colspan="1" rowspan="1" %)tblWaterSample|(% colspan="1" rowspan="1" %)WsStartSampleTime | ||
| 420 | |(% colspan="1" rowspan="1" %)Air sample details|(% colspan="1" rowspan="1" %)Post-sampling time|(% colspan="1" rowspan="1" %)Tijdstip einde monstername|(% colspan="1" rowspan="1" %)11:30:00|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)Add Field|(% colspan="1" rowspan="1" %)datetime|(% colspan="1" rowspan="1" %)tblWaterSample|(% colspan="1" rowspan="1" %)WsPostSampleTime | ||
| 421 | |(% colspan="1" rowspan="1" %)Air sample details|(% colspan="1" rowspan="1" %)Post- sampling O2|(% colspan="1" rowspan="1" %)Zuurstof einde monstername |(% colspan="1" rowspan="1" %)25%|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)Add Field|(% colspan="1" rowspan="1" %)float|(% colspan="1" rowspan="1" %)tblObservations/tblWatersampleMeasurements|(% colspan="1" rowspan="1" %)Metingcode: 140 / WsPostSampleO2 | ||
| 422 | |(% colspan="1" rowspan="1" %)Air sample details|(% colspan="1" rowspan="1" %)Post-sampling CO2|(% colspan="1" rowspan="1" %)Koolstofdioxine/CO2 einde monstername (ppm)|(% colspan="1" rowspan="1" %)25ppm|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)Add Field|(% colspan="1" rowspan="1" %)float|(% colspan="1" rowspan="1" %)tblObservations/tblWatersampleMeasurements|(% colspan="1" rowspan="1" %)Metingcode: 141 / WsPostSampleCO2 | ||
| 423 | |(% colspan="1" rowspan="1" %)Air sample details|(% colspan="1" rowspan="1" %)Post-sampling air flow rate|(% colspan="1" rowspan="1" %)Debiet einde monstername |(% colspan="1" rowspan="1" %)0,3l/min|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)Add Field|(% colspan="1" rowspan="1" %)float|(% colspan="1" rowspan="1" %)tblObservations/tblWatersampleMeasurements|(% colspan="1" rowspan="1" %)Metingcode: 142 / WsPostSampleFlowRate | ||
| 424 | |(% colspan="1" rowspan="1" %)Air sample details|(% colspan="1" rowspan="1" %)Post-sampling PID|(% colspan="1" rowspan="1" %)PID einde monstername |(% colspan="1" rowspan="1" %)25ppm|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)Add Field|(% colspan="1" rowspan="1" %)float|(% colspan="1" rowspan="1" %)tblObservations/tblWatersampleMeasurements|(% colspan="1" rowspan="1" %)Metingcode: 143 / WsPostSamplePID | ||
| 425 | |(% colspan="1" rowspan="1" %)Air sample details|(% colspan="1" rowspan="1" %)Post-sampling temperature|(% colspan="1" rowspan="1" %)Temperatuur einde monstername|(% colspan="1" rowspan="1" %)25C|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)Add Field|(% colspan="1" rowspan="1" %)float|(% colspan="1" rowspan="1" %)tblObservations/tblWatersampleMeasurements|(% colspan="1" rowspan="1" %)Metingcode: 144 / WsPostSampleTemperature | ||
| 426 | |(% colspan="1" rowspan="1" %)Air sample details|(% colspan="1" rowspan="1" %)Post sampling air humidity|(% colspan="1" rowspan="1" %)Vochtigheid einde monstername|(% colspan="1" rowspan="1" %)25%|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)Add Field|(% colspan="1" rowspan="1" %)float|(% colspan="1" rowspan="1" %)tblObservations/tblWatersampleMeasurements|(% colspan="1" rowspan="1" %)Metingcode: 145 / WsPostSampleHumidity | ||
| 427 | |(% colspan="1" rowspan="1" %)Air sample details|(% colspan="1" rowspan="1" %)Post sampling air pressure|(% colspan="1" rowspan="1" %)Luchtdruk einde monstername|(% colspan="1" rowspan="1" %)25hPa|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)Add Field|(% colspan="1" rowspan="1" %)float|(% colspan="1" rowspan="1" %)tblObservations/tblWatersampleMeasurements|(% colspan="1" rowspan="1" %)Metingcode: 146 / WsPostSamplePressure | ||
| 428 | |(% colspan="1" rowspan="1" %)Air samples Packaging|(% colspan="1" rowspan="1" %)Sample type|(% colspan="1" rowspan="1" %)Monstertype|(% colspan="1" rowspan="1" %)regular sample/transport blind/environment blind|(% colspan="1" rowspan="1" %)To select the type of support used in the sampling process|(% colspan="1" rowspan="1" %)Add Field|(% colspan="1" rowspan="1" %)lookupvalue|(% colspan="1" rowspan="1" %)tblBottles|(% colspan="1" rowspan="1" %)BoSampleTypeCode | ||
| 429 | |(% colspan="1" rowspan="1" %)Air samples Packaging|(% colspan="1" rowspan="1" %)Reference number|(% colspan="1" rowspan="1" %)Referentienummer|(% colspan="1" rowspan="1" %)088D235D123|(% colspan="1" rowspan="1" %)As secundary to barcode. Supports have both a barcode and a reference|(% colspan="1" rowspan="1" %)Add Field|(% colspan="1" rowspan="1" %)string (10)|(% colspan="1" rowspan="1" %)tblBottles|(% colspan="1" rowspan="1" %)BoReferenceNumber | ||
| 430 | |||
| 431 |