Open Water Pipes Shares in Streams in Helsinki

This dataset collection includes one or more dataset tables sourced from the website of Helsingin kaupunkiympariston toimiala (City of Helsinki's Urban Environment Division) in Finland.

Tables

Water Stream Conduits - Version HistoryTSV
This table contains the version history of the rows extracted from the 'Helsingin kaupunkiympariston toimiala' website, which originates from Finland. It has been named 'purojen_putkitetut_osuudetvesi_purojen_putkitetut_osuudetlinehistory'. The table includes additional columns compared to its base table: '_start_date' and '_end_date'. The '_start_date' column indicates the date when the row was extracted from the data source, while the '_end_date' column indicates the date when a new version of the row was extracted. If the value in the '_end_date' column is null, it denotes that the row is the most recent version. The table has various columns such as 'id', 'tunnus', 'luokkatunn', 'luokan_nim', 'nimi', 'kuvaus', 'huom', 'digipvm', 'pvm_editoi', 'pinta_ala', 'kohdetekst', 'metadata',...
Waterway Pipe Shares in Open WaterwaysTSV
This table contains data sourced from the website of Helsingin kaupunkiympariston toimiala in Finland (ISO country code: 'fi'). It contains information about the various attributes of the ltj_avoinvesi_purojen_putkitetut_osuudet__vesi_purojen_putkitetut_osuudetline table. The table may be utilized for data analytics purposes, such as analyzing the distribution of 'pinta_ala' (surface area) across different 'luokkatunn' (class identifiers) or studying the relationship between 'geom_geojson' (geographical JSON object) and 'metadata' (additional information). It can also be used to explore the 'kuvaus' (description) and 'nimi' (name) associated with each entry. The 'huom' (note) field could be used to identify any specific notes or comments about each entry. The 'digipvm' (digital date)...

Column Descriptions

Waterway Pipe Shares in Open Waterways

Column	Type	Comment
_extract_date	date	The date when the data was extracted
_row_number	long	The row number of the data entry
id	int	The unique identifier of the entry
tunnus	string	The tunnus of the entry
luokkatunn	string	The luokkatunn of the entry
luokan_nim	string	The name of the luokka
nimi	string	The name of the entry
kuvaus	string	The description of the entry
huom	string	Additional notes about the entry
digipvm	string	The digital date of the entry
pvm_editoi	string	The date when the entry was edited
pinta_ala	string	The surface area of the entry
kohdetekst	string	The target text of the entry
metadata	string	The metadata associated with the entry
geom_geojson	string	The geometric data in GeoJSON format
geom_geotext	string	The geometric data in Geotext format
geom_type	string	The type of geometric data
geom_centroid	string	The centroid of the geometric data
geom_center_x	double	The x-coordinate of the center of the geometric data
geom_center_y	double	The y-coordinate of the center of the geometric data
geom	binary	The geometric data

Water Stream Conduits - Version History

Column	Type	Comment
_start_date	date	The start date of the validity period of the row version.
_end_date	date	The end date of the validity period of the row version.
_row_number	long	The number that represents the order of the row version.
id	int	The unique identifier of the row.
tunnus	string	The identifier of the row.
luokkatunn	string	The identifier of the row's class.
luokan_nim	string	The name of the row's class.
nimi	string	The name of the row.
kuvaus	string	The description of the row.
huom	string	Additional remarks or notes about the row.
digipvm	string	The date of digitization of the row.
pvm_editoi	string	The date when the row was last edited.
pinta_ala	string	The surface area of the row.
kohdetekst	string	The text describing the object in the row.
metadata	string	Additional metadata associated with the row.
geom_geojson	string	The geometry of the row in GeoJSON format.
geom_geotext	string	Textual representation of the row's geometry.
geom_type	string	The type of geometry of the row.
geom_centroid	string	The centroid of the row's geometry.
geom_center_x	double	The X coordinate of the center point of the row's geometry.
geom_center_y	double	The Y coordinate of the center point of the row's geometry.
geom	binary	The spatial data that represents the geometry of the row.

Additional Info

Last Updated	September 13, 2024
Created	October 22, 2018