Railways Data for Helsinki Metropolitan Area in Finland

This dataset collection, sourced from the website of Helsingin kaupunkiympariston toimiala, consists of one or more dataset tables. The tables belong to the dataset collection named 'avoindatameluselvitys_2012_alue_12_rautatiet_l_yo'. The dataset collection provides data related to railways in the country Finland.

Tables

Noise survey areas near railways at night in 2012TSV
This table contains data from the avoindatameluselvitys_2012_alue_12_rautatiet_l_yo__meluselvitys_2012_alue_12_rautatiet_l_yopolygon dataset sourced from the website of Helsingin kaupunkiympariston toimiala. The dataset originates from Finland (ISO country code 'fi'). 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. These columns contain information that can be utilized in data analytics to study noise levels related to railway areas. By analyzing the data in this table, one can gain insights into the noise levels, their fluctuations over time, data ownership information, and the geographical aspects of the railway areas. This...
Version History of Meluselvitys 2012 Zone 12 Rautatiet L Yo PolygonTSV
This table contains the version history of rows from the 'avoindatameluselvitys_2012_alue_12_rautatiet_l_yo__meluselvitys_2012_alue_12_rautatiet_l_yopolygon' table, sourced from the website of Helsingin kaupunkiympariston toimiala in Finland. The table includes additional columns '_start_date' and '_end_date' which represent the extraction dates of each row. The data in this table can be utilized for various data analytics purposes such as trend analysis, historical comparisons, and identifying changes over time. The table provides insights into the noise assessment areas related to railways in Finland, including information such as identifier, data boundaries, data owner, last update date, geometry representation in both GeoJSON and Geotext formats, geometry type, centroid...

Column Descriptions

Noise survey areas near railways at night in 2012

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The row number of the record in the table.
id	int	The unique identifier of the record.
db_lo	int	The lower bound of the data.
db_hi	int	The higher bound of the data.
datanomist	string	The name of the data analyst.
paivitetty	string	The date when the data was updated.
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 in a general format.

Version History of Meluselvitys 2012 Zone 12 Rautatiet L Yo Polygon

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	A sequential number to identify the row version within the table.
id	int	The unique identifier for each row in the table.
db_lo	int	A lower bound value for a range of database values.
db_hi	int	An upper bound value for a range of database values.
datanomist	string	The name of the data scientist responsible for the row version.
paivitetty	string	The date and time when the row version was last updated.
geom_geojson	string	The geometry of the row version represented in GeoJSON format.
geom_geotext	string	The geometry of the row version represented in Geotext format.
geom_type	string	The type of geometry for the row version.
geom_centroid	string	The centroid of the geometry for the row version.
geom_center_x	double	The X-coordinate of the center point of the geometry for the row version.
geom_center_y	double	The Y-coordinate of the center point of the geometry for the row version.
geom	binary	The geometry object for the row version.

Additional Info

Last Updated	September 13, 2024
Created	April 23, 2024