|
|
, , • • |
| Unique identifier: | HVSCL24.0.0 |
| Title: | Hive scales ONM |
| Long title: | Hive scale data provided by members of the organisation Osservatorio Nazionale Miele |
| Status: | Quality Validated |
| Current Version: | v. 1.0 |
| Published: | 2024-01-06 |
| Reviewed by: | |
| Citation proposal: |
EU Pollinator Hub, Pappalardo 2024 Report of dataset Hive scales ONM, v. 1.0 [HVSCL24.0.0]. EU Pollinator Hub. [2026-02-24] app.pollinatorhub.eu
|
|
Data Quality
Under evaluation
|
|||||||||||||||
Document history
Release
Version v. 1.0 released on 2024-01-06.
Revision
| No | Date | Description | Reason |
|---|---|---|---|
| 1 | 2024-01-06 00:01:00 | Initial release. | n/a |
Abbreviations
No abbreviations.
Executive summary
Data overview:
Data value:
Data description:
Data application:
Unresolved issues:
Introduction
Material and methods
Data acquisition
| No | File | Type | D | M | Arrival | Data points | File size |
|---|---|---|---|---|---|---|---|
| 1 | hivescale.csv | CSV - Comma seperated values | Yes | No | 2024-01-07 20:01:45 | 3,901,008 | 37.91 MiB |
Data preparation
Data validation
Data analysis
Data description
Dataset
| No | Table | Description |
|---|---|---|
| 1 | Hivescale | The table contains data from 57 hive scales in Italy, in the period form 1 June 2021 to 31 December… |
| Parameter | Content |
|---|---|
| interactions.single.uid | HVSCL24.0.0 |
| Title | Hive scales ONM |
| Long title | Hive scale data provided by members of the organisation Osservatorio Nazionale Miele |
| Target IRI | https://app.pollinatorhub.eu/dataset-discovery/HVSCL24.0.0 |
| interactions.single.section-details.licence | CC BY-SA 4.0 |
| DOI | n/a |
| Created | 2023-01-26 |
| Published | 2024-01-06 |
| Contact | n/a |
| Keywords | Abruzzo, Basilicata, Calabria, Campania, Emilia-Romagna, Friuli-Venezia Giulia, Italy, Lazio, Liguria, Lombardia, Marche, Molise, Piemonte, Puglia, Sardegna, Sicilia, Toscana, Trentino-Alto Adige, Umbria, Valle d'Aosta, Veneto, hive scale |
| Data collection years | 2021-2023 |
| Regions, the data was collected in | Italia |
| Abstract | The dataset contains data from hive scales (hive weight, temperature, relative humidity, air pressure) from various apiaries in Italy. Data was provided by Osservatorio Nazionale Miele. |
| Parameter | Content |
|---|---|
| Name | EU Pollinator Hub |
| Url | |
| Acronym | EUPH |
| IRI | https://app.pollinatorhub.eu/data-providers/euph |
| Address | |
| Country | Belgium |
| Contact | https://www.linkedin.com/company/beelife-european-beekeeping-coordination/ pollinatorhub.eu |
| Description | The EU Pollinator Hub (EUPH) is a data hub related to pollinators, which is provided by the European Food Safety Authority (EFSA). |
| Parameter | Content |
|---|---|
| Name | Pappalardo |
| Url | |
| Acronym | SP |
| IRI | https://app.pollinatorhub.eu/data-providers/simona-pappalardo |
| Contact | n/a |
| Description |
Tables
Hivescale
| Parameter | Content |
|---|---|
| Unique identifier | HVSCL24.HVSCL178.0 |
| Name | Hivescale |
| Target IRI | https://app.pollinatorhub.eu/dataset-discovery/parts/HVSCL24.HVSCL178.0 |
| Table Type | File |
| Licence | CC BY-SA 4.0 |
| Description |
The table contains data from 57 hive scales in Italy, in the period form 1 June 2021 to 31 December 2023. |
The table contains data from 57 hive scales in Italy, in the period form 1 June 2021 to 31 December 2023.
Metadata
| Column Name | Column Description | Datatype | Descriptor | Unit |
|---|---|---|---|---|
| id |
Identifier of the record. |
Integer number | dwc:identificationID [0.0.DNTFC406] | n/a |
| datetime |
Date and time of measurement by the hive scale. |
Date and Time | iso-8601:calendarDateAndTime [0.0.DTNDT319] | n/a |
| hive_scale |
Name of the hive scale. |
String | Text [0.0.TEXTA315] | n/a |
| hive_weight |
Weight of up to 5 hives in kg, measured by the hive scale. |
Decimal number | pms:hiveWeight [0.0.HVWGH33] | kg |
| temperature |
Ambient air temperature in °C, measured by the hive scale. |
Decimal number | pms:temperature [0.0.TMPRT394] | °C |
| rh |
Ambient relative humidity in %, measured by the hive scale. |
Decimal number | pms:relativeHumidity [0.0.RLTVH395] | % |
| air_pressure |
Atmospheric pressure in mbar (hPa) measured by the hive scale. |
Decimal number | pms:atmosphericPressure [0.0.TMSPH396] | |
| elevation |
Height above sea level measured by the hive scale (may be incorrect). |
Decimal number | dwc:verbatimElevation [0.0.DWCVR436] | n/a |
| lau |
LAU code of the local area unit in which the hive scale is located. |
Integer number | eurostat:lauCode [0.0.LCODE73] | n/a |
| lau_name |
Name of the local area unit in which the hive scale is located. |
String | Text [0.0.TEXTA315] | n/a |
| lau_latitude |
Geographical coordinate, latitude, of the local administrative unit as provided by OpenStreetMap. |
Decimal number | dwc:decimalLatitude [0.0.LTTDE333] | ° |
| lau_longitude |
Geographical coordinate, longitude, of the local administrative unit as provided by OpenStreetMap. |
Decimal number | dwc:decimalLongitude [0.0.LNGTD332] | ° |
Metadata of individual tables can be found in Annex 1.
Descriptive measures
| Column Name | Range | Mean | Minimum | Q1 | Median | Q3 | Maximum | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | 1 - 6 | 200,757.4 | 1 | 111,597.25 | 201,108.5 | 303,838.75 | 392,053 | 325,084 | 0 ( 0.0% ) | 0 ( 0.0% ) | 0 ( 0.0% ) | 325,084 ( 100.0% ) |
| datetime | 19 - 19 | 2,023.0 | 2021-06-01 1… | 2,022 | 2,023 | 2,023 | 2023-12-31 2… | 325,084 | 0 ( 0.0% ) | 0 ( 0.0% ) | 0 ( 0.0% ) | 323,150 ( 99.4% ) |
| hive_scale | 11 - 11 | n/a | beicavie520 | n/a | n/a | n/a | beicavie553 | 325,084 | 0 ( 0.0% ) | 0 ( 0.0% ) | 0 ( 0.0% ) | 51 ( 0.0% ) |
| hive_weight | 5 - 6 | 38.582 | 10.01 | 30.81 | 35.36 | 41.5 | 594.53 | 325,084 | 0 ( 0.0% ) | 0 ( 0.0% ) | 0 ( 0.0% ) | 8,677 ( 2.7% ) |
| temperature | 3 - 5 | 14.27 | -11.2 | 7.9 | 14 | 20 | 60.1 | 325,084 | 16,892 ( 5.2% ) | 2,576 ( 0.8% ) | 0 ( 0.0% ) | 665 ( 0.2% ) |
| rh | 3 - 5 | 76.40 | 0.0 | 58.6 | 82.7 | 100 | 100.0 | 325,084 | 16,879 ( 5.2% ) | 3,298 ( 1.0% ) | 0 ( 0.0% ) | 964 ( 0.3% ) |
| air_pressure | 5 - 6 | 979.29 | 689.0 | 961.9 | 987.3 | 1,003 | 1,724.6 | 325,084 | 18,764 ( 5.8% ) | 0 ( 0.0% ) | 0 ( 0.0% ) | 2,053 ( 0.6% ) |
| elevation | 3 - 6 | 3.58 | 0.0 | 0 | 0 | 0 | 3,155.9 | 325,084 | 0 ( 0.0% ) | 321,560 ( 98.9% ) | 0 ( 0.0% ) | 1,652 ( 0.5% ) |
| lau | 6 - 6 | 39,913.9 | 1,272 | 15,002 | 33,045 | 64,095 | 102,010 | 325,084 | 0 ( 0.0% ) | 0 ( 0.0% ) | 0 ( 0.0% ) | 122 ( 0.0% ) |
| lau_name | 4 - 33 | n/a | Roma | n/a | n/a | n/a | Primiero San… | 325,084 | 0 ( 0.0% ) | 0 ( 0.0% ) | 0 ( 0.0% ) | 122 ( 0.0% ) |
| lau_latitude | 0 - 0 | n/a | n/a | n/a | n/a | 325,084 | 325,084 ( 100.0% ) | 0 ( 0.0% ) | 0 ( 0.0% ) | 1 ( 0.0% ) | ||
| lau_longitude | 9 - 10 | 11.55231491 | 7.0647408 | 8.9338624 | 11.5368965 | 13.5383743 | 17.3349040 | 325,084 | 0 ( 0.0% ) | 0 ( 0.0% ) | 0 ( 0.0% ) | 122 ( 0.0% ) |
Quality measures
| Column Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| id |
100.00%
|
100.00%
|
1 | 1 |
| datetime |
100.00%
|
99.41%
|
2022-07-08 08:04:56 | 2021-06-01 15:11:02 |
| hive_scale |
100.00%
|
0.02%
|
beicavie525 | beicavie547 |
| hive_weight |
100.00%
|
2.67%
|
396.46 | 19.47 |
| temperature |
94.80%
|
0.20%
|
null | 45.2 |
| rh |
94.81%
|
0.30%
|
100.0 | 6.2 |
| air_pressure |
94.23%
|
0.63%
|
null | 1485.3 |
| elevation |
100.00%
|
0.51%
|
0.0 | 150.8 |
| lau |
100.00%
|
0.04%
|
070024 | 007038 |
| lau_name |
100.00%
|
0.04%
|
Fossalto | Jovençan |
| lau_latitude |
0.00%
|
0.00%
|
null | null |
| lau_longitude |
100.00%
|
0.04%
|
14.5457260 | 7.2763432 |
Changes made to preparatory file
Changes made to data
Unresolved issues
References
There are no sources in the current document.
Annex 1: Table column reports
Table: Hivescale
Column: id
| Parameter | Content |
|---|---|
| Column name | id |
| Description |
Identifier of the record. |
| Data type | Integer number |
| Descriptor | dwc:identificationID [UID:0.0.DNTFC406] |
| Descriptor description |
Any identifier for the identification (the body of information associated with the assignment of a scientific name). |
| Descriptor target IRI | http://rs.tdwg.org/dwc/terms/identificationID |
| Unit | n/a |
| Column Name | Range | Mean | Minimum | Q1 | Median | Q3 | Maximum | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | 1 - 6 | 200,757.4 | 1 | 111,597.25 | 201,108.5 | 303,838.75 | 392,053 | 325,084 | 0 ( 0.0% ) | 0 ( 0.0% ) | 0 ( 0.0% ) | 325,084 ( 100.0% ) |
| Column Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| id |
100.00%
|
100.00%
|
1 | 1 |
Continuous Data Distribution
Outliers
Completeness
Uniqueness
Column: datetime
| Parameter | Content |
|---|---|
| Column name | datetime |
| Description |
Date and time of measurement by the hive scale. |
| Data type | Date and Time |
| Descriptor | iso-8601:calendarDateAndTime [UID:0.0.DTNDT319] |
| Descriptor description |
|
| Descriptor target IRI | https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.DTNDT319 |
| Unit | n/a |
| Column Name | Range | Mean | Minimum | Q1 | Median | Q3 | Maximum | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| datetime | 19 - 19 | 2,023.0 | 2021-06-01 1… | 2,022 | 2,023 | 2,023 | 2023-12-31 2… | 325,084 | 0 ( 0.0% ) | 0 ( 0.0% ) | 0 ( 0.0% ) | 323,150 ( 99.4% ) |
| Column Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| datetime |
100.00%
|
99.41%
|
2022-07-08 08:04:56 | 2021-06-01 15:11:02 |
Outliers
Completeness
Uniqueness
Column: hive_scale
| Parameter | Content |
|---|---|
| Column name | hive_scale |
| Description |
Name of the hive scale. |
| Data type | String |
| Descriptor | Text [UID:0.0.TEXTA315] |
| Descriptor description |
|
| Descriptor target IRI | https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.TEXTA315 |
| Unit | n/a |
| Column Name | Range | Mean | Minimum | Q1 | Median | Q3 | Maximum | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| hive_scale | 11 - 11 | n/a | beicavie520 | n/a | n/a | n/a | beicavie553 | 325,084 | 0 ( 0.0% ) | 0 ( 0.0% ) | 0 ( 0.0% ) | 51 ( 0.0% ) |
| Column Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| hive_scale |
100.00%
|
0.02%
|
beicavie525 | beicavie547 |
Data Distribution Top 20
Data Distribution Bottom 20
Completeness
Uniqueness
Column: hive_weight
| Parameter | Content |
|---|---|
| Column name | hive_weight |
| Description |
Weight of up to 5 hives in kg, measured by the hive scale. |
| Data type | Decimal number |
| Descriptor | pms:hiveWeight [UID:0.0.HVWGH33] |
| Descriptor description |
A hive weight is a measurement of the mass of a beehive. |
| Descriptor target IRI | https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.HVWGH33 |
| Unit | kg |
| Column Name | Range | Mean | Minimum | Q1 | Median | Q3 | Maximum | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| hive_weight | 5 - 6 | 38.582 | 10.01 | 30.81 | 35.36 | 41.5 | 594.53 | 325,084 | 0 ( 0.0% ) | 0 ( 0.0% ) | 0 ( 0.0% ) | 8,677 ( 2.7% ) |
| Column Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| hive_weight |
100.00%
|
2.67%
|
396.46 | 19.47 |
Continuous Data Distribution
Outliers
Completeness
Uniqueness
Column: temperature
| Parameter | Content |
|---|---|
| Column name | temperature |
| Description |
Ambient air temperature in °C, measured by the hive scale. |
| Data type | Decimal number |
| Descriptor | pms:temperature [UID:0.0.TMPRT394] |
| Descriptor description |
The physical quantity Celsius temperature expressed in the derived SI unit with special name and symbol degree Celcius. |
| Descriptor target IRI | https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.TMPRT394 |
| Unit | °C |
| Column Name | Range | Mean | Minimum | Q1 | Median | Q3 | Maximum | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| temperature | 3 - 5 | 14.27 | -11.2 | 7.9 | 14 | 20 | 60.1 | 325,084 | 16,892 ( 5.2% ) | 2,576 ( 0.8% ) | 0 ( 0.0% ) | 665 ( 0.2% ) |
| Column Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| temperature |
94.80%
|
0.20%
|
null | 45.2 |
Continuous Data Distribution
Outliers
Completeness
Uniqueness
Column: rh
| Parameter | Content |
|---|---|
| Column name | rh |
| Description |
Ambient relative humidity in %, measured by the hive scale. |
| Data type | Decimal number |
| Descriptor | pms:relativeHumidity [UID:0.0.RLTVH395] |
| Descriptor description |
Relative humidity (RH) (expressed as a percent) also measures water vapor, but RELATIVE to the temperature of the air. In other words, it is a measure of the actual amount of water vapor in the air compared to the total amount of vapor that can exist in the air at its current temperature. |
| Descriptor target IRI | https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.RLTVH395 |
| Unit | % |
| Column Name | Range | Mean | Minimum | Q1 | Median | Q3 | Maximum | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| rh | 3 - 5 | 76.40 | 0.0 | 58.6 | 82.7 | 100 | 100.0 | 325,084 | 16,879 ( 5.2% ) | 3,298 ( 1.0% ) | 0 ( 0.0% ) | 964 ( 0.3% ) |
| Column Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| rh |
94.81%
|
0.30%
|
100.0 | 6.2 |
Continuous Data Distribution
Outliers
Completeness
Uniqueness
Column: air_pressure
| Parameter | Content |
|---|---|
| Column name | air_pressure |
| Description |
Atmospheric pressure in mbar (hPa) measured by the hive scale. |
| Data type | Decimal number |
| Descriptor | pms:atmosphericPressure [UID:0.0.TMSPH396] |
| Descriptor description |
Atmospheric pressure, also known as air pressure or barometric pressure (after the barometer), is the pressure within the atmosphere of Earth. |
| Descriptor target IRI | https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.TMSPH396 |
| Unit |
| Column Name | Range | Mean | Minimum | Q1 | Median | Q3 | Maximum | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| air_pressure | 5 - 6 | 979.29 | 689.0 | 961.9 | 987.3 | 1,003 | 1,724.6 | 325,084 | 18,764 ( 5.8% ) | 0 ( 0.0% ) | 0 ( 0.0% ) | 2,053 ( 0.6% ) |
| Column Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| air_pressure |
94.23%
|
0.63%
|
null | 1485.3 |
Continuous Data Distribution
Outliers
Completeness
Uniqueness
Column: elevation
| Parameter | Content |
|---|---|
| Column name | elevation |
| Description |
Height above sea level measured by the hive scale (may be incorrect). |
| Data type | Decimal number |
| Descriptor | dwc:verbatimElevation [UID:0.0.DWCVR436] |
| Descriptor description |
|
| Descriptor target IRI | http://rs.tdwg.org/dwc/terms/verbatimElevation |
| Unit | n/a |
| Column Name | Range | Mean | Minimum | Q1 | Median | Q3 | Maximum | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| elevation | 3 - 6 | 3.58 | 0.0 | 0 | 0 | 0 | 3,155.9 | 325,084 | 0 ( 0.0% ) | 321,560 ( 98.9% ) | 0 ( 0.0% ) | 1,652 ( 0.5% ) |
| Column Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| elevation |
100.00%
|
0.51%
|
0.0 | 150.8 |
Continuous Data Distribution
Completeness
Uniqueness
Column: lau
| Parameter | Content |
|---|---|
| Column name | lau |
| Description |
LAU code of the local area unit in which the hive scale is located. |
| Data type | Integer number |
| Descriptor | eurostat:lauCode [UID:0.0.LCODE73] |
| Descriptor description |
|
| Descriptor target IRI | https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.LCODE73 |
| Unit | n/a |
| Column Name | Range | Mean | Minimum | Q1 | Median | Q3 | Maximum | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| lau | 6 - 6 | 39,913.9 | 1,272 | 15,002 | 33,045 | 64,095 | 102,010 | 325,084 | 0 ( 0.0% ) | 0 ( 0.0% ) | 0 ( 0.0% ) | 122 ( 0.0% ) |
| Column Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| lau |
100.00%
|
0.04%
|
070024 | 007038 |
Data Distribution Top 20
Data Distribution Bottom 20
Outliers
Completeness
Uniqueness
Column: lau_name
| Parameter | Content |
|---|---|
| Column name | lau_name |
| Description |
Name of the local area unit in which the hive scale is located. |
| Data type | String |
| Descriptor | Text [UID:0.0.TEXTA315] |
| Descriptor description |
|
| Descriptor target IRI | https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.TEXTA315 |
| Unit | n/a |
| Column Name | Range | Mean | Minimum | Q1 | Median | Q3 | Maximum | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| lau_name | 4 - 33 | n/a | Roma | n/a | n/a | n/a | Primiero San… | 325,084 | 0 ( 0.0% ) | 0 ( 0.0% ) | 0 ( 0.0% ) | 122 ( 0.0% ) |
| Column Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| lau_name |
100.00%
|
0.04%
|
Fossalto | Jovençan |
Data Distribution Top 20
Data Distribution Bottom 20
Completeness
Uniqueness
Column: lau_latitude
| Parameter | Content |
|---|---|
| Column name | lau_latitude |
| Description |
Geographical coordinate, latitude, of the local administrative unit as provided by OpenStreetMap. |
| Data type | Decimal number |
| Descriptor | dwc:decimalLatitude [UID:0.0.LTTDE333] |
| Descriptor description |
|
| Descriptor target IRI | http://rs.tdwg.org/dwc/terms/decimalLatitude |
| Unit | ° |
| Column Name | Range | Mean | Minimum | Q1 | Median | Q3 | Maximum | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| lau_latitude | 0 - 0 | n/a | n/a | n/a | n/a | 325,084 | 325,084 ( 100.0% ) | 0 ( 0.0% ) | 0 ( 0.0% ) | 1 ( 0.0% ) |
| Column Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| lau_latitude |
0.00%
|
0.00%
|
null | null |
Data Distribution Top 20
Completeness
Uniqueness
Column: lau_longitude
| Parameter | Content |
|---|---|
| Column name | lau_longitude |
| Description |
Geographical coordinate, longitude, of the local administrative unit as provided by OpenStreetMap. |
| Data type | Decimal number |
| Descriptor | dwc:decimalLongitude [UID:0.0.LNGTD332] |
| Descriptor description |
|
| Descriptor target IRI | http://rs.tdwg.org/dwc/terms/decimalLongitude |
| Unit | ° |
| Column Name | Range | Mean | Minimum | Q1 | Median | Q3 | Maximum | Total | Missing | Zero | Blank | Distinct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| lau_longitude | 9 - 10 | 11.55231491 | 7.0647408 | 8.9338624 | 11.5368965 | 13.5383743 | 17.3349040 | 325,084 | 0 ( 0.0% ) | 0 ( 0.0% ) | 0 ( 0.0% ) | 122 ( 0.0% ) |
| Column Name | Completeness | Uniqueness | Most Common Value | Least Common Value |
|---|---|---|---|---|
| lau_longitude |
100.00%
|
0.04%
|
14.5457260 | 7.2763432 |