Skip to Content
Last modified by Robert Jan Daams on 2025/02/04 11:52
From version 27.3
edited by Robert Jan Daams
on 2025/02/04 11:52
Change comment: There is no comment for this version
To version 17.1
edited by Richard Dyer
on 2022/04/14 15:02
Change comment: There is no comment for this version

Summary

Details

Page properties
Title
... ... @@ -1,1 +1,1 @@
1 -TerraIndex Export format - dsFieldProject.xsd
1 +Documentation TerraIndex Export format - dsFieldProject.xsd
Parent
... ... @@ -1,1 +1,1 @@
1 -Implementation documentation.For customers.WebHome
1 +Implementation documentation.WebHome
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.RjDaams
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 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 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,53 +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 -== ==
109 -
110 110  == Changes and updates: ==
111 111  
112 -**27 augustus 2024:**
113 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 -|BRO-ID| |The BRO-ID of the project. Used for specific deliveries to the BRO-loket after the project has been officially registered within the BRO.|Add|Varchar(50)|tblProjects|BroId
119 -|Report date| |The reporting date of this project towards the 'Bronhouder'. Used for specific deliveries to the BRO-loket, keep in mind this is the date the BRO will check 'Bronhouders' for their legal tasks.|Add|datetime|tblProjects|ReportDate
120 -|BRO Bronhouder objectId| |The objectId for the 'Bronhouder' to find this project in the BRO Portal.|Add|Varchar(200)|tblProjects|BroAccountableParty
121 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 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 -|
99 +|
100 +|
101 +|
143 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 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 145  |BroID| |Field for the BroID at filltertube level|Add|Varchar(50)|tblFilterTubes|BroID
... ... @@ -150,9 +150,9 @@
150 150  |Recommended prepump volume|CodeID: 158|Needed to register for french users|Add|Float|tblObservations|METINGCODE 158
151 151  |Tube flushing volume|CodeID: 159|Needed to register for french users|Add|Float|tblObservations|METINGCODE 159
152 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
112 +|Precense of water|CodeID: 160|Check to see whetherthe tube is dry when sampling an air sample|Add|codelist (Yes / no)|tblObservations|METINGCODE 160
154 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
114 +|Benzeen PID |CodeID: 156|Arcadis nederland wil dit graag...|Add|float|tblObservations|METINGCODE 156
156 156  |Lager explosief gehalte (vol %)|CodeID: 155|Arcadis nederland wil dit graag...|Add|float|tblObservations|METINGCODE 155
157 157  |Number of soil grabs| |Aantal grepen veld voor partijkeuring|Add|Integer|tblMeasurementpoints|MpGrabNumber
158 158  |Koolstofdioxine/CO2 ppm|(((
... ... @@ -165,17 +165,7 @@
165 165  
166 166  CO2 (ppm) einde monstername
167 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
127 +|Weight debris (kg)| |Change label to conform norm|Change|Float|tblJars|JrWeightDebris
179 179  |Pieces of Asbestos|(((
180 180  new label
181 181  
... ... @@ -208,14 +208,14 @@
208 208  
209 209  english:
210 210  
211 -Total sample weight (kg)
160 +Weight coarse fraction (kg)
212 212  
213 213  dutch:
214 214  
215 -Totaal gewicht monster (kg)
164 +Gewicht grove fractie (kg)
216 216  )))|Change label to make it more clear that it concerns the total weight of the sample|Change|Float|tblJars|JrWeightSample
217 217  
218 -== ==
167 +== Changes and updates: ==
219 219  
220 220  **27-01-2022:**
221 221  
... ... @@ -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**"}}