Setting up API communication by REST services with TerraIndex for customers - Documentation TerraIndex Export format - dsFieldProject.xsd

Page / - last modified by Roelof Zwaan on 2021/11/22 10:25

Documentation TerraIndex Export format - dsFieldProject.xsd

last modified by Roelof Zwaan

on 2021/11/22 10:25

Table of Contents

When you request an export from the TerraIndex webservice or try to upload new data, you’ll need to understand the format of the projects. For exportType ‘Export_FIELD_XML_v1_0_0' or when you open a '.ti'/'TerraIndex Export’ file from the exportmodule of TerraIndex web, you receive an XML file that contains all Project data. Below the XSD and examples of how this format looks like.

Files to help understand the data format:

Example Export XML file

Field database description

dsFieldproject format XSD file

Codelookup excel list

In the diagram above the table ‘tblWatersampleMeasurement' is presented, but this table is replaced bij ‘tblObservations’. We recommend to use 'tblObservation’, because the other table will be removed. It will be in the XML only for backwards compatibility.

Small XML example, full example can be found as an attachment:

'dsFieldProject' root tag, is also named: 'VeldData'. This is the same export formatting inside.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54

<dsFieldProject
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:noNamespaceSchemaLocation="file:///C:/Temp/dsFieldProject.xsd">
<tblProjects>
<PrID>242</PrID>
<PrCode>2018-010-DEMO</PrCode>
<PrName>TU Delft, the Netherlands</PrName>
<PrConsultancyFirm>TerraIndex</PrConsultancyFirm>
<PrLeaderCode>Consult</PrLeaderCode>
<PrFieldworkFirm>TerraIndex</PrFieldworkFirm>
<PrDrillingMasterCode>Borelog</PrDrillingMasterCode>
<PrGuid>46ba5f9e-5d59-8c8c-c5d6-ac9e9651ec4b</PrGuid>
<PrDateLastChanged>2018-08-31T11:12:50.45</PrDateLastChanged>
<PrLocPointGeometry>POINT (6.1000890695634133 52.58846240818189)</PrLocPointGeometry>
<PrTemplateID>23737</PrTemplateID>
<PrCoordinateSystem>RD</PrCoordinateSystem>
</tblProjects>
<tblMeasurementPoints>
<MpID>1</MpID>
<MpName>A01</MpName>
<MpNameNumeric>1</MpNameNumeric>
<MpDate>2018-08-01T00:00:00</MpDate>
<MpDepth>300</MpDepth>
<MpXCoord>203588.1</MpXCoord>
<MpYCoord>511339.61</MpYCoord>
<MpDrillingMasterCode>John Borelog</MpDrillingMasterCode>
<MpGroundLevelTypeCode>KL</MpGroundLevelTypeCode>
<MpTypeCode>P</MpTypeCode>
<MpCoordinatesPrecisionCode>G1</MpCoordinatesPrecisionCode>
<PrID>242</PrID>
<MpGuid>d09c8af7-45d1-4cd2-939f-7db42218b4ec</MpGuid>
<MpDateLastChanged>2018-08-28T10:00:26.567</MpDateLastChanged>
<MpPointGeometry>POINT (6.10416686139686 52.5874623700489)</MpPointGeometry>
</tblMeasurementPoints>
<tblMeasurementPoints>
<MpID>2</MpID>
<MpName>A04</MpName>
<MpNameNumeric>4</MpNameNumeric>
<MpDate>2018-08-01T00:00:00</MpDate>
<MpDepth>300</MpDepth>
<MpXCoord>203508.7</MpXCoord>
<MpYCoord>511382.74</MpYCoord>
<MpDrillingMasterCode>John Borelog</MpDrillingMasterCode>
<MpGroundLevelTypeCode>KL</MpGroundLevelTypeCode>
<MpTypeCode>B</MpTypeCode>
<MpGWT>150</MpGWT>
<MpCoordinatesPrecisionCode>G1</MpCoordinatesPrecisionCode>
<PrID>242</PrID>
<MpGuid>133ef5e8-2990-4b75-b718-27cd7bb9630d</MpGuid>
<MpDateLastChanged>2018-08-28T10:00:26.57</MpDateLastChanged>
<MpPointGeometry>POINT (6.10300163732122 52.5878570271434)</MpPointGeometry>
</tblMeasurementPoints>
</dsFieldProject

When you need help with detailed mappings, please request help at: service@terraindex.com

- DateLastChanged fields containing DateTime values, should be send to the server in +2 Timezone (Amsterdam).

- 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.

Changes and updates:

27 augustus 2024:

Labeltext in English	Remarks	Definition and process how this field will be used and when it will be filled.	Change/Add/Delete	DB Type (String (length) / Float / Lookupvalue / Integer / DateTime)	DBTable in dsFieldProject	DBFieldname in dsFieldProject
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
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
BRO Bronhouder objectId	The objectId for the 'Bronhouder' to find this project in the BRO Portal.	Add	Varchar(200)	tblProjects	BroAccountableParty

27 juli 2022:

Nieuwe database unieke GUIDs toegevoegd, die in Streamline als ID gaan gelden.

dsFieldProject.tblAnalysisSamplesDataTable.AnStreamlineGUID
dsFieldProject.tblLabassignmentsDataTable.LbStreamlineGUID
dsFieldProject.tblAnalysisRequestsDataTable.ArStreamlineGUID
dsFieldProject.tblAnalysisResultsDataTable.AsStreamlineGUID
dsFieldProject.tblAssessmentPropertiesDataTable.ApStreamlineGUID
dsFieldProject.tblAssessmentResultsDataTable.ArStreamlineGUID
dsFieldProject.tblAssessmentResultStandards.ArsStreamlineGUID
dsFieldProject.tblWaterSamples.AnStreamlineGUID
dsFieldProject.tblConcernedCompanies.CcStreamlineGUID

14 maart 2022:

Labeltext in English	Remarks	Definition and process how this field will be used and when it will be filled.	Change/Add/Delete	DB Type (String (length) / Float / Lookupvalue / Integer / DateTime)	DBTable in dsFieldProject	DBFieldname in dsFieldProject
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
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
BroID	Field for the BroID at filltertube level	Add	Varchar(50)	tblFilterTubes	BroID
Weight fine fraction (kg)	This concerns the weight of the sieved fraction, which is distinct from the coarse fraction	Add	Float	tblJars	JrWeightFractionFine
Determination method of moisture	Describes how the soil was kept at a safe mositure level to work with asbestos	Add	Codelist	tblLayers	LaFieldworkMoistureMethodCode
Type of asbestos containing material	Describes how the soil was kept at a safe mositure level to work with asbestos	Add	Codelist	tblJars	JrPlateMaterialTypeCode
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
Recommended prepump volume	CodeID: 158	Needed to register for french users	Add	Float	tblObservations	METINGCODE 158
Tube flushing volume	CodeID: 159	Needed to register for french users	Add	Float	tblObservations	METINGCODE 159
Filtertube leaktest	Wether or not a leaking test was performed on the filtertube (for air sampling)	Add	codelist (Yes / no)	tblFilterTubes	FtLeakingtestCode
Presence of water	CodeID: 160	Check to see whetherthe tube is dry when sampling an air sample	Add	codelist (Yes / no)	tblObservations	METINGCODE 160
Grondwaterstand aangetroffen?	Veld om aan te geven dat de grondwaterstand niet is bereikt bij deze boring	Add	codelist (Yes / no)	tblMeasurementPoints	MpGWSFoundCode
Benzene PID	CodeID: 156	Arcadis nederland wil dit graag...	Add	float	tblObservations	METINGCODE 156
Lager explosief gehalte (vol %)	CodeID: 155	Arcadis nederland wil dit graag...	Add	float	tblObservations	METINGCODE 155
Number of soil grabs	Aantal grepen veld voor partijkeuring	Add	Integer	tblMeasurementpoints	MpGrabNumber
Koolstofdioxine/CO2 ppm	New label CO2 (ppm)	CHANGE LABEL	Change	Float	tblObservations	METING CODE: 113
Koolstofdioxine/CO2 einde monstername (ppm)	New label CO2 (ppm) einde monstername	CHANGE LABEL	Change	Float	tblObservations	METING CODE: 113
Weight debris (kg)	new label english: Weight coarse fraction (kg) dutch: Gewicht grove fractie (kg)	Change label to conform norm	Change	Float	tblJars	JrWeightDebris
Pieces of Asbestos	new label english: Pieces of asbestos-containing material dutch: Aantal stukjes asbestverdacht materiaal	Change label to conform norm	Change	Integer	tblJars	JrNoPiecesAsbestos
Weight asbestos	new label english: Weight asbestos-containing material dutch: Gewicht asbestverdacht materiaal	Change label to conform norm	Change	Float	tblJars	JrWeightAsbestos
Weight sample (kg)	new label english: Total sample weight (kg) dutch: Totaal gewicht monster (kg)	Change label to make it more clear that it concerns the total weight of the sample	Change	Float	tblJars	JrWeightSample

27-01-2022:

Labeltext in English	Remarks	Definition and process how this field will be used and when it will be filled.	Change/Add/ Delete	DB Type (String (length) / Float / Lookupvalue / Integer / DateTime)	DBTable in dsFieldProject	DBFieldname in dsFieldProject
Use of location	To add the current use of the location to a measurement point	Add	Lookupvalue	tblMeasurementPoints	MpLocationUsageCode
Type	New codelist optios added	-	Change	Lookupvalue	tblMeasurementPoint	MpType
Interior location	Yes / no field for if the sample is an interior location	Add	Lookupvalue	tblMeasurementPoints	MpIsIndoorsCode
FlowTypesSurfaceWater	Describes the flowing pattern of the surface water sampling location	Add	Lookupvalue	tblObservations	METINGCODE 148
Location flow rate	The flow rate of the sampling location	Add	Lookupvalue	tblObservations	METINGCODE 149
Special conditions	Remark field for special sampling conditions to print in report	Add	String	tblWatersamples	JrStreamlineGUID
Pump type	Codelist used for several fields	New options added to codelist	Change	Lookupvalue	Multiple fields	Multiple fields
Pump connection	Field for the power connection of a pump	Add	LookupValue	tblObservations	METINGCODE 150
Matrix	Added codelist options	Change	Lookupvalue	tblWatersamples	WsMatrix
Mesh size (mm)	Field for the mesh size of a monitoring well filter	Add	Float	tblFiltertubes	FtMeshSize
Type	Project level	New codelist options	Change	Lookupvalue	tblProjects	PrType
Type	Finishing level	New codelist options	Change	Lookupvalue	tblFinishings	FiType
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)
Pumped volume series	Field for the total pumped volume during a single series	Add	Float	tblObservations	METINGCODE 152 (Series), METINGCODE 151 (Stable value)

22-11-2021:

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
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
Measurement Point	Diameter	Diameter (mm)	Diameter (mm)	Information is available on layer level, but may sometimes be consistent over the entire measurement point	Add	Integer	tblMeasurementPoints	MpDiameter
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
Water samples	Surrounding humidity	Omgevingsvochtigheid	Licht vochtig, Zeer vochtig, Vochtig op bodem, Vochtig op plaatsen	The circumstances when sampling	Add	Codelist	tblObservations tblWatersampleMeasurements	Metingcode: 147 / WsSurroundingHumidity

18-10-2021:

Labeltext in English	Remarks	Definition and process how this field will be used and when it will be filled.	Change/Add/Delete	DB Type (String (length) / Float / Lookupvalue / Integer / DateTime)	DBTable in dsFieldProject	DBFieldname in dsFieldProject
StreamlineGUID	Does not have to be unique	To facilate synchronisation between Streamline and Classic	Add	Unique identifier	tblProjects	PrStreamlineGUID
StreamlineGUID	Does not have to be unique	To facilate synchronisation between Streamline and Classic	Add	Unique identifier	tblMeasurementPoint	MpStreamlineGUID
StreamlineGUID	Does not have to be unique	To facilate synchronisation between Streamline and Classic	Add	Unique identifier	tblWaterSample	WsStreamlineGUID
StreamlineGUID	Does not have to be unique	To facilate synchronisation between Streamline and Classic	Add	Unique identifier	tblFiltertubes	FtStreamlineGUID
StreamlineGUID	Does not have to be unique	To facilate synchronisation between Streamline and Classic	Add	Unique identifier	tblLayers	LaStreamlineGUID
StreamlineGUID	Does not have to be unique	To facilate synchronisation between Streamline and Classic	Add	Unique identifier	tblJars	JrStreamlineGUID
PackagingStreamlineGUID	Does not have to be unique	To facilate synchronisation between Streamline and Classic	Add	Unique identifier	tblJars	JrPackagingStreamlineGUID
StreamlineGUID	Does not have to be unique	To facilate synchronisation between Streamline and Classic	Add	Unique identifier	tblFinishings	FiStreamlineGUID
StreamlineGUID	Does not have to be unique	To facilate synchronisation between Streamline and Classic	Add	Unique identifier	tblBottles	BoStreamlineGUID
StreamlineGUID	Does not have to be unique	To facilate synchronisation between Streamline and Classic	Add	Unique identifier	tblLocations	LcStreamlineGUID
StreamlineGUID	Does not have to be unique	To facilate synchronisation between Streamline and Classic	Add	Unique identifier	tblSublocations	SlStreamlineGUID

07-10-2021:

Screen to add the extra field	Labeltext 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.	Change/Add/Delete	DB Type (String (length) / Float / Lookupvalue / Integer / DateTime)	DBTable in dsFieldProject	DBFieldname in dsFieldProject
Measurement Points Details	Sample Moisture	Monstervochtigheid	Dried out	Explains humidity condition of measurment point	Add Field	string (10)	tblMeasurementPoint	MpSampleHumidityCode
Air sample details	Special conditions	Bijzondere omstandigheden	Normal, used standard protocol	Description of deviation from protocol	Add Field	string (2000)	tblWaterSample	WsSpecialConditions
Air sample details	Field conditions	Maaiveld omstandigheden	Damp, easy to drill	Description of field/location at time of sampling	Add Field	string (2000)	tblWaterSample	WsFieldConditions
Air sample details	Calibration - O2	Kalibratie Zuurstof (%)	25%	Filled in when performing the leaking test before prepumping	Add Field	float	tblObservations/tblWatersampleMeasurements	Metingcode: 136 / WsCalibrationO2
Air sample details	Calibration - CO2	Kalibratie koolstofdioxine/CO2 (ppm)	25ppm	Filled in when performing the leaking test before prepumping	Add Field	float	tblObservations/tblWatersampleMeasurements	Metingcode: 137 / WsCalibrationCO2
Air sample details	Start-sampling time	Tijdstip start bemonstering	11:30:00	Time when the actual sampling has started	Add Field	datetime	tblWaterSample	WsStartSampleTime
Air sample details	Post-sampling time	Tijdstip einde monstername	11:30:00	Add Field	datetime	tblWaterSample	WsPostSampleTime
Air sample details	Post- sampling O2	Zuurstof einde monstername	25%	Add Field	float	tblObservations/tblWatersampleMeasurements	Metingcode: 140 / WsPostSampleO2
Air sample details	Post-sampling CO2	Koolstofdioxine/CO2 einde monstername (ppm)	25ppm	Add Field	float	tblObservations/tblWatersampleMeasurements	Metingcode: 141 / WsPostSampleCO2
Air sample details	Post-sampling air flow rate	Debiet einde monstername	0,3l/min	Add Field	float	tblObservations/tblWatersampleMeasurements	Metingcode: 142 / WsPostSampleFlowRate
Air sample details	Post-sampling PID	PID einde monstername	25ppm	Add Field	float	tblObservations/tblWatersampleMeasurements	Metingcode: 143 / WsPostSamplePID
Air sample details	Post-sampling temperature	Temperatuur einde monstername	25C	Add Field	float	tblObservations/tblWatersampleMeasurements	Metingcode: 144 / WsPostSampleTemperature
Air sample details	Post sampling air humidity	Vochtigheid einde monstername	25%	Add Field	float	tblObservations/tblWatersampleMeasurements	Metingcode: 145 / WsPostSampleHumidity
Air sample details	Post sampling air pressure	Luchtdruk einde monstername	25hPa	Add Field	float	tblObservations/tblWatersampleMeasurements	Metingcode: 146 / WsPostSamplePressure
Air samples Packaging	Sample type	Monstertype	regular sample/transport blind/environment blind	To select the type of support used in the sampling process	Add Field	lookupvalue	tblBottles	BoSampleTypeCode
Air samples Packaging	Reference number	Referentienummer	088D235D123	As secundary to barcode. Supports have both a barcode and a reference	Add Field	string (10)	tblBottles	BoReferenceNumber

6-8-2021:

Screen to add the extra field	Examples of values and how it should be printed in a report.	Labeltext in Dutch	Codelist CategoryID	Change/Add/Delete	DB Type (String (length) / Float / Lookupvalue / Integer / DateTime)	DBTable in dsFieldProject	DBFieldname in dsFieldProject
Watersample details	Diepte aanzuigpunt voorpompen	Add Field	Float	tblObservations/tblWatersampleMeasurements	Metingcode: 133/ WsPrepumpSuctionPointDepth
Watersample details	Ja/Nee	peilbuis drooggevallen bij voorpompen	26 (categoryID: 73)	Add Field	String (10)	tblObservations/tblWatersampleMeasurements	Metingcode: 134/ WsPrepumpFTDryCode
Watersample Reeksen	Ja/Nee	peilbuis drooggevallen bij voorpompen reeks	26 (categoryID: 73)	Add Field in Reeks interface	String (10)	tblObservations	Metingcode: 135
Watersample details	reden pompen beeindigd	518 (categoryID: 200)	Add Codelist item,	peilbuis is droog
Meetpunt details	reden boring gestopt	236 (categoryID: 236)	Add Codelist item	water aangetroffen

1-6-2021:

Screen to add the extra field	Labeltext of field in English	Definition and process how this field will be used and when it will be filled.	Codelist CategoryID	Change/Add/Delete	Labeltext in Dutch	Input type	DB Type (String (length) / Float / Lookupvalue / Integer / DateTime)	DBTable in dsFieldProject	DBFieldname in dsFieldProject
Layer Details	K qualification	they don't give any value to K but appreciations. Het is ook wel uit de Hoofdnaam met bijmengingen af te leiden, maar dat is niet handig. Op boorprofiel moet het getoond worden, dus graag als apart veld toevoegen. De k-waarde geeft de waterdoorlatendheid van de bodem of een constructie, de hydrologische conductiviteit. De k-waarde of doorlatendheidscoëfficiënt van zand kan horizontaal (kh) tot 50 m zijn en verticaal (kv) ca. 5 m per dag (etmaal), van klei en veen ca. 0,1 m per dag. doorlatendheid: (k-waarde in m/etmaal)	271	add	K kwalificatie	Codelist	String (10)	tblLayers	LaKQualificationCode
Layer description	colorimetric measurements (ppm	when PID gives strange values, colorimetric tube will be used. Values are always expressed in ppm Colorimetric measurements are made in the layer, at a certain depth. If the layer is large, several measurements will be taken. The number of measurements that need to be done per layer is at the discretion of the field worker. De colorimetric values shall be displayed in a graphic (in the same way as the PID graphic) in the drilling profile. Pid meting slaat uit, dan plaatsen ze een buisje om extra stoffen te meten. Is dus echt een aparte meting.	add	colorimetrische meting (ppm)	Float Input -> Same as PID	Float/Double	tblLayers	LaColometricValue
soil sample details	Soil Temperature (0C)	according to the Spanish law, they have to measure the temperature of the soil sample. The data has to be reported in their report (veldwerkoverzicht)	add	Temperatuur van het monster	Float Input -> Same as PID	Float/Double	tblJars	JrTemperatureSample
water sample details	Cleaned	Before taking a sample, the monitoring well may need to be cleaned (e.g. in case of sand trapping). At sample level, they can say whether the monitoring well has been cleaned (yes /no). If " yes", a new field " depth of the gauging tube after cleaning" shall appear. Overslaan, opgelost met als Diepte na schoonmaken gevuld is, dan is er ook schoongemaakt.	73	add	Schoongemaakt	Codelist	String (10)	METINGCODE	WsCleanedCode
water sample details	depth of gauging tube before cleaning (cm - ref)	shall appear if the feld "cleaning" is turned on. Appearing will be always, because the checkbox will be removed.	add	Diepte peilbuis voor schoonmaak	Float Input -> Same as diepte	Float/Double	METINGCODE	WsDepthBeforeCleaning
Water sample details	Replenishment	While purging, they have to indicate if the groundwater is coming back and how. If after few minutes it does not go back it means that the groundwater has dried.	270	add	Herstelsnelheid grondwater niveau	Codelist	String (10)	METINGCODE	WsReplenishmentCode
Soil Gaz sample details - stable	Lower Explosive Level (%)	parameter that need to be measured during soil gaz sampling, for security reasons STABLE VALUE!!	add	Lager explosief niveau (%)	Float Input -> Same as diepte	Float/Double	METINGCODE	WsLowerExplosiveLevel
Soil Gaz sample details - series	Lower Explosive Level (%) serie	parameter that need to be measured during soil gaz sampling, for security reasons SERIES VALUE!!	add	Lager explosief niveau (%) reeks	Float Input -> Same as diepte	Float/Double	METINGCODE	METINGCODE
Soil Gaz sample details - stable	H2S (ppm)	parameter that is also checked during the soil gaz purge. STABLE!!	add	H2S (ppm)	Float Input -> Same as diepte	Float/Double	METINGCODE	WsH2S
Soil Gaz sample details - series	H2S (ppm) serie	parameter that is also checked during the soil gaz purge. SERIES VALUE!!	add	H2S (ppm) reeks	Float Input -> Same as diepte	Float/Double	METINGCODE	METINGCODE
Water Sample - series	Turbidity serie	In France , Spain (and Germany) they don't use NTU to describe turbidity but appreciations The same appreciations that already exist for the feld "turbidiy" from Watersample should also exist for the series	252	add	Helderheid reeks	Codelist	String (10)	METINGCODE	METINGCODE

20-04-2021:

Change/Add/Delete	Remarks, Questions with answers and feedback of the status and the field info.	Labeltext in Dutch	CategoryID	Input type	DB Type	(String (length) / Float / Lookupvalue / Integer / DateTime)	tblObservations/	DBFieldname in dsFieldProject
Add	Monsternemer handtekening	signature	text	tblWaterSamples	WsSampletakerSignatureJPEG
Add	Handtekening datum	date time	datetime	tblWaterSamples	WsSampletakerSignatureTimestamp
Add	Gevalideerd	138	codelist	string()	tblWaterSamples	WsValidatedCode

06-04-2021

Change/Add/Delete	Remarks, Questions with answers and feedback of the status and the field info.	Labeltext in Dutch	CategoryID	Input type	DB Type	(String (length) / Float / Lookupvalue / Integer / DateTime)	dsTI DB Table	dsTI DB Columnname
Add	-	-	int	tblLocationVisits	LvID
Add	-	-	uniqueidentifier	tblLocationVisits	LvGuid
Add	-	-	int	tblLocationVisits	PrID
Add	The moment the fieldwork visited the location	Bezoek tijdstip	Date input	datetime	tblLocationVisits	LvVisitTimestamp
Add	Lucht Temperatuur (°C)	Number	float	tblLocationVisits	LvAirTemperature
Add	Luchtdruk (hPa)	Number	float	tblLocationVisits	LvAirPressure
Add	Luchtvochtigheid (%)	Number	float	tblLocationVisits	LvHumidity
Add	Windrichting (°)	Number	float	tblLocationVisits	LvWindDirectionDegrees
Add	Windrichting (Kompas)	264	codelist	String(10)	tblLocationVisits	LvWindDirectionPointCode
Add	Windkracht (m/s)	Number	float	tblLocationVisits	LvWindForce
Add	The weatherconditions during the visit to the location	Weersomstandigheden	Text input	String(2000)	tblLocationVisits	LvWeatherConditionsDescription
Add	nvt	datetime	tblLocationVisits	LvDateLastChanged

10-3-2021:

Change/Add/Delete	Remarks, Questions with answers and feedback of the status and the field info.	Labeltext in Dutch	CategoryID	Input type	DB Type	(String (length) / Float / Lookupvalue / Integer / DateTime)	DBTable in dsFieldProject	DBFieldname in dsFieldProject
Add	Een veld om aan te geven of het monster in het veld gemengd is in 1 verpakking.	Is veld mengmonster	boolean	tblAnalysisSamples	IsMixedFieldSample

18-1-2021:

Change/Add/Delete	Remarks, Questions with answers and feedback of the status and the field info.	Labeltext in Dutch	CategoryID	Input type	DB Type	(String (length) / Float / Lookupvalue / Integer / DateTime)	DBTable in dsFieldProject	DBFieldname in dsFieldProject
Add	We hebben een maaiveldtype per meetpunt, hierbij graag de mogelijkheid om de condities op te opgeven van het maaiveld.	Maaiveld omstandigheden	TextInput	String (2000)	tblMeasurementPoint	MpGroundLevelCondition
Add Observation	Totaal volume van het gepompte volume bij de monstername	Volume monstername (l)	Float	Float	tblObservations tblWatersampleMeasurements	WsSampledVolume/ Old metingcode: 109
Add Observation	Monstername methode kunnen opgeven	Monstername methode	259	Codelist	String(20)	tblObservations tblWatersampleMeasurements	WsSamplingMethodTypeCode/ Old metingcode: 110
Change	Aanpassen van deze meting naar een vaste eenheid: mg/l.	Zuurstof in mg/l	Float	Float	tblObservations tblWatersampleMeasurements	WsOxygen (Metingcode: 23 / Old metingcode: 12
Add Observation	Toevoegen van deze meting met een vaste eneheid: %.	Zuurstof in %	Float	Float	tblObservations tblWatersampleMeasurements	WsOxygenPercentage/ Old metingcode: 111
Add Observation	Toevoegen van deze Series meting met een vaste eenheid: %.	Reeks Zuurstof in %	Float	Float	tblObservations tblWatersampleMeasurements	METING CODE: 112
Add Observation	Toevoegen van deze meting met een vaste eneheid: ppm.	Koolstofdioxine/CO2 in ppm	Float	Float	tblObservations tblWatersampleMeasurements	WsCarbonDioxine / Old metingcode: 113
Add Observation	Toevoegen van deze Series meting met een vaste eenheid: ppm.	Reeks Koolstofdioxine/CO2 in ppm	Float	Float	tblObservations tblWatersampleMeasurements	METING CODE: 114
Add Observation	Toevoegen van deze meting met een vaste eneheid: %.	Vochtigheid in %	Float	Float	tblObservations tblWatersampleMeasurements	WsHumidityPercentage/ Old metingcode: 115
Add Observation	Toevoegen van deze Series meting met een vaste eenheid: %.	Reeks Vochtigheid in %	Float	Float	tblObservations tblWatersampleMeasurements	METING CODE: 116
Add Observation	Toevoegen van deze Series meting met een vaste eenheid: ppm.	Reeks PID in ppm	Float	Float	tblObservations tblWatersampleMeasurements	METING CODE: 117
Add Observation	Toevoegen van deze Series meting met een vaste eenheid: hPa.	Reeks Luchtdruk in hPa	Float	Float	tblObservations tblWatersampleMeasurements	METING CODE: 118
Change/Add/Delete	Remarks, Questions with answers and feedback of the status and the field info.	Labeltext in Dutch	CategoryID	DB Type	Table	Column
Add column	When a sample has a strong hydrocarbon odor a measure of Total Petroleum Hydrocarbons (TPH) is performed in the field with a PetroFLAG analyzer. This field is meant to register that value.	PetroFLAG® Analyzer (ppmv)	Float	tblJars	JrPetroFLAGAnalyzerValue
Add column	When changing a PID measurement to a sample, in case of a strange exceptional measured value, they will need to remeasure the pid value but also keep the original one that was taken during the PID measurement.	Afwijkende PID (ppm)	Float	tblJars	JrExceptionalPIDValue
Add Observation	Method used to remove the floating layer in the gauging tube	Drijflaag ophaal/verwijder systeem	260	String(10)	tblObservations	WsFloatingLayerRemoveMethodCode/Metingcode: 119
Add Observation	Type of operation that has been performed on the device used to remove the floating layer.	Uitgevoerde behandeling op drijflaag	261	String(10)	tblObservations	WsFloatingLayerSystemActionCode/Metingcode: 120
Add Observation	Sometimes an absorbtion stick is used to collect the floating layer in the Gauging tube. This parameter allows to indicate how saturated the absorbtion stick is after the procedure.	Saturatie absorberende staaf (%)	262	String(10)	tblObservations	WsSaturationAbsorptionStickCode/Metingcode: 121
Add Observation	Method used to clean the gauging tube.	Reiniging methode	257	String(10)	tblObservations	WsPurgeMethodCode/Metingcode: 122
Add Observation	When a gauging tube is purged, it can be done in two ways. Static: the intake depth is left at a set location. Dynamic: the hose intake depth is manually varied by moving the hose up and down.	Afpomp methode	263	String(10)	tblObservations	WsPurgeModeCode/Metingcode: 123
Add Observation	The total voltage that is measured on a water sample. So that is Redox + Standard. This is used in Germany to give adivice on the sample	Totale voltage (mV)	Float	tblObservations	WsTotalVoltage/Metingcode: 124

11-8-2020:

DSField Table	DSField Column	Field name in interface	Input type	Input Options example	Code categorie
tblMeasurementPoint	MpSoilDisposedCodeVarchar (10)	Soil disposal method	Lookup list	Transported to a appropriate treatment facility Stored in the CIW containers of the site Stored on site awaiting disposal Left on the ground on site Used to fill the borehole	256
tblFiltertubes	FtPurgeTechniqueCode Varchar(10)	Purge technique	Lookup list	Continuous water pumping Water pumping per level Alternate pumping (Shock) Swabbing and pumping Double air-lift Brushing and pumping Chemical treatment and pumping	257
tblFiltertubes	FtPurgeDuration Integer	Purga duration	Integer input
tblMeasurementPoint	MpDrillmasterSignatureJPEG Text (Base64 JPEG string)	Drillmaster signature	Signature input
tblMeasurementPoint	MpDrillmasterSignatureTimestamp DateTime	Signature timestamp	DateTime input

27-7-2020:

DSField Table	DSField Column	Field name in interface	Input type	Input Options example	Code categorie
tblBottle	BoFilteredTypeCode (int32)	Filter type	Lookup list	Folded filter Ground filter prefilter	255- Filtering method for the bottle
tblConcernedCompanies	CcChamberOfCommerceNr Varchar(50)	Chamber of Commerce Nr	-	-	-

10-7-2020:

DSField Table	DSField Column	Field name in interface	Input type	Input Options example	Code categorie
tblLabassignment	LbLabStatusCode (int32)	n/a	n/a	n/a	62 - Status van de labopdracht gerapporteerd door het lab (SIKB Lab status)

20-4-2020:

DSField Table	DSField Column	Field name in interface	Input type	Input Options example	Code categorie
tblMeasurementPoints	MpSortOrder	n/a	n/a	n/a	n/a
tblMeasurementPoints	MpInReports	Show in Reports	4 boolean	Yes/No	n/a
tblMeasurementPoints	MpOvamID	n/a	n/a	n/a	n/a
tblMeasurementPoints	MpInExports	Include in Exports	4 boolean	true/false	n/a
tblMeasurementPoints	MpUsedDevices	NL: Gebruikte apparaten EN: Used devices	tekst edit
tblFilterTubes	FtDecommissioned	Decommissioned	11 list	Yes/No	73
tblFilterTubes	FtDecommissionedDate	Decommission Date	2 date	date	n/a
tblJars	JrMatrixCode	Matrix	11 list	6
tblLayers	LaOvamID	n/a	n/a	n/a	n/a
tblLayers	LaSampleQualityClassCode	Sample quality class/ Monster kwaliteitsklasse	11 list	QM1, QM2, QM3, QM4, QM5	245
tblLayers	LaSecondaryBeddingTypeCode	Secundaire Gelaagdheid type	11 list	Grindlagen, Zandlagen, Siltlagen, Kleilagen, Veenlagen, Humuslagen, Detrituslagen, Schelpmateriaallagen, Bruinkoollagen.	247
tblLayers	LaSecondaryBeddingThicknessCode	Secundaire Gelaagdheid dikte	11 list	Dun gelamineerd (< 6 mm) Dik gelamineerd (6 tot 20 mm) Zeer dun gelaagd (20 tot 60 mm) Dun gelaagd (60 tot 200 mm)	243
tblLayers	LaSecondaryBeddingGradationCode	Secundaire gelaagdheid gradatie	11 list	Veel, Weinig	246
tblLayers	LaDisperseInhomogeneityCode	Disperse Inhomogeneity/ Disperse Inhomogeniteit	11 list	Veel grindlensjes, Weinig grindlensjes, Veel kleibrokken, Weinig kleibrokken, Veel kleilensjes, Weinig kleilensjes, Veel veenbrokken, Weinig veenbrokken, Veel zandlensjes, Weinig zandlensjes	248
tblLayers	LaDrillingProgressCode	DE: bohrfortschritt NL: boorvoortgang EN: drilling progress	11 list	sl - very easy to drill - 1m in 1-10 s. l - easy to drill - 1m in 10-30 s. m - medium difficulty to drill - 1m in 30 - 60 s. sl - difficult to drill - 1m in 1-2 min. ss - very difficult to drill - 1 m in > 2 min. BH - drilling obstacle kBf at ET - No drilling progress at final depth	249
tblWaterSamples	WsSortOrder	n/a	n/a	n/a	n/a
tblWaterSamples	WsInReports	Show in Reports	4 boolean	true/false	11
tblWaterSamples	WsOvamID	n/a	n/a	n/a	n/a
tblWaterSamples	WsInExports	Include in Exports	4 boolean	true/false	11
tblObservations (tblWaterSampleMeasurements)	NIEUWE OBSERVATION MetingType: 99	DE: Witterung nach KA5 NL: Weersomstandigheden EN: Weather conditions	11 list	WT1 WT2 WT3 WT4 WT5 WT6	251
tblObservations (tblWaterSampleMeasurements)	NIEUWE OBSERVATION MetingType: 98	DE: Standardspannung UB (mV) NL: Standaardspanning (mV) EN: Standard voltage (mV)	6 float
tblObservations (tblWaterSampleMeasurements)	NIEUWE OBSERVATION MetingType: 100	NL: Grondwaterstand na voorpompen (cm-ref) EN: Groundwater level after prepump (cm -ref)	6 float
tblWaterSamples	WsUsedDevices	NL: Gebruikte apparaten EN: Used devices	tekst edit
tblProjects	PrReportName	Report Name	string
tblProjects	PrStartDate	Start Date	2 date
tblProjects	PrEndDate	End Date	2 date
tblProjects	PrConsultStartDate	Advice Start Date	2 date
tblProjects	PrConsultEndDate	Advice End Date	2 date
tblProjects	PrFieldworkStartDate	Fieldwork Start Date	2 date
tblProjects	PrFieldworkEndDate	Fieldwork End Date	2 date
tblProjects	PrGroundwaterFlowDirection	Groundwater Flow Direction (eenheid nakijken!)	6 float
tblProjects	PrGroundwaterDepth	Groundwater Depth (eenheid nakijken!)	6 float
tblProjects	PrOvamID	n/a	n/a	n/a	n/a
tblAnalysisSamples	AnSortOrder	n/a	n/a	n/a	n/a
tblAnalysisSamples	AnInReports	Show in Reports	4 boolean	true/false
tblAnalysisSamples	AnOvamID	n/a	n/a	n/a	n/a
tblAnalysisSamples	AnInExports	Include in Exports	4 boolean	true/false
tblJars	JrSampleHumidityCode	Sample Humidity/ Monstervochtigheid	11 list	Volledig uitgedroogd, Uitgedroogd, Veldvochtig	250

27 maart 2020:

tblMeasurementPoint	MpDescriptionQualityCode String(10)	Beschrijfkwaliteit	List (11)	1 - B1: Uitgebreide monsterbeschrijving 2 - B2: Standaard monsterbechrijving 3 - B3: Verkennende monsterbeschrijving Verwijderde waardes: LET OP: Codeid 3 = 1 geworden, en 1 = 3 geworden 1 - klasse2geroerd 2 - klasse2ongedifferentieerd 3 - klasse2ongeroerd klasse3 nietGespecificeerd	239

18-Dec-2019

Additional BRO fields

Table DSField	Column DSField	Namefield in interface	Input type	Options	Code Category
tblMeasurementPoint	MpVerticalPositioningMethodCode String(10)	Precisie hoogte	List (11)	RTKGPS0tot4cm RTKGPS4tot10cm RTKGPS10tot20cm RTKGPS20tot100cm tachymetrie0tot10cm tachymetrie10tot50cm waterpassing0tot2cm waterpassing4tot10cm waterpassing2tot4cm	235
tblMeasurementPoint	MpStopCriterionCode String(10)	Reden boring gestopt	List (11)	beperkingTechnisch einddoel obstakelConstructie obstakelGrindStenen obstakelIJzervloer obstakelOnbekend obstakelPuin obstakelVastGesteente risico risicoGrondwaterdruk storingOrganisatorisch storingTechnisch werkwaterverlies onbekend	236
tblJars	JrSamplingQualityCode String(10)	Bemonsteringskwaliteit	List (11)	klasseA klasseB klasseC klasseD klasseE	237
tblJars	JrMethodCode String(10)	Bemonsteringsmethode	List (11)	graven opAfstandDroog opAfstandNat opDiepteGrijpen opDiepteKernen opDiepteLosroeren opDiepteUitsteken drukken hammeren	125 / Old: 40
tblMeasurementPoint	MpDescriptionQualityCode String(10)	Beschrijfkwaliteit	List (11)	klasse2geroerd klasse2ongedifferentieerd klasse2ongeroerd klasse3 nietGespecificeerd	239
tblMeasurementPoint	MpContinuouslySampledCode String(10)	Continu bemonsterd	List (11)	Ja Nee	73 / OLD: 26
tblMeasurementPoint	MpDescriptionLocationCode String(10)	Beschrijflocatie	List (11)	lab veld veldlab onbekend	240
tblMeasurementPoint	MpDescribedMaterialCode String(10)	Beschreven materiaal	List (11)	grond grondGesteente gesteente	241
tblLayers	LaUpperBoundaryDeterminationCode String(10)	Laagovergang bovenkant	List (11)	afgeleid afgeleidSondering voorbepaald waargenomenScherp waargenomenGeleidelijk waargenomenDiffuus waargenomenWillekeurig	242
tblLayers	LaLowerBoundaryDeterminationCode String(10)	Laagovergang onderkant	List (11)	afgeleid afgeleidSondering voorbepaald waargenomenScherp waargenomenGeleidelijk waargenomenDiffuus waargenomenWillekeurig	242
tblLayers	LaAnthropogenicCode String(10)	Antropogeen	List (11)	Ja Nee	73 / OLD: 26
tblLayers	LaBeddingCode String(10)	Gelaagdheid	List (11)	dunGelamineerd dikGelamineerd ergDunGelaagd dunGelaagd mmGelaagd cmGelaagd dmGelaagd	243
tblLayers	LaIsRootedCode String(10)	Beworteld	List (11)	Ja Nee	73 / OLD: 26
tblMeasurementPoint	MpCoordinatesTimestamp DateTime	Datum locatiebepaling	DateTimeEditor (13)
tblMeasurementPoint	MpBroID Varchar(50)	BRO-ID	textEditor (1)
tblLayers	LaTensileStrengthCode String(10)	Treksterkte	Lijst (11)	Geen sterkte Laag Matig Hoog	244

05-Aug-2019

Additional ISO14688 fields

Table DSField	Column DSField	Namefield in interface	Input type	Options	Code Category
Table DSField	Column DSField	Namefield in interface	Input type	Options	Code Category
tblLayers	LaTextureTertiaryCode String(10)	Tertiar	List (11)	Schelpfracties Glauconietkorrels IJzersulfiden Plantenresten Wortelresten Kalkhoudende concreties	226
tblLayers	LaTexturePlasticityCode String(10)	Plasticiteit	List (11)	Niet Weinig Matig Sterk	227
tblLayers	LaTextureGrainShapeCode String(10)	Korrelvorm	List (11)	Zeer Hoekig Hoekig Subhoekig Subrond Afgerond Zeer afgerond	228
tblLayers	LaTextureFormCode String(10)	Vorm	List (11)	Bol Plat Langwerpig	229
tblLayers	LaTextureSurfaceCode String(10)	Oppervlakte	List (11)	Ruw Glad	230
tblLayers	LaTextureParticleStrengthCode String(10)	Deeltjes Sterkte	List (11)	Extreem zwawk Zeer zwak Zwak Matig zwak Gemiddeld sterk Sterk Zeer sterk Extreem sterk	231
tblLayers	LaRockShapeCode String(10)	Steenvorm	List (11)	Molenstenen Schaalachtig Blokken	232
tblLayers	LaRockWeatheringCode String(10)	Steen Verwering	List (11)	Veranderde Gebarsten Fractured Gemalen	233

Contents

Documentation TerraIndex Export format - dsFieldProject.xsd

Documentation TerraIndex Export format - dsFieldProject.xsd

Changes and updates:

Documentation TerraIndex Export format - dsFieldProject.xsd