Tables from Helsingin kaupunkiympariston toimiala in Finland

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

Noise Areas Near Railways in Helsinki, Finland - 2017-2019TSV
This table contains data sourced from the website of 'Helsinki Urban Environment Division' in Finland. It represents a collection of spatial polygons representing noise areas generated by railways in Helsinki. The table consists of various attributes including the extract date, row number, ID, lower and higher decibel values, data nominator, update date, the geometry in both GeoJSON and GeoText formats, the type of geometry, the centroid of the polygons along with its x and y coordinates, and the full geometry.
Version History of Helsinki Railway and Noise Areas - Source: Helsinki Urban Environment Sector, FinlandTSV
The table contains the version history of a dataset sourced from the website of Helsingin kaupunkiympariston toimiala in Finland. It provides information on a specific data domain, with each row representing a version of the data extracted from the source. The table includes the '_start_date' column, indicating the date when each row was extracted, and the '_end_date' column, indicating the date when a new version of the row was extracted. If '_end_date' is null, it means that the row represents the most recent version of the data. The table contains various columns such as 'id', 'db_lo', 'db_hi', 'datanomist', 'paivitetty', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. These columns provide different attributes and characteristics...

Column	Type	Comment
_extract_date	date	The date when the record was extracted.
_row_number	long	The row number of the record.
id	int	The unique identifier of the record.
db_lo	float	The lower boundary value of a database range.
db_hi	float	The upper boundary value of a database range.
datanomist	string	The name of the data analyst.
paivitetty	date	The date when the record was last updated.
geom_geojson	string	The geometric data in GeoJSON format.
geom_geotext	string	The geometric data in GeoText format.
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 of the geometry.
geom_center_y	double	The y-coordinate of the center of the geometry.
geom	binary	The geometry data.

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 number of the row version.
id	int	The identifier of the row in the base table.
db_lo	float	Lower 32 bits of the hash value of the row version.
db_hi	float	Upper 32 bits of the hash value of the row version.
datanomist	string	The data scientist who updated the row version.
paivitetty	date	The date when the row version was last updated.
geom_geojson	string	The spatial information of the row version in GeoJSON format.
geom_geotext	string	The spatial information of the row version in Geotext format.
geom_type	string	The type of the spatial geometry of the row version.
geom_centroid	string	The centroid point of the spatial geometry of the row version.
geom_center_x	double	The x-coordinate of the center point of the spatial geometry of the row version.
geom_center_y	double	The y-coordinate of the center point of the spatial geometry of the row version.
geom	binary	The spatial geometry of the row version.

Last Updated	April 23, 2024
Created	July 9, 2018