guardrail_pdx |
Table Description | |
Table Jurisdiction | |
Column Sort | Column Name | Column Alias | Column Type | Column Size | Domain Value(s) | Column Description |
1 | AssetID | AssetID | String | 15 | | Unique asset identifier. | 1 | GuardRailType | GuardRailType | Integer | 4 | 4710 | Concrete barrier | X | 4711 | Guardrail | X | 4712 | Rock barrier | X | 4713 | Post cable | X | 4714 | Other | X | | The subtype field describes broad categories of roadside barriers including guardrail, concrete, rock and post and cable designs. | 1 | LocationID | LocationID | String | 15 | | Location in PBOT's location hierarchysystem. | 1 | ImagePath | ImagePath | String | 255 | | Link to related diagram or photo, not typically used for guardrail. | 1 | TotalLength | TotalLength | Numeric | 8 | | Field measurement of the length of the barrier, in feet. | 1 | SectionLength | SectionLength | Numeric | 8 | | Length of a typical section of the barrier, in feet. | 1 | Owner | Owner | String | 15 | | Owner of the asset. PdxTrans means the asset is owned by PBOT. | 1 | MaintResp | MaintResp | String | 15 | | Maintainer of the asset. PdxTrans means that PBOT is responsible for maintaining the asset. | 1 | DistAlongSt | DistAlongSt | Integer | 4 | | Distance from the curb face or edge of pavement/roadway of the nearest cross street to the beginning of the roadside barrier, in feet. Not typically populated. | 1 | MeasureDir | MeasureDir | String | 1 | | Direction of the DistAlongSt measure. Not typically populated. | 1 | MeasureFrom | MeasureFrom | String | 50 | | Description of the starting point for the DistAlongSt measure. Not typically populated. | 1 | DistFromEdge | DistFromEdge | Integer | 4 | | Narrowest distance from edge of traveled way to the face of the barrier. Edge of traveled way is defined as edge of vehicle travel lane (i.e. curb face, edge line, bike lane line, or edge of pavement if no line). If for any portion of the run, the face of the rail is over the curb, 0 is recorded as the distance value. | 1 | MinRailHeight | MinRailHeight | Integer | 2 | | If the rail is behind the curb, the lowest height (in inches) from the surface on which the rail is mounted is measured. If the face of the rail is over the curb, the height from the surface of the roadway is measured. If the rail height is uniform, the same value for both minimum and maximum height is entered. | 1 | MaxRailHeight | MaxRailHeight | Integer | 2 | | The highest height (in inches) from the surface on which the rail is mounted to the top of the rail is measured. If the rail height is uniform, the same value is entered for both minimum and maximum height. | 1 | SectionsStraight | SectionsStraight | Integer | 2 | | The number of straight sections. Concrete barrier sections should berecorded as “straight.” | 1 | SectionsConcave | SectionsConcave | Integer | 2 | | The number of concave sections (bends away from traffic). | 1 | SectionsConvex | SectionsConvex | Integer | 2 | | The number of convex sections (bends towards traffic). | 1 | PostsTimber6x8 | PostsTimber6x8 | Integer | 2 | | Count of 6x8 timber posts. | 1 | PostsTimber8x8 | PostsTimber8x8 | Integer | 2 | | Count of 8x8 timber posts. | 1 | PostsIBeam | PostsIBeam | Integer | 2 | | Count of steel I-beam posts. | 1 | PostsWideFlange | PostsWideFlange | Integer | 2 | | Count of wide flange posts. | 1 | PostsConcrete8D | PostsConcrete8D | Integer | 2 | | Count of 8" diameter concrete posts. | 1 | PostsConcrete8x8 | PostsConcrete8x8 | Integer | 2 | | Count of 8"x8" concrete posts. | 1 | PostsOther | PostsOther | Integer | 2 | | Count of other post. | 1 | HazardDist | HazardDist | Integer | 2 | | Approximate distance to the nearest hazard, in feet. | 1 | HazardDesc | HazardDesc | String | 100 | | Text description of the hazard. | 1 | LastInspDate | LastInspDate | Date | 36 | | Date of the last inspection. | 1 | FlaredAway | FlaredAway | String | 1 | N | No
| X | U | Unknown | X | Y | Yes | X | | Indicates whether the near end of the barrier, given the direction of travel, flares away from the roadway. | 1 | RailType | RailType | String | 8 | BANDRAIL | Band rail | X | BOXBEAM | Box beam | X | CABLE | Cable
| X | CHAINLINK | Chain link | X | JERSEY | Jersey barrier | X | NONE | None | X | PARAPET | Parapet
| X | ROCKWALL | Rock wall | X | SCOLLINS | Steel collins | X | THRIEBM | Thrie beam | X | TEXAS | Texas barrier | X | UNKNOWN | Unknown | X | WBEAM | W beam | X | WBEAMT31 | W beam T31 | X | WBFLAIR | W beam with flared edge
| X | WOOD | Wood | X | | Roadside barrier design. | 1 | Reflectors | Reflectors | String | 1 | N | No | X | U | Unknown | X | Y | Yes | X | | Indicates if reflectors are present. | 1 | NearEndTreatment | NearEndTreatment | String | 8 | ABSORB | Energy Absorbing - Other | X | ATTACHED | Attached to Structure - Other | X | BCT | BCT | X | BURIED | Buried in Ground | X | ENDSHOE | End Shoe | X | ENDWING | Endwing | X | ET2000 | ET-2000 | X | ET2000+ | ET-2000 Plus | X | FLEAT350 | FLEAT 350 | X | NONE | None | X | OREGON | Oregon alternate | X | SKT350 | SKT 350 | X | SRT350 | SRT 350 | X | UNKNOWN | Unknown | X | 3/4WRAP | 3/4 Wrap | X | | Identifies the end-treatment on the leading end of the barrier in the direction of adjacent traffic. | 1 | FarEndTreatment | FarEndTreatment | String | 8 | ABSORB | Energy Absorbing - Other | X | ATTACHED | Attached to Structure - Other | X | BCT | BCT | X | BURIED | Buried in Ground | X | ENDSHOE | End Shoe | X | ENDWING | Endwing | X | ET2000 | ET-2000 | X | ET2000+ | ET-2000 Plus | X | FLEAT350 | FLEAT 350 | X | NONE | None | X | OREGON | Oregon Alternate | X | SKT350 | SKT 350 | X | SRT350 | SRT 350 | X | UNKNOWN | Unknown | X | 3/4WRAP | 3/4 Wrap | X | | Identifies the end-treatment on the trailing end of the barrier in the direction of adjacent traffic. | 1 | Blockouts | Blockouts | String | 1 | N | No | X | U | Unknown | X | Y | Yes | X | | Indicates if blockouts are present. | 1 | PostsSpacing | PostsSpacing | String | 15 | UNKNOWN | Unknown | X | 12FTCENT | 12ft center | X | 3FTCENT | 3ft center | X | 6FTCENT | 6ft center | X | | Standard post spacing is 3’, 6’ or 12’ measured center to center. Guardrail has slots for bolts at these intervals. If holes have been drilled into rail at different intervals that could indicate non-standard spacing. | 1 | HazardType | HazardType | String | 8 | DITCH | Ditch | X | NONE | No other hazard | X | ROCK | Rock | X | STRUCT | Structure | X | TREES | Trees | X | UTILITY | Utility | X | WATER | Water | X | | Hazard present behind the barrier, if there is a hazard other than slope. | 1 | Slope | Slope | String | 8 | FLAT | Flat
| X | MODDOWN | Moderate - down | X | MODUP | Moderate - up | X | STPDOWN | Steep - down | X | STPUP | Steep - up | X | | Slope of the terrain behind the barrier. |