| pavement_mark_symbol_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. | 2 | Owner | Owner | String | 15 | | CLACKCO | ClackCo | X | | LAKEOSWEGO | LakeOswego | X | | METRO | Metro | X | | MULTCO | MultCo | X | | ODOT | ODOT | X | | ODOT/PDXTRANS | ODOT/PdxTrans | X | | PPL | PacPowerLight | X | | PDXDEVCOMM | PdxDevComm | X | | PDXENVSERV | PdxEnvServ | X | | PDXPARKS | PdxParks | X | | PDXWATER | PdxWater | X | | PGE | PGE | X | | PORTPORTLAND | PortPortland | X | | PDXTRANS | PdxTrans | X | | PRIVATE | Private | X | | PTLDMALL | Portland Mall Management Inc | X | | PDXBPS | Planning and Sustainability | X | | PDXSTCAR | Portland Street Car Inc | X | | PSU | Portland State University | X | | PPS | Portland Public Schools | X | | PDXBTS | PdxBTS | X | | RAILROAD | Railroad | X | | RR/PDXTRANS | RR/PdxTrans | X | | TRI-MET | Tri-Met | X | | TELCO | MiscTelecomCo | X | | UNKNOWN | Unknown | X | | USDOT | USDOT | X | | WASHCO | WashCo | X | | WILLAMTROLLYCON | WillamTrollyCon | X | | Owner of the asset. PdxTrans means the asset is owned by PBOT. | 3 | MaintResp | MaintResp | String | 15 | | CLACKCO | ClackCo | X | | LAKEOSWEGO | LakeOswego | X | | METRO | Metro | X | | MULTCO | MultCo | X | | ODOT | ODOT | X | | ODOT/PDXTRANS | ODOT/PDXTrans | X | | PPL | PacPowerLight | X | | PDXDEVCOMM | PdxDevComm | X | | PDXENVSERV | PdxEnvServ | X | | PDXPARKS | PdxParks | X | | PDXWATER | PdxWater | X | | PGE | PGE | X | | PORTPORTLAND | PortPortland | X | | PTLDMALL | Portland Mall Management Inc | X | | PDXBPS | Planning and Sustainability | X | | PDXSTCAR | Portland Street Car Inc | X | | PSU | Portland State University | X | | PDXTRANS | PdxTrans | X | | PRIVATE | Private | X | | PPS | Portland Public Schools | X | | RAILROAD | RailRoad | X | | RR/PDXTRANS | RR/PdxTrans | X | | TRI-MET | Tri-Met | X | | TRIMET/PDXTRANS | Tri-Met/PdxTrans | X | | TELCO | MiscTelecomCo | X | | UNKNOWN | Unknown | X | | USDOT | USDOT | X | | WASHCO | WashCo | X | | WILLAMTROLLYCON | WillamTrollyCon | X | | Maintainer of the asset. PdxTrans means that PBOT is responsible for maintaining the asset. | 4 | LocationID | LocationID | String | 15 | | Location in PBOT's location hierarchy system. | 5 | ImagePath | ImagePath | String | 255 | | Link to related diagram or photo, not typically used for pavement marking symbols. | 6 | SymbolType | SymbolType | Integer | 4 | | 3631 | Symbol | X | | 3632 | Word | X | | 3633 | Railroad Crossing | X | | 3634 | Bump | X | | Type of pavement marking symbol. | 7 | SymbolStyle | SymbolStyle | String | 8 | | 25 | 25 (mph) | X | | 30 | 30
| X | | AF | Arrow Forward | X | | AFS | Arrow Forward, Small | X | | AHDS | Ahead, Small | X | | AHED | Ahead | X | | AL | Arrow Left | X | | ALF | Arrow Left/Forward | X | | ALFR | Arrow Left/Forward/Right | X | | ALFS | Arrow Left/Forward, Small | X | | ALL | Arrow Left/Left | X | | ALR | Arrow Left/Right | X | | ALS | Arrow Left, Small | X | | AR | Arrow Right | X | | ARF | Arrow Right/Forward | X | | ARR | Arrow Right/Right | X | | ARS | Arrow Right, Small | X | | BB | Bicycle Blvd | X | | BBA | Bicycle Blvd Arrow | X | | BBB | Bicycle, Bike Box | X | | BCG | Bicycle Circle, Green | X | | BCWA | Bicycle Circle, White with one arrow | X | | BCY | Bicycle Circle, Yellow | X | | BIKE | Bike | X | | BIKS | Bikes | X | | BKSS | Bikes, Small | X | | BL | Bike Loop | X | | BLB | Bike Loop, Black Outline | X | | BP12 | Squares, 12 in | X | | BRL | Bike Rider, Large | X | | BRS | Bike Rider, Small | X | | BS | Bicycle, Sharrow | X | | BUMP | Bump | X | | BUS | Bus | X | | CS | Chevron, Sharrow | X | | CV14 | Chevron, 14 ft | X | | CV22 | Chevron, 22 ft | X | | CV6 | Chevron, 6 ft | X | | DC | Direct Current | X | | DL | Diamond, Large | X | | DS | Diamond, Small | X | | EV | Electric Vehicle | X | | FOR | For | X | | FORS | For, Small | X | | GRLY | Greeley | X | | HERE | Here | X | | HERS | Here, Small | X | | HOTL | Hotel | X | | LANE | Lane | X | | LDBR | Ladder Bar | X | | LIFT | Lift (on blue background) | X | | LOKS | Look, Small | X | | LRT | Light Rail Transit | X | | ON | On | X | | ONLY | Only | X | | PCW | Pedestrian Circle, White | X | | PCWA | Pedestrian Circle, White with two arrows | X | | PCY | Pedestrian Circle, Yellow | X | | PDSS | Peds, Small | X | | PEDL | Pedestrian, Large | X | | PEDS | Peds | X | | PFLG | Portland Flag | X | | RED | Red | X | | RHTS | Right, Small | X | | RRX | Railroad Crossing | X | | SCHL | School | X | | SIGL | Signal | X | | SLW | Slow | X | | SLWS | Slow, Small | X | | STOP | Stop | X | | STPS | Stop, Small | X | | T | T (Light Rail Transit) | X | | TDOM | Truncated Dome | X | | TO | To | X | | TRKS | Trucks | X | | TRNS | Turns, Small | X | | UNK | Unknown | X | | UNK | Unknown | X | | UNK | Unknown | X | | WAIT | Wait | X | | WTCH | Watch | X | | YELD | Yield | X | | ZONE | Zone | X | | ZONS | Zone, Small | X | | Style of pavement marking symbol. | 8 | Rotation | Rotation | Numeric | 8 | | Rotation of the symbol in degrees counter-clockwise from east (90 = North). | 9 | MSColor | MSColor | String | 8 | | BLK | Black | X | | BRRED | Brick Red | X | | GRN | Green | X | | WHT | White | X | | YEL | Yellow | X | | Pavement marking color. | 10 | Material | Material | String | 8 | | BRK | Brick | X | | BUT | Button | X | | CON | Concrete | X | | CPG | Cold Plastic, Glued | X | | CPI | Cold Plastic, Inlaid | X | | CTP | Cold Thermal Plastic | X | | EBP | Embedded Plastic | X | | GLU | Glue Down | X | | HPE | Hot Plastic, Extruded | X | | HPS | Hot Plastic, Sprayed | X | | PNT | Paint | X | | R1W | Reflector, 1-way | X | | R2W | Reflector, 2-way | X | | UNK | Unknown | X | | Pavement marking material. |