tiploc to lat lon coords

[Mike]

Hi

What is the best data resource for coding tiploc coords to lat lon coordinates?  I need to code schedule tiploc information to coordinates.. of osm.

Thanks!

[Carl Partridge]

Hi Mike

I'm fairly new here, but as far as I can tell there are three separate sources of static data that relate to Tiplocs:

1. The train planning data.
2. The TipLoc records that preface the Cif schedule information.

3. The TipLoc->Stanox mappings as found in the CORPUS data.

Of these, only the first dataset contains geographic information, specified in OS Northings and Eastings coordinates.  (where available, some are set to 00000 or 99999)  You'll find a useful spreadsheet here to help with the conversion to longitude and latitude.  If you're coding in C# .NET, I recommend the .Net Coordinates library as a quick and useful alternative.

You may be able to get more co-ordinates of TipLocs from other sources - there's a useful list of published data from other users at the bottom of this page.  I found the Barry Carlyon dataset a little degraded myself; search for duplicates and non-standard field lengths. Let us know if you find more sources of co-ordinates, as it seems to be a question that gets asked a lot here.

best,

Carl

[Carl Partridge]

Sorry, I should also mention NaPTAN, which contains a lot of the TipLoc codes together with their Lat/Lng coordinates too.  There are 2597 railway stations in NaPTAN, I'd be surprised if the non-station TipLocs are in there though, to get a complete picture it would be worth you cross-referencing this with the train planning data.  

[Juhani Pirttilahti]

Hi

Train planning data does have something to start with.

However, there is some errors to be filtered out.

You can use QGIS to import and convert the LOC records to WGS 84 coordinates or whatever system you need to use.

It is quite simple. Just filter out LOC records and save the file as a CSV and then import to QGIS (Layer -> Add Delimited Text Layer).

Use EPSG:27700 - OSGB 1936 / British National Grid - for the coordinate conversion.

I have attached an image for a visual reference... the file does have some false records and you have to sort out these.

[Marcus]

I've got this many:
(http://www.trainspots.co.uk/codes-index.php)

But I did them all 'by hand'

Cheers,

Marcus
--
www.rail-net.co.uk
www.trainspots.co.uk
www.youtube.com/railnet

[Mike J]

I have it on osm. Any suggestions how to get rid of false stations records?    I guess there are false records in side country borders also...

If someone is interested of data file I could post it (might be buggy:)

--
You received this message because you are subscribed to a topic in the Google Groups "A gathering place for the Open Rail Data community" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/openraildata-talk/yRLQZWfeZws/unsubscribe.

To unsubscribe from this group and all of its topics, send an email to openraildata-talk+unsubscribe@googlegroups.com.
To post to this group, send an email to openraildata-talk@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

[Marcus]

Quickly, no idea.

Of the 2,647 things mapped 100% of them were input manually by myself.
For a project I did about 6 years ago for plotting the routes of workings:
(http://www.trainspots.co.uk/working-report.php?working=168)

I've yet to merge the 'official data' in with mine as
a) there are the 'false' locations
b) the ones that are correct are not necessarily in the right place.

I will probably go on manually inputting the locations into my database
for a while, I just have problems locating signal locations.

Marcus

On 12/03/2014 01:07, Mike J wrote:
> I have it on osm. Any suggestions how to get rid of false stations
> records? I guess there are false records in side country borders also...
> If someone is interested of data file I could post it (might be buggy:)
>
>
> 2014-03-11 19:30 GMT+02:00 Marcus <g...@rail-net.co.uk

> <mailto:g...@rail-net.co.uk>>:

>
> On 11/03/2014 06:41, Mike wrote:
>
> Hi
>
> What is the best data resource for coding tiploc coords to lat lon
> coordinates? I need to code schedule tiploc information to
> coordinates.. of osm.
>
>
> I've got this many:

> (http://www.trainspots.co.uk/__codes-index.php
> <http://www.trainspots.co.uk/codes-index.php>)

>
> But I did them all 'by hand'
>
> Cheers,
>
> Marcus
> --

> www.rail-net.co.uk <http://www.rail-net.co.uk>
> www.trainspots.co.uk <http://www.trainspots.co.uk>
> www.youtube.com/railnet <http://www.youtube.com/railnet>

>
>
>
> --
> You received this message because you are subscribed to a topic in
> the Google Groups "A gathering place for the Open Rail Data
> community" group.
> To unsubscribe from this topic, visit

> https://groups.google.com/d/__topic/openraildata-talk/__yRLQZWfeZws/unsubscribe
> <https://groups.google.com/d/topic/openraildata-talk/yRLQZWfeZws/unsubscribe>.

> To unsubscribe from this group and all of its topics, send an email

> to openraildata-talk+unsubscribe@__googlegroups.com
> <mailto:openraildata-talk%2Bunsu...@googlegroups.com>.

> To post to this group, send an email to

> openraildata-talk@__googlegroups.com
> <mailto:openrail...@googlegroups.com>.
>
> For more options, visit https://groups.google.com/d/__optout
> <https://groups.google.com/d/optout>.
>
>

[Prof Falken]

https://gist.github.com/proffalken/8096231 has a SQL Dump of my location_data table taken from the NaPTAN Data Set.

It only covers railway stations, not freight depots etc. but it might be of soe use.

Matt

[Carl Partridge]

Just to follow up on this, I'm about to post my cleaned, merged dataset to the group as a new thread.

bw,

Carl