Historical Versions of Base Table Rows in Sweden's Geographic Dataset Collection from 1960

To download the data set, please sign up or log in

Click here for a data sample

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_datedateThis 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_datedateThis 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_numberlongThis 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.
RT90RUTAstringThis 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.
FLYGARstringThis 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_geojsonstringThis column contains the geometric data of the row in GeoJSON format. GeoJSON is a format for encoding a variety of geographic data structures.
geom_geotextstringThis 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_typestringThis 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_centroidstringThis column contains the centroid of the geometric data. The centroid is the geometric center of a shape.
geom_center_xdoubleThis 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_ydoubleThis 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
Adaptershapefile
Countryse
Databasese_lantmateriet
Extract date2024-08-26
Idfc82edc5-cdc8-40ed-9e15-42c429af4fc8
Package idee2c9510-e772-4d86-aa8c-7241b31f7271
Position1
Revision id6098593b-b723-4949-a675-df2fa7a9ae34
Stateactive
Tableutfall_historiska_ortofoto_sverigelager1960_shape_zip__sverigelager1960__history