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

Navigation

TerraIndex
asd