Lakes in Vantaa, Finland

This dataset collection consists of one or more dataset tables sourced from the web site of Helsingin kaupunkiympäristön toimiala in Finland.

Tables

Version History of Lakes from Website of Helsingin kaupunkiympariston toimiala in FinlandTSV
This table contains the version history of the 'seutukarttavakavesi_jarvet__vakavesi_jarvetpolygon' base table. It is sourced from the website of 'Helsinki City Environment Sector' which originates from Finland. The table includes columns such as '_start_date', '_end_date', '._row_number', 'vesistap', 'vesista0', 'mtryhm', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. The '_start_date' column indicates the extraction date of each row, while the '_end_date' column shows the date when a new version of the row was extracted. If the '_end_date' is null, it means that the row is the most recent version. The table's data can be utilized in data analytics to analyze and track changes over time in features related to bodies of water and...
Water Bodies in FinlandTSV
This table contains data about lakes in Finland. It is sourced from the website of the 'City of Helsinki Environment Sector', which originates from the country with ISO country code 'fi'. The table includes information such as the extraction date, row number, water source, water area, water group, geographic data in the form of JSON and text format, geometry type, centroid coordinates, and the full geometry of the lake. The data in this table can be utilized in various data analytics scenarios, such as analyzing the distribution of lakes based on their water group, calculating the total water area in a specific region, identifying the location of a lake's centroid, or studying the geographical characteristics of different lake shapes.

Column Descriptions

Water Bodies in Finland

Column	Type	Comment
_extract_date	date	The date on which the data was extracted.
_row_number	long	The row number of the record.
vesistap	string	The unique identifier of the waterbody.
vesista0	string	The type of waterbody.
mtryhm	int	The group the waterbody belongs to.
geom_geojson	string	The geometry of the waterbody in GeoJSON format.
geom_geotext	string	The geometry of the waterbody in Well-Known Text (WKT) format.
geom_type	string	The type of geometry of the waterbody (point, line, or polygon).
geom_centroid	string	The centroid location of the waterbody.
geom_center_x	double	The x-coordinate of the center point of the waterbody.
geom_center_y	double	The y-coordinate of the center point of the waterbody.
geom	binary	The complete geometry information of the waterbody.

Version History of Lakes from Website of Helsingin kaupunkiympariston toimiala in Finland

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 row number of the version.
vesistap	string	The 'vesistap' column.
vesista0	string	The 'vesista0' column.
mtryhm	int	The 'mtryhm' column.
geom_geojson	string	The 'geom_geojson' column containing the geometry data in GeoJSON format.
geom_geotext	string	The 'geom_geotext' column containing the geometry data in Geotext format.
geom_type	string	The type of geometry.
geom_centroid	string	The centroid of the geometry.
geom_center_x	double	The x-coordinate of the center of the geometry.
geom_center_y	double	The y-coordinate of the center of the geometry.
geom	binary	The 'geom' column containing the geometry data.

Additional Info

Last Updated	September 13, 2024
Created	October 22, 2018