utfall_historiska_ortofoto_sverigelager1960_shape
Tables
-
Historical Swedish Aerial Imaging Data Extracted in 1960TSV
The table 'sverigelager1960' is a valuable collection of geographical data sourced from the Swedish website, 'Lantmäteriet'. This data is organized into multiple columns, each representing a unique aspect of the dataset. Two critical columns comprise the extraction date and row number, both of which serve to uniquely identify each row of data. The extraction date specifies when the data was retrieved from the source, while the row number represents the sequence of data extracted on that particular date. The rich data within this table is largely geographical, originally sourced in shapefile format - a popular way to store location and attribute information of geographical features such as points, lines, and polygons. This data has been transformed into a more accessible geographic...
-
Historical Versions of Base Table Rows in Sweden's Geographic Dataset Collection from 1960TSV
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...
Column Descriptions
Historical Swedish Aerial Imaging Data Extracted in 1960
Column | Type | Comment |
---|---|---|
_extract_date | date | This column records the date on which the data in the corresponding row was extracted from the data source. |
_row_number | long | This column contains the row number in the data that was extracted from the source on the specified extraction date. This, combined with the '_extract_date', uniquely identifies each row. |
RT90RUTA | string | This column contains specific data relevant to the dataset, the interpretation of which depends on the context of the data source. |
FLYGAR | string | This column contains specific data relevant to the dataset, the interpretation of which depends on the context of the data source. |
geom_geojson | string | This column contains the GeoJSON geometric representation of the data. |
geom_geotext | string | This column holds the geometric data in text format. |
geom_type | string | This column describes the type of geometric data represented in the row. |
geom_centroid | string | This column holds the centroid of the geometric data. |
geom_center_x | double | This column holds the X-coordinate of the center of the geometric data. |
geom_center_y | double | This column holds the Y-coordinate of the center of the geometric data. |
Historical Versions of Base Table Rows in Sweden's Geographic Dataset Collection from 1960
Column | Type | Comment |
---|---|---|
_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. |
Additional Info
Last Updated | September 13, 2024 |
---|---|
Created | August 26, 2024 |