20221001 15080200 1.0 FALSE StreetSigns 002 StreetSigns__ATTACHREL Relationship SupportPoleToSigns Relationship 20211116 14364600 20211116 14364600 150000000 5000 ItemDescription Version 6.2 (Build 9200) ; Esri ArcGIS 10.4.1.5686 Street Signs street signs signs road signs signage traffic Allen Tx This table contains street signs that are related to poles, traffic signals, etc <DIV STYLE="text-align:Left;"><DIV><DIV>This table was developed from a point collection project performed by Halff Associates in 2019. It is in a one to many relationship with the TrafficSupportPole feature class. The foreign key field within this table is 'Post ID' and this relates to the primary key field called 'CW ID' in the TrafficSupportPole feature class.This table contains MUTCD Category subtypes.<OL><LI>Regulatory Sign</LI><LI>Warning Sign</LI><LI>Guide Sign</LI><LI>General Information Sign</LI><LI>Recreational & Cultural Sign</LI><LI>School Sign</LI><LI>Customized Sign</LI><LI>Other</LI></OL>The table contains information about each sign such as dimensions, support type, install date, condition, facing direction, and location information. As well as a URL field to display photo attachments.</DIV></DIV></DIV> City of Allen Tx Table dataset StreetSigns Table 16292 OBJECTID OBJECTID OID 4 10 0 Internal feature number. Esri Sequential unique whole numbers that are automatically generated. CWID CW ID String 20 0 0 POSTID Post ID String 20 0 0 MUTCD_Cat MUTCD Category SmallInteger 2 5 0 MUTCD_Desc MUTCD Description String 100 0 0 MUTCD_Code MUTCD Code String 80 0 0 Dimensions Dimensions String 50 0 0 MaintainedBy MaintainedBy String 50 0 0 SupportType Support Type String 50 0 0 InstallDate Install Date Date 8 0 0 InspectDate Inspection Date Date 8 0 0 InspectedBy Inspected By String 50 0 0 Condition Condition String 50 0 0 FacingDirection Facing Direction String 5 0 0 Block Block String 50 0 0 Street Street String 80 0 0 CrossStreet Cross Street String 80 0 0 SignText Sign Text String 255 0 0 ElectricComponents Electric Components String 5 0 0 SpeedLimit Speed Limit SmallInteger 2 5 0 Hours Hours String 50 0 0 Angle Angle SmallInteger 2 5 0 LifecycleStatus Lifecycle Status String 50 0 0 Comments Comments String 500 0 0 Flag Flag SmallInteger 2 5 0 ImageName Image Name String 100 0 0 URL URL String 500 0 0 created_user Creator String 50 0 0 created_date Creation Date Date 8 0 0 last_edited_user Last Editor String 50 0 0 last_edited_date Last Edited Date Date 8 0 0 Regulatory Sign 1 MUTCD_Desc MUTCDRegulatorySignDescription This domain is used for the MUTCD description field. R1-1 = Stop Coded Value Default value Default value GIS String MUTCD_Code MUTCDRegulatorySignCode This domain is used for the MUTCD code field. Stop = R1-1 Coded Value Default value Default value GIS String MaintainedBy TrafficMaintainedBy Contains responsible parties for maintenance of traffic signs and assets Coded Value Default value Default value GIS String SupportType SupportType Indicates the support type for Traffic signs or the type of pole Coded Value Default value Default value GIS String FacingDirection Direction Indicates the direction an asset faces. Originally created for traffic signs Coded Value Default value Default value GIS String SpeedLimit SpeedLimit A numeric speed limit domain created for the Traffic signs Coded Value Default value Default value GIS SmallInteger Warning Sign 2 MUTCD_Desc MUTCDWarningSignDescription This domain is used for the MUTCD description field. W1-1,2,3,4,5 = Horizontal Alignment Coded Value Default value Default value GIS String MUTCD_Code MUTCDWarningSignCode This domain is used for the MUTCD code field. Horizontal Alignment = W1-1,2,3,4,5 Coded Value Default value Default value GIS String MaintainedBy TrafficMaintainedBy Contains responsible parties for maintenance of traffic signs and assets Coded Value Default value Default value GIS String SupportType SupportType Indicates the support type for Traffic signs or the type of pole Coded Value Default value Default value GIS String FacingDirection Direction Indicates the direction an asset faces. Originally created for traffic signs Coded Value Default value Default value GIS String SpeedLimit SpeedLimit A numeric speed limit domain created for the Traffic signs Coded Value Default value Default value GIS SmallInteger Guide Sign 3 MUTCD_Desc MUTCDGuideSignDescription This domain is used for the MUTCD description field. M1-1 = Interstate Route Sign Coded Value Default value Default value GIS String MUTCD_Code MUTCDGuideSignCode This domain is used for the MUTCD code field. Interstate Route Sign = M1-1 Coded Value Default value Default value GIS String MaintainedBy TrafficMaintainedBy Contains responsible parties for maintenance of traffic signs and assets Coded Value Default value Default value GIS String SupportType SupportType Indicates the support type for Traffic signs or the type of pole Coded Value Default value Default value GIS String FacingDirection Direction Indicates the direction an asset faces. Originally created for traffic signs Coded Value Default value Default value GIS String SpeedLimit SpeedLimit A numeric speed limit domain created for the Traffic signs Coded Value Default value Default value GIS SmallInteger General Information Sign 4 MUTCD_Desc MUTCDGeneralSignDescription This domain is used for the MUTCD description field. I-8 = Library Coded Value Default value Default value GIS String MUTCD_Code MUTCDGeneralSignCode This domain is used for the MUTCD code field. Library = I-8 Coded Value Default value Default value GIS String MaintainedBy TrafficMaintainedBy Contains responsible parties for maintenance of traffic signs and assets Coded Value Default value Default value GIS String SupportType SupportType Indicates the support type for Traffic signs or the type of pole Coded Value Default value Default value GIS String FacingDirection Direction Indicates the direction an asset faces. Originally created for traffic signs Coded Value Default value Default value GIS String SpeedLimit SpeedLimit A numeric speed limit domain created for the Traffic signs Coded Value Default value Default value GIS SmallInteger Recreational & Cultural Sign 5 MUTCD_Desc MUTCDRecreationSignDescription This domain is used for the MUTCD description field. D7-7aT = Historical Marker Coded Value Default value Default value GIS String MUTCD_Code MUTCDRecreationSignCode This domain is used for the MUTCD code field. Historical Marker = D7-7aT Coded Value Default value Default value GIS String MaintainedBy TrafficMaintainedBy Contains responsible parties for maintenance of traffic signs and assets Coded Value Default value Default value GIS String SupportType SupportType Indicates the support type for Traffic signs or the type of pole Coded Value Default value Default value GIS String FacingDirection Direction Indicates the direction an asset faces. Originally created for traffic signs Coded Value Default value Default value GIS String SpeedLimit SpeedLimit A numeric speed limit domain created for the Traffic signs Coded Value Default value Default value GIS SmallInteger School Sign 6 MUTCD_Desc MUTCDSchoolSignDescription This domain is used for the MUTCD description field. S1-1 = School Sign (walking) Coded Value Default value Default value GIS String MUTCD_Code MUTCDSchoolSignCode This domain is used for the MUTCD code field. School Sign (walking) = S1-1 Coded Value Default value Default value GIS String MaintainedBy TrafficMaintainedBy Contains responsible parties for maintenance of traffic signs and assets Coded Value Default value Default value GIS String SupportType SupportType Indicates the support type for Traffic signs or the type of pole Coded Value Default value Default value GIS String FacingDirection Direction Indicates the direction an asset faces. Originally created for traffic signs Coded Value Default value Default value GIS String SpeedLimit SpeedLimit A numeric speed limit domain created for the Traffic signs Coded Value Default value Default value GIS SmallInteger Customized Sign 7 MUTCD_Desc MUTCDCustomizedSignDescription This domain is used for the MUTCD description field. CS-1 = Way Finding Coded Value Default value Default value GIS String MUTCD_Code MUTCDCustomizedSignCode This domain is used for the MUTCD code field. Way Finding = CS-1 Coded Value Default value Default value GIS String MaintainedBy TrafficMaintainedBy Contains responsible parties for maintenance of traffic signs and assets Coded Value Default value Default value GIS String SupportType SupportType Indicates the support type for Traffic signs or the type of pole Coded Value Default value Default value GIS String FacingDirection Direction Indicates the direction an asset faces. Originally created for traffic signs Coded Value Default value Default value GIS String SpeedLimit SpeedLimit A numeric speed limit domain created for the Traffic signs Coded Value Default value Default value GIS SmallInteger Other 8 MUTCD_Desc MUTCDOtherSignDescription This domain is used for the MUTCD description field. R1-1 = Stop Coded Value Default value Default value GIS String MUTCD_Code MUTCDOtherSignCode This domain is used for the MUTCD code field. Stop = R1-1 Coded Value Default value Default value GIS String MaintainedBy TrafficMaintainedBy Contains responsible parties for maintenance of traffic signs and assets Coded Value Default value Default value GIS String SupportType SupportType Indicates the support type for Traffic signs or the type of pole Coded Value Default value Default value GIS String FacingDirection Direction Indicates the direction an asset faces. Originally created for traffic signs Coded Value Default value Default value GIS String SpeedLimit SpeedLimit A numeric speed limit domain created for the Traffic signs Coded Value Default value Default value GIS SmallInteger CWDescription CW Description String 500 0 0 GlobalID GlobalID GlobalID 38 0 0 EngineerGrid Engineering Grid # SmallInteger 2 5 0 20211116