Open valuable plant locations in Helsinki, Finland

The dataset collection consists of one or more dataset tables sourced from the website of Helsingin kaupunkiympariston toimiala in Finland.

Tables

Historical Version of Valuable Vegetation Areas Polygon in Helsinki Urban Environment Sector, FinlandTSV
This table contains the version history of the rows in the 'Arvokkaat_kasvikohteetPolygon' table sourced from the website of 'Helsinki City Environment Services' in Finland. It provides information about various valuable plant locations. The table includes columns such as '_start_date', '_end_date', 'row_number', 'id', 'tunnus', 'luokkatunn', 'luokan_nim', 'nimi', 'kuvaus', 'huom', 'digipvm', 'pvm_editoi', 'pinta_ala', 'kohdetekst', 'arvoluokka', 'arvoluokan', 'metadata', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. The '_start_date' column denotes the date when a particular row was extracted from the data source, while the '_end_date' column represents the date when a new version of the row was extracted. If the '_end_date' value...
Valuable Plant Areas: Polygon GeometryTSV
This table contains data from the 'Helsinki City environment' website, which originates from the country Finland (ISO country code: FI). It represents valuable vegetation areas with their related attributes. The table includes information such as the extraction date, row number, unique identifier, class identifier, class name, name, description, notes, digitalization date, editing date, area, target text, value class, value class name, metadata, GeoJSON representation of the geometry, geotext representation of the geometry, geometry type, centroid of the geometry, x coordinate of the centroid, y coordinate of the centroid, and the geometry itself. The data in this table can be utilized for various data analytics purposes including spatial analysis, identifying valuable vegetation areas,...

Column Descriptions

Valuable Plant Areas: Polygon Geometry

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 identifier of a specific object.
luokkatunn	string	The identifier of a class.
luokan_nim	string	The name of a class.
nimi	string	The name of a particular object.
kuvaus	string	The description of a particular object.
huom	string	Additional notes or remarks.
digipvm	string	The date when the data was digitally captured.
pvm_editoi	string	The date when the data was edited.
pinta_ala	float	The surface area of an object.
kohdetekst	string	The text related to an object.
arvoluokka	string	The value class of an object.
arvoluokan	string	The name of the value class.
metadata	string	Additional data about an object.
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 a geometric object.
geom_center_x	double	The x-coordinate of the center of a geometric object.
geom_center_y	double	The y-coordinate of the center of a geometric object.
geom	binary	The geometric data.

Historical Version of Valuable Vegetation Areas Polygon in Helsinki Urban Environment Sector, Finland

Column	Type	Comment
_start_date	date	The start date indicating the validity period of the row version.
_end_date	date	The end date indicating the validity period of the row version.
_row_number	long	The unique row number of the version in the table.
id	int	The unique identifier for the row.
tunnus	string	The tunnus column.
luokkatunn	string	The luokkatunn column.
luokan_nim	string	The luokan_nim column.
nimi	string	The nimi column.
kuvaus	string	The kuvaus column.
huom	string	The huom column.
digipvm	string	The digipvm column.
pvm_editoi	string	The pvm_editoi column.
pinta_ala	float	The pinta_ala column.
kohdetekst	string	The kohdetekst column.
arvoluokka	string	The arvoluokka column.
arvoluokan	string	The arvoluokan column.
metadata	string	The metadata column.
geom_geojson	string	The geom_geojson column.
geom_geotext	string	The geom_geotext column.
geom_type	string	The geom_type column.
geom_centroid	string	The geom_centroid column.
geom_center_x	double	The geom_center_x column.
geom_center_y	double	The geom_center_y column.
geom	binary	The geom column.

Additional Info

Last Updated	April 23, 2024
Created	October 21, 2018