Version History of Base Table Rows in Varmland Dataset Collection
The table under consideration is a history table that is part of a larger dataset collection. It originates from 'Lantmäteriet' (The National Land Survey), a website based in Sweden. This table contains a detailed record of the version history of its base table rows, making it immensely valuable for tracking changes over time. Each entry in the table is uniquely identified by a combination of the row number and the date the row data was extracted from the original source.
The table includes additional columns, namely the start date and end date, which are not present in the base table. The start date refers to when the data was initially extracted, while the end date signifies when a new version of the row was introduced. A null value in the end date column indicates that the data in the row is the most current version.
One of the significant features of this table is its geographical data, originally in a shapefile format - a popular geospatial vector data format. This geographic data has been transformed into a final format from the initial shapefile format. Geographic features can be represented in various forms such as points, lines, or polygons (areas), providing a detailed spatial understanding of the data.
In terms of data analytics, this table could be used in various ways. For instance, the historical data can be analyzed to track changes and trends over time, which would be particularly useful in fields such as environmental studies or urban planning. The geographical data could be utilized in spatial analysis, helping in tasks such as identifying patterns or anomalies in the data. Moreover, the combination of historical and geographical data could provide valuable insights in predictive modeling, forecasting, and decision-making processes.
Field Descriptions
Name | Data type | Description |
---|---|---|
_start_date | date | This column contains the date when the row was extracted from the data source. Together with '_row_number', 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 conjunction with '_start_date'. |
OBJECTID | long | This column contains an object identifier, which is a unique identifier for the object. |
ID | string | This column holds the ID of the object. |
CODE_12 | string | This column contains a 12-digit code associated with the object. |
Area_Ha | double | This column contains the area of the object in hectares. |
Remark | string | This column includes any additional remarks or comments about the object. |
Shape_Leng | double | This column contains the length of the shape of the object. |
Shape_Area | double | This column holds the area of the shape of the object. |
geom_geojson | string | This column contains the geometric representation of the object in GeoJSON format. |
geom_geotext | string | This column contains the geometric representation of the object in geotext format. |
geom_type | string | This column indicates the type of the geometric representation of the object. |
geom_centroid | string | This column contains the centroid of the geometric representation of the object. |
geom_center_x | double | This column contains the X-coordinate of the center of the geometric representation of the object. |
geom_center_y | double | This column contains the Y-coordinate of the center of the geometric representation of the object. |
No sample for this dataset
Additional Information
Last updated | August 27, 2024 |
---|---|
Created | August 27, 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 | 8db673ff-7eb9-4709-af1f-9b5bc247156c |
Package id | bdfc37ab-2d87-436a-ba7b-6312fe00922e |
Position | 17 |
Revision id | 1c53284b-7b0a-4ebe-bea5-c10eda577b5a |
State | active |
Table | varmland_zip__clc12_66e_no__history |