Index Grids in SWEREF99 13 30 Coordinate System
Tables
-
Geospatial Index Routes Data with Extracted Features and Geometric AttributesTSV
The table under discussion is a collection of geographical data sourced from 'Lantmäteriet' (The Land Survey) website based in Sweden. The underlying information in the table is organised into various columns, each representing different aspects of the data collected. The dataset collection to which this table belongs focusses on geographic features specifically in the SWEREF99 13 30 coordinate system. Each row of the table is uniquely identified by a combination of the extraction date and the row number, which indicates the sequence in which the data was extracted from the source. This allows for precise tracking and referencing of each individual data entry. The geographical data included within the table was originally in shapefile format - a common format for storing geometric...
-
Version History of Base Table Rows in the SWEREF99 13 30 Index Rutor CollectionTSV
The 'Indexrutor Sweref 13 30 History' table is a part of the 'Indexrutor Sweref99 13 30' dataset. This table is a history table, which provides a version history of base table rows. It contains unique identifiers for each row, which are formed by a combination of the row's start date and its raw row number from the data source. The table also includes the start and end dates for each row’s version, indicating when that version of the row was extracted from the source and when a new version emerged. If the end date is null, it means that version of the row is the most recent one. The table also contains geographic data, which was originally sourced in shapefile format, a common format for storing geometric location and attribute information of geographic features. The geographic data has...
Column Descriptions
Geospatial Index Routes Data with Extracted Features and Geometric Attributes
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 combines with '_extract_date' to uniquely identify each row. |
INDEXRUTA | string | This column contains index data which is specific to the dataset. |
geom_geojson | string | This column contains the GeoJSON representation of the geometrical data. |
geom_geotext | string | This column contains the geometrical data in a text format. |
geom_type | string | This column specifies the type of geometrical data stored in the 'geom_geojson' and 'geom_geotext' columns. |
geom_centroid | string | This column contains the central point of the geometrical data. |
geom_center_x | double | This column contains the x-coordinate of the center of the geometrical data. |
geom_center_y | double | This column contains the y-coordinate of the center of the geometrical data. |
Version History of Base Table Rows in the SWEREF99 13 30 Index Rutor Collection
Column | Type | Comment |
---|---|---|
_start_date | date | This column carries the date when the row was first extracted from the data source. It, along with '_row_number', uniquely identifies each row in the version history table. |
_end_date | date | The '_end_date' column consists of the date when a new version of the row was extracted from the data source. A null value in this column signifies that the row is the most recent version. |
_row_number | long | The '_row_number' column contains the number of the row in the raw data as it was extracted from the data source. This, combined with '_start_date', uniquely identifies each row in this version history table. |
INDEXRUTA | string | The 'INDEXRUTA' column contains the index route from the data source. |
geom_geojson | string | The 'geom_geojson' column stores the geometrical data of the row in the GeoJSON format. |
geom_geotext | string | The 'geom_geotext' column contains the geometrical data of the row in textual format. |
geom_type | string | The 'geom_type' column identifies the type of the geometrical data of the row. |
geom_centroid | string | The 'geom_centroid' column represents the centroid of the geometrical data of the row. |
geom_center_x | double | The 'geom_center_x' column signifies the X-coordinate of the center of the geometrical data of the row. |
geom_center_y | double | The 'geom_center_y' column represents the Y-coordinate of the center of the geometrical data of the row. |
Additional Info
Last Updated | September 13, 2024 |
---|---|
Created | August 27, 2024 |