Rail Traffic Volume in Helsinki City Region in 2007

The dataset collection contains tables sourced from the website of 'Helsingin kaupunkiympariston toimiala' in Finland. It is named 'avoindatameluselvitys_2007_alue_05_raideliikenne_l_den'.

Tables

Environmental Noise Study - Rail Transport Noise Study for Area 05 in 2007TSV
This table contains data from the 'Helsinki city environment sector' website, specifically the 'avoindatameluselvitys_2007_alue_05_raideliikenne_l_denmeluselvitys_2007_alue_05_raideliikenne_l_denpolygon' dataset. The table includes various columns such as '_extract_date', '_row_number', 'tietopalve', 'db_lo', 'db_hi', 'datanomist', 'paivitetty', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', and 'geom'. It provides information that can be utilized for data analytics purposes. By analyzing this dataset, one can gain insights into various aspects related to noise levels pertaining to rail traffic within specific areas. This can be valuable for understanding noise pollution patterns, identifying areas with high noise levels, and studying the...
Version History of Area 05 Noise Study - Rail Traffic in Helsinki - 2007TSV
This table, sourced from the website of the Helsinki City Environment Sector, contains the version history of rows from the table 'avoindatameluselvitys_2007_alue_05_raideliikenne_l_den__meluselvitys_2007_alue_05_raideliikenne_l_denpolygon'. It has additional columns '_start_date' and '_end_date' to track the extraction dates of each row. The data in this table can be used for various data analytics purposes. For example, it can be utilized to analyze the changes in the 'geom_geojson' and 'geom_geotext' columns over time, providing insights into the geographical aspects of noise studies related to rail transportation. Moreover, the 'tietopalve' column can be used to determine the data service responsible for providing the information, while the 'paivitetty' column can help identify when...

Column Descriptions

Environmental Noise Study - Rail Transport Noise Study for Area 05 in 2007

Column	Type	Comment
_extract_date	date	The date when the data was extracted
_row_number	long	The row number of the data entry
tietopalve	int	The type of service provided
db_lo	int	The lower bound of the database
db_hi	int	The upper bound of the database
datanomist	string	The name of the data analyst
paivitetty	string	The date when the data was last updated
geom_geojson	string	The geometry data in GeoJSON format
geom_geotext	string	The geometry data in Geotext format
geom_type	string	The type of the geometry data
geom_centroid	string	The centroid of the geometry data
geom_center_x	double	The x-coordinate of the center of the geometry data
geom_center_y	double	The y-coordinate of the center of the geometry data
geom	binary	The geometry data

Version History of Area 05 Noise Study - Rail Traffic in Helsinki - 2007

Column	Type	Comment
_start_date	date	This column indicates the start date of the validity period for the row version.
_end_date	date	This column indicates the end date of the validity period for the row version.
_row_number	long	This column represents the row number of the version in the history table.
tietopalve	int	This column stores the tietopalve information associated with the row version.
db_lo	int	This column holds the db_lo value for the row version.
db_hi	int	This column stores the db_hi value for the row version.
datanomist	string	This column contains the information of the datanomist associated with the row version.
paivitetty	string	This column represents the date when the row version was last updated.
geom_geojson	string	This column holds the geometrical data in JSON format for the row version.
geom_geotext	string	This column stores the geometrical data in geotext format for the row version.
geom_type	string	This column indicates the type of the geometry for the row version.
geom_centroid	string	This column represents the centroid of the geometry for the row version.
geom_center_x	double	This column stores the X-coordinate of the center of the geometry for the row version.
geom_center_y	double	This column holds the Y-coordinate of the center of the geometry for the row version.
geom	binary	This column contains the geometrical data for the row version.

Additional Info

Last Updated	September 13, 2024
Created	April 23, 2024