Name: Sign Table

Display Field: SignNum

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 31f0c47df2a94579b8dc9ce9f0fb7ab9

Copyright Text: null

Default Visibility: false

MaxRecordCount: 4000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: SIGN_CATEGORY

Fields:

• Rel_GlobalID ( type: esriFieldTypeGUID, alias: Related Global ID, length: 38 )
• SignNum ( type: esriFieldTypeString, alias: Sign Number, length: 50 )
• MUTCD ( type: esriFieldTypeString, alias: MUTCD Code, length: 50 )
• Width ( type: esriFieldTypeSmallInteger, alias: Sign Width )
• Height ( type: esriFieldTypeSmallInteger, alias: Sign Height )
• FaceMat ( type: esriFieldTypeSmallInteger, alias: Face Material , Coded Values: [1: Engineer Grade] , [2: High Intensity Prismatic] , [3: Diamond Grade Cube] , ...2 more... )
• BlnkMat ( type: esriFieldTypeSmallInteger, alias: Blank Material , Coded Values: [1: Aluminum] , [2: Fiberglass] , [3: Plywood] , ...4 more... )
• Legend ( type: esriFieldTypeString, alias: Sign Legend, length: 100 )
• DirOfFace ( type: esriFieldTypeSmallInteger, alias: Direction of Face , Coded Values: [1: North] , [2: Northeast] , [3: East] , ...7 more... )
• Leds ( type: esriFieldTypeSmallInteger, alias: LEDs , Coded Values: [0: False] , [1: True] , [3: Not Checked] )
• RotSym ( type: esriFieldTypeDouble, alias: Symbol Rotation )
• InstallDate ( type: esriFieldTypeDate, alias: Installed Date, length: 8 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 100 )
• WONumber ( type: esriFieldTypeString, alias: Work Order Number, length: 12 )
• WOAction ( type: esriFieldTypeSmallInteger, alias: Work Order Action , Coded Values: [1: Vandalized] , [2: Poor Reflectivity] , [3: Damaged] , ...5 more... )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• CMT_Latitude ( type: esriFieldTypeDouble, alias: Latitude )
• CMT_Longitude ( type: esriFieldTypeDouble, alias: Longitude )
• CMT_Map_Label ( type: esriFieldTypeString, alias: CMT Map Label, length: 255 )
• CMT_Map_Style1 ( type: esriFieldTypeString, alias: CMT Map Style 1, length: 255 )
• CMT_Map_Style2 ( type: esriFieldTypeString, alias: CMT Map Style 2, length: 255 )
• CMT_Map_Style3 ( type: esriFieldTypeString, alias: CMT Map Style 3, length: 255 )
• CMT_Data_Key ( type: esriFieldTypeString, alias: CMT Data Key, length: 255 )
• CMT_Job_Number ( type: esriFieldTypeInteger, alias: Job Number )
• isActive ( type: esriFieldTypeSmallInteger, alias: CMT Is Active )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• SIGN_CATEGORY ( type: esriFieldTypeSmallInteger, alias: SIGN_CATEGORY , Coded Values: [1: Regulatory] , [2: Warning] , [3: Directional] , ...11 more... )

Types:

ID: 1
Name: Regulator
Domains:
• MUTCD:
  Coded Values: [Unknown: Unknown] , [R1-1: R1-1 Stop] , [R1-2: R1-2 Yield] , ...482 more...
• FaceMat:
  Inherited
• BlnkMat:
  Inherited
• DirOfFace:
  Inherited
• Leds:
  Inherited
• WOAction:
  Inherited

---

ID: 2
Name: Warning
Domains:
• MUTCD:
  Coded Values: [Unknown: Unknown] , [W1-1L: W1-1L Horizontal Alignment] , [W1-1R: W1-1R Horizontal Alignment] , ...360 more...
• FaceMat:
  Inherited
• BlnkMat:
  Inherited
• DirOfFace:
  Inherited
• Leds:
  Inherited
• WOAction:
  Inherited

---

ID: 3
Name: Directional
Domains:
• MUTCD:
  Coded Values: [Unknown: Unknown] , [D1-H1: D1-H1 Destination (1 line)] , [D1-H1a: D1-H1a Destination and Distance (1 line)] , ...229 more...
• FaceMat:
  Inherited
• BlnkMat:
  Inherited
• DirOfFace:
  Inherited
• Leds:
  Inherited
• WOAction:
  Inherited

---

ID: 4
Name: Information
Domains:
• MUTCD:
  Coded Values: [Unknown: Unknown] , [I-2: I-2 Ohio State Line] , [I-H2: I-H2 Welcome to Ohio] , ...32 more...
