About this Dataset

National Public Transport Gazetteer (NPTG)

This is the Government data catalogue page for NPTG. Use this link to visit the actual website for NPTG: https://beta-naptan.dft.gov.uk/ NPTG a database of localities (cities, towns, villages and other settlements) in Great Britain. It provides a common frame of reference for the National Public Access Nodes (NaPTAN) schema. The appropriate naming and geospatial location of towns and places is vital for providing effective place and stop finding in on-line journey planners and other passenger information systems. Names are those that would be used by the people that reside or work in that place; the geospatial location is selected to optimise journey planning and other passenger information usage. The NPTG XML schema is used to distribute topographic data from the NPTG database to the local Administrative Areas who administer NaPTAN data, as well as other downstream Public Transport Information systems such as journey planners.
Publisher name: Department for Transport
Last updated: 2024-06-14T04:02:58Z

Tables

Table 1

@ukgov.nptg.table_1

1.59 MB
43854 rows
21 columns


CREATE TABLE table_1 (
  "nptglocalitycode" VARCHAR,
  "localityname" VARCHAR,
  "localitynamelang" VARCHAR,
  "shortname" VARCHAR,
  "shortnamelang" VARCHAR,
  "qualifiername" VARCHAR,
  "qualifiernamelang" VARCHAR,
  "qualifierlocalityref" VARCHAR,
  "qualifierdistrictref" VARCHAR,
  "parentlocalityname" VARCHAR,
  "parentlocalitynamelang" VARCHAR,
  "administrativeareacode" BIGINT,
  "nptgdistrictcode" BIGINT,
  "sourcelocalitytype" VARCHAR,
  "gridtype" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "creationdatetime" TIMESTAMP,
  "modificationdatetime" TIMESTAMP,
  "revisionnumber" BIGINT,
  "modification" VARCHAR
);