Version History of the Gradnat Line Layer with Degree Line and Arctic Circle in the SVE 20 Million SWEREF 99 TM Shape Dataset
Click here for a data sample
The 'gradnat__history' table contains version history of geographic features represented in the form of lines. Originating from the collection 'sve_20milj_sweref_99_tm_shape', it is a historical record of changes to the geographic features over time. The table records the start and end dates of each version of a row, with the combination of the start date and a unique row number serving as an identifier for each version. If the end date is null, it indicates that the version is the most recent. The table holds geographic data that has been transformed from the original shapefile format. This data includes geographic coordinates and types, such as line strings and points. It also provides additional information about the geographic center of the features. The data in this table is sourced from the 'Lantmäteriet' website located in Sweden. The information in this table could be extremely valuable in data analytics for understanding changes in geographic features over time, for instance, tracking the shift in the Arctic Circle or geographic graticule. Moreover, it could also be used to analyze the correlation between geographic changes and other environmental or climatic factors.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | This column records the date when a row was first extracted from the source. It forms part of a unique identifier for each row in conjunction with the '_row_number' column. This column is specific to this history table and helps track the version history of each row in the base table. |
|---|
| _end_date | date | This column captures the date when a new version of a row was extracted from the data source, effectively marking the 'end date' for the previous version of the row. If the value in this column is null, it indicates that the current row is the most recent version. |
|---|
| _row_number | long | This column contains the number of the row as it appears in the raw data extracted from the data source. Together with the '_start_date' column, it uniquely identifies each row in this history table. |
|---|
| KKOD | string | This column contains the category code for the geographical feature. It refers to various geographical features such as degree lines, the Arctic Circle, etc. as per the data provided by Lantmäteriet in Sweden. |
|---|
| geom_geojson | string | This column stores the geographic data for each row in GeoJSON format, a common open standard format designed for representing simple geographical features, along with their non-spatial attributes. |
|---|
| geom_geotext | string | In this column, the geographic data for each row is represented in a human-readable text format. It offers an alternative way to view and understand the geographic information. |
|---|
| geom_type | string | This column specifies the type of the geographic feature represented in the row. For example, it might indicate whether the feature is a line, point, polygon, etc. |
|---|
| geom_centroid | string | This column contains the geographical point that represents the center (centroid) of the geographical feature. It is represented as a point in a two-dimensional space. |
|---|
| geom_center_x | double | This column represents the X-coordinate (longitude) of the centroid point of the geographical feature. It is part of the spatial data associated with each row. |
|---|
| geom_center_y | double | This column represents the Y-coordinate (latitude) of the centroid point of the geographical feature. It provides spatial information about the location of the geographical feature. |
|---|
