Geospatial Information Table with Index Routes and Geometry Attributes
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 information in the final geographic format, previously converted from the shapefile format. This includes data about geographic features, which can be points, lines, or polygons (areas).
In terms of data analytics, the table provides a rich source of geographic and temporal data that could be used in various ways. For instance, one could analyze trends over time by using the data extraction date to study changes in the geographic features. Alternatively, the geographic data could be used to create detailed maps or understand spatial relationships. Additionally, the row number could be used to track data extraction processes, offering insights into the efficiency or reliability of these processes over time.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _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. |
No sample for this dataset
Additional Information
| Last updated | August 27, 2024 |
|---|---|
| Created | August 27, 2024 |
| License | No License Provided |
| Geographic coverage | |
| Geographic granularity | |
| Temporal coverage from | |
| Temporal coverage to | |
| Temporal coverage to | |
| Adapter | shapefile |
| Country | se |
| Database | se_lantmateriet |
| Extract date | 2024-08-26 |
| Id | 25a7cda6-0a44-41b1-a78c-5c3bd4872cf4 |
| Package id | a4aa455e-fcd3-4d06-b43c-e0dd77ff5ae9 |
| Revision id | ab5047d0-be49-4f56-be01-c4c17128b279 |
| State | active |
| Table | indexrutor_sweref99_12_00_zip__indexrutor_sweref_12_00 |