Changes for page 2. TerraIndex Export format - dsFieldProject.xsd

Summary

• Page properties (2 modified, 0 added, 0 removed)
• Attachments (2 modified, 1 added, 0 removed)
  • 20150224 Field Database Description (3).docx
  • dsFieldProject.xsd
  • 20220414 Codelookup.xlsx

Details

Page properties

Author

...	...	@@ -1,1 +1,1 @@
1		-XWiki.RichardDyer
	1	+XWiki.Martijn

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" %)**dsFieldproject format XSD file**>>attach:dsFieldProject.xsd]]
	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]]
14	14
15		-[[(% class="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 wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink" %)**Codelookup excel list**>>attach:20200619 Codelookup.xlsx]]
16	16	)))
17	17	)))
18	18
...	...	@@ -29,6 +29,11 @@
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	+
32	32	{{code language="XML" layout="LINENUMBERS" width="100%"}}
33	33
34	34	<dsFieldProject
...	...	@@ -88,11 +88,153 @@
88	88
89	89	(% class="box infomessage" %)
90	90	(((
91		-When you need help with detailed mappings, please request help at: service@terraindex.com
	96	+(% class="box infomessage" %)
	97	+(((
	98	+When you need help with detailed mappings, please request help at: [[service@terraindex.com>>mailto:service@terraindex.com]]
92	92	)))
93	93
	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	+
94	94	== Changes and updates: ==
95	95
	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	+|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	+
	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	+**27-01-2022:**
	221	+
	222	+|**Labeltext in English**|**Remarks**|**Definition and process how this field will be used and when it will be filled.**|(((
	223	+**Change/Add/**
	224	+
	225	+**Delete**
	226	+)))|**DB Type
	227	+(String (length) / Float / Lookupvalue / Integer / DateTime)**|**DBTable in dsFieldProject**|**DBFieldname in dsFieldProject**
	228	+|Use of location| |To add the current use of the location to a measurement point|Add|Lookupvalue|tblMeasurementPoints|MpLocationUsageCode
	229	+|Type|New codelist optios added |-|Change|Lookupvalue|tblMeasurementPoint|MpType
	230	+|Interior location| |Yes / no field for if the sample is an interior location|Add|Lookupvalue|tblMeasurementPoints|MpIsIndoorsCode
	231	+|FlowTypesSurfaceWater| |Describes the flowing pattern of the surface water sampling location|Add|Lookupvalue|tblObservations|METINGCODE 148
	232	+|Location flow rate| |The flow rate of the sampling location|Add|Lookupvalue|tblObservations|METINGCODE 149
	233	+|Special conditions| |Remark field for special sampling conditions to print in report|Add|String|tblWatersamples|JrStreamlineGUID
	234	+|Pump type|Codelist used for several fields|New options added to codelist|Change|Lookupvalue|Multiple fields|Multiple fields
	235	+|Pump connection| |Field for the power connection of a pump|Add|LookupValue|tblObservations|METINGCODE 150
	236	+|Matrix| |Added codelist options|Change|Lookupvalue|tblWatersamples|WsMatrix
	237	+|Mesh size (mm)| |Field for the mesh size of a monitoring well filter|Add|Float|tblFiltertubes|FtMeshSize
	238	+|Type|Project level|New codelist options|Change|Lookupvalue|tblProjects|PrType
	239	+|Type|Finishing level|New codelist options|Change|Lookupvalue|tblFinishings|FiType
	240	+|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)
	241	+|Pumped volume series| |Field for the total pumped volume during a single series|Add|Float|tblObservations|METINGCODE 152 (Series), METINGCODE 151 (Stable value)
	242	+
96	96	**22-11-2021:**
97	97
98	98	|**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**
...	...	@@ -803,6 +803,8 @@
803	803	)))
804	804
805	805
	953	+
	954	+
806	806	(% class="col-xs-12 col-sm-4" %)
807	807	(((
808	808	{{box title="**Contents**"}}

20150224 Field Database Description (3).docx

Size

...	...	@@ -1,1 +1,1 @@
1		-170.3 KB
	1	+172.8 KB

Content

dsFieldProject.xsd

Author

...	...	@@ -1,1 +1,1 @@
1		-XWiki.RoelofZwaan
	1	+XWiki.RichardDyer

Size

...	...	@@ -1,1 +1,1 @@
1		-441.5 KB
	1	+447.8 KB

Content

20220414 Codelookup.xlsx

Author

...	...	@@ -1,0 +1,1 @@
	1	+XWiki.RichardDyer

Size

...	...	@@ -1,0 +1,1 @@
	1	+1.6 MB

Content