Skip to Content
Last modified by Robert Jan Daams on 2025/02/04 11:52
From version 4.1
edited by Roelof Zwaan
on 2021/11/22 10:16
Change comment: Uploaded new attachment "20200619 Codelookup.xlsx", version {1}
To version 11.2
edited by Richard Dyer
on 2021/11/23 11:40
Change comment: Update document after refactoring.

Summary

Details

Page properties
Title
... ... @@ -1,0 +1,1 @@
1 +Documentation TerraIndex Export format - dsFieldProject.xsd
Parent
... ... @@ -1,0 +1,1 @@
1 +Implementation documentation.WebHome
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.RoelofZwaan
1 +XWiki.RichardDyer
Content
... ... @@ -1,0 +1,812 @@
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 +)))
20150224 Field Database Description (3).docx
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.RoelofZwaan
1 +XWiki.RichardDyer
Size
... ... @@ -1,1 +1,1 @@
1 -170.1 KB
1 +170.3 KB
Content
20200619 Codelookup.xlsx
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.RoelofZwaan
1 +XWiki.RichardDyer
Size
... ... @@ -1,1 +1,1 @@
1 -1647316
1 +1649622
Content
1637572655588-407.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.RoelofZwaan
Size
... ... @@ -1,0 +1,1 @@
1 +815.3 KB
Content
dsFieldProject.cs
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.RichardDyer
Size
... ... @@ -1,0 +1,1 @@
1 +374 bytes
Content
... ... @@ -1,0 +1,24 @@
1 +namespace ITWorks.Types.Datasets
2 +{
3 +
4 +
5 + partial class dsFieldProject
6 + {
7 + partial class tblBottlesDataTable
8 + {
9 + }
10 +
11 + partial class tblMeasurementPointsDataTable
12 + {
13 + }
14 +
15 + partial class tblLabassignmentsDataTable
16 + {
17 + }
18 +
19 + partial class tblWaterSamplesDataTable
20 + {
21 + }
22 + }
23 +}
24 +
dsTerraIndex1.0.xsd
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.RichardDyer
Size
... ... @@ -1,0 +1,1 @@
1 +1.9 MB
Content
image1.jpg
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.RoelofZwaan
Size
... ... @@ -1,0 +1,1 @@
1 +43.8 KB
Content
image2.jpg
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.RoelofZwaan
Size
... ... @@ -1,0 +1,1 @@
1 +40.0 KB
Content