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

Latest Orthophoto Outcome Shape Data Collection

The dataset collection in question is comprised of a series of related tables, which are organized in a systematic manner with rows and columns for the ease of data interpretation. These tables are part of a larger dataset collection that is primarily sourced from the website of Lantmäteriet (The Land Survey of Sweden), located in Sweden. Each table within this collection contains a variety of information and data points, providing a comprehensive overview of the subject matter at hand. The dataset collection as a whole serves as a valuable resource for comprehensive data analysis and interpretation.

Tables

  • Latest Orthophoto Outcomes: A Comprehensive Table of Aerial Photography and Geometrical DataTSV

    The table at hand is a comprehensive collection of related data, housed under the dataset collection. This table contains a variety of data, including unique identifiers for each row, determined by the date of data extraction and the row number itself. Specifically, these identifiers are the date when the data on the row was extracted from the source and the row number in the data extracted from the source on that specific extract date. This combination allows each row to be uniquely identified. Additionally, the table holds geographic information, which was originally in shapefile format and has been transformed into the final geographic format. Geographic features can be represented by points, lines, or polygons (areas). This table was sourced from Lantmäteriet, a website based in...

  • Version History of Aerial Photography RecordsTSV

    The 'utfall_ortofoto_senaste__history' table is a part of the 'utfall_ortofoto_senaste_shape' dataset collection. It serves as a history table, maintaining the version history of individual rows from its base table. Unique identification of each row in this version history table is achieved through a combination of the start date of extraction and the row number in the raw data. The table includes two additional columns compared to its base table, specifically the start and end dates of data extraction. A row is considered the most recent version if its end date value is null. The table's data is sourced from the website of 'Lantmäteriet' in Sweden. The history table incorporates geographical information as well, which was originally in shapefile format, a common geospatial vector data...

Column Descriptions

Latest Orthophoto Outcomes: A Comprehensive Table of Aerial Photography and Geometrical Data

Column Type Comment
_extract_date date This column signifies the date when the data on the row was extracted from the source. It plays a crucial role in uniquely identifying each row in conjunction with the _row_number.
_row_number long This column contains the row number in the data extracted from the source. In combination with the _extract_date, it serves to uniquely identify each row.
FLYGFOTOAR string This column represents the year of the aerial photograph from which the data was sourced.
OMRPLAN string This column pertains to the area plan associated with the data.
PIXEL string This column provides information about the pixel value of the data in the image.
geom_geojson string This column contains the geographical data in GeoJSON format.
geom_geotext string This column contains the geographical data in geotext format.
geom_type string This column indicates the type of the geographical data.
geom_centroid string This column holds the centroid or the geometric center of the geographical data.
geom_center_x double This column contains the X coordinate of the center of the geographical data.
geom_center_y double This column contains the Y coordinate of the center of the geographical data.

Version History of Aerial Photography Records

Column Type Comment
_start_date date This column contains the date when a specific row was extracted from the data source. Together with the '_row_number' column, it uniquely identifies each row in the version history table.
_end_date date This column contains the date when a new version of a specific row was extracted from the data source. If this column has a null value, it indicates that the row is the most recent version.
_row_number long This column contains the row number from the raw data extracted from the data source. It is used in conjunction with the '_start_date' column to uniquely identify each row in this version history table.
FLYGFOTOAR string This column contains information related to the aerial photography year.
OMRPLAN string This column contains information about the area plan.
PIXEL string This column contains pixel-related information.
geom_geojson string This column contains the geographical data in GeoJSON format.
geom_geotext string This column contains the geographical data in a text format.
geom_type string This column specifies the type of the geographical data.
geom_centroid string This column contains the centroid information of the geographical data.
geom_center_x double This column contains the X coordinate of the center of the geographical data.
geom_center_y double This column contains the Y coordinate of the center of the geographical data.

Additional Info

Last Updated September 13, 2024
Created August 26, 2024