From version 1.1 >
edited by Robin Huisman
on 2021/11/29 15:16
To version < 3.4 >
edited by Roelof Zwaan
on 2022/11/25 09:58
>
Change comment: There is no comment for this version

Summary

Details

Page properties
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.RobinHuisman
1 +XWiki.RoelofZwaan
Content
... ... @@ -1,5 +1,155 @@
1 1  == Changes and updates: ==
2 2  
3 +**25-11-2022:**
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 +|Status| |(((
13 +This field is for planned measurement points, and can be used to determine the status (to be done, done, removed etc)
14 +)))|Add|Lookup value (codelist 289)|tblMeasurementPoints|(((
15 +MpStatusCode
16 +)))
17 +|(((
18 +Penetrometer compaction strength (kg/cm2)
19 +)))| |(((
20 +This field is a numeric field for field tests to determine the compaction strength of the soil
21 +)))|Add|numberfield|tblMeasurementPoints|MpPenetrometerCompaction
22 +|(((
23 +Accreditation number
24 +)))| |(((
25 +This field can be used to fill in the accreditation number of the fieldworker, which needs to be filled in by walloon customers
26 +)))|Add|text field (30)|tblMeasurementPoints|(((
27 +MpAccreditationNumber
28 +)))
29 +|Moisture Class Soil| |(((
30 +This field is for giving moisture classes in soil, these are present in the NEN 6693 and also used for french research.
31 +)))|Add|Lookup value (codelist 290)|tblLayers|(((
32 +LaMoistureClass
33 +)))
34 +|Sediment Sump Length (cm)| |(((
35 +Field to input the length within the tube that is used as a sand / silt catchment below the filter
36 +)))|Add|numberfield|tblFilterTubes|FtSedimentSumpLength
37 +|Length / Width|Multi edit turned on in grid vierw| |Change|numberfield|tblMeasurementPoints|(((
38 +MpTrialPitLength & MpTrialPitWidth
39 +)))
40 +|Length / Width|Multi edit turned on in grid vierw| |Change|numberfield|tblLayers|(((
41 +LaTrialPitLength & LaTrialPitWidth
42 +)))
43 +|Initial function| |(((
44 +Field to input the function of the filtertube when it was installed
45 +)))|Add|Lookup value (codelist 288)|tblFilterTubes|FtInitialFiltertubeFunction
46 +|Weather conditions| |(((
47 +Remarkable weather conditions can be noted here as part of a location inspection
48 +)))|Add|String|tblSublocations|(((
49 +SlCoverRatePostRemoval
50 +)))
51 +|Sampling procedure| |Field to fill in the used sampling procedure|Add|Lookup value (codelist 287)|tblWatersamples|WsSamplingProcedure
52 +|Starttime & Endtime sampling|Already existed for airsamples, no as well for watersamples| |Change|Datetime|tblWatersamples|(((
53 +WsStartSampleTime & WsPostSampleTime
54 +)))
55 +|Radioactive ionisation (cps)| |(((
56 +Numberfield to input the cps (counts per second) of a meter that reacts to ionisation (like a geiger counter)
57 +)))|Add|numberfield|tblJars|(((
58 +JrIonisationCount
59 +)))
60 +|Sample water content ~(%)| |(((
61 +Percentage field for sample humidity
62 +)))|Add|numberfield|tblJars|JrHumidityPercentage
63 +|(((
64 +Volume weight dry Yd (Kn/M3)
65 +)))| |(((
66 +Geotechnical field for the dry weight of the sample, different unit than the other weight sample fields which are more simplistic
67 +)))|Add|numberfield|tblJars|JrDryVolumeWeight
68 +|Liquit limit water content ~(%)| |The liquid limit used within the attenbergs limits|Add|numberfield|tblJars|JrLiquidLimit
69 +|Plasticity index ~(%)| |(((
70 +Geotechnical field for the plasticity index
71 +)))|Add|numberfield|tblJars|JrPlasticityIndex
72 +|(((
73 +Semi-Solid limit (water content %)
74 +)))| |The semi-solid limit used within the attenbergs limits|Add|numberfield|tblJars|JrSemiSolidLimit
75 +|(((
76 +Plastic limit (water content %)
77 +)))| |The plastic limit used within the attenbergs limits|Add|numberfield|tblJars|JrPlasticLimit
78 +|(((
79 +Undrained shear strength (kPa)
80 +)))| |The shear strength of the soil|Add|numberfield|tblJars|JrUndrainedShearStrength
81 +|Void ratio ~(%)| |The ratio of void (air) in the soil|Add|numberfield|tblJars|JrVoidRatio
82 +|Saturation ~(%)| |The percentage of moisture saturation in the soil|Add|numberfield|tblJars|JrSaturationPercentage
83 +|Soil sampes (several fields)|Multi edit turned on| |Change| |tblJars|Several
84 +|Destination Type| |Field for destination type for the OVAM|Add|Lookup value (codelist 49)|tblProjects|PrDestinationType
85 +|Groundwater vulnerability| |Field for groundwater vulnerability for the OVAM|Add|Lookup value (codelist 92)|tblProjects|PrGroundwaterVulnerability
86 +|Percentage Fractrion >20mm| |Asbestos fields now als on layer level|Add|numberfield|tblLayers|LaCourseFractionPercentage
87 +|Weight fraction >20 mm| |Asbestos fields now als on layer level|Add|numberfield|tblLayers|LaCourseFractionWeight
88 +|Weight fraction <20 mm| |Asbestos fields now als on layer level|Add|numberfield|tblLayers|LaFineFractionWeight
89 +|Type plate material| |Asbestos fields now als on layer level|Add|Lookup value (281)|tblLayers|LaPlateMaterialTypeCode
90 +|Number of pieces plate material| |Asbestos fields now als on layer level|Add|numberfield|tbLLayers|LaPlateMaterialPieces
91 +|Weight plate material (g)| |Asbestos fields now als on layer level|Add|numberfield|tblLayers|LaPlateMaterialWeight
92 +|Special component gradation|Add codelist "A little (bit of)"| |Change codelist value| | |
93 +|Sand sorting codes|Add extra sand and gravel sorting codes| |Change codelist value| | |
94 +| | | | | | |
95 +
96 +
97 +**03-08-2022:**
98 +
99 +(% class="table-hover" %)
100 +|**Labeltext in English**|**Remarks**|**Definition and process how this field will be used and when it will be filled.**|(((
101 +**Change/Add/**
102 +
103 +**Delete**
104 +)))|**DB Type
105 +(String (length) / Float / Lookupvalue / Integer / DateTime)**|**DBTable in dsFieldProject**|**DBFieldname in dsFieldProject**
106 +|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|(((
107 +SlSpecialVegetationCode
108 +)))
109 +|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
110 +|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
111 +|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
112 +|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
113 +|Measurement point type|New codelist options added|Canister, Ambient air measurement added|Change|Lookup value (codelist 24)|tblMeasurementpoints|MpTypeCode
114 +|Reference plane|New codelist options added|Sea level added|Change|Lookup value (codelist 15)|tblMeasurementpoints|MpReferencePointTypeCode
115 +|Finishing Type|New codelist options added|Surface box plasic, Surface box stainless steel added|Change|Lookup value (codelist 32)|tblFinishings|FiTypeCode
116 +|Horizon|New codelist options added|Unit R0, Unit R1, Unit R2 added|Change|Lookup value (codelist 109)|tblLayers|LaHorizonCode
117 +|Soil / Rock Type|New codelist options added|Granodiorite added|Change|Lookup value (codelist 163 and 35)|tblLayers|LaRockTypeCode
118 +|Special component type|New codelist options added|(((
119 +Construction and demolition waste, Calcium nodules, calcium crusts, Stones >50MM added
120 +)))|Change|Lookup value (codelist 11)|tblLayers|LaSc1TypeCode
121 +|Drilling System|New codelist options added|Tubed edelman, tubed pulse drill, tubed percussion gouge added|Change|Lookup value (codelist 23)|tblLayers|LaDrillingSystemTypeCode
122 +|Clarity|New codelist options added|None, Low, medium, high clarity codes added|Change|Lookup value (codelist 252)|tblWatersamples|LaClarityCode
123 +|Stop prepumping|New codelist options added|1x volume of drilling well + parameters stabilisation added|Change|Lookup value (codelist 200)|tblWatersamples|WsPrepumpingEndedTypeCode
124 +|Sampling method|New codelist options added|multi support active sampling|Change|Lookup value (codelist 259)|tblWatersamples|WsSamplingMethodCode
125 +|Placed in serie|New codelist options added|New codelist: Unique, in paralel, in series added|Change|Lookup value (codelist 284)|WsPackagings|BoPlacedInSerie
126 +|Air sample Type|New codelist options added|Impregnated filter added|Change|Lookup value (codelist 272)|WsPackagings|BoSampleTypeCode
127 +|Field matrix|New codelist options added|Waterbed (solid part) added|Change|Lookup value (codelist 6)|WsAnalysisSamples|MatrixTypeCode
128 +
129 +**27-01-2022:**
130 +
131 +(% class="table-hover" %)
132 +|**Labeltext in English**|**Remarks**|**Definition and process how this field will be used and when it will be filled.**|(((
133 +**Change/Add/**
134 +
135 +**Delete**
136 +)))|**DB Type
137 +(String (length) / Float / Lookupvalue / Integer / DateTime)**|**DBTable in dsFieldProject**|**DBFieldname in dsFieldProject**
138 +|Use of location| |To add the current use of the location to a measurement point|Add|Lookupvalue|tblMeasurementPoints|MpLocationUsageCode
139 +|Type|New codelist optios added |-|Change|Lookupvalue|tblMeasurementPoint|MpType
140 +|Interior location| |Yes / no field for if the sample is an interior location|Add|Lookupvalue|tblMeasurementPoints|MpIsIndoorsCode
141 +|FlowTypesSurfaceWater| |Describes the flowing pattern of the surface water sampling location|Add|Lookupvalue|tblObservations|METINGCODE 148
142 +|Location flow rate| |The flow rate of the sampling location|Add|Lookupvalue|tblObservations|METINGCODE 149
143 +|Special conditions| |Remark field for special sampling conditions to print in report|Add|String|tblWatersamples|JrStreamlineGUID
144 +|Pump type|Codelist used for several fields|New options added to codelist|Change|Lookupvalue|Multiple fields|Multiple fields
145 +|Pump connection| |Field for the power connection of a pump|Add|LookupValue|tblObservations|METINGCODE 150
146 +|Matrix| |Added codelist options|Change|Lookupvalue|tblWatersamples|WsMatrix
147 +|Mesh size (mm)| |Field for the mesh size of a monitoring well filter|Add|Float|tblFiltertubes|FtMeshSize
148 +|Type|Project level|New codelist options|Change|Lookupvalue|tblProjects|PrType
149 +|Type|Finishing level|New codelist options|Change|Lookupvalue|tblFinishings|FiType
150 +|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)
151 +|Pumped volume series| |Field for the total pumped volume during a single series|Add|Float|tblObservations|METINGCODE 152 (Series), METINGCODE 151 (Stable value)
152 +
3 3  **22-11-2021:**
4 4  
5 5  |**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**
... ... @@ -41,3 +41,44 @@
41 41  |(% 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
42 42  |(% 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
43 43  |(% 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
194 +
195 +**07-10-2021:**
196 +
197 +|=(% colspan="1" rowspan="1" %)(((
198 +**Screen to add the extra field**
199 +)))|=(% colspan="1" rowspan="1" %)(((
200 +**Labeltext in English**
201 +)))|=(% colspan="1" rowspan="1" %)(((
202 +**Labeltext in Dutch**
203 +)))|=(% colspan="1" rowspan="1" %)(((
204 +**Examples of values and how it should be printed in a report.**
205 +)))|=(% colspan="1" rowspan="1" %)(((
206 +**Definition and process how this field will be used and when it will be filled.**
207 +)))|=(% colspan="1" rowspan="1" %)(((
208 +**Change/Add/Delete**
209 +)))|=(% colspan="1" rowspan="1" %)(((
210 +**DB Type**
211 +**(String (length) / Float / Lookupvalue / Integer / DateTime)**
212 +)))|=(% colspan="1" rowspan="1" %)(((
213 +**DBTable in dsFieldProject**
214 +)))|=(% colspan="1" rowspan="1" %)(((
215 +**DBFieldname in dsFieldProject**
216 +)))
217 +|(% 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
218 +|(% 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
219 +|(% 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
220 +|(% 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
221 +|(% 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
222 +|(% 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
223 +|(% 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
224 +|(% 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
225 +|(% 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
226 +|(% 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
227 +|(% 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
228 +|(% 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
229 +|(% 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
230 +|(% 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
231 +|(% 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
232 +|(% 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
233 +
234 +
TerraIndex
asd