Trains.com

Need help to interpret a rail network dataset

927 views
8 replies
1 rating 2 rating 3 rating 4 rating 5 rating
  • Member since
    August 2023
  • 1 posts
Need help to interpret a rail network dataset
Posted by Johnny. Y on Wednesday, August 2, 2023 12:11 PM

Hi there, 

I have a rail dataset but unfortunately, I cannot find any information about the data description/manual. So I have difficulties to interpret the meaning of the value in this dataset. It is probably an ORNL rail network, the data table is shown in the picture attached. I want to know the meaning of the alphabet in the SIGNAL field, and it will be better if anyone knows where am I able to get a data description of this dataset.

Thank you very much !!!

ALID RTID QAUX MILES DIRCTN ENTRK MLC GAUGE TRKTYP GRADE HEIGHT WEIGHT STATUS PASNGR MILIT SIGNAL LSRC SB
1000010 LN     SN wCSXT 12.85 N 1.4 A _ 1 G O _ K _ S C Q SN
1000020 SOU wNS 0.19 N 1 H _ 1 G _ _ K _ _ M Q _
1000030 NCSLJ  Chat wCSXTtNS  tSQVR 9.39 E 2.4 A _ 2 G O _ K _ S C Q Chat
1000040 NCSLJ  Chat wCSXTtNS 4.19 E 2.4 A _ 2 G O _ K _ S C Q Chat
1000050 ATN    AM wATN 1.57 N 1 G _ 1 G _ _ K _ _ M Q AM
1000060 TAG wNS 1.83 E 1 G _ 1 G _ _ K _ _ M Q _
1000070 AB&CANJLnvl wCSXT 4.43 E 1.4 A _ 1 G O _ K _ _ C G Lnvl
1000080 CG  P wNS 0.93 N 1.4 C _ 1 G _ _ K _ _ C Q _
1000100 LN     BU wCSXTrNS 0.46 S 2.4 A _ 2 G O _ K A S C J BU

Signal Count of SIGNAL
B 3807
C 8199
G 1
I 10
M 14207
O 11
S 184
T 221
U 280
  • Member since
    May 2003
  • From: US
  • 24,939 posts
Posted by BaltACD on Monday, August 7, 2023 9:37 PM

Welcome!

Unless and until the rows and columns are correctly aligned with their headings - no one will be able to make sense out of it.

Never too old to have a happy childhood!

              

  • Member since
    March 2023
  • 168 posts
Posted by Perry Babin on Monday, August 7, 2023 11:40 PM

How would you attach an XLS file on this forum?

  • Member since
    December 2001
  • From: Northern New York
  • 24,865 posts
Posted by tree68 on Tuesday, August 8, 2023 6:51 AM

Perry Babin

How would you attach an XLS file on this forum?

Maybe "hand jam" a couple of lines.

LarryWhistling
Resident Microferroequinologist (at least at my house) 
Everyone goes home; Safety begins with you
My Opinion. Standard Disclaimers Apply. No Expiration Date
Come ride the rails with me!
There's one thing about humility - the moment you think you've got it, you've lost it...

  • Member since
    March 2023
  • 168 posts
Posted by Perry Babin on Tuesday, August 8, 2023 7:04 AM

What does that mean?

Can you post files without links onto this forum? If so, are there pages that tell you how to do that?

  • Member since
    May 2003
  • From: US
  • 24,939 posts
Posted by BaltACD on Tuesday, August 8, 2023 7:22 AM

Perry Babin
What does that mean?

...

Type and display the data with manual input.  The software of this forum does not make inputting and displaying data tables easy.

Never too old to have a happy childhood!

              

  • Member since
    September 2003
  • 21,356 posts
Posted by Overmod on Tuesday, August 8, 2023 7:24 AM

By explicit intent, there is no on-site hosting of either images or files.  We have had some threads in the past about why this is significant.

If you host the file externally, you can post a link that will access it, but the file must have a full URL.  We repeatedly have people attempt to share from a drive or a personal account that will not allow 'sharing' with what the remote system considers a random Internet-originated request... and we all know what to do when we get one of those, right?

The easiest way to see data from an Excel table is likely going to be to print a custom report, image that in a format the Kalmbach link tool will recognize (as a picture or screenshot) and then put the result up on a usual-suspects photo site from which you can set proper embed codes and whatnot.

  • Member since
    March 2023
  • 168 posts
Posted by Perry Babin on Tuesday, August 8, 2023 7:29 AM

That appears to be what he did. It was easily converted to an XLS file and I could post it to a server and provide a link but it's not my data. If he wants to do that, it should work. If he wants me to drop it on a server so others could click a link, I could do that. It's what I've had to do for some files.  

 

  • Member since
    July 2008
  • 2,323 posts
Posted by rdamon on Tuesday, August 8, 2023 7:41 AM

Or try taking a screen shot of the spreadsheet (win + shift + S  for PCs)

save the file

upload it here - https://postimages.org/

Copy the "Direct link:"

Click on the inset/edit image button and use that address.

 

Join our Community!

Our community is FREE to join. To participate you must either login or register for an account.

Search the Community

Newsletter Sign-Up

By signing up you may also receive occasional reader surveys and special offers from Trains magazine.Please view our privacy policy