Skip to Content
Last modified by Robert Jan Daams on 2025/02/04 11:52
From version 24.1
edited by Robin Huisman
on 2022/07/27 21:12
Change comment: There is no comment for this version
To version 9.3
edited by Richard Dyer
on 2021/11/22 11:38
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.RobinHuisman
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" %)**dsFieldproject format XSD file**>>attach:dsFieldProject.xsd]]
13 +[[(% class="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" %)**Codelookup excel list**>>attach:20200619 Codelookup.xlsx]]
15 +[[(% class="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,155 +93,19 @@
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 -== ==
109 -
110 110  == Changes and updates: ==
111 111  
112 -**juli 2022:**
113 -
114 -Nieuwe database unieke GUIDs toegevoegd, die in Streamline als ID gaan gelden.
115 -
116 -
117 -|dsFieldProject.tblAnalysisSamplesDataTable.AnStreamlineGUID
118 -|dsFieldProject.tblLabassignmentsDataTable.LbStreamlineGUID
119 -|dsFieldProject.tblAnalysisRequestsDataTable.ArStreamlineGUID
120 -|dsFieldProject.tblAnalysisResultsDataTable.AsStreamlineGUID
121 -|dsFieldProject.tblAssessmentPropertiesDataTable.ApStreamlineGUID
122 -|dsFieldProject.tblAssessmentResultsDataTable.ArStreamlineGUID
123 -|dsFieldProject.tblAssessmentResultStandards.ArsStreamlineGUID
124 -|dsFieldProject.tblWaterSamples.AnStreamlineGUID
125 -|dsFieldProject.tblConcernedCompanies.CcStreamlineGUID
126 -
127 -
128 -**maart 2022:**
129 -
130 -|(% 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**
131 -|
132 -|
133 -|
134 -|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
135 -|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
136 -|BroID| |Field for the BroID at filltertube level|Add|Varchar(50)|tblFilterTubes|BroID
137 -|Weight fine fraction (kg)| |This concerns the weight of the sieved fraction, which is distinct from the coarse fraction|Add|Float|tblJars|JrWeightFractionFine
138 -|Determination method of moisture| |Describes how the soil was kept at a safe mositure level to work with asbestos|Add|Codelist|tblLayers|LaFieldworkMoistureMethodCode
139 -|Type of asbestos containing material| |Describes how the soil was kept at a safe mositure level to work with asbestos|Add|Codelist|tblJars|JrPlateMaterialTypeCode
140 -|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
141 -|Recommended prepump volume|CodeID: 158|Needed to register for french users|Add|Float|tblObservations|METINGCODE 158
142 -|Tube flushing volume|CodeID: 159|Needed to register for french users|Add|Float|tblObservations|METINGCODE 159
143 -|Filtertube leaktest| |Wether or not a leaking test was performed on the filtertube (for air sampling)|Add|codelist (Yes / no)|tblFilterTubes|FtLeakingtestCode
144 -|Presence of water|CodeID: 160|Check to see whetherthe tube is dry when sampling an air sample|Add|codelist (Yes / no)|tblObservations|METINGCODE 160
145 -|Grondwaterstand aangetroffen?| |Veld om aan te geven dat de grondwaterstand niet is bereikt bij deze boring|Add|codelist (Yes / no)|tblMeasurementPoints|MpGWSFoundCode
146 -|Benzene PID|CodeID: 156|Arcadis nederland wil dit graag...|Add|float|tblObservations|METINGCODE 156
147 -|Lager explosief gehalte (vol %)|CodeID: 155|Arcadis nederland wil dit graag...|Add|float|tblObservations|METINGCODE 155
148 -|Number of soil grabs| |Aantal grepen veld voor partijkeuring|Add|Integer|tblMeasurementpoints|MpGrabNumber
149 -|Koolstofdioxine/CO2 ppm|(((
150 -New label
151 -
152 -CO2 (ppm)
153 -)))|CHANGE LABEL|Change|Float|tblObservations|METING CODE: 113
154 -|Koolstofdioxine/CO2 einde monstername (ppm)|(((
155 -New label
156 -
157 -CO2 (ppm) einde monstername
158 -)))|CHANGE LABEL|Change|Float|tblObservations|METING CODE: 113
159 -|Weight debris (kg)|(((
160 -new label
161 -
162 -english:
163 -
164 -Weight coarse fraction (kg)
165 -
166 -dutch:
167 -
168 -Gewicht grove fractie (kg)
169 -)))|Change label to conform norm|Change|Float|tblJars|JrWeightDebris
170 -|Pieces of Asbestos|(((
171 -new label
172 -
173 -english:
174 -
175 -Pieces of asbestos-containing material
176 -
177 -
178 -dutch:
179 -
180 -Aantal stukjes asbestverdacht materiaal
181 -
182 -
183 -
184 -)))|Change label to conform norm|Change|Integer |tblJars|JrNoPiecesAsbestos
185 -|Weight asbestos|(((
186 -new label
187 -
188 -english:
189 -
190 -Weight asbestos-containing material
191 -
192 -
193 -dutch:
194 -
195 -Gewicht asbestverdacht materiaal
196 -)))|Change label to conform norm|Change|Float|tblJars|JrWeightAsbestos
197 -|Weight sample (kg)|(((
198 -new label
199 -
200 -english:
201 -
202 -Total sample weight (kg)
203 -
204 -dutch:
205 -
206 -Totaal gewicht monster (kg)
207 -)))|Change label to make it more clear that it concerns the total weight of the sample|Change|Float|tblJars|JrWeightSample
208 -
209 -== ==
210 -
211 -**27-01-2022:**
212 -
213 -|**Labeltext in English**|**Remarks**|**Definition and process how this field will be used and when it will be filled.**|(((
214 -**Change/Add/**
215 -
216 -**Delete**
217 -)))|**DB Type
218 -(String (length) / Float / Lookupvalue / Integer / DateTime)**|**DBTable in dsFieldProject**|**DBFieldname in dsFieldProject**
219 -|Use of location| |To add the current use of the location to a measurement point|Add|Lookupvalue|tblMeasurementPoints|MpLocationUsageCode
220 -|Type|New codelist optios added |-|Change|Lookupvalue|tblMeasurementPoint|MpType
221 -|Interior location| |Yes / no field for if the sample is an interior location|Add|Lookupvalue|tblMeasurementPoints|MpIsIndoorsCode
222 -|FlowTypesSurfaceWater| |Describes the flowing pattern of the surface water sampling location|Add|Lookupvalue|tblObservations|METINGCODE 148
223 -|Location flow rate| |The flow rate of the sampling location|Add|Lookupvalue|tblObservations|METINGCODE 149
224 -|Special conditions| |Remark field for special sampling conditions to print in report|Add|String|tblWatersamples|JrStreamlineGUID
225 -|Pump type|Codelist used for several fields|New options added to codelist|Change|Lookupvalue|Multiple fields|Multiple fields
226 -|Pump connection| |Field for the power connection of a pump|Add|LookupValue|tblObservations|METINGCODE 150
227 -|Matrix| |Added codelist options|Change|Lookupvalue|tblWatersamples|WsMatrix
228 -|Mesh size (mm)| |Field for the mesh size of a monitoring well filter|Add|Float|tblFiltertubes|FtMeshSize
229 -|Type|Project level|New codelist options|Change|Lookupvalue|tblProjects|PrType
230 -|Type|Finishing level|New codelist options|Change|Lookupvalue|tblFinishings|FiType
231 -|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)
232 -|Pumped volume series| |Field for the total pumped volume during a single series|Add|Float|tblObservations|METINGCODE 152 (Series), METINGCODE 151 (Stable value)
233 -
234 234  **22-11-2021:**
235 235  
236 236  |**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**
237 237  | | | | | | | | | |
238 -|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
239 -|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
240 -|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
241 -|Water samples|Surrounding humidity|Omgevingsvochtigheid|Licht vochtig, Zeer vochtig, Vochtig op bodem, Vochtig op plaatsen|The circumstances when sampling| |Add|Codelist|(((
242 -* tblObservations
243 -* tblWatersampleMeasurements
244 -)))|Metingcode: 147 / WsSurroundingHumidity
100 +|Soil samples|JrLengthCoreSampler|Lengte steekbuis (mm)|Length core sampler (mm)|The length of a core sampler may vary and defines volume| |Add|Integer|tblJars|JrLengthCoreSampler
101 +|Measurement Point|MpDiameter|Diameter (mm)|Diameter (mm)|(% colspan="2" %)Information is available on layer level, but may sometimes be consistent over the enitre measurement point|Add|Integer|tblMeasurementPoints|MpDiameter
102 +|Air Samples packaging|Placed in serie|In serie geplaatst|Yes/no|Two packagings for air samples can be placed in serie or not| |Add|Lookupvalue (Yes/No)|tblBottles|BoPlacedInSerie
103 +|Water samples|Surrounding humidity|Omgevingsvochtigheid|Licht vochtig, Zeer vochtig, Vochtig op bodem, Vochtig op plaatsen|The circumstances whan sampling| |Add|Codelist|tblWaterSample|WsSurroundingHumidity
245 245  
246 246  **18-10-2021:**
247 247  
... ... @@ -941,8 +941,6 @@
941 941  )))
942 942  
943 943  
944 -
945 -
946 946  (% class="col-xs-12 col-sm-4" %)
947 947  (((
948 948  {{box title="**Contents**"}}
20150224 Field Database Description (3).docx
Size
... ... @@ -1,1 +1,1 @@
1 -172.8 KB
1 +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.RichardDyer
1 +XWiki.RoelofZwaan
Size
... ... @@ -1,1 +1,1 @@
1 -447.8 KB
1 +441.5 KB
Content