Historical Versions of 100km Index Data Records
The 'index_100km__history' table is a historical record of a base table that contains geographical data. It keeps track of the version history of each row in the base table, making it possible to see when each piece of data was extracted and when it was replaced with a new version. Each row in this table can be uniquely identified by a combination of the date of extraction and the row number from the raw data source.
Furthermore, this table has geographic information that has been transformed from the shapefile format, a common format for storing geometric locations and attribute information of geographic features. These features can be represented by points, lines, or polygons.
The data for this table is sourced from the 'Lantmäteriet' website, located in Sweden.
In terms of data analytics, this table offers valuable insights. For instance, one could track how geographic features evolve over time by checking when their data was updated. The information in this table could also be used to identify trends in the frequency of data updates, which might point to periods of significant geographic change. Moreover, the geographic data could be used to create time-sensitive models of the area covered by the dataset. These are just a few examples of how the data in this table could be utilized.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | The date when the row was extracted from the data source. Together with '_row_number', it forms a unique identifier for each row in this version history table. |
| _end_date | date | 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 | The number of the row in the raw data extracted from the data source. This, in combination with '_start_date', uniquely identifies each row in this version history table. |
| SHAPE_Leng | double | A column related to the geometric properties of the data. |
| SHAPE_Area | double | A column related to the geometric properties of the data. |
| BK | string | A column that contains specific data, the nature of which is determined by the data source. |
| geom_geojson | string | The geometric data of the row in geojson format. |
| geom_geotext | string | The geometric data of the row in text format. |
| geom_type | string | The type of the geometric data. |
| geom_centroid | string | The centroid of the geometric data. |
| geom_center_x | double | The X coordinate of the center of the geometric data. |
| geom_center_y | double | The Y coordinate of the center of the geometric data. |
No sample for this dataset
Additional Information
| Last updated | August 26, 2024 |
|---|---|
| Created | August 26, 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 | 0e56f46f-b6b6-4ab8-99fe-7950a7821f90 |
| Package id | ec4ee5c0-ed07-48c5-94c6-6abd08c7e1d7 |
| Position | 1 |
| Revision id | b040e819-98c7-4b05-af30-f9393bf0ed3d |
| State | active |
| Table | index_100km_zip__index_100km__history |