Version History of Base Table Rows in the SWEREF99 13 30 Index Rutor Collection
The 'Indexrutor Sweref 13 30 History' table is a part of the 'Indexrutor Sweref99 13 30' dataset. This table is a history table, which provides a version history of base table rows. It contains unique identifiers for each row, which are formed by a combination of the row's start date and its raw row number from the data source. The table also includes the start and end dates for each row’s version, indicating when that version of the row was extracted from the source and when a new version emerged. If the end date is null, it means that version of the row is the most recent one.
The table also contains geographic data, which was originally sourced in shapefile format, a common format for storing geometric location and attribute information of geographic features. The geographic data has since been transformed into a final format suitable for this dataset.
The data for this table is sourced from Lantmäteriet (The Land Survey) in Sweden.
In terms of data analytics, this table may be valuable in a variety of applications. For instance, one could track changes in geographic features over time, by examining the version history of each row. This could be useful in environmental studies, urban planning, or infrastructure development. Also, the unique combination of start date and row number could be used in time series analysis to study temporal trends or patterns.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column carries the date when the row was first extracted from the data source. It, along with '_row_number', uniquely identifies each row in the version history table. |
| _end_date | date | The '_end_date' column consists of the date when a new version of the row was extracted from the data source. A null value in this column signifies that the row is the most recent version. |
| _row_number | long | The '_row_number' column contains the number of the row in the raw data as it was extracted from the data source. This, combined with '_start_date', uniquely identifies each row in this version history table. |
| INDEXRUTA | string | The 'INDEXRUTA' column contains the index route from the data source. |
| geom_geojson | string | The 'geom_geojson' column stores the geometrical data of the row in the GeoJSON format. |
| geom_geotext | string | The 'geom_geotext' column contains the geometrical data of the row in textual format. |
| geom_type | string | The 'geom_type' column identifies the type of the geometrical data of the row. |
| geom_centroid | string | The 'geom_centroid' column represents the centroid of the geometrical data of the row. |
| geom_center_x | double | The 'geom_center_x' column signifies the X-coordinate of the center of the geometrical data of the row. |
| geom_center_y | double | The 'geom_center_y' column represents the Y-coordinate of the center of the geometrical data of the row. |
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 | ba0ca7a1-62cf-424b-9012-09aa2b490117 |
| Package id | acd029f9-dced-4015-af6f-f39e39fa19ef |
| Position | 1 |
| Revision id | 6b0c9627-47ca-4ed8-967d-7e41855a5ace |
| State | active |
| Table | indexrutor_sweref99_13_30_zip__indexrutor_sweref_13_30__history |