Pickled Egg Quiz

This is the place for posts that don't fit into any other category.

Moderator: RichardW

User avatar
mickthemaverick
Donor 2019
Posts: 3982
Joined: 11 May 2019, 17:56
x 1184

Re: Pickled Egg Quiz

Post by mickthemaverick »

Was the Queens pipe the incinerator C&E used to burn smuggled tobacco? Seem to recall something about that from Dockland visits :?: :)

User avatar
bobins
Donor 2020
Posts: 3392
Joined: 05 Jul 2012, 18:07
x 979

Re: Pickled Egg Quiz

Post by bobins »

10/10 A+ :) Spot on. IIRC, he also used to have to pour the contraband alcohol down the drain and into the Thames :bigcry:

User avatar
NewcastleFalcon
Posts: 12559
Joined: 25 Feb 2009, 11:40
x 1168

Re: Pickled Egg Quiz

Post by NewcastleFalcon »

mickthemaverick wrote:
15 Jul 2020, 21:08
That would be this one from Network Rails list:

CNH3 181.0231 0.0000 12 SALTNEY Bridge Underline Bridge NO LATERAL POSITION
NO TRACK ID London North Western Central West NO MAJ STRUCT FLG Functionary Network Rail (CE-Struct) NO SECONDARY ELR 0.0000 3978559DBEC245D9E04400306E4AD01A 193989 1 NO PARENT ELEMENT ID NO ROUTE TYPE N NO STRUCT POLICY REF FLG RBE - Brick NO SECONDARY MATERIAL NO STRUCTURAL FORM
Mick on the spreadsheet I downloaded that is Engineers Line Reference CNH3 and the bridge Number is 12.
The only ones on the list I found with no number ref are FORTH BRIDGE and TAY BRIDGE where those words are the reference.

REgards Neil

User avatar
mickthemaverick
Donor 2019
Posts: 3982
Joined: 11 May 2019, 17:56
x 1184

Re: Pickled Egg Quiz

Post by mickthemaverick »

That might be because I copied line 3968 instead of 3969 #-o This is 3969 which has Null ID in the ref column.
I cannot find either the Tay or Forth bridges named in the spreadsheet, which row numbers are they on your sheet Neil?

CNH3 181.0583 0.0000 NULL ID CULVERT 1200mm DIA - DUPLICATE(No Exams Req) Bridge Culvert NO LATERAL POSITION NO TRACK ID London North Western Central West NO MAJ STRUCT FLG Duplicate Network Rail NO SECONDARY ELR 0.0000 3978559DBEC345D9E04400306E4AD01A 193990 0 NO PARENT ELEMENT ID NO ROUTE TYPE N NO STRUCT POLICY REF FLG Unknown NO SECONDARY MATERIAL NO STRUCTURAL FORM
Screenshot
Screenshot
Last edited by mickthemaverick on 15 Jul 2020, 21:55, edited 1 time in total.

User avatar
bobins
Donor 2020
Posts: 3392
Joined: 05 Jul 2012, 18:07
x 979

Re: Pickled Egg Quiz

Post by bobins »

^^^^^
Reading that description - are you sure the bridge actually exists ? :rofl2:

User avatar
NewcastleFalcon
Posts: 12559
Joined: 25 Feb 2009, 11:40
x 1168

Re: Pickled Egg Quiz

Post by NewcastleFalcon »

mickthemaverick wrote:
15 Jul 2020, 21:50
That might be because I copied line 3968 instead of 3969 #-o This is 3969 which has Null ID in the ref column.
I cannot find either the Tay or Forth bridges named in the spreadsheet, which row numbers are they on your sheet Neil?
Forth Bridge is Spreadsheet line number 8581 on the sheet
Tay Bridge is Spreadsheet line number 8582 on the sheet

I down loaded the spreadsheet here https://www.whatdotheyknow.com/request/ ... twork_rail
didnt sort it at all so the line numbers I quote are the line numbers on an unsorted sheet.

Found the Forth Bridge entry using the "Find and Replace" option on the Edit menu on the spreadsheet. Just put Forth in the find box and clicked down all the occurences of it on the sheet and the bridge turned up on lines 8581 and 8582.


I think the sheet you are using is different to mine in the line numbers.

Regards Neil

User avatar
mickthemaverick
Donor 2019
Posts: 3982
Joined: 11 May 2019, 17:56
x 1184

Re: Pickled Egg Quiz

Post by mickthemaverick »

oooeerrrr!!
I think we have different versions of the sheet.

This is the column headings on my sheet and a shot showing the row numbers you mentioned:
Screenshot
Screenshot
I assumed the 'Railway ID' column to be the bridge number in view of the type of entries.
Screenshot
Screenshot
I have used excel to search the 15000+ rows for both bridges in all columns and found nothing!! :-D

I feel a plot thickening.

I downloaded the sheet from the freedom of information website!!

User avatar
NewcastleFalcon
Posts: 12559
Joined: 25 Feb 2009, 11:40
x 1168

