Public Area Survey 2017 - Railways in District 19, Helsinki, Finland

The dataset collection contains one or more dataset tables sourced from the website of 'Helsinki City Environment Sector' in Finland.

Tables

History of Alue 19 Rautatiet Läden Data from Helsingin kaupunkiympäristön toimiala in FinlandTSV
This table contains the version history of rows from the 'avoindatameluselvitys_2017_alue_19_rautatiet_l_den__meluselvitys_2017_alue_19_rautatiet_l_denpolygon' base table. It includes additional columns '_start_date' and '_end_date' indicating the extraction dates of each row. The data in this table is sourced from the website of 'Helsinki City Environment Sector', which originates from the country with ISO country code 'fi'. The table can be used for data analytics purposes, such as analyzing changes over time or measuring the impact of noise pollution on different regions.
Railways Noise Survey Data for Area 19 - FinlandTSV
This table contains data from 'Helsinki City Planning Department', which originates from the country 'Finland'. It provides information related to the noise survey conducted in 2017 for the railway lines in Zone 19. The table includes a variety of 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'. These columns store different aspects of the noise survey data and the geographical features associated with the railway lines. The data in this table can be utilized for various data analytics purposes such as analyzing the noise levels in different locations, identifying noise hotspots, studying the relationship between noise levels and...

Column Descriptions

Railways Noise Survey Data for Area 19 - Finland

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The row number of the data.
id	int	The unique identifier of the record.
db_lo	int	The lower bound value of the record in the database.
db_hi	int	The upper bound value of the record in the database.
datanomist	string	The name of the person or entity responsible for the data.
paivitetty	string	The date when the data was last updated.
geom_geojson	string	The geometry of the record in GeoJSON format.
geom_geotext	string	The geometry of the record in Geotext format.
geom_type	string	The type of geometry for the record.
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.

History of Alue 19 Rautatiet Läden Data from Helsingin kaupunkiympäristön toimiala in Finland

Column	Type	Comment
_start_date	date	Column indicating the start date of the validity period of the row version.
_end_date	date	Column indicating the end date of the validity period of the row version.
_row_number	long	Column indicating the row number of the version in the history table.
id	int	Column representing the unique identifier of the base table row.
db_lo	int	Column representing the lower value of a date or time range.
db_hi	int	Column representing the upper value of a date or time range.
datanomist	string	Column indicating the data custodian or owner.
paivitetty	string	Column indicating the last updated date or timestamp.
geom_geojson	string	Column storing the geometries of the row version in GeoJSON format.
geom_geotext	string	Column storing the geometries of the row version in text format.
geom_type	string	Column indicating the type of geometry.
geom_centroid	string	Column storing the centroid of the geometry.
geom_center_x	double	Column storing the X coordinate of the centroid.
geom_center_y	double	Column storing the Y coordinate of the centroid.
geom	binary	Column storing the geometry in a binary format.

Additional Info

Last Updated	September 13, 2024
Created	October 21, 2018