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