Skip to Content
Last modified by Robert Jan Daams on 2025/02/04 11:52
From version 20.1
edited by Richard Dyer
on 2022/04/14 15:55
Change comment: There is no comment for this version
To version 5.2
edited by Roelof Zwaan
on 2021/11/22 10:25
Change comment: There is no comment for this version

Summary

Details

Page properties
Parent
... ... @@ -1,1 +1,1 @@
1 -Implementation documentation.WebHome
1 +Implementatie dcoumentatie.WebHome
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.RichardDyer
1 +XWiki.RoelofZwaan
Content
... ... @@ -10,9 +10,9 @@
10 10  
11 11  **[[Field database description>>attach:20150224 Field Database Description (3).docx]]**
12 12  
13 -[[(% class="wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink" %)**dsFieldproject format XSD file**>>attach:dsFieldProject.xsd]]
13 +[[(% class="wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink" %)**dsFieldproject format XSD file**>>attach:dsFieldProject.xsd]]
14 14  
15 -[[(% class="wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink" %)**Codelookup excel list**>>attach:20200619 Codelookup.xlsx]]
15 +[[(% class="wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink" %)**Codelookup excel list**>>attach:20200619 Codelookup.xlsx]]
16 16  )))
17 17  )))
18 18  
... ... @@ -93,124 +93,6 @@
93 93  
94 94  == Changes and updates: ==
95 95  
96 -
97 -
98 -|(% rowspan="4" %)**Labeltext in English**|(% rowspan="4" %)**Remarks**|(% rowspan="4" %)**Definition and process how this field will be used and when it will be filled.**|(% rowspan="4" %)**Change/Add/Delete**|(% rowspan="4" %)**DB Type (String (length) / Float / Lookupvalue / Integer / DateTime)**|(% rowspan="4" %)**DBTable in dsFieldProject**|(% rowspan="4" %)**DBFieldname in dsFieldProject**
99 -|
100 -|
101 -|
102 -|Smoketube test|CodeID: 157|A test done to determine wether no air is escaping the suction system of the filtration unit. This is important because if this is the case, dangerous gases might escape and affect the health of people nearby|Add|Lookupvalue|tblObservations|METINGCODE 157
103 -|Discontinuity cause| |This describes the cause of a discontinuity among rock layers for a rock classification. This is not a description of the discontinuity, merely how it came to exist|Add|Lookupvalue|tblLayers|LaDiscontinuityCauseCode
104 -|BroID| |Field for the BroID at filltertube level|Add|Varchar(50)|tblFilterTubes|BroID
105 -|Weight fine fraction (kg)| |This concerns the weight of the sieved fraction, which is distinct from the coarse fraction|Add|Float|tblJars|JrWeightFractionFine
106 -|Determination method of moisture| |Describes how the soil was kept at a safe mositure level to work with asbestos|Add|Codelist|tblLayers|LaFieldworkMoistureMethodCode
107 -|Type of asbestos containing material| |Describes how the soil was kept at a safe mositure level to work with asbestos|Add|Codelist|tblJars|JrPlateMaterialTypeCode
108 -|Thickness asbestos containing material (mm)| |Thickness of the plate material in mm, needed to make the distinction of types of plate material|Add|Float|tblJars|JrPlateMaterialThickness
109 -|Recommended prepump volume|CodeID: 158|Needed to register for french users|Add|Float|tblObservations|METINGCODE 158
110 -|Tube flushing volume|CodeID: 159|Needed to register for french users|Add|Float|tblObservations|METINGCODE 159
111 -|Filtertube leaktest| |Wether or not a leaking test was performed on the filtertube (for air sampling)|Add|codelist (Yes / no)|tblFilterTubes|FtLeakingtestCode
112 -|Presence of water|CodeID: 160|Check to see whetherthe tube is dry when sampling an air sample|Add|codelist (Yes / no)|tblObservations|METINGCODE 160
113 -|Grondwaterstand aangetroffen?| |Veld om aan te geven dat de grondwaterstand niet is bereikt bij deze boring|Add|codelist (Yes / no)|tblMeasurementPoints|MpGWSFoundCode
114 -|Benzene PID|CodeID: 156|Arcadis nederland wil dit graag...|Add|float|tblObservations|METINGCODE 156
115 -|Lager explosief gehalte (vol %)|CodeID: 155|Arcadis nederland wil dit graag...|Add|float|tblObservations|METINGCODE 155
116 -|Number of soil grabs| |Aantal grepen veld voor partijkeuring|Add|Integer|tblMeasurementpoints|MpGrabNumber
117 -|Koolstofdioxine/CO2 ppm|(((
118 -New label
119 -
120 -CO2 (ppm)
121 -)))|CHANGE LABEL|Change|Float|tblObservations|METING CODE: 113
122 -|Koolstofdioxine/CO2 einde monstername (ppm)|(((
123 -New label
124 -
125 -CO2 (ppm) einde monstername
126 -)))|CHANGE LABEL|Change|Float|tblObservations|METING CODE: 113
127 -|Weight debris (kg)|(((
128 -new label
129 -
130 -english:
131 -
132 -Total sample weight (kg)
133 -
134 -dutch:
135 -
136 -Totaal gewicht monster (kg)
137 -)))|Change label to conform norm|Change|Float|tblJars|JrWeightDebris
138 -|Pieces of Asbestos|(((
139 -new label
140 -
141 -english:
142 -
143 -Pieces of asbestos-containing material
144 -
145 -
146 -dutch:
147 -
148 -Aantal stukjes asbestverdacht materiaal
149 -
150 -
151 -
152 -)))|Change label to conform norm|Change|Integer |tblJars|JrNoPiecesAsbestos
153 -|Weight asbestos|(((
154 -new label
155 -
156 -english:
157 -
158 -Weight asbestos-containing material
159 -
160 -
161 -dutch:
162 -
163 -Gewicht asbestverdacht materiaal
164 -)))|Change label to conform norm|Change|Float|tblJars|JrWeightAsbestos
165 -|Weight sample (kg)|(((
166 -new label
167 -
168 -english:
169 -
170 -Weight coarse fraction (kg)
171 -
172 -dutch:
173 -
174 -Gewicht grove fractie (kg)
175 -)))|Change label to make it more clear that it concerns the total weight of the sample|Change|Float|tblJars|JrWeightSample
176 -
177 -== Changes and updates: ==
178 -
179 -**27-01-2022:**
180 -
181 -|**Labeltext in English**|**Remarks**|**Definition and process how this field will be used and when it will be filled.**|(((
182 -**Change/Add/**
183 -
184 -**Delete**
185 -)))|**DB Type
186 -(String (length) / Float / Lookupvalue / Integer / DateTime)**|**DBTable in dsFieldProject**|**DBFieldname in dsFieldProject**
187 -|Use of location| |To add the current use of the location to a measurement point|Add|Lookupvalue|tblMeasurementPoints|MpLocationUsageCode
188 -|Type|New codelist optios added |-|Change|Lookupvalue|tblMeasurementPoint|MpType
189 -|Interior location| |Yes / no field for if the sample is an interior location|Add|Lookupvalue|tblMeasurementPoints|MpIsIndoorsCode
190 -|FlowTypesSurfaceWater| |Describes the flowing pattern of the surface water sampling location|Add|Lookupvalue|tblObservations|METINGCODE 148
191 -|Location flow rate| |The flow rate of the sampling location|Add|Lookupvalue|tblObservations|METINGCODE 149
192 -|Special conditions| |Remark field for special sampling conditions to print in report|Add|String|tblWatersamples|JrStreamlineGUID
193 -|Pump type|Codelist used for several fields|New options added to codelist|Change|Lookupvalue|Multiple fields|Multiple fields
194 -|Pump connection| |Field for the power connection of a pump|Add|LookupValue|tblObservations|METINGCODE 150
195 -|Matrix| |Added codelist options|Change|Lookupvalue|tblWatersamples|WsMatrix
196 -|Mesh size (mm)| |Field for the mesh size of a monitoring well filter|Add|Float|tblFiltertubes|FtMeshSize
197 -|Type|Project level|New codelist options|Change|Lookupvalue|tblProjects|PrType
198 -|Type|Finishing level|New codelist options|Change|Lookupvalue|tblFinishings|FiType
199 -|Measurement duration| |Field for the duration of a series of a measurements, mostly used to estimate the time when a tube is dry|Add|Float|tblObservations|METINGCODE 154 (Series), METINGCODE 153 (Stable value)
200 -|Pumped volume series| |Field for the total pumped volume during a single series|Add|Float|tblObservations|METINGCODE 152 (Series), METINGCODE 151 (Stable value)
201 -
202 -**22-11-2021:**
203 -
204 -|**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**
205 -| | | | | | | | | |
206 -|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
207 -|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
208 -|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
209 -|Water samples|Surrounding humidity|Omgevingsvochtigheid|Licht vochtig, Zeer vochtig, Vochtig op bodem, Vochtig op plaatsen|The circumstances when sampling| |Add|Codelist|(((
210 -* tblObservations
211 -* tblWatersampleMeasurements
212 -)))|Metingcode: 147 / WsSurroundingHumidity
213 -
214 214  **18-10-2021:**
215 215  
216 216  (% class="table-hover" style="height:1452px; width:1050px" %)
... ... @@ -282,6 +282,7 @@
282 282  |(% 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
283 283  |(% 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
284 284  
167 +
285 285  **6-8-2021:**
286 286  
287 287  (% class="table-hover" %)
... ... @@ -293,6 +293,7 @@
293 293  |(% 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
294 294  |(% 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
295 295  
179 +
296 296  **1-6-2021:**
297 297  
298 298  (% class="table-hover" %)
... ... @@ -348,6 +348,7 @@
348 348  |(% 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
349 349  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
350 350  
235 +
351 351  **20-04-2021:**
352 352  
353 353  |(% 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**
... ... @@ -372,6 +372,7 @@
372 372  |(% 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
373 373  |(% 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
374 374  
260 +
375 375  **10-3-2021:**
376 376  
377 377  (% class="table-hover" %)
... ... @@ -428,6 +428,7 @@
428 428  * tblWatersampleMeasurements
429 429  )))|(% colspan="1" rowspan="1" %)METING CODE: 118
430 430  
317 +
431 431  (% class="table-hover" %)
432 432  |(% 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**
433 433  |(% 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
... ... @@ -439,6 +439,7 @@
439 439  |(% 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
440 440  |(% 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
441 441  
329 +
442 442  **11-8-2020:**
443 443  
444 444  (% class="table-hover" %)
... ... @@ -467,6 +467,7 @@
467 467  Ground filter prefilter|(% colspan="1" rowspan="1" %)255- Filtering method for the bottle
468 468  |(% 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" %)-
469 469  
358 +
470 470  **10-7-2020:**
471 471  
472 472  (% class="table-hover" %)
... ... @@ -787,6 +787,7 @@
787 787  * Hoog
788 788  )))|(% colspan="1" rowspan="1" %)244
789 789  
679 +
790 790  **05-Aug-2019**
791 791  
792 792  Additional **ISO14688** fields
20150224 Field Database Description (3).docx
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.RichardDyer
1 +XWiki.RoelofZwaan
Size
... ... @@ -1,1 +1,1 @@
1 -172.8 KB
1 +170.1 KB
Content
20200619 Codelookup.xlsx
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.RichardDyer
1 +XWiki.RoelofZwaan
Size
... ... @@ -1,1 +1,1 @@
1 -1649622
1 +1647316
Content
20220414 Codelookup.xlsx
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.RichardDyer
Size
... ... @@ -1,1 +1,0 @@
1 -1.6 MB
Content
dsFieldProject.cs
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.RichardDyer
Size
... ... @@ -1,1 +1,0 @@
1 -374 bytes
Content
... ... @@ -1,24 +1,0 @@
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 -
dsFieldProject.xsd
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.RichardDyer
1 +XWiki.RoelofZwaan
Size
... ... @@ -1,1 +1,1 @@
1 -447.8 KB
1 +441.5 KB
Content
dsTerraIndex1.0.xsd
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.RichardDyer
Size
... ... @@ -1,1 +1,0 @@
1 -1.9 MB
Content