Natural Drainage Areas - Consolidated (Sourced from Stockholm, Sweden)
The table under discussion is a part of a larger dataset collection. It comprises of numerous columns that hold various types of data, all related to geographic information and identifiers. Each row in the table represents unique data extracted from the source, as indicated by two special columns: '_extract_date' and '_row_number'. The former column records the date of data extraction, while the latter provides a unique row number for the extracted data.
Columns that begin with 'geom_' contain geographic information, making the table extremely useful for geospatial data analytics. The geographic coordinates are presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. For instance, the 'geom_centroid' column contains the geographic point that represents the centroid of a specific geographic area.
Identification columns like 'EU_CD' and 'OBJECTID' provide unique identifiers for each row. There's also a column called 'Vattenforekomst' which indicates the water body related to the data in the row.
This table is sourced from the website of 'Stockholms stad' (City of Stockholm) in Sweden.
Data from this table could be used in various ways in data analytics. For instance, the geospatial data could be utilized to analyze and visualize the distribution of different water bodies across the region. The unique identifiers can be used to track specific geographic locations or features over time, providing valuable insights into environmental changes or urban development trends. The '_extract_date' column could be used for time series analysis, studying how certain aspects evolve over time.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This is a special column that captures the date when the data on the row was extracted from the source. This, in conjunction with '_row_number', helps in uniquely identifying each row. |
| _row_number | long | This is another crucial column that displays the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. The combination of '_extract_date' and '_row_number' assigns a unique ID to each row. |
| EU_CD | string | This column contains string type data. The specifics of the data it holds are not provided by the source, but it might be some kind of code or identifier. |
| OBJECTID | long | This integer type column might be used for storing discrete numerical data. The source has not provided specific details about this column. |
| Vattenforekomst | string | This is a string type column. The source does not provide its exact details but it might be involved in storing textual data. |
| geom_geojson | string | This column probably holds geographical data, given standard GeoJSON data format, which is used to represent simple geographical features. |
| geom_geotext | string | This column also seems to contain geographic data, but in a text format. It might be related to the 'geom_geojson' column. |
| geom_type | string | This column specifies the type of geometry that the geographic data in the other 'geom_' columns represents. For example, multipolygon, indicating multiple polygon shapes. |
| geom_centroid | string | This column likely contains the centroid, or the geometric center, of the geographical feature represented in the respective row. |
| geom_center_x | double | This column appears to represent the x-coordinate of the geometric center of the geographical feature in the respective row. |
| geom_center_y | double | This column seems to represent the y-coordinate of the geometric center of the geographical feature in the respective row. |
| gml_id | string | This string type column may be used to store some form of identifier. The source has not provided detailed information about this column. |
No sample for this dataset
Additional Information
| Last updated | January 8, 2025 |
|---|---|
| Created | January 8, 2025 |
| License | No License Provided |
| Geographic coverage | |
| Geographic granularity | |
| Temporal coverage from | |
| Temporal coverage to | |
| Temporal coverage to | |
| Country | se |
| Database | se_stockholms_stad |
| Extract date | 2025-01-08 |
| Id | fc876f07-351a-42ce-9659-e7a48aaf809e |
| Package id | 6d74da1b-5ebf-42d9-9892-c80247e70fc6 |
| Revision id | 7086ab8d-9959-4e59-98fc-72e2d6c07b2a |
| State | active |
| Table | naturliga_avromr_dag_vattenforekomst_naturliga_avrinningsomr_sammanfogade__table |