Index Grid Dataset for SWEREF99 18 45 Coordinate System

This dataset collection is a structured compilation of tables sourced from Lantmäteriet (The Land Survey), a website based in Sweden. These tables are meticulously organized into rows and columns, providing a clear presentation of related data. The dataset's relevance and value stem from its comprehensive nature, as it encapsulates several aspects within one or multiple tables. The dataset collection is designed for ease of navigation, thereby enabling efficient data analysis and extraction.

Tables

Geospatial Indexing Table with Extraction Date, Geometry Details and Index RouteTSV
The table in question is part of a larger dataset sourced from the Swedish website Lantmäteriet. It comprises several columns of data, each providing unique and valuable information. Two of these columns hold particularly crucial data: one indicates the date of data extraction from the source, while the other specifies the row number in the data as extracted on the specified date. These two together are what uniquely identify each row of data in the table. The other columns hold geographic data, which have been transformed from the shapefile format into their final geographic format. Shapefiles are a simple, non-topological format for storing the geometric location and attribute information of geographic features like points, lines, and polygons. The table's data could be of immense...
Version History of Index Routes in SWEREF99 18 45 Coordinate SystemTSV
The 'indexrutor_sweref_18_45__history' table is a historical archive, recording the version history of its base table rows. This table is part of the 'indexrutor_sweref99_18_45' dataset collection. The table hosts a variety of information, including key identifiers, the row extraction dates, and geographic data transformed from the shapefile format. Two unique identifiers define each row: the extraction date and the row number from the original data source. When a row is updated, the table logs the date of this new extraction, allowing for tracking of changes over time. If a row's end date is null, it signifies that the row is the current version. The geographical details in the dataset have been converted from the simple, non-topological shapefile format, which can represent...

Column Descriptions

Geospatial Indexing Table with Extraction Date, Geometry Details and Index Route

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 - the website of Lantmäteriet (The Land Survey) in Sweden.
_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'. This, in combination with '_extract_date', uniquely identifies each row.
INDEXRUTA	string	This column represents an index value that is specific to each data entry.
geom_geojson	string	This column stores the geographical data of the row in GeoJSON format, which is a format for encoding geographic data structures.
geom_geotext	string	This column contains geographical data in text format.
geom_type	string	This column indicates the type of the geographical feature represented in the 'geom_geojson' and 'geom_geotext' columns.
geom_centroid	string	This column represents the centroid or the geometric center of a two-dimensional shape or the center of mass of a three-dimensional solid.
geom_center_x	double	This column indicates the X coordinate of the geographical center point.
geom_center_y	double	This column indicates the Y coordinate of the geographical center point.

Version History of Index Routes in SWEREF99 18 45 Coordinate System

Column	Type	Comment
_start_date	date	This column indicates the date when the row was extracted from the data source. This, in combination with the '_row_number', uniquely identifies each row in this version history table.
_end_date	date	This column records the date when a new version of the row was extracted from the 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 as it appeared in the raw data extracted from the data source. It forms part of the unique identifier for each row in conjunction with '_start_date'.
INDEXRUTA	string	This column is part of the original base table and its contents are sourced from the data source.
geom_geojson	string	This column is part of the original base table and its contents are sourced from the data source.
geom_geotext	string	This column is part of the original base table and its contents are sourced from the data source.
geom_type	string	This column is part of the original base table and its contents are sourced from the data source.
geom_centroid	string	This column is part of the original base table and its contents are sourced from the data source.
geom_center_x	double	This column is part of the original base table and its contents are sourced from the data source.
geom_center_y	double	This column is part of the original base table and its contents are sourced from the data source.

Additional Info

Last Updated	September 13, 2024
Created	August 27, 2024