<
From version < 8.1
edited by Roelof Zwaan
on 2023/07/24 15:58
To version < 3.2 >
edited by Roelof Zwaan
on 2022/08/04 09:24
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -1,296 +1,5 @@
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 -
294 294  **03-08-2022:**
295 295  
296 296  (% class="table-hover" %)
TerraIndex
asd