TerraIndex ReleaseNotes

Page / - dernière modification par Roelof Zwaan le 2023/07/24 15:58

TerraIndex ReleaseNotes

dernière modification par Roelof Zwaan

le 2023/07/24 15:58

Table des matières

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