Historical Version Control Record of Base Table Rows in Dalarna Dataset Collection
The table under description is a historical record, part of a larger dataset collection. It specializes in maintaining the version history of its base table rows, providing a unique identifier for each row via a combination of a start date and a row number. The start date indicates when the row was initially extracted from the data source, while an end date signals when a new version of the row was extracted. If the end date value is null, this indicates that the row is the current, most recent version.
The table also contains geographical information, originally stored in a shapefile format, a format widely used for storing the geometric location and attribute information of geographic features, such as points, lines, or polygons. This geographic information has been transformed into a final format from the original shapefile format for easier data manipulation and analysis.
The table's data is sourced from Lantmäteriet, the Swedish National Land Survey, in Sweden.
Potential applications of this data in analytics could include tracking changes in geographic features over time, aiding in urban planning or environmental studies. For example, if the data is related to land use, analysts could track how certain areas have developed or changed. Alternatively, if the data is related to environmental features, it could be used to monitor changes and trends in these features over time, aiding in environmental conservation efforts.
Field Descriptions
Name | Data type | Description |
---|---|---|
_start_date | date | The date when the row was extracted from the data source. Together with '_row_number', it uniquely identifies each row in this version history table. |
_end_date | date | The date when a new version of the row was extracted from the data source. If its value is null, it means that the row is the most recent version. |
_row_number | long | The number of the row in the raw data extracted from the data source. Together with '_start_date', it uniquely identifies each row in this version history table. |
OBJECTID | long | A unique identifier for each object in the table. |
ID | string | A unique identifier for each entry in the table. |
CODE_12 | string | A code associated with each row in the table. |
Area_Ha | double | The area (in hectares) associated with each row in the table. |
Remark | string | Any additional comments or observations associated with each row. |
Shape_Leng | double | The length of the shape associated with each row. |
Shape_Area | double | The area of the shape associated with each row. |
geom_geojson | string | The geometric representation of the data in GeoJSON format. |
geom_geotext | string | The geometric representation of the data in text format. |
geom_type | string | The type of the geometric representation of the data. |
geom_centroid | string | The centroid of the geometric representation of the data. |
geom_center_x | double | The x-coordinate of the center of the geometric representation of the data. |
geom_center_y | double | The y-coordinate of the center of the geometric representation of the data. |
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 | eebc9565-00c6-490e-950f-7cbdab01c6db |
Package id | b5850e4f-b288-47bd-aa8e-1b5ae61e62d6 |
Position | 9 |
Revision id | 061d419e-5ad5-4060-a724-7f0a1c38dd06 |
State | active |
Table | dalarna_zip__clc12_67d_no__history |