Index Grids Collection in SWEREF99 18 00 Coordinate System
Tables
-
Geospatial Index Routines Dataset Table with Extraction Date and Geometry AttributesTSV
The table is an integral part of a dataset that contains a wealth of geographical data. It is derived from the website of Lantmäteriet (The Land Survey) in Sweden, and features several columns that provide unique and valuable information. For instance, two of the columns are dedicated to tracking when data was extracted from the source and the sequence of extraction. This allows each row of data to be uniquely identified based on both the extraction date and the row number. The table also contains a vast amount of geographical information, which has been transformed from the shapefile format. Shapefile is a popular non-topological format for storing geographical features, which can be represented as points, lines, or polygons. The geographical data in this table has been reformatted,...
-
Version History of Index Routes in SWEREF99 18 00 Coordinate SystemTSV
This is a history table that contains the version history of its base table rows. It is part of a larger dataset collection, sourced from the website of Lantmäteriet (The Land Survey) in Sweden. The table contains unique identifiers for each row, represented by a combination of the row number and the start date. The start date indicates when the row was extracted from the source, while an end date is used to signify when a new version of the row was added. If the end date is null, it indicates that the row is the most recent version. The data also includes geographic information, transformed from a shapefile format, which can be represented by points, lines, or polygons. This information could be particularly useful in data analytics for tracking changes over time, such as monitoring...
Column Descriptions
Geospatial Index Routines Dataset Table with Extraction Date and Geometry Attributes
Column | Type | Comment |
---|---|---|
_extract_date | date | This column represents the date when the data in the row was extracted from the source. It is one of the two columns that uniquely identify each row. |
_row_number | long | This column contains the row number of the data extracted from the source on the extract date specified by the '_extract_date' column. Together with '_extract_date', this column helps to uniquely identify each row. |
INDEXRUTA | string | This column contains the Index Route data. |
geom_geojson | string | This column contains the GeoJSON representation of the geometric data. |
geom_geotext | string | This column contains the Geotext representation of the geometric data. |
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. |
Version History of Index Routes in SWEREF99 18 00 Coordinate System
Column | Type | Comment |
---|---|---|
_start_date | date | This column contains the date when the row was extracted from the data source. It forms a unique combination with the '_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 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 source. It forms a unique combination with the '_start_date' to identify each row in this version history table. |
INDEXRUTA | string | This column contains specific data related to the 'INDEXRUTA' feature of the dataset. |
geom_geojson | string | This column contains the Geographical JSON data representing the geographical feature associated with each row. |
geom_geotext | string | This column stores the geographic details in a text format. |
geom_type | string | This column specifies the type of the geometric structure associated with each row. |
geom_centroid | string | This column contains data representing the centroid of the geographical feature associated with each row. |
geom_center_x | double | This column contains the X coordinate of the center of the geographical feature associated with each row. |
geom_center_y | double | This column contains the Y coordinate of the center of the geographical feature associated with each row. |
Additional Info
Last Updated | September 13, 2024 |
---|---|
Created | August 27, 2024 |