Version History of Index Routes: A Comprehensive Table of Geospatial Data and Temporal Details
The 'indexrutor_sweref_17_15__history' table is a valuable part of the 'indexrutor_sweref99_17_15' dataset collection. This table is a history table, meaning it contains the version history of its base table rows. What makes it unique is that it records the changes in the data over time, using two specific columns to mark the start and end dates of each version. If a row's end date is null, it signifies that the version is the most recent one.
In addition to temporal information, the table also carries geographical data transformed from the shapefile format, a standard used for storing geographical location and attribute information. This geographical data can represent features as points, lines, or polygons, offering a rich source of spatial analysis opportunities.
The data for this table is sourced from the website of 'Lantmäteriet' (The Land Survey) in Sweden. This site is a reliable source for geographical data, further enhancing the value of the table.
In terms of data analytics, this table could be used in multiple ways. For example, it can be used to analyze historical changes in geographical features, providing critical insights into patterns of change over time. Furthermore, the table's data can complement other data sources to provide a comprehensive view in studies related to environmental changes, urban planning, transport, and infrastructure development among others. The row identification system, which uses a combination of a row number and start date, ensures the reliability and traceability of the data, which is crucial in any analytical work.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. It is part of the combination that uniquely identifies 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 in this column is null, it indicates that the 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. It forms a unique combination with '_start_date' to identify each row in this version history table. |
| INDEXRUTA | string | This column contains specific data related to the 'INDEXRUTA'. The exact nature of this data would depend on the context provided by the data source. |
| geom_geojson | string | This column contains the GeoJSON representation of the geometry associated with each row. GeoJSON is a format for encoding geographical data structures. |
| geom_geotext | string | This column contains a textual representation of the geometry associated with each row. |
| geom_type | string | This column specifies the type of the geometry associated with each row. For instance, the geometry could be a point, a line, or a polygon. |
| geom_centroid | string | This column contains the centroid of the geometry associated with each row. The centroid is the geometric center of a plane figure or shape. |
| geom_center_x | double | This column contains the x-coordinate of the center of the geometry associated with each row. |
| geom_center_y | double | This column contains the y-coordinate of the center of the geometry associated with each 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 | 517d0604-754f-49a1-b0a0-75f32deaf912 |
| Package id | 44cd8cd9-b03d-48d0-89e7-6289dc5f74d8 |
| Position | 1 |
| Revision id | ac81e83b-3ec8-4b5a-8bac-1144904f4764 |
| State | active |
| Table | indexrutor_sweref99_17_15_zip__indexrutor_sweref_17_15__history |