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 |
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