Skip to Content
Last modified by Robert Jan Daams on 2025/02/04 11:52
From version 12.3
edited by Richard Dyer
on 2022/04/14 11:41
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" %)**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" %)**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,43 +93,6 @@
93 93  
94 94  == Changes and updates: ==
95 95  
96 -== Changes and updates: ==
97 -
98 -**27-01-2022:**
99 -
100 -|**Labeltext in English**|**Remarks**|**Definition and process how this field will be used and when it will be filled.**|(((
101 -**Change/Add/**
102 -
103 -**Delete**
104 -)))|**DB Type
105 -(String (length) / Float / Lookupvalue / Integer / DateTime)**|**DBTable in dsFieldProject**|**DBFieldname in dsFieldProject**
106 -|Use of location| |To add the current use of the location to a measurement point|Add|Lookupvalue|tblMeasurementPoints|MpLocationUsageCode
107 -|Type|New codelist optios added |-|Change|Lookupvalue|tblMeasurementPoint|MpType
108 -|Interior location| |Yes / no field for if the sample is an interior location|Add|Lookupvalue|tblMeasurementPoints|MpIsIndoorsCode
109 -|FlowTypesSurfaceWater| |Describes the flowing pattern of the surface water sampling location|Add|Lookupvalue|tblObservations|METINGCODE 148
110 -|Location flow rate| |The flow rate of the sampling location|Add|Lookupvalue|tblObservations|METINGCODE 149
111 -|Special conditions| |Remark field for special sampling conditions to print in report|Add|String|tblWatersamples|JrStreamlineGUID
112 -|Pump type|Codelist used for several fields|New options added to codelist|Change|Lookupvalue|Multiple fields|Multiple fields
113 -|Pump connection| |Field for the power connection of a pump|Add|LookupValue|tblObservations|METINGCODE 150
114 -|Matrix| |Added codelist options|Change|Lookupvalue|tblWatersamples|WsMatrix
115 -|Mesh size (mm)| |Field for the mesh size of a monitoring well filter|Add|Float|tblFiltertubes|FtMeshSize
116 -|Type|Project level|New codelist options|Change|Lookupvalue|tblProjects|PrType
117 -|Type|Finishing level|New codelist options|Change|Lookupvalue|tblFinishings|FiType
118 -|Measurement duration| |Field for the duration of a series of a measurements, mostly used to estimate the time when a tube is dry|Add|Float|tblObservations|METINGCODE 154 (Series), METINGCODE 153 (Stable value)
119 -|Pumped volume series| |Field for the total pumped volume during a single series|Add|Float|tblObservations|METINGCODE 152 (Series), METINGCODE 151 (Stable value)
120 -
121 -**22-11-2021:**
122 -
123 -|**Screen to add the extra field**|**Labeltext of field in English**|**Labeltext in Dutch**|**Examples of values and how it should be printed in a report.**|**Definition and process how this field will be used and when it will be filled.**|**Codelist CategoryID**|**Change/Add/Delete**|**DB Type**|**DBTable in dsFieldProject**|**DBFieldname in dsFieldProject**
124 -| | | | | | | | | |
125 -|Soil samples|Length core sampler|Lengte steekbuis (mm)|Length core sampler (mm)|The length of a core sampler may vary and defines volume| |Add|Integer|tblJars|JrLengthCoreSampler
126 -|Measurement Point|Diameter|Diameter (mm)|Diameter (mm)|(% colspan="2" %)Information is available on layer level, but may sometimes be consistent over the entire measurement point|Add|Integer|tblMeasurementPoints|MpDiameter
127 -|Air Samples packaging|Placed in serie|In serie geplaatst|Yes/no|Two packages for air samples can be placed in serie or not| |Add|Lookupvalue (Yes/No)|tblBottles|BoPlacedInSerie
128 -|Water samples|Surrounding humidity|Omgevingsvochtigheid|Licht vochtig, Zeer vochtig, Vochtig op bodem, Vochtig op plaatsen|The circumstances when sampling| |Add|Codelist|(((
129 -* tblObservations
130 -* tblWatersampleMeasurements
131 -)))|Metingcode: 147 / WsSurroundingHumidity
132 -
133 133  **18-10-2021:**
134 134  
135 135  (% class="table-hover" style="height:1452px; width:1050px" %)
... ... @@ -201,6 +201,7 @@
201 201  |(% colspan="1" rowspan="1" %)Air samples Packaging|(% colspan="1" rowspan="1" %)Sample type|(% colspan="1" rowspan="1" %)Monstertype|(% colspan="1" rowspan="1" %)regular sample/transport blind/environment blind|(% colspan="1" rowspan="1" %)To select the type of support used in the sampling process|(% colspan="1" rowspan="1" %)Add Field|(% colspan="1" rowspan="1" %)lookupvalue|(% colspan="1" rowspan="1" %)tblBottles|(% colspan="1" rowspan="1" %)BoSampleTypeCode
202 202  |(% colspan="1" rowspan="1" %)Air samples Packaging|(% colspan="1" rowspan="1" %)Reference number|(% colspan="1" rowspan="1" %)Referentienummer|(% colspan="1" rowspan="1" %)088D235D123|(% colspan="1" rowspan="1" %)As secundary to barcode. Supports have both a barcode and a reference|(% colspan="1" rowspan="1" %)Add Field|(% colspan="1" rowspan="1" %)string (10)|(% colspan="1" rowspan="1" %)tblBottles|(% colspan="1" rowspan="1" %)BoReferenceNumber
203 203  
167 +
204 204  **6-8-2021:**
205 205  
206 206  (% class="table-hover" %)
... ... @@ -212,6 +212,7 @@
212 212  |(% colspan="1" rowspan="1" %)Watersample details|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)reden pompen beeindigd|(% colspan="1" rowspan="1" %)518 (categoryID: 200)|(% colspan="1" rowspan="1" %)Add Codelist item,|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)peilbuis is droog
213 213  |(% colspan="1" rowspan="1" %)Meetpunt details|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)reden boring gestopt|(% colspan="1" rowspan="1" %)236 (categoryID: 236)|(% colspan="1" rowspan="1" %)Add Codelist item|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)water aangetroffen
214 214  
179 +
215 215  **1-6-2021:**
216 216  
217 217  (% class="table-hover" %)
... ... @@ -267,6 +267,7 @@
267 267  |(% colspan="1" rowspan="1" %)Water Sample - series|(% colspan="1" rowspan="1" %)Turbidity serie|(% colspan="1" rowspan="1" %)In France , Spain (and Germany)  they don't use NTU to describe turbidity but appreciations
268 268  The same appreciations that already exist for the feld "turbidiy" from Watersample should also exist for the series|(% colspan="1" rowspan="1" %)252|(% colspan="1" rowspan="1" %)add|(% colspan="1" rowspan="1" %)Helderheid reeks|(% colspan="1" rowspan="1" %)Codelist|(% colspan="1" rowspan="1" %)String (10)|(% colspan="1" rowspan="1" %)METINGCODE|(% colspan="1" rowspan="1" %)METINGCODE
269 269  
235 +
270 270  **20-04-2021:**
271 271  
272 272  |(% colspan="1" rowspan="1" %)**Change/Add/Delete**|(% colspan="1" rowspan="1" %)**Remarks, Questions with answers and feedback of the status and the field info.**|(% colspan="1" rowspan="1" %)**Labeltext in Dutch**|(% colspan="1" rowspan="1" %)**CategoryID**|(% colspan="1" rowspan="1" %)**Input type**|(% colspan="1" rowspan="1" %)**DB Type**|(% colspan="1" rowspan="1" %)**(String (length) / Float / Lookupvalue / Integer / DateTime)**|(% colspan="1" rowspan="1" %)**tblObservations/**|(% colspan="1" rowspan="1" %)**DBFieldname in dsFieldProject**
... ... @@ -291,6 +291,7 @@
291 291  |(% colspan="1" rowspan="1" %)Add|(% colspan="1" rowspan="1" %)The weatherconditions during the visit to the location|(% colspan="1" rowspan="1" %)Weersomstandigheden|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)Text input|(% colspan="2" rowspan="1" %)String(2000)|(% colspan="1" rowspan="1" %)tblLocationVisits|(% colspan="1" rowspan="1" %)LvWeatherConditionsDescription
292 292  |(% colspan="1" rowspan="1" %)Add|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)nvt|(% colspan="2" rowspan="1" %)datetime|(% colspan="1" rowspan="1" %)tblLocationVisits|(% colspan="1" rowspan="1" %)LvDateLastChanged
293 293  
260 +
294 294  **10-3-2021:**
295 295  
296 296  (% class="table-hover" %)
... ... @@ -347,6 +347,7 @@
347 347  * tblWatersampleMeasurements
348 348  )))|(% colspan="1" rowspan="1" %)METING CODE: 118
349 349  
317 +
350 350  (% class="table-hover" %)
351 351  |(% colspan="1" rowspan="1" %)**Change/Add/Delete**|(% colspan="1" rowspan="1" %)**Remarks, Questions with answers and feedback of the status and the field info.**|(% colspan="1" rowspan="1" %)**Labeltext in Dutch**|(% colspan="1" rowspan="1" %)**CategoryID**|(% colspan="1" rowspan="1" %)**DB Type**|(% colspan="1" rowspan="1" %)**Table**|(% colspan="1" rowspan="1" %)**Column**
352 352  |(% colspan="1" rowspan="1" %)Add column|(% colspan="1" rowspan="1" %)When a sample has a strong hydrocarbon odor a measure of Total Petroleum Hydrocarbons (TPH) is performed in the field with a PetroFLAG analyzer. This field is meant to register that value.|(% colspan="1" rowspan="1" %)PetroFLAG® Analyzer (ppmv)|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)Float|(% colspan="1" rowspan="1" %)tblJars|(% colspan="1" rowspan="1" %)JrPetroFLAGAnalyzerValue
... ... @@ -358,6 +358,7 @@
358 358  |(% colspan="1" rowspan="1" %)Add Observation|(% colspan="1" rowspan="1" %)When a gauging tube is purged, it can be done in two ways. Static: the intake depth is left at a set location. Dynamic: the hose intake depth is manually varied by moving the hose up and down.|(% colspan="1" rowspan="1" %)Afpomp methode|(% colspan="1" rowspan="1" %)263|(% colspan="1" rowspan="1" %)String(10)|(% colspan="1" rowspan="1" %)tblObservations|(% colspan="1" rowspan="1" %)WsPurgeModeCode/Metingcode: 123
359 359  |(% colspan="1" rowspan="1" %)Add Observation|(% colspan="1" rowspan="1" %)The total voltage that is measured on a water sample. So that is Redox + Standard. This is used in Germany to give adivice on the sample|(% colspan="1" rowspan="1" %)Totale voltage (mV)|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)Float|(% colspan="1" rowspan="1" %)tblObservations|(% colspan="1" rowspan="1" %)WsTotalVoltage/Metingcode: 124
360 360  
329 +
361 361  **11-8-2020:**
362 362  
363 363  (% class="table-hover" %)
... ... @@ -386,6 +386,7 @@
386 386  Ground filter prefilter|(% colspan="1" rowspan="1" %)255- Filtering method for the bottle
387 387  |(% colspan="1" rowspan="1" %)tblConcernedCompanies|(% colspan="1" rowspan="1" %)CcChamberOfCommerceNr Varchar(50)|(% colspan="1" rowspan="1" %)Chamber of Commerce Nr|(% colspan="1" rowspan="1" %)-|(% colspan="1" rowspan="1" %)-|(% colspan="1" rowspan="1" %)-
388 388  
358 +
389 389  **10-7-2020:**
390 390  
391 391  (% class="table-hover" %)
... ... @@ -706,6 +706,7 @@
706 706  * Hoog
707 707  )))|(% colspan="1" rowspan="1" %)244
708 708  
679 +
709 709  **05-Aug-2019**
710 710  
711 711  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
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 -
dsTerraIndex1.0.xsd
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.RichardDyer
Size
... ... @@ -1,1 +1,0 @@
1 -1.9 MB
Content