Airport Traffic Map - Historical Data
Click here for a data sample
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.
Field Descriptions
| Name |
Data type |
Description |
| _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. |
|---|
