Public Transport and Urban Environment Survey 2017 (Area 16, Night Trams)

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

Tables

Noise Study 2017 Rail Traffic L Night - Helsinki City Environment DepartmentTSV
This table contains data from the 'Helsinki City Environment Sector' website, which originates from the country Finland. It represents information from the 'avoindatameluselvitys_2017_alue_16_raitioliikenne_l_yo__meluselvitys_2017_alue_16_raitioliikenne_l_yopolygon' dataset. The table includes various columns such as '_extract_date', '_row_number', 'id', 'db_lo', 'db_hi', 'datanomist', 'paivitetty', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', and 'geom'. This data can be utilized for various data analytics purposes such as analyzing noise levels related to nighttime public transportation routes in Helsinki. For example, the columns 'db_lo' and 'db_hi' provide information about the noise level range, while 'geom_geojson' and...
Version history of railyard noise assessment polygons in area 16 in Helsinki (Nighttime)TSV
This table contains the version history of the 'avoindatameluselvitys_2017_alue_16_raitioliikenne_l_yo__meluselvitys_2017_alue_16_raitioliikenne_l_yopolygon' table. It is sourced from the website of 'Helsinki City Environment Sector' in Finland. The table consists of rows with additional columns '_start_date' and '_end_date', indicating the extraction dates of each row. The table can be utilized for data analytics purposes, such as studying the changes in noise assessment for nighttime public transportation routes. The various attributes in the table can be used to analyze the characteristics of the noise levels, track updates in data, and calculate centroids or center points of geometries. Analyzing this historical data can provide insights into noise patterns and support...

Column Descriptions

Noise Study 2017 Rail Traffic L Night - Helsinki City Environment Department

Column	Type	Comment
_extract_date	date	The date and time when the data was extracted.
_row_number	long	The row number of the data entry.
id	int	The unique identifier of the record.
db_lo	int	The lower bound of the database index value.
db_hi	int	The upper bound of the database index value.
datanomist	string	The name of the data owner.
paivitetty	string	The date and time when the data was last updated.
geom_geojson	string	The geometry in GeoJSON format.
geom_geotext	string	The geometry 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 spatial representation of the data.

Version history of railyard noise assessment polygons in area 16 in Helsinki (Nighttime)

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 row number indicating the version history of the base table rows.
id	int	The unique identifier of the row.
db_lo	int	The lower bound of the database version.
db_hi	int	The upper bound of the database version.
datanomist	string	The person responsible for the data.
paivitetty	string	The date of the last update of the row.
geom_geojson	string	The geometry in GeoJSON format.
geom_geotext	string	The geometry in Geotext format.
geom_type	string	The type of the 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.

Additional Info

Last Updated	September 13, 2024
Created	October 21, 2018