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

Navigation

TerraIndex
asd