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

Total Drain by Regional Unit in Finland

This dataset collection contains one or more dataset tables sourced from the web site of Luke in Finland.

Tables

  • Total Drain by Regional UnitTSV

    This table contains data on the total drain for different regional units in Finland. The data is sourced from the web site of Luke, which is the Finnish Forest Centre. It provides information on the total drain of trees by year, regional unit, forest ownership category, and species of tree. The 'total_drain' column represents the total amount of trees drained. This table can be used for various data analytics tasks such as analyzing the trend of tree drain over time, comparing drain between different regional units, exploring the relationship between drain and forest ownership categories, and studying the impact of tree species on drain. The data in this table can help in understanding forestry practices and making informed decisions related to sustainable forest management.

  • Total Drain by Regional Unit - Species of TreeTSV

    This table contains data from 'Luke' website, which originates from Finland (ISO country code: 'fi'). The table provides information on total drain by regional unit and species of trees. It can be utilized in various data analytics tasks such as analyzing the distribution of tree species across different regional units, determining the trends in total drain over time, and assessing the impact of tree species on drain levels.

  • Total Drain by Regional Unit and YearTSV

    This table contains information about total drain by regional unit and year. The data is sourced from the web site of Luke, which originates from Finland.

  • Total Drainage by Regional Unit - Finnish Forest Centre Regional UnitTSV

    This table contains data on the total drain by regional units in Finland. The data is sourced from the website of Luke, the Finnish Forest Centre. It provides information on the total amount of drain in different regional units of Finland. The table includes columns such as 'extract_date', 'row_number', 'code', and 'label'. These columns can be utilized in data analytics to analyze trends in drain over time, compare drain across different regions, perform statistical calculations, and generate visualizations.

  • Total Drainage by Regional Unit and Forest Ownership CategoryTSV

    This table provides information on total drain by regional unit and dimension forest ownership category. The data is sourced from the website of Luke, which originates from Finland (ISO country code 'fi'). The table contains data columns such as '_extract_date', '_row_number', 'code', and 'label'. These columns can be utilized in various data analytics scenarios, such as analyzing the overall drain rate in different regional units, comparing drain rates based on forest ownership categories, monitoring changes in drain rates over time, and identifying areas with the highest drain rates. The data in this table can provide valuable insights into forest drain patterns and aid in decision-making processes related to forest management and conservation.

  • Version History of Total Drain by Regional UnitTSV

    This table contains the version history of the rows from the 'total drain by regional unit fact' table. The data is sourced from the website of Luke, which is the Finnish Forest Centre. The table includes columns such as '_start_date' and '_end_date', which represent the extraction dates of the row versions. The 'year' column provides the year of the data, while 'the Finnish Forest Centre regional unit', 'forest ownership category', 'species of tree', and 'total drain' columns contain specific information related to the drain by regional unit. The table can be utilized for data analytics purposes, such as calculating trends in drain over time, analyzing drain based on regional units and ownership categories, or studying the impact of different tree species on drain. The data is...

  • Version History of Total Drain by Regional Unit - Finnish Forest Centre Regional UnitTSV

    This table contains the version history of the rows in the 'total drain by regional unit - dim the Finnish Forest Centre Regional Unit' table from the data source 'Luke' in Finland. It includes the columns '_start_date' and '_end_date' which indicate the extraction dates of the row versions. The table can be utilized in data analytics to track changes in the total drain values by regional unit over time, analyze the trends in drain values for different regions, compare the drain values between different extraction dates, and to identify the most recent version of the rows.

  • Version History of Total Drain by Regional Unit and Forest Ownership Category from Luke (Finland)TSV

    This table contains the version history of the rows extracted from the 'Total Drain by Regional Unit' data source, which provides information on forest ownership categories. The data is sourced from the Luke website, which originates from Finland (ISO country code 'fi'). Each row in the table represents a specific version of the data, with the '_start_date' column indicating the extraction date, and the '_end_date' column indicating the date when a new version of the row was extracted. If the '_end_date' value is null, it means that the row represents the most recent version of the data. The table can be utilized in data analytics to track changes and analyze trends over time in total drain values for different regional units and forest ownership categories.

  • Version History of Total Drain by Regional Unit in Finland Extracted from Luke WebsiteTSV

    This table contains the version history of the rows from the 'total drain by regional unit, dimension year' table. The rows in this table represent the different versions of the data extracted from the data source, where each version is identified by a unique '_row_number'. The '_start_date' column indicates the date when the row was extracted, while the '_end_date' column represents the date when a new version of the row was extracted. If the '_end_date' is null, it means that the row is the most recent version of the data. The 'code' column contains the codes associated with the regional units, and the 'label' column provides the labels or names corresponding to those codes. The data in this table can be utilized in data analytics to analyze the changes in the total drain by regional...

  • Version History of Total Drain by Regional Unit, Dimension Species of Tree [From Luke - Finland]TSV

    This table represents the version history of the rows in the 'Total Drain by Regional Unit - Dim Species of Tree' table sourced from the web site of 'Luke' which originates from the country Finland (ISO country code: FI). It contains information about the start date and end date of each version of the rows. The table can be utilized in data analytics to track changes and analyze trends over time for the total drain by regional units and species of trees. By comparing the start and end dates of the rows, it is possible to identify when and how the data has been updated or modified. This can be valuable for monitoring changes in the total drain values and studying the impact of various factors on the drain by regional unit and species of trees.

