Page 1 of 1
Crossing information spreadsheet
Posted: Wed Oct 25, 2023 10:41 pm
by ~Z~
Found a reference to the FRA's crossing list. Can select Michigan, hit download, and open up in your spreadsheet program(Excel, Libreoffice, etc). Shows data for every railroad crossing in Michigan, milepost number, owner, phone number to contact in case of issue, number of trains recorded in a sample day, crossing protection type, speed limits...lots of info.
https://safetydata.fra.dot.gov/officeof ... yData.aspx
Trains per day column headers: DayThru - trains between 6am-6pm. NghtThru - trains between 6pm-6am. TotalSwt - total switching train moves. WeekTrnMov - weekly train moves if they often have zero trains on some days.
Re: Crossing information spreadsheet
Posted: Thu Oct 26, 2023 1:08 pm
by Raildudes dad
Use with caution - lots of inaccuracies
Re: Crossing information spreadsheet
Posted: Fri Oct 27, 2023 11:18 pm
by Jetlink
Can you give some examples of the inaccuracies so we know what to be on the lookout for? Or is it just generally outdated or something else?
Re: Crossing information spreadsheet
Posted: Sat Oct 28, 2023 5:52 pm
by Saturnalia
Jetlink wrote: ↑Fri Oct 27, 2023 11:18 pm
Can you give some examples of the inaccuracies so we know what to be on the lookout for? Or is it just generally outdated or something else?
The database relies on railroad managers to keep the data current - not often a top priority - so a lot of stuff is out of date. Also not a high level of accuracy also, I've seen lots of train counts being wildly off. Some of the shortline stuff is actually pretty good, but the Class Ones seem to have people at HQ punching in numbers who don't know what is right or wrong.
Re: Crossing information spreadsheet
Posted: Tue Oct 31, 2023 12:02 am
by justin_gram
There is also an app! Easy to use map, zoom in and click your crossing. App is from the FRA.
iOS:
https://apps.apple.com/us/app/rail-cros ... d643005214
Shows all of that detailed information, along with data reports of every (reported) collision that has ever happened at that crossing.
Re: Crossing information spreadsheet
Posted: Wed Nov 01, 2023 7:32 pm
by Raildudes dad
"Can you give some examples of the inaccuracies so we know what to be on the lookout for? Or is it just generally outdated or something else?
Look at the CPMY. The GR leased to Marne in 1998?. It was not renewed in 2003. It still shows it's leased. In defense of the poor RR person that gets to fill out the form, I have not seen anything more confusing. I had to change Walker Ave from a grade separation to a grade crossing. I finally cried uncle and asked MDOT Rail to do it for me.