Historical Version Records of Base Table Rows in Vasternorrland Dataset
The 'clc12_69f_no__history' table is a historical dataset, part of the larger 'vasternorrland' dataset collection. As a history table, it stores the version history of its base table rows, allowing users to track changes over time. The unique identifiers for each row are a combination of the start date and the row number, providing a clear timeline of data changes.
This table is particularly rich in geographic information, originally in the shapefile format which is a common format for storing the geometric location and attribute information of geographic features. This geographic data has been transformed into a final format from the original shapefile format, enabling users to analyze points, lines, or polygon-based areas.
Sourced from the 'Lantmäteriet' (The Land Survey) website in Sweden, this dataset provides a comprehensive historical overview of its base table rows. If you're analyzing historical trends or changes over time, this dataset is a valuable resource.
For instance, one could use this data in analytics to track changes in land use over time, as the table records the area of each geographic feature. Likewise, the geographic information could be used to analyze spatial patterns or trends, potentially providing insights into environmental changes. Similarly, by leveraging the start and end dates, one could gauge the frequency of updates or changes, which could inform understanding of data management practices or trends in the data source itself.
Field Descriptions
Name | Data type | Description |
---|---|---|
_start_date | date | This column contains the date when the row was extracted from the data source. It forms part of a unique identifier for each row in this version history table, together with the '_row_number' column. |
_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 means 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. Together with the '_start_date' column, it forms a unique identifier for each row in this version history table. |
OBJECTID | long | This column contains a unique identifier for each object in the table. |
ID | string | This column contains a unique identification number for each row in the table. |
CODE_12 | string | This column contains a coded value, possibly representing a certain category or type. |
Area_Ha | double | This column contains the area of the object, measured in hectares. |
Remark | string | This column contains any additional remarks or notes related to the row. |
Shape_Leng | double | This column contains the length of the shape of the object. |
Shape_Area | double | This column contains 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 a textual representation of the geometry of the object. |
geom_type | string | This column contains the type of the geometry of the object. |
geom_centroid | string | This column contains the centroid of the geometry of the object. |
geom_center_x | double | This column contains the x-coordinate of the center of the geometry of the object. |
geom_center_y | double | This column contains the y-coordinate of the center of the geometry 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 | 413b9f7e-f516-47a4-bbfd-8e158a36588b |
Package id | 363c72ba-f2e9-4503-ae45-694b4a3163d3 |
Position | 7 |
Revision id | 5bbaed12-cc01-4da8-a215-dc0b7cac293f |
State | active |
Table | vasternorrland_zip__clc12_69f_no__history |