Long-term Aerial Photography Plan: A Comprehensive Dataset Collection

The dataset collection 'plan_flygfoto_langsiktig' comprises of two main tables. These tables contain related data organized in a structured table format, with columns and rows detailing various aspects. The data is sourced from the website of 'Lantmäteriet' (the Swedish Mapping, Cadastral and Land Registration Authority) in Sweden. Given the source, the data is highly reliable and credible, making it useful for a variety of applications and research projects. It's important to note that the tables in the collection may intersect at certain points due to the nature of the data, making it a comprehensive collection for in-depth analysis.

Tables

Historical Version Tracker of Zone Boundary LinesTSV
The 'zon_grans_line__history' table is a vital part of the dataset collection aimed at capturing long-term aerial photography planning. This table, in essence, is a history table that meticulously keeps track of the version history of its base table rows. This feature makes it a unique asset in evaluating chronological changes and trends. The table, sourced from the 'Lantmäteriet' website in Sweden, offers detailed information about various aspects of the data. For instance, it records when each row was extracted from the data source and when a new version was obtained. This information makes it possible to track the lifecycle of each data point, from its inception to its most recent update. If a row is the most recent version, this is indicated by a null value in the 'end_date'...
Long-term Aerial Photography Plan - Version History TableTSV
The 'plan_flygfoto_langsiktig__history' table is a historical archive, storing version history of its base table rows. This aspect makes it unique as it contains two additional columns compared to its base table, which hold the dates when each row was extracted from the data source and when a new version of the row was extracted, respectively. If the end date column is null, it indicates that the row is the latest version. This table holds geographic information, which originally comes in a shapefile format - a common format for storing geometric location and attribute details of geographic features. These features could be represented as points, lines, or polygons. However, in this dataset, the geographic information has been converted from the shapefile format into its final...
Long-term Aerial Photography Planning DataTSV
The table 'plan_flygfoto_langsiktig' is a valuable collection of data that provides insights related to geographic features in Sweden. This data is sourced from the website of 'Lantmäteriet' (The Swedish Mapping, Cadastral and Land Registration Authority). The table is distinct in its design as it contains data that has been transformed from a simple, non-topological shapefile format into a final geographic format. This transformation allows for the efficient storage of geometric location and attribute information of various geographic features, which can be represented as points, lines, or polygons. Two notable features of the table are the '_extract_date' and '_row_number' columns. The '_extract_date' column records the date when the data was extracted from the source, while the...
Long-Term Aerial Photography Planning Zones Boundary Line DataTSV
The 'zon_grans_line' table is a significant component of a larger dataset collection, sourced from the Swedish website, Lantmäteriet. It is a meticulously structured collection of data, organized into columns and rows. Each row is uniquely identified by two special columns - one indicating the date the data was extracted, and the other specifying the row number from the original source extraction. This combination ensures each row is distinct and easily identifiable. The table also contains geographic data, which originally was in the shapefile format, a format for storing geographic features' location and attribute information. This data has been transformed into a final geographic format from its original shapefile format. The table can be utilized in a variety of ways in data...

Column Descriptions

Long-term Aerial Photography Planning Data

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the row was extracted from the source. It allows us to track when each specific piece of data was retrieved.
_row_number	long	This column holds the row number in the data extracted from the source on the extract date specified by the '_extract_date' column. This, along with the '_extract_date', allows for unique identification of each row.
OBJECTID	long	This is an identifier for the objects represented in the table.
Område	string	This column represents the area related to the data row.
geom_geojson	string	This column contains the geometric data of the area represented in GeoJSON format.
geom_geotext	string	This column contains the geometric data of the area in a textual format.
geom_type	string	This column specifies the type of the geometric data represented, such as point, line, or polygon.
geom_centroid	string	This column contains the centroid of the geometric data represented. The centroid is the geometric center of a shape.
geom_center_x	double	This column represents the X coordinate of the center of the geometric data.
geom_center_y	double	This column represents the Y coordinate of the center of the geometric data.

Long-term Aerial Photography Plan - Version History Table

Column	Type	Comment
_start_date	date	This column contains the extraction date of the row from the data source. This information, together with the '_row_number', uniquely identifies each row in this 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 is null, it indicates that the row is the most recent version.
_row_number	long	This column contains the row number in the raw data extracted from the data source. This information, together with the '_start_date', uniquely identifies each row in this history table.
OBJECTID	long	This column contains the object identifier.
Område	string	This column contains area related information.
geom_geojson	string	This column contains the geometric information of the area in GeoJSON format.
geom_geotext	string	This column contains the geometric information of the area in text format.
geom_type	string	This column specifies the type of the geometric data.
geom_centroid	string	This column contains the centroid of the geometric data.
geom_center_x	double	This column represents the X coordinate of the geometric center.
geom_center_y	double	This column represents the Y coordinate of the geometric center.

Long-Term Aerial Photography Planning Zones Boundary Line Data

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the 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 '_extract_date' column.
OBJECTID	long	This column contains unique identifiers for the objects in the table.
Zoner	string	This column contains information about the zones associated with the objects.
geom_geojson	string	This column contains geographical data in GeoJSON format.
geom_geotext	string	This column contains geographical data in text format.
geom_type	string	This column specifies the type of geographical data stored in the 'geom_geojson' and 'geom_geotext' columns.
geom_centroid	string	This column contains the geographical coordinates of the centroid of each object.
geom_center_x	double	This column contains the X coordinate of the center of each object.
geom_center_y	double	This column contains the Y coordinate of the center of each object.

Historical Version Tracker of Zone Boundary Lines

Column	Type	Comment
_start_date	date	This column holds the date when the row was extracted from the data source. It is part of a unique combination with '_row_number' to identify 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 here is null, it indicates that the row is the most recent version.
_row_number	long	This column contains the number of the row as it appears in the raw data extracted from the source. It forms a unique identifier for each row in combination with '_start_date'.
OBJECTID	long	This column likely contains unique identifiers for each of the objects in the table.
Zoner	string	This column likely contains data related to zones or zoning, given its name.
geom_geojson	string	This column likely contains geospatial data in the GeoJSON format.
geom_geotext	string	This column likely contains geospatial data in a textual format.
geom_type	string	This column likely contains information about the type of geospatial data stored in the row.
geom_centroid	string	This column likely contains the centroid, or geometric center, of a shape in geospatial data.
geom_center_x	double	This column likely contains the 'x' coordinate of the center of a shape in geospatial data.
geom_center_y	double	This column likely contains the 'y' coordinate of the center of a shape in geospatial data.

Additional Info

Last Updated	September 13, 2024
Created	August 26, 2024