Version 12.1 by Richard Dyer on 2022/04/14 11:39
Show last authors
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
13 [[(% class="wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink" %)**dsFieldproject format XSD file**>>attach:dsFieldProject.xsd]]
14
15 [[(% class="wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink" %)**Codelookup excel list**>>attach:20200619 Codelookup.xlsx]]
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
32 {{code language="XML" layout="LINENUMBERS" width="100%"}}
33
34 <dsFieldProject
35 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
36 xsi:noNamespaceSchemaLocation="file:///C:/Temp/dsFieldProject.xsd">
37 <tblProjects>
38 <PrID>242</PrID>
39 <PrCode>2018-010-DEMO</PrCode>
40 <PrName>TU Delft, the Netherlands</PrName>
41 <PrConsultancyFirm>TerraIndex</PrConsultancyFirm>
42 <PrLeaderCode>Consult</PrLeaderCode>
43 <PrFieldworkFirm>TerraIndex</PrFieldworkFirm>
44 <PrDrillingMasterCode>Borelog</PrDrillingMasterCode>
45 <PrGuid>46ba5f9e-5d59-8c8c-c5d6-ac9e9651ec4b</PrGuid>
46 <PrDateLastChanged>2018-08-31T11:12:50.45</PrDateLastChanged>
47 <PrLocPointGeometry>POINT (6.1000890695634133 52.58846240818189)</PrLocPointGeometry>
48 <PrTemplateID>23737</PrTemplateID>
49 <PrCoordinateSystem>RD</PrCoordinateSystem>
50 </tblProjects>
51 <tblMeasurementPoints>
52 <MpID>1</MpID>
53 <MpName>A01</MpName>
54 <MpNameNumeric>1</MpNameNumeric>
55 <MpDate>2018-08-01T00:00:00</MpDate>
56 <MpDepth>300</MpDepth>
57 <MpXCoord>203588.1</MpXCoord>
58 <MpYCoord>511339.61</MpYCoord>
59 <MpDrillingMasterCode>John Borelog</MpDrillingMasterCode>
60 <MpGroundLevelTypeCode>KL</MpGroundLevelTypeCode>
61 <MpTypeCode>P</MpTypeCode>
62 <MpCoordinatesPrecisionCode>G1</MpCoordinatesPrecisionCode>
63 <PrID>242</PrID>
64 <MpGuid>d09c8af7-45d1-4cd2-939f-7db42218b4ec</MpGuid>
65 <MpDateLastChanged>2018-08-28T10:00:26.567</MpDateLastChanged>
66 <MpPointGeometry>POINT (6.10416686139686 52.5874623700489)</MpPointGeometry>
67 </tblMeasurementPoints>
68 <tblMeasurementPoints>
69 <MpID>2</MpID>
70 <MpName>A04</MpName>
71 <MpNameNumeric>4</MpNameNumeric>
72 <MpDate>2018-08-01T00:00:00</MpDate>
73 <MpDepth>300</MpDepth>
74 <MpXCoord>203508.7</MpXCoord>
75 <MpYCoord>511382.74</MpYCoord>
76 <MpDrillingMasterCode>John Borelog</MpDrillingMasterCode>
77 <MpGroundLevelTypeCode>KL</MpGroundLevelTypeCode>
78 <MpTypeCode>B</MpTypeCode>
79 <MpGWT>150</MpGWT>
80 <MpCoordinatesPrecisionCode>G1</MpCoordinatesPrecisionCode>
81 <PrID>242</PrID>
82 <MpGuid>133ef5e8-2990-4b75-b718-27cd7bb9630d</MpGuid>
83 <MpDateLastChanged>2018-08-28T10:00:26.57</MpDateLastChanged>
84 <MpPointGeometry>POINT (6.10300163732122 52.5878570271434)</MpPointGeometry>
85 </tblMeasurementPoints>
86 </dsFieldProject
87 {{/code}}
88
89 (% class="box infomessage" %)
90 (((
91 When you need help with detailed mappings, please request help at: service@terraindex.com
92 )))
93
94 == Changes and updates: ==
95
96 == Changes and updates: ==
97
98 **27-01-2022:**
99
100 |**Labeltext in English**|**Remarks**|**Definition and process how this field will be used and when it will be filled.**|(((
101 **Change/Add/**
102
103 **Delete**
104 )))|**DB Type
105 (String (length) / Float / Lookupvalue / Integer / DateTime)**|**DBTable in dsFieldProject**|**DBFieldname in dsFieldProject**
106 |Use of location| |To add the current use of the location to a measurement point|Add|Lookupvalue|tblMeasurementPoints|MpLocationUsageCode
107 |Type|New codelist optios added |-|Change|Lookupvalue|tblMeasurementPoint|MpType
108 |Interior location| |Yes / no field for if the sample is an interior location|Add|Lookupvalue|tblMeasurementPoints|MpIsIndoorsCode
109 |FlowTypesSurfaceWater| |Describes the flowing pattern of the surface water sampling location|Add|Lookupvalue|tblObservations|METINGCODE 148
110 |Location flow rate| |The flow rate of the sampling location|Add|Lookupvalue|tblObservations|METINGCODE 149
111 |Special conditions| |Remark field for special sampling conditions to print in report|Add|String|tblWatersamples|JrStreamlineGUID
112 |Pump type|Codelist used for several fields|New options added to codelist|Change|Lookupvalue|Multiple fields|Multiple fields
113 |Pump connection| |Field for the power connection of a pump|Add|LookupValue|tblObservations|METINGCODE 150
114 |Matrix| |Added codelist options|Change|Lookupvalue|tblWatersamples|WsMatrix
115 |Mesh size (mm)| |Field for the mesh size of a monitoring well filter|Add|Float|tblFiltertubes|FtMeshSize
116 |Type|Project level|New codelist options|Change|Lookupvalue|tblProjects|PrType
117 |Type|Finishing level|New codelist options|Change|Lookupvalue|tblFinishings|FiType
118 |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)
119 |Pumped volume series| |Field for the total pumped volume during a single series|Add|Float|tblObservations|METINGCODE 152 (Series), METINGCODE 151 (Stable value)
120
121 **22-11-2021:**
122
123 |**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**
124 | | | | | | | | | |
125 |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
126 |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
127 |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
128 |Water samples|Surrounding humidity|Omgevingsvochtigheid|Licht vochtig, Zeer vochtig, Vochtig op bodem, Vochtig op plaatsen|The circumstances when sampling| |Add|Codelist|(((
129 * tblObservations
130 * tblWatersampleMeasurements
131 )))|Metingcode: 147 / WsSurroundingHumidity
132
133 **18-10-2021:**
134
135 (% class="table-hover" style="height:1452px; width:1050px" %)
136 |=(% colspan="1" rowspan="1" %)(((
137 **Labeltext in English**
138 )))|=(% colspan="1" rowspan="1" %)(((
139 **Remarks**
140 )))|=(% colspan="1" rowspan="1" %)(((
141 **Definition and process how this field will be used and when it will be filled.**
142 )))|=(% colspan="1" rowspan="1" %)(((
143 **Change/Add/Delete**
144 )))|=(% colspan="1" rowspan="1" %)(((
145 **DB Type**
146 **(String (length) / Float / Lookupvalue / Integer / DateTime)**
147 )))|=(% colspan="1" rowspan="1" %)(((
148 **DBTable in dsFieldProject**
149 )))|=(% colspan="1" rowspan="1" %)(((
150 **DBFieldname in dsFieldProject**
151 )))
152 |(% 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
153 |(% 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
154 |(% 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
155 |(% 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
156 |(% 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
157 |(% 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
158 |(% 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
159 |(% 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
160 |(% 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
161 |(% 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
162 |(% 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
163
164 **07-10-2021:**
165
166 (% class="table-hover" style="height:1676px; width:1195px" %)
167 |=(% colspan="1" rowspan="1" %)(((
168 **Screen to add the extra field**
169 )))|=(% colspan="1" rowspan="1" %)(((
170 **Labeltext in English**
171 )))|=(% colspan="1" rowspan="1" %)(((
172 **Labeltext in Dutch**
173 )))|=(% colspan="1" rowspan="1" %)(((
174 **Examples of values and how it should be printed in a report.**
175 )))|=(% colspan="1" rowspan="1" %)(((
176 **Definition and process how this field will be used and when it will be filled.**
177 )))|=(% colspan="1" rowspan="1" %)(((
178 **Change/Add/Delete**
179 )))|=(% colspan="1" rowspan="1" %)(((
180 **DB Type**
181 **(String (length) / Float / Lookupvalue / Integer / DateTime)**
182 )))|=(% colspan="1" rowspan="1" %)(((
183 **DBTable in dsFieldProject**
184 )))|=(% colspan="1" rowspan="1" %)(((
185 **DBFieldname in dsFieldProject**
186 )))
187 |(% 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
188 |(% 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
189 |(% 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
190 |(% 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
191 |(% 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
192 |(% 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
193 |(% 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
194 |(% 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
195 |(% 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
196 |(% 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
197 |(% 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
198 |(% 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
199 |(% 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
200 |(% 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
201 |(% 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
202 |(% 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
203
204 **6-8-2021:**
205
206 (% class="table-hover" %)
207 |(% 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**
208 **(String (length) / Float / Lookupvalue / Integer / DateTime)**|(% colspan="1" rowspan="1" %)**DBTable in dsFieldProject**|(% colspan="1" rowspan="1" %)**DBFieldname in dsFieldProject**
209 |(% 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
210 |(% 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
211 |(% 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
212 |(% 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
213 |(% 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
214
215 **1-6-2021:**
216
217 (% class="table-hover" %)
218 |(% 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**
219 **(String (length) / Float / Lookupvalue / Integer / DateTime)**|(% colspan="1" rowspan="1" %)**DBTable in dsFieldProject**|(% colspan="1" rowspan="1" %)**DBFieldname in dsFieldProject**
220 |(% colspan="1" rowspan="1" %)Layer Details|(% colspan="1" rowspan="1" %)K qualification|(% colspan="1" rowspan="1" %)(((
221 they don't give any value to K but appreciations.
222
223 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.
224
225 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.
226 doorlatendheid: (k-waarde in m/etmaal)
227 )))|(% 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
228 |(% colspan="1" rowspan="1" %)Layer description|(% colspan="1" rowspan="1" %)colorimetric measurements (ppm|(% colspan="1" rowspan="1" %)(((
229 when PID gives strange values, colorimetric tube will be used. Values are always expressed in ppm
230 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.
231 De colorimetric values shall be displayed in a graphic (in the same way as the PID graphic) in the drilling profile.
232
233 Pid meting slaat uit, dan plaatsen ze een buisje om extra stoffen te meten. Is dus echt een aparte meting.
234 )))|(% 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
235 |(% 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
236 |(% colspan="1" rowspan="1" %)water sample details|(% colspan="1" rowspan="1" %)Cleaned|(% colspan="1" rowspan="1" %)(((
237 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.
238
239 Overslaan, opgelost met als Diepte na schoonmaken gevuld is, dan is er ook schoongemaakt.
240 )))|(% 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
241 |(% colspan="1" rowspan="1" %)water sample details|(% colspan="1" rowspan="1" %)depth of gauging tube before cleaning (cm - ref)|(% colspan="1" rowspan="1" %)(((
242 shall appear if the feld "cleaning" is turned on.
243
244 Appearing will be always, because the checkbox will be removed.
245 )))|(% 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
246 |(% 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
247 |(% colspan="1" rowspan="1" %)Soil Gaz sample details - stable|(% colspan="1" rowspan="1" %)Lower Explosive Level ~(%)|(% colspan="1" rowspan="1" %)(((
248 parameter that need to be measured during soil gaz sampling, for security reasons
249
250 STABLE VALUE!!
251 )))|(% 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
252 |(% colspan="1" rowspan="1" %)Soil Gaz sample details - series|(% colspan="1" rowspan="1" %)Lower Explosive Level ~(%) serie|(% colspan="1" rowspan="1" %)(((
253 parameter that need to be measured during soil gaz sampling, for security reasons
254
255 SERIES VALUE!!
256 )))|(% 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
257 |(% colspan="1" rowspan="1" %)Soil Gaz sample details - stable|(% colspan="1" rowspan="1" %)H2S (ppm)|(% colspan="1" rowspan="1" %)(((
258 parameter that is also checked during the soil gaz purge.
259
260 STABLE!!
261 )))|(% 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
262 |(% colspan="1" rowspan="1" %)Soil Gaz sample details - series|(% colspan="1" rowspan="1" %)H2S (ppm) serie|(% colspan="1" rowspan="1" %)(((
263 parameter that is also checked during the soil gaz purge.
264
265 SERIES VALUE!!
266 )))|(% 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
267 |(% 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
268 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
269
270 **20-04-2021:**
271
272 |(% 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**
273 |(% 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
274 |(% 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
275 |(% 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
276
277 **06-04-2021**
278
279 (% class="table-hover" %)
280 |(% 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**
281 |(% 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
282 |(% 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
283 |(% 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
284 |(% 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
285 |(% 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
286 |(% 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
287 |(% 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
288 |(% 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
289 |(% 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
290 |(% 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
291 |(% 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
292 |(% 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
293
294 **10-3-2021:**
295
296 (% class="table-hover" %)
297 |(% 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**
298 |(% 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
299
300 **18-1-2021:**
301
302 (% class="table-hover" %)
303 |(% 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**
304 |(% 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
305 |(% 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" %)(((
306 * tblObservations
307 * tblWatersampleMeasurements
308 )))|(% colspan="1" rowspan="1" %)WsSampledVolume/ Old metingcode: 109
309 |(% 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" %)(((
310 * tblObservations
311 * tblWatersampleMeasurements
312 )))|(% colspan="1" rowspan="1" %)WsSamplingMethodTypeCode/ Old metingcode: 110
313 |(% 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" %)(((
314 * tblObservations
315 * tblWatersampleMeasurements
316 )))|(% colspan="1" rowspan="1" %)WsOxygen (Metingcode: 23 / Old metingcode: 12
317 |(% 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" %)(((
318 * tblObservations
319 * tblWatersampleMeasurements
320 )))|(% colspan="1" rowspan="1" %)WsOxygenPercentage/ Old metingcode: 111
321 |(% 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" %)(((
322 * tblObservations
323 * tblWatersampleMeasurements
324 )))|(% colspan="1" rowspan="1" %)METING CODE: 112
325 |(% 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" %)(((
326 * tblObservations
327 * tblWatersampleMeasurements
328 )))|(% colspan="1" rowspan="1" %)WsCarbonDioxine / Old metingcode: 113
329 |(% 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" %)(((
330 * tblObservations
331 * tblWatersampleMeasurements
332 )))|(% colspan="1" rowspan="1" %)METING CODE: 114
333 |(% 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" %)(((
334 * tblObservations
335 * tblWatersampleMeasurements
336 )))|(% colspan="1" rowspan="1" %)WsHumidityPercentage/ Old metingcode: 115
337 |(% 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" %)(((
338 * tblObservations
339 * tblWatersampleMeasurements
340 )))|(% colspan="1" rowspan="1" %)METING CODE: 116
341 |(% 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" %)(((
342 * tblObservations
343 * tblWatersampleMeasurements
344 )))|(% colspan="1" rowspan="1" %)METING CODE: 117
345 |(% 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" %)(((
346 * tblObservations
347 * tblWatersampleMeasurements
348 )))|(% colspan="1" rowspan="1" %)METING CODE: 118
349
350 (% class="table-hover" %)
351 |(% 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**
352 |(% 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
353 |(% 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
354 |(% 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
355 |(% 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
356 |(% 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
357 |(% 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
358 |(% 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
359 |(% 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
360
361 **11-8-2020:**
362
363 (% class="table-hover" %)
364 |(% 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
365 |(% 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
366 Stored in the CIW containers of the site
367 Stored on site awaiting disposal
368 Left on the ground on site
369 Used to fill the borehole|(% colspan="1" rowspan="1" %)256
370 |(% 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
371 Water pumping per level
372 Alternate pumping (Shock)
373 Swabbing and pumping
374 Double air-lift
375 Brushing and pumping
376 Chemical treatment and pumping|(% colspan="1" rowspan="1" %)257
377 |(% 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" %)
378 |(% 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" %)
379 |(% 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" %)
380
381 **27-7-2020:**
382
383 (% class="table-hover" %)
384 |(% 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
385 |(% 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
386 Ground filter prefilter|(% colspan="1" rowspan="1" %)255- Filtering method for the bottle
387 |(% 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" %)-
388
389 **10-7-2020:**
390
391 (% class="table-hover" %)
392 |(% 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
393 |(% 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)
394
395 **20-4-2020:**
396
397 (% class="table-hover" %)
398 |(% 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
399 |(% 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
400 |(% 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
401 |(% 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
402 |(% 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
403 |(% colspan="1" rowspan="1" %)tblMeasurementPoints|(% colspan="1" rowspan="1" %)MpUsedDevices|(% colspan="1" rowspan="1" %)NL: Gebruikte apparaten
404 EN: Used devices|(% colspan="1" rowspan="1" %)tekst edit|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)
405 |(% 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
406 |(% 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
407 |(% 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
408 |(% 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
409 |(% colspan="1" rowspan="1" %)tblLayers|(% colspan="1" rowspan="1" %)LaSampleQualityClassCode|(% colspan="1" rowspan="1" %)Sample quality class/ Monster kwaliteitsklasse|(% colspan="1" rowspan="1" %)11
410 list|(% colspan="1" rowspan="1" %)QM1, QM2, QM3, QM4, QM5|(% colspan="1" rowspan="1" %)245
411 |(% 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
412 |(% colspan="1" rowspan="1" %)tblLayers|(% colspan="1" rowspan="1" %)LaSecondaryBeddingThicknessCode|(% colspan="1" rowspan="1" %)Secundaire Gelaagdheid dikte|(% colspan="1" rowspan="1" %)11
413 list|(% colspan="1" rowspan="1" %)Dun gelamineerd (< 6 mm)
414 Dik gelamineerd (6 tot 20 mm)
415 Zeer dun gelaagd (20 tot 60 mm)
416 Dun gelaagd (60 tot 200 mm)|(% colspan="1" rowspan="1" %)243
417 |(% colspan="1" rowspan="1" %)tblLayers|(% colspan="1" rowspan="1" %)LaSecondaryBeddingGradationCode|(% colspan="1" rowspan="1" %)Secundaire gelaagdheid gradatie|(% colspan="1" rowspan="1" %)11
418 list|(% colspan="1" rowspan="1" %)Veel, Weinig|(% colspan="1" rowspan="1" %)246
419 |(% colspan="1" rowspan="1" %)tblLayers|(% colspan="1" rowspan="1" %)LaDisperseInhomogeneityCode|(% colspan="1" rowspan="1" %)Disperse Inhomogeneity/ Disperse Inhomogeniteit |(% colspan="1" rowspan="1" %)11
420 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
421 |(% colspan="1" rowspan="1" %)tblLayers|(% colspan="1" rowspan="1" %)LaDrillingProgressCode|(% colspan="1" rowspan="1" %)(((
422 DE: bohrfortschritt
423
424 NL: boorvoortgang
425
426 EN: drilling progress
427 )))|(% colspan="1" rowspan="1" %)11
428 list|(% colspan="1" rowspan="1" %)sl - very easy to drill - 1m in 1-10 s.
429 l - easy to drill - 1m in 10-30 s.
430 m - medium difficulty to drill - 1m in 30 - 60 s.
431 sl - difficult to drill - 1m in 1-2 min.
432 ss - very difficult to drill - 1 m in > 2 min.
433 BH - drilling obstacle
434 kBf at ET - No drilling progress at final depth|(% colspan="1" rowspan="1" %)249
435 |(% 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
436 |(% 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
437 |(% 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
438 |(% 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
439 |(% colspan="1" rowspan="1" %)tblObservations (tblWaterSampleMeasurements)|(% colspan="1" rowspan="1" %)NIEUWE OBSERVATION MetingType: 99|(% colspan="1" rowspan="1" %)(((
440 DE: Witterung nach KA5
441
442 NL: Weersomstandigheden
443
444 EN: Weather conditions
445 )))|(% colspan="1" rowspan="1" %)11
446 list|(% colspan="1" rowspan="1" %)WT1
447 WT2
448 WT3
449 WT4
450 WT5
451 WT6|(% colspan="1" rowspan="1" %)251
452 |(% colspan="1" rowspan="1" %)tblObservations (tblWaterSampleMeasurements)|(% colspan="1" rowspan="1" %)NIEUWE OBSERVATION MetingType: 98|(% colspan="1" rowspan="1" %)(((
453 DE: Standardspannung UB (mV)
454
455 NL: Standaardspanning (mV)
456
457 EN: Standard voltage  (mV)
458 )))|(% colspan="1" rowspan="1" %)6 float|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)
459 |(% colspan="1" rowspan="1" %)tblObservations (tblWaterSampleMeasurements)|(% colspan="1" rowspan="1" %)NIEUWE OBSERVATION MetingType: 100|(% colspan="1" rowspan="1" %)(((
460 NL: Grondwaterstand na voorpompen (cm-ref)
461
462 EN: Groundwater level after prepump (cm -ref)
463 )))|(% colspan="1" rowspan="1" %)6 float|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)
464 |(% colspan="1" rowspan="1" %)tblWaterSamples|(% colspan="1" rowspan="1" %)WsUsedDevices|(% colspan="1" rowspan="1" %)NL: Gebruikte apparaten
465 EN: Used devices|(% colspan="1" rowspan="1" %)tekst edit|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)
466 |(% 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" %)
467 |(% 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" %)
468 |(% 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" %)
469 |(% 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" %)
470 |(% 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" %)
471 |(% 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" %)
472 |(% 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" %)
473 |(% colspan="1" rowspan="1" %)tblProjects|(% colspan="1" rowspan="1" %)PrGroundwaterFlowDirection|(% colspan="1" rowspan="1" %)Groundwater Flow Direction (eenheid nakijken!)|(% colspan="1" rowspan="1" %)6
474 float|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)
475 |(% colspan="1" rowspan="1" %)tblProjects|(% colspan="1" rowspan="1" %)PrGroundwaterDepth|(% colspan="1" rowspan="1" %)Groundwater Depth (eenheid nakijken!)|(% colspan="1" rowspan="1" %)6
476 float|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)
477 |(% 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
478 |(% 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
479 |(% 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" %)
480 |(% 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
481 |(% 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" %)
482 |(% 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
483
484 **27 maart 2020:**
485
486 (% class="table-hover" %)
487 |(% colspan="1" rowspan="1" %)tblMeasurementPoint|(% colspan="1" rowspan="1" %)(((
488 MpDescriptionQualityCode
489
490 **String(10)**
491 )))|(% colspan="1" rowspan="1" %)Beschrijfkwaliteit|(% colspan="1" rowspan="1" %)List (11)|(% colspan="1" rowspan="1" %)(((
492 * 1 - B1: Uitgebreide monsterbeschrijving
493 * 2 - B2: Standaard monsterbechrijving
494 * 3 - B3: Verkennende monsterbeschrijving
495 \\Verwijderde waardes:
496 LET OP: Codeid 3 = 1 geworden, en 1 = 3 geworden
497 * 1 - klasse2geroerd
498 * 2 - klasse2ongedifferentieerd
499 * 3 - klasse2ongeroerd
500 * klasse3
501 * nietGespecificeerd
502 )))|(% colspan="1" rowspan="1" %)239
503
504 **18-Dec-2019**
505
506 Additional BRO fields
507
508 (% class="table-hover" %)
509 |=(% colspan="1" rowspan="1" %)(((
510 **Table DSField**
511 )))|=(% colspan="1" rowspan="1" %)(((
512 **Column DSField**
513 )))|=(% colspan="1" rowspan="1" %)(((
514 **Namefield in interface**
515 )))|=(% colspan="1" rowspan="1" %)(((
516 **Input type**
517 )))|=(% colspan="1" rowspan="1" %)(((
518 **Options**
519 )))|=(% colspan="1" rowspan="1" %)(((
520 **Code Category**
521 )))
522 |(% colspan="1" rowspan="1" %)tblMeasurementPoint|(% colspan="1" rowspan="1" %)(((
523 MpVerticalPositioningMethodCode
524
525 **String(10)**
526 )))|(% colspan="1" rowspan="1" %)Precisie hoogte|(% colspan="1" rowspan="1" %)List (11)|(% colspan="1" rowspan="1" %)(((
527 * RTKGPS0tot4cm
528 * RTKGPS4tot10cm
529 * RTKGPS10tot20cm
530 * RTKGPS20tot100cm
531 * tachymetrie0tot10cm
532 * tachymetrie10tot50cm
533 * waterpassing0tot2cm
534 * waterpassing4tot10cm
535 * waterpassing2tot4cm
536 )))|(% colspan="1" rowspan="1" %)235
537 |(% colspan="1" rowspan="1" %)tblMeasurementPoint|(% colspan="1" rowspan="1" %)(((
538 MpStopCriterionCode
539
540 **String(10)**
541 )))|(% colspan="1" rowspan="1" %)Reden boring gestopt|(% colspan="1" rowspan="1" %)(((
542 List (11)
543
544
545 )))|(% colspan="1" rowspan="1" %)(((
546 * beperkingTechnisch
547 * einddoel
548 * obstakelConstructie
549 * obstakelGrindStenen
550 * obstakelIJzervloer
551 * obstakelOnbekend
552 * obstakelPuin
553 * obstakelVastGesteente
554 * risico
555 * risicoGrondwaterdruk
556 * storingOrganisatorisch
557 * storingTechnisch
558 * werkwaterverlies
559 * onbekend
560 )))|(% colspan="1" rowspan="1" %)236
561 |(% colspan="1" rowspan="1" %)tblJars|(% colspan="1" rowspan="1" %)(((
562 JrSamplingQualityCode
563
564 **String(10)**
565 )))|(% colspan="1" rowspan="1" %)Bemonsteringskwaliteit|(% colspan="1" rowspan="1" %)List (11)|(% colspan="1" rowspan="1" %)(((
566 * klasseA
567 * klasseB
568 * klasseC
569 * klasseD
570 * klasseE
571 )))|(% colspan="1" rowspan="1" %)237
572 |(% colspan="1" rowspan="1" %)tblJars|(% colspan="1" rowspan="1" %)(((
573 JrMethodCode
574
575 **String(10)**
576 )))|(% colspan="1" rowspan="1" %)Bemonsteringsmethode|(% colspan="1" rowspan="1" %)List (11)|(% colspan="1" rowspan="1" %)(((
577 * graven
578 * opAfstandDroog
579 * opAfstandNat
580 * opDiepteGrijpen
581 * opDiepteKernen
582 * opDiepteLosroeren
583 * opDiepteUitsteken
584 * drukken
585 * hammeren
586 )))|(% colspan="1" rowspan="1" %)(((
587 **125 / Old: 40**
588
589
590 )))
591 |(% colspan="1" rowspan="1" %)tblMeasurementPoint|(% colspan="1" rowspan="1" %)(((
592 MpDescriptionQualityCode
593
594 **String(10)**
595 )))|(% colspan="1" rowspan="1" %)Beschrijfkwaliteit|(% colspan="1" rowspan="1" %)List (11)|(% colspan="1" rowspan="1" %)(((
596 * klasse2geroerd
597 * klasse2ongedifferentieerd
598 * klasse2ongeroerd
599 * klasse3
600 * nietGespecificeerd
601 )))|(% colspan="1" rowspan="1" %)239
602 |(% colspan="1" rowspan="1" %)tblMeasurementPoint|(% colspan="1" rowspan="1" %)(((
603 MpContinuouslySampledCode
604
605 **String(10)**
606 )))|(% colspan="1" rowspan="1" %)Continu bemonsterd|(% colspan="1" rowspan="1" %)List (11)|(% colspan="1" rowspan="1" %)(((
607 * Ja
608 * Nee
609 )))|(% colspan="1" rowspan="1" %)**73 / OLD: 26**
610 |(% colspan="1" rowspan="1" %)tblMeasurementPoint|(% colspan="1" rowspan="1" %)(((
611 MpDescriptionLocationCode
612
613 **String(10)**
614 )))|(% colspan="1" rowspan="1" %)Beschrijflocatie|(% colspan="1" rowspan="1" %)List (11)|(% colspan="1" rowspan="1" %)(((
615 * lab
616 * veld
617 * veldlab
618 * onbekend
619 )))|(% colspan="1" rowspan="1" %)240
620 |(% colspan="1" rowspan="1" %)tblMeasurementPoint|(% colspan="1" rowspan="1" %)(((
621 MpDescribedMaterialCode
622
623 **String(10)**
624 )))|(% colspan="1" rowspan="1" %)Beschreven materiaal|(% colspan="1" rowspan="1" %)List (11)|(% colspan="1" rowspan="1" %)(((
625 * grond
626 * grondGesteente
627 * gesteente
628 )))|(% colspan="1" rowspan="1" %)241
629 |(% colspan="1" rowspan="1" %)tblLayers|(% colspan="1" rowspan="1" %)(((
630 LaUpperBoundaryDeterminationCode
631
632 **String(10)**
633 )))|(% colspan="1" rowspan="1" %)Laagovergang bovenkant|(% colspan="1" rowspan="1" %)List (11)|(% colspan="1" rowspan="1" %)(((
634 * afgeleid
635 * afgeleidSondering
636 * voorbepaald
637 * waargenomenScherp
638 * waargenomenGeleidelijk
639 * waargenomenDiffuus
640 * waargenomenWillekeurig
641 )))|(% colspan="1" rowspan="1" %)242
642 |(% colspan="1" rowspan="1" %)tblLayers|(% colspan="1" rowspan="1" %)(((
643 LaLowerBoundaryDeterminationCode
644
645 **String(10)**
646 )))|(% colspan="1" rowspan="1" %)Laagovergang onderkant|(% colspan="1" rowspan="1" %)List (11)|(% colspan="1" rowspan="1" %)(((
647 * afgeleid
648 * afgeleidSondering
649 * voorbepaald
650 * waargenomenScherp
651 * waargenomenGeleidelijk
652 * waargenomenDiffuus
653 * waargenomenWillekeurig
654 )))|(% colspan="1" rowspan="1" %)242
655 |(% colspan="1" rowspan="1" %)tblLayers|(% colspan="1" rowspan="1" %)(((
656 LaAnthropogenicCode
657
658 **String(10)**
659 )))|(% colspan="1" rowspan="1" %)Antropogeen|(% colspan="1" rowspan="1" %)List (11)|(% colspan="1" rowspan="1" %)(((
660 * Ja
661 * Nee
662 )))|(% colspan="1" rowspan="1" %)**73 / OLD: 26**
663 |(% colspan="1" rowspan="1" %)tblLayers|(% colspan="1" rowspan="1" %)(((
664 LaBeddingCode
665
666 **String(10)**
667 )))|(% colspan="1" rowspan="1" %)Gelaagdheid|(% colspan="1" rowspan="1" %)List (11)|(% colspan="1" rowspan="1" %)(((
668 * dunGelamineerd
669 * dikGelamineerd
670 * ergDunGelaagd
671 * dunGelaagd
672 * mmGelaagd
673 * cmGelaagd
674 * dmGelaagd
675 )))|(% colspan="1" rowspan="1" %)243
676 |(% colspan="1" rowspan="1" %)tblLayers|(% colspan="1" rowspan="1" %)(((
677 LaIsRootedCode
678
679 **String(10)**
680 )))|(% colspan="1" rowspan="1" %)Beworteld|(% colspan="1" rowspan="1" %)List (11)|(% colspan="1" rowspan="1" %)(((
681 * Ja
682 * Nee
683 )))|(% colspan="1" rowspan="1" %)**73 / OLD: 26**
684 |(% colspan="1" rowspan="1" %)tblMeasurementPoint|(% colspan="1" rowspan="1" %)(((
685 MpCoordinatesTimestamp
686
687 **DateTime**
688 )))|(% colspan="1" rowspan="1" %)Datum locatiebepaling|(% colspan="1" rowspan="1" %)DateTimeEditor (13)|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)
689 |(% colspan="1" rowspan="1" %)tblMeasurementPoint|(% colspan="1" rowspan="1" %)(((
690 MpBroID
691
692 **Varchar(50)**
693 )))|(% colspan="1" rowspan="1" %)BRO-ID|(% colspan="1" rowspan="1" %)textEditor (1)|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)(((
694
695
696
697 )))
698 |(% colspan="1" rowspan="1" %)tblLayers|(% colspan="1" rowspan="1" %)(((
699 LaTensileStrengthCode
700
701 **String(10)**
702 )))|(% colspan="1" rowspan="1" %)Treksterkte|(% colspan="1" rowspan="1" %)Lijst (11)|(% colspan="1" rowspan="1" %)(((
703 * Geen sterkte
704 * Laag
705 * Matig
706 * Hoog
707 )))|(% colspan="1" rowspan="1" %)244
708
709 **05-Aug-2019**
710
711 Additional **ISO14688** fields
712
713 (% class="table-hover" %)
714 |=(% colspan="1" rowspan="1" %)(((
715 **Table DSField**
716 )))|=(% colspan="1" rowspan="1" %)(((
717 **Column DSField**
718 )))|=(% colspan="1" rowspan="1" %)(((
719 **Namefield in interface**
720 )))|=(% colspan="1" rowspan="1" %)(((
721 **Input type**
722 )))|=(% colspan="1" rowspan="1" %)(((
723 **Options**
724 )))|=(% colspan="1" rowspan="1" %)(((
725 **Code Category**
726 )))
727
728 (% class="table-hover" %)
729 |=(% colspan="1" rowspan="1" %)(((
730 **Table DSField**
731 )))|=(% colspan="1" rowspan="1" %)(((
732 **Column DSField**
733 )))|=(% colspan="1" rowspan="1" %)(((
734 **Namefield in interface**
735 )))|=(% colspan="1" rowspan="1" %)(((
736 **Input type**
737 )))|=(% colspan="1" rowspan="1" %)(((
738 **Options**
739 )))|=(% colspan="1" rowspan="1" %)(((
740 **Code Category**
741 )))
742 |(% colspan="1" rowspan="1" %)tblLayers|(% colspan="1" rowspan="1" %)(((
743 LaTextureTertiaryCode
744
745 **String(10)**
746 )))|(% colspan="1" rowspan="1" %)Tertiar|(% colspan="1" rowspan="1" %)List (11)|(% colspan="1" rowspan="1" %)(((
747 * Schelpfracties
748 * Glauconietkorrels
749 * IJzersulfiden
750 * Plantenresten
751 * Wortelresten
752 * Kalkhoudende concreties
753 )))|(% colspan="1" rowspan="1" %)226
754 |(% colspan="1" rowspan="1" %)tblLayers|(% colspan="1" rowspan="1" %)(((
755 LaTexturePlasticityCode
756
757 **String(10)**
758 )))|(% colspan="1" rowspan="1" %)Plasticiteit|(% colspan="1" rowspan="1" %)List (11)|(% colspan="1" rowspan="1" %)(((
759 * Niet
760 * Weinig
761 * Matig
762 * Sterk
763 )))|(% colspan="1" rowspan="1" %)227
764 |(% colspan="1" rowspan="1" %)tblLayers|(% colspan="1" rowspan="1" %)(((
765 LaTextureGrainShapeCode
766
767 **String(10)**
768 )))|(% colspan="1" rowspan="1" %)Korrelvorm|(% colspan="1" rowspan="1" %)List (11)|(% colspan="1" rowspan="1" %)(((
769 * Zeer Hoekig
770 * Hoekig
771 * Subhoekig
772 * Subrond
773 * Afgerond
774 * Zeer afgerond
775 )))|(% colspan="1" rowspan="1" %)228
776 |(% colspan="1" rowspan="1" %)tblLayers|(% colspan="1" rowspan="1" %)(((
777 LaTextureFormCode
778
779 **String(10)**
780 )))|(% colspan="1" rowspan="1" %)Vorm|(% colspan="1" rowspan="1" %)List (11)|(% colspan="1" rowspan="1" %)(((
781 * Bol
782 * Plat
783 * Langwerpig
784 )))|(% colspan="1" rowspan="1" %)229
785 |(% colspan="1" rowspan="1" %)tblLayers|(% colspan="1" rowspan="1" %)(((
786 LaTextureSurfaceCode
787
788 **String(10)**
789 )))|(% colspan="1" rowspan="1" %)Oppervlakte|(% colspan="1" rowspan="1" %)List (11)|(% colspan="1" rowspan="1" %)(((
790 * Ruw
791 * Glad
792 )))|(% colspan="1" rowspan="1" %)230
793 |(% colspan="1" rowspan="1" %)tblLayers|(% colspan="1" rowspan="1" %)(((
794 LaTextureParticleStrengthCode
795
796 **String(10)**
797 )))|(% colspan="1" rowspan="1" %)Deeltjes Sterkte|(% colspan="1" rowspan="1" %)List (11)|(% colspan="1" rowspan="1" %)(((
798 * Extreem zwawk
799 * Zeer zwak
800 * Zwak
801 * Matig zwak
802 * Gemiddeld sterk
803 * Sterk
804 * Zeer sterk
805 * Extreem sterk
806 )))|(% colspan="1" rowspan="1" %)231
807 |(% colspan="1" rowspan="1" %)tblLayers|(% colspan="1" rowspan="1" %)(((
808 LaRockShapeCode
809
810 **String(10)**
811 )))|(% colspan="1" rowspan="1" %)Steenvorm|(% colspan="1" rowspan="1" %)List (11)|(% colspan="1" rowspan="1" %)(((
812 * Molenstenen
813 * Schaalachtig
814 * Blokken
815 )))|(% colspan="1" rowspan="1" %)232
816 |(% colspan="1" rowspan="1" %)tblLayers|(% colspan="1" rowspan="1" %)(((
817 LaRockWeatheringCode
818
819 **String(10)**
820 )))|(% colspan="1" rowspan="1" %)Steen Verwering|(% colspan="1" rowspan="1" %)List (11)|(% colspan="1" rowspan="1" %)(((
821 * Veranderde
822 * Gebarsten
823 * Fractured
824 * Gemalen
825 )))|(% colspan="1" rowspan="1" %)233
826
827
828 )))
829
830
831 (% class="col-xs-12 col-sm-4" %)
832 (((
833 {{box title="**Contents**"}}
834 {{toc/}}
835 {{/box}}
836 )))
837 )))

Navigation

TerraIndex
asd