Open Value Forest Objects from Helsingin kaupunkiymparisto toimiala in Finland

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

Tables

Open Value Forest Areas - PolygonTSV
This table contains data from 'Helsinki City Environment Sector' which is sourced from Finland (ISO country code: 'fi'). The table stores information about open value forest areas and their attributes. It includes various fields such as extraction date, row number, identifier, class identifier, class name, name, description, note, digitalization date, editing date, surface area, target text, metadata, geojson geometry, geotext geometry, geometry type, centroid of geometry, center X-coordinate, center Y-coordinate, and geometry.
Version History of Open Value Forest Sites - Polygon - Helsinki Urban Environment SectorTSV
This table contains the version history of the ltj_avoinarvo_metsakohteet__arvo_metsakohteetpolygon table. It includes additional columns '_start_date' and '_end_date' to indicate the start and end dates of each row's version. The data in this table is sourced from the website of Helsingin kaupunkiympäristön toimiala, which originates from the country Finland (ISO country code: FI). The table provides information about various forest areas, including their identifiers, class codes, names, descriptions, surface areas, digitalization dates, editing dates, metadata, geographic coordinates (in geoJSON and geotext formats), and geometries. The data in this table can be utilized in data analytics for various purposes, such as analyzing the changes in forest areas over different versions,...

Column Descriptions

Open Value Forest Areas - Polygon

Column	Type	Comment
_extract_date	date	The date when the row was extracted.
_row_number	long	The row number of the current record.
id	int	The unique identifier of the record.
tunnus	string	The tunnus value of the record.
luokkatunn	string	The luokkatunn value of the record.
luokan_nim	string	The luokan_nim value of the record.
nimi	string	The name value of the record.
kuvaus	string	The description of the record.
huom	string	Any additional remarks about the record.
digipvm	string	The digitalization date of the record.
pvm_editoi	string	The date on which the record was edited.
pinta_ala	float	The surface area of the record.
kohdetekst	string	The target text value of the record.
metadata	string	The metadata associated with the record.
geom_geojson	string	The GeoJSON representation of the geometry.
geom_geotext	string	The geotext representation of the geometry.
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 point of the geometry.
geom_center_y	double	The y-coordinate of the center point of the geometry.
geom	binary	The geometry of the record.

Version History of Open Value Forest Sites - Polygon - Helsinki Urban Environment Sector

Column	Type	Comment
_start_date	date	This column indicates the start date of the validity period of the row version.
_end_date	date	This column indicates the end date of the validity period of the row version.
_row_number	long	This column contains the row number of the version history entry.
id	int	This column stores the unique identifier of the row.
tunnus	string	This column stores a specific code or identifier related to the row.
luokkatunn	string	This column stores a code or identifier that represents the category of the row.
luokan_nim	string	This column stores the name associated with the category of the row.
nimi	string	This column stores the name associated with the row.
kuvaus	string	This column stores a description or additional information about the row.
huom	string	This column stores any additional remarks or notes related to the row.
digipvm	string	This column stores the digital date associated with the row.
pvm_editoi	string	This column stores the date when the row was last edited.
pinta_ala	float	This column stores the value indicating the surface area related to the row.
kohdetekst	string	This column stores a specific target text associated with the row.
metadata	string	This column stores metadata or additional information about the row.
geom_geojson	string	This column stores the geometrical representation of the row in the GeoJSON format.
geom_geotext	string	This column stores the geometrical text representation of the row.
geom_type	string	This column stores the type of geometry associated with the row.
geom_centroid	string	This column stores the centroid point of the geometry associated with the row.
geom_center_x	double	This column stores the x-coordinate of the center point of the geometry associated with the row.
geom_center_y	double	This column stores the y-coordinate of the center point of the geometry associated with the row.
geom	binary	This column stores the geometry associated with the row.

Additional Info

Last Updated	September 13, 2024
Created	October 21, 2018