From version 1.1 >
edited by Robin Huisman
on 2021/11/29 15:16
To version < 3.3 >
edited by Roelof Zwaan
on 2022/11/25 09:26
>
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,112 @@
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 +
53 +
54 +**03-08-2022:**
55 +
56 +(% class="table-hover" %)
57 +|**Labeltext in English**|**Remarks**|**Definition and process how this field will be used and when it will be filled.**|(((
58 +**Change/Add/**
59 +
60 +**Delete**
61 +)))|**DB Type
62 +(String (length) / Float / Lookupvalue / Integer / DateTime)**|**DBTable in dsFieldProject**|**DBFieldname in dsFieldProject**
63 +|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|(((
64 +SlSpecialVegetationCode
65 +)))
66 +|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
67 +|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
68 +|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
69 +|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
70 +|Measurement point type|New codelist options added|Canister, Ambient air measurement added|Change|Lookup value (codelist 24)|tblMeasurementpoints|MpTypeCode
71 +|Reference plane|New codelist options added|Sea level added|Change|Lookup value (codelist 15)|tblMeasurementpoints|MpReferencePointTypeCode
72 +|Finishing Type|New codelist options added|Surface box plasic, Surface box stainless steel added|Change|Lookup value (codelist 32)|tblFinishings|FiTypeCode
73 +|Horizon|New codelist options added|Unit R0, Unit R1, Unit R2 added|Change|Lookup value (codelist 109)|tblLayers|LaHorizonCode
74 +|Soil / Rock Type|New codelist options added|Granodiorite added|Change|Lookup value (codelist 163 and 35)|tblLayers|LaRockTypeCode
75 +|Special component type|New codelist options added|(((
76 +Construction and demolition waste, Calcium nodules, calcium crusts, Stones >50MM added
77 +)))|Change|Lookup value (codelist 11)|tblLayers|LaSc1TypeCode
78 +|Drilling System|New codelist options added|Tubed edelman, tubed pulse drill, tubed percussion gouge added|Change|Lookup value (codelist 23)|tblLayers|LaDrillingSystemTypeCode
79 +|Clarity|New codelist options added|None, Low, medium, high clarity codes added|Change|Lookup value (codelist 252)|tblWatersamples|LaClarityCode
80 +|Stop prepumping|New codelist options added|1x volume of drilling well + parameters stabilisation added|Change|Lookup value (codelist 200)|tblWatersamples|WsPrepumpingEndedTypeCode
81 +|Sampling method|New codelist options added|multi support active sampling|Change|Lookup value (codelist 259)|tblWatersamples|WsSamplingMethodCode
82 +|Placed in serie|New codelist options added|New codelist: Unique, in paralel, in series added|Change|Lookup value (codelist 284)|WsPackagings|BoPlacedInSerie
83 +|Air sample Type|New codelist options added|Impregnated filter added|Change|Lookup value (codelist 272)|WsPackagings|BoSampleTypeCode
84 +|Field matrix|New codelist options added|Waterbed (solid part) added|Change|Lookup value (codelist 6)|WsAnalysisSamples|MatrixTypeCode
85 +
86 +**27-01-2022:**
87 +
88 +(% class="table-hover" %)
89 +|**Labeltext in English**|**Remarks**|**Definition and process how this field will be used and when it will be filled.**|(((
90 +**Change/Add/**
91 +
92 +**Delete**
93 +)))|**DB Type
94 +(String (length) / Float / Lookupvalue / Integer / DateTime)**|**DBTable in dsFieldProject**|**DBFieldname in dsFieldProject**
95 +|Use of location| |To add the current use of the location to a measurement point|Add|Lookupvalue|tblMeasurementPoints|MpLocationUsageCode
96 +|Type|New codelist optios added |-|Change|Lookupvalue|tblMeasurementPoint|MpType
97 +|Interior location| |Yes / no field for if the sample is an interior location|Add|Lookupvalue|tblMeasurementPoints|MpIsIndoorsCode
98 +|FlowTypesSurfaceWater| |Describes the flowing pattern of the surface water sampling location|Add|Lookupvalue|tblObservations|METINGCODE 148
99 +|Location flow rate| |The flow rate of the sampling location|Add|Lookupvalue|tblObservations|METINGCODE 149
100 +|Special conditions| |Remark field for special sampling conditions to print in report|Add|String|tblWatersamples|JrStreamlineGUID
101 +|Pump type|Codelist used for several fields|New options added to codelist|Change|Lookupvalue|Multiple fields|Multiple fields
102 +|Pump connection| |Field for the power connection of a pump|Add|LookupValue|tblObservations|METINGCODE 150
103 +|Matrix| |Added codelist options|Change|Lookupvalue|tblWatersamples|WsMatrix
104 +|Mesh size (mm)| |Field for the mesh size of a monitoring well filter|Add|Float|tblFiltertubes|FtMeshSize
105 +|Type|Project level|New codelist options|Change|Lookupvalue|tblProjects|PrType
106 +|Type|Finishing level|New codelist options|Change|Lookupvalue|tblFinishings|FiType
107 +|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)
108 +|Pumped volume series| |Field for the total pumped volume during a single series|Add|Float|tblObservations|METINGCODE 152 (Series), METINGCODE 151 (Stable value)
109 +
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
151 +
152 +**07-10-2021:**
153 +
154 +|=(% colspan="1" rowspan="1" %)(((
155 +**Screen to add the extra field**
156 +)))|=(% colspan="1" rowspan="1" %)(((
157 +**Labeltext in English**
158 +)))|=(% colspan="1" rowspan="1" %)(((
159 +**Labeltext in Dutch**
160 +)))|=(% colspan="1" rowspan="1" %)(((
161 +**Examples of values and how it should be printed in a report.**
162 +)))|=(% colspan="1" rowspan="1" %)(((
163 +**Definition and process how this field will be used and when it will be filled.**
164 +)))|=(% colspan="1" rowspan="1" %)(((
165 +**Change/Add/Delete**
166 +)))|=(% colspan="1" rowspan="1" %)(((
167 +**DB Type**
168 +**(String (length) / Float / Lookupvalue / Integer / DateTime)**
169 +)))|=(% colspan="1" rowspan="1" %)(((
170 +**DBTable in dsFieldProject**
171 +)))|=(% colspan="1" rowspan="1" %)(((
172 +**DBFieldname in dsFieldProject**
173 +)))
174 +|(% 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
175 +|(% 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
176 +|(% 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
177 +|(% 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
178 +|(% 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
179 +|(% 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
180 +|(% 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
181 +|(% 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
182 +|(% 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
183 +|(% 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
184 +|(% 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
185 +|(% 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
186 +|(% 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
187 +|(% 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
188 +|(% 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
189 +|(% 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
190 +
191 +
TerraIndex
asd