Version History of Irrigation Methods by Region over Time
Click here for a data sample
The irrigation method by region and year version history table contains a record of past versions of the base table 'irrigation_method_by_region__dim_year'. It includes additional columns '_start_date' and '_end_date', which represent the starting and ending dates of each row version. This table, sourced from the website of 'Luke' in Finland, can be utilized in various data analytics tasks. For instance, it enables analysis of changes in irrigation methods over time for different regions and years. The data can be used to identify trends, patterns, and discrepancies in the chosen region's irrigation practices, and further support decision-making processes related to water resource management and agricultural planning.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The start date indicating the validity period of the row version. |
|---|
| _end_date | date | The end date indicating the validity period of the row version. |
|---|
| _row_number | long | The number assigned to the row version. |
|---|
| code | string | The code associated with the row version. |
|---|
| label | string | The label associated with the row version. |
|---|
