Recent content by PatTurner

Thanks Poggs and everyone for the additional info on berths. I'm still getting lots of descriptors being overwritten. Some are the special codes mentioned (COUT etc), some have letter prefixes, and some are all numeric. I'm concentrating on front end visualisation of the TD feed now, so I'm...

Update on progress handling the TD feed: I've added the area code to Berth and Descriptor in my schema, and the picture looks a lot better. However, I am getting Descriptors forcibly removed from their Berths when a Berth Step comes in for a different Descriptor. Examples I have come across are...

I tried making berth name and area the PK for a berth and that certainly helped. Good to have that confirmed as the right decision :-) I'll make the relationship the other way round and see how it goes from there. The technical barriers seem to be minute compared to understanding the domain...

Thanks Poggs, very helpful :-) I'm trying to produce a real time graph of the berth nodes, showing which TD is in any berth at a time. Problem is, my schema has the td with a FK to berth, and I'm getting more than one TD in a berth at one time. This isn't suppposed to happen is it? I'm...

I meant that svg is a vector format, so it may be usable. I don't know what format you'd like but there's a SVG to WKT converter here: http://code.google.com/p/svg-to-wkt-converter/ Would that do? --- old post above --- --- new post below --- Thanks Mark and Poggs for the explanations. Could...

You can grab the data in a variety of formats. Here's a link for SVG...

Great thread. I've been reading these posts to try and glean some information on the NR data feeds, and this has bean a really useful resource. So, thanks. @Poggs, it might not be appropriate for what you're doing with OpenStreetMaps, but have you seen the Railway Network Inspire data...