Version History of Base Table Rows in Stockholm Dataset Collection
Click here for a data sample
This table is a historical record of geographic features and their associated attributes for a specific area, sourced from the Swedish website 'Lantmäteriet'. The history table tracks the changes in geographic features over time, capturing the version history of each row in its base table. Each entry is uniquely identified by a combination of its start date and a row number. The start date represents when the row was extracted from the data source, while the end date indicates when a new version of the row was extracted. If the end date is null, this signifies that the row is the most current version. Importantly, the table includes geographic information that has been translated from the original shapefile format into a final geographic format. The geographic features are represented as points, lines, or polygons (areas), providing a detailed understanding of the geographic layout of the region. The table can be used for a wide variety of data analytics tasks. For example, it could be used to track changes in land use over time, such as the expansion of urban areas or changes in agricultural land. This could inform urban planning or environmental conservation efforts. Additionally, the table could be used in combination with other data to analyze the relationship between geographic features and other variables, such as population density or climate conditions. This could provide insights for a range of fields, from public health to climatology.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | This column holds the date when a row was first extracted from the data source. The format of the date is YYYY-MM-DD. |
|---|
| _end_date | date | This column contains the date when a newer version of the row was extracted from the data source. The format of the date is YYYY-MM-DD. If this column value is null, it indicates that the row is the most current version. |
|---|
| _row_number | long | This column contains the row number as it appeared in the raw data extracted from the data source. Along with the '_start_date', it forms a unique identifier for each row in this version history table. |
|---|
| OBJECTID | long | This column contains a unique identifier for each object or feature in the dataset. |
|---|
| ID | string | This column contains another unique identifier, which is usually prefixed with 'SE_' to denote the country of origin, Sweden. |
|---|
| CODE_12 | string | This column holds a code that represents the class or type of the object or feature, as defined in the CORINE Land Cover (CLC) classification system. |
|---|
| Area_Ha | double | This column contains the area of the object or feature, measured in hectares. |
|---|
| Remark | string | This column is intended for additional notes or comments related to the object or feature. However, it appears to be unused in the current version of the dataset. |
|---|
| Shape_Leng | double | This column is intended to hold the calculated length of the object or feature. It seems to be unused in the current version of the dataset. |
|---|
| Shape_Area | double | This column contains the calculated area of the object or feature, in square meters. This value is typically very close to the 'Area_Ha' multiplied by 10,000. |
|---|
| geom_geojson | string | This column holds the geometric representation of the object or feature in GeoJSON format, a popular open standard format designed for representing simple geographical features. |
|---|
| geom_geotext | string | This column contains the geometric representation of the object or feature in text format. |
|---|
| geom_type | string | This column contains the type of the geometric representation of the object or feature. In this case, all features are polygons. |
|---|
| geom_centroid | string | This column holds the geometric centroid of the object or feature. The centroid is the arithmetic mean position of all the points in the shape. |
|---|
| geom_center_x | double | This column contains the X-coordinate (longitude) of the geometric center of the object or feature. |
|---|
| geom_center_y | double | This column contains the Y-coordinate (latitude) of the geometric center of the object or feature. |
|---|
