To download the data set, please sign up or log in

Field and Horticultural Area Available for Irrigation by Region

This dataset collection consists of one or more tables related to field and horticultural area available for irrigation by region. The tables in this dataset collection are sourced from the website of Luke, the Natural Resources Institute Finland. Luke provides information regarding the available land for irrigation in Finland. The dataset collection provides data on the field and horticultural areas that can be irrigated in different regions of Finland. The tables in this dataset collection present detailed information about the extent of irrigable land in various regions of Finland. The data is collected and updated by Luke to provide valuable insights into the field and horticultural areas suitable for irrigation purposes in the country.

Tables

  • Field and Horticultural Area Available for Irrigation by RegionTSV

    This table contains data on the field and horticultural areas available for irrigation, categorized by region. The data is sourced from Luke (Natural Resources Institute Finland), which is the official rural research institute of Finland. The table provides information on the extraction date, row number, code, and label of each entry. The data in this table can be utilized in various data analytics applications, such as analyzing the distribution of irrigated areas across different regions, identifying trends in field and horticultural areas over time, and assessing the impact of irrigation on agricultural productivity in different parts of Finland.

  • Field and Horticultural Area Available for Irrigation by RegionTSV

    This table contains data on field and horticultural areas available for irrigation by region. The data is sourced from the web site of Luke, which originates from Finland (ISO country code 'FI'). The table includes information such as the extract date, row number, year, ELY centre, data, and field and horticultural area available for irrigation. The data in this table can be utilized in data analytics to analyze the availability of irrigation areas over time, compare the ELY centres' irrigation capacities, track changes in field and horticultural areas available for irrigation, and assess the overall water resource management in Finland's agricultural sector.

  • Field and Horticultural Area Available for Irrigation by Region - Year DimensionTSV

    This table provides information on the field and horticultural areas available for irrigation, categorized by region and year. The data is sourced from the official website of Luke, which is the Natural Resources Institute Finland. Luke is a research organization operating in Finland (ISO country code 'fi'). The table contains several columns including the extraction date, row number, code, and label. The data in this table can be utilized in data analytics to analyze the trends and changes in irrigation availability over time, identify regions with the highest and lowest irrigation capacities, compare the utilization of irrigation resources across different years, and assess the overall distribution of field and horticultural areas for irrigation in Finland.

  • Version History of Field and Horticultural Area Available for Irrigation by Region - FactTSV

    This table contains the version history of the rows extracted from the 'Luke' website, which provides data from Finland. The table records the changes made to the 'field_and_horticultural_area_available_for_irrigation_by_region__fact' base table over time. Each row includes the start date and end date of the version. The table can be used in data analytics to analyze the historical changes in field and horticultural area available for irrigation by region. By tracking the changes in the data over time, it is possible to identify trends, patterns, and fluctuations in the availability of irrigation areas across different years and ELY centres.

  • Version History of Field and Horticultural Area Available for Irrigation by Region and Year in Finland - LukeTSV

    This table contains the version history of the rows in the 'Field and Horticultural Area Available for Irrigation by Region - Dim Year' table. Each row in this table represents a specific version of a row from the base table. It includes additional columns '_start_date' and '_end_date' which indicate the dates when the versions of the rows were extracted from the data source. If the '_end_date' is null, it means that the row is the most recent version. The data in this table is sourced from the website 'Luke' which originates from Finland (ISO country code: 'FI'). The table provides valuable data for data analytics, enabling analysis of changes in field and horticultural area available for irrigation over time, identifying trends and patterns, and facilitating comparison of different...

  • Version History of Field and Horticultural Area Available for Irrigation by Region in Ely Centre, Luke (Finland)TSV

    This table contains the version history of the rows in the 'field_and_horticultural_area_available_for_irrigation_by_regiondim_ely_centrehistory' table. It is sourced from the web site of Luke, which originates from the country Finland (ISO country code 'fi'). The table includes information about the start and end dates of each version of the rows, along with their row numbers, codes, and labels. By analyzing this data, valuable insights can be gained regarding the historical changes and updates in the field and horticultural area available for irrigation by region in Ely Centre. This information can be utilized for various data analytics purposes such as identifying trends, tracking changes over time, and comparing different versions of the data.

Column Descriptions

Field and Horticultural Area Available for Irrigation by Region

Column Type Comment
_extract_date date The date when the data was extracted from the source system.
_row_number long The unique identifier assigned to each row in the table.
code int The unique code assigned to each record in the table.
label string The label or name associated with each code in the table.

Version History of Field and Horticultural Area Available for Irrigation by Region in Ely Centre, Luke (Finland)

Column Type Comment
_start_date date The start date indicating the beginning of the validity period of the row version.
_end_date date The end date indicating the end of the validity period of the row version.
_row_number long A unique identifier assigned to each row version.
code int A code value associated with the row version.
label string A label or name associated with the row version.

Field and Horticultural Area Available for Irrigation by Region - Year Dimension

Column Type Comment
_extract_date date The date when the data was extracted from the source system.
_row_number long The number assigned to each row in the table.
code int A unique identifier for each item in the table.
label int The human-readable label for each item in the table.

Version History of Field and Horticultural Area Available for Irrigation by Region and Year in Finland - Luke

Column Type Comment
_start_date date The column indicating the start date of the validity period of the row version.
_end_date date The column indicating the end date of the validity period of the row version.
_row_number long The column containing the row number of the version in the table.
code int The column storing the code associated with the row version.
label int The column storing the label associated with the row version.

Field and Horticultural Area Available for Irrigation by Region

Column Type Comment
_extract_date date The date when the data was extracted.
_row_number long The row number of the data entry.
year int The year for which the data is recorded.
ely_centre int The center location for the Ely area.
data string The data recorded for the respective entry.
field_and_horticultural_area_available_for_irrigation int The available area for irrigation in the field and horticultural sector.

Version History of Field and Horticultural Area Available for Irrigation by Region - Fact

Column Type Comment
_start_date date The date when the row version becomes valid.
_end_date date The date when the row version becomes invalid.
_row_number long The sequential number assigned to each row version.
year int The year associated with the row version.
ely_centre int The center location of the ELY (Centres for Economic Development, Transport and the Environment).
data string The data related to the row version.
field_and_horticultural_area_available_for_irrigation int The area of land available for irrigation for field and horticultural purposes.

Additional Info

Last Updated May 20, 2024
Created October 2, 2023