Historical Versions of Base Table Rows in Sweden's Geographic Dataset Collection from 1960
The table 'sverigelager1960__history' is a part of the dataset collection 'utfall_historiska_ortofoto_sverigelager1960_shape'. This table is of historical nature, containing the version history of its base table rows. It possesses unique identifiers for each row, formulated by a combination of the date the row was extracted from the data source and the row number in the raw data. Furthermore, it gives insights into when a row was updated with a new version or if it is the most recent version, indicated by a null value in the end date column.
Geographic data is a significant part of this table. Originally in the shapefile format, this data has been transformed into its final geographic format, representing geographic features as points, lines, or polygons (areas). The source of this table is the 'Lantmäteriet' website, based in Sweden.
With the rich historical and geographic data provided in this table, there are several potential applications in data analytics. For example, one could perform a temporal analysis to understand the frequency or pattern of updates to the base table rows. Additionally, the geographic data could be utilized to perform spatial analysis or mapping of the geographic features, revealing patterns and trends related to location. Lastly, by analyzing the row version history, one could identify any data anomalies or inconsistencies over time.
Field Descriptions
Name | Data type | Description |
---|---|---|
_start_date | date | This column contains the date when the row was extracted from the data source. Together with the '_row_number' column, it forms a 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 of 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 in the raw data extracted from the data source. It is used in combination with the '_start_date' column to uniquely identify each row in the table. |
RT90RUTA | string | This column contains data related to the 'RT90RUTA' aspect of the dataset. The specific content and format of the data can vary depending on the nature of the dataset. |
FLYGAR | string | This column contains data related to the 'FLYGAR' aspect of the dataset. The specific content and format of the data can vary depending on the nature of the dataset. |
geom_geojson | string | This column contains the geometric data of the row in GeoJSON format. GeoJSON is a format for encoding a variety of geographic data structures. |
geom_geotext | string | This column contains the geometric data of the row in text format. The specific format of the geometric data can vary depending on the nature of the dataset. |
geom_type | string | This column specifies the type of the geometric data contained in the row. The type can vary depending on the nature of the data and the geographic area it represents. |
geom_centroid | string | This column contains the centroid of the geometric data. The centroid is the geometric center of a shape. |
geom_center_x | double | This column contains the X-coordinate of the center of the geometric data. It is used in combination with the 'geom_center_y' column to specify the location of the center of the geometric data. |
geom_center_y | double | This column contains the Y-coordinate of the center of the geometric data. It is used in combination with the 'geom_center_x' column to specify the location 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 | fc82edc5-cdc8-40ed-9e15-42c429af4fc8 |
Package id | ee2c9510-e772-4d86-aa8c-7241b31f7271 |
Position | 1 |
Revision id | 6098593b-b723-4949-a675-df2fa7a9ae34 |
State | active |
Table | utfall_historiska_ortofoto_sverigelager1960_shape_zip__sverigelager1960__history |