Technical Stormwater Runoff and Catchment Areas Dataset Collection

This dataset collection is an assembly of related data tables, each rich with information and organized in a structured table format with distinct columns and rows. Sourced from the website of 'Stockholms stad' (City of Stockholm) in Sweden, these tables form an interconnected group. The contents of the dataset collection provide valuable insights and data points relating to technical aspects of stormwater management, including detailed information on stormwater recipients and drainage areas. The comprehensive nature of this dataset collection ensures a wide coverage of data, making it a valuable resource for in-depth study and analysis in the field of stormwater management.

Tables

Rainwater Drainage Basins - Data Collection from SwedenTSV
The table under consideration is part of a larger dataset collection, sourced from the website of 'Stockholms stad' (City of Stockholm) in Sweden. It features a rich variety of data points, with particular emphasis on geographical and environmental parameters. The table contains data about the date of data extraction and the row number of the data extracted. These two parameters are critical as they uniquely identify each row of data. It also houses data on various geographical parameters, with a focus on the coordinates of different locations, presented using the WGS 84 coordinate reference system. This geographical information could be utilized for geospatial data analytics, for studying patterns and trends related to geographical variations. The table also contains data about EU...
Version History of Drainage Areas for Rainwater - StockholmTSV
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...

Column Descriptions

Rainwater Drainage Basins - Data Collection from Sweden

Column	Type	Comment
_extract_date	date	The date when the data row was extracted from the data source.
_row_number	long	The row number in the data extracted from the source on the extract date specified by the _extract_date column.
EU_ID	string	The unique identifier of the European Union.
Huvudområde	string	The main area in which the data row is relevant.
Kustförekomst	string	The coastal occurrence related to the data row.
Modifieringsdatum	string	The date and time when the data row was last modified.
OBJECTID	long	The unique identifier of the object within the data row.
Recipient	string	The primary recipient related to the data row.
Recipient_2	string	The secondary recipient related to the data row.
Utlopp	string	The outlet related to the data row.
Utloppstyp	long	The type of the outlet related to the data row.
Vattenförekomst	string	The water occurrence related to the data row.
geom_geojson	string	The geometrical data of the related area in GeoJSON format.
geom_geotext	string	The geometrical data of the related area in plain text format.
geom_type	string	The type of the geometrical data.
geom_centroid	string	The centroid of the geometrical data.
geom_center_x	double	The x-coordinate of the center of the geometrical data.
geom_center_y	double	The y-coordinate of the center of the geometrical data.
gml_id	string	The GML identifier of the data row.

Version History of Drainage Areas for Rainwater - Stockholm

Column	Type	Comment
_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.

Additional Info

Last Updated	November 8, 2024
Created	November 8, 2024