Version History of Index Routes in SWEREF99 18 00 Coordinate System
Click here for a data sample
This is a history table that contains the version history of its base table rows. It is part of a larger dataset collection, sourced from the website of Lantmäteriet (The Land Survey) in Sweden. The table contains unique identifiers for each row, represented by a combination of the row number and the start date. The start date indicates when the row was extracted from the source, while an end date is used to signify when a new version of the row was added. If the end date is null, it indicates that the row is the most recent version. The data also includes geographic information, transformed from a shapefile format, which can be represented by points, lines, or polygons. This information could be particularly useful in data analytics for tracking changes over time, such as monitoring the evolution of geographical features, or studying trends in the data source updates. The table provides two additional columns compared to its base table that hold the start and end dates, allowing for a comprehensive understanding of each data point's history.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | This column contains the date when the row was extracted from the data source. It forms a unique combination with the '_row_number' to identify each row in this version history table. |
|---|
| _end_date | date | This column contains the date when a new version of the row was extracted from the data source. If the value is null, it indicates that the row is the most recent version. |
|---|
| _row_number | long | This column contains the number of the row in the raw data extracted from the source. It forms a unique combination with the '_start_date' to identify each row in this version history table. |
|---|
| INDEXRUTA | string | This column contains specific data related to the 'INDEXRUTA' feature of the dataset. |
|---|
| geom_geojson | string | This column contains the Geographical JSON data representing the geographical feature associated with each row. |
|---|
| geom_geotext | string | This column stores the geographic details in a text format. |
|---|
| geom_type | string | This column specifies the type of the geometric structure associated with each row. |
|---|
| geom_centroid | string | This column contains data representing the centroid of the geographical feature associated with each row. |
|---|
| geom_center_x | double | This column contains the X coordinate of the center of the geographical feature associated with each row. |
|---|
| geom_center_y | double | This column contains the Y coordinate of the center of the geographical feature associated with each row. |
|---|
