20210924
09305500
1.0
FALSE
Railroad_Bridges
002
-156.679117
-67.170095
20.883272
64.918303
1
file://\\FRASLHQW-67170\D$\Backup\PROJ\Bridge_DB_SpatialFront\National_Railroad_Bridges.gdb
Local Area Network
Geographic
GCS_WGS_1984
Angular Unit: Degree (0.017453)
<GeographicCoordinateSystem xsi:type='typens:GeographicCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/10.8'><WKT>GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433],AUTHORITY["EPSG",4326]]</WKT><XOrigin>-400</XOrigin><YOrigin>-400</YOrigin><XYScale>999999999.99999988</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>8.983152841195215e-09</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><LeftLongitude>-180</LeftLongitude><WKID>4326</WKID><LatestWKID>4326</LatestWKID></GeographicCoordinateSystem>
20211102
15075800
20211102
15075800
150000000
5000
ISO19139
ISO 19139 Metadata Implementation Specification
Version 6.2 (Build 9200) ; Esri ArcGIS 10.8.1.14362
Railroad Bridges
vector digital data
2020-11-30T00:00:00
external
9c18574cfe014c9f4c676b45c03e2c81
Raquel Wright
Federal Railroad Administration
GIS Program Manager
True
Raquel Wright
1
-156.679117
-67.170095
64.918303
20.883272
FRA
Rail Bridges
Rail
Bridges
A point layer of the rail bridges over road and water.
<DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>FRA develop a spatial point layer of the rail bridges over road and water. </SPAN><SPAN><SPAN>The bridges are a snapshot and is not an offical or complete inventory of all bridges. Railroads change ownership, railroads are abandoned, bridges are replaced, etc. therefore it cannot be relied upon as being accurate.</SPAN></SPAN></P></DIV></DIV></DIV>
FRA
Railroad, Bridges
Bridge
USA
USA
National
2020, 2021
external
9c18574cfe014c9f4c676b45c03e2c81
Raquel Wright
Federal Railroad Administration
GIS Program Manager
True
Raquel Wright
<DIV STYLE="text-align:Left;"><DIV><P><SPAN>Is not used for FRA SAfety Inspections ???</SPAN></P></DIV></DIV>
File Geodatabase Feature Class
ArcGIS 10.8.1
dataset
EPSG
6.14(3.0.1)
71271
Simple
FALSE
71271
TRUE
FALSE
Railroad_Bridges
Feature Class
71271
OBJECTID
OBJECTID
OID
4
0
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
SHAPE
SHAPE
Geometry
0
0
0
Feature geometry.
Esri
Coordinates defining the features.
UniqueID
Bridge Identifier
String
50
0
0
The Primary Key Universal Unique Identifier (UUID) of a bridge database record.
FRA
UniqueID
City
City Name
String
50
0
0
City name of where the bridge is located
Census
City Name
U.S. Census Bureau's Master Address File / Topologically Integrated Geographic Encoding and Referencing (MAF/TIGER) Database (MTDB)
County
County Name
String
50
0
0
County name of where the bridge is located
Census
County Name
U.S. Census Bureau's Master Address File / Topologically Integrated Geographic Encoding and Referencing (MAF/TIGER) Database (MTDB)
State
State Abbreviation
String
2
0
0
State abbreviation of where the bridge is located.
U.S. Postal Service (USPS)
Official List of U.S. Postal Code Abbreviations
U.S. Postal Service (USPS)
FIPS
FIPS Code
String
5
0
0
Federal Information Processing Standard (FIPS)
National Institute of Standards and Technology
Federal Information Processing Standard (FIPS)
National Institute of Standards and Technology
Type
Crossing_Type
String
50
0
0
Latitude
Latitude
Double
8
0
0
Latitude Decimal Degrees (WGS 84)
FRA
Longitude
Longitude
Double
8
0
0
Longitude Decimal Degrees (WGS 84)
FRA
RROwner
RROwner
String
50
0
0
Railroad Code for Bridge Above Water, Above/Under Road, or Code of Top Railroad for Bridge Above Railroad
FRA
Subdivision
Subdivision
String
50
0
0
Subdivision of Railroad for Bridge Above Water, Above/Under Road, or Subdivision of Top Railroad for Bridge Above Railroad.
• Unknown
• {Division Name}
FRA
Rail_MilePost
Rail Milepost
String
50
0
0
Railroad Mile Marker of Bridge Above Water, Above/Under Road, or Mile Marker for Top Railroad for Bridge Above Railroad. If no MilePost found, the value is "Unknown"
FRA
Name
Name
String
255
0
0
Name of Road or Waterway under bridge.
FRA
Bridge_Type
Bridge Type
String
50
0
0
Bridge Type
FRA
Fixed - Non moveable
FRA
Moveable-Bascule
FRA
Moveable-Vertical Lift
FRA
Moveable-Swing
FRA
Design_Type
Design Type
String
50
0
0
Primary Design Type
FRA
Concrete
FRA
Other
FRA
Steel/Concrete
FRA
Steel Other
FRA
Steel Deck Girder
FRA
Steel Deck Truss
FRA
Steel Through Girder
FRA
Steel Through Truss
FRA
Timber
FRA
Unknown (if street view is not available)
FRA
Num_Tracks
Number of Tracks
String
50
0
0
Number of Railroad Tracks for Bridge Above Water, Above/Under Road, or Number of Top Railroad Tracks for Bridge Above Railroad
• One • Multiple
FRA
Length
Length
Double
8
0
0
Overall Length
FRA
ALT_Name
Alternate Name
String
50
0
0
Alternate Name: Names of moveable bridges
FRA
GradeCrossing_ID
Grade Crossing ID
String
50
0
0
USDOT Inventory Grade Crossing ID
Secondary_Name
Secondary_Name
String
255
0
0
Name of Road from Grade Crossing, or Name of Waterway from Water Bridges
FRA
Secondary_RROwner
Secondary RR Owner
String
50
0
0
Railroad Code from Grade Crossing for Bridge Above/Under Road or Code from Below Railroad for Bridge Above Railroad
FRA
Secondary_StreetNames
Secondary Street Names
String
2048
0
0
Names of Overlapping Roads
FRA
Secondary_Subdivision
Secondary Subdivision
String
50
0
0
Subdivision of Below Railroad for Bridge Above Railroad
• Unknown
• {Division Name}
FRA
Secondary_RailMilePost
Secondary Rail Mile Post
String
50
0
0
Mile Marker of Below Railroad for Bridge Above Railroad. If no MilePost found, the value is "Unknown"
FRA
Secondary_NumTracks
Secondary NumTracks
String
50
0
0
Number of Railroad Tracks for Bridge Above Water, Above/Under Road, or Number of Top Railroad Tracks for Bridge Above Railroad
• One • Multiple
FRA
Mile_Post
MilePost
String
50
0
0
Highway mile marker of bridge or waterway mile marker of bridge. If no MilePost found, the value is "Unknown".
FRA
CreateDate
CreateDate
Date
8
0
0
Source
Source
String
50
0
0
Data source used for intersection
FRA
NHD Waterways
Soure of intersection
FRA
Tiger Roads
Source of intersection
FRA
Operator
Operator Name
String
50
0
0
Operator Name who identify the bridge
FRA
20211102
external
9c18574cfe014c9f4c676b45c03e2c81
Raquel Wright
Federal Railroad Administration
GIS Program Manager
True
Raquel Wright
<DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>The bridges are a snapshot and is not an offical or complete inventory of all bridges. </SPAN><SPAN><SPAN>Railroads change ownership, railroads are abandoned, bridges are replaced, etc. therefore it cannot be relied upon as being accurate.</SPAN></SPAN></P><P /><P><SPAN /></P></DIV></DIV></DIV>
Business Rules for Primary Conflation
1. Grade Crossing related to abandoned railroad
a. Conflate Grade Crossing point to the intersection of abandoned railroad and road, then flag it as “BridgeRelatedToAbandoned”
2. Grade crossing has same street name as Tiger and rail owner as FRA railroad
a. Capture Tiger street name as primary and leave secondary street name blank. Capture FRA rail owner as primary and leave secondary rail owner blank. No flag needed.
3. Grade crossing has same rail owner but different street name than Tiger road
a. Conflate grade crossing to the intersection point, capture the Tiger road name as primary and grade crossing street name as secondary. Flag this bridge as “StreetNameUnmacthed”.
4. Grade crossing has street name, but Tiger road source does not
a. Conflate grade crossing to the intersection point. Leave primary street name blank and capture grade crossing street name as secondary. Flag the bridge as “StreetNameUnmatched”.
5. Grade crossing has same street name but different railroad owner than FRA railroad
a. Conflate grade crossing to the intersection point, capture the FRA railroad owner as primary owner and grade crossing rail owner as secondary. Capture the Tiger road street name as primary, leave secondary street name blank. Flag this bridge as “RailOwnerUnmatched”.
6. Grade crossing has railroad owner, but FRA railroad segment does not
a. Conflate grade crossing to the intersection. Leave primary rail owner blank and capture grade crossing rail owner as secondary. Flag the bridge as “RailroadNoOwner”.
7. Grade crossing has no street name
a. In urban area, if only one intersection in buffer of 200 meters (500 meters for rural areas), rail owner is matched, and the bridge can be observed on the image, and then conflate grade crossing bridge to the intersection point, capture the Tiger street name as primary and leave secondary street name blank. Flag this bridge as “GXingNoStreet”. 8. No Grade Crossing found
a. Consider this as a new bridge, capture railroad owner and street name from its corresponding FRA railroad and Tiger road. Flag it as “NoGXing”
9. Census Tiger road missing a road segment
a. Visually identify the bridge location based on Bing or Google imagery, capture street name from Tiger or Google Map and flag the cases as “NoStreet”.
10. FRA network is missing railroad segment4
a. Visually identify target based on imagery. Flag the case as “NoRailroad”
11. An overpass railroad bridge over multiple Tiger roads
a. If street names are the same, group intersection points and use the group center as the bridge location. Flag this case as “OverMulitpleRoads”
b. If street names are different, multiple bridges will be generated, with each one corresponding to one street. Flag it as “OverMulitpleRoadsUnmatched”
12. Multiple overpass bridges over a Tiger road
a. If same rail owner and not structurally separated, group intersection points and use the group center as the bridge location. Flag it as “MultipleRailroadOver”.
b. If same railownerbut structurally separated, multiple bridges are generated. Flag it as “MultipleRailroadOver”.
c. If different rail owners, multiple bridges are generated. Flag it as “MultipleRailroadUnmatchedOver”
13. An overpass road bridge over multiple railroads
a. If same rail owners, group intersection points and use the group center as the bridge location. Flag it as “MultipleRailroadUnder”
b. If different rail owners, multiple bridges are generated. Flag it as “MultipleRailroadUnmatchedUnder”
14. No Grade Crossing Bridge source, NBI or ATIP bridge exists
a. Generate a new bridge and capture FRA rail owner as primary. If ATIP is available and has different rail owner, capture rail owner as secondary. Capture bridge type, design type, length from NBI if available. Otherwise visually identify the bridge type.
15. Water bridge has different railroad owner than railroad
a. Conflate the water bridge to the intersection point. Capture FRA rail owner as primary and water bridge rail owner as secondary. Flag this bridge as “WaterBridgeUnmatched”
16. Missing water bridge source
a. Consider this intersection as a new bridge. Capture FRA rail owner as primary and waterway name. If ATIP available and has different rail owner, capture its rail owner as secondary. Flag this intersection point as “NoWaterBridge”
17. Waterway Target related to abandoned railroad
a. Conflate water bridge point to the intersection of abandoned railroad and waterway, then flag it as “WaterBridgeRelatedToAbandoned”
18. NBI as source for bridge type, design type, and bridge length
a. If NBI data is found within the buffer of 20 meters, use its STRUCTURE_LEN_MT_049, STRUCTURE_TYPE_043B, STRUCTURE_KIND_043A as the bridge length, bridge type, and design type respectively. Flag this intersection point as “NBI”
19. No NBI
a. Visually identify the bridge type, design type, and manually measure bridge length based on imagery and flag the cases as “NoNBI”.
20. Overlapping intersection points due to overlapping Tiger roads
a. Only one bridge will be generated. Capture the street name as the primary street name from one Tiger street segment
21. Overlapping Grade Crossings
a. Keep the one with the matched rail owner and street name
b. If no matched found, follow below rules: non-closed>closed, only rail owner matched >neither matched, public>private, above/below> at, latest revision date or last updated.
c. 3. If key fields are the same, just pick up the either one
22. Abandoned bridge
a. Visually identify the abandoned bridge based on Bing or Google imagery and flag the cases as “FRA Abandoned”.
23. Multiple railroads over a waterway
a. If same rail owner and not structurally separated, group intersection points and use the group center as the bridge location. Flag it as “MultipleRailroadOver”.
b. If same rail owner but structurally separated, multiple bridges are generated. Flag it as “MultipleRailroadOver”.
c. If different rail owners, multiple bridges are generated. Flag it as “MultipleRailroadUnmatchedOver”
24. Bridge Attribute: City Name (No Data Source)
a. Developed a batch process tool to get city name for all the bridges
25. Bridge Attribute: Num_Tracks and SUBDIV
a. If a bridge is related to the multiple railroad line segments, the Num of Tracks for bridge will be “Multiple”. For example, if a bridge point is the intersection of the one road and the multiple railroad line segment with the same railroad owner, the Num of Tracks should be “Multiple”.
b. If a bridge is related to the single railroad line segment, but the attribute value of TRACKS for the railroad line segment is more than 1, the Num of Tracks should be still populated as “Multiple”, Otherwise, it will be populated as “One”
c. Get SUBDIV from main track (NET=“M”). If no main tracks found, the value of SUBDIV is set to be “Unknown”
26. Bridge Attribute: Attribute: Rail_MilePost
a. ~ 50% of bridges do not have rail milepost; If no corresponding Milepost found, the value of Rail Milepost set to be “Unknown”
27. Follow the following rules to populate the column “NAME” and the column “SECONDARY_STREETNAMES”
a. If one of the overlapping street names in TIGER matches the street name on Grade Crossing database, that street name will go to the column “NAME”.
b. If no road name matches the street name in the Grade Crossing database, check the tiger MTFCC code, the road name with the highest function code will go to the column “NAME. c. If the function codes for the streets are the same, check the tiger RTTYP, the road name with the highest type code ("U“> "S“>"I“> “C“> “M“> "O") will go to the column “NAME. d. If the function codes and road type are the same, check if the street name includes a number such as “1STstreet”, “Rte80” or “HWY 9”. The road name which contains a number will go to the column “NAME”.
e. If none of the street names contain a number, then either street name will go to the column “NAME”.
f. The rest of the street names will go to the column “SECONDARY_STREETNAMES”.
28. Overlapping intersection points due to overlapping/crossing FRA Railroads
a. If RROWNER are different, multiple bridges will be generated at the same location, with one bridge for one RROWNER
Business Rules for Processing Rail over Rail
Business Rules for Processing HIFLD/NGA Railroad Bridges
1. No Bridge found around NGA point a. Definitions:
• No railroad observed or
• Railroad present but no FRA bridge observed b. Solution:
• NGA Bridge Point will not be conflated to FRA bridge
2. Stream bridge found around NGA point
a. Definitions:
• Railroad is observed, stream can be observed underneath railroad, and bridge or arch bridge can be observed • Its width is greater than10 feet b. Solution: • NGA Bridge Point will be conflated to FRA bridge; the bridge will be snapped to railroad.
3. FRA bridge identified near NGA point
a. Definitions:
• Railroad observed, but a FRA bridge already identified nearby b. Solution: • NGA Bridge Point will not be conflated to FRA bridge
4. Bridge present near NGA point
a. Definitions:
• Railroad observed, a bridge found at NGA point b. Solution: • NGA Point will be conflated to FRA bridge and its location will be moved to be on the FRA railroad
5. Business Rule 5: Cannot clearly see a bridge near NGA point
a. Definitions:
• Railroad present, cannot clearly see if there is a bridge or not due to poor image quality or blocked by tree b. Solution: • NGA Bridge Point will not be conflated to FRA bridge