Attribute types (datatypes)#

Glossary#

AquiferMediaTypeValue#

Value from the AquiferMediaTypeValue controlled list of values.

AssessmentConfidence#

Value from the AssessmentConfidence controlled list of values.

AssessmentMethod#

Value from the AssessmentMethod controlled list of values.

Attachment#

File uploaded directly into Reportnet3. The file can have a maximum of 100 MB. The valid filename extensions are ‘pdf’ (Portable Document Format),’xlsx’ (Excel) or ‘docx’ (Word). In a WISE dataflow, files are always uploaded to the documentFile attribute of the Document table.

BiologicalQualityElement#

Value from the BiologicalQualityElement controlled list of values, which is a subset of the QualityElement controlled list of values.

ChemicalMatrixType#

Value from the ChemicalMatrixType controlled list of values.

ChemicalPurpose#

Value from the ChemicalPurpose controlled list of values.

ChemicalStatus#

Value from the ChemicalStatus controlled list of values.

ClassificationSystem #

Value from the ClassificationSystem controlled list of values. See https://dd.eionet.europa.eu/vocabulary/wise/ClassificationSystem

ConfidentialityStatus#

Value from the ConfidentialityStatus controlled list of values. [5] [6]

Country#

Value from the Country controlled list of values.

date#

Date in the format yyyy-mm-dd.

documentCode#

Character string following the wiseIdentifier syntax that uniquely identifies a document provided in a data delivery.

EcologicalStatus#

Value from the EcologicalStatus controlled list of values.

Email#

Character string with a maximum length of 250 characters. Validate using REGEX pattern.

EnvironmentalQualityStandard#

Value from the EnvironmentalQualityStandard controlled list of values.

ExemptionPeriod#

Value from the ExemptionPeriod controlled list of values.

ExemptionRationale#

Value from the ExemptionRationale controlled list of values.

ExemptionType#

Value from the ExemptionType controlled list of values.

Value from the GroundwaterSurfaceWaterLink controlled list of values.

gYear#

Gregorian year.

IdentifierScheme#

Value from the IdentifierScheme controlled list of values.

ImpactType#

Value from the ImpactType controlled list of values.

IntercalibrationType#

Value from the IntercalibrationType controlled list of values.

Language#

Value from the Language controlled list of values.
WISE dataflows use a subset of the ISO 639-2 alpha-3 code for the representation of names of languages [7]

LegislationLevelValue#

Value from the LegislationLevelValue controlled list of values.

Licence#

Value from the Licence controlled list of values.
Because all WFD datasets fall under the HVD regulation [8], the Licence options are:

LineString#

A LineString is a 1-dimensional line formed by a contiguous sequence of line segments. Each line segment is defined by two Point, with the end point of one segment forming the start point of the next segment. [3] [4]
In the WISE spatial datasets, a valid LineString is simple (does not have self-intersections), does not have zero-length line segments, and has 1 or more line segments.

LithologyValue#

Value from the LithologyValue controlled list of values. To be defined.

MitigationMeasure#

Value from the MitigationMeasure controlled list of values.

MixingZoneMeasure#

Value from the MixingZoneMeasure controlled list of values.

MonitoringCycle#

Value from the MonitoringCycle controlled list of values.

MonitoringFrequency#

Value from the MonitoringFrequency controlled list of values.

MultiLineString#

A MultiLineString is a collection of LineString. [3] [4]

MultiPoint#

A MultiPoint is a collection of Points. [3] [4]

MultiPolygon#

A MultiPolygon is a collection of non-overlapping, non-adjacent Polygon. Polygons in the collection may touch only at a finite number of points. [3] [4]

NaturalAWBHMWB#

Value from the NaturalAWBHMWB controlled list of values.

nonNegativeValue#

Non-negative numeric value.

ObservationStatus#

Value from the ObservationStatus controlled list of values.

Parameter#

Value from the Parameter controlled list of values. Depending of the scope in which it is being used, the subset of allowed values may be restricted by the quality control.

Percentage#

Integer value in the interval [0,100].

PercentageInterval#

Value from the PercentageInterval controlled list of values.

Point#

A Point is a 0-dimensional geometry that represents a single location in coordinate space. A Point has an x-coordinate value, a y-coordinate value. [3] [4]
In the WISE spatial datasets, a valid point does not have a z-coordinate value.

Polygon#

A Polygon is a 2-dimensional planar region, delimited by an exterior boundary (the shell) and zero or more interior boundaries (holes). Each boundary is a LinearRing (a closed simple LineString). [3] [4]

PressureAssessmentMethod#

Value from the PressureAssessmentMethod controlled list of values.

PressureType#

Value from the PressureType controlled list of values.
This is a hierarchical list.

QualityElement#

Value from the QualityElement controlled list of values, which is a subset of the Parameter controlled list of values.

QuantitativeStatus#

Value from the QuantitativeStatus controlled list of values.

range#

Range of values. The data type follows the Postgre range type implementation of the ISO 80000-2:2019(E) standard. [1] [2]

ReasonForFailure #

Value from the ReasonForFailure controlled list of values.

referenceCode#

Character string following the wiseIdentifier syntax that uniquely identifies a document reference (e.g. a chapter, bookmark, page, etc.) within a document provided in a data delivery.

ReservoirType#

Value from the ReservoirType controlled list of values.

Role#

Value from the Role controlled list of values.

SpecialisedZoneType#

Value from the SpecialisedZoneType controlled list of values.

string#

Character string. A maximum of 4000 characters is allowed, unless otherwise specified by indicating the number of characters. UTF8 encoding is mandatory.

UnitOfMeasure#

Value from the UnitOfMeasure controlled list of values.

URL#

Character string with a maximum of 2100 characters. Validate using REGEX pattern.

VolumeRevenueCost#

Value from the VolumeRevenueCost controlled list of values.

WaterBodyCategory#

Value from the WaterBodyCategory controlled list of values.

WFDMonitoringPurpose#

Value from the WFDMonitoringPurpose controlled list of values.

WFDWaterService#

Value from the WFDWaterService controlled list of values.

WiseEvolutionType#

Value from the WiseEvolutionType controlled list of values.

wiseIdentifier#

String with a maximum of 42 characters. A WISE identifier:

  • must start with the ISO 3166-1 alpha-2 country code, except for Greece (‘EL’) and the United Kingdom (‘UK’)

  • must use only upper case letters [A to Z] and digits [0 to 9]

  • may use the underscore character (‘_’) or the hyphen character (‘-‘) as separator characters within the identifier (but not immediately after the country code, and not at the end of the code)

  • must not have consecutive separator characters

  • be unique at national level, within the context to which they apply

Valid examples: FR123, FR1_XYZ1234_1, FR1-XYZ1234-1, FR1XYZ12341.
Invalid examples: FR1__XYZ1234__1, FRa123, FR123_.

WisePurposeOfCollectionValue#

Value from the WisePurposeOfCollectionValue controlled list of values.

YesNo#

Value from the YesNo controlled list of values.

YesNoNotApplicable#

Value from the YesNoNotApplicable controlled list of values.

YesNoRBMP#

Value from the YesNoRBMP controlled list of values.

YesNoUnknownInapplicable#

Value from the YesNoNotApplicable controlled list of values.

YesNoUnknownNotApplicableNotAssessed#

Value from the YesNoUnknownNotApplicableNotAssessed controlled list of values.

YesNoUnknownNotAssessed#

Value from the YesNoUnknownNotAssessed controlled list of values.

ZoneType#

Value from the ZoneType controlled list of values.

References#