ASSET TYPE CLASSIFICATION
Export Excel Spreadsheet
ENGINEERING ATTRIBUTES TABLE
|
UNIT OF MEASURE
|
DATA TYPE
|
DOMAIN ID
|
| ANTI GRAFFITI COATING |
SGPN_07 |
N/A |
ALN |
_YESNO |
| AREA |
SGPN_21 |
N/A |
ALN |
_AREA |
| BACKGROUND RETRO |
SGPN_05 |
N/A |
NUM |
|
| BLUE RETRO |
SGPN_03 |
N/A |
NUM |
|
| COMMENTS |
SGPN_19 |
N/A |
ALN |
|
| DRAWING NUMBER |
SGPN_28 |
N/A |
ALN |
|
| HEIGHT |
SGPN_08 |
IN |
NUM |
|
| ILLUMINATION |
SGPN_25 |
N/A |
ALN |
_YESNO |
| LATITUDE |
SGPN_31 |
DEG |
NUM |
|
| LEGEND RETRO |
SGPN_06 |
N/A |
NUM |
|
| LEVEL |
SGPN_24 |
N/A |
ALN |
_LEVEL |
| LIGHT |
SGPN_13 |
N/A |
ALN |
_YESNO |
| LONGITUDE |
SGPN_30 |
DEG |
NUM |
|
| MUTCD CODE |
SGPN_23 |
N/A |
ALN |
|
| NUMBER OF SUPPORTS |
SGPN_12 |
N/A |
ALN |
|
| RED RETRO |
SGPN_04 |
N/A |
NUM |
|
| SERVICE LIFE |
SGPN_01 |
N/A |
ALN |
|
| SHEETING TYPE |
SGPN_02 |
N/A |
ALN |
_SHEGTYPE |
| SIGN CLASS |
SGPN_18 |
N/A |
ALN |
_SIGNCLAS |
| SIGN DESCRIPTION |
SGPN_22 |
N/A |
ALN |
|
| SIGN LOCATION |
SGPN_27 |
N/A |
ALN |
_SIGNLOC |
| SIGN MATERIAL |
SGPN_17 |
N/A |
ALN |
_SIGNMATL |
| SIGN PANEL ORIENTATION |
SGPN_16 |
N/A |
ALN |
_ORIENTATION |
| SIGN PANEL TYPE |
SGPN_15 |
N/A |
ALN |
_SIGNPANLTYPE |
| SIGN SUPPORT MATERIAL |
SGPN_11 |
N/A |
ALN |
_SIGNSUPTMATL |
| SIGN SUPPORT TYPE |
SGPN_10 |
N/A |
ALN |
_SIGNSUPTTYPE |
| SIGN TEXT |
SGPN_20 |
N/A |
ALN |
|
| SURVEY DATE |
SGPN_29 |
N/A |
ALN |
|
| VERTICAL CLEARANCE |
SGPN_14 |
FT |
NUM |
|
| WARRANTY PERIOD |
SGPN_26 |
YR |
NUM |
_WARRANTYPE |
| WIDTH |
SGPN_09 |
IN |
NUM |
|
ASSET SUB TYPE AND ATTRIBUTES TABLE
|
SIGN PANEL |
| ANTI GRAFFITI COATING |
|
| AREA |
|
| BACKGROUND RETRO |
|
| BLUE RETRO |
|
| COMMENTS |
|
| DRAWING NUMBER |
|
| HEIGHT |
|
| ILLUMINATION |
|
| LATITUDE |
|
| LEGEND RETRO |
|
| LEVEL |
|
| LIGHT |
|
| LONGITUDE |
|
| MUTCD CODE |
|
| NUMBER OF SUPPORTS |
|
| RED RETRO |
|
| SERVICE LIFE |
|
| SHEETING TYPE |
|
| SIGN CLASS |
|
| SIGN DESCRIPTION |
|
| SIGN LOCATION |
|
| SIGN MATERIAL |
|
| SIGN PANEL ORIENTATION |
|
| SIGN PANEL TYPE |
|
| SIGN SUPPORT MATERIAL |
|
| SIGN SUPPORT TYPE |
|
| SIGN TEXT |
|
| SURVEY DATE |
|
| VERTICAL CLEARANCE |
|
| WARRANTY PERIOD |
|
| WIDTH |
|
RELATED FUNCTIONAL ASSET CLASSIFICATION
| SIGN PANEL |
DIST91C-SGPNDIST91C-SPRT-SGPNFUNCT16A-SGPNFUNCT16B-SGPN |
PROBLEMS, CAUSES, & REMEDIES
UPDATES LOG
|
Operation Type
|
Type of Change
|
Old Value
|
New Value
|
Update Recorded (EST)
|
|---|
| Edit |
Description |
|
A FLAT, TYPICALLY RECTANGULAR COMPONENT OF A SIGN THAT DISPLAYS INFORMATION |
7/17/2024 4:10:02 PM |
| Edit |
Service Life |
|
10 YEARS |
7/17/2024 4:10:02 PM |
| Edit |
Equipment Utilization |
|
N/A |
7/17/2024 4:10:02 PM |
| Delete |
ADS CODE |
FUNCT16B-SPRT-SGPN |
|
7/8/2024 10:00:10 PM |
| Edit |
ADS CODE |
BLDG16B-SPRT-SGPN |
FUNCT16B-SPRT-SGPN |
7/8/2024 10:00:10 PM |
| Delete |
ADS CODE |
FUNCT16A-SPRT-SGPN |
|
7/8/2024 9:57:38 PM |
| Edit |
ADS CODE |
BLDG16A-SPRT-SGPN |
FUNCT16A-SPRT-SGPN |
7/8/2024 9:57:38 PM |
| Edit |
Unit of measure (VERTICAL CLEARANCE(SGPN_14)) |
IN |
FT |
12/14/2022 2:53:33 PM |
| Edit |
Generate Description |
False |
True |
6/27/2022 9:18:21 PM |
| Create |
Field Change |
|
LATITUDE(SGPN_31) |
1/14/2022 10:11:37 AM |
| Create |
Field Change |
|
LONGITUDE(SGPN_30) |
1/14/2022 10:09:27 AM |
| Edit |
Field Change |
SIGN MAT(SGPN_17) |
SIGN MATERIAL(SGPN_17) |
12/17/2021 11:28:16 AM |
| Create |
Field Change |
|
SIGN MAT(SGPN_17) |
10/1/2021 5:55:51 PM |
| Create |
Field Change |
|
SIGN PANEL ORIENTATION(SGPN_16) |
10/1/2021 5:55:51 PM |
| Create |
Field Change |
|
SIGN PANEL TYPE(SGPN_15) |
10/1/2021 5:55:51 PM |
| Create |
Field Change |
|
SIGN SUPPORT MATERIAL(SGPN_11) |
10/1/2021 5:55:51 PM |
| Create |
Field Change |
|
SIGN SUPPORT TYPE(SGPN_10) |
10/1/2021 5:55:51 PM |
| Create |
Field Change |
|
SIGN TEXT(SGPN_20) |
10/1/2021 5:55:51 PM |
| Create |
Field Change |
|
SURVEY DATE(SGPN_29) |
10/1/2021 5:55:51 PM |
| Create |
Field Change |
|
VERTICAL CLEARANCE(SGPN_14) |
10/1/2021 5:55:51 PM |
| Create |
Field Change |
|
WARRANTY PERIOD(SGPN_26) |
10/1/2021 5:55:51 PM |
| Create |
Field Change |
|
WIDTH(SGPN_09) |
10/1/2021 5:55:51 PM |
| Create |
Field Change |
|
SIGN LOCATION(SGPN_27) |
10/1/2021 5:55:51 PM |
| Create |
Field Change |
|
SIGN DESCRIPTION(SGPN_22) |
10/1/2021 5:55:51 PM |
| Create |
Field Change |
|
SHEETING TYPE(SGPN_02) |
10/1/2021 5:55:51 PM |
| Create |
Field Change |
|
ANTI GRAFFITI COATING(SGPN_07) |
10/1/2021 5:55:51 PM |
| Create |
Field Change |
|
AREA(SGPN_21) |
10/1/2021 5:55:51 PM |
| Create |
Field Change |
|
BACKGROUND RETRO(SGPN_05) |
10/1/2021 5:55:51 PM |
| Create |
Field Change |
|
BLUE RETRO(SGPN_03) |
10/1/2021 5:55:51 PM |
| Create |
Field Change |
|
COMMENTS(SGPN_19) |
10/1/2021 5:55:51 PM |
| Create |
Field Change |
|
DRAWING NUMBER(SGPN_28) |
10/1/2021 5:55:51 PM |
| Create |
Field Change |
|
HEIGHT(SGPN_08) |
10/1/2021 5:55:51 PM |
| Create |
Field Change |
|
ILLUMINATION(SGPN_25) |
10/1/2021 5:55:51 PM |
| Create |
Field Change |
|
LEGEND RETRO(SGPN_06) |
10/1/2021 5:55:51 PM |
| Create |
Field Change |
|
LEVEL(SGPN_24) |
10/1/2021 5:55:51 PM |
| Create |
Field Change |
|
LIGHT(SGPN_13) |
10/1/2021 5:55:51 PM |
| Create |
Field Change |
|
MUTCD CODE(SGPN_23) |
10/1/2021 5:55:51 PM |
| Create |
Field Change |
|
NUMBER OF SUPPORTS(SGPN_12) |
10/1/2021 5:55:51 PM |
| Create |
Field Change |
|
RED RETRO(SGPN_04) |
10/1/2021 5:55:51 PM |
| Create |
Field Change |
|
SERVICE LIFE(SGPN_01) |
10/1/2021 5:55:51 PM |