Field and Horticultural Area Available for Irrigation by Region
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 |