Version History of Drainage Areas for Rainwater - Stockholm
The 'table__history' is a historical information repository, part of the dataset collection associated with the drainage system of Stockholm City, Sweden. This table is of particular significance as it maintains the version history of its base table rows, enabling a time-bound analysis of the data.
The table consists of a wide range of columns that contain various types of information. For instance, some columns hold geographic data, which are essential for geospatial data analytics. They provide geographic coordinates that adhere to the WGS 84 coordinate reference system, specifying longitude first, followed by latitude.
In addition, there are special columns like '_start_date', '_end_date', and '_row_number' that provide unique identifiers for each row and track the chronology of the data. The '_row_number' column denotes the row number in the raw data, while '_start_date' and '_end_date' capture the date when a row was added or updated in the table. A null value in the '_end_date' column indicates that the row is the most recent version.
The data content of the table is quite diverse. It includes information on areas like EU IDs, main areas, coastal occurrence, modification dates, object IDs, recipients, outlets, outlet types, water occurrence, among others. The table also contains multiple 'geom_' prefixed columns that store geographic information.
Given the wide range of data, the table can be utilized in numerous data analytics scenarios. For example, the temporal aspect of the data can be used to analyze changes in the drainage system over time. The geographic data can aid in spatial analysis or mapping of the drainage areas. Also, the data can be used to identify patterns or trends in the drainage system, which can inform maintenance plans and infrastructure upgrades. Finally, the table can be used to improve water management practices by analyzing data on water occurrence and outlet types.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. It is part of a combination with '_row_number' that uniquely identifies each row in this version history table. |
| _end_date | date | This column holds the date when a new version of the row was extracted from the data source. If the value is null, it signifies that the row is the most recent version. |
| _row_number | long | This column contains the number of the row in the raw data extracted from the data source. It forms a unique identifier for each row in conjunction with '_start_date'. |
| EU_ID | string | This column possibly holds codes related to European Union specifications or standards, although some entries may be null. |
| Huvudområde | string | Translated to 'Main Area' in English, this column contains the name of the main area associated with the entry. Some entries may be null. |
| Kustförekomst | string | This column, likely titled 'Coastal Occurrence' in English, may indicate whether the entry has a coastal occurrence or not. Some entries may be null. |
| Modifieringsdatum | string | This column represents the 'Modification Date' in English, holding the date and time when the entry was last modified. |
| OBJECTID | long | This column contains unique identification numbers for each row entry. |
| Recipient | string | This column holds names of recipients, possibly indicating the destination or beneficiary of something related to each entry. |
| Recipient_2 | string | This column might be an additional field for recording recipients, similar to the 'Recipient' column. |
| Utlopp | string | Translated to 'Outlet' in English, this column seems to hold identifiers for different types of outlets, possibly related to water drainage. |
| Utloppstyp | long | This column, likely titled 'Outlet Type' in English, contains numerical codes that could represent different types of outlets. |
| Vattenförekomst | string | This column, possibly titled 'Water Occurrence' in English, might indicate the presence or status of water in the areas associated with the entries. Some entries may be null. |
| geom_geojson | string | This column contains GeoJSON data, a format for encoding geographic data structures. |
| geom_geotext | string | This column holds geographical data in a textual format, likely representing the same data as in the 'geom_geojson' column but in a different format. |
| geom_type | string | This column contains the type of geographical data stored in the entries, such as 'ST_MULTIPOLYGON' which represents a type of shape in spatial data. |
| geom_centroid | string | This column holds the centroid coordinates of the geographical shapes associated with the entries, represented as points. |
| geom_center_x | double | This column contains the x-coordinates for the center points of the geographical shapes associated with the entries. |
| geom_center_y | double | This column contains the y-coordinates for the center points of the geographical shapes associated with the entries. |
| gml_id | string | This column holds identifiers in the Geography Markup Language (GML) format, which is an XML grammar for expressing geographical features. |
No sample for this dataset
Additional Information
| Last updated | November 8, 2024 |
|---|---|
| Created | November 8, 2024 |
| 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 | 2024-11-08 |
| Id | 5c531918-54ad-4d14-9a23-dc26bca44a7d |
| Package id | 45dc37eb-1b6e-4c3b-8ede-42d5ccda631b |
| Position | 1 |
| Revision id | bd52a056-7f61-4491-bc9c-a0a857ee5e31 |
| State | active |
| Table | dagvatten_tekniska_avromr_dag_recipient_avrinningsomraden_dagvatten__table__history |