National Public Transport Access Nodes (NaPTAN) - Ferry Ports
Information on planned roadworks carried out on the Highways Agency network
National Public Transport Access Nodes (NaPTAN) - Railway Stations
National Public Transport Access Nodes (NaPTAN) - Airports
National Public Transport Access Nodes (NaPTAN) - Coach Stations
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;
This theme has no geographic data to display