Index Grids for SWEREF99 Coordinate System
Tables
-
Composite Spatial Data Table with Geometric Mapping DetailsTSV
The table is a crucial part of a specific dataset collection. It holds related data arranged in an organized format, with clear columns and rows to facilitate understanding and analysis. One of the unique features of this table is its two special columns that contain information on the date of data extraction and the row number in the extracted data. These two columns provide a unique identifier for each row, enhancing the accuracy of data tracking and manipulation. The data in this table is rich with geographic information, which has been transformed from the shapefile format. Shapefile is a simple, non-topological format used for storing the geometric location and attribute information of geographic features. These features could be points, lines, or polygons. The geographic...
-
Version History of Index Routes: A Comprehensive Table of Geospatial Data and Temporal DetailsTSV
The 'indexrutor_sweref_17_15__history' table is a valuable part of the 'indexrutor_sweref99_17_15' dataset collection. This table is a history table, meaning it contains the version history of its base table rows. What makes it unique is that it records the changes in the data over time, using two specific columns to mark the start and end dates of each version. If a row's end date is null, it signifies that the version is the most recent one. In addition to temporal information, the table also carries geographical data transformed from the shapefile format, a standard used for storing geographical location and attribute information. This geographical data can represent features as points, lines, or polygons, offering a rich source of spatial analysis opportunities. The data for this...
Column Descriptions
Composite Spatial Data Table with Geometric Mapping Details
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. Combined with '_extract_date', this column uniquely identifies each row. |
INDEXRUTA | string | This column contains specific index values related to each row. |
geom_geojson | string | This column contains the geometric representation of the data in GeoJSON format. |
geom_geotext | string | This column contains the geometric representation of the data in text format. |
geom_type | string | This column specifies the type of geometric data stored in the row. |
geom_centroid | string | This column contains the geometric centroid of the data. |
geom_center_x | double | This column contains the X coordinate of the geometric center of the data. |
geom_center_y | double | This column contains the Y coordinate of the geometric center of the data. |
Version History of Index Routes: A Comprehensive Table of Geospatial Data and Temporal Details
Column | Type | Comment |
---|---|---|
_start_date | date | This column contains the date when the row was extracted from the data source. It is part of the combination that uniquely identifies 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 in this column 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 appears in the raw data extracted from the data source. It forms a unique combination with '_start_date' to identify each row in this version history table. |
INDEXRUTA | string | This column contains specific data related to the 'INDEXRUTA'. The exact nature of this data would depend on the context provided by the data source. |
geom_geojson | string | This column contains the GeoJSON representation of the geometry associated with each row. GeoJSON is a format for encoding geographical data structures. |
geom_geotext | string | This column contains a textual representation of the geometry associated with each row. |
geom_type | string | This column specifies the type of the geometry associated with each row. For instance, the geometry could be a point, a line, or a polygon. |
geom_centroid | string | This column contains the centroid of the geometry associated with each row. The centroid is the geometric center of a plane figure or shape. |
geom_center_x | double | This column contains the x-coordinate of the center of the geometry associated with each row. |
geom_center_y | double | This column contains the y-coordinate of the center of the geometry associated with each row. |
Additional Info
Last Updated | September 18, 2024 |
---|---|
Created | August 27, 2024 |