Protected Area Blocks in Helsinki, Finland

The dataset collection 'helpel_suojelualalohko' consists of one or more dataset tables sourced from the website of Helsingin kaupunkiympäristön toimiala (City of Helsinki Environment Sector), located in Finland.

Tables

Protective Areas in the Municipality - Helsingin kaupunkiymparisto - FinlandTSV
This table contains data from 'Helsinki City environment sector' website, sourced from Finland. It provides information about protected areas ('suojelualalohko') in different municipalities ('kunta') across the country. The table includes various attributes such as the extraction date ('_extract_date'), row number ('_row_number'), GML identifier ('gml_id'), municipal names ('kunta_nimi'), protected area names ('suojeluala'), and other related attributes. The table also includes geographical information like the GeoJSON representation ('geom_geojson'), geospatial text representation ('geom_geotext'), and centroid point coordinates ('geom_centroid'). The 'geom' column stores the geometric information of the protected areas. This table can be utilized for data analytics purposes such as...
Version History of Protected Area Blocks in Helsingin kaupunkiympariston toimiala, FinlandTSV
This table contains the version history of the rows in the 'helpel_suojelualalohko__pel_suojelualalohko' table sourced from the website of 'Helsinki City Environment Division'. The table tracks changes to the rows over time, with each row having a start date and an end date. If the end date is null, it means that the row is the most recent version. The table includes columns such as '_start_date', '_end_date', 'gml_id', 'kunta', 'kunta_nimi', 'kunta_nim0', 'suojeluala', 'suojelual0', 'suojelual1', 'suojeluloh', 'suojelulo0', 'suojelulo1', 'suojelupii', 'suojelupi0', 'suojelupi1', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. This table provides valuable data that can be utilized for various data analytics purposes. For example, it...

Column Descriptions

Protective Areas in the Municipality - Helsingin kaupunkiymparisto - Finland

Column	Type	Comment
_extract_date	date	Date when the data was extracted
_row_number	long	Number assigned to each row of the table
gml_id	string	Unique identifier for each record
kunta	int	Code representing the municipality
kunta_nimi	string	Name of the municipality
kunta_nim0	string	Alternative name of the municipality
suojeluala	string	Code representing a protected area
suojelual0	string	Alternative code representing a protected area
suojelual1	int	Another alternative code representing a protected area
suojeluloh	string	Code representing a protected area division
suojelulo0	string	Another code representing a protected area division
suojelulo1	int	Another code representing a protected area division
suojelupii	string	Code representing a protected area sub-region
suojelupi0	string	Another code representing a protected area sub-region
suojelupi1	int	Another code representing a protected area sub-region
geom_geojson	string	Geometry in GeoJSON format
geom_geotext	string	Geometry in geotext format
geom_type	string	Type of geometry
geom_centroid	string	Centroid point of the geometry
geom_center_x	double	X coordinate of the geometry centroid
geom_center_y	double	Y coordinate of the geometry centroid
geom	binary	Geometry in an unspecified format

Version History of Protected Area Blocks in Helsingin kaupunkiympariston toimiala, 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 in the version history table.
gml_id	string	The globally unique identifier of the row version.
kunta	int	The code representing the municipality associated with the row version.
kunta_nimi	string	The name of the municipality associated with the row version.
kunta_nim0	string	The alternative name of the municipality associated with the row version.
suojeluala	string	The code representing the protected area associated with the row version.
suojelual0	string	The alternative code representing the protected area associated with the row version.
suojelual1	int	Another alternative code representing the protected area associated with the row version.
suojeluloh	string	The code representing the protected site associated with the row version.
suojelulo0	string	The alternative code representing the protected site associated with the row version.
suojelulo1	int	Another alternative code representing the protected site associated with the row version.
suojelupii	string	The code representing the protected area boundary associated with the row version.
suojelupi0	string	The alternative code representing the protected area boundary associated with the row version.
suojelupi1	int	Another alternative code representing the protected area boundary associated with the row version.
geom_geojson	string	The geometry of the row version in GeoJSON format.
geom_geotext	string	The geometry of the row version in text format.
geom_type	string	The type of geometry of the row version.
geom_centroid	string	The centroid point of the geometry of the row version.
geom_center_x	double	The x-coordinate of the centroid point of the geometry of the row version.
geom_center_y	double	The y-coordinate of the centroid point of the geometry of the row version.
geom	binary	The full geometry of the row version.

Additional Info

Last Updated	September 13, 2024
Created	October 22, 2018