About this Dataset

National Public Transport Access Nodes (NaPTAN)

New NaPTAN is here! https://beta-naptan.dft.gov.uk/ NaPTAN is Great Britain's dataset of all public transport access points, ie anywhere you can get on or off public transport (including bus, rail, tram, metro, underground, air and ferry services). NaPTAN data is updated on a daily basis. The dates shown below are when the links on this website were last updated. We have redeveloped the NaPTAN service and now have a new Website and API you can use to download the data. https://beta-naptan.dft.gov.uk/.
Publisher name: Department for Transport
Last updated: 2024-06-14T04:02:58Z

Tables

Table 1

@ukgov.naptan.table_1

25.81 MB
433259 rows
43 columns


CREATE TABLE table_1 (
  "atcocode" VARCHAR,
  "naptancode" VARCHAR,
  "platecode" VARCHAR,
  "cleardowncode" VARCHAR,
  "commonname" VARCHAR,
  "commonnamelang" VARCHAR,
  "shortcommonname" VARCHAR,
  "shortcommonnamelang" VARCHAR,
  "landmark" VARCHAR,
  "landmarklang" VARCHAR,
  "street" VARCHAR,
  "streetlang" VARCHAR,
  "crossing" VARCHAR,
  "crossinglang" VARCHAR,
  "indicator" VARCHAR,
  "indicatorlang" VARCHAR,
  "bearing" VARCHAR,
  "nptglocalitycode" VARCHAR,
  "localityname" VARCHAR,
  "parentlocalityname" VARCHAR,
  "grandparentlocalityname" VARCHAR,
  "town" VARCHAR,
  "townlang" VARCHAR,
  "suburb" VARCHAR,
  "suburblang" VARCHAR,
  "localitycentre" VARCHAR,
  "gridtype" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "stoptype" VARCHAR,
  "busstoptype" VARCHAR,
  "timingstatus" VARCHAR,
  "defaultwaittime" VARCHAR,
  "notes" VARCHAR,
  "noteslang" VARCHAR,
  "administrativeareacode" BIGINT,
  "creationdatetime" TIMESTAMP,
  "modificationdatetime" TIMESTAMP,
  "revisionnumber" DOUBLE,
  "modification" VARCHAR,
  "status" VARCHAR
);