utfall_laserdata_nh_skannade_strak_xlsx

The dataset collection is a comprehensive compilation of tables related to laser data. Each table within the dataset is a well-structured assembly of information neatly organized into rows and columns. These tables are sourced from 'Lantmäteriet' (The Land Survey), a reputable website based in Sweden. The dataset collection provides significant insights and values for different analyses and interpretations. The intricate organization of data ensures easy accessibility and comprehensibility of information.

Tables

Historical Versioning of Scanned Stretches within Laser Data CollectionTSV
The 'Scanned Sections History' table is a part of the 'Outcome Laser Data - Scanned Sections' dataset collection. Originating from the 'Lantmäteriet' (The Land Survey) website in Sweden, this historical table maintains the version history of its base table rows. The table contains a unique combination of a start date and a row number that uniquely identifies each row in this version history table. A key feature of this table is its ability to track changes in the data over time, thanks to the two additional columns compared to its base table: the start date and the end date. The start date indicates when the row was extracted from the data source, while the end date represents when a new version of the row was extracted. Should the end date be null, this signifies that the row is the...
Scanned Tracks Data CollectionTSV
The 'Scanned Tracks' table is a valuable collection of data, sourced from the website of Lantmäteriet (The Land Survey) in Sweden. The table contains a variety of columns, each housing a specific type of information. Two of the most significant columns are those containing the date of data extraction and the row number of the data. These two columns together uniquely identify each row of data. The range of data in the table includes details such as track ID, primary and secondary areas, track details, date, GPS time, and point source ID. The 'Scanned Tracks' table can be utilized in several ways for data analytics. For instance, analysts could track changes over time by comparing data from different extraction dates. The geographical data present in the table could be employed to...

Column Descriptions

Scanned Tracks Data Collection

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the row of the table was extracted from the 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'. The combination of '_extract_date' and '_row_number' uniquely identifies each row.
strak_id	string	This column contains a unique identifier for the 'strak' or section.
p_omr	string	This column contains data related to the 'p_omr' which could be information about a specific area or parameter.
s_omr	string	This column contains data related to the 's_omr' which could be information about a specific area or parameter.
strak	int	This column contains the 'strak' or section data.
datum	int	This column contains the 'datum' which is a specific date related to the data row in question.
gps_tid	int	This column contains the 'gps_tid', which could be a timestamp related to GPS data.
point_source_id	int	This column contains the 'point_source_id', a unique identifier for the source of the data point.

Historical Versioning of Scanned Stretches within Laser Data Collection

Column	Type	Comment
_start_date	date	This column contains the date when the row was extracted from the data source. It forms a combination with '_row_number' to uniquely 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 is null, it indicates that the row is the most recent version.
_row_number	long	This column contains the number of the row in the raw data extracted from the data source. It forms a combination with '_start_date' to uniquely identify each row in this version history table.
strak_id	string	This column contains the identification number for the 'strak'.
p_omr	string	This column contains information about the 'p_omr'.
s_omr	string	This column contains information about the 's_omr'.
strak	int	This column contains information about the 'strak'.
datum	int	This column contains the date related to each 'strak'.
gps_tid	int	This column contains the GPS time related to each 'strak'.
point_source_id	int	This column contains the source ID for each point in the 'strak'. The table is sourced from the website of 'Lantmäteriet' (The Land Survey) in Sweden.

Additional Info

Last Updated	September 13, 2024
Created	August 26, 2024