• FaceMat:
  Inherited
• BlnkMat:
  Inherited
• DirOfFace:
  Inherited
• Leds:
  Inherited
• WOAction:
  Inherited

---

ID: 5
Name: Logos
Domains:
• MUTCD:
  Coded Values: [Unknown: Unknown] , [E9-H1: E9-H1 Logo Mainline Signing (One service-6 panels)] , [E9-H1a: E9-H1a Logo Mainline; 1 service; 6 panel; 2x3] , ...29 more...
• FaceMat:
  Inherited
• BlnkMat:
  Inherited
• DirOfFace:
  Inherited
• Leds:
  Inherited
• WOAction:
  Inherited

---

ID: 6
Name: Markers
Domains:
• MUTCD:
  Coded Values: [Unknown: Unknown] , [M1-1: M1-1 Interstate Route Sign] , [M1-2: M1-2 Off-Interstate Route Sign (Loop)] , ...97 more...
• FaceMat:
  Inherited
• BlnkMat:
  Inherited
• DirOfFace:
  Inherited
• Leds:
  Inherited
• WOAction:
  Inherited

---

ID: 7
Name: Miscellaneous (Guide)
Domains:
• MUTCD:
  Coded Values: [Unknown: Unknown] , [Fully Designable: Fully Designable] , [E1-5aP: E1-5aP Left (plaque)] , ...47 more...
• FaceMat:
  Inherited
• BlnkMat:
  Inherited
• DirOfFace:
  Inherited
• Leds:
  Inherited
• WOAction:
  Inherited

---

ID: 8
Name: Recreational & Cultural
Domains:
• MUTCD:
  Coded Values: [Unknown: Unknown] , [RS-002: RS-002 Smoking] , [RS-005: RS-005 Tunnel] , ...120 more...
• FaceMat:
  Inherited
• BlnkMat:
  Inherited
• DirOfFace:
  Inherited
• Leds:
  Inherited
• WOAction:
  Inherited

---

ID: 9
Name: TODS
Domains:
• MUTCD:
  Coded Values: [Unknown: Unknown] , [D9-H50: D9-H50 TODS Business Panel] , [D9-H51: D9-H51 TODS TOURIST ACTIVITIES] , ...5 more...
• FaceMat:
  Inherited
• BlnkMat:
  Inherited
• DirOfFace:
  Inherited
• Leds:
  Inherited
• WOAction:
  Inherited

---

ID: 10
Name: Emergency Management
Domains:
• MUTCD:
  Coded Values: [Unknown: Unknown] , [EM-1: EM-1 Evacuation Route] , [EM-1a: EM-1a Evacuation Route] , ...13 more...
• FaceMat:
  Inherited
• BlnkMat:
  Inherited
• DirOfFace:
  Inherited
• Leds:
  Inherited
• WOAction:
  Inherited

---

ID: 11
Name: Object / End-of-Roadway Markers
Domains:
• MUTCD:
  Coded Values: [Unknown: Unknown] , [OM1-1: OM1-1 Obstructions within the Roadway] , [OM1-2: OM1-2 Obstructions within the Roadway] , ...12 more...
• FaceMat:
  Inherited
• BlnkMat:
  Inherited
• DirOfFace:
  Inherited
• Leds:
  Inherited
• WOAction:
  Inherited

---

ID: 12
Name: School
Domains:
• MUTCD:
  Coded Values: [Unknown: Unknown] , [S1-1: S1-1 School] , [S3-1: S3-1 School Bus Stop Ahead] , ...15 more...
• FaceMat:
  Inherited
• BlnkMat:
  Inherited
• DirOfFace:
  Inherited
• Leds:
  Inherited
• WOAction:
  Inherited

---

ID: 13
Name: Temporary Traffic Control
Domains:
• MUTCD:
  Coded Values: [Unknown: Unknown] , [R1-1: R1-1 STOP] , [R1-2: R1-2 YIELD] , ...228 more...
• FaceMat:
  Inherited
• BlnkMat:
  Inherited
• DirOfFace:
  Inherited
• Leds:
  Inherited
• WOAction:
  Inherited

---

ID: 99
Name: Other
Domains:
• MUTCD:
  Coded Values: [Other: Other]
• FaceMat:
  Inherited
• BlnkMat:
  Inherited
• DirOfFace:
  Inherited
• Leds:
  Inherited
• WOAction:
  Inherited

---

Relationships:

• Sign_Insp_Sign (2) -- Related To: Sign Inspection (7)
• Sign_Main (1) -- Related To: Sign Post Feature (5)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata