20181022 08421600 1.0 TRUE Sign 002 20181218 16211000 20212006 153NnS5800 Esri ArcGIS 10.6.1.9270 Sign Table dataset Sign Table 5818 OBJECTID OBJECTID OID 4 10 0 Internal feature number. Esri Sequential unique whole numbers that are automatically generated. GlobalID GlobalID GlobalID 38 0 0 FACILITYID Facility Identifier String 50 0 0 SIGNPOSTID Attachment ID String 50 0 0 SIGNTYPE Sign Type Integer 4 10 0 SIGNHEIGHT Sign Height String 20 0 0 SIGNWIDTH Sign Width String 20 0 0 SIGNCODE Sign Name String 255 0 0 SIGNTEXT Sign Text String 255 0 0 FACING Facing Direction String 20 0 0 SIGNCOLOUR Horizontal Clearance String 25 0 0 HORIZFROM Horizontal From String 12 0 0 VERTFROM Vertical From String 12 0 0 ANGLE Angle (Degrees) SmallInteger 2 5 0 DISTTOTOP Distance to Top of Pole Double 8 38 8 REFLCOAT Reflective Coating String 15 0 0 SHEETING Sheeting Type String 50 0 0 SUPMATERIAL Supplemental Materials String 30 0 0 INSTALLDATE Install Date Date 8 0 0 CONDITION Condition String 50 0 0 OWNEDBY Owned By SmallInteger 2 5 0 MAINTBY Managed By SmallInteger 2 5 0 ROTATION Rotation Double 8 38 8 LASTUPDATE Last Update Date Date 8 0 0 LASTEDITOR Last Editor String 50 0 0 ACQU_TECH Acquisition Technique SmallInteger 2 5 0 ACCURACY_M Planimetric Accuracy (m) Double 8 38 8 SCALE_LRG Largest Scale Integer 4 10 0 SCALE_SM Smallest Scale Integer 4 10 0 created_user created_user String 255 0 0 created_date created_date Date 8 0 0 last_edited_user last_edited_user String 255 0 0 last_edited_date last_edited_date Date 8 0 0 ID_NUM ID_NUM Integer 4 10 0 ID_TEXT ID_TEXT String 50 0 0 FACILITYID_OLD FACILITYID_OLD String 20 0 0 REGULATORY 0 SIGNCODE RegulatoryCode The regulatory signs Coded Value Default value Default value SDE String FACING Direction Names used for directional attributes. Coded Value Default value Default value SDE String SIGNCOLOUR SignColour Colour of the sign Coded Value Default value Duplicate SDE String ANGLE 0 SHEETING SignSheetType The type of sheeting used on the sign Coded Value Default value Default value SDE String CONDITION SignCondition The condition of the sign asset Coded Value Default value Duplicate SDE String OWNEDBY AssetOwner The owner of the asset Coded Value Default value Default value SDE SmallInteger MAINTBY AssetManager The manager of the asset Coded Value Default value Default value SDE SmallInteger ACQU_TECH AcquisitionTechnique The Type of data source or technique used to populate (create or revise) the dataset. Coded Value Default value Duplicate SDE SmallInteger SCALE_LRG Scale List of arbitrary scales. Coded Value Default value Duplicate SDE Integer SCALE_SM Scale List of arbitrary scales. Coded Value Default value Duplicate SDE Integer WARNING 1 SIGNCODE WarningCode Codes for Warning Signs Coded Value Default value Default value SDE String FACING Direction Names used for directional attributes. Coded Value Default value Default value SDE String SIGNCOLOUR SignColour Colour of the sign Coded Value Default value Duplicate SDE String ANGLE 0 SHEETING SignSheetType The type of sheeting used on the sign Coded Value Default value Default value SDE String CONDITION SignCondition The condition of the sign asset Coded Value Default value Duplicate SDE String OWNEDBY AssetOwner The owner of the asset Coded Value Default value Default value SDE SmallInteger MAINTBY AssetManager The manager of the asset Coded Value Default value Default value SDE SmallInteger ACQU_TECH AcquisitionTechnique The Type of data source or technique used to populate (create or revise) the dataset. Coded Value Default value Duplicate SDE SmallInteger SCALE_LRG Scale List of arbitrary scales. Coded Value Default value Duplicate SDE Integer SCALE_SM Scale List of arbitrary scales. Coded Value Default value Duplicate SDE Integer INFORMATION 2 SIGNCODE InformationCode Codes for Information Signs Coded Value Default value Default value SDE String FACING Direction Names used for directional attributes. Coded Value Default value Default value SDE String SIGNCOLOUR SignColour Colour of the sign Coded Value Default value Duplicate SDE String ANGLE 0 SHEETING SignSheetType The type of sheeting used on the sign Coded Value Default value Default value SDE String CONDITION SignCondition The condition of the sign asset Coded Value Default value Duplicate SDE String OWNEDBY AssetOwner The owner of the asset Coded Value Default value Default value SDE SmallInteger MAINTBY AssetManager The manager of the asset Coded Value Default value Default value SDE SmallInteger ACQU_TECH AcquisitionTechnique The Type of data source or technique used to populate (create or revise) the dataset. Coded Value Default value Duplicate SDE SmallInteger SCALE_LRG Scale List of arbitrary scales. Coded Value Default value Duplicate SDE Integer SCALE_SM Scale List of arbitrary scales. Coded Value Default value Duplicate SDE Integer CUSTOM 3 SIGNCODE CustomCode Codes for Custom SignsDescription Coded Value Default value Default value SDE String FACING Direction Names used for directional attributes. Coded Value Default value Default value SDE String SIGNCOLOUR SignColour Colour of the sign Coded Value Default value Duplicate SDE String ANGLE 0 SHEETING SignSheetType The type of sheeting used on the sign Coded Value Default value Default value SDE String CONDITION SignCondition The condition of the sign asset Coded Value Default value Duplicate SDE String OWNEDBY AssetOwner The owner of the asset Coded Value Default value Default value SDE SmallInteger MAINTBY AssetManager The manager of the asset Coded Value Default value Default value SDE SmallInteger ACQU_TECH AcquisitionTechnique The Type of data source or technique used to populate (create or revise) the dataset. Coded Value Default value Duplicate SDE SmallInteger SCALE_LRG Scale List of arbitrary scales. Coded Value Default value Duplicate SDE Integer SCALE_SM Scale List of arbitrary scales. Coded Value Default value Duplicate SDE Integer 20181218