Column Descriptions

Total Drainage by Regional Unit and Forest Ownership Category

Column Type Comment
_extract_date date The date when the data was extracted from the source.
_row_number long The row number of the data entry.
code int The unique code associated with the item.
label string The label or name of the item.

Version History of Total Drain by Regional Unit and Forest Ownership Category from Luke (Finland)

Column Type Comment
_start_date date The start date of the validity period for the row version.
_end_date date The end date of the validity period for the row version.
_row_number long The number assigned to the row version in the version history table.
code int The code associated with the row version.
label string The label associated with the row version.

Total Drain by Regional Unit - Species of Tree

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

Version History of Total Drain by Regional Unit, Dimension Species of Tree [From Luke - Finland]

Column Type Comment
_start_date date The start date of the validity period of the row version.
_end_date date The end date of the validity period of the row version.
_row_number long The unique number assigned to each row version.
code string The code associated with the row version.
label string The label or description of the row version.

Total Drainage by Regional Unit - Finnish Forest Centre Regional Unit

Column Type Comment
_extract_date date The date when the data was extracted from the source.
_row_number long The unique identifier for each row in the table.
code int The unique code corresponding to each item or entity.
label string The descriptive label or name associated with each item or entity.

Version History of Total Drain by Regional Unit - Finnish Forest Centre Regional Unit

Column Type Comment
_start_date date The validity period start date of the row version in the table
_end_date date The validity period end date of the row version in the table
_row_number long The unique identifier assigned to each row version in the table
code int The code associated with the row version in the table
label string The label assigned to the row version in the table

Total Drain by Regional Unit

Column Type Comment
_extract_date date The date when the data was extracted from the table.
_row_number long The number assigned to each row of data in the table.
year int The year when the data was recorded.
the_finnish_forest_centre_regional_unit int The regional unit of the Finnish Forest Centre where the data was collected.
forest_ownership_category int The category of forest ownership for the specific data entry.
species_of_tree string The species of tree recorded in the data entry.
total_drain int The total drain value of the specific data entry.

Version History of Total Drain by Regional Unit

Column Type Comment
_start_date date The start date of the validity period of the row version.
_end_date date The end date of the validity period of the row version.
_row_number long The row number of the version in the table.
year int The year of the data recorded.
the_finnish_forest_centre_regional_unit int The regional unit of the Finnish Forest Centre.
forest_ownership_category int The category of forest ownership.
species_of_tree string The species of the tree.
total_drain int The total drain of the forest.

Total Drain by Regional Unit and Year

Column Type Comment
_extract_date date The date and time when the record was extracted.
_row_number long The unique identifier assigned to each row.
code int The code associated with the label.
label int The label associated with the code.

Version History of Total Drain by Regional Unit in Finland Extracted from Luke Website

Column Type Comment
_start_date date The start date of the validity period for the row version.
_end_date date The end date of the validity period for the row version.
_row_number long The unique identifier of the row version.
code int The code associated with the row version.
label int The label associated with the row version.

Additional Info

Last Updated May 20, 2024
Created October 1, 2023