Open Peace Areas in Natura

The dataset collection consists of tables sourced from the website of 'Helsinki City Environment Agency' in Finland.

Tables

Open Peace Natural Areas in FinlandTSV
This table contains data from 'Helsinki City Environment Sector' sourced from the website of the sector. The data in this table is sourced from Finland (ISO country code 'FI'). The table contains information related to a natural area named 'ltj_avoinrauh_natura__rauh_naturaline'. The table includes various columns such as '_extract_date', '_row_number', 'id', 'tunnus', 'luokkatunn', 'luokan_nim', 'nimi', 'kuvaus', 'huom', 'digipvm', 'pvm_editoi', 'pinta_ala', 'kohdetekst', 'metadata', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. These columns provide valuable information that can be utilized for data analytics. For example, the 'pinta_ala' column represents the surface area of the natural area. By analyzing this column, it is...
Version History of 'Rauh Naturaline' Data from Helsinki City Environment Sector (Finland)TSV
This table contains the version history of the rows extracted from the website of 'Helsinki City Environment Services'. The data in this table is sourced from the 'Rauh Natural Area Database'. The data in this table is specific to the country Finland (ISO country code: fi). The table has additional columns '_start_date' and '_end_date' compared to its base table. The '_start_date' column stores the date when the row was extracted from the data source, while the '_end_date' column stores the date when a new version of the row was extracted. If the value in the '_end_date' column is null, it indicates that the row is the most recent version. The table contains various columns such as 'id', 'tunnus', 'luokkatunn', 'luokan_nim', 'nimi', 'kuvaus', 'huom', 'digipvm', 'pvm_editoi',...

Column Descriptions

Open Peace Natural Areas in Finland

Column	Type	Comment
_extract_date	date	The date on which the data was extracted.
_row_number	long	The number of the row in the table.
id	int	The unique identifier of the entry.
tunnus	string	The identifier of the item.
luokkatunn	string	The identifier of the class.
luokan_nim	string	The name of the class.
nimi	string	The name of the item.
kuvaus	string	The description of the item.
huom	string	Any additional notes or remarks.
digipvm	date	The date of the digital version.
pvm_editoi	date	The date of the latest edit.
pinta_ala	float	The surface area of the item.
kohdetekst	string	The target text.
metadata	string	The metadata information of the item.
geom_geojson	string	The geometry data in GeoJSON format.
geom_geotext	string	The geometry data in Geotext format.
geom_type	string	The type of geometry.
geom_centroid	string	A point representing 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 data.

Version History of 'Rauh Naturaline' Data from Helsinki City Environment Sector (Finland)

Column	Type	Comment
_start_date	date	The start date of the validity period for the row version.
_end_date	date	The end date of the validity period for the row version.
_row_number	long	The number indicating the order of the row version.
id	int	The unique identifier of the row.
tunnus	string	The identifier of the row.
luokkatunn	string	The identifier of the class.
luokan_nim	string	The name of the class.
nimi	string	The name of the row.
kuvaus	string	The description of the row.
huom	string	Additional notes about the row.
digipvm	date	The digital date of the row.
pvm_editoi	date	The date when the row was last edited.
pinta_ala	float	The surface area of the row.
kohdetekst	string	The target text of the row.
metadata	string	The metadata of the row.
geom_geojson	string	The geometric data of the row in GEOJSON format.
geom_geotext	string	The geometric data of the row in GEOTEXT format.
geom_type	string	The type of the geometry of the row.
geom_centroid	string	The centroid of the geometry of the row.
geom_center_x	double	The x-coordinate of the center point of the geometry of the row.
geom_center_y	double	The y-coordinate of the center point of the geometry of the row.
geom	binary	The geometric representation of the row.

Additional Info

Last Updated	September 13, 2024
Created	October 22, 2018