Environmental protection areas in Helsinki

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

Tables

Protected Areas in Helsingin kaupunkiympariston toimiala, FinlandTSV
This table contains data sourced from the website of 'Helsinki City Environment Sector' in Finland (ISO country code - 'fi'). The table 'helpel_suojelupiiri__pel_suojelupiiripolygon' includes various attributes related to protected areas, municipalities, and geometrical information. This dataset can be utilized for data analytics purposes such as conducting spatial analysis, visualizing protected areas within municipalities, calculating centroid coordinates, and determining the type of geometry for each area. The table provides valuable insights and supports decision-making processes related to environmental planning and conservation efforts.
Version History of 'Protection Area Polygon' in 'Helsinki Urban Environment Department' sourced from 'Finland'TSV
This table represents the version history of the 'suojelupiiripolygon' table sourced from the website of Helsingin kaupunkiympariston toimiala, which originates from Finland. It includes the columns '_start_date', '_end_date', '_row_number', 'id', 'suojelupii', 'kunta', 'suojelupi0', 'suojelupi1', 'kunta_nimi', 'kunta_nim0', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. The '_start_date' column contains the date when a row was extracted, while the '_end_date' column contains the date when a new version of the row was extracted. If the '_end_date' value is null, it means the row is the most recent version. This table provides valuable information for data analytics, such as tracking changes in 'suojelupiiripolygon' over time,...

Column Descriptions

Protected Areas in Helsingin kaupunkiympariston toimiala, Finland

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The row number of the data in the table.
id	int	The unique identifier of the row.
suojelupii	int	The value of suojelupii.
kunta	int	The value of kunta.
suojelupi0	string	The value of suojelupi0.
suojelupi1	string	The value of suojelupi1.
kunta_nimi	string	The name of the municipality.
kunta_nim0	string	The name of the municipality (alternative).
geom_geojson	string	The geometry in GeoJSON format.
geom_geotext	string	The text representation of the geometry.
geom_type	string	The type of the 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 geometry.

Version History of 'Protection Area Polygon' in 'Helsinki Urban Environment Department' sourced from 'Finland'

Column	Type	Comment
_start_date	date	Date when the row version starts being valid.
_end_date	date	Date when the row version stops being valid.
_row_number	long	Number indicating the order of the row version within the base table.
id	int	Unique identifier for each row version.
suojelupii	int	Field related to protection level.
kunta	int	Field related to municipality.
suojelupi0	string	Field related to protection level (similar to suojelupii).
suojelupi1	string	Field related to protection level (similar to suojelupii).
kunta_nimi	string	Field related to municipality name.
kunta_nim0	string	Field related to municipality name (similar to kunta_nimi).
geom_geojson	string	Geometry field in geoJSON format.
geom_geotext	string	Field containing text representation of the geometry.
geom_type	string	Type of the geometry (e.g. point, line, polygon).
geom_centroid	string	Centroid of the geometry.
geom_center_x	double	X-coordinate of the center of the geometry.
geom_center_y	double	Y-coordinate of the center of the geometry.
geom	binary	Field containing the actual geometry data.

Additional Info

Last Updated	April 23, 2024
Created	October 22, 2018