Guides
Guides

Standardize TMC in NAVSTREETS

1. Add Field – ‘ROAD_DIR’ (text, length 1) 
    1. Field Calculator 
        1.LEFT( [TRAFFIC_CD],1)
        2.‘OK’
    2. Field Calculator – Standardize Road Direction 
        1. replace([ROAD_DIR], "-", "T")
        2. replace([ROAD_DIR], "+", "F")
    3.  Add Field – ‘TMC’ (text, length 9) 
        1. Field Calculator 
            1. right( [TRAFFIC_CD],9)
            2. ‘OK’
        2. Field Calculator (Standardized Positive/Negative Direction) 
            1. replace([TMC],"-","N")
            2. replace([TMC],"+","P")
Traffic tables