EU Pollinator Hub

, ,
• •
Dataset Report
Unique identifier: PLLNT11.0.0
Title: Pollination
Long title: Data on economic dependence of pollination by animals in crops as well as observations of pollinators on plant species, inon economic dependence of pollination by animals in crops as well as observations of pollinators on plant species, in particular crops
Status: Quality Validated
Current Version: v. 1.0
Published: 2023-07-26
Reviewed by: Rubinigg Michael as Data scientist, San Martin Gilles as Data scientist
Citation proposal:
Michael Rubinigg 2023 Report of dataset Pollination, v. 1.0 [PLLNT11.0.0]. EU Pollinator Hub. [2025-07-06] app.pollinatorhub.eu
Compliance with FAIR* principles
Findable
Accessible
Interoperable
Reusable
See https://www.go-fair.org/fair-principles for more information about FAIR principles
Data Quality
Good

This document is published under the Creative Commons Attribution 4.0 International (CC BY 4.0) licence. This means that reuse is allowed, provided appropriate credit is given and changes are indicated.

Document history

Release

Version v. 1.0 released on 2023-07-26. Reviewed by Rubinigg Michael, San Martin Gilles.

Revision

Table 1. List of revisions made to the document. Identifier of revision (No); date of revision (Date); description of revision (Description); reason for revision (Reason).
No Date Description Reason
1 2023-07-26 00:07:00 Initial release. n/a

Abbreviations

EU
European Union
EUPH
EU Pollinator Hub
FAO
Food and Agriculture Organization of the United Nations
FAOSTAT
Statistical division of the Food and Agriculture Organization of the United Nations
GBIF
Global Biodiversity Information Facility
n.a.
not available

Executive summary

Data overview:

The dataset contains data on economic dependence of pollination by animals in crops as well as observations of pollinators on plant species, in particular crops.

Data value:

The dataset allows linkage between plants, pollinating animals, and human economic activities.

Data description:

The dataset contains 8 tables. Three tables provide a linkage between entities: Crop aggregate to single crop, single crop to plant species, pollinating insect to pollinated plant species. One table contains information on the economic impact of pollination on the economic value of crop production. Four tables contain references.

interactions.single.section-about.data-overview-application:

This data is suited for linking data from existing data hubs such as the Food and Agriculture Organization Corporate Statistical Database (FAOSTAT), national databases containing data on agricultural production, beekeeping and pesticide use, the Global Biodiversity Information Facility (GBIF) as well as data from scientific and technical publications. Possible research questions include the following:

  1. What is the economic impact of pollination by animals on the economic value of crop production in a given area and a given year?
  2. What is the economic value of beehive products relative to the economic value of pollination by animals for crop production in a given area and a given year?
  3. What is the proportion of agricultural land requiring pollination by animals in the total agricultural land in a given area and a given year?
  4. What is the average number of beehives in an area per unit of agricultural land requiring pollination in a given area and a given year?
  5. Which animals are potential pollinators of a given crop or a given plant species in an area?
  6. Which pollinating insects are potentially threatened due to the application of plant protection products on a crop in an area?

Unresolved issues:

n/a

Introduction

For a range of crops, pollinating insects are a crucial factor for productivity. Several databases for crop production and classification as well as animal and plant species taxonomy and occurrence exist. To our knowledge, however, there is no publicly available data hub, which allows direct linkage of crop production, plants, and insect pollinators. The currently available data in the dataset was obtained from professionally acquired and reviewed data sources such as the Food and Agriculture Organization Corporate Statistical Database (FAOSTAT) and the Global Biodiversity Information Facility (GBIF) as well as data from scientific and technical publications. Works by Klein et al. (Klein, et al., 2007) and Gallai et al. (Gallai, Salle, Settele, & Vaissière, 2009) were used as theoretical basis for the economic importance of pollinators for world crops. The present data set is incomplete and intended to be a starting point for further work (data collection, standardisation and harmonisation) on this topic.

Material and methods

Data acquisition

