Index 100KM: A Comprehensive Dataset Collection sourced from a Prominent Swedish Website

The dataset collection titled 'index_100km' is a valuable resource comprising one or multiple tables of related data. The data within these tables is meticulously organized in a structured format of columns and rows for easy understanding and analysis. The data for these tables has been sourced from the website of 'Lantmäteriet' (The Land Survey) in Sweden. This ensures the data's authenticity, given the reputation of the source. The dataset collection is crucial for various analyses and can be significantly useful for researchers and professionals in various fields.

Tables

Historical Versions of 100km Index Data RecordsTSV
The 'index_100km__history' table is a historical record of a base table that contains geographical data. It keeps track of the version history of each row in the base table, making it possible to see when each piece of data was extracted and when it was replaced with a new version. Each row in this table can be uniquely identified by a combination of the date of extraction and the row number from the raw data source. Furthermore, this table has geographic information that has been transformed from the shapefile format, a common format for storing geometric locations and attribute information of geographic features. These features can be represented by points, lines, or polygons. The data for this table is sourced from the 'Lantmäteriet' website, located in Sweden. In terms of data...
Index 100km: A Comprehensive Geographical Dataset with Detailed Geometric and Spatial PropertiesTSV
The 'index_100km' table is a valuable collection of geographic data, sourced from Lantmäteriet (The Land Survey) in Sweden. It offers a variety of geographic details, transformed from shapefile format into a more convenient structure for data analysis. This transformation includes points, lines, and polygons (areas) that represent different geographic features. The table's organization is quite unique. There are two special columns providing the extraction date of the data and the row number for that particular extraction. These two columns work together to uniquely identify each row of data. One of the standout features of this table is its inclusion of geographic information in different formats, enabling versatile applications. Whether it's the geometric representation of the data...

Column Descriptions

Index 100km: A Comprehensive Geographical Dataset with Detailed Geometric and Spatial Properties

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. It helps in uniquely identifying each row when combined with the extract date.
SHAPE_Leng	double	This column represents the length of the shape in the geographical data.
SHAPE_Area	double	This column represents the area of the shape in the geographical data.
BK	string	Details about this column are not provided. It may contain specific information related to the dataset.
geom_geojson	string	This column contains the geometric data in GeoJSON format. GeoJSON is a format for encoding geographic data structures.
geom_geotext	string	This column contains the geometric data in text format.
geom_type	string	This column specifies the type of geometric data (like Point, LineString, Polygon etc.).
geom_centroid	string	This column contains the centroid of the geometric shape. The centroid is the arithmetic mean position of all the points in the shape.
geom_center_x	double	This column represents the X coordinate of the center of the geometric shape.
geom_center_y	double	This column represents the Y coordinate of the center of the geometric shape.

Historical Versions of 100km Index Data Records

Column	Type	Comment
_start_date	date	The date when the row was extracted from the data source. Together with '_row_number', it forms a unique identifier for each row in this version history table.
_end_date	date	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	The number of the row in the raw data extracted from the data source. This, in combination with '_start_date', uniquely identifies each row in this version history table.
SHAPE_Leng	double	A column related to the geometric properties of the data.
SHAPE_Area	double	A column related to the geometric properties of the data.
BK	string	A column that contains specific data, the nature of which is determined by the data source.
geom_geojson	string	The geometric data of the row in geojson format.
geom_geotext	string	The geometric data of the row in text format.
geom_type	string	The type of the geometric data.
geom_centroid	string	The centroid of the geometric data.
geom_center_x	double	The X coordinate of the center of the geometric data.
geom_center_y	double	The Y coordinate of the center of the geometric data.

Additional Info

Last Updated	September 13, 2024
Created	August 26, 2024