Latest Orthophoto Outcome Shape Data Collection
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 |