Version 24.1 by Robin Huisman on 2022/07/27 21:12
Hide last authors
Roelof Zwaan 5.2 1 (% class="jumbotron" %)
2 (((
3 (% class="container" %)
4 (((
5 When you request an export from the TerraIndex webservice or try to upload new data, you’ll need to understand the format of the projects. For exportType ‘**Export_FIELD_XML_v1_0_0**' or when you open a '.ti'/'TerraIndex Export’ file from the exportmodule of TerraIndex web, you receive an XML file that contains all Project data. Below the XSD and examples of how this format looks like.
6
7 Files to help understand the data format:
8
9 **[[Example Export XML file>>attach:export example.xml]]**
10
11 **[[Field database description>>attach:20150224 Field Database Description (3).docx]]**
12
Robin Huisman 24.1 13 [[(% class="wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink" %)**dsFieldproject format XSD file**>>attach:dsFieldProject.xsd]]
Roelof Zwaan 5.2 14
Robin Huisman 24.1 15 [[(% class="wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink" %)**Codelookup excel list**>>attach:20200619 Codelookup.xlsx]]
Roelof Zwaan 5.2 16 )))
17 )))
18
19 (% class="row" %)
20 (((
21 (% class="col-xs-12 col-sm-8" %)
22 (((
23 = [[image:1637572655588-407.png]] =
24
25 (% class="box errormessage" %)
26 (((
27 In the diagram above the table ‘tblWatersampleMeasurement' is presented, but this table is replaced bij ‘tblObservations’. We recommend to use 'tblObservation’, because the other table will be removed. It will be in the XML only for backwards compatibility.
28 )))
29
30 Small XML example, full example can be found as an attachment:
31
Robin Huisman 22.1 32 (% class="box infomessage" %)
33 (((
34 'dsFieldProject' root tag, is also named: 'VeldData'. This is the same export formatting inside.
35 )))
36
Roelof Zwaan 5.2 37 {{code language="XML" layout="LINENUMBERS" width="100%"}}
38
39 <dsFieldProject
40 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
41 xsi:noNamespaceSchemaLocation="file:///C:/Temp/dsFieldProject.xsd">
42 <tblProjects>
43 <PrID>242</PrID>
44 <PrCode>2018-010-DEMO</PrCode>
45 <PrName>TU Delft, the Netherlands</PrName>
46 <PrConsultancyFirm>TerraIndex</PrConsultancyFirm>
47 <PrLeaderCode>Consult</PrLeaderCode>
48 <PrFieldworkFirm>TerraIndex</PrFieldworkFirm>
49 <PrDrillingMasterCode>Borelog</PrDrillingMasterCode>
50 <PrGuid>46ba5f9e-5d59-8c8c-c5d6-ac9e9651ec4b</PrGuid>
51 <PrDateLastChanged>2018-08-31T11:12:50.45</PrDateLastChanged>
52 <PrLocPointGeometry>POINT (6.1000890695634133 52.58846240818189)</PrLocPointGeometry>
53 <PrTemplateID>23737</PrTemplateID>
54 <PrCoordinateSystem>RD</PrCoordinateSystem>
55 </tblProjects>
56 <tblMeasurementPoints>
57 <MpID>1</MpID>
58 <MpName>A01</MpName>
59 <MpNameNumeric>1</MpNameNumeric>
60 <MpDate>2018-08-01T00:00:00</MpDate>
61 <MpDepth>300</MpDepth>
62 <MpXCoord>203588.1</MpXCoord>
63 <MpYCoord>511339.61</MpYCoord>
64 <MpDrillingMasterCode>John Borelog</MpDrillingMasterCode>
65 <MpGroundLevelTypeCode>KL</MpGroundLevelTypeCode>
66 <MpTypeCode>P</MpTypeCode>
67 <MpCoordinatesPrecisionCode>G1</MpCoordinatesPrecisionCode>
68 <PrID>242</PrID>
69 <MpGuid>d09c8af7-45d1-4cd2-939f-7db42218b4ec</MpGuid>
70 <MpDateLastChanged>2018-08-28T10:00:26.567</MpDateLastChanged>
71 <MpPointGeometry>POINT (6.10416686139686 52.5874623700489)</MpPointGeometry>
72 </tblMeasurementPoints>
73 <tblMeasurementPoints>
74 <MpID>2</MpID>
75 <MpName>A04</MpName>
76 <MpNameNumeric>4</MpNameNumeric>
77 <MpDate>2018-08-01T00:00:00</MpDate>
78 <MpDepth>300</MpDepth>
79 <MpXCoord>203508.7</MpXCoord>
80 <MpYCoord>511382.74</MpYCoord>
81 <MpDrillingMasterCode>John Borelog</MpDrillingMasterCode>
82 <MpGroundLevelTypeCode>KL</MpGroundLevelTypeCode>
83 <MpTypeCode>B</MpTypeCode>
84 <MpGWT>150</MpGWT>
85 <MpCoordinatesPrecisionCode>G1</MpCoordinatesPrecisionCode>
86 <PrID>242</PrID>
87 <MpGuid>133ef5e8-2990-4b75-b718-27cd7bb9630d</MpGuid>
88 <MpDateLastChanged>2018-08-28T10:00:26.57</MpDateLastChanged>
89 <MpPointGeometry>POINT (6.10300163732122 52.5878570271434)</MpPointGeometry>
90 </tblMeasurementPoints>
91 </dsFieldProject
92 {{/code}}
93
94 (% class="box infomessage" %)
95 (((
Robin Huisman 23.1 96 (% class="box infomessage" %)
97 (((
98 When you need help with detailed mappings, please request help at: [[service@terraindex.com>>mailto:service@terraindex.com]]
Roelof Zwaan 5.2 99 )))
100
Robin Huisman 23.1 101 - DateLastChanged fields containing DateTime values, should be send to the server in +2 Timezone (Amsterdam).
102
103 - ID’s in the XML should be valid internally, as Primary- and Foreign-Keys. Once getting pushed into the database, the database will provice new ID’s.
104
105
106 )))
107
108 == ==
109
Roelof Zwaan 5.2 110 == Changes and updates: ==
111
Robin Huisman 24.1 112 **juli 2022:**
Richard Dyer 17.1 113
Robin Huisman 24.1 114 Nieuwe database unieke GUIDs toegevoegd, die in Streamline als ID gaan gelden.
115
Richard Dyer 17.1 116
Robin Huisman 24.1 117 |dsFieldProject.tblAnalysisSamplesDataTable.AnStreamlineGUID
118 |dsFieldProject.tblLabassignmentsDataTable.LbStreamlineGUID
119 |dsFieldProject.tblAnalysisRequestsDataTable.ArStreamlineGUID
120 |dsFieldProject.tblAnalysisResultsDataTable.AsStreamlineGUID
121 |dsFieldProject.tblAssessmentPropertiesDataTable.ApStreamlineGUID
122 |dsFieldProject.tblAssessmentResultsDataTable.ArStreamlineGUID
123 |dsFieldProject.tblAssessmentResultStandards.ArsStreamlineGUID
124 |dsFieldProject.tblWaterSamples.AnStreamlineGUID
125 |dsFieldProject.tblConcernedCompanies.CcStreamlineGUID
126
127
128 **maart 2022:**
129
Richard Dyer 17.1 130 |(% rowspan="4" %)**Labeltext in English**|(% rowspan="4" %)**Remarks**|(% rowspan="4" %)**Definition and process how this field will be used and when it will be filled.**|(% rowspan="4" %)**Change/Add/Delete**|(% rowspan="4" %)**DB Type (String (length) / Float / Lookupvalue / Integer / DateTime)**|(% rowspan="4" %)**DBTable in dsFieldProject**|(% rowspan="4" %)**DBFieldname in dsFieldProject**
Richard Dyer 18.1 131 |
132 |
133 |
Richard Dyer 17.1 134 |Smoketube test|CodeID: 157|A test done to determine wether no air is escaping the suction system of the filtration unit. This is important because if this is the case, dangerous gases might escape and affect the health of people nearby|Add|Lookupvalue|tblObservations|METINGCODE 157
135 |Discontinuity cause| |This describes the cause of a discontinuity among rock layers for a rock classification. This is not a description of the discontinuity, merely how it came to exist|Add|Lookupvalue|tblLayers|LaDiscontinuityCauseCode
136 |BroID| |Field for the BroID at filltertube level|Add|Varchar(50)|tblFilterTubes|BroID
137 |Weight fine fraction (kg)| |This concerns the weight of the sieved fraction, which is distinct from the coarse fraction|Add|Float|tblJars|JrWeightFractionFine
138 |Determination method of moisture| |Describes how the soil was kept at a safe mositure level to work with asbestos|Add|Codelist|tblLayers|LaFieldworkMoistureMethodCode
139 |Type of asbestos containing material| |Describes how the soil was kept at a safe mositure level to work with asbestos|Add|Codelist|tblJars|JrPlateMaterialTypeCode
140 |Thickness asbestos containing material (mm)| |Thickness of the plate material in mm, needed to make the distinction of types of plate material|Add|Float|tblJars|JrPlateMaterialThickness
141 |Recommended prepump volume|CodeID: 158|Needed to register for french users|Add|Float|tblObservations|METINGCODE 158
142 |Tube flushing volume|CodeID: 159|Needed to register for french users|Add|Float|tblObservations|METINGCODE 159
143 |Filtertube leaktest| |Wether or not a leaking test was performed on the filtertube (for air sampling)|Add|codelist (Yes / no)|tblFilterTubes|FtLeakingtestCode
Richard Dyer 19.1 144 |Presence of water|CodeID: 160|Check to see whetherthe tube is dry when sampling an air sample|Add|codelist (Yes / no)|tblObservations|METINGCODE 160
Richard Dyer 17.1 145 |Grondwaterstand aangetroffen?| |Veld om aan te geven dat de grondwaterstand niet is bereikt bij deze boring|Add|codelist (Yes / no)|tblMeasurementPoints|MpGWSFoundCode
Richard Dyer 20.1 146 |Benzene PID|CodeID: 156|Arcadis nederland wil dit graag...|Add|float|tblObservations|METINGCODE 156
Richard Dyer 17.1 147 |Lager explosief gehalte (vol %)|CodeID: 155|Arcadis nederland wil dit graag...|Add|float|tblObservations|METINGCODE 155
148 |Number of soil grabs| |Aantal grepen veld voor partijkeuring|Add|Integer|tblMeasurementpoints|MpGrabNumber
149 |Koolstofdioxine/CO2 ppm|(((
150 New label
151
152 CO2 (ppm)
153 )))|CHANGE LABEL|Change|Float|tblObservations|METING CODE: 113
154 |Koolstofdioxine/CO2 einde monstername (ppm)|(((
155 New label
156
157 CO2 (ppm) einde monstername
158 )))|CHANGE LABEL|Change|Float|tblObservations|METING CODE: 113
Richard Dyer 18.1 159 |Weight debris (kg)|(((
160 new label
161
162 english:
163
Richard Dyer 21.1 164 Weight coarse fraction (kg)
Richard Dyer 18.1 165
166 dutch:
167
Richard Dyer 21.1 168 Gewicht grove fractie (kg)
Richard Dyer 18.1 169 )))|Change label to conform norm|Change|Float|tblJars|JrWeightDebris
Richard Dyer 17.1 170 |Pieces of Asbestos|(((
171 new label
172
173 english:
174
175 Pieces of asbestos-containing material
176
177
178 dutch:
179
180 Aantal stukjes asbestverdacht materiaal
181
182
183
184 )))|Change label to conform norm|Change|Integer |tblJars|JrNoPiecesAsbestos
185 |Weight asbestos|(((
186 new label
187
188 english:
189
190 Weight asbestos-containing material
191
192
193 dutch:
194
195 Gewicht asbestverdacht materiaal
196 )))|Change label to conform norm|Change|Float|tblJars|JrWeightAsbestos
197 |Weight sample (kg)|(((
198 new label
199
200 english:
201
Richard Dyer 21.1 202 Total sample weight (kg)
Richard Dyer 17.1 203
204 dutch:
205
Richard Dyer 21.1 206 Totaal gewicht monster (kg)
Richard Dyer 17.1 207 )))|Change label to make it more clear that it concerns the total weight of the sample|Change|Float|tblJars|JrWeightSample
208
Robin Huisman 24.1 209 == ==
Roelof Zwaan 11.3 210
211 **27-01-2022:**
212
213 |**Labeltext in English**|**Remarks**|**Definition and process how this field will be used and when it will be filled.**|(((
214 **Change/Add/**
215
216 **Delete**
217 )))|**DB Type
218 (String (length) / Float / Lookupvalue / Integer / DateTime)**|**DBTable in dsFieldProject**|**DBFieldname in dsFieldProject**
219 |Use of location| |To add the current use of the location to a measurement point|Add|Lookupvalue|tblMeasurementPoints|MpLocationUsageCode
220 |Type|New codelist optios added |-|Change|Lookupvalue|tblMeasurementPoint|MpType
221 |Interior location| |Yes / no field for if the sample is an interior location|Add|Lookupvalue|tblMeasurementPoints|MpIsIndoorsCode
222 |FlowTypesSurfaceWater| |Describes the flowing pattern of the surface water sampling location|Add|Lookupvalue|tblObservations|METINGCODE 148
223 |Location flow rate| |The flow rate of the sampling location|Add|Lookupvalue|tblObservations|METINGCODE 149
224 |Special conditions| |Remark field for special sampling conditions to print in report|Add|String|tblWatersamples|JrStreamlineGUID
225 |Pump type|Codelist used for several fields|New options added to codelist|Change|Lookupvalue|Multiple fields|Multiple fields
226 |Pump connection| |Field for the power connection of a pump|Add|LookupValue|tblObservations|METINGCODE 150
227 |Matrix| |Added codelist options|Change|Lookupvalue|tblWatersamples|WsMatrix
228 |Mesh size (mm)| |Field for the mesh size of a monitoring well filter|Add|Float|tblFiltertubes|FtMeshSize
229 |Type|Project level|New codelist options|Change|Lookupvalue|tblProjects|PrType
230 |Type|Finishing level|New codelist options|Change|Lookupvalue|tblFinishings|FiType
231 |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)
232 |Pumped volume series| |Field for the total pumped volume during a single series|Add|Float|tblObservations|METINGCODE 152 (Series), METINGCODE 151 (Stable value)
233
Richard Dyer 5.3 234 **22-11-2021:**
235
236 |**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**
237 | | | | | | | | | |
Richard Dyer 10.1 238 |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
239 |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
240 |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
241 |Water samples|Surrounding humidity|Omgevingsvochtigheid|Licht vochtig, Zeer vochtig, Vochtig op bodem, Vochtig op plaatsen|The circumstances when sampling| |Add|Codelist|(((
242 * tblObservations
243 * tblWatersampleMeasurements
244 )))|Metingcode: 147 / WsSurroundingHumidity
Richard Dyer 5.3 245
Roelof Zwaan 5.2 246 **18-10-2021:**
247
248 (% class="table-hover" style="height:1452px; width:1050px" %)
249 |=(% colspan="1" rowspan="1" %)(((
250 **Labeltext in English**
251 )))|=(% colspan="1" rowspan="1" %)(((
252 **Remarks**
253 )))|=(% colspan="1" rowspan="1" %)(((
254 **Definition and process how this field will be used and when it will be filled.**
255 )))|=(% colspan="1" rowspan="1" %)(((
256 **Change/Add/Delete**
257 )))|=(% colspan="1" rowspan="1" %)(((
258 **DB Type**
259 **(String (length) / Float / Lookupvalue / Integer / DateTime)**
260 )))|=(% colspan="1" rowspan="1" %)(((
261 **DBTable in dsFieldProject**
262 )))|=(% colspan="1" rowspan="1" %)(((
263 **DBFieldname in dsFieldProject**
264 )))
265 |(% 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
266 |(% 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
267 |(% 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
268 |(% 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
269 |(% 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
270 |(% 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
271 |(% 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
272 |(% 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
273 |(% 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
274 |(% 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
275 |(% 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
276
277 **07-10-2021:**
278
279 (% class="table-hover" style="height:1676px; width:1195px" %)
280 |=(% colspan="1" rowspan="1" %)(((
281 **Screen to add the extra field**
282 )))|=(% colspan="1" rowspan="1" %)(((
283 **Labeltext in English**
284 )))|=(% colspan="1" rowspan="1" %)(((
285 **Labeltext in Dutch**
286 )))|=(% colspan="1" rowspan="1" %)(((
287 **Examples of values and how it should be printed in a report.**
288 )))|=(% colspan="1" rowspan="1" %)(((
289 **Definition and process how this field will be used and when it will be filled.**
290 )))|=(% colspan="1" rowspan="1" %)(((
291 **Change/Add/Delete**
292 )))|=(% colspan="1" rowspan="1" %)(((
293 **DB Type**
294 **(String (length) / Float / Lookupvalue / Integer / DateTime)**
295 )))|=(% colspan="1" rowspan="1" %)(((
296 **DBTable in dsFieldProject**
297 )))|=(% colspan="1" rowspan="1" %)(((
298 **DBFieldname in dsFieldProject**
299 )))
300 |(% 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
301 |(% 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
302 |(% 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
303 |(% 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
304 |(% 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
305 |(% 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
306 |(% 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
307 |(% 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
308 |(% 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
309 |(% 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
310 |(% 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
311 |(% 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
312 |(% 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
313 |(% 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
314 |(% 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
315 |(% 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
316
317 **6-8-2021:**
318
319 (% class="table-hover" %)
320 |(% colspan="1" rowspan="1" %)**Screen to add the extra field**|(% colspan="1" rowspan="1" %)**Examples of values and how it should be printed in a report.**|(% colspan="1" rowspan="1" %)**Labeltext in Dutch**|(% colspan="1" rowspan="1" %)**Codelist CategoryID**|(% colspan="1" rowspan="1" %)**Change/Add/Delete**|(% colspan="1" rowspan="1" %)**DB Type**
321 **(String (length) / Float / Lookupvalue / Integer / DateTime)**|(% colspan="1" rowspan="1" %)**DBTable in dsFieldProject**|(% colspan="1" rowspan="1" %)**DBFieldname in dsFieldProject**
322 |(% colspan="1" rowspan="1" %)Watersample details|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)Diepte aanzuigpunt voorpompen|(% 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: 133/ WsPrepumpSuctionPointDepth
323 |(% colspan="1" rowspan="1" %)Watersample details|(% colspan="1" rowspan="1" %)Ja/Nee|(% colspan="1" rowspan="1" %)peilbuis drooggevallen bij voorpompen|(% colspan="1" rowspan="1" %)26 (categoryID: 73)|(% colspan="1" rowspan="1" %)Add Field|(% colspan="1" rowspan="1" %)String (10)|(% colspan="1" rowspan="1" %)tblObservations/tblWatersampleMeasurements|(% colspan="1" rowspan="1" %)Metingcode: 134/ WsPrepumpFTDryCode
324 |(% colspan="1" rowspan="1" %)Watersample Reeksen|(% colspan="1" rowspan="1" %)Ja/Nee|(% colspan="1" rowspan="1" %)peilbuis drooggevallen bij voorpompen reeks|(% colspan="1" rowspan="1" %)26 (categoryID: 73)|(% colspan="1" rowspan="1" %)Add Field in Reeks interface|(% colspan="1" rowspan="1" %)String (10)|(% colspan="1" rowspan="1" %)tblObservations|(% colspan="1" rowspan="1" %)Metingcode: 135
325 |(% colspan="1" rowspan="1" %)Watersample details|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)reden pompen beeindigd|(% colspan="1" rowspan="1" %)518 (categoryID: 200)|(% colspan="1" rowspan="1" %)Add Codelist item,|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)peilbuis is droog
326 |(% colspan="1" rowspan="1" %)Meetpunt details|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)reden boring gestopt|(% colspan="1" rowspan="1" %)236 (categoryID: 236)|(% colspan="1" rowspan="1" %)Add Codelist item|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)water aangetroffen
327
328 **1-6-2021:**
329
330 (% class="table-hover" %)
331 |(% colspan="1" rowspan="1" %)**Screen to add the extra field**|(% colspan="1" rowspan="1" %)**Labeltext of field in English**|(% colspan="1" rowspan="1" %)**Definition and process how this field will be used and when it will be filled.**|(% colspan="1" rowspan="1" %)**Codelist CategoryID**|(% colspan="1" rowspan="1" %)**Change/Add/Delete**|(% colspan="1" rowspan="1" %)**Labeltext in Dutch**|(% colspan="1" rowspan="1" %)**Input type**|(% colspan="1" rowspan="1" %)**DB Type**
332 **(String (length) / Float / Lookupvalue / Integer / DateTime)**|(% colspan="1" rowspan="1" %)**DBTable in dsFieldProject**|(% colspan="1" rowspan="1" %)**DBFieldname in dsFieldProject**
333 |(% colspan="1" rowspan="1" %)Layer Details|(% colspan="1" rowspan="1" %)K qualification|(% colspan="1" rowspan="1" %)(((
334 they don't give any value to K but appreciations.
335
336 Het is ook wel uit de Hoofdnaam met bijmengingen af te leiden, maar dat is niet handig. Op boorprofiel moet het getoond worden, dus graag als apart veld toevoegen.
337
338 De k-waarde geeft de waterdoorlatendheid van de bodem of een constructie, de hydrologische conductiviteit. De k-waarde of doorlatendheidscoëfficiënt van zand kan horizontaal (kh) tot 50 m zijn en verticaal (kv) ca. 5 m per dag (etmaal), van klei en veen ca. 0,1 m per dag.
339 doorlatendheid: (k-waarde in m/etmaal)
340 )))|(% colspan="1" rowspan="1" %)271|(% colspan="1" rowspan="1" %)add|(% colspan="1" rowspan="1" %)K kwalificatie|(% colspan="1" rowspan="1" %)Codelist|(% colspan="1" rowspan="1" %)String (10)|(% colspan="1" rowspan="1" %)tblLayers|(% colspan="1" rowspan="1" %)LaKQualificationCode
341 |(% colspan="1" rowspan="1" %)Layer description|(% colspan="1" rowspan="1" %)colorimetric measurements (ppm|(% colspan="1" rowspan="1" %)(((
342 when PID gives strange values, colorimetric tube will be used. Values are always expressed in ppm
343 Colorimetric measurements are made in the layer, at a certain depth. If the layer is large, several measurements will be taken. The number of measurements that need to be done per layer is at the discretion of the field worker.
344 De colorimetric values shall be displayed in a graphic (in the same way as the PID graphic) in the drilling profile.
345
346 Pid meting slaat uit, dan plaatsen ze een buisje om extra stoffen te meten. Is dus echt een aparte meting.
347 )))|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)add|(% colspan="1" rowspan="1" %)colorimetrische meting (ppm)|(% colspan="1" rowspan="1" %)Float Input -> Same as PID|(% colspan="1" rowspan="1" %)Float/Double|(% colspan="1" rowspan="1" %)tblLayers|(% colspan="1" rowspan="1" %)LaColometricValue
348 |(% colspan="1" rowspan="1" %)soil sample details|(% colspan="1" rowspan="1" %)Soil Temperature (0C)|(% colspan="1" rowspan="1" %)according to the Spanish law, they have to measure the temperature of the soil sample. The data has to be reported in their report (veldwerkoverzicht)|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)add|(% colspan="1" rowspan="1" %)Temperatuur van het monster|(% colspan="1" rowspan="1" %)Float Input -> Same as PID|(% colspan="1" rowspan="1" %)Float/Double|(% colspan="1" rowspan="1" %)tblJars|(% colspan="1" rowspan="1" %)JrTemperatureSample
349 |(% colspan="1" rowspan="1" %)water sample details|(% colspan="1" rowspan="1" %)Cleaned|(% colspan="1" rowspan="1" %)(((
350 Before taking a sample, the monitoring well may need to be cleaned (e.g. in case of sand trapping). At sample level, they can say whether the monitoring well has been cleaned (yes /no). If " yes", a new field " depth of the gauging tube after cleaning" shall appear.
351
352 Overslaan, opgelost met als Diepte na schoonmaken gevuld is, dan is er ook schoongemaakt.
353 )))|(% colspan="1" rowspan="1" %)73|(% colspan="1" rowspan="1" %)add|(% colspan="1" rowspan="1" %)Schoongemaakt|(% colspan="1" rowspan="1" %)Codelist|(% colspan="1" rowspan="1" %)String (10)|(% colspan="1" rowspan="1" %)METINGCODE|(% colspan="1" rowspan="1" %)WsCleanedCode
354 |(% colspan="1" rowspan="1" %)water sample details|(% colspan="1" rowspan="1" %)depth of gauging tube before cleaning (cm - ref)|(% colspan="1" rowspan="1" %)(((
355 shall appear if the feld "cleaning" is turned on.
356
357 Appearing will be always, because the checkbox will be removed.
358 )))|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)add|(% colspan="1" rowspan="1" %)Diepte peilbuis voor schoonmaak|(% colspan="1" rowspan="1" %)Float Input -> Same as diepte|(% colspan="1" rowspan="1" %)Float/Double|(% colspan="1" rowspan="1" %)METINGCODE|(% colspan="1" rowspan="1" %)WsDepthBeforeCleaning
359 |(% colspan="1" rowspan="1" %)Water sample details|(% colspan="1" rowspan="1" %)Replenishment|(% colspan="1" rowspan="1" %)While purging, they have to indicate if the groundwater is coming back and how. If after few minutes it does not go back it means that the groundwater has dried.|(% colspan="1" rowspan="1" %)270|(% colspan="1" rowspan="1" %)add|(% colspan="1" rowspan="1" %)Herstelsnelheid grondwater niveau|(% colspan="1" rowspan="1" %)Codelist|(% colspan="1" rowspan="1" %)String (10)|(% colspan="1" rowspan="1" %)METINGCODE|(% colspan="1" rowspan="1" %)WsReplenishmentCode
360 |(% colspan="1" rowspan="1" %)Soil Gaz sample details - stable|(% colspan="1" rowspan="1" %)Lower Explosive Level ~(%)|(% colspan="1" rowspan="1" %)(((
361 parameter that need to be measured during soil gaz sampling, for security reasons
362
363 STABLE VALUE!!
364 )))|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)add|(% colspan="1" rowspan="1" %)Lager explosief niveau ~(%)|(% colspan="1" rowspan="1" %)Float Input -> Same as diepte|(% colspan="1" rowspan="1" %)Float/Double|(% colspan="1" rowspan="1" %)METINGCODE|(% colspan="1" rowspan="1" %)WsLowerExplosiveLevel
365 |(% colspan="1" rowspan="1" %)Soil Gaz sample details - series|(% colspan="1" rowspan="1" %)Lower Explosive Level ~(%) serie|(% colspan="1" rowspan="1" %)(((
366 parameter that need to be measured during soil gaz sampling, for security reasons
367
368 SERIES VALUE!!
369 )))|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)add|(% colspan="1" rowspan="1" %)Lager explosief niveau ~(%) reeks|(% colspan="1" rowspan="1" %)Float Input -> Same as diepte|(% colspan="1" rowspan="1" %)Float/Double|(% colspan="1" rowspan="1" %)METINGCODE|(% colspan="1" rowspan="1" %)METINGCODE
370 |(% colspan="1" rowspan="1" %)Soil Gaz sample details - stable|(% colspan="1" rowspan="1" %)H2S (ppm)|(% colspan="1" rowspan="1" %)(((
371 parameter that is also checked during the soil gaz purge.
372
373 STABLE!!
374 )))|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)add|(% colspan="1" rowspan="1" %)H2S (ppm)|(% colspan="1" rowspan="1" %)Float Input -> Same as diepte|(% colspan="1" rowspan="1" %)Float/Double|(% colspan="1" rowspan="1" %)METINGCODE|(% colspan="1" rowspan="1" %)WsH2S
375 |(% colspan="1" rowspan="1" %)Soil Gaz sample details - series|(% colspan="1" rowspan="1" %)H2S (ppm) serie|(% colspan="1" rowspan="1" %)(((
376 parameter that is also checked during the soil gaz purge.
377
378 SERIES VALUE!!
379 )))|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)add|(% colspan="1" rowspan="1" %)H2S (ppm) reeks|(% colspan="1" rowspan="1" %)Float Input -> Same as diepte|(% colspan="1" rowspan="1" %)Float/Double|(% colspan="1" rowspan="1" %)METINGCODE|(% colspan="1" rowspan="1" %)METINGCODE
380 |(% colspan="1" rowspan="1" %)Water Sample - series|(% colspan="1" rowspan="1" %)Turbidity serie|(% colspan="1" rowspan="1" %)In France , Spain (and Germany)  they don't use NTU to describe turbidity but appreciations
381 The same appreciations that already exist for the feld "turbidiy" from Watersample should also exist for the series|(% colspan="1" rowspan="1" %)252|(% colspan="1" rowspan="1" %)add|(% colspan="1" rowspan="1" %)Helderheid reeks|(% colspan="1" rowspan="1" %)Codelist|(% colspan="1" rowspan="1" %)String (10)|(% colspan="1" rowspan="1" %)METINGCODE|(% colspan="1" rowspan="1" %)METINGCODE
382
383 **20-04-2021:**
384
385 |(% colspan="1" rowspan="1" %)**Change/Add/Delete**|(% colspan="1" rowspan="1" %)**Remarks, Questions with answers and feedback of the status and the field info.**|(% colspan="1" rowspan="1" %)**Labeltext in Dutch**|(% colspan="1" rowspan="1" %)**CategoryID**|(% colspan="1" rowspan="1" %)**Input type**|(% colspan="1" rowspan="1" %)**DB Type**|(% colspan="1" rowspan="1" %)**(String (length) / Float / Lookupvalue / Integer / DateTime)**|(% colspan="1" rowspan="1" %)**tblObservations/**|(% colspan="1" rowspan="1" %)**DBFieldname in dsFieldProject**
386 |(% colspan="1" rowspan="1" %)Add|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)Monsternemer handtekening|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)signature|(% colspan="2" rowspan="1" %)text|(% colspan="1" rowspan="1" %)tblWaterSamples|(% colspan="1" rowspan="1" %)WsSampletakerSignatureJPEG
387 |(% colspan="1" rowspan="1" %)Add|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)Handtekening datum|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)date time|(% colspan="2" rowspan="1" %)datetime|(% colspan="1" rowspan="1" %)tblWaterSamples|(% colspan="1" rowspan="1" %)WsSampletakerSignatureTimestamp
388 |(% colspan="1" rowspan="1" %)Add|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)Gevalideerd|(% colspan="1" rowspan="1" %)138|(% colspan="1" rowspan="1" %)codelist|(% colspan="2" rowspan="1" %)string()|(% colspan="1" rowspan="1" %)tblWaterSamples|(% colspan="1" rowspan="1" %)WsValidatedCode
389
390 **06-04-2021**
391
392 (% class="table-hover" %)
393 |(% colspan="1" rowspan="1" %)**Change/Add/Delete**|(% colspan="1" rowspan="1" %)**Remarks, Questions with answers and feedback of the status and the field info.**|(% colspan="1" rowspan="1" %)**Labeltext in Dutch**|(% colspan="1" rowspan="1" %)**CategoryID**|(% colspan="1" rowspan="1" %)**Input type**|(% colspan="1" rowspan="1" %)**DB Type**|(% colspan="1" rowspan="1" %)**(String (length) / Float / Lookupvalue / Integer / DateTime)**|(% colspan="1" rowspan="1" %)**dsTI DB Table**|(% colspan="1" rowspan="1" %)**dsTI DB Columnname**
394 |(% colspan="1" rowspan="1" %)Add|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)-|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)-|(% colspan="2" rowspan="1" %)int|(% colspan="1" rowspan="1" %)tblLocationVisits|(% colspan="1" rowspan="1" %)LvID
395 |(% colspan="1" rowspan="1" %)Add|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)-|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)-|(% colspan="2" rowspan="1" %)uniqueidentifier|(% colspan="1" rowspan="1" %)tblLocationVisits|(% colspan="1" rowspan="1" %)LvGuid
396 |(% colspan="1" rowspan="1" %)Add|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)-|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)-|(% colspan="2" rowspan="1" %)int|(% colspan="1" rowspan="1" %)tblLocationVisits|(% colspan="1" rowspan="1" %)PrID
397 |(% colspan="1" rowspan="1" %)Add|(% colspan="1" rowspan="1" %)The moment the fieldwork visited the location|(% colspan="1" rowspan="1" %)Bezoek tijdstip|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)Date input|(% colspan="2" rowspan="1" %)datetime|(% colspan="1" rowspan="1" %)tblLocationVisits|(% colspan="1" rowspan="1" %)LvVisitTimestamp
398 |(% colspan="1" rowspan="1" %)Add|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)Lucht Temperatuur (°C)|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)Number|(% colspan="2" rowspan="1" %)float|(% colspan="1" rowspan="1" %)tblLocationVisits|(% colspan="1" rowspan="1" %)LvAirTemperature
399 |(% colspan="1" rowspan="1" %)Add|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)Luchtdruk (hPa)|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)Number|(% colspan="2" rowspan="1" %)float|(% colspan="1" rowspan="1" %)tblLocationVisits|(% colspan="1" rowspan="1" %)LvAirPressure
400 |(% colspan="1" rowspan="1" %)Add|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)Luchtvochtigheid ~(%)|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)Number|(% colspan="2" rowspan="1" %)float|(% colspan="1" rowspan="1" %)tblLocationVisits|(% colspan="1" rowspan="1" %)LvHumidity
401 |(% colspan="1" rowspan="1" %)Add|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)Windrichting (°)|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)Number|(% colspan="2" rowspan="1" %)float|(% colspan="1" rowspan="1" %)tblLocationVisits|(% colspan="1" rowspan="1" %)LvWindDirectionDegrees
402 |(% colspan="1" rowspan="1" %)Add|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)Windrichting (Kompas)|(% colspan="1" rowspan="1" %)264|(% colspan="1" rowspan="1" %)codelist|(% colspan="2" rowspan="1" %)String(10)|(% colspan="1" rowspan="1" %)tblLocationVisits|(% colspan="1" rowspan="1" %)LvWindDirectionPointCode
403 |(% colspan="1" rowspan="1" %)Add|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)Windkracht (m/s)|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)Number|(% colspan="2" rowspan="1" %)float|(% colspan="1" rowspan="1" %)tblLocationVisits|(% colspan="1" rowspan="1" %)LvWindForce
404 |(% colspan="1" rowspan="1" %)Add|(% colspan="1" rowspan="1" %)The weatherconditions during the visit to the location|(% colspan="1" rowspan="1" %)Weersomstandigheden|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)Text input|(% colspan="2" rowspan="1" %)String(2000)|(% colspan="1" rowspan="1" %)tblLocationVisits|(% colspan="1" rowspan="1" %)LvWeatherConditionsDescription
405 |(% colspan="1" rowspan="1" %)Add|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)nvt|(% colspan="2" rowspan="1" %)datetime|(% colspan="1" rowspan="1" %)tblLocationVisits|(% colspan="1" rowspan="1" %)LvDateLastChanged
406
407 **10-3-2021:**
408
409 (% class="table-hover" %)
410 |(% colspan="1" rowspan="1" %)**Change/Add/Delete**|(% colspan="1" rowspan="1" %)**Remarks, Questions with answers and feedback of the status and the field info.**|(% colspan="1" rowspan="1" %)**Labeltext in Dutch**|(% colspan="1" rowspan="1" %)**CategoryID**|(% colspan="1" rowspan="1" %)**Input type**|(% colspan="1" rowspan="1" %)**DB Type**|(% colspan="1" rowspan="1" %)**(String (length) / Float / Lookupvalue / Integer / DateTime)**|(% colspan="1" rowspan="1" %)**DBTable in dsFieldProject**|(% colspan="1" rowspan="1" %)**DBFieldname in dsFieldProject**
411 |(% colspan="1" rowspan="1" %)Add|(% colspan="1" rowspan="1" %)Een veld om aan te geven of het monster in het veld gemengd is in 1 verpakking.|(% colspan="1" rowspan="1" %)Is veld mengmonster|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %) |(% colspan="2" rowspan="1" %)boolean|(% colspan="1" rowspan="1" %)tblAnalysisSamples|(% colspan="1" rowspan="1" %)IsMixedFieldSample
412
413 **18-1-2021:**
414
415 (% class="table-hover" %)
416 |(% colspan="1" rowspan="1" %)**Change/Add/Delete**|(% colspan="1" rowspan="1" %)**Remarks, Questions with answers and feedback of the status and the field info.**|(% colspan="1" rowspan="1" %)**Labeltext in Dutch**|(% colspan="1" rowspan="1" %)**CategoryID**|(% colspan="1" rowspan="1" %)**Input type**|(% colspan="1" rowspan="1" %)**DB Type**|(% colspan="1" rowspan="1" %)**(String (length) / Float / Lookupvalue / Integer / DateTime)**|(% colspan="1" rowspan="1" %)**DBTable in dsFieldProject**|(% colspan="1" rowspan="1" %)**DBFieldname in dsFieldProject**
417 |(% colspan="1" rowspan="1" %)Add|(% colspan="1" rowspan="1" %)We hebben een maaiveldtype per meetpunt, hierbij graag de mogelijkheid om de condities op te opgeven van het maaiveld.|(% colspan="1" rowspan="1" %)Maaiveld omstandigheden|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)TextInput|(% colspan="2" rowspan="1" %)String (2000)|(% colspan="1" rowspan="1" %)tblMeasurementPoint|(% colspan="1" rowspan="1" %)MpGroundLevelCondition
418 |(% colspan="1" rowspan="1" %)Add Observation|(% colspan="1" rowspan="1" %)Totaal volume van het gepompte volume bij de monstername|(% colspan="1" rowspan="1" %)Volume monstername (l)|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)Float|(% colspan="2" rowspan="1" %)Float|(% colspan="1" rowspan="1" %)(((
419 * tblObservations
420 * tblWatersampleMeasurements
421 )))|(% colspan="1" rowspan="1" %)WsSampledVolume/ Old metingcode: 109
422 |(% colspan="1" rowspan="1" %)Add Observation|(% colspan="1" rowspan="1" %)Monstername methode kunnen opgeven|(% colspan="1" rowspan="1" %)Monstername methode|(% colspan="1" rowspan="1" %) 259|(% colspan="1" rowspan="1" %)Codelist|(% colspan="2" rowspan="1" %)String(20)|(% colspan="1" rowspan="1" %)(((
423 * tblObservations
424 * tblWatersampleMeasurements
425 )))|(% colspan="1" rowspan="1" %)WsSamplingMethodTypeCode/ Old metingcode: 110
426 |(% colspan="1" rowspan="1" %)Change|(% colspan="1" rowspan="1" %)Aanpassen van deze meting naar een vaste eenheid: mg/l.|(% colspan="1" rowspan="1" %)Zuurstof in mg/l|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)Float|(% colspan="2" rowspan="1" %)Float|(% colspan="1" rowspan="1" %)(((
427 * tblObservations
428 * tblWatersampleMeasurements
429 )))|(% colspan="1" rowspan="1" %)WsOxygen (Metingcode: 23 / Old metingcode: 12
430 |(% colspan="1" rowspan="1" %)Add Observation|(% colspan="1" rowspan="1" %)Toevoegen van deze meting met een vaste eneheid: %.|(% colspan="1" rowspan="1" %)Zuurstof in %|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)Float|(% colspan="2" rowspan="1" %)Float|(% colspan="1" rowspan="1" %)(((
431 * tblObservations
432 * tblWatersampleMeasurements
433 )))|(% colspan="1" rowspan="1" %)WsOxygenPercentage/ Old metingcode: 111
434 |(% colspan="1" rowspan="1" %)Add Observation|(% colspan="1" rowspan="1" %)Toevoegen van deze Series meting met een vaste eenheid: %.|(% colspan="1" rowspan="1" %)Reeks Zuurstof in %|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)Float|(% colspan="2" rowspan="1" %)Float|(% colspan="1" rowspan="1" %)(((
435 * tblObservations
436 * tblWatersampleMeasurements
437 )))|(% colspan="1" rowspan="1" %)METING CODE: 112
438 |(% colspan="1" rowspan="1" %)Add Observation|(% colspan="1" rowspan="1" %)Toevoegen van deze meting met een vaste eneheid: ppm.|(% colspan="1" rowspan="1" %)Koolstofdioxine/CO2 in ppm|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)Float|(% colspan="2" rowspan="1" %)Float|(% colspan="1" rowspan="1" %)(((
439 * tblObservations
440 * tblWatersampleMeasurements
441 )))|(% colspan="1" rowspan="1" %)WsCarbonDioxine / Old metingcode: 113
442 |(% colspan="1" rowspan="1" %)Add Observation|(% colspan="1" rowspan="1" %)Toevoegen van deze Series meting met een vaste eenheid: ppm.|(% colspan="1" rowspan="1" %)Reeks Koolstofdioxine/CO2 in ppm|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)Float|(% colspan="2" rowspan="1" %)Float|(% colspan="1" rowspan="1" %)(((
443 * tblObservations
444 * tblWatersampleMeasurements
445 )))|(% colspan="1" rowspan="1" %)METING CODE: 114
446 |(% colspan="1" rowspan="1" %)Add Observation|(% colspan="1" rowspan="1" %)Toevoegen van deze meting met een vaste eneheid: %.|(% colspan="1" rowspan="1" %)Vochtigheid in %|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)Float|(% colspan="2" rowspan="1" %)Float|(% colspan="1" rowspan="1" %)(((
447 * tblObservations
448 * tblWatersampleMeasurements
449 )))|(% colspan="1" rowspan="1" %)WsHumidityPercentage/ Old metingcode: 115
450 |(% colspan="1" rowspan="1" %)Add Observation|(% colspan="1" rowspan="1" %)Toevoegen van deze Series meting met een vaste eenheid: %.|(% colspan="1" rowspan="1" %)Reeks Vochtigheid in %|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)Float|(% colspan="2" rowspan="1" %)Float|(% colspan="1" rowspan="1" %)(((
451 * tblObservations
452 * tblWatersampleMeasurements
453 )))|(% colspan="1" rowspan="1" %)METING CODE: 116
454 |(% colspan="1" rowspan="1" %)Add Observation|(% colspan="1" rowspan="1" %)Toevoegen van deze Series meting met een vaste eenheid: ppm.|(% colspan="1" rowspan="1" %)Reeks PID in ppm|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)Float|(% colspan="2" rowspan="1" %)Float|(% colspan="1" rowspan="1" %)(((
455 * tblObservations
456 * tblWatersampleMeasurements
457 )))|(% colspan="1" rowspan="1" %)METING CODE: 117
458 |(% colspan="1" rowspan="1" %)Add Observation|(% colspan="1" rowspan="1" %)Toevoegen van deze Series meting met een vaste eenheid: hPa.|(% colspan="1" rowspan="1" %)Reeks Luchtdruk in hPa|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)Float|(% colspan="2" rowspan="1" %)Float|(% colspan="1" rowspan="1" %)(((
459 * tblObservations
460 * tblWatersampleMeasurements
461 )))|(% colspan="1" rowspan="1" %)METING CODE: 118
462
463 (% class="table-hover" %)
464 |(% colspan="1" rowspan="1" %)**Change/Add/Delete**|(% colspan="1" rowspan="1" %)**Remarks, Questions with answers and feedback of the status and the field info.**|(% colspan="1" rowspan="1" %)**Labeltext in Dutch**|(% colspan="1" rowspan="1" %)**CategoryID**|(% colspan="1" rowspan="1" %)**DB Type**|(% colspan="1" rowspan="1" %)**Table**|(% colspan="1" rowspan="1" %)**Column**
465 |(% colspan="1" rowspan="1" %)Add column|(% colspan="1" rowspan="1" %)When a sample has a strong hydrocarbon odor a measure of Total Petroleum Hydrocarbons (TPH) is performed in the field with a PetroFLAG analyzer. This field is meant to register that value.|(% colspan="1" rowspan="1" %)PetroFLAG® Analyzer (ppmv)|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)Float|(% colspan="1" rowspan="1" %)tblJars|(% colspan="1" rowspan="1" %)JrPetroFLAGAnalyzerValue
466 |(% colspan="1" rowspan="1" %)Add column|(% colspan="1" rowspan="1" %)When changing a PID measurement to a sample, in case of a strange exceptional measured value, they will need to remeasure the pid value but also keep the original one that was taken during the PID measurement.|(% colspan="1" rowspan="1" %)Afwijkende PID (ppm)|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)Float|(% colspan="1" rowspan="1" %)tblJars|(% colspan="1" rowspan="1" %)JrExceptionalPIDValue
467 |(% colspan="1" rowspan="1" %)Add Observation|(% colspan="1" rowspan="1" %)Method used to remove the floating layer in the gauging tube|(% colspan="1" rowspan="1" %)Drijflaag ophaal/verwijder systeem|(% colspan="1" rowspan="1" %)260|(% colspan="1" rowspan="1" %)String(10)|(% colspan="1" rowspan="1" %)tblObservations|(% colspan="1" rowspan="1" %)WsFloatingLayerRemoveMethodCode/Metingcode: 119
468 |(% colspan="1" rowspan="1" %)Add Observation|(% colspan="1" rowspan="1" %)Type of operation that has been performed on the device used to remove the floating layer.|(% colspan="1" rowspan="1" %)Uitgevoerde behandeling op drijflaag|(% colspan="1" rowspan="1" %)261|(% colspan="1" rowspan="1" %)String(10)|(% colspan="1" rowspan="1" %)tblObservations|(% colspan="1" rowspan="1" %)WsFloatingLayerSystemActionCode/Metingcode: 120
469 |(% colspan="1" rowspan="1" %)Add Observation|(% colspan="1" rowspan="1" %)Sometimes an absorbtion stick is used to collect the floating layer in the Gauging tube. This parameter allows to indicate how saturated the absorbtion stick is after the procedure.|(% colspan="1" rowspan="1" %)Saturatie absorberende staaf ~(%)|(% colspan="1" rowspan="1" %)262|(% colspan="1" rowspan="1" %)String(10)|(% colspan="1" rowspan="1" %)tblObservations|(% colspan="1" rowspan="1" %)WsSaturationAbsorptionStickCode/Metingcode: 121
470 |(% colspan="1" rowspan="1" %)Add Observation|(% colspan="1" rowspan="1" %)Method used to clean the gauging tube.|(% colspan="1" rowspan="1" %)Reiniging methode|(% colspan="1" rowspan="1" %)257|(% colspan="1" rowspan="1" %)String(10)|(% colspan="1" rowspan="1" %)tblObservations|(% colspan="1" rowspan="1" %)WsPurgeMethodCode/Metingcode: 122
471 |(% colspan="1" rowspan="1" %)Add Observation|(% colspan="1" rowspan="1" %)When a gauging tube is purged, it can be done in two ways. Static: the intake depth is left at a set location. Dynamic: the hose intake depth is manually varied by moving the hose up and down.|(% colspan="1" rowspan="1" %)Afpomp methode|(% colspan="1" rowspan="1" %)263|(% colspan="1" rowspan="1" %)String(10)|(% colspan="1" rowspan="1" %)tblObservations|(% colspan="1" rowspan="1" %)WsPurgeModeCode/Metingcode: 123
472 |(% colspan="1" rowspan="1" %)Add Observation|(% colspan="1" rowspan="1" %)The total voltage that is measured on a water sample. So that is Redox + Standard. This is used in Germany to give adivice on the sample|(% colspan="1" rowspan="1" %)Totale voltage (mV)|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)Float|(% colspan="1" rowspan="1" %)tblObservations|(% colspan="1" rowspan="1" %)WsTotalVoltage/Metingcode: 124
473
474 **11-8-2020:**
475
476 (% class="table-hover" %)
477 |(% colspan="1" rowspan="1" %)DSField Table|(% colspan="1" rowspan="1" %)DSField Column|(% colspan="1" rowspan="1" %)Field name in interface|(% colspan="1" rowspan="1" %)Input type|(% colspan="1" rowspan="1" %)Input Options example|(% colspan="1" rowspan="1" %)Code categorie
478 |(% colspan="1" rowspan="1" %)tblMeasurementPoint|(% colspan="1" rowspan="1" %)MpSoilDisposedCodeVarchar (10)|(% colspan="1" rowspan="1" %)Soil disposal method|(% colspan="1" rowspan="1" %)Lookup list|(% colspan="1" rowspan="1" %)Transported to a appropriate treatment facility
479 Stored in the CIW containers of the site
480 Stored on site awaiting disposal
481 Left on the ground on site
482 Used to fill the borehole|(% colspan="1" rowspan="1" %)256
483 |(% colspan="1" rowspan="1" %)tblFiltertubes|(% colspan="1" rowspan="1" %)FtPurgeTechniqueCode Varchar(10)|(% colspan="1" rowspan="1" %)Purge technique|(% colspan="1" rowspan="1" %)Lookup list|(% colspan="1" rowspan="1" %)Continuous water pumping
484 Water pumping per level
485 Alternate pumping (Shock)
486 Swabbing and pumping
487 Double air-lift
488 Brushing and pumping
489 Chemical treatment and pumping|(% colspan="1" rowspan="1" %)257
490 |(% colspan="1" rowspan="1" %)tblFiltertubes|(% colspan="1" rowspan="1" %)FtPurgeDuration Integer|(% colspan="1" rowspan="1" %)Purga duration|(% colspan="1" rowspan="1" %)Integer input|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)
491 |(% colspan="1" rowspan="1" %)tblMeasurementPoint|(% colspan="1" rowspan="1" %)MpDrillmasterSignatureJPEG Text (Base64 JPEG string)|(% colspan="1" rowspan="1" %)Drillmaster signature|(% colspan="1" rowspan="1" %)Signature input|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)
492 |(% colspan="1" rowspan="1" %)tblMeasurementPoint|(% colspan="1" rowspan="1" %)MpDrillmasterSignatureTimestamp DateTime|(% colspan="1" rowspan="1" %)Signature timestamp|(% colspan="1" rowspan="1" %)DateTime input|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)
493
494 **27-7-2020:**
495
496 (% class="table-hover" %)
497 |(% colspan="1" rowspan="1" %)DSField Table|(% colspan="1" rowspan="1" %)DSField Column|(% colspan="1" rowspan="1" %)Field name in interface|(% colspan="1" rowspan="1" %)Input type|(% colspan="1" rowspan="1" %)Input Options example|(% colspan="1" rowspan="1" %)Code categorie
498 |(% colspan="1" rowspan="1" %)tblBottle|(% colspan="1" rowspan="1" %)BoFilteredTypeCode (int32)|(% colspan="1" rowspan="1" %)Filter type|(% colspan="1" rowspan="1" %)Lookup list|(% colspan="1" rowspan="1" %)Folded filter
499 Ground filter prefilter|(% colspan="1" rowspan="1" %)255- Filtering method for the bottle
500 |(% colspan="1" rowspan="1" %)tblConcernedCompanies|(% colspan="1" rowspan="1" %)CcChamberOfCommerceNr Varchar(50)|(% colspan="1" rowspan="1" %)Chamber of Commerce Nr|(% colspan="1" rowspan="1" %)-|(% colspan="1" rowspan="1" %)-|(% colspan="1" rowspan="1" %)-
501
502 **10-7-2020:**
503
504 (% class="table-hover" %)
505 |(% colspan="1" rowspan="1" %)DSField Table|(% colspan="1" rowspan="1" %)DSField Column|(% colspan="1" rowspan="1" %)Field name in interface|(% colspan="1" rowspan="1" %)Input type|(% colspan="1" rowspan="1" %)Input Options example|(% colspan="1" rowspan="1" %)Code categorie
506 |(% colspan="1" rowspan="1" %)tblLabassignment|(% colspan="1" rowspan="1" %)LbLabStatusCode (int32)|(% colspan="1" rowspan="1" %)n/a|(% colspan="1" rowspan="1" %)n/a|(% colspan="1" rowspan="1" %)n/a|(% colspan="1" rowspan="1" %)62 - Status van de labopdracht gerapporteerd door het lab (SIKB Lab status)
507
508 **20-4-2020:**
509
510 (% class="table-hover" %)
511 |(% colspan="1" rowspan="1" %)DSField Table|(% colspan="1" rowspan="1" %)DSField Column|(% colspan="1" rowspan="1" %)Field name in interface|(% colspan="1" rowspan="1" %)Input type|(% colspan="1" rowspan="1" %)Input Options example|(% colspan="1" rowspan="1" %)Code categorie
512 |(% colspan="1" rowspan="1" %)tblMeasurementPoints|(% colspan="1" rowspan="1" %)MpSortOrder|(% colspan="1" rowspan="1" %)n/a|(% colspan="1" rowspan="1" %)n/a|(% colspan="1" rowspan="1" %)n/a|(% colspan="1" rowspan="1" %)n/a
513 |(% colspan="1" rowspan="1" %)tblMeasurementPoints|(% colspan="1" rowspan="1" %)MpInReports|(% colspan="1" rowspan="1" %)Show in Reports|(% colspan="1" rowspan="1" %)4 boolean|(% colspan="1" rowspan="1" %)Yes/No|(% colspan="1" rowspan="1" %)n/a
514 |(% colspan="1" rowspan="1" %)tblMeasurementPoints|(% colspan="1" rowspan="1" %)MpOvamID|(% colspan="1" rowspan="1" %)n/a|(% colspan="1" rowspan="1" %)n/a|(% colspan="1" rowspan="1" %)n/a|(% colspan="1" rowspan="1" %)n/a
515 |(% colspan="1" rowspan="1" %)tblMeasurementPoints|(% colspan="1" rowspan="1" %)MpInExports|(% colspan="1" rowspan="1" %)Include in Exports|(% colspan="1" rowspan="1" %)4 boolean|(% colspan="1" rowspan="1" %)true/false|(% colspan="1" rowspan="1" %)n/a
516 |(% colspan="1" rowspan="1" %)tblMeasurementPoints|(% colspan="1" rowspan="1" %)MpUsedDevices|(% colspan="1" rowspan="1" %)NL: Gebruikte apparaten
517 EN: Used devices|(% colspan="1" rowspan="1" %)tekst edit|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)
518 |(% colspan="1" rowspan="1" %)tblFilterTubes|(% colspan="1" rowspan="1" %)FtDecommissioned|(% colspan="1" rowspan="1" %)Decommissioned|(% colspan="1" rowspan="1" %)11 list|(% colspan="1" rowspan="1" %)Yes/No|(% colspan="1" rowspan="1" %)73
519 |(% colspan="1" rowspan="1" %)tblFilterTubes|(% colspan="1" rowspan="1" %)FtDecommissionedDate|(% colspan="1" rowspan="1" %)Decommission Date|(% colspan="1" rowspan="1" %)2 date|(% colspan="1" rowspan="1" %)date|(% colspan="1" rowspan="1" %)n/a
520 |(% colspan="1" rowspan="1" %)tblJars|(% colspan="1" rowspan="1" %)JrMatrixCode|(% colspan="1" rowspan="1" %)Matrix|(% colspan="1" rowspan="1" %)11 list|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)6
521 |(% colspan="1" rowspan="1" %)tblLayers|(% colspan="1" rowspan="1" %)LaOvamID|(% colspan="1" rowspan="1" %)n/a|(% colspan="1" rowspan="1" %)n/a|(% colspan="1" rowspan="1" %)n/a|(% colspan="1" rowspan="1" %)n/a
522 |(% colspan="1" rowspan="1" %)tblLayers|(% colspan="1" rowspan="1" %)LaSampleQualityClassCode|(% colspan="1" rowspan="1" %)Sample quality class/ Monster kwaliteitsklasse|(% colspan="1" rowspan="1" %)11
523 list|(% colspan="1" rowspan="1" %)QM1, QM2, QM3, QM4, QM5|(% colspan="1" rowspan="1" %)245
524 |(% colspan="1" rowspan="1" %)tblLayers|(% colspan="1" rowspan="1" %)LaSecondaryBeddingTypeCode|(% colspan="1" rowspan="1" %)Secundaire Gelaagdheid type|(% colspan="1" rowspan="1" %)11 list|(% colspan="1" rowspan="1" %)Grindlagen, Zandlagen, Siltlagen, Kleilagen, Veenlagen, Humuslagen, Detrituslagen, Schelpmateriaallagen, Bruinkoollagen.|(% colspan="1" rowspan="1" %)247
525 |(% colspan="1" rowspan="1" %)tblLayers|(% colspan="1" rowspan="1" %)LaSecondaryBeddingThicknessCode|(% colspan="1" rowspan="1" %)Secundaire Gelaagdheid dikte|(% colspan="1" rowspan="1" %)11
526 list|(% colspan="1" rowspan="1" %)Dun gelamineerd (< 6 mm)
527 Dik gelamineerd (6 tot 20 mm)
528 Zeer dun gelaagd (20 tot 60 mm)
529 Dun gelaagd (60 tot 200 mm)|(% colspan="1" rowspan="1" %)243
530 |(% colspan="1" rowspan="1" %)tblLayers|(% colspan="1" rowspan="1" %)LaSecondaryBeddingGradationCode|(% colspan="1" rowspan="1" %)Secundaire gelaagdheid gradatie|(% colspan="1" rowspan="1" %)11
531 list|(% colspan="1" rowspan="1" %)Veel, Weinig|(% colspan="1" rowspan="1" %)246
532 |(% colspan="1" rowspan="1" %)tblLayers|(% colspan="1" rowspan="1" %)LaDisperseInhomogeneityCode|(% colspan="1" rowspan="1" %)Disperse Inhomogeneity/ Disperse Inhomogeniteit |(% colspan="1" rowspan="1" %)11
533 list|(% colspan="1" rowspan="1" %)Veel grindlensjes, Weinig grindlensjes, Veel kleibrokken, Weinig kleibrokken, Veel kleilensjes, Weinig kleilensjes, Veel veenbrokken, Weinig veenbrokken, Veel zandlensjes, Weinig zandlensjes|(% colspan="1" rowspan="1" %)248
534 |(% colspan="1" rowspan="1" %)tblLayers|(% colspan="1" rowspan="1" %)LaDrillingProgressCode|(% colspan="1" rowspan="1" %)(((
535 DE: bohrfortschritt
536
537 NL: boorvoortgang
538
539 EN: drilling progress
540 )))|(% colspan="1" rowspan="1" %)11
541 list|(% colspan="1" rowspan="1" %)sl - very easy to drill - 1m in 1-10 s.
542 l - easy to drill - 1m in 10-30 s.
543 m - medium difficulty to drill - 1m in 30 - 60 s.
544 sl - difficult to drill - 1m in 1-2 min.
545 ss - very difficult to drill - 1 m in > 2 min.
546 BH - drilling obstacle
547 kBf at ET - No drilling progress at final depth|(% colspan="1" rowspan="1" %)249
548 |(% colspan="1" rowspan="1" %)tblWaterSamples|(% colspan="1" rowspan="1" %)WsSortOrder|(% colspan="1" rowspan="1" %)n/a|(% colspan="1" rowspan="1" %)n/a|(% colspan="1" rowspan="1" %)n/a|(% colspan="1" rowspan="1" %)n/a
549 |(% colspan="1" rowspan="1" %)tblWaterSamples|(% colspan="1" rowspan="1" %)WsInReports|(% colspan="1" rowspan="1" %)Show in Reports|(% colspan="1" rowspan="1" %)4 boolean|(% colspan="1" rowspan="1" %)true/false|(% colspan="1" rowspan="1" %)11
550 |(% colspan="1" rowspan="1" %)tblWaterSamples|(% colspan="1" rowspan="1" %)WsOvamID|(% colspan="1" rowspan="1" %)n/a|(% colspan="1" rowspan="1" %)n/a|(% colspan="1" rowspan="1" %)n/a|(% colspan="1" rowspan="1" %)n/a
551 |(% colspan="1" rowspan="1" %)tblWaterSamples|(% colspan="1" rowspan="1" %)WsInExports|(% colspan="1" rowspan="1" %)Include in Exports|(% colspan="1" rowspan="1" %)4 boolean|(% colspan="1" rowspan="1" %)true/false|(% colspan="1" rowspan="1" %)11
552 |(% colspan="1" rowspan="1" %)tblObservations (tblWaterSampleMeasurements)|(% colspan="1" rowspan="1" %)NIEUWE OBSERVATION MetingType: 99|(% colspan="1" rowspan="1" %)(((
553 DE: Witterung nach KA5
554
555 NL: Weersomstandigheden
556
557 EN: Weather conditions
558 )))|(% colspan="1" rowspan="1" %)11
559 list|(% colspan="1" rowspan="1" %)WT1
560 WT2
561 WT3
562 WT4
563 WT5
564 WT6|(% colspan="1" rowspan="1" %)251
565 |(% colspan="1" rowspan="1" %)tblObservations (tblWaterSampleMeasurements)|(% colspan="1" rowspan="1" %)NIEUWE OBSERVATION MetingType: 98|(% colspan="1" rowspan="1" %)(((
566 DE: Standardspannung UB (mV)
567
568 NL: Standaardspanning (mV)
569
570 EN: Standard voltage  (mV)
571 )))|(% colspan="1" rowspan="1" %)6 float|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)
572 |(% colspan="1" rowspan="1" %)tblObservations (tblWaterSampleMeasurements)|(% colspan="1" rowspan="1" %)NIEUWE OBSERVATION MetingType: 100|(% colspan="1" rowspan="1" %)(((
573 NL: Grondwaterstand na voorpompen (cm-ref)
574
575 EN: Groundwater level after prepump (cm -ref)
576 )))|(% colspan="1" rowspan="1" %)6 float|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)
577 |(% colspan="1" rowspan="1" %)tblWaterSamples|(% colspan="1" rowspan="1" %)WsUsedDevices|(% colspan="1" rowspan="1" %)NL: Gebruikte apparaten
578 EN: Used devices|(% colspan="1" rowspan="1" %)tekst edit|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)
579 |(% colspan="1" rowspan="1" %)tblProjects|(% colspan="1" rowspan="1" %)PrReportName|(% colspan="1" rowspan="1" %)Report Name|(% colspan="1" rowspan="1" %)string|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)
580 |(% colspan="1" rowspan="1" %)tblProjects|(% colspan="1" rowspan="1" %)PrStartDate|(% colspan="1" rowspan="1" %)Start Date|(% colspan="1" rowspan="1" %)2 date|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)
581 |(% colspan="1" rowspan="1" %)tblProjects|(% colspan="1" rowspan="1" %)PrEndDate|(% colspan="1" rowspan="1" %)End Date|(% colspan="1" rowspan="1" %)2 date|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)
582 |(% colspan="1" rowspan="1" %)tblProjects|(% colspan="1" rowspan="1" %)PrConsultStartDate|(% colspan="1" rowspan="1" %)Advice Start Date|(% colspan="1" rowspan="1" %)2 date|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)
583 |(% colspan="1" rowspan="1" %)tblProjects|(% colspan="1" rowspan="1" %)PrConsultEndDate|(% colspan="1" rowspan="1" %)Advice End Date|(% colspan="1" rowspan="1" %)2 date|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)
584 |(% colspan="1" rowspan="1" %)tblProjects|(% colspan="1" rowspan="1" %)PrFieldworkStartDate|(% colspan="1" rowspan="1" %)Fieldwork Start Date|(% colspan="1" rowspan="1" %)2 date|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)
585 |(% colspan="1" rowspan="1" %)tblProjects|(% colspan="1" rowspan="1" %)PrFieldworkEndDate|(% colspan="1" rowspan="1" %)Fieldwork End Date|(% colspan="1" rowspan="1" %)2 date|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)
586 |(% colspan="1" rowspan="1" %)tblProjects|(% colspan="1" rowspan="1" %)PrGroundwaterFlowDirection|(% colspan="1" rowspan="1" %)Groundwater Flow Direction (eenheid nakijken!)|(% colspan="1" rowspan="1" %)6
587 float|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)
588 |(% colspan="1" rowspan="1" %)tblProjects|(% colspan="1" rowspan="1" %)PrGroundwaterDepth|(% colspan="1" rowspan="1" %)Groundwater Depth (eenheid nakijken!)|(% colspan="1" rowspan="1" %)6
589 float|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)
590 |(% colspan="1" rowspan="1" %)tblProjects|(% colspan="1" rowspan="1" %)PrOvamID|(% colspan="1" rowspan="1" %)n/a|(% colspan="1" rowspan="1" %)n/a|(% colspan="1" rowspan="1" %)n/a|(% colspan="1" rowspan="1" %)n/a
591 |(% colspan="1" rowspan="1" %)tblAnalysisSamples|(% colspan="1" rowspan="1" %)AnSortOrder|(% colspan="1" rowspan="1" %)n/a|(% colspan="1" rowspan="1" %)n/a|(% colspan="1" rowspan="1" %)n/a|(% colspan="1" rowspan="1" %)n/a
592 |(% colspan="1" rowspan="1" %)tblAnalysisSamples|(% colspan="1" rowspan="1" %)AnInReports|(% colspan="1" rowspan="1" %)Show in Reports|(% colspan="1" rowspan="1" %)4 boolean|(% colspan="1" rowspan="1" %)true/false|(% colspan="1" rowspan="1" %)
593 |(% colspan="1" rowspan="1" %)tblAnalysisSamples|(% colspan="1" rowspan="1" %)AnOvamID|(% colspan="1" rowspan="1" %)n/a|(% colspan="1" rowspan="1" %)n/a|(% colspan="1" rowspan="1" %)n/a|(% colspan="1" rowspan="1" %)n/a
594 |(% colspan="1" rowspan="1" %)tblAnalysisSamples|(% colspan="1" rowspan="1" %)AnInExports|(% colspan="1" rowspan="1" %)Include in Exports|(% colspan="1" rowspan="1" %)4 boolean|(% colspan="1" rowspan="1" %)true/false|(% colspan="1" rowspan="1" %)
595 |(% colspan="1" rowspan="1" %)tblJars|(% colspan="1" rowspan="1" %)JrSampleHumidityCode|(% colspan="1" rowspan="1" %)Sample Humidity/ Monstervochtigheid |(% colspan="1" rowspan="1" %)11 list|(% colspan="1" rowspan="1" %)Volledig uitgedroogd, Uitgedroogd, Veldvochtig|(% colspan="1" rowspan="1" %)250
596
597 **27 maart 2020:**
598
599 (% class="table-hover" %)
600 |(% colspan="1" rowspan="1" %)tblMeasurementPoint|(% colspan="1" rowspan="1" %)(((
601 MpDescriptionQualityCode
602
603 **String(10)**
604 )))|(% colspan="1" rowspan="1" %)Beschrijfkwaliteit|(% colspan="1" rowspan="1" %)List (11)|(% colspan="1" rowspan="1" %)(((
605 * 1 - B1: Uitgebreide monsterbeschrijving
606 * 2 - B2: Standaard monsterbechrijving
607 * 3 - B3: Verkennende monsterbeschrijving
608 \\Verwijderde waardes:
609 LET OP: Codeid 3 = 1 geworden, en 1 = 3 geworden
610 * 1 - klasse2geroerd
611 * 2 - klasse2ongedifferentieerd
612 * 3 - klasse2ongeroerd
613 * klasse3
614 * nietGespecificeerd
615 )))|(% colspan="1" rowspan="1" %)239
616
617 **18-Dec-2019**
618
619 Additional BRO fields
620
621 (% class="table-hover" %)
622 |=(% colspan="1" rowspan="1" %)(((
623 **Table DSField**
624 )))|=(% colspan="1" rowspan="1" %)(((
625 **Column DSField**
626 )))|=(% colspan="1" rowspan="1" %)(((
627 **Namefield in interface**
628 )))|=(% colspan="1" rowspan="1" %)(((
629 **Input type**
630 )))|=(% colspan="1" rowspan="1" %)(((
631 **Options**
632 )))|=(% colspan="1" rowspan="1" %)(((
633 **Code Category**
634 )))
635 |(% colspan="1" rowspan="1" %)tblMeasurementPoint|(% colspan="1" rowspan="1" %)(((
636 MpVerticalPositioningMethodCode
637
638 **String(10)**
639 )))|(% colspan="1" rowspan="1" %)Precisie hoogte|(% colspan="1" rowspan="1" %)List (11)|(% colspan="1" rowspan="1" %)(((
640 * RTKGPS0tot4cm
641 * RTKGPS4tot10cm
642 * RTKGPS10tot20cm
643 * RTKGPS20tot100cm
644 * tachymetrie0tot10cm
645 * tachymetrie10tot50cm
646 * waterpassing0tot2cm
647 * waterpassing4tot10cm
648 * waterpassing2tot4cm
649 )))|(% colspan="1" rowspan="1" %)235
650 |(% colspan="1" rowspan="1" %)tblMeasurementPoint|(% colspan="1" rowspan="1" %)(((
651 MpStopCriterionCode
652
653 **String(10)**
654 )))|(% colspan="1" rowspan="1" %)Reden boring gestopt|(% colspan="1" rowspan="1" %)(((
655 List (11)
656
657
658 )))|(% colspan="1" rowspan="1" %)(((
659 * beperkingTechnisch
660 * einddoel
661 * obstakelConstructie
662 * obstakelGrindStenen
663 * obstakelIJzervloer
664 * obstakelOnbekend
665 * obstakelPuin
666 * obstakelVastGesteente
667 * risico
668 * risicoGrondwaterdruk
669 * storingOrganisatorisch
670 * storingTechnisch
671 * werkwaterverlies
672 * onbekend
673 )))|(% colspan="1" rowspan="1" %)236
674 |(% colspan="1" rowspan="1" %)tblJars|(% colspan="1" rowspan="1" %)(((
675 JrSamplingQualityCode
676
677 **String(10)**
678 )))|(% colspan="1" rowspan="1" %)Bemonsteringskwaliteit|(% colspan="1" rowspan="1" %)List (11)|(% colspan="1" rowspan="1" %)(((
679 * klasseA
680 * klasseB
681 * klasseC
682 * klasseD
683 * klasseE
684 )))|(% colspan="1" rowspan="1" %)237
685 |(% colspan="1" rowspan="1" %)tblJars|(% colspan="1" rowspan="1" %)(((
686 JrMethodCode
687
688 **String(10)**
689 )))|(% colspan="1" rowspan="1" %)Bemonsteringsmethode|(% colspan="1" rowspan="1" %)List (11)|(% colspan="1" rowspan="1" %)(((
690 * graven
691 * opAfstandDroog
692 * opAfstandNat
693 * opDiepteGrijpen
694 * opDiepteKernen
695 * opDiepteLosroeren
696 * opDiepteUitsteken
697 * drukken
698 * hammeren
699 )))|(% colspan="1" rowspan="1" %)(((
700 **125 / Old: 40**
701
702
703 )))
704 |(% colspan="1" rowspan="1" %)tblMeasurementPoint|(% colspan="1" rowspan="1" %)(((
705 MpDescriptionQualityCode
706
707 **String(10)**
708 )))|(% colspan="1" rowspan="1" %)Beschrijfkwaliteit|(% colspan="1" rowspan="1" %)List (11)|(% colspan="1" rowspan="1" %)(((
709 * klasse2geroerd
710 * klasse2ongedifferentieerd
711 * klasse2ongeroerd
712 * klasse3
713 * nietGespecificeerd
714 )))|(% colspan="1" rowspan="1" %)239
715 |(% colspan="1" rowspan="1" %)tblMeasurementPoint|(% colspan="1" rowspan="1" %)(((
716 MpContinuouslySampledCode
717
718 **String(10)**
719 )))|(% colspan="1" rowspan="1" %)Continu bemonsterd|(% colspan="1" rowspan="1" %)List (11)|(% colspan="1" rowspan="1" %)(((
720 * Ja
721 * Nee
722 )))|(% colspan="1" rowspan="1" %)**73 / OLD: 26**
723 |(% colspan="1" rowspan="1" %)tblMeasurementPoint|(% colspan="1" rowspan="1" %)(((
724 MpDescriptionLocationCode
725
726 **String(10)**
727 )))|(% colspan="1" rowspan="1" %)Beschrijflocatie|(% colspan="1" rowspan="1" %)List (11)|(% colspan="1" rowspan="1" %)(((
728 * lab
729 * veld
730 * veldlab
731 * onbekend
732 )))|(% colspan="1" rowspan="1" %)240
733 |(% colspan="1" rowspan="1" %)tblMeasurementPoint|(% colspan="1" rowspan="1" %)(((
734 MpDescribedMaterialCode
735
736 **String(10)**
737 )))|(% colspan="1" rowspan="1" %)Beschreven materiaal|(% colspan="1" rowspan="1" %)List (11)|(% colspan="1" rowspan="1" %)(((
738 * grond
739 * grondGesteente
740 * gesteente
741 )))|(% colspan="1" rowspan="1" %)241
742 |(% colspan="1" rowspan="1" %)tblLayers|(% colspan="1" rowspan="1" %)(((
743 LaUpperBoundaryDeterminationCode
744
745 **String(10)**
746 )))|(% colspan="1" rowspan="1" %)Laagovergang bovenkant|(% colspan="1" rowspan="1" %)List (11)|(% colspan="1" rowspan="1" %)(((
747 * afgeleid
748 * afgeleidSondering
749 * voorbepaald
750 * waargenomenScherp
751 * waargenomenGeleidelijk
752 * waargenomenDiffuus
753 * waargenomenWillekeurig
754 )))|(% colspan="1" rowspan="1" %)242
755 |(% colspan="1" rowspan="1" %)tblLayers|(% colspan="1" rowspan="1" %)(((
756 LaLowerBoundaryDeterminationCode
757
758 **String(10)**
759 )))|(% colspan="1" rowspan="1" %)Laagovergang onderkant|(% colspan="1" rowspan="1" %)List (11)|(% colspan="1" rowspan="1" %)(((
760 * afgeleid
761 * afgeleidSondering
762 * voorbepaald
763 * waargenomenScherp
764 * waargenomenGeleidelijk
765 * waargenomenDiffuus
766 * waargenomenWillekeurig
767 )))|(% colspan="1" rowspan="1" %)242
768 |(% colspan="1" rowspan="1" %)tblLayers|(% colspan="1" rowspan="1" %)(((
769 LaAnthropogenicCode
770
771 **String(10)**
772 )))|(% colspan="1" rowspan="1" %)Antropogeen|(% colspan="1" rowspan="1" %)List (11)|(% colspan="1" rowspan="1" %)(((
773 * Ja
774 * Nee
775 )))|(% colspan="1" rowspan="1" %)**73 / OLD: 26**
776 |(% colspan="1" rowspan="1" %)tblLayers|(% colspan="1" rowspan="1" %)(((
777 LaBeddingCode
778
779 **String(10)**
780 )))|(% colspan="1" rowspan="1" %)Gelaagdheid|(% colspan="1" rowspan="1" %)List (11)|(% colspan="1" rowspan="1" %)(((
781 * dunGelamineerd
782 * dikGelamineerd
783 * ergDunGelaagd
784 * dunGelaagd
785 * mmGelaagd
786 * cmGelaagd
787 * dmGelaagd
788 )))|(% colspan="1" rowspan="1" %)243
789 |(% colspan="1" rowspan="1" %)tblLayers|(% colspan="1" rowspan="1" %)(((
790 LaIsRootedCode
791
792 **String(10)**
793 )))|(% colspan="1" rowspan="1" %)Beworteld|(% colspan="1" rowspan="1" %)List (11)|(% colspan="1" rowspan="1" %)(((
794 * Ja
795 * Nee
796 )))|(% colspan="1" rowspan="1" %)**73 / OLD: 26**
797 |(% colspan="1" rowspan="1" %)tblMeasurementPoint|(% colspan="1" rowspan="1" %)(((
798 MpCoordinatesTimestamp
799
800 **DateTime**
801 )))|(% colspan="1" rowspan="1" %)Datum locatiebepaling|(% colspan="1" rowspan="1" %)DateTimeEditor (13)|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)
802 |(% colspan="1" rowspan="1" %)tblMeasurementPoint|(% colspan="1" rowspan="1" %)(((
803 MpBroID
804
805 **Varchar(50)**
806 )))|(% colspan="1" rowspan="1" %)BRO-ID|(% colspan="1" rowspan="1" %)textEditor (1)|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)(((
807
808
809
810 )))
811 |(% colspan="1" rowspan="1" %)tblLayers|(% colspan="1" rowspan="1" %)(((
812 LaTensileStrengthCode
813
814 **String(10)**
815 )))|(% colspan="1" rowspan="1" %)Treksterkte|(% colspan="1" rowspan="1" %)Lijst (11)|(% colspan="1" rowspan="1" %)(((
816 * Geen sterkte
817 * Laag
818 * Matig
819 * Hoog
820 )))|(% colspan="1" rowspan="1" %)244
821
822 **05-Aug-2019**
823
824 Additional **ISO14688** fields
825
826 (% class="table-hover" %)
827 |=(% colspan="1" rowspan="1" %)(((
828 **Table DSField**
829 )))|=(% colspan="1" rowspan="1" %)(((
830 **Column DSField**
831 )))|=(% colspan="1" rowspan="1" %)(((
832 **Namefield in interface**
833 )))|=(% colspan="1" rowspan="1" %)(((
834 **Input type**
835 )))|=(% colspan="1" rowspan="1" %)(((
836 **Options**
837 )))|=(% colspan="1" rowspan="1" %)(((
838 **Code Category**
839 )))
840
841 (% class="table-hover" %)
842 |=(% colspan="1" rowspan="1" %)(((
843 **Table DSField**
844 )))|=(% colspan="1" rowspan="1" %)(((
845 **Column DSField**
846 )))|=(% colspan="1" rowspan="1" %)(((
847 **Namefield in interface**
848 )))|=(% colspan="1" rowspan="1" %)(((
849 **Input type**
850 )))|=(% colspan="1" rowspan="1" %)(((
851 **Options**
852 )))|=(% colspan="1" rowspan="1" %)(((
853 **Code Category**
854 )))
855 |(% colspan="1" rowspan="1" %)tblLayers|(% colspan="1" rowspan="1" %)(((
856 LaTextureTertiaryCode
857
858 **String(10)**
859 )))|(% colspan="1" rowspan="1" %)Tertiar|(% colspan="1" rowspan="1" %)List (11)|(% colspan="1" rowspan="1" %)(((
860 * Schelpfracties
861 * Glauconietkorrels
862 * IJzersulfiden
863 * Plantenresten
864 * Wortelresten
865 * Kalkhoudende concreties
866 )))|(% colspan="1" rowspan="1" %)226
867 |(% colspan="1" rowspan="1" %)tblLayers|(% colspan="1" rowspan="1" %)(((
868 LaTexturePlasticityCode
869
870 **String(10)**
871 )))|(% colspan="1" rowspan="1" %)Plasticiteit|(% colspan="1" rowspan="1" %)List (11)|(% colspan="1" rowspan="1" %)(((
872 * Niet
873 * Weinig
874 * Matig
875 * Sterk
876 )))|(% colspan="1" rowspan="1" %)227
877 |(% colspan="1" rowspan="1" %)tblLayers|(% colspan="1" rowspan="1" %)(((
878 LaTextureGrainShapeCode
879
880 **String(10)**
881 )))|(% colspan="1" rowspan="1" %)Korrelvorm|(% colspan="1" rowspan="1" %)List (11)|(% colspan="1" rowspan="1" %)(((
882 * Zeer Hoekig
883 * Hoekig
884 * Subhoekig
885 * Subrond
886 * Afgerond
887 * Zeer afgerond
888 )))|(% colspan="1" rowspan="1" %)228
889 |(% colspan="1" rowspan="1" %)tblLayers|(% colspan="1" rowspan="1" %)(((
890 LaTextureFormCode
891
892 **String(10)**
893 )))|(% colspan="1" rowspan="1" %)Vorm|(% colspan="1" rowspan="1" %)List (11)|(% colspan="1" rowspan="1" %)(((
894 * Bol
895 * Plat
896 * Langwerpig
897 )))|(% colspan="1" rowspan="1" %)229
898 |(% colspan="1" rowspan="1" %)tblLayers|(% colspan="1" rowspan="1" %)(((
899 LaTextureSurfaceCode
900
901 **String(10)**
902 )))|(% colspan="1" rowspan="1" %)Oppervlakte|(% colspan="1" rowspan="1" %)List (11)|(% colspan="1" rowspan="1" %)(((
903 * Ruw
904 * Glad
905 )))|(% colspan="1" rowspan="1" %)230
906 |(% colspan="1" rowspan="1" %)tblLayers|(% colspan="1" rowspan="1" %)(((
907 LaTextureParticleStrengthCode
908
909 **String(10)**
910 )))|(% colspan="1" rowspan="1" %)Deeltjes Sterkte|(% colspan="1" rowspan="1" %)List (11)|(% colspan="1" rowspan="1" %)(((
911 * Extreem zwawk
912 * Zeer zwak
913 * Zwak
914 * Matig zwak
915 * Gemiddeld sterk
916 * Sterk
917 * Zeer sterk
918 * Extreem sterk
919 )))|(% colspan="1" rowspan="1" %)231
920 |(% colspan="1" rowspan="1" %)tblLayers|(% colspan="1" rowspan="1" %)(((
921 LaRockShapeCode
922
923 **String(10)**
924 )))|(% colspan="1" rowspan="1" %)Steenvorm|(% colspan="1" rowspan="1" %)List (11)|(% colspan="1" rowspan="1" %)(((
925 * Molenstenen
926 * Schaalachtig
927 * Blokken
928 )))|(% colspan="1" rowspan="1" %)232
929 |(% colspan="1" rowspan="1" %)tblLayers|(% colspan="1" rowspan="1" %)(((
930 LaRockWeatheringCode
931
932 **String(10)**
933 )))|(% colspan="1" rowspan="1" %)Steen Verwering|(% colspan="1" rowspan="1" %)List (11)|(% colspan="1" rowspan="1" %)(((
934 * Veranderde
935 * Gebarsten
936 * Fractured
937 * Gemalen
938 )))|(% colspan="1" rowspan="1" %)233
939
940
941 )))
942
943
Robin Huisman 23.1 944
945
Roelof Zwaan 5.2 946 (% class="col-xs-12 col-sm-4" %)
947 (((
948 {{box title="**Contents**"}}
949 {{toc/}}
950 {{/box}}
951 )))
952 )))

Navigation

TerraIndex
asd