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

Summary

Details

Page properties
Parent
... ... @@ -1,1 +1,1 @@
1 -Implementatie dcoumentatie.WebHome
1 +Implementation documentation.WebHome
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" %)**dsFieldproject format XSD file**>>attach:dsFieldProject.xsd]]
13 +[[(% class="wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink" %)**dsFieldproject format XSD file**>>attach:dsFieldProject.xsd]]
14 14  
15 -[[(% class="wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink" %)**Codelookup excel list**>>attach:20200619 Codelookup.xlsx]]
15 +[[(% class="wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink" %)**Codelookup excel list**>>attach:20200619 Codelookup.xlsx]]
16 16  )))
17 17  )))
18 18  
... ... @@ -93,6 +93,43 @@
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 +
96 96  **18-10-2021:**
97 97  
98 98  (% class="table-hover" style="height:1452px; width:1050px" %)
... ... @@ -164,7 +164,6 @@
164 164  |(% colspan="1" rowspan="1" %)Air samples Packaging|(% colspan="1" rowspan="1" %)Sample type|(% colspan="1" rowspan="1" %)Monstertype|(% colspan="1" rowspan="1" %)regular sample/transport blind/environment blind|(% colspan="1" rowspan="1" %)To select the type of support used in the sampling process|(% colspan="1" rowspan="1" %)Add Field|(% colspan="1" rowspan="1" %)lookupvalue|(% colspan="1" rowspan="1" %)tblBottles|(% colspan="1" rowspan="1" %)BoSampleTypeCode
165 165  |(% colspan="1" rowspan="1" %)Air samples Packaging|(% colspan="1" rowspan="1" %)Reference number|(% colspan="1" rowspan="1" %)Referentienummer|(% colspan="1" rowspan="1" %)088D235D123|(% colspan="1" rowspan="1" %)As secundary to barcode. Supports have both a barcode and a reference|(% colspan="1" rowspan="1" %)Add Field|(% colspan="1" rowspan="1" %)string (10)|(% colspan="1" rowspan="1" %)tblBottles|(% colspan="1" rowspan="1" %)BoReferenceNumber
166 166  
167 -
168 168  **6-8-2021:**
169 169  
170 170  (% class="table-hover" %)
... ... @@ -176,7 +176,6 @@
176 176  |(% colspan="1" rowspan="1" %)Watersample details|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)reden pompen beeindigd|(% colspan="1" rowspan="1" %)518 (categoryID: 200)|(% colspan="1" rowspan="1" %)Add Codelist item,|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)peilbuis is droog
177 177  |(% colspan="1" rowspan="1" %)Meetpunt details|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)reden boring gestopt|(% colspan="1" rowspan="1" %)236 (categoryID: 236)|(% colspan="1" rowspan="1" %)Add Codelist item|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)water aangetroffen
178 178  
179 -
180 180  **1-6-2021:**
181 181  
182 182  (% class="table-hover" %)
... ... @@ -232,7 +232,6 @@
232 232  |(% colspan="1" rowspan="1" %)Water Sample - series|(% colspan="1" rowspan="1" %)Turbidity serie|(% colspan="1" rowspan="1" %)In France , Spain (and Germany)  they don't use NTU to describe turbidity but appreciations
233 233  The same appreciations that already exist for the feld "turbidiy" from Watersample should also exist for the series|(% colspan="1" rowspan="1" %)252|(% colspan="1" rowspan="1" %)add|(% colspan="1" rowspan="1" %)Helderheid reeks|(% colspan="1" rowspan="1" %)Codelist|(% colspan="1" rowspan="1" %)String (10)|(% colspan="1" rowspan="1" %)METINGCODE|(% colspan="1" rowspan="1" %)METINGCODE
234 234  
235 -
236 236  **20-04-2021:**
237 237  
238 238  |(% colspan="1" rowspan="1" %)**Change/Add/Delete**|(% colspan="1" rowspan="1" %)**Remarks, Questions with answers and feedback of the status and the field info.**|(% colspan="1" rowspan="1" %)**Labeltext in Dutch**|(% colspan="1" rowspan="1" %)**CategoryID**|(% colspan="1" rowspan="1" %)**Input type**|(% colspan="1" rowspan="1" %)**DB Type**|(% colspan="1" rowspan="1" %)**(String (length) / Float / Lookupvalue / Integer / DateTime)**|(% colspan="1" rowspan="1" %)**tblObservations/**|(% colspan="1" rowspan="1" %)**DBFieldname in dsFieldProject**
... ... @@ -257,7 +257,6 @@
257 257  |(% colspan="1" rowspan="1" %)Add|(% colspan="1" rowspan="1" %)The weatherconditions during the visit to the location|(% colspan="1" rowspan="1" %)Weersomstandigheden|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)Text input|(% colspan="2" rowspan="1" %)String(2000)|(% colspan="1" rowspan="1" %)tblLocationVisits|(% colspan="1" rowspan="1" %)LvWeatherConditionsDescription
258 258  |(% colspan="1" rowspan="1" %)Add|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)nvt|(% colspan="2" rowspan="1" %)datetime|(% colspan="1" rowspan="1" %)tblLocationVisits|(% colspan="1" rowspan="1" %)LvDateLastChanged
259 259  
260 -
261 261  **10-3-2021:**
262 262  
263 263  (% class="table-hover" %)
... ... @@ -314,7 +314,6 @@
314 314  * tblWatersampleMeasurements
315 315  )))|(% colspan="1" rowspan="1" %)METING CODE: 118
316 316  
317 -
318 318  (% class="table-hover" %)
319 319  |(% colspan="1" rowspan="1" %)**Change/Add/Delete**|(% colspan="1" rowspan="1" %)**Remarks, Questions with answers and feedback of the status and the field info.**|(% colspan="1" rowspan="1" %)**Labeltext in Dutch**|(% colspan="1" rowspan="1" %)**CategoryID**|(% colspan="1" rowspan="1" %)**DB Type**|(% colspan="1" rowspan="1" %)**Table**|(% colspan="1" rowspan="1" %)**Column**
320 320  |(% colspan="1" rowspan="1" %)Add column|(% colspan="1" rowspan="1" %)When a sample has a strong hydrocarbon odor a measure of Total Petroleum Hydrocarbons (TPH) is performed in the field with a PetroFLAG analyzer. This field is meant to register that value.|(% colspan="1" rowspan="1" %)PetroFLAG® Analyzer (ppmv)|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)Float|(% colspan="1" rowspan="1" %)tblJars|(% colspan="1" rowspan="1" %)JrPetroFLAGAnalyzerValue
... ... @@ -326,7 +326,6 @@
326 326  |(% colspan="1" rowspan="1" %)Add Observation|(% colspan="1" rowspan="1" %)When a gauging tube is purged, it can be done in two ways. Static: the intake depth is left at a set location. Dynamic: the hose intake depth is manually varied by moving the hose up and down.|(% colspan="1" rowspan="1" %)Afpomp methode|(% colspan="1" rowspan="1" %)263|(% colspan="1" rowspan="1" %)String(10)|(% colspan="1" rowspan="1" %)tblObservations|(% colspan="1" rowspan="1" %)WsPurgeModeCode/Metingcode: 123
327 327  |(% colspan="1" rowspan="1" %)Add Observation|(% colspan="1" rowspan="1" %)The total voltage that is measured on a water sample. So that is Redox + Standard. This is used in Germany to give adivice on the sample|(% colspan="1" rowspan="1" %)Totale voltage (mV)|(% colspan="1" rowspan="1" %) |(% colspan="1" rowspan="1" %)Float|(% colspan="1" rowspan="1" %)tblObservations|(% colspan="1" rowspan="1" %)WsTotalVoltage/Metingcode: 124
328 328  
329 -
330 330  **11-8-2020:**
331 331  
332 332  (% class="table-hover" %)
... ... @@ -355,7 +355,6 @@
355 355  Ground filter prefilter|(% colspan="1" rowspan="1" %)255- Filtering method for the bottle
356 356  |(% colspan="1" rowspan="1" %)tblConcernedCompanies|(% colspan="1" rowspan="1" %)CcChamberOfCommerceNr Varchar(50)|(% colspan="1" rowspan="1" %)Chamber of Commerce Nr|(% colspan="1" rowspan="1" %)-|(% colspan="1" rowspan="1" %)-|(% colspan="1" rowspan="1" %)-
357 357  
358 -
359 359  **10-7-2020:**
360 360  
361 361  (% class="table-hover" %)
... ... @@ -676,7 +676,6 @@
676 676  * Hoog
677 677  )))|(% colspan="1" rowspan="1" %)244
678 678  
679 -
680 680  **05-Aug-2019**
681 681  
682 682  Additional **ISO14688** fields
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
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