Data from the Food and Agriculture Organization Corporate Statistical Database (FAOSTAT), the statistical data website of the Food and Agriculture Organization of the United Nations (FAO), was obtained on March 29, 2022. Later versions of the database are therefore not considered. Data from scientific literature and images were acquired manually. Data from FAO is made available under the Creative Commons Attribution-NonCommercial-ShareAlike 3.0 IGO license (CC BY-NC-SA 3.0 IGO; https://creativecommons.org/licenses/by-nc-sa/3.0/igo). In addition to this license, some database specific terms of use are listed: https://www.fao.org/contact-us/terms/db-terms-of-use/en/.

Table 2. List of raw data and metadata files included in the dataset. Identifier of table row (No); name of the file (File); the type of the file (Type); file contains data (D); file contains metadata (M); date of upload of the file to the EU Pollinator Hub (Arrival); number of data points contained within the file (if applicable); uploaded file size.
No File Type D M Arrival Data points File size
1 crop_species.csv CSV - Comma seperated values Yes No 2025-01-27 17:01:43 480 10.27 KiB
2 insect_plant.csv CSV - Comma seperated values Yes No 2025-02-05 13:02:29 31,328 869.16 KiB
3 pollination_dependency.csv CSV - Comma seperated values Yes No 2025-01-27 16:01:02 1,980 20.20 KiB
4 imagelist.csv CSV - Comma seperated values Yes No 2025-01-27 16:01:24 208 2.71 KiB
5 Ecology.pdf Miscellaneous No Yes 2025-01-27 18:01:15 n/a 311.30 KiB
6 Ecology.R Miscellaneous No Yes 2025-01-27 18:01:30 n/a 21.44 KiB
7 images.zip Miscellaneous No Yes 2025-01-27 18:01:54 n/a 43.26 MiB

Data preparation

Raw data was rearranged and converted to CSV format using Excel (Microsoft Corporation, version 15.0.5293.1000) and subsequently imported for profiling into a MySQL database (Oracle Corporation) running in a XAMPP environment (BitRock, version 2.3.4). Data was exported from the MySQL database to CSV format using windows-1252 coding. Data for this dataset are stored CSV format. Three tables provide a linkage between entities: Crop aggregate to single crop (crop_aggregate), single crop to plant species (crop_species), pollinating insect to pollinated plant species (insect_plant). One table contains information on the economic impact of pollination on the economic value of crop production (pollination_dependency). Four tables contain specific references (ref_flag, ref_image, ref_source, ref_unit) used in this dataset. Data were explored using descriptive statistics. Metrics for selected key columns are reported.

Data validation

No data validation was performed.

Data analysis

Data analyses can be found in supplemental files Ecology.R and Ecology.pdf.

Data description

Dataset

Table 3. Summary of tables belonging to the dataset. Table row identifier (No); name of the table (Table); description of the table (Description).
No Table Description
1 Crop_species This table contains names of aggregates of crops as well as single crops traded on the world market provided by…
2 Insect_Plant This table contains data on documented faunistic observations of insect species on plant species, mainly crops, obtained from literature references…
3 Pollination_dependency This table contains data on the estimated range of production reduction without the presence of animal pollinators on crops, referred…
4 Imagelist This table contains information on images provided.
Table 4. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
interactions.single.uid PLLNT11.0.0
Title Pollination
Long title Data on economic dependence of pollination by animals in crops as well as observations of pollinators on plant species, inon economic dependence of pollination by animals in crops as well as observations of pollinators on plant species, in particular crops
Target IRI https://app.pollinatorhub.eu/dataset-discovery/PLLNT11.0.0
interactions.single.section-details.licence CC BY 4.0
DOI n/a
Created 2022-10-19
Published 2023-07-26
Contact n/a
Keywords n/a
Data collection years n/a
Regions, the data was collected in n/a
Abstract

The dataset contains data on economic dependence of pollination by animals in crops as well as observations of pollinators on plant species, in particular crops.
Table 5. Standardised metadata of the data provider Michael Rubinigg. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name Michael Rubinigg
Url
Acronym Visualife
IRI https://app.pollinatorhub.eu/data-providers/michael-rubinigg
Contact https://orcid.org/0000-0002-7061-920X https://www.linkedin.com/in/rubinigg/
Description

Tables

Crop_species

Table 6. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Unique identifier PLLNT11.CRPSP74.0
Name Crop_species
Target IRI https://app.pollinatorhub.eu/dataset-discovery/parts/PLLNT11.CRPSP74.0
Table Type File
Licence CC BY 4.0
Description

This table contains names of aggregates of crops as well as single crops traded on the world market provided by FAOSTAT and/or Klein and co-workers (2007). Plant species are identified by the access number of the accepted scientific name of the organism at the Global Biodiversity Information Facility (GBIF).

This table contains names of aggregates of crops as well as single crops traded on the world market provided by FAOSTAT and/or Klein and co-workers (2007). Plant species are identified by the access number of the accepted scientific name of the organism at the Global Biodiversity Information Facility (GBIF).

Metadata

• Gbif links to https://www.gbif.org/species/crop_species.Gbif

Table 7. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Column Description Datatype Descriptor Unit
CropId

Identifier of the crop.

 Integer number CropId [PLLNT11.CRPGG73.CRPID388]

n/a
SpeciesName

Name of the species.

 String dwc:scientificName [0.0.SCNTF503]

n/a
Gbif

GBIF identifier of the organism, accessible at https://www.gbif.org/species/.

 String dwc:taxonID [0.0.TXNID628]

n/a

Metadata of individual tables can be found in Annex 1.

Descriptive measures

Table 8. Content analysis of the table. Column name (Name); range of length of characters (Length); arithmetic mean of values in column (Mean); lowest value in column (Min); first quartile of values in column (Q1); median of values in column (Median); third quartile of values in column (Q3); highest value in column (Max); number of records (Total); number and percentage (between brackets) of all values containing NULL (Missing), the value 0 (Zero), exclusively blank characters (Blank), and of distinct values including NULL, Zero and blank (Distinct).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
CropId 1 - 3 98.1 2 47.25 100.5 148.5 194 160 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 160 ( 100.0% )
SpeciesName 10 - 42 n/a Vicia faba n/a n/a n/a Cucurbita ar… 160 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 159 ( 99.4% )
Gbif 33 - 37 n/a https://www.… n/a n/a n/a https://www.… 160 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 159 ( 99.4% )

Quality measures

Table 9. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
CropId
100.00%
100.00%
2 2
SpeciesName
100.00%
99.38%
Phaseolus vulgaris Pimpinella anisum
Gbif
100.00%
99.38%
https://www.gbif.org/species/5350452 https://www.gbif.org/species/8080300

Changes made to preparatory file

None

Changes made to data

None

Unresolved issues

None

Insect_Plant

Table 10. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Unique identifier PLLNT11.NSCTP75.0
Name Insect_Plant
Target IRI https://app.pollinatorhub.eu/dataset-discovery/parts/PLLNT11.NSCTP75.0
Table Type File
Licence CC BY 4.0
Description

This table contains data on documented faunistic observations of insect species on plant species, mainly crops, obtained from literature references and images from a photographer. The information on the Global Biodiversity Information Facility (GBIF) was used as taxonomic reference for all species referred to in this table.

This table contains data on documented faunistic observations of insect species on plant species, mainly crops, obtained from literature references and images from a photographer. The information on the Global Biodiversity Information Facility (GBIF) was used as taxonomic reference for all species referred to in this table.

Metadata

• InsectGbif links to https://www.gbif.org/species/InsectGbif • PlantGbif links to https://www.gbif.org/species/InsectGbif • ImageId links to imagelist.ImageId

Table 11. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Column Description Datatype Descriptor Unit
Id

Internal identifier of the record.

 Integer number pms:recordID [0.0.RCRDD344]

n/a
InsectValidName

Valid scientific name of the insect.

 String dwc:scientificName [0.0.SCNTF503]

n/a
InsectGbif

GBIF identifier (dwc:taxonID) of the insect, accessible at https://www.gbif.org/species/.

 Integer number dwc:resourceID [0.0.RSRCD790]

n/a
PlantValidName

Valid scientific name of the plant on which the insect has been observed on.

 String dwc:scientificName [0.0.SCNTF503]

n/a
PlantGbif

GBIF identifier (dwc:taxonID) of the plant, accessible at https://www.gbif.org/species/.

 Integer number dwc:relatedResourceID [0.0.RLTDR789]

n/a
PlantSynonymName

Synonym of the scientific name of the plant (dwc:relatedResourceID) used in the beexml:recordID.

 String dwc:verbatimIdentification [0.0.VRBTM484]

n/a
Country

Two-letter country code as defined in ISO 3166-1 in which the observation is reported.

 String dwc:countryCode [0.0.CNTRY736]

n/a
Nuts

NUTS area in which the observation is reported.

 String eurostat:nuts2021Code [0.0.NTSCD55]

n/a
Zip

Postcodes for the location in which the observation is reported.

 String eurostat:postcode [0.0.PSTCD378]

n/a
PlaceName

Name of the place in local language in which the observation is reported.

 String dwc:locality [0.0.LCLTY544]

n/a
Lau

LAU code of in which the observation is reported.

 String eurostat:lauCode [0.0.LCODE73]

n/a
WGS84_N

Latitude in WGS84 format of the position on which the observation is reported.

 String dwc:decimalLatitude [0.0.LTTDE333]

°
WGS84_E

Longitude in WGS84 format of the position on which the observation is reported.

 String dwc:decimalLongitude [0.0.LNGTD332]

°
Elevation

Elevation of the location in which the observation is reported.

 String pms:heightAboveMeanSeaLevel [0.0.HGHTB393]

m
DateFrom

Start date at which the observation is reported.

 String dwc:eventDate [0.0.VNTDT721]

n/a
DateTo

End date at which the observation is reported.

 String dwc:eventDate [0.0.VNTDT721]

n/a
TimeFrom

First time of the day at which the observation is reported.

 String dwc:eventDate [0.0.VNTDT721]

n/a
TimeTo

First time of the day at which the observation is reported.

 String dwc:eventDate [0.0.VNTDT721]

n/a
ImageId

Internal identifier of an image.

 String imageId [PLLNT11.0.PLLNT11.0.0.0.MGEID795]

n/a
InsectSynonymName

Synonym of the scientific name of the insect (dwc:resourceID) used in the beexml:recordID.

 String dwc:verbatimIdentification [0.0.VRBTM484]

n/a
Source

Literature rescource from which the data in the record was obtained.

 String dcterms:bibliographicCitation [0.0.BBLGR567]

n/a
interaction

The identifier for the relationship type (predicate) from the OBO Relations Ontology (RO) that connects the subject identified by dwc:resourceID to its object identified by dwc:relatedResourceID.

 String dwc:relationshipOfResourceID [0.0.RLTNS791]

n/a

Metadata of individual tables can be found in Annex 1.

Descriptive measures

Table 12. Content analysis of the table. Column name (Name); range of length of characters (Length); arithmetic mean of values in column (Mean); lowest value in column (Min); first quartile of values in column (Q1); median of values in column (Median); third quartile of values in column (Q3); highest value in column (Max); number of records (Total); number and percentage (between brackets) of all values containing NULL (Missing), the value 0 (Zero), exclusively blank characters (Blank), and of distinct values including NULL, Zero and blank (Distinct).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Id 1 - 4 712.5 1 356.25 712.5 1,068.75 1,424 1,424 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,424 ( 100.0% )
InsectValidName 11 - 28 n/a Adalia bipun… n/a n/a n/a Xylocopa vio… 1,424 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 266 ( 18.7% )
InsectGbif 36 - 36 n/a https://www.… n/a n/a n/a https://www.… 1,424 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 265 ( 18.6% )
PlantValidName 9 - 41 n/a Acer platan… n/a n/a n/a Vitis vinife… 1,424 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 263 ( 18.5% )
PlantGbif 36 - 36 n/a https://www.… n/a n/a n/a https://www.… 1,424 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 252 ( 17.7% )
PlantSynonymName 0 - 0 n/a n/a n/a n/a 1,424 1,424 ( 100.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.1% )
Country 0 - 2 n/a AT n/a n/a n/a IT 1,424 89 ( 6.3% ) 0 ( 0.0% ) 0 ( 0.0% ) 4 ( 0.3% )
Nuts 0 - 5 n/a AT22 n/a n/a n/a ITC18 1,424 93 ( 6.5% ) 0 ( 0.0% ) 0 ( 0.0% ) 15 ( 1.1% )
Zip 4 - 5 15,054.0 6,020 6,065 6,184 14,020 77,743 1,424 1,317 ( 92.5% ) 0 ( 0.0% ) 0 ( 0.0% ) 25 ( 1.8% )
PlaceName 0 - 28 n/a Absam n/a n/a n/a Zirl 1,424 1,317 ( 92.5% ) 0 ( 0.0% ) 0 ( 0.0% ) 25 ( 1.8% )
Lau 4 - 7 907,290.6 5,082 61,760 70,220 70,358 8,317,151 1,424 1,317 ( 92.5% ) 0 ( 0.0% ) 0 ( 0.0% ) 25 ( 1.8% )
WGS84_N 7 - 17 47.518415070000003 46.663673 47.1280745 47.29676385 48.45385 48.45385 1,424 1,382 ( 97.1% ) 0 ( 0.0% ) 0 ( 0.0% ) 15 ( 1.1% )
WGS84_E 7 - 18 11.7610757499999998 7.81893 7.81893 11.4849826 15.36796375 15.866698 1,424 1,382 ( 97.1% ) 0 ( 0.0% ) 0 ( 0.0% ) 15 ( 1.1% )
Elevation 3 - 4 626.4 144 354.25 640 650 2,250 1,424 1,356 ( 95.2% ) 0 ( 0.0% ) 0 ( 0.0% ) 22 ( 1.5% )
DateFrom 0 - 11 n/a 01.04.65 n/a n/a n/a May 1877 1,424 1,315 ( 92.3% ) 0 ( 0.0% ) 0 ( 0.0% ) 37 ( 2.6% )
DateTo 0 - 14 n/a 01.04.65 n/a n/a n/a September 20… 1,424 1,315 ( 92.3% ) 0 ( 0.0% ) 0 ( 0.0% ) 37 ( 2.6% )
TimeFrom 0 - 20 n/a 10:00 n/a n/a n/a sunrise (app… 1,424 1,377 ( 96.7% ) 0 ( 0.0% ) 0 ( 0.0% ) 14 ( 1.0% )
TimeTo 0 - 19 n/a 12:00 n/a n/a n/a sunset (app.… 1,424 1,377 ( 96.7% ) 0 ( 0.0% ) 0 ( 0.0% ) 14 ( 1.0% )
ImageId 1 - 2 7.0 1 3.5 7 10.5 13 1,424 1,411 ( 99.1% ) 0 ( 0.0% ) 0 ( 0.0% ) 14 ( 1.0% )
InsectSynonymName 0 - 25 n/a Andrena carb… n/a n/a n/a Tipula hortu… 1,424 1,334 ( 93.7% ) 0 ( 0.0% ) 0 ( 0.0% ) 20 ( 1.4% )
Source 0 - 2,647 n/a @article{gro… n/a n/a n/a article{sche… 1,424 13 ( 0.9% ) 0 ( 0.0% ) 0 ( 0.0% ) 36 ( 2.5% )
interaction 41 - 41 n/a http://purl.… n/a n/a n/a http://purl.… 1,424 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.1% )

Quality measures

Table 13. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Id
100.00%
100.00%
1 1
InsectValidName
100.00%
18.68%
Andrena bicolor Adalia bipunctata
InsectGbif
100.00%
18.61%
https://www.gbif.org/species/1356887 https://www.gbif.org/species/1043097
PlantValidName
100.00%
18.47%
Taraxacum officinale Ballota nigra
PlantGbif
100.00%
17.70%
https://www.gbif.org/species/5394163 https://www.gbif.org/species/2926894
PlantSynonymName
0.00%
0.07%
n/a n/a
Country
93.75%
0.28%
DE IT
Nuts
93.47%
1.05%
DE1 AT31
Zip
7.51%
1.76%
6020 6215
PlaceName
7.51%
1.76%
n/a Achental
Lau
7.51%
1.76%
70107 70901
WGS84_N
2.95%
1.05%
n/a 47.159483
WGS84_E
2.95%
1.05%
n/a 15.364551
Elevation
4.78%
1.54%
640 600
DateFrom
7.65%
2.60%
n/a 01.04.65
DateTo
7.65%
2.60%
n/a 01.04.65
TimeFrom
3.30%
0.98%
n/a 9:45
TimeTo
3.30%
0.98%
n/a 9:45
ImageId
0.91%
0.98%
1 1
InsectSynonymName
6.32%
1.40%
n/a Andrena saundersella
Source
99.09%
2.53%
@book{westrich_paul_wildbienen_1990, address = {Stuttgart, DEU}, edition = {2}, title = {Die {Wildbienen} {Baden}-{Württenbergs}. {Spezieller} {Teil}}, volume = {2}, isbn = {3-8001-3317-2}, language = {de}, publisher = {Ulmer}, author = {{Westrich, Paul}}, year = {1990}, } @incollection{free_john_brand_notitle_1970, address = {London, GBR}, edition = {1}, isbn = {0-12-266650-X}, booktitle = {Insect {Pollination} of {Crops}}, publisher = {Academic Press}, author = {{Free, John Brand}}, year = {1970}, pages = {271}, }
interaction
100.00%
0.07%
http://purl.obolibrary.org/obo/RO_0002618 http://purl.obolibrary.org/obo/RO_0002618

Changes made to preparatory file

None

Changes made to data

None

Unresolved issues

None

Pollination_dependency

Table 14. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Unique identifier PLLNT11.PLLNT76.0
Name Pollination_dependency
Target IRI https://app.pollinatorhub.eu/dataset-discovery/parts/PLLNT11.PLLNT76.0
Table Type File
Licence CC BY 4.0
Description

This table contains data on the estimated range of production reduction without the presence of animal pollinators on crops, referred to as pollination dependency. Data was obtained from Klein and co-workers (2007).

This table contains data on the estimated range of production reduction without the presence of animal pollinators on crops, referred to as pollination dependency. Data was obtained from Klein and co-workers (2007).

Metadata

• CropId links to crop_species.CropId

Table 15. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Column Description Datatype Descriptor Unit
CropId

Internal identifier of the crop.

 Integer number CropId [PLLNT11.CRPGG73.CRPID388]

n/a
ParentCropId

Internal crop identifier of the higher level aggregate.

 Integer number CropId [PLLNT11.CRPGG73.CRPID388]

n/a
Impact

Description of pollination dependency of the reported crop on nominal scale.

 String Text [0.0.TEXTA315]

n/a
DepFrom

Lower range of pollination dependency of the reported crop in the reported unit.

 Integer number Integer [0.0.NTGER313]

n/a
DepTo

Upper range of pollination dependency of the reported crop in the reported unit.

 Integer number Integer [0.0.NTGER313]

n/a
Unit

Unit in which the value is reported.

 String dwc:measurementUnit [0.0.NTNME87]

n/a
FaoItemCode
Integer number faostat:ItemCode [0.0.ITMCD423]

n/a
FaoItem
String faostat:ItemLabel [0.0.TMLBL425]

n/a
Source
String dcterms:bibliographicCitation [0.0.BBLGR567]

n/a
Annotation

Specific annotation on the record.

 String dwc:measurementRemarks [0.0.MSRMN780]

n/a

Metadata of individual tables can be found in Annex 1.

Descriptive measures

Table 16. Content analysis of the table. Column name (Name); range of length of characters (Length); arithmetic mean of values in column (Mean); lowest value in column (Min); first quartile of values in column (Q1); median of values in column (Median); third quartile of values in column (Q3); highest value in column (Max); number of records (Total); number and percentage (between brackets) of all values containing NULL (Missing), the value 0 (Zero), exclusively blank characters (Blank), and of distinct values including NULL, Zero and blank (Distinct).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
CropId 1 - 3 97.5 1 48.75 98.5 146.25 194 198 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 192 ( 97.0% )
ParentCropId 1 - 3 94.0 1 44 94 158 194 198 80 ( 40.4% ) 0 ( 0.0% ) 0 ( 0.0% ) 30 ( 15.2% )
Impact 5 - 11 n/a great n/a n/a n/a no increase 198 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 6 ( 3.0% )
DepFrom 1 - 2 22.9 0 1 10 40 90 198 19 ( 9.6% ) 13 ( 6.6% ) 0 ( 0.0% ) 6 ( 3.0% )
DepTo 1 - 3 46.8 0 9 39 89 100 198 19 ( 9.6% ) 13 ( 6.6% ) 0 ( 0.0% ) 6 ( 3.0% )
Unit 0 - 1 n/a n/a n/a n/a % 198 19 ( 9.6% ) 0 ( 0.0% ) 0 ( 0.0% ) 2 ( 1.0% )
FaoItemCode 2 - 4 474.6 89 249 423 567 2,613 198 111 ( 56.1% ) 0 ( 0.0% ) 0 ( 0.0% ) 83 ( 41.9% )
FaoItem 4 - 72 n/a Figs n/a n/a n/a Other nuts (… 198 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 190 ( 96.0% )
Source 38 - 38 n/a https://doi.… n/a n/a n/a https://doi.… 198 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.5% )
Annotation 0 - 178 n/a n/a n/a n/a Comodity con… 198 196 ( 99.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 2 ( 1.0% )

Quality measures

Table 17. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
CropId
100.00%
96.97%
24 1
ParentCropId
59.60%
15.15%
158 55
Impact
100.00%
3.03%
little no increase
DepFrom
90.40%
3.03%
1 0
DepTo
90.40%
3.03%
9 0
Unit
90.40%
1.01%
% null
FaoItemCode
43.94%
41.92%
211 711
FaoItem
100.00%
95.96%
Kola nuts Anise, badian, fennel, coriander
Source
100.00%
0.51%
https://doi.org/10.1098/rspb.2006.3721 https://doi.org/10.1098/rspb.2006.3721
Annotation
1.01%
1.01%
null Comodity consist of more than one crop species differing in pollination dependency. Quantities for each crop are unknown. No pollination dependence for the comodity can be given.

Changes made to preparatory file

None

Changes made to data

None

Unresolved issues

None

Imagelist

Table 18. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Unique identifier PLLNT11.RFMGS80.0
Name Imagelist
Target IRI https://app.pollinatorhub.eu/dataset-discovery/parts/PLLNT11.RFMGS80.0
Table Type File
Licence CC BY 4.0
Description

This table contains information on images provided.

This table contains information on images provided.

Metadata

None

Table 19. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Column Description Datatype Descriptor Unit
ImageId

Internal identifier of an image.

 Integer number imageId [PLLNT11.0.PLLNT11.0.0.0.MGEID795]

n/a
FileName

Name of the file.

 String Text [0.0.TEXTA315]

n/a
FileTitle

Title of the file describing the content.

 String Text [0.0.TEXTA315]

n/a
AuthorName

Name of the photographer.

 String dcterms:rightsHolder [0.0.RGHTS565]

n/a
DateTime

Date and time at which the image was taken.

 Date and Time dwc:eventDate [0.0.VNTDT721]

n/a
Bytes

File size in bytes.

 Integer number Integer [0.0.NTGER313]

n/a
WidthPx

Width of image in pixels.

 Integer number Integer [0.0.NTGER313]

n/a
HeightPx

Height of image in pixels.

 Integer number Integer [0.0.NTGER313]

n/a
CameraModel

Name of the camera model the image was taken with.

 String Text [0.0.TEXTA315]

n/a
Fstop

F-stop (ratio of the lens focal length to the diameter of the entrance pupil) of the camera.

 Decimal number DecimalNumber [0.0.DCMLN314]

n/a
ExposureSec

Exposure time in seconds of the camera.

 Decimal number DecimalNumber [0.0.DCMLN314]

n/a
IsoSpeed

ISO speed of the camera.

 Integer number Integer [0.0.NTGER313]

n/a
FocalLengtmm

Focal length in mm of the lens.

 Integer number Integer [0.0.NTGER313]

n/a
Flash

Information on the utilization of a flash.

 String Text [0.0.TEXTA315]

n/a
WGS84_N

Latitude in WGS 84 format of the position on which the image was taken.

 String dwc:decimalLatitude [0.0.LTTDE333]

°
WGS84_E

Longitude in WGS 84 format of the position on which the image was taken.

 String dwc:decimalLongitude [0.0.LNGTD332]

°

Metadata of individual tables can be found in Annex 1.

Descriptive measures

Table 20. Content analysis of the table. Column name (Name); range of length of characters (Length); arithmetic mean of values in column (Mean); lowest value in column (Min); first quartile of values in column (Q1); median of values in column (Median); third quartile of values in column (Q3); highest value in column (Max); number of records (Total); number and percentage (between brackets) of all values containing NULL (Missing), the value 0 (Zero), exclusively blank characters (Blank), and of distinct values including NULL, Zero and blank (Distinct).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
ImageId 1 - 2 7.0 1 3.5 7 10.5 13 13 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 13 ( 100.0% )
FileName 13 - 13 n/a 100000001.JP… n/a n/a n/a 100000013.JP… 13 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 13 ( 100.0% )
FileTitle 28 - 38 n/a Apis melifer… n/a n/a n/a Apis mellife… 13 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 13 ( 100.0% )
AuthorName 16 - 16 n/a Rubinigg Mic… n/a n/a n/a Rubinigg Mic… 13 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 7.7% )
DateTime 19 - 19 n/a 2012-05-30 1… n/a n/a n/a 2019-06-18 0… 13 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 13 ( 100.0% )
Bytes 7 - 7 3,473,759.0 2,535,424 2,701,312 3,256,320 3,971,072 5,390,803 13 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 12 ( 92.3% )
WidthPx 4 - 4 4,162.5 2,848 4,272 4,272 4,272 4,272 13 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 2 ( 15.4% )
HeightPx 4 - 5 5,919.1 2,848 2,848 2,848 2,848 42,772 13 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 2 ( 15.4% )
CameraModel 15 - 15 n/a Canon EOS 11… n/a n/a n/a Canon EOS 11… 13 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 7.7% )
Fstop 1 - 3 11.96 3.2 4.25 7.1 21.5 32 13 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 9 ( 69.2% )
ExposureSec 4 - 7 0.006154 0.0005 0.001125 0.0025 0.007125 0.04 13 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 8 ( 61.5% )
IsoSpeed 3 - 4 1,450.0 100 100 100 2,225 6,400 13 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 5 ( 38.5% )
FocalLengtmm 3 - 3 105.4 100 100 100 100 135 13 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 2 ( 15.4% )
Flash 20 - 20 n/a No flash, co… n/a n/a n/a No flash, co… 13 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 7.7% )
WGS84_N 0 - 0 n/a n/a n/a n/a 13 13 ( 100.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 7.7% )
WGS84_E 0 - 0 n/a n/a n/a n/a 13 13 ( 100.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 7.7% )

Quality measures

Table 21. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
ImageId
100.00%
100.00%
1 1
FileName
100.00%
100.00%
100000001.JPG 100000001.JPG
FileTitle
100.00%
100.00%
Apis mellifera on Castanea sativa Apis mellifera on Castanea sativa
AuthorName
100.00%
7.69%
Rubinigg Michael Rubinigg Michael
DateTime
100.00%
100.00%
2019-06-18 09:45:00 2019-06-18 09:45:00
Bytes
100.00%
92.31%
2535424 5390803
WidthPx
100.00%
15.38%
4272 2848
HeightPx
100.00%
15.38%
2848 42772
CameraModel
100.00%
7.69%
Canon EOS 1100D Canon EOS 1100D
Fstop
100.00%
69.23%
32 11
ExposureSec
100.00%
61.54%
0.0025 0.0005
IsoSpeed
100.00%
38.46%
100 800
FocalLengtmm
100.00%
15.38%
100 135
Flash
100.00%
7.69%
No flash, compulsory No flash, compulsory
WGS84_N
0.00%
7.69%
n/a n/a
WGS84_E
0.00%
7.69%
n/a n/a

Changes made to preparatory file

None

Changes made to data

None

Unresolved issues

None

References

There are no sources in the current document.

Annex 1: Table column reports

Table: Crop_species

Column: CropId

Table 22. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name CropId
Description

Identifier of the crop.
Data type Integer number
Descriptor CropId [UID:PLLNT11.CRPGG73.CRPID388]
Descriptor description

Identifier of the crop.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/PLLNT11.CRPGG73.CRPID388
Unit

n/a
Table 23. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
CropId 1 - 3 98.1 2 47.25 100.5 148.5 194 160 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 160 ( 100.0% )
Table 24. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
CropId
100.00%
100.00%
2 2

Continuous Data Distribution

Figure 1. Distribution of values in the column.

Outliers

Figure 2. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 3. Visualization of completeness of the data in the column.

Uniqueness

Figure 4. Visualization of uniqueness of the data in the column.

Column: SpeciesName

Table 25. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name SpeciesName
Description

Name of the species.
Data type String
Descriptor dwc:scientificName [UID:0.0.SCNTF503]
Descriptor description

A term from the Darwin Core standard:

The full scientific name, with authorship and date information if known. When forming part of a dwc:Identification, this should be the name in lowest level taxonomic rank that can be determined. This term should not contain identification qualifications, which should instead be supplied in the dwc:identificationQualifier term.
Descriptor target IRI http://rs.tdwg.org/dwc/terms/scientificName
Unit

n/a
Table 26. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
SpeciesName 10 - 42 n/a Vicia faba n/a n/a n/a Cucurbita ar… 160 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 159 ( 99.4% )
Table 27. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
SpeciesName
100.00%
99.38%
Phaseolus vulgaris Pimpinella anisum

Completeness

Figure 5. Visualization of completeness of the data in the column.

Uniqueness

Figure 6. Visualization of uniqueness of the data in the column.

Column: Gbif

Table 28. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name Gbif
Description

GBIF identifier of the organism, accessible at https://www.gbif.org/species/.
Data type String
Descriptor dwc:taxonID [UID:0.0.TXNID628]
Descriptor description

A term from the Darwin Core standard:

An identifier for the set of dwc:Taxon information. May be a global unique identifier or an identifier specific to the data set.
Descriptor target IRI http://rs.tdwg.org/dwc/terms/taxonID
Unit

n/a
Table 29. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Gbif 33 - 37 n/a https://www.… n/a n/a n/a https://www.… 160 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 159 ( 99.4% )
Table 30. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Gbif
100.00%
99.38%
https://www.gbif.org/species/5350452 https://www.gbif.org/species/8080300

Completeness

Figure 7. Visualization of completeness of the data in the column.

Uniqueness

Figure 8. Visualization of uniqueness of the data in the column.

Table: Insect_Plant

Column: Id

Table 31. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name Id
Description

Internal identifier of the record.
Data type Integer number
Descriptor pms:recordID [UID:0.0.RCRDD344]
Descriptor description

Unique sequence of integers associated with a record within a certain table.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.RCRDD344
Unit

n/a
Table 32. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Id 1 - 4 712.5 1 356.25 712.5 1,068.75 1,424 1,424 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,424 ( 100.0% )
Table 33. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Id
100.00%
100.00%
1 1

Continuous Data Distribution

Figure 9. Distribution of values in the column.

Outliers

Figure 10. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 11. Visualization of completeness of the data in the column.

Uniqueness

Figure 12. Visualization of uniqueness of the data in the column.

Column: InsectValidName

Table 34. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name InsectValidName
Description

Valid scientific name of the insect.
Data type String
Descriptor dwc:scientificName [UID:0.0.SCNTF503]
Descriptor description

A term from the Darwin Core standard:

The full scientific name, with authorship and date information if known. When forming part of a dwc:Identification, this should be the name in lowest level taxonomic rank that can be determined. This term should not contain identification qualifications, which should instead be supplied in the dwc:identificationQualifier term.
Descriptor target IRI http://rs.tdwg.org/dwc/terms/scientificName
Unit

n/a
Table 35. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
InsectValidName 11 - 28 n/a Adalia bipun… n/a n/a n/a Xylocopa vio… 1,424 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 266 ( 18.7% )
Table 36. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
InsectValidName
100.00%
18.68%
Andrena bicolor Adalia bipunctata

Completeness

Figure 13. Visualization of completeness of the data in the column.

Uniqueness

Figure 14. Visualization of uniqueness of the data in the column.

Column: InsectGbif

Table 37. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name InsectGbif
Description

GBIF identifier (dwc:taxonID) of the insect, accessible at https://www.gbif.org/species/.
Data type Integer number
Descriptor dwc:resourceID [UID:0.0.RSRCD790]
Descriptor description

A term from the Darwin Core standard:

An identifier for the resource that is the subject of the relationship.
Descriptor target IRI http://rs.tdwg.org/dwc/terms/resourceID
Unit

n/a
Table 38. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
InsectGbif 36 - 36 n/a https://www.… n/a n/a n/a https://www.… 1,424 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 265 ( 18.6% )
Table 39. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
InsectGbif
100.00%
18.61%
https://www.gbif.org/species/1356887 https://www.gbif.org/species/1043097

Completeness

Figure 15. Visualization of completeness of the data in the column.

Uniqueness

Figure 16. Visualization of uniqueness of the data in the column.

Column: PlantValidName

Table 40. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name PlantValidName
Description

Valid scientific name of the plant on which the insect has been observed on.
Data type String
Descriptor dwc:scientificName [UID:0.0.SCNTF503]
Descriptor description

A term from the Darwin Core standard:

The full scientific name, with authorship and date information if known. When forming part of a dwc:Identification, this should be the name in lowest level taxonomic rank that can be determined. This term should not contain identification qualifications, which should instead be supplied in the dwc:identificationQualifier term.
Descriptor target IRI http://rs.tdwg.org/dwc/terms/scientificName
Unit

n/a
Table 41. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
PlantValidName 9 - 41 n/a Acer platan… n/a n/a n/a Vitis vinife… 1,424 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 263 ( 18.5% )
Table 42. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
PlantValidName
100.00%
18.47%
Taraxacum officinale Ballota nigra

Completeness

Figure 17. Visualization of completeness of the data in the column.

Uniqueness

Figure 18. Visualization of uniqueness of the data in the column.

Column: PlantGbif

Table 43. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name PlantGbif
Description

GBIF identifier (dwc:taxonID) of the plant, accessible at https://www.gbif.org/species/.
Data type Integer number
Descriptor dwc:relatedResourceID [UID:0.0.RLTDR789]
Descriptor description

A term from the Darwin Core standard:

An identifier for a related resource (the object, rather than the subject of the relationship).
Descriptor target IRI http://rs.tdwg.org/dwc/terms/relatedResourceID
Unit

n/a
Table 44. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
PlantGbif 36 - 36 n/a https://www.… n/a n/a n/a https://www.… 1,424 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 252 ( 17.7% )
Table 45. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
PlantGbif
100.00%
17.70%
https://www.gbif.org/species/5394163 https://www.gbif.org/species/2926894

Completeness

Figure 19. Visualization of completeness of the data in the column.

Uniqueness

Figure 20. Visualization of uniqueness of the data in the column.

Column: PlantSynonymName

Table 46. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name PlantSynonymName
Description

Synonym of the scientific name of the plant (dwc:relatedResourceID) used in the beexml:recordID.
Data type String
Descriptor dwc:verbatimIdentification [UID:0.0.VRBTM484]
Descriptor description

A term from the Darwin Core standard:

A string representing the taxonomic identification as it appeared in the original record.
Descriptor target IRI http://rs.tdwg.org/dwc/terms/verbatimIdentification
Unit

n/a
Table 47. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
PlantSynonymName 0 - 0 n/a n/a n/a n/a 1,424 1,424 ( 100.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.1% )
Table 48. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
PlantSynonymName
0.00%
0.07%
n/a n/a

Data Distribution Top 20

Figure 21. Distribution of 20 most common values, from highest to lowest.

Completeness

Figure 22. Visualization of completeness of the data in the column.

Uniqueness

Figure 23. Visualization of uniqueness of the data in the column.

Column: Country

Table 49. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name Country
Description

Two-letter country code as defined in ISO 3166-1 in which the observation is reported.
Data type String
Descriptor dwc:countryCode [UID:0.0.CNTRY736]
Descriptor description

A term from the Darwin Core standard:

The standard code for the country in which the dcterms:Location occurs.
Descriptor target IRI http://rs.tdwg.org/dwc/terms/countryCode
Unit

n/a
Table 50. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Country 0 - 2 n/a AT n/a n/a n/a IT 1,424 89 ( 6.3% ) 0 ( 0.0% ) 0 ( 0.0% ) 4 ( 0.3% )
Table 51. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Country
93.75%
0.28%
DE IT

Data Distribution Top 20

Figure 24. Distribution of 20 most common values, from highest to lowest.

Completeness

Figure 25. Visualization of completeness of the data in the column.

Uniqueness

Figure 26. Visualization of uniqueness of the data in the column.

Column: Nuts

Table 52. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name Nuts
Description

NUTS area in which the observation is reported.
Data type String
Descriptor eurostat:nuts2021Code [UID:0.0.NTSCD55]
Descriptor description

A NUTS code defined in the NUTS classification 2021, valid from 2021-01-01 to 2023-12-31, containing 92 regions at NUTS level 1, 244 regions at NUTS level 2 and 1165 regions at NUTS level 3 level.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.NTSCD55
Unit

n/a
Table 53. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Nuts 0 - 5 n/a AT22 n/a n/a n/a ITC18 1,424 93 ( 6.5% ) 0 ( 0.0% ) 0 ( 0.0% ) 15 ( 1.1% )
Table 54. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Nuts
93.47%
1.05%
DE1 AT31

Data Distribution Top 20

Figure 27. Distribution of 20 most common values, from highest to lowest.

Completeness

Figure 28. Visualization of completeness of the data in the column.

Uniqueness

Figure 29. Visualization of uniqueness of the data in the column.

Column: Zip

Table 55. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name Zip
Description

Postcodes for the location in which the observation is reported.
Data type String
Descriptor eurostat:postcode [UID:0.0.PSTCD378]
Descriptor description

A postal code (also known locally in various English-speaking countries throughout the world as a postcode, post code, PIN or ZIP Code) is a series of letters or digits or both, sometimes including spaces or punctuation, included in a postal address for the purpose of sorting mail.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.PSTCD378
Unit

n/a
Table 56. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Zip 4 - 5 15,054.0 6,020 6,065 6,184 14,020 77,743 1,424 1,317 ( 92.5% ) 0 ( 0.0% ) 0 ( 0.0% ) 25 ( 1.8% )
Table 57. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Zip
7.51%
1.76%
6020 6215

Data Distribution Top 20

Figure 30. Distribution of 20 most common values, from highest to lowest.

Data Distribution Bottom 20

Figure 31. Distribution of 20 least common values, from lowest to highest.

Outliers

Figure 32. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 33. Visualization of completeness of the data in the column.

Uniqueness

Figure 34. Visualization of uniqueness of the data in the column.

Column: PlaceName

Table 58. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name PlaceName
Description

Name of the place in local language in which the observation is reported.
Data type String
Descriptor dwc:locality [UID:0.0.LCLTY544]
Descriptor description

A term from the Darwin Core standard:

The specific description of the place.
Descriptor target IRI http://rs.tdwg.org/dwc/terms/locality
Unit

n/a
Table 59. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
PlaceName 0 - 28 n/a Absam n/a n/a n/a Zirl 1,424 1,317 ( 92.5% ) 0 ( 0.0% ) 0 ( 0.0% ) 25 ( 1.8% )
Table 60. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
PlaceName
7.51%
1.76%
n/a Achental

Data Distribution Top 20

Figure 35. Distribution of 20 most common values, from highest to lowest.

Data Distribution Bottom 20

Figure 36. Distribution of 20 least common values, from lowest to highest.

Completeness

Figure 37. Visualization of completeness of the data in the column.

Uniqueness

Figure 38. Visualization of uniqueness of the data in the column.

Column: Lau

Table 61. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name Lau
Description

LAU code of in which the observation is reported.
Data type String
Descriptor eurostat:lauCode [UID:0.0.LCODE73]
Descriptor description

To meet the demand for statistics at a local level, Eurostat maintains a system of local administrative units (LAUs) compatible with NUTS. These LAUs are the building blocks of the NUTS, and comprise the municipalities and communes of the European Union. [...]

The LAUs are:

administrative for reasons such as the availability of data and policy implementation capacity a subdivision of the NUTS 3 regions covering the whole economic territory of the Member States appropriate for the implementation of local level typologies included in Tercet, namely the coastal area and DEGURBA classification. Since there are frequent changes to the LAUs, Eurostat publishes an updated list towards the end of each year.

The NUTS regulation makes provision for EU Member States to send the lists of their LAUs to Eurostat. If available, Eurostat receives additionally basic administrative data by means of the annual LAU lists, namely total population and total area for each LAU.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.LCODE73
Unit

n/a
Table 62. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Lau 4 - 7 907,290.6 5,082 61,760 70,220 70,358 8,317,151 1,424 1,317 ( 92.5% ) 0 ( 0.0% ) 0 ( 0.0% ) 25 ( 1.8% )
Table 63. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Lau
7.51%
1.76%
70107 70901

Data Distribution Top 20

Figure 39. Distribution of 20 most common values, from highest to lowest.

Data Distribution Bottom 20

Figure 40. Distribution of 20 least common values, from lowest to highest.

Outliers

Figure 41. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 42. Visualization of completeness of the data in the column.

Uniqueness

Figure 43. Visualization of uniqueness of the data in the column.

Column: WGS84_N

Table 64. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name WGS84_N
Description

Latitude in WGS84 format of the position on which the observation is reported.
Data type String
Descriptor dwc:decimalLatitude [UID:0.0.LTTDE333]
Descriptor description

A term from the Darwin Core standard:

The geographic latitude (in decimal degrees, using the spatial reference system given in dwc:geodeticDatum) of the geographic center of a dcterms:Location. Positive values are north of the Equator, negative values are south of it. Legal values lie between -90 and 90, inclusive.
Descriptor target IRI http://rs.tdwg.org/dwc/terms/decimalLatitude
Unit

°
Table 65. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
WGS84_N 7 - 17 47.518415070000003 46.663673 47.1280745 47.29676385 48.45385 48.45385 1,424 1,382 ( 97.1% ) 0 ( 0.0% ) 0 ( 0.0% ) 15 ( 1.1% )
Table 66. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
WGS84_N
2.95%
1.05%
n/a 47.159483

Data Distribution Top 20

Figure 44. Distribution of 20 most common values, from highest to lowest.

Continuous Data Distribution

Figure 45. Distribution of values in the column.

Outliers

Figure 46. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 47. Visualization of completeness of the data in the column.

Uniqueness

Figure 48. Visualization of uniqueness of the data in the column.

Column: WGS84_E

Table 67. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name WGS84_E
Description

Longitude in WGS84 format of the position on which the observation is reported.
Data type String
Descriptor dwc:decimalLongitude [UID:0.0.LNGTD332]
Descriptor description

A term from the Darwin Core standard:

The geographic longitude (in decimal degrees, using the spatial reference system given in dwc:geodeticDatum) of the geographic center of a dcterms:Location. Positive values are east of the Greenwich Meridian, negative values are west of it. Legal values lie between -180 and 180, inclusive.
Descriptor target IRI http://rs.tdwg.org/dwc/terms/decimalLongitude
Unit

°
Table 68. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
WGS84_E 7 - 18 11.7610757499999998 7.81893 7.81893 11.4849826 15.36796375 15.866698 1,424 1,382 ( 97.1% ) 0 ( 0.0% ) 0 ( 0.0% ) 15 ( 1.1% )
Table 69. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
WGS84_E
2.95%
1.05%
n/a 15.364551

Data Distribution Top 20

Figure 49. Distribution of 20 most common values, from highest to lowest.

Continuous Data Distribution

Figure 50. Distribution of values in the column.

Outliers

Figure 51. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 52. Visualization of completeness of the data in the column.

Uniqueness

Figure 53. Visualization of uniqueness of the data in the column.

Column: Elevation

Table 70. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name Elevation
Description

Elevation of the location in which the observation is reported.
Data type String
Descriptor pms:heightAboveMeanSeaLevel [UID:0.0.HGHTB393]
Descriptor description

Height above mean sea level is a measure of the vertical distance (height, elevation or altitude) of a location in reference to a historic mean sea level taken as a vertical datum. In geodesy, it is formalized as orthometric heights.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.HGHTB393
Unit

m
Table 71. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Elevation 3 - 4 626.4 144 354.25 640 650 2,250 1,424 1,356 ( 95.2% ) 0 ( 0.0% ) 0 ( 0.0% ) 22 ( 1.5% )
Table 72. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Elevation
4.78%
1.54%
640 600

Data Distribution Top 20

Figure 54. Distribution of 20 most common values, from highest to lowest.

Data Distribution Bottom 20

Figure 55. Distribution of 20 least common values, from lowest to highest.

Outliers

Figure 56. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 57. Visualization of completeness of the data in the column.

Uniqueness

Figure 58. Visualization of uniqueness of the data in the column.

Column: DateFrom

Table 73. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name DateFrom
Description

Start date at which the observation is reported.
Data type String
Descriptor dwc:eventDate [UID:0.0.VNTDT721]
Descriptor description

A term from the Darwin Core standard:

The date-time or interval during which a dwc:Event occurred. For occurrences, this is the date-time when the dwc:Event was recorded. Not suitable for a time in a geological context.
Descriptor target IRI http://rs.tdwg.org/dwc/terms/eventDate
Unit

n/a
Table 74. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
DateFrom 0 - 11 n/a 01.04.65 n/a n/a n/a May 1877 1,424 1,315 ( 92.3% ) 0 ( 0.0% ) 0 ( 0.0% ) 37 ( 2.6% )
Table 75. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
DateFrom
7.65%
2.60%
n/a 01.04.65

Data Distribution Top 20

Figure 59. Distribution of 20 most common values, from highest to lowest.

Data Distribution Bottom 20

Figure 60. Distribution of 20 least common values, from lowest to highest.

Completeness

Figure 61. Visualization of completeness of the data in the column.

Uniqueness

Figure 62. Visualization of uniqueness of the data in the column.

Column: DateTo

Table 76. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name DateTo
Description

End date at which the observation is reported.
Data type String
Descriptor dwc:eventDate [UID:0.0.VNTDT721]
Descriptor description

A term from the Darwin Core standard:

The date-time or interval during which a dwc:Event occurred. For occurrences, this is the date-time when the dwc:Event was recorded. Not suitable for a time in a geological context.
Descriptor target IRI http://rs.tdwg.org/dwc/terms/eventDate
Unit

n/a
Table 77. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
DateTo 0 - 14 n/a 01.04.65 n/a n/a n/a September 20… 1,424 1,315 ( 92.3% ) 0 ( 0.0% ) 0 ( 0.0% ) 37 ( 2.6% )
Table 78. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
DateTo
7.65%
2.60%
n/a 01.04.65

Data Distribution Top 20

Figure 63. Distribution of 20 most common values, from highest to lowest.

Data Distribution Bottom 20

Figure 64. Distribution of 20 least common values, from lowest to highest.

Completeness

Figure 65. Visualization of completeness of the data in the column.

Uniqueness

Figure 66. Visualization of uniqueness of the data in the column.

Column: TimeFrom

Table 79. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name TimeFrom
Description

First time of the day at which the observation is reported.
Data type String
Descriptor dwc:eventDate [UID:0.0.VNTDT721]
Descriptor description

A term from the Darwin Core standard:

The date-time or interval during which a dwc:Event occurred. For occurrences, this is the date-time when the dwc:Event was recorded. Not suitable for a time in a geological context.
Descriptor target IRI http://rs.tdwg.org/dwc/terms/eventDate
Unit

n/a
Table 80. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
TimeFrom 0 - 20 n/a 10:00 n/a n/a n/a sunrise (app… 1,424 1,377 ( 96.7% ) 0 ( 0.0% ) 0 ( 0.0% ) 14 ( 1.0% )
Table 81. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
TimeFrom
3.30%
0.98%
n/a 9:45

Data Distribution Top 20

Figure 67. Distribution of 20 most common values, from highest to lowest.

Completeness

Figure 68. Visualization of completeness of the data in the column.

Uniqueness

Figure 69. Visualization of uniqueness of the data in the column.

Column: TimeTo

Table 82. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name TimeTo
Description

First time of the day at which the observation is reported.
Data type String
Descriptor dwc:eventDate [UID:0.0.VNTDT721]
Descriptor description

A term from the Darwin Core standard:

The date-time or interval during which a dwc:Event occurred. For occurrences, this is the date-time when the dwc:Event was recorded. Not suitable for a time in a geological context.
Descriptor target IRI http://rs.tdwg.org/dwc/terms/eventDate
Unit

n/a
Table 83. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
TimeTo 0 - 19 n/a 12:00 n/a n/a n/a sunset (app.… 1,424 1,377 ( 96.7% ) 0 ( 0.0% ) 0 ( 0.0% ) 14 ( 1.0% )
Table 84. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
TimeTo
3.30%
0.98%
n/a 9:45

Data Distribution Top 20

Figure 70. Distribution of 20 most common values, from highest to lowest.

Completeness

Figure 71. Visualization of completeness of the data in the column.

Uniqueness

Figure 72. Visualization of uniqueness of the data in the column.

Column: ImageId

Table 85. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name ImageId
Description

Internal identifier of an image.
Data type String
Descriptor imageId [UID:PLLNT11.0.PLLNT11.0.0.0.MGEID795]
Descriptor description

Internal identifier of the image that was taken of a sample.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/PLLNT11.0.PLLNT11.0.0.0.MGEID795
Unit

n/a
Table 86. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
ImageId 1 - 2 7.0 1 3.5 7 10.5 13 1,424 1,411 ( 99.1% ) 0 ( 0.0% ) 0 ( 0.0% ) 14 ( 1.0% )
Table 87. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
ImageId
0.91%
0.98%
1 1

Data Distribution Top 20

Figure 73. Distribution of 20 most common values, from highest to lowest.

Continuous Data Distribution

Figure 74. Distribution of values in the column.

Outliers

Figure 75. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 76. Visualization of completeness of the data in the column.

Uniqueness

Figure 77. Visualization of uniqueness of the data in the column.

Column: InsectSynonymName

Table 88. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name InsectSynonymName
Description

Synonym of the scientific name of the insect (dwc:resourceID) used in the beexml:recordID.
Data type String
Descriptor dwc:verbatimIdentification [UID:0.0.VRBTM484]
Descriptor description

A term from the Darwin Core standard:

A string representing the taxonomic identification as it appeared in the original record.
Descriptor target IRI http://rs.tdwg.org/dwc/terms/verbatimIdentification
Unit

n/a
Table 89. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
InsectSynonymName 0 - 25 n/a Andrena carb… n/a n/a n/a Tipula hortu… 1,424 1,334 ( 93.7% ) 0 ( 0.0% ) 0 ( 0.0% ) 20 ( 1.4% )
Table 90. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
InsectSynonymName
6.32%
1.40%
n/a Andrena saundersella

Data Distribution Top 20

Figure 78. Distribution of 20 most common values, from highest to lowest.

Completeness

Figure 79. Visualization of completeness of the data in the column.

Uniqueness

Figure 80. Visualization of uniqueness of the data in the column.

Column: Source

Table 91. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name Source
Description

Literature rescource from which the data in the record was obtained.
Data type String
Descriptor dcterms:bibliographicCitation [UID:0.0.BBLGR567]
Descriptor description

A bibliographic reference for the resource.
Descriptor target IRI http://purl.org/dc/terms/bibliographicCitation
Unit

n/a
Table 92. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Source 0 - 2,647 n/a @article{gro… n/a n/a n/a article{sche… 1,424 13 ( 0.9% ) 0 ( 0.0% ) 0 ( 0.0% ) 36 ( 2.5% )
Table 93. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Source
99.09%
2.53%
@book{westrich_paul_wildbienen_1990, address = {Stuttgart, DEU}, edition = {2}, title = {Die {Wildbienen} {Baden}-{Württenbergs}. {Spezieller} {Teil}}, volume = {2}, isbn = {3-8001-3317-2}, language = {de}, publisher = {Ulmer}, author = {{Westrich, Paul}}, year = {1990}, } @incollection{free_john_brand_notitle_1970, address = {London, GBR}, edition = {1}, isbn = {0-12-266650-X}, booktitle = {Insect {Pollination} of {Crops}}, publisher = {Academic Press}, author = {{Free, John Brand}}, year = {1970}, pages = {271}, }

Data Distribution Top 20

Figure 81. Distribution of 20 most common values, from highest to lowest.

Data Distribution Bottom 20

Figure 82. Distribution of 20 least common values, from lowest to highest.

Completeness

Figure 83. Visualization of completeness of the data in the column.

Uniqueness

Figure 84. Visualization of uniqueness of the data in the column.

Column: interaction

Table 94. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name interaction
Description

The identifier for the relationship type (predicate) from the OBO Relations Ontology (RO) that connects the subject identified by dwc:resourceID to its object identified by dwc:relatedResourceID.
Data type String
Descriptor dwc:relationshipOfResourceID [UID:0.0.RLTNS791]
Descriptor description

A term from the Darwin Core standard:

An identifier for the relationship type (predicate) that connects the subject identified by dwc:resourceID to its object identified by dwc:relatedResourceID.
Descriptor target IRI http://rs.tdwg.org/dwc/terms/relationshipOfResourceID
Unit

n/a
Table 95. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
interaction 41 - 41 n/a http://purl.… n/a n/a n/a http://purl.… 1,424 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.1% )
Table 96. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
interaction
100.00%
0.07%
http://purl.obolibrary.org/obo/RO_0002618 http://purl.obolibrary.org/obo/RO_0002618

Data Distribution Top 20

Figure 85. Distribution of 20 most common values, from highest to lowest.

Completeness

Figure 86. Visualization of completeness of the data in the column.

Uniqueness

Figure 87. Visualization of uniqueness of the data in the column.

Table: Pollination_dependency

Column: CropId

Table 97. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name CropId
Description

Internal identifier of the crop.
Data type Integer number
Descriptor CropId [UID:PLLNT11.CRPGG73.CRPID388]
Descriptor description

Identifier of the crop.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/PLLNT11.CRPGG73.CRPID388
Unit

n/a
Table 98. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
CropId 1 - 3 97.5 1 48.75 98.5 146.25 194 198 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 192 ( 97.0% )
Table 99. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
CropId
100.00%
96.97%
24 1

Continuous Data Distribution

Figure 88. Distribution of values in the column.

Outliers

Figure 89. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 90. Visualization of completeness of the data in the column.

Uniqueness

Figure 91. Visualization of uniqueness of the data in the column.

Column: ParentCropId

Table 100. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name ParentCropId
Description

Internal crop identifier of the higher level aggregate.
Data type Integer number
Descriptor CropId [UID:PLLNT11.CRPGG73.CRPID388]
Descriptor description

Identifier of the crop.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/PLLNT11.CRPGG73.CRPID388
Unit

n/a
Table 101. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
ParentCropId 1 - 3 94.0 1 44 94 158 194 198 80 ( 40.4% ) 0 ( 0.0% ) 0 ( 0.0% ) 30 ( 15.2% )
Table 102. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
ParentCropId
59.60%
15.15%
158 55

Continuous Data Distribution

Figure 92. Distribution of values in the column.

Outliers

Figure 93. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 94. Visualization of completeness of the data in the column.

Uniqueness

Figure 95. Visualization of uniqueness of the data in the column.

Column: Impact

Table 103. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name Impact
Description

Description of pollination dependency of the reported crop on nominal scale.
Data type String
Descriptor Text [UID:0.0.TEXTA315]
Descriptor description

In computer programming, a string is traditionally a sequence of characters, either as a literal constant or as some kind of variable. The latter may allow its elements to be mutated and the length changed, or it may be fixed (after creation). A string is generally considered as a data type and is often implemented as an array data structure of bytes (or words) that stores a sequence of elements, typically characters, using some character encoding. String may also denote more general arrays or other sequence (or list) data types and structures.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.TEXTA315
Unit

n/a
Table 104. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Impact 5 - 11 n/a great n/a n/a n/a no increase 198 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 6 ( 3.0% )
Table 105. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Impact
100.00%
3.03%
little no increase

Data Distribution Top 20

Figure 96. Distribution of 20 most common values, from highest to lowest.

Completeness

Figure 97. Visualization of completeness of the data in the column.

Uniqueness

Figure 98. Visualization of uniqueness of the data in the column.

Column: DepFrom

Table 106. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name DepFrom
Description

Lower range of pollination dependency of the reported crop in the reported unit.
Data type Integer number
Descriptor Integer [UID:0.0.NTGER313]
Descriptor description

A number with no fractional part, including the negative and positive numbers as well as zero.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.NTGER313
Unit

n/a
Table 107. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
DepFrom 1 - 2 22.9 0 1 10 40 90 198 19 ( 9.6% ) 13 ( 6.6% ) 0 ( 0.0% ) 6 ( 3.0% )
Table 108. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
DepFrom
90.40%
3.03%
1 0

Data Distribution Top 20

Figure 99. Distribution of 20 most common values, from highest to lowest.

Continuous Data Distribution

Figure 100. Distribution of values in the column.

Outliers

Figure 101. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 102. Visualization of completeness of the data in the column.

Uniqueness

Figure 103. Visualization of uniqueness of the data in the column.

Column: DepTo

Table 109. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name DepTo
Description

Upper range of pollination dependency of the reported crop in the reported unit.
Data type Integer number
Descriptor Integer [UID:0.0.NTGER313]
Descriptor description

A number with no fractional part, including the negative and positive numbers as well as zero.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.NTGER313
Unit

n/a
Table 110. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
DepTo 1 - 3 46.8 0 9 39 89 100 198 19 ( 9.6% ) 13 ( 6.6% ) 0 ( 0.0% ) 6 ( 3.0% )
Table 111. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
DepTo
90.40%
3.03%
9 0

Data Distribution Top 20

Figure 104. Distribution of 20 most common values, from highest to lowest.

Continuous Data Distribution

Figure 105. Distribution of values in the column.

Outliers

Figure 106. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 107. Visualization of completeness of the data in the column.

Uniqueness

Figure 108. Visualization of uniqueness of the data in the column.

Column: Unit

Table 112. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name Unit
Description

Unit in which the value is reported.
Data type String
Descriptor dwc:measurementUnit [UID:0.0.NTNME87]
Descriptor description

A named quantity in terms of which other quantities are measured or specified, used as a standard measurement of like kinds.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.NTNME87
Unit

n/a
Table 113. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Unit 0 - 1 n/a n/a n/a n/a % 198 19 ( 9.6% ) 0 ( 0.0% ) 0 ( 0.0% ) 2 ( 1.0% )
Table 114. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Unit
90.40%
1.01%
% null

Data Distribution Top 20

Figure 109. Distribution of 20 most common values, from highest to lowest.

Completeness

Figure 110. Visualization of completeness of the data in the column.

Uniqueness

Figure 111. Visualization of uniqueness of the data in the column.

Column: FaoItemCode

Table 115. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name FaoItemCode
Description
Data type Integer number
Descriptor faostat:ItemCode [UID:0.0.ITMCD423]
Descriptor description

Code of the item for which FAOSTAT provides data, summarised in the "Item" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.ITMCD423
Unit

n/a
Table 116. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
FaoItemCode 2 - 4 474.6 89 249 423 567 2,613 198 111 ( 56.1% ) 0 ( 0.0% ) 0 ( 0.0% ) 83 ( 41.9% )
Table 117. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
FaoItemCode
43.94%
41.92%
211 711

Continuous Data Distribution

Figure 112. Distribution of values in the column.

Outliers

Figure 113. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 114. Visualization of completeness of the data in the column.

Uniqueness

Figure 115. Visualization of uniqueness of the data in the column.

Column: FaoItem

Table 118. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name FaoItem
Description
Data type String
Descriptor faostat:ItemLabel [UID:0.0.TMLBL425]
Descriptor description

Item for which FAOSTAT provides data, summarised in the "Item" list on the web page "Definitions and standards used in FAOSTAT" of the FAOSTAT website.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.TMLBL425
Unit

n/a
Table 119. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
FaoItem 4 - 72 n/a Figs n/a n/a n/a Other nuts (… 198 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 190 ( 96.0% )
Table 120. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
FaoItem
100.00%
95.96%
Kola nuts Anise, badian, fennel, coriander

Completeness

Figure 116. Visualization of completeness of the data in the column.

Uniqueness

Figure 117. Visualization of uniqueness of the data in the column.

Column: Source

Table 121. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name Source
Description
Data type String
Descriptor dcterms:bibliographicCitation [UID:0.0.BBLGR567]
Descriptor description

A bibliographic reference for the resource.
Descriptor target IRI http://purl.org/dc/terms/bibliographicCitation
Unit

n/a
Table 122. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Source 38 - 38 n/a https://doi.… n/a n/a n/a https://doi.… 198 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.5% )
Table 123. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Source
100.00%
0.51%
https://doi.org/10.1098/rspb.2006.3721 https://doi.org/10.1098/rspb.2006.3721

Data Distribution Top 20

Figure 118. Distribution of 20 most common values, from highest to lowest.

Completeness

Figure 119. Visualization of completeness of the data in the column.

Uniqueness

Figure 120. Visualization of uniqueness of the data in the column.

Column: Annotation

Table 124. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name Annotation
Description

Specific annotation on the record.
Data type String
Descriptor dwc:measurementRemarks [UID:0.0.MSRMN780]
Descriptor description

Comments or notes accompanying the dwc:MeasurementOrFact.
Descriptor target IRI http://rs.tdwg.org/dwc/terms/measurementRemarks
Unit

n/a
Table 125. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Annotation 0 - 178 n/a n/a n/a n/a Comodity con… 198 196 ( 99.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 2 ( 1.0% )
Table 126. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Annotation
1.01%
1.01%
null Comodity consist of more than one crop species differing in pollination dependency. Quantities for each crop are unknown. No pollination dependence for the comodity can be given.

Data Distribution Top 20

Figure 121. Distribution of 20 most common values, from highest to lowest.

Completeness

Figure 122. Visualization of completeness of the data in the column.

Uniqueness

Figure 123. Visualization of uniqueness of the data in the column.

Table: Imagelist

Column: ImageId

Table 127. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name ImageId
Description

Internal identifier of an image.
Data type Integer number
Descriptor imageId [UID:PLLNT11.0.PLLNT11.0.0.0.MGEID795]
Descriptor description

Internal identifier of the image that was taken of a sample.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/PLLNT11.0.PLLNT11.0.0.0.MGEID795
Unit

n/a
Table 128. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
ImageId 1 - 2 7.0 1 3.5 7 10.5 13 13 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 13 ( 100.0% )
Table 129. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
ImageId
100.00%
100.00%
1 1

Continuous Data Distribution

Figure 124. Distribution of values in the column.

Outliers

Figure 125. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 126. Visualization of completeness of the data in the column.

Uniqueness

Figure 127. Visualization of uniqueness of the data in the column.

Column: FileName

Table 130. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name FileName
Description

Name of the file.
Data type String
Descriptor Text [UID:0.0.TEXTA315]
Descriptor description

In computer programming, a string is traditionally a sequence of characters, either as a literal constant or as some kind of variable. The latter may allow its elements to be mutated and the length changed, or it may be fixed (after creation). A string is generally considered as a data type and is often implemented as an array data structure of bytes (or words) that stores a sequence of elements, typically characters, using some character encoding. String may also denote more general arrays or other sequence (or list) data types and structures.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.TEXTA315
Unit

n/a
Table 131. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
FileName 13 - 13 n/a 100000001.JP… n/a n/a n/a 100000013.JP… 13 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 13 ( 100.0% )
Table 132. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
FileName
100.00%
100.00%
100000001.JPG 100000001.JPG

Completeness

Figure 128. Visualization of completeness of the data in the column.

Uniqueness

Figure 129. Visualization of uniqueness of the data in the column.

Column: FileTitle

Table 133. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name FileTitle
Description

Title of the file describing the content.
Data type String
Descriptor Text [UID:0.0.TEXTA315]
Descriptor description

In computer programming, a string is traditionally a sequence of characters, either as a literal constant or as some kind of variable. The latter may allow its elements to be mutated and the length changed, or it may be fixed (after creation). A string is generally considered as a data type and is often implemented as an array data structure of bytes (or words) that stores a sequence of elements, typically characters, using some character encoding. String may also denote more general arrays or other sequence (or list) data types and structures.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.TEXTA315
Unit

n/a
Table 134. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
FileTitle 28 - 38 n/a Apis melifer… n/a n/a n/a Apis mellife… 13 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 13 ( 100.0% )
Table 135. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
FileTitle
100.00%
100.00%
Apis mellifera on Castanea sativa Apis mellifera on Castanea sativa

Completeness

Figure 130. Visualization of completeness of the data in the column.

Uniqueness

Figure 131. Visualization of uniqueness of the data in the column.

Column: AuthorName

Table 136. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name AuthorName
Description

Name of the photographer.
Data type String
Descriptor dcterms:rightsHolder [UID:0.0.RGHTS565]
Descriptor description

A person or organization owning or managing rights over the resource.
Descriptor target IRI http://purl.org/dc/terms/rightsHolder
Unit

n/a
Table 137. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
AuthorName 16 - 16 n/a Rubinigg Mic… n/a n/a n/a Rubinigg Mic… 13 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 7.7% )
Table 138. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
AuthorName
100.00%
7.69%
Rubinigg Michael Rubinigg Michael

Data Distribution Top 20

Figure 132. Distribution of 20 most common values, from highest to lowest.

Completeness

Figure 133. Visualization of completeness of the data in the column.

Uniqueness

Figure 134. Visualization of uniqueness of the data in the column.

Column: DateTime

Table 139. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name DateTime
Description

Date and time at which the image was taken.
Data type Date and Time
Descriptor dwc:eventDate [UID:0.0.VNTDT721]
Descriptor description

A term from the Darwin Core standard:

The date-time or interval during which a dwc:Event occurred. For occurrences, this is the date-time when the dwc:Event was recorded. Not suitable for a time in a geological context.
Descriptor target IRI http://rs.tdwg.org/dwc/terms/eventDate
Unit

n/a
Table 140. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
DateTime 19 - 19 n/a 2012-05-30 1… n/a n/a n/a 2019-06-18 0… 13 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 13 ( 100.0% )
Table 141. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
DateTime
100.00%
100.00%
2019-06-18 09:45:00 2019-06-18 09:45:00

Completeness

Figure 135. Visualization of completeness of the data in the column.

Uniqueness

Figure 136. Visualization of uniqueness of the data in the column.

Column: Bytes

Table 142. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name Bytes
Description

File size in bytes.
Data type Integer number
Descriptor Integer [UID:0.0.NTGER313]
Descriptor description

A number with no fractional part, including the negative and positive numbers as well as zero.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.NTGER313
Unit

n/a
Table 143. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Bytes 7 - 7 3,473,759.0 2,535,424 2,701,312 3,256,320 3,971,072 5,390,803 13 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 12 ( 92.3% )
Table 144. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Bytes
100.00%
92.31%
2535424 5390803

Continuous Data Distribution

Figure 137. Distribution of values in the column.

Outliers

Figure 138. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 139. Visualization of completeness of the data in the column.

Uniqueness

Figure 140. Visualization of uniqueness of the data in the column.

Column: WidthPx

Table 145. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name WidthPx
Description

Width of image in pixels.
Data type Integer number
Descriptor Integer [UID:0.0.NTGER313]
Descriptor description

A number with no fractional part, including the negative and positive numbers as well as zero.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.NTGER313
Unit

n/a
Table 146. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
WidthPx 4 - 4 4,162.5 2,848 4,272 4,272 4,272 4,272 13 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 2 ( 15.4% )
Table 147. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
WidthPx
100.00%
15.38%
4272 2848

Data Distribution Top 20

Figure 141. Distribution of 20 most common values, from highest to lowest.

Continuous Data Distribution

Figure 142. Distribution of values in the column.

Outliers

Figure 143. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 144. Visualization of completeness of the data in the column.

Uniqueness

Figure 145. Visualization of uniqueness of the data in the column.

Column: HeightPx

Table 148. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name HeightPx
Description

Height of image in pixels.
Data type Integer number
Descriptor Integer [UID:0.0.NTGER313]
Descriptor description

A number with no fractional part, including the negative and positive numbers as well as zero.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.NTGER313
Unit

n/a
Table 149. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
HeightPx 4 - 5 5,919.1 2,848 2,848 2,848 2,848 42,772 13 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 2 ( 15.4% )
Table 150. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
HeightPx
100.00%
15.38%
2848 42772

Data Distribution Top 20

Figure 146. Distribution of 20 most common values, from highest to lowest.

Continuous Data Distribution

Figure 147. Distribution of values in the column.

Outliers

Figure 148. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 149. Visualization of completeness of the data in the column.

Uniqueness

Figure 150. Visualization of uniqueness of the data in the column.

Column: CameraModel

Table 151. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name CameraModel
Description

Name of the camera model the image was taken with.
Data type String
Descriptor Text [UID:0.0.TEXTA315]
Descriptor description

In computer programming, a string is traditionally a sequence of characters, either as a literal constant or as some kind of variable. The latter may allow its elements to be mutated and the length changed, or it may be fixed (after creation). A string is generally considered as a data type and is often implemented as an array data structure of bytes (or words) that stores a sequence of elements, typically characters, using some character encoding. String may also denote more general arrays or other sequence (or list) data types and structures.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.TEXTA315
Unit

n/a
Table 152. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
CameraModel 15 - 15 n/a Canon EOS 11… n/a n/a n/a Canon EOS 11… 13 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 7.7% )
Table 153. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
CameraModel
100.00%
7.69%
Canon EOS 1100D Canon EOS 1100D

Data Distribution Top 20

Figure 151. Distribution of 20 most common values, from highest to lowest.

Completeness

Figure 152. Visualization of completeness of the data in the column.

Uniqueness

Figure 153. Visualization of uniqueness of the data in the column.

Column: Fstop

Table 154. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name Fstop
Description

F-stop (ratio of the lens focal length to the diameter of the entrance pupil) of the camera.
Data type Decimal number
Descriptor DecimalNumber [UID:0.0.DCMLN314]
Descriptor description

Any of the rational or irrational numbers.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.DCMLN314
Unit

n/a
Table 155. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Fstop 1 - 3 11.96 3.2 4.25 7.1 21.5 32 13 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 9 ( 69.2% )
Table 156. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Fstop
100.00%
69.23%
32 11

Continuous Data Distribution

Figure 154. Distribution of values in the column.

Outliers

Figure 155. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 156. Visualization of completeness of the data in the column.

Uniqueness

Figure 157. Visualization of uniqueness of the data in the column.

Column: ExposureSec

Table 157. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name ExposureSec
Description

Exposure time in seconds of the camera.
Data type Decimal number
Descriptor DecimalNumber [UID:0.0.DCMLN314]
Descriptor description

Any of the rational or irrational numbers.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.DCMLN314
Unit

n/a
Table 158. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
ExposureSec 4 - 7 0.006154 0.0005 0.001125 0.0025 0.007125 0.04 13 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 8 ( 61.5% )
Table 159. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
ExposureSec
100.00%
61.54%
0.0025 0.0005

Continuous Data Distribution

Figure 158. Distribution of values in the column.

Outliers

Figure 159. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 160. Visualization of completeness of the data in the column.

Uniqueness

Figure 161. Visualization of uniqueness of the data in the column.

Column: IsoSpeed

Table 160. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name IsoSpeed
Description

ISO speed of the camera.
Data type Integer number
Descriptor Integer [UID:0.0.NTGER313]
Descriptor description

A number with no fractional part, including the negative and positive numbers as well as zero.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.NTGER313
Unit

n/a
Table 161. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
IsoSpeed 3 - 4 1,450.0 100 100 100 2,225 6,400 13 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 5 ( 38.5% )
Table 162. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
IsoSpeed
100.00%
38.46%
100 800

Continuous Data Distribution

Figure 162. Distribution of values in the column.

Outliers

Figure 163. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 164. Visualization of completeness of the data in the column.

Uniqueness

Figure 165. Visualization of uniqueness of the data in the column.

Column: FocalLengtmm

Table 163. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name FocalLengtmm
Description

Focal length in mm of the lens.
Data type Integer number
Descriptor Integer [UID:0.0.NTGER313]
Descriptor description

A number with no fractional part, including the negative and positive numbers as well as zero.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.NTGER313
Unit

n/a
Table 164. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
FocalLengtmm 3 - 3 105.4 100 100 100 100 135 13 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 2 ( 15.4% )
Table 165. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
FocalLengtmm
100.00%
15.38%
100 135

Data Distribution Top 20

Figure 166. Distribution of 20 most common values, from highest to lowest.

Continuous Data Distribution

Figure 167. Distribution of values in the column.

Outliers

Figure 168. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 169. Visualization of completeness of the data in the column.

Uniqueness

Figure 170. Visualization of uniqueness of the data in the column.

Column: Flash

Table 166. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name Flash
Description

Information on the utilization of a flash.
Data type String
Descriptor Text [UID:0.0.TEXTA315]
Descriptor description

In computer programming, a string is traditionally a sequence of characters, either as a literal constant or as some kind of variable. The latter may allow its elements to be mutated and the length changed, or it may be fixed (after creation). A string is generally considered as a data type and is often implemented as an array data structure of bytes (or words) that stores a sequence of elements, typically characters, using some character encoding. String may also denote more general arrays or other sequence (or list) data types and structures.
Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.TEXTA315
Unit

n/a
Table 167. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Flash 20 - 20 n/a No flash, co… n/a n/a n/a No flash, co… 13 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 7.7% )
Table 168. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
Flash
100.00%
7.69%
No flash, compulsory No flash, compulsory

Data Distribution Top 20

Figure 171. Distribution of 20 most common values, from highest to lowest.

Completeness

Figure 172. Visualization of completeness of the data in the column.

Uniqueness

Figure 173. Visualization of uniqueness of the data in the column.

Column: WGS84_N

Table 169. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name WGS84_N
Description

Latitude in WGS 84 format of the position on which the image was taken.
Data type String
Descriptor dwc:decimalLatitude [UID:0.0.LTTDE333]
Descriptor description

A term from the Darwin Core standard:

The geographic latitude (in decimal degrees, using the spatial reference system given in dwc:geodeticDatum) of the geographic center of a dcterms:Location. Positive values are north of the Equator, negative values are south of it. Legal values lie between -90 and 90, inclusive.
Descriptor target IRI http://rs.tdwg.org/dwc/terms/decimalLatitude
Unit

°
Table 170. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
WGS84_N 0 - 0 n/a n/a n/a n/a 13 13 ( 100.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 7.7% )
Table 171. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
WGS84_N
0.00%
7.69%
n/a n/a

Data Distribution Top 20

Figure 174. Distribution of 20 most common values, from highest to lowest.

Completeness

Figure 175. Visualization of completeness of the data in the column.

Uniqueness

Figure 176. Visualization of uniqueness of the data in the column.

Column: WGS84_E

Table 172. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name WGS84_E
Description

Longitude in WGS 84 format of the position on which the image was taken.
Data type String
Descriptor dwc:decimalLongitude [UID:0.0.LNGTD332]
Descriptor description

A term from the Darwin Core standard:

The geographic longitude (in decimal degrees, using the spatial reference system given in dwc:geodeticDatum) of the geographic center of a dcterms:Location. Positive values are east of the Greenwich Meridian, negative values are west of it. Legal values lie between -180 and 180, inclusive.
Descriptor target IRI http://rs.tdwg.org/dwc/terms/decimalLongitude
Unit

°
Table 173. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
WGS84_E 0 - 0 n/a n/a n/a n/a 13 13 ( 100.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 7.7% )
Table 174. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
WGS84_E
0.00%
7.69%
n/a n/a

Data Distribution Top 20

Figure 177. Distribution of 20 most common values, from highest to lowest.

Completeness

Figure 178. Visualization of completeness of the data in the column.

Uniqueness

Figure 179. Visualization of uniqueness of the data in the column.