Name: Traffic Signs

Display Field: ImageName

Type: Table

Geometry Type: N/A

Description:

Service Item Id: f11de3f569e245ddb93abdd1f977be59

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: MUTCD_Cat

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• CWID ( type: esriFieldTypeString, alias: CW ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CWID )
• POSTID ( type: esriFieldTypeString, alias: Post ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: POSTID )
• MUTCD_Cat ( type: esriFieldTypeSmallInteger, alias: MUTCD Category, editable: true, nullable: true, defaultValue: 1, modelName: MUTCD_Cat )
• MUTCD_Desc ( type: esriFieldTypeString, alias: MUTCD Description, editable: true, nullable: true, length: 100, defaultValue: null, modelName: MUTCD_Desc )
• MUTCD_Code ( type: esriFieldTypeString, alias: MUTCD Code, editable: true, nullable: true, length: 80, defaultValue: null, modelName: MUTCD_Code )
• Dimensions ( type: esriFieldTypeString, alias: Dimensions, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Dimensions )
• MaintainedBy ( type: esriFieldTypeString, alias: MaintainedBy, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MaintainedBy , Coded Values: [Allen: Allen] , [Allen PR: Allen Public & Media Relations (PAMRO)] , [Collin County: Collin County] , ...12 more... )
• SupportType ( type: esriFieldTypeString, alias: Support Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SupportType , Coded Values: [Pole: Pole] , [Traffic Signal: Traffic Signal] , [Flasher: Flasher] , ...3 more... )
• InstallDate ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallDate )
• InspectDate ( type: esriFieldTypeDate, alias: Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InspectDate )
• InspectedBy ( type: esriFieldTypeString, alias: Inspected By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: InspectedBy )
• Condition ( type: esriFieldTypeString, alias: Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Condition , Coded Values: [Excellent: Excellent] , [Good: Good] , [Fair: Fair] , ...2 more... )
• FacingDirection ( type: esriFieldTypeString, alias: Facing Direction, editable: true, nullable: true, length: 5, defaultValue: null, modelName: FacingDirection , Coded Values: [N: N] , [NE: NE] , [E: E] , ...5 more... )
• Block ( type: esriFieldTypeString, alias: Block, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Block )
• Street ( type: esriFieldTypeString, alias: Street, editable: true, nullable: true, length: 80, defaultValue: null, modelName: Street )
• CrossStreet ( type: esriFieldTypeString, alias: Cross Street, editable: true, nullable: true, length: 80, defaultValue: null, modelName: CrossStreet )
• SignText ( type: esriFieldTypeString, alias: Sign Text, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SignText )
• ElectricComponents ( type: esriFieldTypeString, alias: Electric Components, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ElectricComponents , Coded Values: [Yes: Yes] , [No: No] )
• SpeedLimit ( type: esriFieldTypeSmallInteger, alias: Speed Limit, editable: true, nullable: true, defaultValue: null, modelName: SpeedLimit )
• Hours ( type: esriFieldTypeString, alias: Hours, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Hours )
• Angle ( type: esriFieldTypeSmallInteger, alias: Angle, editable: true, nullable: true, defaultValue: null, modelName: Angle )
• LifecycleStatus ( type: esriFieldTypeString, alias: Lifecycle Status, editable: true, nullable: true, length: 50, defaultValue: Active, modelName: LifecycleStatus , Coded Values: [Active: Active] , [Future: Future] , [Removed: Removed] , ...3 more... )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 500, defaultValue: null, modelName: Comments )
• Flag ( type: esriFieldTypeSmallInteger, alias: Flag, editable: true, nullable: true, defaultValue: null, modelName: Flag )
• ImageName ( type: esriFieldTypeString, alias: Image Name, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ImageName )
• URL ( type: esriFieldTypeString, alias: URL, editable: true, nullable: true, length: 500, defaultValue: null, modelName: URL )
• created_user ( type: esriFieldTypeString, alias: Creator, editable: false, nullable: true, length: 50, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: Creation Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: Last Editor, editable: false, nullable: true, length: 50, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edited Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• CWDescription ( type: esriFieldTypeString, alias: CW Description, editable: true, nullable: true, length: 500, defaultValue: null, modelName: CWDescription )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• EngineerGrid ( type: esriFieldTypeSmallInteger, alias: Engineering Grid #, editable: true, nullable: true, defaultValue: null, modelName: EngineerGrid )

Types:

ID: 1
Name: Regulatory Sign
Domains:
• MUTCD_Desc:
  Coded Values: [R1-1: Stop] , [R1-2: Yield] , [R1-3P: All Way] , ...44 more...
• MUTCD_Code:
  Coded Values: [Stop: R1-1] , [Yield: R1-2] , [All Way: R1-3P] , ...44 more...
• MaintainedBy:
  Inherited
• SupportType:
  Inherited
• Condition:
  Inherited
• FacingDirection:
  Inherited
• ElectricComponents:
  Inherited
• SpeedLimit:
  Coded Values: [5: 5] , [10: 10] , [15: 15] , ...11 more...
• LifecycleStatus:
  Inherited
Templates:
• Name: Regulatory Sign
  Description:
  Prototype:
  EngineerGrid: null
  CWDescription: null
  CWID: null
  POSTID: null
  MUTCD_Cat: 1
  MUTCD_Desc: null
  MUTCD_Code: null
  Dimensions: null
  MaintainedBy: null
  SupportType: null
  InstallDate: null
  InspectDate: null
  InspectedBy: null
  Condition: null
  FacingDirection: null
  Block: null
  Street: null
  CrossStreet: null
  SignText: null
  ElectricComponents: null
  SpeedLimit: null
  Hours: null
  Angle: null
  LifecycleStatus: Active
  Comments: null
  Flag: null
  ImageName: null
  URL: null
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 2
Name: Warning Sign
Domains:
• MUTCD_Desc:
  Coded Values: [W1-1,2,3,4,5: Horizontal Alignment] , [W1-1a,2a: Combination Horizontal Alignment/Advisory Speed] , [W1-8: Chevron Alignment] , ...43 more...
• MUTCD_Code:
  Coded Values: [Horizontal Alignment: W1-1,2,3,4,5] , [Combination Horizontal Alignment/Advisory Speed: W1-1a,2a] , [Chevron Alignment: W1-8] , ...43 more...
• MaintainedBy:
  Inherited
• SupportType:
  Inherited
• Condition:
  Inherited
• FacingDirection:
  Inherited
• ElectricComponents:
  Inherited
• SpeedLimit:
  Coded Values: [5: 5] , [10: 10] , [15: 15] , ...11 more...
• LifecycleStatus:
  Inherited
Templates:
• Name: Warning Sign
  Description:
  Prototype:
  EngineerGrid: null
  CWDescription: null
  CWID: null
  POSTID: null
  MUTCD_Cat: 2
  MUTCD_Desc: null
  MUTCD_Code: null
  Dimensions: null
  MaintainedBy: null
  SupportType: null
  InstallDate: null
  InspectDate: null
  InspectedBy: null
  Condition: null
  FacingDirection: null
  Block: null
  Street: null
  CrossStreet: null
  SignText: null
  ElectricComponents: null
  SpeedLimit: null
  Hours: null
  Angle: null
  LifecycleStatus: Active
  Comments: null
  Flag: null
  ImageName: null
  URL: null
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 3
Name: Guide Sign
Domains:
• MUTCD_Desc:
  Coded Values: [M1-1: Interstate Route Sign] , [M1-4: U.S. Route Sign] , [M1-6T: State Route Sign] , ...15 more...
• MUTCD_Code:
  Coded Values: [Interstate Route Sign: M1-1] , [U.S. Route Sign: M1-4] , [State Route Sign: M1-6T] , ...15 more...
• MaintainedBy:
  Inherited
• SupportType:
  Inherited
• Condition:
  Inherited
• FacingDirection:
  Inherited
• ElectricComponents:
  Inherited
• SpeedLimit:
  Coded Values: [5: 5] , [10: 10] , [15: 15] , ...11 more...
• LifecycleStatus:
  Inherited
Templates:
• Name: Guide Sign
  Description:
  Prototype:
  EngineerGrid: null
  CWDescription: null
  CWID: null
  POSTID: null
  MUTCD_Cat: 3
  MUTCD_Desc: null
  MUTCD_Code: null
  Dimensions: null
  MaintainedBy: null
  SupportType: null
  InstallDate: null
  InspectDate: null
  InspectedBy: null
  Condition: null
  FacingDirection: null
  Block: null
  Street: null
  CrossStreet: null
  SignText: null
  ElectricComponents: null
  SpeedLimit: null
  Hours: null
  Angle: null
  LifecycleStatus: Active
  Comments: null
  Flag: null
  ImageName: null
  URL: null
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 4
Name: General Information Sign
Domains:
• MUTCD_Desc:
  Coded Values: [I-8: Library] , [D9-2: Hospital] , [D9-14: Police] , ...1 more...
• MUTCD_Code:
  Coded Values: [Library: I-8] , [Hospital: D9-2] , [Police: D9-14] , ...1 more...
• MaintainedBy:
  Inherited
• SupportType:
  Inherited
• Condition:
  Inherited
• FacingDirection:
  Inherited
• ElectricComponents:
  Inherited
• SpeedLimit:
  Coded Values: [5: 5] , [10: 10] , [15: 15] , ...11 more...
• LifecycleStatus:
  Inherited
Templates:
• Name: General Information Sign
  Description:
  Prototype:
  EngineerGrid: null
  CWDescription: null
  CWID: null
  POSTID: null
  MUTCD_Cat: 4
  MUTCD_Desc: null
  MUTCD_Code: null
  Dimensions: null
  MaintainedBy: null
  SupportType: null
  InstallDate: null
  InspectDate: null
  InspectedBy: null
  Condition: null
  FacingDirection: null
  Block: null
  Street: null
  CrossStreet: null
  SignText: null
  ElectricComponents: null
  SpeedLimit: null
  Hours: null
  Angle: null
  LifecycleStatus: Active
  Comments: null
  Flag: null
  ImageName: null
  URL: null
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 5
Name: Recreational & Cultural Sign
Domains:
• MUTCD_Desc:
  Coded Values: [D7-7aT: Historical Marker] , [RCx: Other] , [RS-034: Parking] , ...3 more...
• MUTCD_Code:
  Coded Values: [Historical Marker: D7-7aT] , [Other: RCx] , [Parking: RS-034] , ...3 more...
• MaintainedBy:
  Inherited
• SupportType:
  Inherited
• Condition:
  Inherited
• FacingDirection:
  Inherited
• ElectricComponents:
  Inherited
• SpeedLimit:
  Coded Values: [5: 5] , [10: 10] , [15: 15] , ...11 more...
• LifecycleStatus:
  Inherited
Templates:
• Name: Recreational & Cultural Sign
  Description:
  Prototype:
  EngineerGrid: null
  CWDescription: null
  CWID: null
  POSTID: null
  MUTCD_Cat: 5
  MUTCD_Desc: null
  MUTCD_Code: null
  Dimensions: null
  MaintainedBy: null
  SupportType: null
  InstallDate: null
  InspectDate: null
  InspectedBy: null
  Condition: null
  FacingDirection: null
  Block: null
  Street: null
  CrossStreet: null
  SignText: null
  ElectricComponents: null
  SpeedLimit: null
  Hours: null
  Angle: null
  LifecycleStatus: Active
  Comments: null
  Flag: null
  ImageName: null
  URL: null
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 6
Name: School Sign
Domains:
• MUTCD_Desc:
  Coded Values: [S1-1: School Sign (walking)] , [S4-3P: School (text)] , [S4-1P: Time Range] , ...9 more...
• MUTCD_Code:
  Coded Values: [School Sign (walking): S1-1] , [School (text): S4-3P] , [Time Range: S4-1P] , ...9 more...
• MaintainedBy:
  Inherited
• SupportType:
  Inherited
• Condition:
  Inherited
• FacingDirection:
  Inherited
• ElectricComponents:
  Inherited
• SpeedLimit:
  Coded Values: [5: 5] , [10: 10] , [15: 15] , ...11 more...
• LifecycleStatus:
  Inherited
Templates:
• Name: School Sign
  Description:
  Prototype:
  EngineerGrid: null
  CWDescription: null
  CWID: null
  POSTID: null
  MUTCD_Cat: 6
  MUTCD_Desc: null
  MUTCD_Code: null
  Dimensions: null
  MaintainedBy: null
  SupportType: null
  InstallDate: null
  InspectDate: null
  InspectedBy: null
  Condition: null
  FacingDirection: null
  Block: null
  Street: null
  CrossStreet: null
  SignText: null
  ElectricComponents: null
  SpeedLimit: null
  Hours: null
  Angle: null
  LifecycleStatus: Active
  Comments: null
  Flag: null
  ImageName: null
  URL: null
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 7
Name: Customized Sign
Domains:
• MUTCD_Desc:
  Coded Values: [CS-1: Way Finding] , [CS-2: Recognition] , [CS-3: Keep Allen Beautiful] , ...3 more...
• MUTCD_Code:
  Coded Values: [Way Finding: CS-1] , [Recognition: CS-2] , [Keep Allen Beautiful: CS-3] , ...3 more...
• MaintainedBy:
  Inherited
• SupportType:
  Inherited
• Condition:
  Inherited
• FacingDirection:
  Inherited
• ElectricComponents:
  Inherited
• SpeedLimit:
  Coded Values: [5: 5] , [10: 10] , [15: 15] , ...11 more...
• LifecycleStatus:
  Inherited
Templates:
• Name: Customized Sign
  Description:
  Prototype:
  EngineerGrid: null
  CWDescription: null
  CWID: null
  POSTID: null
  MUTCD_Cat: 7
  MUTCD_Desc: null
  MUTCD_Code: null
  Dimensions: null
  MaintainedBy: null
  SupportType: null
  InstallDate: null
  InspectDate: null
  InspectedBy: null
  Condition: null
  FacingDirection: null
  Block: null
  Street: null
  CrossStreet: null
  SignText: null
  ElectricComponents: null
  SpeedLimit: null
  Hours: null
  Angle: null
  LifecycleStatus: Active
  Comments: null
  Flag: null
  ImageName: null
  URL: null
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 8
Name: Other
Domains:
• MUTCD_Desc:
  Coded Values: [Xx: Other Sign]
• MUTCD_Code:
  Coded Values: [Other Sign: Xx]
• MaintainedBy:
  Inherited
• SupportType:
  Inherited
• Condition:
  Inherited
• FacingDirection:
  Inherited
• ElectricComponents:
  Inherited
• SpeedLimit:
  Coded Values: [5: 5] , [10: 10] , [15: 15] , ...11 more...
• LifecycleStatus:
  Inherited
Templates:
• Name: Other
  Description:
  Prototype:
  EngineerGrid: null
  CWDescription: null
  CWID: null
  POSTID: null
  MUTCD_Cat: 8
  MUTCD_Desc: null
  MUTCD_Code: null
  Dimensions: null
  MaintainedBy: null
  SupportType: null
  InstallDate: null
  InspectDate: null
  InspectedBy: null
  Condition: null
  FacingDirection: null
  Block: null
  Street: null
  CrossStreet: null
  SignText: null
  ElectricComponents: null
  SpeedLimit: null
  Hours: null
  Angle: null
  LifecycleStatus: Active
  Comments: null
  Flag: null
  ImageName: null
  URL: null
  
  Drawing Tool: esriFeatureEditToolNone

---

Relationships:

• StreetSignsToSupportPole (0) -- Related To: Traffic Support Pole (0)

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Query Related Records   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata