TerraIndex ReleaseNotes 

Page / - last modified by Bram Ardesch on 2023/05/23 16:11 

TerraIndex ReleaseNotes 
last modified by Bram Ardesch
on 2023/05/23 16:11

Table of Contents
Changes and updates:

Changes and updates:
26-07-2023
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	
Name inspector	 	Field where the name of the fieldworker that performed the field inspection can be selected.	Add	String	tblSublocations	SlNameInspector	
Coverage removed?	 	Yes/No field to indicate whether or not any vegetation was removed in order to perform a field inspection.	Add	Lookupvalue (73)	tblSublocations	SlCoverageRemoved	
Density (ton/m3)	 	Field where the name of the fieldworker that performed the field inspection can be selected.	Add	Float	tblLayers	LaDensity	
pH-value	 	Field to enter the measured Ph value of this soil layer. Often used to map out contamination from drug waste.	Add	Float	tblLayers	LaPhValue	
CH4 (ppm)	 	The CH4 (methane) value measured during the sampling of a soil air or ambient air sample. Measured in parts per million (ppm).	Add	Float	tblObservations	METINGCODE 162	
CO (ppm)	 	The CO (Carbonmonoxide) value measured during the sampling of a soil air or ambient air sample. Measured in parts per million (ppm).	Add	Float	tblObservations	METINGCODE 161	
CH4 (ppm) Series value	 	The CH4 (methane) value measured during the sampling of a soil air or ambient air sample. Measured in parts per million (ppm).	Add	Float	tblObservations	METINGCODE 162	
CO (ppm) Series value	 	The CO (Carbonmonoxide) value measured during the sampling of a soil air or ambient air sample. Measured in parts per million (ppm).	Add	Float	tblObservations	METINGCODE 161	
Reference of the Flow-measurement device	 	The reference number of the device used in this sampling of soil air.	Add	String	tblWatersamples	WsDebitReference	
Reference of the explosimeter	 	The reference number of the device used in this sampling of soil air.	Add	String	tblWatersamples	WsExplosimeterReference	
Reference of the barometer	 	The reference number of the device used in this sampling of soil air.	Add	String	tblWatersamples	WsBarometerReference	
Reference of the O2/ Co2 sensor	 	The reference number of the device used in this sampling of soil air.	Add	String	tblWatersamples	WsOxygenSensorReference	
Reference PID-instrument	 	The reference number of the device used in this sampling of soil air.	Add	String	tblWatersamples	WsPIDMeterReference	
Reference of the hygrometer	 	The reference number of the device used in this sampling of soil air.	Add	String	tblWatersamples	WsHygrometerReference	
Reference of the pump	 	The reference number of the device used in this sampling of soil air.	Add	String	tblWatersamples	WsPumpReference	
Drilling fluid used	 	If a fluid was used to aid the drilling, that fluid can be specified in this field. Required by Spanish ENAC standards.	Add	Lookupvalue (293)	tblMeasurementPoints	MpDrillingFluid	
Reference PID-instrument	 	The referencecode of the used PID-instrument.	Add	String	tblMeasurementPoints	MpPIDReference	
Gravel grain size from (mm)	 	The median of the type of gravel that has been used in the finishings of a filtertube.	Add	Float	tblFinishings	FiGravelSizeFrom	
Gravel grain size to (mm)	 	The median of the type of gravel that has been used in the finishings of a filtertube.	Add	Float	tblFinishings	FiGravelSizeTo	
Type of rod grease used	 	The type of grease used to connect different parts of the filtertubes.	Add	Lookupvalue (295)	tblFilterTubes	FtRodGrease	
Reference of the purging water filter	 	The reference number of the device used in this sampling of soil air.	Add	String	tblWatersamples	WsFilterReference	
Reference of the multi-parameter sensor	 	The reference number of the device used in this sampling of soil air.	Add	String	tblWatersamples	WsMultiParameterSensorReference	
Reference of the waterlevel sensor	 	The reference number of the device used in this sampling of soil air.	Add	String	tblWatersamples	WsGroundwaterSensorReference	
n/a	 	Technical field for the exchange of field samples (air / water)	Add	GUID	tblWatersamples	WsFieldSampleGuid	
Reason	 	Field t indicate the reason for starting the research	Add	Lookupvalue (294)	tblSummaryConclusion	SmReasonCode	
 	 	 	 	 	 	 	
05-04-2023
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	
HDOP	 	Precision value for the GPS coordinates.	Add	Float	tblMeasurementPoints	MpHDOP	
VDOP	 	Precision value for the GPS coordinates.	Add	Float	tblMeasurementPoints	MpVDOP	
PDOP	 	Precision value for the GPS coordinates.	Add	Float	tblMeasurementPoints	MpPDOP	
Number of satellites used	 	Field to note the amount of sattelites that where used for the GPS measurement in this measurement point.	Add	Integer	tblMeasurementPoints	MpNumberOfSatellites	
HRMS	 	Precision value for the GPS coordinates.	Add	Float	tblMeasurementPoints	MpHRMS	
VRMS	 	Precision value for the GPS coordinates.	Add	Float	tblMeasurementPoints	MpVRMS	
Gps pole height (m)	 	Field to fill in the height of the GPS pole	Add	Float	tblMeasurementPoints	MpGPSPoleHeight	
Antenna height (cm)	 	Field to fill in the height of the antenna on the GPS machine	Add	Float	tblMeasurementPoints	MpAntennaHeight	
Weather conditions	 	Field to fill in the weather conditions during the drilling process	Add	Float	tblMeasurementPoints	MPWeatherConditions	
Ambient temperature (°C) 	 	Outside temperature during the drilling process	Add	Float	tblMeasurementPoints	MpAmbientTemperature	
CO (ppm)	 	Field to save the measurement of carbon monoxide in the layer	Add	Float	tblLayers	LaCO	
Oxygen (%)	 	Field to save the measurement of oxygen in the layer	Add	Float	tblLayers	LaOxygenPercentage	
H2S (ppm)	 	Field to save the measurement of hydrogen sulfide in the layer	Add	Float	tblLayers	LaH2S	
LEL (%)	 	Field the save the lower explosive level measurement in the layer	Add	Float	tblLayers	LaLEL	
Inspectie efficiency (%)	 	The amount of soil in the layer that was able to be inspected properly for the purpose of asbestos research.	Add	Float	tblLayers	LaInspectionEfficiencyPercentage	
Mixing of soil	 	Field to denote the amount of mixing in this soil layer	Add	Integer (codelist 291)	tblLayers	LaDegreeOfSoilMixingCode	
CO (ppm)	 	Field to save the measurement of carbon monoxide in the air sample	Add	Float	tblObservations	METINGCODE 161	
Jar type	 	Soil sample ring added to the codelist	Add codelist value	 	 	 	
25-11-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	
Status	 	This field is for planned measurement points, and can be used to determine the status (to be done, done, removed etc)	Add	Lookup value (codelist 289)	tblMeasurementPoints	MpStatusCode	
Penetrometer compaction strength (kg/cm2)	 	This field is a numeric field for field tests to determine the compaction strength of the soil	Add	numberfield	tblMeasurementPoints	MpPenetrometerCompaction	
Accreditation number	 	This field can be used to fill in the accreditation number of the fieldworker, which needs to be filled in by walloon customers	Add	text field (30)	tblMeasurementPoints	MpAccreditationNumber	
Moisture Class Soil	 	This field is for giving moisture classes in soil, these are present in the NEN 6693 and also used for french research.	Add	Lookup value (codelist 290)	tblLayers	LaMoistureClass	
Sediment Sump Length (cm)	 	Field to input the length within the tube that is used as a sand / silt catchment below the filter	Add	numberfield	tblFilterTubes	FtSedimentSumpLength	
Length / Width	Multi edit turned on in grid vierw	 	Change	numberfield	tblMeasurementPoints	MpTrialPitLength & MpTrialPitWidth	
Length / Width	Multi edit turned on in grid vierw	 	Change	numberfield	tblLayers	LaTrialPitLength & LaTrialPitWidth	
Initial function	 	Field to input the function of the filtertube when it was installed	Add	Lookup value (codelist 288)	tblFilterTubes	FtInitialFiltertubeFunction	
Weather conditions	 	Remarkable weather conditions can be noted here as part of a location inspection	Add	String	tblSublocations	SlCoverRatePostRemoval	
Sampling procedure	 	Field to fill in the used sampling procedure	Add	Lookup value (codelist 287)	tblWatersamples	WsSamplingProcedure	
Starttime & Endtime sampling	Already existed for airsamples, no as well for watersamples	 	Change	Datetime	tblWatersamples	WsStartSampleTime & WsPostSampleTime	
Radioactive ionisation (cps)	 	Numberfield to input the cps (counts per second) of a meter that reacts to ionisation (like a geiger counter)	Add	numberfield	tblJars	JrIonisationCount	
Sample water content (%)	 	Percentage field for sample humidity	Add	numberfield	tblJars	JrHumidityPercentage	
Volume weight dry Yd (Kn/M3)	 	Geotechnical field for the dry weight of the sample, different unit than the other weight sample fields which are more simplistic	Add	numberfield	tblJars	JrDryVolumeWeight	
Liquit limit water content (%)	 	The liquid limit used within the attenbergs limits	Add	numberfield	tblJars	JrLiquidLimit	
Plasticity index (%)	 	Geotechnical field for the plasticity index	Add	numberfield	tblJars	JrPlasticityIndex	
Semi-Solid limit (water content %)	 	The semi-solid limit used within the attenbergs limits	Add	numberfield	tblJars	JrSemiSolidLimit	
Plastic limit (water content %)	 	The plastic limit used within the attenbergs limits	Add	numberfield	tblJars	JrPlasticLimit	
Undrained shear strength (kPa)	 	The shear strength of the soil	Add	numberfield	tblJars	JrUndrainedShearStrength	
Void ratio (%)	 	The ratio of void (air) in the soil	Add	numberfield	tblJars	JrVoidRatio	
Saturation (%)	 	The percentage of moisture saturation in the soil	Add	numberfield	tblJars	JrSaturationPercentage	
Soil sampes (several fields)	Multi edit turned on	 	Change	 	tblJars	Several	
Destination Type	 	Field for destination type for the OVAM	Add	Lookup value (codelist 49)	tblProjects	PrDestinationType	
Groundwater vulnerability	 	Field for groundwater vulnerability for the OVAM	Add	Lookup value (codelist 92)	tblProjects	PrGroundwaterVulnerability	
Percentage Fractrion >20mm	 	Asbestos fields now als on layer level	Add	numberfield	tblLayers	LaCourseFractionPercentage	
Weight fraction >20 mm	 	Asbestos fields now als on layer level	Add	numberfield	tblLayers	LaCourseFractionWeight	
Weight fraction <20 mm	 	Asbestos fields now als on layer level	Add	numberfield	tblLayers	LaFineFractionWeight	
Type plate material	 	Asbestos fields now als on layer level	Add	Lookup value (281)	tblLayers	LaPlateMaterialTypeCode	
Number of pieces plate material	 	Asbestos fields now als on layer level	Add	numberfield	tbLLayers	LaPlateMaterialPieces	
Weight plate material (g)	 	Asbestos fields now als on layer level	Add	numberfield	tblLayers	LaPlateMaterialWeight	
Special component gradation	Add codelist "A little (bit of)"	 	Add Codelist value	 	 	 	
Sand sorting codes	Add extra sand and gravel sorting codes	 	Add Codelist value	 	 	 	
Geological interpretation	All new belgium geological interpretation options added	 	Add Codelist value	 	 	 	
End prepump citeria	New prepump ending condition added	 	Add Codelist value	 	 	 	
Finishing Type	Type 'Asfalt' added	 	Add Codelist value	 	 	 	
Project Type	New French Project types added	 	Add Codelist value	 	 	 	
Colour Type	Colour 'Pink' added	 	Add Codelist value	 	 	 	
Use of location	Additional location uses added	 	Add Codelist value	 	 	 	
03-08-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	
Special or invasive vegetation(1, 2, 3)	 	Field to note invasive species found on the release location. New codelist with species from the dutch invasive species list added.	Add	Lookup value (codelist 285)	tblSublocations	SlSpecialVegetationCode	
Sieved material inspection hole	 	Field to note the total amount of sieved material at the measurementpoint level of an asbestos inspection hole	Add	Float	tblMeasurementPoints	MpSievedMaterial	
Water depth (cm-gl)	 	Field to describe the column of water above the waterbed, if chosen not to add a water layer as the first layer.	Add	Float	tblMeasurementPoints	MpWaterDepth	
Special component in layer (mass%)	 	Can be used to note the total mass % of foreign (non-soil) material in a layer.	Add	Float	tblLayers	LaSpecialComponentPercent	
Suspected Asbestos pollution	 	Field by which a fieldworker can remark if a layer is suspect of containing asbestos	Add	Lookup value (codelist 73)	tblLayers	LaSuspectedAsbestosCode	
Measurement point type	New codelist options added	Canister, Ambient air measurement added	Change	Lookup value (codelist 24)	tblMeasurementpoints	MpTypeCode	
Reference plane	New codelist options added	Sea level added	Change	Lookup value (codelist 15)	tblMeasurementpoints	MpReferencePointTypeCode	
Finishing Type	New codelist options added	Surface box plasic, Surface box stainless steel added	Change	Lookup value (codelist 32)	tblFinishings	FiTypeCode	
Horizon	New codelist options added	Unit R0, Unit R1, Unit R2 added	Change	Lookup value (codelist 109)	tblLayers	LaHorizonCode	
Soil / Rock Type	New codelist options added	Granodiorite added	Change	Lookup value (codelist 163 and 35)	tblLayers	LaRockTypeCode	
Special component type	New codelist options added	Construction and demolition waste, Calcium nodules, calcium crusts, Stones >50MM added	Change	Lookup value (codelist 11)	tblLayers	LaSc1TypeCode	
Drilling System	New codelist options added	Tubed edelman, tubed pulse drill, tubed percussion gouge added	Change	Lookup value (codelist 23)	tblLayers	LaDrillingSystemTypeCode	
Clarity	New codelist options added	None, Low, medium, high clarity codes added	Change	Lookup value (codelist 252)	tblWatersamples	LaClarityCode	
Stop prepumping	New codelist options added	1x volume of drilling well + parameters stabilisation added	Change	Lookup value (codelist 200)	tblWatersamples	WsPrepumpingEndedTypeCode	
Sampling method	New codelist options added	multi support active sampling	Change	Lookup value (codelist 259)	tblWatersamples	WsSamplingMethodCode	
Placed in serie	New codelist options added	New codelist: Unique, in paralel, in series added	Change	Lookup value (codelist 284)	WsPackagings	BoPlacedInSerie	
Air sample Type	New codelist options added	Impregnated filter added	Change	Lookup value (codelist 272)	WsPackagings	BoSampleTypeCode	
Field matrix	New codelist options added	Waterbed (solid part) added	Change	Lookup value (codelist 6)	WsAnalysisSamples	MatrixTypeCode	
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