Railroads in Area 09 - Helsinki City Environment Sector

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

Tables

Railway Noise Assessment 2017 - Area 09 Rautatiet L AEQ Paiva PolygonTSV
This table contains data from Helsingin kaupunkiympariston toimiala, which is a data source from Finland. It represents the avoindatameluselvitys_2017_alue_09_rautatiet_l_aeq_paiva__meluselvitys_2017_alue_09_rautatiet_l_aeq_paivapolygon table. The table consists of various columns including _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 data analytics purposes, such as analyzing noise levels in specific areas, identifying noise hotspots, studying the impact of noise on different regions, or visualizing the geographical distribution of noise levels.
Version History of Noise Study Areas for Railway in Finland by Helsingin kaupunkiympariston toimiala DatabaseTSV
This table contains the version history of the 'avoindatameluselvitys_2017_alue_09_rautatiet_l_aeq_paiva__meluselvitys_2017_alue_09_rautatiet_l_aeq_paivapolygon' table. It includes records with additional columns '_start_date' and '_end_date'. The '_start_date' column represents the extraction date of the row, while the '_end_date' column indicates the date when a new version of the row was extracted. Rows with a null value in the '_end_date' column are the most recent versions of the base table rows. The table is sourced from the website of 'City of Helsinki Urban Environment Division' which originates from Finland (country code: 'fi'). The table provides valuable insights for data analytics purposes, enabling analysis, comparison, and tracking of changes over time in the various...

Column Descriptions

Railway Noise Assessment 2017 - Area 09 Rautatiet L AEQ Paiva Polygon

Column	Type	Comment
_extract_date	date	The date when the data entry was extracted.
_row_number	long	The row number of the data entry in the table.
id	int	The unique identifier of the entry.
db_lo	int	The lower boundary value of the database range.
db_hi	int	The upper boundary value of the database range.
datanomist	string	The name of the data owner.
paivitetty	string	The date when the data was last updated.
geom_geojson	string	The geometry of the data entry in GeoJSON format.
geom_geotext	string	The geometry of the data entry in GeoText format.
geom_type	string	The type of the geometry of the data entry.
geom_centroid	string	The centroid of the geometry of the data entry.
geom_center_x	double	The x-coordinate of the center of the geometry of the data entry.
geom_center_y	double	The y-coordinate of the center of the geometry of the data entry.
geom	binary	The geometry of the data entry.

Version History of Noise Study Areas for Railway in Finland by Helsingin kaupunkiympariston toimiala Database

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 of the version.
id	int	The unique identifier for the row.
db_lo	int	The lower bound value of the database identifier range.
db_hi	int	The upper bound value of the database identifier range.
datanomist	string	The name of the data scientist responsible for the row.
paivitetty	string	The date and time when the row was last updated.
geom_geojson	string	The geometry of the row in GeoJSON format.
geom_geotext	string	The geometry of the row in Geotext format.
geom_type	string	The type of the geometry.
geom_centroid	string	The centroid point 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 full geometry object.

Additional Info

Last Updated	September 13, 2024
Created	October 21, 2018