Re: Pickled Egg Quiz

Post by NewcastleFalcon »

This is where I got mine from Freedom of info request response with This excel spreadsheet

Bridges 24062013.xls
Screenshot
Screenshot
REgards Neil

User avatar
mickthemaverick
Donor 2019
Posts: 3982
Joined: 11 May 2019, 17:56
x 1184

Re: Pickled Egg Quiz

Post by mickthemaverick »

Petty much the same source there except mine was from a 2018 enquiry and hence probably been up dated since your sheet.:
screenshot
screenshot
can you put up a screenshot of the lines so I can try and find them from other info in the entries? :)

User avatar
NewcastleFalcon
Posts: 12559
Joined: 25 Feb 2009, 11:40
x 1168

Re: Pickled Egg Quiz

Post by NewcastleFalcon »

mickthemaverick wrote:
15 Jul 2020, 23:52
can you put up a screenshot of the lines so I can try and find them from other info in the entries? :)
Mick, I have downloaded your FOI spreadsheet and as well as definitely not having the Forth Or Tay Bridge on the list it uses Engineer's Line References which do not include ECN2 or any of the Alpha Numeric References which fill the earlier sheet. The spreadsheet from 2018 has 15782 lines the info from 2013 has 28,452 lines.

Save you fruitlessly trying to match the two sheets up.....they contain different selections of information.
I guess it is down to what enquiry they put into their database.

The Engineer's Line References haven't changed as shown in the spreadsheet entitled Scotland Redacted from a 2019 FOI request, where the FORTH BRIDGE appears at line 1306 as the "Railway ID" and the TAY BRIDGE appears at Line 1501. Both have the engineers line reference ECN2.

Reference number: FOI2019/01148

REgards Neil
Last edited by NewcastleFalcon on 16 Jul 2020, 18:44, edited 1 time in total.

Online
Hell Razor5543
NOT Alistair or Simon
Posts: 10709
Joined: 01 Apr 2012, 09:47
x 1052

Re: Pickled Egg Quiz

Post by Hell Razor5543 »

Erm, I seem to have chucked a very hot potato into the mix! Sorry about that, Guys.

User avatar
bobins
Donor 2020
Posts: 3392
Joined: 05 Jul 2012, 18:07
x 979

Re: Pickled Egg Quiz

Post by bobins »

Hell Razor5543 wrote:
15 Jul 2020, 20:39
It IS The Forth Bridge, but it is simply known as "The Bridge" (according to Michael Portillo and Great British Railway Journeys). All other bridges are numbered (although they may be spoken about by their name).
Hell Razor5543 wrote:
16 Jul 2020, 14:40
Erm, I seem to have chucked a very hot potato into the mix! Sorry about that, Guys.

Rule number 1 - never trust a (ex-) politician :lol:

Online
Hell Razor5543
NOT Alistair or Simon
Posts: 10709
Joined: 01 Apr 2012, 09:47
x 1052

Re: Pickled Egg Quiz

Post by Hell Razor5543 »

bobins wrote:
16 Jul 2020, 15:36
Hell Razor5543 wrote:
15 Jul 2020, 20:39
It IS The Forth Bridge, but it is simply known as "The Bridge" (according to Michael Portillo and Great British Railway Journeys). All other bridges are numbered (although they may be spoken about by their name).
Hell Razor5543 wrote:
16 Jul 2020, 14:40
Erm, I seem to have chucked a very hot potato into the mix! Sorry about that, Guys.

Rule number 1 - never trust a (ex-) politician :lol:
Michael Portillo might be an ex-politician, but I would have expected the producers of Great British Railway Journeys to have done their research properly. If they get things wrong (and are SEEN to get it wrong) people will lose their trust in those producers. I would NOT blame the presenter (whoever they are) for any research mistakes (unless they are the researcher).

User avatar
bobins
Donor 2020
Posts: 3392
Joined: 05 Jul 2012, 18:07
x 979

Re: Pickled Egg Quiz

Post by bobins »

Having been filmed and been present during filming of a few bits for TV programmes, I can assure you that producers only have a passing acquaintance with truth and reality. 'Good' TV and accurate TV aren't the same thing, unfortunately :( I don't blame for that, BTW. I think most of the public would be too bored by 'accurate' TV.

Online
Hell Razor5543
NOT Alistair or Simon
Posts: 10709
Joined: 01 Apr 2012, 09:47
x 1052

Re: Pickled Egg Quiz

Post by Hell Razor5543 »

bobins wrote:
16 Jul 2020, 19:53
Having been filmed and been present during filming of a few bits for TV programmes, I can assure you that producers only have a passing acquaintance with truth and reality. 'Good' TV and accurate TV aren't the same thing, unfortunately :( I don't blame for that, BTW. I think most of the public would be too bored by 'accurate' TV.
True, but if something is claimed as a fact (regardless of the program presenting it) I would expect it to be accurate.