Version History of Base Table Rows in Stockholm Dataset Collection
This history table is part of a dataset collection sourced from the Swedish website, 'Lantmäteriet'. It stores the version history of geographic features, including various details and changes over time. The table contains unique identifiers for each row, formed by a combination of the date the row was extracted and the row number. This table also includes dates signifying when a new version of the row was extracted, and if there's no 'end date' provided, it signifies that the version of the row is the most recent. Geographic information, initially in the shapefile format, is included, which represents the location and attribute information of geographic features. Features can be represented by points, lines, or polygons.
The table contains information such as the unique object identifiers, identifiers related to the geographic region, area measurements in hectares, and codes related to the geographic feature. There are also details regarding the shape length and area. Geographic information is detailed through various formats including GeoJSON, GeoText, and centroid coordinates. An interesting aspect of this table is that it also includes the type of geometric shape that represents each geographic feature.
Data from this table can be utilized in numerous ways in data analytics. For instance, changes in geographic feature area over time could be tracked to monitor environmental changes or urban development. The geographic data can be used to create detailed, time-lapse visual maps to better illustrate these changes. Additionally, data analysts could use this data to perform spatial analysis, allowing for the study of spatial relationships and patterns. The table could also prove useful in infrastructure planning, land use studies, and resource management, among others.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This is a date column that records when the data row was initially extracted from the data source, forming part of the unique identifier for each row in this version history table. |
| _end_date | date | This date column indicates when a new version of the data row was extracted from the data source. If the value is null, it signifies that the data row is the most recent version. |
| _row_number | long | This column holds the row number as it appears in the raw data source. In conjunction with '_start_date', it forms a unique identifier for each row in this version history table. |
| OBJECTID | long | This column contains unique identifiers for the objects in the data set. |
| ID | string | This column represents a unique identification code for each entry in the data set, typically following the format 'SE_' followed by a series of numbers. |
| CODE_12 | string | This column contains specific codes associated with each data entry. |
| Area_Ha | double | This column records the area in hectares for each data entry. |
| Remark | string | This column is reserved for any additional comments or notes regarding each data entry. It can commonly be null if there are no remarks to be made. |
| Shape_Leng | double | This column is intended to store the length of the shape associated with each data entry. |
| Shape_Area | double | This column records the area of the shape associated with each data entry. |
| geom_geojson | string | This column stores the geometric data associated with each entry in GeoJSON format, a popular open standard format designed for representing simple geographical features. |
| geom_geotext | string | This column holds the geometric data associated with each data entry in a text-based format. |
| geom_type | string | This column indicates the type of geometric data associated with each data entry (e.g., 'ST_POLYGON' for polygon shapes). |
| geom_centroid | string | This column stores the geometric center (or 'centroid') of the shape associated with each data entry. |
| geom_center_x | double | This column records the x-coordinate of the geometric center of the shape associated with each data entry. |
| geom_center_y | double | This column records the y-coordinate of the geometric center of the shape associated with each data entry. |
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 | 9da1233e-d69a-42be-a99f-e6d934581a3b |
| Package id | eb0d036e-d9a1-45eb-8f03-d57004b03840 |
| Position | 1 |
| Revision id | 592b6665-4b83-46a4-ad26-5b9e766a5351 |
| State | active |
| Table | stockholm_zip__clc12_65g_nv__history |