Natural Daily Water Occurrence and Drainage Dataset Collection

This dataset collection comprises a group of interrelated data tables. These tables, forming a comprehensive collection, are organized in a structured format consisting of rows and columns. The data for these tables is sourced from the website of Stockholm City (Stockholms stad), located in Sweden. The dataset collection provides a rich source of information, though the specific nature of its contents is determined by the data provided by Stockholm City. It's designed to represent and analyze a variety of factors, which are expressed through the structure and organization of the tables within the collection.

Tables

Natural Drainage Areas - Consolidated (Sourced from Stockholm, Sweden)TSV
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...
Version History of Combined Natural Drainage Areas (Sweden)TSV
The 'History' table is an extensive resource, part of a broader dataset collection. It holds a wealth of information, primarily chronicling the version history of its base table rows. The table serves as an archive, keeping track of changes to each row over time. To do this, it employs a combination of two specific columns, '_start_date' and '_row_number', which together form a unique identifier for each row in the table. The '_start_date' column marks the date when the row was extracted from the data source, while the '_row_number' shows the position of the row in the raw data. The '_end_date' column indicates when a new version of the row was extracted. If this column is null, it signifies that the row is the current version. The table also includes geographical data, with several...

Column Descriptions

Natural Drainage Areas - Consolidated (Sourced from Stockholm, Sweden)

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

Version History of Combined Natural Drainage Areas (Sweden)

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 unique identifier for each row in the history table, along with '_row_number'.
_end_date	date	This column contains the date when a new version of the row was extracted from the data source. If the value is null, it denotes 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 source. It forms part of the unique identifier for each row in the history table, along with '_start_date'.
EU_CD	string	This column contains codes as per the EU standards.
OBJECTID	long	This column contains integer values that are unique identifiers for each object in the table.
Vattenforekomst	string	This column contains names of water bodies in Swedish.
geom_geojson	string	This column contains geometric data of the water bodies in GeoJSON format, a popular format for encoding geographic data structures.
geom_geotext	string	This column contains geometric data of the water bodies in plaintext format. It provides a human-readable representation of the geographic data.
geom_type	string	This column specifies the type of geometric data contained in the 'geom_geojson' and 'geom_geotext' columns. The sample value 'ST_MULTIPOLYGON' indicates that the geometric data represents a collection of polygons.
geom_centroid	string	This column contains the geographic coordinates of the centroid (geometric center) of each water body.
geom_center_x	double	This column contains the x-coordinate (longitude) of the centroid of each water body.
geom_center_y	double	This column contains the y-coordinate (latitude) of the centroid of each water body.
gml_id	string	This column contains the ID of each row in GML (Geography Markup Language) format, a standard for expressing geographical features.

Additional Info

Last Updated	January 19, 2025
Created	January 8, 2025