Changes for page 2. TerraIndex Export format - dsFieldProject.xsd
Last modified by Robert Jan Daams on 2025/02/04 11:52
From version 19.1
edited by Richard Dyer
on 2022/04/14 15:53
on 2022/04/14 15:53
Change comment:
There is no comment for this version
To version 11.2
edited by Richard Dyer
on 2021/11/23 11:40
on 2021/11/23 11:40
Change comment:
Update document after refactoring.
Summary
-
Page properties (1 modified, 0 added, 0 removed)
-
Attachments (2 modified, 0 added, 1 removed)
Details
- Page properties
-
- 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" %)**dsFieldproject format XSD file**>>attach:dsFieldProject.xsd]]13 +[[(% class="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 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 wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink" %)**Codelookup excel list**>>attach:20200619 Codelookup.xlsx]] 16 16 ))) 17 17 ))) 18 18 ... ... @@ -93,112 +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 -|Benzeen 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 202 **22-11-2021:** 203 203 204 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**
- 20150224 Field Database Description (3).docx
-
- Size
-
... ... @@ -1,1 +1,1 @@ 1 -17 2.8KB1 +170.3 KB - Content
- 20220414 Codelookup.xlsx
-
- Author
-
... ... @@ -1,1 +1,0 @@ 1 -XWiki.RichardDyer - Size
-
... ... @@ -1,1 +1,0 @@ 1 -1.6 MB - Content
- dsFieldProject.xsd
-
- Author
-
... ... @@ -1,1 +1,1 @@ 1 -XWiki.R ichardDyer1 +XWiki.RoelofZwaan - Size
-
... ... @@ -1,1 +1,1 @@ 1 -44 7.8KB1 +441.5 KB - Content