Changes for page 2. TerraIndex Export format - dsFieldProject.xsd
Last modified by Robert Jan Daams on 2025/02/04 11:52
From version 23.1
edited by Robin Huisman
on 2022/07/27 17:12
on 2022/07/27 17:12
Change comment:
There is no comment for this version
To version 17.1
edited by Richard Dyer
on 2022/04/14 15:02
on 2022/04/14 15:02
Change comment:
There is no comment for this version
Summary
-
Page properties (2 modified, 0 added, 0 removed)
Details
- Page properties
-
- Author
-
... ... @@ -1,1 +1,1 @@ 1 -XWiki.R obinHuisman1 +XWiki.RichardDyer - 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 wikiattachmentlink wikiattachmentlink wikiattachmentlink" %)**dsFieldproject format XSD file**>>attach:dsFieldProject.xsd]]13 +[[(% class="wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink 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 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 wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink" %)**Codelookup excel list**>>attach:20200619 Codelookup.xlsx]] 16 16 ))) 17 17 ))) 18 18 ... ... @@ -29,11 +29,6 @@ 29 29 30 30 Small XML example, full example can be found as an attachment: 31 31 32 -(% class="box infomessage" %) 33 -((( 34 -'dsFieldProject' root tag, is also named: 'VeldData'. This is the same export formatting inside. 35 -))) 36 - 37 37 {{code language="XML" layout="LINENUMBERS" width="100%"}} 38 38 39 39 <dsFieldProject ... ... @@ -93,29 +93,17 @@ 93 93 94 94 (% class="box infomessage" %) 95 95 ((( 96 -(% class="box infomessage" %) 97 -((( 98 -When you need help with detailed mappings, please request help at: [[service@terraindex.com>>mailto:service@terraindex.com]] 91 +When you need help with detailed mappings, please request help at: service@terraindex.com 99 99 ))) 100 100 101 -- DateLastChanged fields containing DateTime values, should be send to the server in +2 Timezone (Amsterdam). 102 - 103 -- ID’s in the XML should be valid internally, as Primary- and Foreign-Keys. Once getting pushed into the database, the database will provice new ID’s. 104 - 105 - 106 -))) 107 - 108 -(% class="wikigeneratedid" %) 109 -== == 110 - 111 111 == Changes and updates: == 112 112 113 113 114 114 115 115 |(% 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** 116 -| 117 -| 118 -| 99 +| 100 +| 101 +| 119 119 |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 120 120 |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 121 121 |BroID| |Field for the BroID at filltertube level|Add|Varchar(50)|tblFilterTubes|BroID ... ... @@ -126,9 +126,9 @@ 126 126 |Recommended prepump volume|CodeID: 158|Needed to register for french users|Add|Float|tblObservations|METINGCODE 158 127 127 |Tube flushing volume|CodeID: 159|Needed to register for french users|Add|Float|tblObservations|METINGCODE 159 128 128 |Filtertube leaktest| |Wether or not a leaking test was performed on the filtertube (for air sampling)|Add|codelist (Yes / no)|tblFilterTubes|FtLeakingtestCode 129 -|Pre sence of water|CodeID: 160|Check to see whetherthe tube is dry when sampling an air sample|Add|codelist (Yes / no)|tblObservations|METINGCODE 160112 +|Precense of water|CodeID: 160|Check to see whetherthe tube is dry when sampling an air sample|Add|codelist (Yes / no)|tblObservations|METINGCODE 160 130 130 |Grondwaterstand aangetroffen?| |Veld om aan te geven dat de grondwaterstand niet is bereikt bij deze boring|Add|codelist (Yes / no)|tblMeasurementPoints|MpGWSFoundCode 131 -|Benze ne PID|CodeID: 156|Arcadis nederland wil dit graag...|Add|float|tblObservations|METINGCODE 156114 +|Benzeen PID |CodeID: 156|Arcadis nederland wil dit graag...|Add|float|tblObservations|METINGCODE 156 132 132 |Lager explosief gehalte (vol %)|CodeID: 155|Arcadis nederland wil dit graag...|Add|float|tblObservations|METINGCODE 155 133 133 |Number of soil grabs| |Aantal grepen veld voor partijkeuring|Add|Integer|tblMeasurementpoints|MpGrabNumber 134 134 |Koolstofdioxine/CO2 ppm|((( ... ... @@ -141,17 +141,7 @@ 141 141 142 142 CO2 (ppm) einde monstername 143 143 )))|CHANGE LABEL|Change|Float|tblObservations|METING CODE: 113 144 -|Weight debris (kg)|((( 145 -new label 146 - 147 -english: 148 - 149 -Weight coarse fraction (kg) 150 - 151 -dutch: 152 - 153 -Gewicht grove fractie (kg) 154 -)))|Change label to conform norm|Change|Float|tblJars|JrWeightDebris 127 +|Weight debris (kg)| |Change label to conform norm|Change|Float|tblJars|JrWeightDebris 155 155 |Pieces of Asbestos|((( 156 156 new label 157 157 ... ... @@ -184,11 +184,11 @@ 184 184 185 185 english: 186 186 187 - Totalsampleweight (kg)160 +Weight coarse fraction (kg) 188 188 189 189 dutch: 190 190 191 - Totaal gewichtmonster (kg)164 +Gewicht grove fractie (kg) 192 192 )))|Change label to make it more clear that it concerns the total weight of the sample|Change|Float|tblJars|JrWeightSample 193 193 194 194 == Changes and updates: == ... ... @@ -926,8 +926,6 @@ 926 926 ))) 927 927 928 928 929 - 930 - 931 931 (% class="col-xs-12 col-sm-4" %) 932 932 ((( 933 933 {{box title="**Contents**"}}