indexrutor_sweref99_12_00
Tables
-
Geospatial Information Table with Index Routes and Geometry AttributesTSV
The table in question is part of a larger dataset, gathered from the Lantmäteriet (Land Survey) website in Sweden. It contains a range of data, with a particular focus on geographic information. This information has been converted from its original shapefile format, which holds geometric location and attribute data for geographic features such as points, lines, and polygons. The data in this table is organized in a systematic way, with each row representing unique data extracted from the source. Each row is uniquely identified by two special columns: one indicating the date the data was extracted, and the other assigning a specific row number for the extraction date. Notably, the table contains a wealth of geographic information, including the geometric location and attribute...
-
Version History of Index Routes in the SWEREF99 12 00 Coordinate SystemTSV
The 'indexrutor_sweref_12_00__history' table is a historical record of a larger dataset collection. This history table provides an in-depth version history of its base table rows, allowing users to track changes over time. Each row in the table is uniquely identified by a combination of a start date and a row number, which shows when the row was extracted from the data source and its respective position. The table includes two additional columns that are not present in its base table: a start date and an end date. These columns indicate when a row was extracted and when a new version of that row was extracted, respectively. If the end date is null, this signifies that the row is the most recent version. One of the significant attributes of this table is its rich geographic data....
Column Descriptions
Geospatial Information Table with Index Routes and Geometry Attributes
Column | Type | Comment |
---|---|---|
_extract_date | date | This column records the date when the data on the row was extracted from the data source. It's a special column used in conjunction with '_row_number' to uniquely identify each row. |
_row_number | long | This column indicates the row number in the data extracted from the source on the extract date specified by '_extract_date'. It's a special column that, when combined with '_extract_date', uniquely identifies each row. |
INDEXRUTA | string | This column contains the INDEXRUTA, a specific attribute related to the data. |
geom_geojson | string | This column contains the geometric data in the GeoJSON format. |
geom_geotext | string | This column contains the geometric data in a textual format. |
geom_type | string | This column indicates the type of the geometric data recorded in the 'geom_geojson' and 'geom_geotext' columns. |
geom_centroid | string | This column contains the centroid of the geometric figure represented by the data in the geometric columns. |
geom_center_x | double | This column contains the X coordinate of the center point of the geometric figure represented by the data in the geometric columns. |
geom_center_y | double | This column contains the Y coordinate of the center point of the geometric figure represented by the data in the geometric columns. |
Version History of Index Routes in the SWEREF99 12 00 Coordinate System
Column | Type | Comment |
---|---|---|
_start_date | date | This column contains the date when the row was extracted from the source data. Together with '_row_number', it 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 source data. 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 appears in the raw data extracted from the source. It forms part of a unique identifier for each row when combined with '_start_date'. |
INDEXRUTA | string | The content of this column is not specified in the provided information. |
geom_geojson | string | The content of this column is not specified in the provided information. |
geom_geotext | string | The content of this column is not specified in the provided information. |
geom_type | string | The content of this column is not specified in the provided information. |
geom_centroid | string | The content of this column is not specified in the provided information. |
geom_center_x | double | The content of this column is not specified in the provided information. |
geom_center_y | double | The content of this column is not specified in the provided information. |
Additional Info
Last Updated | September 13, 2024 |
---|---|
Created | August 27, 2024 |