Documentation Old TerraIndex Dump fromat - dsTerraIndex.xsd
Last modified by Robin Huisman on 2022/07/27 21:13
Of this format we won’t provide more information, because it’s in legacy state. So try to use the TerraIndex format in the other Chapter:
.
If you already use this format, we do provide you the updates and changes.
Changes and updates:
27-7-2022:
| dsTerraIndex | dsTerraIndex column name |
| ITWBMAM0 | StreamlineGUID |
| ITWBMLO0 | StreamlineGUID |
| ITWBMAN0 | StreamlineGUID |
| ITWBMAR0 | StreamlineGUID |
| TESTPROPERTIES | StreamlineGUID |
| TESTRESULTS | StreamlineGUID |
| TESTRESULTSTANDARDS | StreamlineGUID |
| ITWBMWA0 | AnStreamlineGUID |
| tblConcernedCompanies | StreamlineGUID |
14-04-2022:
| 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. | Codelist CategoryID | Change/Add/Delete | DB Type | dsTI DB Table | dsTI DB Columnname |
| Air Samples | Smoketube test | Rookbuis test | Smoke tube test result | 278 | Add | Lookupvalue | ITWBMWA0 | SmokeTubeTestCode |
| Layers | Discontinuity cause | Oorzaak Discontinuïteit | Discontinuity type | 279 | Add | Lookupvalue | ITWBMLA0 | DiscontinuityCauseCode |
| Filtertubes | BroID | BroID | BroID | - | Add | Varchar(50) | ITWBMPE0 | BroID |
| Soil samples | Weight fine fraction (kg) | Gewicht fijne fractie (kg) | This concerns the weight of the sieved fraction, which is distinct from the coarse fraction | Add | Float | ITWBMPO0 | WeightFractionFine | |
| Layers | Determination method of moisture | Vochtigheidsbepaling | 280 | Add | Codelist | IWTBMLA0 | FieldworkMoistureMethodCode | |
| Soil samples | Type of asbestos containing material | Type asbestverdacht materiaal | 281 | Add | Codelist | ITWBMPO0 | PlateMaterialTypeCode | |
| Soil samples | Thickness asbestos containing material (mm) | Dikte asbestverdacht materiaal (mm) | Thickness of the plate material in mm, needed to make the distinction of types of plate material | Add | Float | ITWBMPO0 | PlateMaterialThickness | |
| Water samples | Recommended prepump volume | Volume te voorpompen | Add | Float | ITWBMWA0 | RecommendedPrepumpVolume | ||
| Water samples | Tube flushing volume | Spoel volume (l) | Add | Float | ITWBMWA0 | TubeFlushVolume | ||
| Filtertubes | Filtertube leaktest | Lektest | 74 / old CategoryID 26 | Add | codelist (Yes / no) | ITWBMFT0 | LeakingtestCode | |
| Air samples | Precense of water | Water aanwezig | 74 / old CategoryID 26 | Add | codelist (Yes / no) | ITWBMWA0 | TubeDryCode | |
| Measurement point | Grondwaterstand aangetroffen? | Grondwaterstand aangetroffen? | 74/ old CategoryID 26 | Add | codelist (Yes / no) | ITWBMBB0 | GWSFoundCode | |
| Air sample | Benzene PID | Benzeen PID (ppm) | Add | float | ITWBMWA1 | - | ||
| Air sample | Lager explosief gehalte (vol %) | Lager explosief gehalte (vol %) | Add | float | ITWBMWA1 | - | ||
| Measurement point | Number of soil grabs | Aantal grepen | Add | Integer | ITWBMBO0 | GrabNumber | ||
| Air sample | Koolstofdioxine/CO2 ppm | CO2 (ppm) | Change | |||||
| Air sample | Koolstofdioxine/CO2 einde monstername (ppm) | CO2 (ppm) einde monstername | Change | |||||
| Soil samples | Weight debris (kg) | Gewicht grove fractie (kg) | OLD NAME | Change | Float | ITWBMPO0 | GewichtPuin | |
| Soil samples | Pieces of Asbestos | Aantal stukjes asbestverdacht materiaal | OLD NAME | Change | Integer | ITWBMPO0 | StukjesAsbest | |
| Soil samples | Weight asbestos | Gewicht asbestverdacht materiaal | OLD NAME | Change | Float | ITWBMPO0 | Gewichtasbest | |
| Soil samples | Weight sample (kg) | Total sample weight (kg) | Change label to make it more clear that it concerns the total weight of the sample | Change | Float | ITWBMPO0 | Gewichtmonster |
Changes and updates:
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. | Codelist CategoryID | Change/Add/Delete | DB Type | dsTI DB Table | dsTI DB Columnname |
| Soil samples | Length core sampler | Lengte steekbuis (mm) | Length core sampler (mm) | Add | Integer | ITWBMPO0 | LengthCoreSampler | |
| Measurement Point | Diameter | Diameter (mm) | Diameter (mm) | Add | Integer | ITWBMBO0 | Diameter | |
| Air Samples packaging | Placed in serie | In serie geplaatst | Yes/no | Add | Lookupvalue (Yes/No) | ITWBMFL0 | PlacedInSerie | |
| Water samples | Surrounding humidity | Omgevingsvochtigheid | Licht vochtig, Zeer vochtig, Vochtig op bodem, Vochtig op plaatsen | CategoryID 273 | Add | Codelist | ITWBMWA0 | Metingcode: Code 147 / SurroundingHumidity |
18-10-2021:
| Labeltext of field in English | 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 | (String (length) / Float / Lookupvalue / Integer / DateTime) | dsTI DB Table | dsTI DB Columnname |
| GUID | f622f6bb-8ea8-4ab3-b18c-bc8809b24d12 | The GUID will be primarily used for synchronization to and from Streamline, it will be self generated on object creation | Add | Unique identifier | ITWBMPR0 | StreamlineGUID |
| GUID | f622f6bb-8ea8-4ab3-b18c-bc8809b24d13 | The GUID will be primarily used for synchronization to and from Streamline, it will be self generated on object creation | Add | Unique identifier | ITWBMBO0 | StreamlineGUID |
| GUID | f622f6bb-8ea8-4ab3-b18c-bc8809b24d14 | The GUID will be primarily used for synchronization to and from Streamline, it will be self generated on object creation | Add | Unique identifier | ITWBMWA0 | StreamlineGUID |
| GUID | f622f6bb-8ea8-4ab3-b18c-bc8809b24d15 | The GUID will be primarily used for synchronization to and from Streamline, it will be self generated on object creation | Add | Unique identifier | ITWBMPE0 | StreamlineGUID |
| GUID | f622f6bb-8ea8-4ab3-b18c-bc8809b24d16 | The GUID will be primarily used for synchronization to and from Streamline, it will be self generated on object creation | Add | Unique identifier | ITWBMLA0 | StreamlineGUID |
| GUID | f622f6bb-8ea8-4ab3-b18c-bc8809b24d17 | The GUID will be primarily used for synchronization to and from Streamline, it will be self generated on object creation | Add | Unique identifier | ITWBMPO0 | StreamlineGUID |
| GUID | f622f6bb-8ea8-4ab3-b18c-bc8809b24d18 | The GUID will be primarily used for synchronization to and from Streamline, it will be self generated on object creation | Add | Unique identifier | ITWBMPO0 | PackagingStreamlineGUID |
| GUID | f622f6bb-8ea8-4ab3-b18c-bc8809b24d19 | The GUID will be primarily used for synchronization to and from Streamline, it will be self generated on object creation | Add | Unique identifier | ITWBMAF0 | StreamlineGUID |
| GUID | f622f6bb-8ea8-4ab3-b18c-bc8809b24d20 | The GUID will be primarily used for synchronization to and from Streamline, it will be self generated on object creation | Add | Unique identifier | ITWBMFL0 | StreamlineGUID |
| GUID | f622f6bb-8ea8-4ab3-b18c-bc8809b24d21 | The GUID will be primarily used for synchronization to and from Streamline, it will be self generated on object creation | Add | Unique identifier | ITWBMLC0 | StreamlineGUID |
| GUID | f622f6bb-8ea8-4ab3-b18c-bc8809b24d22 | The GUID will be primarily used for synchronization to and from Streamline, it will be self generated on object creation | Add | Unique identifier | ITWBMSL0 | StreamlineGUID |
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. | Codelist CategoryID | Change/Add/Delete | DB Type | dsTI DB Table | dsTI DB Columnname |
|---|---|---|---|---|---|---|---|---|
| Measurement Points Details | Sample Moisture | Monstervochtigheid | Dried out | 250 (categoryID: 250) | Add Field | string (10) | ITWBMBO0 | SampleHumidityCode |
| Air sample details | Special conditions | Bijzondere omstandigheden | Normal, used standard protocol | Add Field | string (2000) | ITWBMWA1 | SpecialConditions | |
| Air sample details | Field conditions | Maaiveld omstandigheden | Damp, easy to drill | Add Field | string (2000) | ITWBMWA1 | FieldConditions | |
| Air sample details | Calibration - O2 | Kalibratie Zuurstof (%) | 25% | Add Field | float | ITWBMWA1 | Metingcode: 136 / CalibrationO2 | |
| Air sample details | Calibration - CO2 | Kalibratie koolstofdioxine/CO2 (ppm) | 25ppm | Add Field | float | ITWBMWA1 | Metingcode: 137 / CalibrationCO2 | |
| Air sample details | Start-sampling time | Tijdstip start bemonstering | 11:30:00 | Add Field | datetime | ITWBMWA1 | StartSampleTime | |
| Air sample details | Post-sampling time | Tijdstip einde monstername | 11:30:00 | Add Field | datetime | ITWBMWA1 | WsPostSampleTime | |
| Air sample details | Post- sampling O2 | Zuurstof einde monstername | 25% | Add Field | float | ITWBMWA1 | Metingcode: 140 / PostSampleO2 | |
| Air sample details | Post-sampling CO2 | Koolstofdioxine/CO2 einde monstername (ppm) | 25ppm | Add Field | float | ITWBMWA1 | Metingcode: 141 / PostSampleCO2 | |
| Air sample details | Post-sampling air flow rate | Debiet einde monstername | 0,3l/min | Add Field | float | ITWBMWA1 | Metingcode: 142 / PostSampleFlowRate | |
| Air sample details | Post-sampling PID | PID einde monstername | 25ppm | Add Field | float | ITWBMWA1 | Metingcode: 143 / PostSamplePID | |
| Air sample details | Post-sampling temperature | Temperatuur einde monstername | 25C | Add Field | float | ITWBMWA1 | Metingcode: 144 / PostSampleTemperature | |
| Air sample details | Post sampling air humidity | Vochtigheid einde monstername | 25% | Add Field | float | ITWBMWA1 | Metingcode: 145 / PostSampleHumidity | |
| Air sample details | Post sampling air pressure | Luchtdruk einde monstername | 25hPa | Add Field | float | ITWBMWA1 | Metingcode: 146 / PostSamplePressure | |
| Air samples Packaging | Sample type | Monstertype | regular sample/transport blind/environment blind | 272 (categoryID: 272) | Add Field | lookupvalue | ITWBMFL0 | SampleTypeCode |
| Air samples Packaging | Reference number | Referentienummer | 088D235D123 | Add Field | string (10) | ITWBMFL0 | ReferenceNumber |
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) | dsTI DB Table | dsTI DB Columnname |
| Watersample details | Diepte aanzuigpunt voorpompen | Add Field | Float | ITWBMWA1 | Metingcode: 133 | ||
| Watersample details | Ja/Nee | peilbuis drooggevallen bij voorpompen | 26 (categoryID: 73) | Add Field | String (10) | ITWBMWA1 | Metingcode: 134 |
| Watersample Reeksen | Ja/Nee | peilbuis drooggevallen bij voorpompen reeks | 26 (categoryID: 73) | Add Field in Reeks interface | String (10) | ITWBMWA1 | Metingcode: 135 |
| Watersample details | reden pompen beeindigd | 518 (categoryID: 200) | Add Codelist item, zie tab: CategoryChanges | peilbuis is droog | |||
| Meetpunt details | reden boring gestopt | 236 (categoryID: 236) | Add Codelist item, zie tab: CategoryChanges | 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) | dsTI DB Table | dsTI DB Columnname |
| 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. | 271 | add | K kwalificatie | Codelist | String (10) | ITWBMLA0 | KQualificationCode |
| Layer description | colorimetric measurements (ppm | when PID gives strange values, colorimetric tube will be used. Values are always expressed in ppm 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 | ITWBMLA0 | ColometricValue | |
| 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 | ITWBMPO0 | TemperatureSample | |
| 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 | 125 |
| 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 | 126 | |
| 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 | 127 |
| 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 | 128 | |
| 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 | 129 | |
| 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 | 130 | |
| 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 | 131 | |
| 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 | 132 |
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 | LocationVisitID | |||
| Add | - | - | uniqueidentifier | tblLocationVisits | LocationVisitGUID | |||
| Add | - | - | int | tblLocationVisits | IDProject | |||
| Add | The moment the fieldwork visited the location | Bezoek tijdstip | Date input | datetime | tblLocationVisits | VisitTimestamp | ||
| Add | Lucht Temperatuur (°C) | Number | float | tblLocationVisits | AirTemperature | |||
| Add | Luchtdruk (hPa) | Number | float | tblLocationVisits | AirPressure | |||
| Add | Luchtvochtigheid (%) | Number | float | tblLocationVisits | Humidity | |||
| Add | Windrichting (°) | Number | float | tblLocationVisits | WindDirectionDegrees | |||
| Add | Windrichting (Kompas) | 264 | codelist | String(10) | tblLocationVisits | WindDirectionPointCode | ||
| Add | Windkracht (m/s) | Number | float | tblLocationVisits | WindForce | |||
| Add | The weatherconditions during the visit to the location | Weersomstandigheden | Text input | String(2000) | tblLocationVisits | WeatherConditionsDescription | ||
| Add | nvt | datetime | tblLocationVisits | DateLastChanged | ||||
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) | dsTI DB Table | dsTI DB Columnname |
| 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) | ITWBMBO0 | GroundLevelCondition | ||
| Add Observation | Totaal volume van het gepompte volume bij de monstername | Volume monstername (l) | Float | Float | ITWBMWA1 | METING CODE: 109 | ||
| Add Observation | Monstername methode kunnen opgeven | Monstername methode | 259 | Codelist | String(20) | ITWBMWA1 | METING CODE: 110 | |
| Change | Aanpassen van deze meting naar een vaste eenheid: mg/l. | Zuurstof in mg/l | Float | Float | ITWBMWA1 | METING CODE: 23 | ||
| Add Observation | Toevoegen van deze meting met een vaste eneheid: %. | Zuurstof in % | Float | Float | ITWBMWA1 | METING CODE: 111 | ||
| Add Observation | Toevoegen van deze Series meting met een vaste eenheid: %. | Reeks Zuurstof in % | Float | Float | ITWBMWA1 | METING CODE: 112 | ||
| Add Observation | Toevoegen van deze meting met een vaste eneheid: ppm. | Koolstofdioxine/CO2 in ppm | Float | Float | ITWBMWA1 | METING CODE: 113 | ||
| Add Observation | Toevoegen van deze Series meting met een vaste eenheid: ppm. | Reeks Koolstofdioxine/CO2 in ppm | Float | Float | ITWBMWA1 | METING CODE: 114 | ||
| Add Observation | Toevoegen van deze meting met een vaste eneheid: %. | Vochtigheid in % | Float | Float | ITWBMWA1 | METING CODE: 115 | ||
| Add Observation | Toevoegen van deze Series meting met een vaste eenheid: %. | Reeks Vochtigheid in % | Float | Float | ITWBMWA1 | METING CODE: 116 | ||
| Add Observation | Toevoegen van deze Series meting met een vaste eenheid: ppm. | Reeks PID in ppm | Float | Float | ITWBMWA1 | METING CODE: 117 | ||
| Add Observation | Toevoegen van deze Series meting met een vaste eenheid: hPa. | Reeks Luchtdruk in hPa | Float | Float | ITWBMWA1 | 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 | TI Table | TI 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 | ITWBMPO0 | PetroFLAGAnalyzerValue | |
| 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 | ITWBMPO0 | ExceptionalPIDValue | |
| Add Observation | Method used to remove the floating layer in the gauging tube | Drijflaag ophaal/verwijder systeem | 260 | String(10) | ITWBMWA1 | 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) | ITWBMWA1 | 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) | ITWBMWA1 | Metingcode: 121 |
| Add Observation | Method used to clean the gauging tube. | Reiniging methode | 257 | String(10) | ITWBMWA1 | 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) | ITWBMWA1 | 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 | ITWBMWA1 | Metingcode: 124 |
10-7-2020:
| DSField Table | DSField Column | Field name in interface | Input type | Input Options example | Code categorie |
| ITWBMFL0 | FilteredTypeCode (varchar (10)) | Filter type | Lookup list | Folded filter Ground filter prefilter | 255- Filtering method for the bottle |
| tblConcernedCompanies | ChamberOfCommerceNr Varchar(50) | Chamber of Commerce Nr |
20-4-2020:
| Tabel Database | Database Column Name | Column Type | Field name in interface | Input type | Input Options example | Code categorie |
| ITWBMBO0 | SORTORDER | integer | n/a | n/a | n/a | n/a |
| ITWBMBO0 | SHOW | boolean | Show in Reports | 4 boolean | Yes/No | n/a |
| ITWBMBO0 | OVAMID | integer | n/a | n/a | n/a | n/a |
| ITWBMBO0 | EXPORT | boolean | Include in Exports | 4 boolean | true/false | n/a |
| ITWBMBO0 | USEDDEVICES | varchar(2000) | NL: Gebruikte apparaten EN: Used devices | tekst edit | ||
| ITWBMPE0 | UITDIENST | varchar(1) | Decommissioned | 11 list | Yes/No | 73 |
| ITWBMPE0 | DATUITDNST | datetime | Decommission Date | 2 date | date | n/a |
| ITWBMPO0 | MATRIX | varchar(50) | Matrix | 11 list | 6 | |
| ITWBMLA0 | OVAMID | integer | n/a | n/a | n/a | n/a |
| ITWBMLA0 | SampleQualityClassCode | varchar(10) | Sample quality class/ Monster kwaliteitsklasse | 11 list | QM1, QM2, QM3, QM4, QM5 | 245 |
| ITWBMLA0 | SecondaryBeddingTypeCode | varchar(10) | Secundaire Gelaagdheid type | 11 list | Grindlagen, Zandlagen, Siltlagen, Kleilagen, Veenlagen, Humuslagen, Detrituslagen, Schelpmateriaallagen, Bruinkoollagen. | 247 |
| ITWBMLA0 | SecondaryBeddingThicknessCode | varchar(10) | 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 |
| ITWBMLA0 | SecondaryBeddingGradationCode | varchar(10) | Secundaire gelaagdheid gradatie | 11 list | Veel, Weinig | 246 |
| ITWBMLA0 | DisperseInhomogeneityCode | varchar(10) | 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 |
| ITWBMLA0 | DrillingProgressCode | varchar(10) | 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 |
| ITWBMWA0 | SORTORDER | integer | n/a | n/a | n/a | n/a |
| ITWBMWA0 | SHOW | boolean | Show in Reports | 4 boolean | true/false | 11 |
| ITWBMWA0 | OVAMID | integer | n/a | n/a | n/a | n/a |
| ITWBMWA0 | EXPORT | boolean | Include in Exports | 4 boolean | true/false | 11 |
| ITWBMWA1 | NIEUWE OBSERVATION MetingType: 98 | DE: Witterung nach KA5 NL: Weersomstandigheden EN: Weather conditions | 11 list | WT1 WT2 WT3 WT4 WT5 WT6 | 251 | |
| ITWBMWA1 | NIEUWE OBSERVATION MetingType: 99 | DE: Standardspannung UB (mV) NL: Standaardspanning (mV) EN: Standard voltage (mV) | 6 float | |||
| ITWBMWA1 | NIEUWE OBSERVATION MetingType: 100 | NL: Grondwaterstand na voorpompen (cm-ref) EN: Groundwater level after prepump (cm -ref) | 6 float | |||
| ITWBMWA0 | USEDDEVICES | varchar(2000) | NL: Gebruikte apparaten EN: Used devices | tekst edit | ||
| ITWBMPR0 | RAPNAAM | varchar(200) | Report Name | string | ||
| ITWBMPR0 | DATOPDS | datetime | Start Date | 2 date | ||
| ITWBMPR0 | DATOPDE | datetime | End Date | 2 date | ||
| ITWBMPR0 | DATADVS | datetime | Advice Start Date | 2 date | ||
| ITWBMPR0 | DATADVE | datetime | Advice End Date | 2 date | ||
| ITWBMPR0 | DATVLDS | datetime | Fieldwork Start Date | 2 date | ||
| ITWBMPR0 | DATVLDE | datetime | Fieldwork End Date | 2 date | ||
| ITWBMPR0 | GWFLOWDIRECTION | int | Groundwater Flow Direction (eenheid nakijken!) | 6 float | ||
| ITWBMPR0 | GWDEPTH | float | Groundwater Depth (eenheid nakijken!) | 6 float | ||
| ITWBMPR0 | OVAMID | integer | n/a | n/a | n/a | n/a |
| ITWBMAM0 | SORTORDER | integer | n/a | n/a | n/a | n/a |
| ITWBMAM0 | SHOW | boolean | Show in Reports | 4 boolean | true/false | |
| ITWBMAM0 | OVAMID | integer | n/a | n/a | n/a | n/a |
| ITWBMAM0 | EXPORT | boolean | Include in Exports | 4 boolean | true/false | |
| ITWBMPO0 | SampleHumidityCode | varchar(10) | Sample Humidity/ Monstervochtigheid | 11 list | Volledig uitgedroogd, Uitgedroogd, Veldvochtig | 250 |
27-3-2020
| ITWBMBO0 | DescriptionQualityCode VARCHAR(10) | Beschrijfkwaliteit | List (11) |
| 239 |
18-Dec-2019
Additional BRO fields
Database Table | Database Column name | Namefield in interface | Input type | Options | Code Category |
|---|---|---|---|---|---|
| ITWBMBO0 | VerticalPositioningMethodCode VARCHAR(10) | Precisie hoogte | List (11) |
| 235 |
| ITWBMBO0 | StopCriterionCode VARCHAR(10) | Reden boring gestopt | List (11)
|
| 236 |
| ITWBMPO0 | SamplingQualityCode VARCHAR(10) | Bemonsteringskwaliteit | List (11) |
| 237 |
| IITWBMPO0 | MethodCode | Bemonsteringsmethode | List (11) |
| 125 / Old: 40
|
| ITWBMBO0 | DescriptionQualityCode VARCHAR(10) | Beschrijfkwaliteit | List (11) |
| 239 |
| ITWBMBO0 | ContinuouslySampledCode String(10) | Continu bemonsterd | List (11) |
| 73 / OLD: 26 |
| ITWBMBO0 | DescriptionLocationCode VARCHAR(10) | Beschrijflocatie | List (11) |
| 240 |
| ITWBMBO0 | DescribedMaterialCode VARCHAR(10) | Beschreven materiaal | List (11) |
| 241 |
| ITWBMLA0 | UpperBoundaryDeterminationCode VARCHAR(10) | Laagovergang bovenkant | List (11) |
| 242 |
| ITWBMLA0 | LowerBoundaryDeterminationCode VARCHAR(10) | Laagovergang onderkant | List (11) |
| 242 |
| ITWBMLA0 | AnthropogenicCode String(10) | Antropogeen | List (11) |
| 73 / OLD: 26 |
| ITWBMLA0 | BeddingCode VARCHAR(10) | Gelaagdheid | List (11) |
| 243 |
| ITWBMLA0 | IsRootedCode String(10) | Beworteld | List (11) |
| 73 / OLD: 26 |
| ITWBMBO0 | CoordinatesTimestamp DateTime | Datum locatiebepaling | DateTimeEditor (13) | ||
| ITWBMBO0 | BroID Varchar(50) | BRO-ID | textEditor (1) |
| |
| ITWBMLA0 | TensileStrengthCode String(10) | Treksterkte | Lijst (11) |
| 244 |
05-Aug-2019
Additional ISO14688 fields
Database Table | Database Column name | Namefield in interface | Input type | Options | Code Category |
|---|
Database Table | Database Column name | Namefield in interface | Input type | Options | Code Category |
|---|---|---|---|---|---|
| ITWBMLA0 | TextureTertiaryCode String(10) | Tertiar | List (11) |
| 226 |
| ITWBMLA0 | TexturePlasticityCode String(10) | Plasticiteit | List (11) |
| 227 |
| ITWBMLA0 | TextureGrainShapeCode String(10) | Korrelvorm | List (11) |
| 228 |
| ITWBMLA0 | TextureFormCode String(10) | Vorm | List (11) |
| 229 |
| ITWBMLA0 | TextureSurfaceCode String(10) | Oppervlakte | List (11) |
| 230 |
| ITWBMLA0 | TextureParticleStrengthCode String(10) | Deeltjes Sterkte | List (11) |
| 231 |
| ITWBMLA0 | RockShapeCode String(10) | Steenvorm | List (11) |
| 232 |
| ITWBMLA0 | RockWeatheringCode String(10) | Steen Verwering | List (11) |
| 233 |