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 IN |
SGPN_08 |
IN |
NUM |
|
| ILLUMINATION |
SGPN_25 |
N/A |
ALN |
_YESNO |
| LATITUDE DEG |
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 DEG |
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 FT |
SGPN_14 |
FT |
NUM |
|
| WARRANTY PERIOD YR WARRANTYPE |
SGPN_26 |
YR |
NUM |
_WARRANTYPE |
| WIDTH IN |
SGPN_09 |
IN |
NUM |
|
ASSET SUB TYPE AND ATTRIBUTES TABLE
|
SIGN PANEL |
| ANTI GRAFFITI COATING |
|
| AREA |
|
| BACKGROUND RETRO |
|
| BLUE RETRO |
|
| COMMENTS |
|
| DRAWING NUMBER |
|
| HEIGHT IN |
|
| ILLUMINATION |
|
| LATITUDE DEG |
|
| LEGEND RETRO |
|
| LEVEL |
|
| LIGHT |
|
| LONGITUDE DEG |
|
| 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 FT |
|
| WARRANTY PERIOD YR WARRANTYPE |
|
| WIDTH IN |
|
RELATED FUNCTIONAL ASSET CLASSIFICATION
| DESTINATION ID SIGN |
FUNCT07L-DSGN |
| EXTERIOR SIGN (NOT COORDINATED) |
FUNCT07L-ESGN |
| SIGN PANEL |
FUNCT16A-SGPNFUNCT16B-SGPNFUNCT91A-SGPNFUNCT91B-SGPNFUNCT91C-SGPN |
PROBLEMS, CAUSES, & REMEDIES
UPDATES LOG
|
Operation Type
|
Type of Change
|
Old Value
|
New Value
|
Update Recorded (EST)
|
|---|
| Edit |
Field Change |
VERTICAL CLEARANCE(SGPN_14) |
VERTICAL CLEARANCE FT(SGPN_14) |
5/9/2025 12:27:10 PM |
| Edit |
Field Change |
WARRANTY PERIOD(SGPN_26) |
WARRANTY PERIOD YR WARRANTYPE(SGPN_26) |
5/9/2025 12:27:10 PM |
| Edit |
Field Change |
WIDTH(SGPN_09) |
WIDTH IN(SGPN_09) |
5/9/2025 12:27:10 PM |
| Edit |
Field Change |
HEIGHT(SGPN_08) |
HEIGHT IN(SGPN_08) |
5/9/2025 12:27:10 PM |
| Edit |
Field Change |
LONGITUDE(SGPN_30) |
LONGITUDE DEG(SGPN_30) |
5/9/2025 12:27:10 PM |
| Edit |
Field Change |
LATITUDE(SGPN_31) |
LATITUDE DEG(SGPN_31) |
5/9/2025 12:27:10 PM |
| Assign |
ADS CODE |
|
FUNCT91C-SGPN |
4/2/2025 1:38:11 PM |
| Assign |
ADS CODE |
|
FUNCT91B-SGPN |
4/2/2025 1:38:02 PM |
| Assign |
ADS CODE |
|
FUNCT91A-SGPN |
4/2/2025 1:37:53 PM |
| Assign |
ADS CODE |
|
FUNCT07L-ESGN |
4/1/2025 3:21:48 PM |
| Assign |
ADS CODE |
|
FUNCT07L-DSGN |
4/1/2025 2:39:32 PM |
| Delete |
ADS CODE |
DIST91C-SGPN |
|
12/9/2024 11:40:47 AM |
| Delete |
ADS CODE |
DIST91C-SPRT-SGPN |
|
12/9/2024 11:40:47 AM |
| 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 |
|
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 |
|
HEIGHT(SGPN_08) |
10/1/2021 5:55:51 PM |
| 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 |
|
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 |