Geospatial Indexing Table with Extraction Date, Geometry Details and Index Route
Click here for a data sample
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 value in various data analytics applications. For instance, it could be used to track changes in geographical features over time based on the extraction date. Additionally, it could be employed to analyze patterns in the geographic data, such as identifying clusters of points or patterns in polygon shapes. The data could also be used to cross-reference other datasets by utilizing the unique identification of each row.
Field Descriptions
Name |
Data type |
Description |
_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. |