Wiki source code of TerraIndex ReleaseNotes
Last modified by Roelof Zwaan on 2023/07/24 15:58
Show last authors
author | version | line-number | content |
---|---|---|---|
1 | == Changes and updates: == | ||
2 | |||
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 | |||
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 | ))) | ||
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| | | | ||
195 | |||
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 | ||
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 | ||
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| | | | ||
293 | |||
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|((( | ||
304 | SlSpecialVegetationCode | ||
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 | ||
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 | ||
325 | |||
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 | |||
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 | ||
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 |