Skip to Content
Last modified by Robert Jan Daams on 2025/02/04 11:52
From version 25.2
edited by Martijn Spaan
on 2024/08/27 11:44
Change comment: There is no comment for this version
To version 15.1
edited by Richard Dyer
on 2022/04/14 13:53
Change comment: Uploaded new attachment "20220414 Codelookup.xlsx", version {1}

Summary

Details

Page properties
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.Martijn
1 +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 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" %)**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 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" %)**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,130 +93,13 @@
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).
94 +== Changes and updates: ==
102 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 -== ==
109 -
110 110  == Changes and updates: ==
111 111  
112 -**27 augustus 2024:**
113 -
114 -|(% 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**
115 -|
116 -|
117 -|
118 -|BroId| |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|Varchar(50)|tblProjects|BroId
119 -|ReportDate| |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|datetime|tblProjects|ReportDate
120 -|BroAccountableParty| |Field for the BroID at filltertube level|Add|Varchar(200)|tblProjects|BroAccountableParty
121 -
122 -**27 juli 2022:**
123 -
124 -Nieuwe database unieke GUIDs toegevoegd, die in Streamline als ID gaan gelden.
125 -
126 -
127 -|dsFieldProject.tblAnalysisSamplesDataTable.AnStreamlineGUID
128 -|dsFieldProject.tblLabassignmentsDataTable.LbStreamlineGUID
129 -|dsFieldProject.tblAnalysisRequestsDataTable.ArStreamlineGUID
130 -|dsFieldProject.tblAnalysisResultsDataTable.AsStreamlineGUID
131 -|dsFieldProject.tblAssessmentPropertiesDataTable.ApStreamlineGUID
132 -|dsFieldProject.tblAssessmentResultsDataTable.ArStreamlineGUID
133 -|dsFieldProject.tblAssessmentResultStandards.ArsStreamlineGUID
134 -|dsFieldProject.tblWaterSamples.AnStreamlineGUID
135 -|dsFieldProject.tblConcernedCompanies.CcStreamlineGUID
136 -
137 -**14 maart 2022:**
138 -
139 -|(% 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**
140 -|
141 -|
142 -|
143 -|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
144 -|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
145 -|BroID| |Field for the BroID at filltertube level|Add|Varchar(50)|tblFilterTubes|BroID
146 -|Weight fine fraction (kg)| |This concerns the weight of the sieved fraction, which is distinct from the coarse fraction|Add|Float|tblJars|JrWeightFractionFine
147 -|Determination method of moisture| |Describes how the soil was kept at a safe mositure level to work with asbestos|Add|Codelist|tblLayers|LaFieldworkMoistureMethodCode
148 -|Type of asbestos containing material| |Describes how the soil was kept at a safe mositure level to work with asbestos|Add|Codelist|tblJars|JrPlateMaterialTypeCode
149 -|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
150 -|Recommended prepump volume|CodeID: 158|Needed to register for french users|Add|Float|tblObservations|METINGCODE 158
151 -|Tube flushing volume|CodeID: 159|Needed to register for french users|Add|Float|tblObservations|METINGCODE 159
152 -|Filtertube leaktest| |Wether or not a leaking test was performed on the filtertube (for air sampling)|Add|codelist (Yes / no)|tblFilterTubes|FtLeakingtestCode
153 -|Presence of water|CodeID: 160|Check to see whetherthe tube is dry when sampling an air sample|Add|codelist (Yes / no)|tblObservations|METINGCODE 160
154 -|Grondwaterstand aangetroffen?| |Veld om aan te geven dat de grondwaterstand niet is bereikt bij deze boring|Add|codelist (Yes / no)|tblMeasurementPoints|MpGWSFoundCode
155 -|Benzene PID|CodeID: 156|Arcadis nederland wil dit graag...|Add|float|tblObservations|METINGCODE 156
156 -|Lager explosief gehalte (vol %)|CodeID: 155|Arcadis nederland wil dit graag...|Add|float|tblObservations|METINGCODE 155
157 -|Number of soil grabs| |Aantal grepen veld voor partijkeuring|Add|Integer|tblMeasurementpoints|MpGrabNumber
158 -|Koolstofdioxine/CO2 ppm|(((
159 -New label
160 -
161 -CO2 (ppm)
162 -)))|CHANGE LABEL|Change|Float|tblObservations|METING CODE: 113
163 -|Koolstofdioxine/CO2 einde monstername (ppm)|(((
164 -New label
165 -
166 -CO2 (ppm) einde monstername
167 -)))|CHANGE LABEL|Change|Float|tblObservations|METING CODE: 113
168 -|Weight debris (kg)|(((
169 -new label
170 -
171 -english:
172 -
173 -Weight coarse fraction (kg)
174 -
175 -dutch:
176 -
177 -Gewicht grove fractie (kg)
178 -)))|Change label to conform norm|Change|Float|tblJars|JrWeightDebris
179 -|Pieces of Asbestos|(((
180 -new label
181 -
182 -english:
183 -
184 -Pieces of asbestos-containing material
185 -
186 -
187 -dutch:
188 -
189 -Aantal stukjes asbestverdacht materiaal
190 -
191 -
192 -
193 -)))|Change label to conform norm|Change|Integer |tblJars|JrNoPiecesAsbestos
194 -|Weight asbestos|(((
195 -new label
196 -
197 -english:
198 -
199 -Weight asbestos-containing material
200 -
201 -
202 -dutch:
203 -
204 -Gewicht asbestverdacht materiaal
205 -)))|Change label to conform norm|Change|Float|tblJars|JrWeightAsbestos
206 -|Weight sample (kg)|(((
207 -new label
208 -
209 -english:
210 -
211 -Total sample weight (kg)
212 -
213 -dutch:
214 -
215 -Totaal gewicht monster (kg)
216 -)))|Change label to make it more clear that it concerns the total weight of the sample|Change|Float|tblJars|JrWeightSample
217 -
218 -== ==
219 -
220 220  **27-01-2022:**
221 221  
222 222  |**Labeltext in English**|**Remarks**|**Definition and process how this field will be used and when it will be filled.**|(((
... ... @@ -950,8 +950,6 @@
950 950  )))
951 951  
952 952  
953 -
954 -
955 955  (% class="col-xs-12 col-sm-4" %)
956 956  (((
957 957  {{box title="**Contents**"}}