Show last authors
1 == Changes and updates: ==
2
3 **03-08-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 |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
14 )))
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 |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
17 |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
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 |Measurement point type|New codelist options added|Canister, Ambient air measurement added|Change|Lookup value (codelist 24)|tblMeasurementpoints|MpTypeCode
20 |Reference plane|New codelist options added|Sea level added|Change|Lookup value (codelist 15)|tblMeasurementpoints|MpReferencePointTypeCode
21 |Finishing Type|New codelist options added|Surface box plasic, Surface box stainless steel added|Change|Lookup value (codelist 32)|tblFinishings|FiTypeCode
22 |Horizon|New codelist options added|Unit R0, Unit R1, Unit R2 added|Change|Lookup value (codelist 109)|tblLayers|LaHorizonCode
23 |Soil / Rock Type|New codelist options added|Granodiorite added|Change|Lookup value (codelist 163 and 35)|tblLayers|LaRockTypeCode
24 |Special component type|New codelist options added|(((
25 Construction and demolition waste, Calcium nodules, calcium crusts, Stones >50MM added
26 )))|Change|Lookup value (codelist 11)|tblLayers|LaSc1TypeCode
27 |Drilling System|New codelist options added|Tubed edelman, tubed pulse drill, tubed percussion gouge added|Change|Lookup value (codelist 23)|tblLayers|LaDrillingSystemTypeCode
28 |Clarity|New codelist options added|None, Low, medium, high clarity codes added|Change|Lookup value (codelist 252)|tblWatersamples|LaClarityCode
29 |Stop prepumping|New codelist options added|1x volume of drilling well + parameters stabilisation added|Change|Lookup value (codelist 200)|tblWatersamples|WsPrepumpingEndedTypeCode
30 |Sampling method|New codelist options added|multi support active sampling|Change|Lookup value (codelist 259)|tblWatersamples|WsSamplingMethodCode
31 |Placed in serie|New codelist options added|New codelist: Unique, in paralel, in series added|Change|Lookup value (codelist 284)|WsPackagings|BoPlacedInSerie
32 |Air sample Type|New codelist options added|Impregnated filter added|Change|Lookup value (codelist 272)|WsPackagings|BoSampleTypeCode
33 |Field matrix|New codelist options added|Waterbed (solid part) added|Change|Lookup value (codelist 6)|WsAnalysisSamples|MatrixTypeCode
34
35
36 **27-01-2022:**
37
38 (% class="table-hover" %)
39 |**Labeltext in English**|**Remarks**|**Definition and process how this field will be used and when it will be filled.**|(((
40 **Change/Add/**
41
42 **Delete**
43 )))|**DB Type
44 (String (length) / Float / Lookupvalue / Integer / DateTime)**|**DBTable in dsFieldProject**|**DBFieldname in dsFieldProject**
45 |Use of location| |To add the current use of the location to a measurement point|Add|Lookupvalue|tblMeasurementPoints|MpLocationUsageCode
46 |Type|New codelist optios added |-|Change|Lookupvalue|tblMeasurementPoint|MpType
47 |Interior location| |Yes / no field for if the sample is an interior location|Add|Lookupvalue|tblMeasurementPoints|MpIsIndoorsCode
48 |FlowTypesSurfaceWater| |Describes the flowing pattern of the surface water sampling location|Add|Lookupvalue|tblObservations|METINGCODE 148
49 |Location flow rate| |The flow rate of the sampling location|Add|Lookupvalue|tblObservations|METINGCODE 149
50 |Special conditions| |Remark field for special sampling conditions to print in report|Add|String|tblWatersamples|JrStreamlineGUID
51 |Pump type|Codelist used for several fields|New options added to codelist|Change|Lookupvalue|Multiple fields|Multiple fields
52 |Pump connection| |Field for the power connection of a pump|Add|LookupValue|tblObservations|METINGCODE 150
53 |Matrix| |Added codelist options|Change|Lookupvalue|tblWatersamples|WsMatrix
54 |Mesh size (mm)| |Field for the mesh size of a monitoring well filter|Add|Float|tblFiltertubes|FtMeshSize
55 |Type|Project level|New codelist options|Change|Lookupvalue|tblProjects|PrType
56 |Type|Finishing level|New codelist options|Change|Lookupvalue|tblFinishings|FiType
57 |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)
58 |Pumped volume series| |Field for the total pumped volume during a single series|Add|Float|tblObservations|METINGCODE 152 (Series), METINGCODE 151 (Stable value)
59
60
61 **22-11-2021:**
62
63 |**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**
64 | | | | | | | | | |
65 |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
66 |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
67 |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
68 |Water samples|Surrounding humidity|Omgevingsvochtigheid|Licht vochtig, Zeer vochtig, Vochtig op bodem, Vochtig op plaatsen|The circumstances when sampling| |Add|Codelist|(((
69 * tblObservations
70 * tblWatersampleMeasurements
71 )))|Metingcode: 147 / WsSurroundingHumidity
72
73 **18-10-2021:**
74
75 |=(% colspan="1" rowspan="1" %)(((
76 **Labeltext in English**
77 )))|=(% colspan="1" rowspan="1" %)(((
78 **Remarks**
79 )))|=(% colspan="1" rowspan="1" %)(((
80 **Definition and process how this field will be used and when it will be filled.**
81 )))|=(% colspan="1" rowspan="1" %)(((
82 **Change/Add/Delete**
83 )))|=(% colspan="1" rowspan="1" %)(((
84 **DB Type**
85 **(String (length) / Float / Lookupvalue / Integer / DateTime)**
86 )))|=(% colspan="1" rowspan="1" %)(((
87 **DBTable in dsFieldProject**
88 )))|=(% colspan="1" rowspan="1" %)(((
89 **DBFieldname in dsFieldProject**
90 )))
91 |(% 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
92 |(% 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
93 |(% 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
94 |(% 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
95 |(% 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
96 |(% 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
97 |(% 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
98 |(% 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
99 |(% 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
100 |(% 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
101 |(% 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
102
103 **07-10-2021:**
104
105 |=(% colspan="1" rowspan="1" %)(((
106 **Screen to add the extra field**
107 )))|=(% colspan="1" rowspan="1" %)(((
108 **Labeltext in English**
109 )))|=(% colspan="1" rowspan="1" %)(((
110 **Labeltext in Dutch**
111 )))|=(% colspan="1" rowspan="1" %)(((
112 **Examples of values and how it should be printed in a report.**
113 )))|=(% colspan="1" rowspan="1" %)(((
114 **Definition and process how this field will be used and when it will be filled.**
115 )))|=(% colspan="1" rowspan="1" %)(((
116 **Change/Add/Delete**
117 )))|=(% colspan="1" rowspan="1" %)(((
118 **DB Type**
119 **(String (length) / Float / Lookupvalue / Integer / DateTime)**
120 )))|=(% colspan="1" rowspan="1" %)(((
121 **DBTable in dsFieldProject**
122 )))|=(% colspan="1" rowspan="1" %)(((
123 **DBFieldname in dsFieldProject**
124 )))
125 |(% 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
126 |(% 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
127 |(% 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
128 |(% 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
129 |(% 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
130 |(% 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
131 |(% 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
132 |(% 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
133 |(% 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
134 |(% 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
135 |(% 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
136 |(% 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
137 |(% 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
138 |(% 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
139 |(% 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
140 |(% 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
141
142
TerraIndex
asd