Traffic Data Collection - Helsinki Metropolitan Area

This dataset collection consists of one or more dataset tables sourced from the website of Helsingin kaupunkiympäristön toimiala (City of Helsinki Urban Environment Division) in Finland.

Tables

Airport Traffic Map - Historical DataTSV
This table contains the version history of the 'avoindataseutukartta_liikenne_lentoasemat__seutukartta_liikenne_lentoasematpolygon' table sourced from the website of 'Helsinki Urban Environment Division'. The data originates from Finland (ISO country code 'fi'). It includes the start and end dates of each version of the base table rows. The table can be used for various data analytics purposes such as analyzing changes over time, tracking updates to airport-related information, and studying spatial characteristics of airports. The specific columns in this table provide information related to airport names, geometries, information categorization, and data sources.
Traffic Airports on Metropolitan Area Map - HelsinkiTSV
This table contains data related to airports in Finland. It includes information such as the extraction date, row number, airport name, municipality group, JSON representation of the airport's geometry, text representation of the airport's geometry, type of geometry, centroid of the airport's geometry, x-coordinate of the centroid, y-coordinate of the centroid, raw geometry data, and information related to data services. The data in this table can be utilized for various data analytics purposes such as analyzing airport infrastructure, studying airport locations and distributions, identifying municipalities with multiple airports, and exploring spatial patterns in airport data. The table is sourced from the website of the Environmental Sector of the City of Helsinki, which originates...

Column Descriptions

Traffic Airports on Metropolitan Area Map - Helsinki

Column	Type	Comment
_extract_date	date	The date when the data was extracted
_row_number	long	The sequential number of the row
lentokentt	string	The name of the airport
mtryhm	int	The group of flights
geom_geojson	string	The geographical data in GeoJSON format
geom_geotext	string	The geographical data in GeoText format
geom_type	string	The type of the geographical data
geom_centroid	string	The centroid of the geographical data
geom_center_x	double	The x-coordinate of the center of the geographical data
geom_center_y	double	The y-coordinate of the center of the geographical data
geom	binary	The geometry data
tietopalve	int	The data provider

Airport Traffic Map - Historical Data

Column	Type	Comment
_start_date	date	The start date of the validity period of the row version.
_end_date	date	The end date of the validity period of the row version.
_row_number	long	The row number of the version in the table.
lentokentt	string	The airport associated with the row version.
mtryhm	int	The flight group associated with the row version.
geom_geojson	string	The geographic coordinates of the row version in GeoJSON format.
geom_geotext	string	The geographic coordinates of the row version in Geotext format.
geom_type	string	The type of geographic geometry of the row version.
geom_centroid	string	The centroid of the geographic geometry of the row version.
geom_center_x	double	The x-coordinate of the center of the geographic geometry of the row version.
geom_center_y	double	The y-coordinate of the center of the geographic geometry of the row version.
geom	binary	The geometric representation of the row version.
tietopalve	int	The data service associated with the row version.

Additional Info

Last Updated	September 13, 2024
Created	May 6, 2018