Historical Versions of Forest Laser Data Rows
This table is a historical record of forest laser data gathered and maintained by Lantmäteriet (The Swedish Mapping, Cadastral, and Land Registration Authority) in Sweden. Its purpose is to track changes over time in the underlying base table. Each row in the table is identified uniquely by a combination of the date the data was extracted and the row number in the original raw data. This allows for a comprehensive version history of each row in the base table, with the start date indicating when the row was added and the end date representing when a newer version was extracted. If the end date is null, this indicates that the current row is the most recent version.
The table also contains geographic information, originally in shapefile format, which has been transformed into a more usable format for analysis. This geographic information can represent features as points, lines, or polygons.
In data analytics, this table could be invaluable in a number of ways. For example, it could be used to analyze patterns and trends over time in the forest laser data, revealing insights into changes in the forest environment. The geographic data could be used in spatial analysis, allowing for the visualization of data on maps or the study of spatial relationships between different geographic features. Additionally, the historical data could be used to train predictive models, helping to forecast future changes in the data and aiding in decision-making and strategic planning.
Field Descriptions
Name | Data type | Description |
---|---|---|
_start_date | date | This column marks the date when the row was extracted from the data source. Together with the '_row_number' column, it forms a unique identifier for each row in this version history table. |
_end_date | date | This column contains the date when a new version of the row was extracted from the data source. If the value is null, it indicates that the row is the most recent version. |
_row_number | long | This column contains the number of the row in the raw data extracted from the data source. It forms a unique identifier for each row in combination with the '_start_date' column. |
OMRÅDE | string | The 'OMRÅDE' column holds the area related information in the dataset. |
STATUS | string | The 'STATUS' column contains the status information of the corresponding row. |
geom_geojson | string | This column contains the geometric information of the area in GeoJSON format. |
geom_geotext | string | This column holds the geometric information of the area in a textual format. |
geom_type | string | The 'geom_type' column specifies the type of the geometric shape representing the area. |
geom_centroid | string | This column contains the centroid of the geometric shape representing the area. |
geom_center_x | double | The 'geom_center_x' column holds the X-coordinate of the center of the geometric shape representing the area. |
geom_center_y | double | The 'geom_center_y' column holds the Y-coordinate of the center of the geometric shape representing the area. |
No sample for this dataset
Additional Information
Last updated | August 26, 2024 |
---|---|
Created | August 26, 2024 |
License | No License Provided |
Geographic coverage | |
Geographic granularity | |
Temporal coverage from | |
Temporal coverage to | |
Temporal coverage to | |
Adapter | shapefile |
Country | se |
Database | se_lantmateriet |
Extract date | 2024-08-26 |
Id | 9823e5d3-17d4-472f-89ff-5398e29cd24d |
Package id | 6813d068-4f5d-47e8-9a76-b2dfc5fc375c |
Position | 1 |
Revision id | ea87d1ef-acfc-48d6-8488-d7226905377a |
State | active |
Table | utfall_laserdata_skog_shape_zip__utfall_laserdata_skog__history |