Mapping of NaPTAN's to NLCs?

Open Data
1

Does anyone know of a dataset that maps NLC codes to NaPTANs? I have a set of NLC’s that I would like to get the NaPTAN of.

Alternatively, I have the names of stations in the following format: Canary Wharf LU, Poplar DLR, Shadwell DLR, Limehouse DLR, Tower Gatewy DLR, W India Quay DLR, Custom House DLR, Lewisham DLR, W Hampstead LO, Dalston Kingsld, Euston NR, Marylebone NR (many more but this is just a sample)

Is there any way to get a NaPTAN from either of these?

2

There is one method I can think of, but it unfortunately only works for National Rail (and London Overground and Elizabeth line) stations (so not London Underground or DLR stations):

The CORPUS dataset from Network Rail has a mapping of various codes. Unfortunately, they don’t have a NaPTAN mapping, but you can map from an NLC to a TIPLOC or 3-Alpha code:

{
    "NLC": 142100,
    "STANOX": "72416",
    "TIPLOC": "WHMDSTD",
    "3ALPHA": "WHD",
    "UIC": "14210",
    "NLCDESC": "WEST HAMPSTEAD",
    "NLCDESC16": " "
}

Then, the NaPTAN 910 dataset will allow us to map from the TIPLOC or 3-Alpha code to an ATCO code:

<StopPoint CreationDateTime="2007-02-23T12:00:00" ModificationDateTime="2007-09-26T13:00:00" Modification="revise" RevisionNumber="2" Status="active">
  <AtcoCode>9100WHMDSTD</AtcoCode>
  <StopClassification>
    <OffStreet>
      <Rail>
        <AnnotatedRailRef CreationDateTime="2005-04-25T00:00:00" ModificationDateTime="2007-02-22T18:24:34" Modification="revise" RevisionNumber="2">
          <TiplocRef>WHMDSTD</TiplocRef>
          <CrsRef>WHD</CrsRef>
          <StationName>West Hampstead Rail Station</StationName>
        </AnnotatedRailRef>
      </Rail>
    </OffStreet>
  </StopClassification>
</StopPoint>
3

I had gotten to finding the CORPUS dataset. However, I’d like to get LU stations too. Any idea where I could find something that maps the TIPLOC to a NaPTAN?

4

@oskar I think this CSV file may provide the information you want to get ATCO Codes for the underground stations.

You can get the DLR stations by name from the national NapTAN CSV download by sorting on ATCOCode. They all use codes in the series 9400ZZDL… so come out in a single block. Likewise if you need them by name for the underground stations which use the series 9400ZZLU…

1 Like
5

While the 940ZZ~ series of NapTAN codes for “Metro Stations” (Railway Stations which aren’t National Rail) were originally set up with the next two characters indicating operator/system (so 940ZZDL~ for DLR, 940ZZLU~ for LU, etc), the latest additiions (notably Nine Elms and Battersea Power Station) do not follow this convention - so Battersea Power Station (9400ZZBPSUST) is amongst the Blackpool Tramway block. But I think the system is identified in the next column (CommonName), as a help to find such.

6

I think I’ve gotten there:
NUMBAT reports are available from TfL’s crowding data.

Each year has an excel book with definitions, in which, we can find a “Stations” sheet, containing an MNLC, and MASC(3 character station code and type), and Station Name.

With some string manipulation, the MASC can be mapped to the Gist CSV you linked, which lets me obtain a NaPTAN.

I will work on piecing this together and upload a CSV for others who may need this.
Thank you for your help!