To download the data set, please sign up or log in

Aerodrome Node Default Style

Aerodrome Node Default Style

Tables

Column Descriptions

Tn airtransportnetwork aerodromenode, Transportnetworkstn airtransportnetwork aerodromenode, Latest

Column Type Comment
inspireid string Data source did not contain a description for INSPIREID. Column inspireid has 99 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: http://paikkatieto.fi/so/... and first 25 characters of maximum string: http://paikkatieto.fi/so/...
geographic string Data source did not contain a description for GEOGRAPHIC. Column geographic has 99 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Aavahelukka and maximum string is YLIVIESKA.
designator string Data source did not contain a description for DESIGNATOR. Column designator has 99 rows, out of which 67 are empty, making the null percent 67.68. Minimum string is and maximum string is YLI.
locationin string Data source did not contain a description for LOCATIONIN. Column locationin has 99 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is EFAA and maximum string is EFYL.
validfrom string Data source did not contain a description for VALIDFROM. Column validfrom has 99 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 2014-02-06T00:00:00Z and maximum string is 2017-03-30T00:00:00Z.
validto string Data source did not contain a description for VALIDTO. Column validto has 99 rows, out of which 97 are empty, making the null percent 97.98. The single string value is: .
innetwork string Data source did not contain a description for INNETWORK. Column innetwork has 99 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Air Transport Network.
beginlifes string Data source did not contain a description for BEGINLIFES. Column beginlifes has 99 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 2002-11-30T00:00:00Z and maximum string is 2015-05-28T00:00:00Z.
endlifespa string Data source did not contain a description for ENDLIFESPA. Column is empty.
significan boolean Data source did not contain a description for SIGNIFICAN.
controltow string Data source did not contain a description for CONTROLTOW. Column is empty.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 99 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: POINT (19.896390030006312... and first 25 characters of maximum string: POINT (30.073609999983333...
geom_center_x float Longitude of center. Column geom_center_x has 99 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 19.90 and maximum value is 30.07.
geom_center_y float Latitude of center. Column geom_center_y has 99 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 59.85 and maximum value is 69.00.
geom_type string Geometry type. Column geom_type has 99 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_POINT.

Additional Info

Last Updated September 8, 2020
Created June 16, 2018