Transport

National Public Transport Access Nodes (NaPTAN) - Ferry Ports

Find ferry ports closest to a lat/lon point


Find ferry ports within a region


Find ferry ports near to a postcode (distance in kilometers)


                    

Information on planned roadworks carried out on the Highways Agency network

Find planned and historical roadworks by road (e.g. M1)


                    

National Public Transport Access Nodes (NaPTAN) - Railway Stations

Find railway stations closest to a lat/lon point


Find railway stations within a region


Find railway stations near to a postcode (distance in km)


                    

National Public Transport Access Nodes (NaPTAN) - Airports

Show all airports


                    

National Public Transport Access Nodes (NaPTAN) - Coach Stations

Find coach stations closest to a lat/lon point


Find coach stations within a region


Find coach stations near to a postcode (distance in km)


                    

The tabs below show the schema for each accessible table within this theme

Naptan Airports

Table Name: naptan_airports
Field Type Description
atcocode string
iatacode string
name string

Naptan Coach Stations

Table Name: naptan_coach_stations
Field Type Description
atcocode string
nationalcoachcode string
name string
ospoint USER-DEFINED
latlong USER-DEFINED

Naptan Ferry Ports

Table Name: naptan_ferry_ports
Field Type Description
atcocode string
ferrycode string
name string
ospoint USER-DEFINED
latlong USER-DEFINED

Naptan Railway Stations

Table Name: naptan_railway_stations
Field Type Description
atcocode string
tiploccode string
crscode string
stationname string
ospoint USER-DEFINED
latlong USER-DEFINED

Planned Road Works

Table Name: planned_road_works
Field Type Description
reference_number string
road [Indexed] string
local_authority string
location string
start_date timestamp without time zone
end_date timestamp without time zone
expected_delay string
description string
traffic_management string
closure_type string
centre_easting string
centre_northing string
status string
published_date timestamp without time zone


Within this editor you may perform SQL queries against the transport database - queries are currently limited to 5 seconds execution time.

SELECT * FROM naptan_airports limit 10;