Vegetation Points in Helsinki, Finland (Helsingin kaupunkiympariston toimiala)

This dataset collection consists of one or more dataset tables sourced from the website of 'Helsinki City Environment Sector' in Finland.

Tables

Green Areas: Information about Green Points in Helsingin kaupunkiympariston toimiala, FinlandTSV
This table contains point data on viherosat (green spaces) in Helsinki, Finland. The table is sourced from the website of Helsingin kaupunkiympariston toimiala. It includes various columns such as '_extract_date', '_row_number', 'osan_id', 'paatyyppi', 'paatyyppi_c2', 'alatyyppi', 'alatyyppi_c4', 'materiaali', 'materiaal0', 'rakenteell', 'rakenteel0', 'talvikunno', 'talvikunn0', 'tkp_kiiree', 'tyhjentava', 'hoitoluokk', 'hoitoluok0', 'hoitoluoka', 'puhtaanapi', 'puhtaanap0', 'puhtaanap1', 'pituus', 'leveys', 'pinta_ala', 'puiston_ni', 'viheraluee', 'viheralue0', 'viheralue1', 'osan_nro', 'paivitetty', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', 'geom'. The table provides useful data for data analytics, such as analyzing the length,...
Version History of Green Areas Points in Helsinki, FinlandTSV
This table contains the version history of the rows extracted from the 'Helsingin kaupunkiympariston toimiala' data source in the country 'Finland'. It is a historical record of the base table called 'ylre_viherosat_pointpoint'. Each row in this table represents a specific version of a row in the base table. The columns '_start_date' and '_end_date' indicate the extraction dates for each row version. If the '_end_date' column is null, it means that the row is the most recent version. The table contains additional columns such as '_row_number', 'osan_id', 'paatyyppi', 'paatyyppi_c2', 'alatyyppi', 'alatyyppi_c4', 'materiaali', 'materiaal0', 'rakenteell', 'rakenteel0', 'talvikunno', 'talvikunn0', 'tkp_kiiree', 'tyhjentava', 'hoitoluokk', 'hoitoluok0', 'hoitoluoka', 'puhtaanapi',...

Column Descriptions

Green Areas: Information about Green Points in Helsingin kaupunkiympariston toimiala, Finland

Column	Type	Comment
_extract_date	date	The date of extraction for the data
_row_number	long	The sequential number of the row
osan_id	int	The ID of the osan
paatyyppi	string	The main type of the record
paatyyppi_c2	int	The second-level main type of the record
alatyyppi	string	The sub-type of the record
alatyyppi_c4	int	The second-level sub-type of the record
materiaali	string	The material used
materiaal0	int	The second material used
rakenteell	string	The structural aspect
rakenteel0	int	The second structural aspect
talvikunno	string	The winter maintenance
talvikunn0	int	The second winter maintenance
tkp_kiiree	string	The urgency of repairs needed
tyhjentava	string	Whether the area needs to be emptied
hoitoluokk	string	The maintenance class
hoitoluok0	int	The second maintenance class
hoitoluoka	string	The type of maintenance class
puhtaanapi	string	The cleanliness level
puhtaanap0	int	The second cleanliness level
puhtaanap1	int	The third cleanliness level
pituus	int	The length
leveys	int	The width
pinta_ala	int	The surface area
puiston_ni	string	The park's name
viheraluee	string	The green area
viheralue0	int	The second green area
viheralue1	int	The third green area
osan_nro	int	The number of the osan
paivitetty	string	The date of last update
geom_geojson	string	The geometry in GeoJSON format
geom_geotext	string	The geometry 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 geometric center
geom_center_y	double	The y-coordinate of the geometric center
geom	binary	The geometry

Version History of Green Areas Points in Helsinki, Finland

Column	Type	Comment
_start_date	date	This column indicates the start date of the validity period for the row version in the table.
_end_date	date	This column indicates the end date of the validity period for the row version in the table.
_row_number	long	This column represents the row number or identifier for the version history row.
osan_id	int	This column stores the identifier of the base table row for which the version history is recorded.
paatyyppi	string	This column stores the main type value of the base table row.
paatyyppi_c2	int	This column stores the secondary main type value of the base table row.
alatyyppi	string	This column stores the sub-type value of the base table row.
alatyyppi_c4	int	This column stores the secondary sub-type value of the base table row.
materiaali	string	This column stores the material value of the base table row.
materiaal0	int	This column stores the secondary material value of the base table row.
rakenteell	string	This column stores the structural value of the base table row.
rakenteel0	int	This column stores the secondary structural value of the base table row.
talvikunno	string	This column stores the winter maintenance value of the base table row.
talvikunn0	int	This column stores the secondary winter maintenance value of the base table row.
tkp_kiiree	string	This column stores the urgency value of the base table row.
tyhjentava	string	This column stores the evacuating value of the base table row.
hoitoluokk	string	This column stores the maintenance class value of the base table row.
hoitoluok0	int	This column stores the secondary maintenance class value of the base table row.
hoitoluoka	string	This column stores the tertiary maintenance class value of the base table row.
puhtaanapi	string	This column stores the cleanliness value of the base table row.
puhtaanap0	int	This column stores the secondary cleanliness value of the base table row.
puhtaanap1	int	This column stores the tertiary cleanliness value of the base table row.
pituus	int	This column stores the length value of the base table row.
leveys	int	This column stores the width value of the base table row.
pinta_ala	int	This column stores the area value of the base table row.
puiston_ni	string	This column stores the park name value of the base table row.
viheraluee	string	This column stores the green area value of the base table row.
viheralue0	int	This column stores the secondary green area value of the base table row.
viheralue1	int	This column stores the tertiary green area value of the base table row.
osan_nro	int	This column stores the part number or identifier of the base table row.
paivitetty	string	This column stores the date of the last update for the base table row.
geom_geojson	string	This column stores the geometry data in GeoJSON format for the base table row.
geom_geotext	string	This column stores the geometry data in Geotext format for the base table row.
geom_type	string	This column stores the type of geometry for the base table row.
geom_centroid	string	This column stores the centroid point geometry for the base table row.
geom_center_x	double	This column stores the x-coordinate of the centroid point geometry for the base table row.
geom_center_y	double	This column stores the y-coordinate of the centroid point geometry for the base table row.
geom	binary	This column stores the full geometry information for the base table row.

Additional Info

Last Updated	April 23, 2024
Created	October 22, 2018