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

Orthophoto Outcome Shape Collection

The dataset collection in question is a compilation of tables that are related to each other. These tables have been gathered from the website of Lantmäteriet (The Swedish Land Survey) in Sweden. The arrangement of the data within each table is systematic, with rows and columns aiding in the interpretation of the information. The dataset is robust and diverse, contributing to a comprehensive understanding of the subject matter it pertains to. It's worth noting that this dataset collection includes a specific table that is projected to offer valuable insights for the year 2024.

Tables

  • Historical Versioning of Orthophoto Outcomes 2024TSV

    The table in focus is a historical data table which is part of a larger dataset collection. It keeps track of the version history of base table rows with the help of specific columns that mark the start and end dates of each row. These dates indicate when the data row was extracted from the source and when a new version was subsequently extracted. The fact that a row is the latest version is indicated by a null value in the end date column. In addition to the version tracking, the table also contains geographical information which has been converted from the shapefile format, a common format for storing geographical features. This geographical data can represent various geographical features like points, lines, or polygons (areas). The data for this table is sourced from the website of...

  • Ortophoto Outcome 2024: Geographic Parameters and Pixel Data AnalysisTSV

    The table 'utfall_ortofoto_2024' is a comprehensive repository of geographic data. Hailing from the 'Lantmäteriet' website in Sweden, the table's data is meticulously organized to offer a broad spectrum of information. A key feature of this table is its capacity to identify each row uniquely, courtesy of two special columns that record the date of data extraction and row number. The geographic data, originally in the shapefile format, has been transformed into a final geographic format for ease of use and understanding. This table holds a rich variety of geographic information that can be represented by points, lines, or polygons (areas). In terms of data analytics, this table serves as a goldmine. For instance, by analyzing the date of extraction, one can track the evolution of...

Column Descriptions

Ortophoto Outcome 2024: Geographic Parameters and Pixel Data Analysis

Column Type Comment
_extract_date date This column represents the date when the data on a particular row was extracted from the data source.
_row_number long This column contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'.
OMRPLAN string This column corresponds to a unique identifier or code associated with the data.
pixel string This column represents the pixel value of the data.
geom_geojson string This column contains the GeoJSON representation of the geometric object.
geom_geotext string This column contains the textual representation of the geometric object.
geom_type string This column specifies the type of the geometric object.
geom_centroid string This column represents the geometric center, or centroid, of the geometric object.
geom_center_x double This column represents the X-coordinate of the center of the geometric object.
geom_center_y double This column represents the Y-coordinate of the center of the geometric object.

Historical Versioning of Orthophoto Outcomes 2024

Column Type Comment
_start_date date The date when the row was extracted from the source data. Together with '_row_number', this forms a unique identifier for each row in the version history table.
_end_date date The date when a new version of the row was extracted from the source data. 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 source data. It forms a unique identifier for each row in combination with '_start_date'.
OMRPLAN string A column in the table about which no specific information was provided.
pixel string A column in the table about which no specific information was provided.
geom_geojson string A column in the table about which no specific information was provided.
geom_geotext string A column in the table about which no specific information was provided.
geom_type string A column in the table about which no specific information was provided.
geom_centroid string A column in the table about which no specific information was provided.
geom_center_x double A column in the table about which no specific information was provided.
geom_center_y double A column in the table about which no specific information was provided.

Additional Info

Last Updated September 13, 2024
Created August 26, 2024