Version History of Base Table Rows in the Swedish 20 Million SWEREF 99 TM Shape Dataset
Click here for a data sample
The 'rutnat__history' table is a historical record of geographic data, specifically related to the grid and frame features in Sweden. It is sourced from the 'Lantmäteriet' (Swedish Mapping, Cadastral, and Land Registration Authority) website. The table contains a unique combination of the date the row was extracted and the row number, which identifies each row in the table. The table has two specific columns for tracking the history of the data: a start date, indicating when the row was initially extracted, and an end date, signifying when a new version of the row was obtained. If the end date is null, it indicates that the current row is the latest version. The table also contains geographic data transformed from the shapefile format, describing the location and attributes of geographic features. This data includes geometric types, geographic coordinates, and other geographical specifications. This table could be utilized in data analytics for various purposes, such as tracking changes in geographic features over time, monitoring patterns in the data extraction process, or analyzing the distribution and characteristics of specific geographic features in Sweden.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | This column represents the date when the row was extracted from the source. The format follows the standard YYYY-MM-DD. |
|---|
| _end_date | date | This column represents the date when a new version of the row was extracted from the source. If the value is null, it indicates that the row is the most recent version. |
|---|
| _row_number | long | This column contains the sequential number of the row, as it was in the raw data extracted from the source. This, combined with the '_start_date', uniquely identifies each row in the version history table. |
|---|
| KKOD | string | This column represents the category code. It is a numerical value that corresponds to a specific category in the data set. |
|---|
| geom_geojson | string | This column stores the geometric data in the GeoJSON format, which is a format for encoding a variety of geographic data structures. |
|---|
| geom_geotext | string | This column contains the geometric data in a textual format. It gives a human-readable representation of the geometry. |
|---|
| geom_type | string | This column indicates the type of the geometric data stored in the row. In this case, it signifies that the geometry is a line string. |
|---|
| geom_centroid | string | This column contains the centroid of the geometric figure. The centroid is the geometric center of a plane figure or shape. |
|---|
| geom_center_x | double | This column represents the x-coordinate of the geometric figure's center point in spatial reference. It is part of the geometry details. |
|---|
| geom_center_y | double | This column represents the y-coordinate of the geometric figure's center point in spatial reference. It is also part of the geometry details. |
|---|
