Changes for page TerraIndex ReleaseNotes

Last modified by Roelof Zwaan on 2023/07/24 15:58
<
From version < 2.3 >
edited by Roelof Zwaan
on 2022/08/03 17:47
To version < 8.1
edited by Roelof Zwaan
on 2023/07/24 15:58
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -1,5 +1,296 @@
1 1  == Changes and updates: ==
2 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 +
3 3  **03-08-2022:**
4 4  
5 5  (% class="table-hover" %)
... ... @@ -10,7 +10,7 @@
10 10  )))|**DB Type
11 11  (String (length) / Float / Lookupvalue / Integer / DateTime)**|**DBTable in dsFieldProject**|**DBFieldname in dsFieldProject**
12 12  |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|(((
13 -SlVegetationCode
304 +SlSpecialVegetationCode
14 14  )))
15 15  |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
16 16  |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
... ... @@ -18,19 +18,20 @@
18 18  |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
19 19  |Measurement point type|New codelist options added|Canister, Ambient air measurement added|Change|Lookup value (codelist 24)|tblMeasurementpoints|MpTypeCode
20 20  |Reference plane|New codelist options added|Sea level added|Change|Lookup value (codelist 15)|tblMeasurementpoints|MpReferencePointTypeCode
21 -|Finishing Type|New codelist options added| |Change|Lookup value (codelist 32)|tblFinishings|FiTypeCode
22 -|Horizon|New codelist options added| |Change|Lookup value (codelist 109)|tblLayers|LaHorizonCode
23 -|Soil / Rock Type|New codelist options added| |Change|Lookup value (codelist 163 and 35)|tblLayers|LaRockTypeCode
24 -|Special component type|New codelist options added| |Change|Lookup value (codelist 11)|tblLayers|LaSc1TypeCode
25 -|Drilling System|New codelist options added| |Change|Lookup value (codelist 23)|tblLayers|LaDrillingSystemTypeCode
26 -|Clarity|New codelist options added| |Change|Lookup value (codelist 252)|tblWatersamples|LaClarityCode
27 -|Stop prepumping|New codelist options added| |Change|Lookup value (codelist 200)|tblWatersamples|WsPrepumpingEndedTypeCode
28 -|Sampling method|New codelist options added| |Change|Lookup value (codelist 259)|tblWatersamples|WsSamplingMethodCode
29 -|Placed in serie|New codelist options added| |Change|Lookup value (codelist 284)|WsPackagings|BoPlacedInSerie
30 -|Air sample Type|New codelist options added| |Change|Lookup value (codelist 272)|WsPackagings|BoSampleTypeCode
31 -|Field matrix|New codelist options added| |Change|Lookup value (codelist 6)|WsAnalysisSamples|MatrixTypeCode
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
32 32  
33 -
34 34  **27-01-2022:**
35 35  
36 36  (% class="table-hover" %)
... ... @@ -55,7 +55,6 @@
55 55  |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)
56 56  |Pumped volume series| |Field for the total pumped volume during a single series|Add|Float|tblObservations|METINGCODE 152 (Series), METINGCODE 151 (Stable value)
57 57  
58 -
59 59  **22-11-2021:**
60 60  
61 61  |**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**

Navigation

TerraIndex
asd