Name: Sign Table

Display Field: SignNum

Type: Table

Geometry Type: N/A

Description:

Service Item Id: e6d1efd2fca9458b908bbd6a4bccbb15

Copyright Text:

Default Visibility: false

MaxRecordCount: 4000

MaxSelectionCount: 0

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

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

Types:

ID: 1
Name: Regulator
Domains:
• WOAction:
  Inherited
• MUTCD:
  Coded Values: [Unknown: Unknown] , [R1-1: R1-1 Stop] , [R1-2: R1-2 Yield] , ...482 more...
• Leds:
  Inherited
• DirOfFace:
  Inherited
• FaceMat:
  Inherited
• BlnkMat:
  Inherited
Templates:
• Name: Regulator
  Description:
  Prototype:
  Legend: null
  WOAction: null
  CMT_Map_Style3: null
  CMT_Map_Style2: null
  CMT_Map_Style1: null
  isActive: null
  Leds: null
  CMT_Latitude: null
  WONumber: null
  SignNum: null
  Height: null
  Width: null
  CMT_Longitude: null
  BlnkMat: null
  CMT_Map_Label: null
  CMT_Job_Number: null
  Comments: null
  MUTCD: null
  InstallDate: null
  RotSym: null
  Rel_GlobalID: {00000000-0000-0000-0000-000000000000}
  CMT_Data_Key: null
  DirOfFace: null
  FaceMat: null
  SIGN_CATEGORY: 1
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 2
Name: Warning
Domains:
• WOAction:
  Inherited
• MUTCD:
  Coded Values: [Unknown: Unknown] , [W1-1L: W1-1L Horizontal Alignment] , [W1-1R: W1-1R Horizontal Alignment] , ...360 more...
• Leds:
  Inherited
• DirOfFace:
  Inherited
• FaceMat:
  Inherited
• BlnkMat:
  Inherited
Templates:
• Name: Warning
  Description:
  Prototype:
  Legend: null
  WOAction: null
  CMT_Map_Style3: null
  CMT_Map_Style2: null
  CMT_Map_Style1: null
  isActive: null
  Leds: null
  CMT_Latitude: null
  WONumber: null
  SignNum: null
  Height: null
  Width: null
  CMT_Longitude: null
  BlnkMat: null
  CMT_Map_Label: null
  CMT_Job_Number: null
  Comments: null
  MUTCD: null
  InstallDate: null
  RotSym: null
  Rel_GlobalID: {00000000-0000-0000-0000-000000000000}
  CMT_Data_Key: null
  DirOfFace: null
  FaceMat: null
  SIGN_CATEGORY: 2
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 3
Name: Directional
Domains:
• WOAction:
  Inherited
• MUTCD:
  Coded Values: [Unknown: Unknown] , [D1-H1: D1-H1 Destination (1 line)] , [D1-H1a: D1-H1a Destination and Distance (1 line)] , ...229 more...
• Leds:
  Inherited
• DirOfFace:
  Inherited
• FaceMat:
  Inherited
• BlnkMat:
  Inherited
Templates:
• Name: Directional
  Description:
  Prototype:
  Legend: null
  WOAction: null
  CMT_Map_Style3: null
  CMT_Map_Style2: null
  CMT_Map_Style1: null
  isActive: null
  Leds: null
  CMT_Latitude: null
  WONumber: null
  SignNum: null
  Height: null
  Width: null
  CMT_Longitude: null
  BlnkMat: null
  CMT_Map_Label: null
  CMT_Job_Number: null
  Comments: null
  MUTCD: null
  InstallDate: null
  RotSym: null
  Rel_GlobalID: {00000000-0000-0000-0000-000000000000}
  CMT_Data_Key: null
  DirOfFace: null
  FaceMat: null
  SIGN_CATEGORY: 3
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 4
Name: Information
Domains:
• WOAction:
  Inherited
• MUTCD:
  Coded Values: [Unknown: Unknown] , [I-2: I-2 Ohio State Line] , [I-H2: I-H2 Welcome to Ohio] , ...32 more...
• Leds:
  Inherited
• DirOfFace:
  Inherited
• FaceMat:
  Inherited
• BlnkMat:
  Inherited
Templates:
• Name: Information
  Description:
  Prototype:
  Legend: null
  WOAction: null
  CMT_Map_Style3: null
  CMT_Map_Style2: null
  CMT_Map_Style1: null
  isActive: null
  Leds: null
  CMT_Latitude: null
  WONumber: null
  SignNum: null
  Height: null
  Width: null
  CMT_Longitude: null
  BlnkMat: null
  CMT_Map_Label: null
  CMT_Job_Number: null
  Comments: null
  MUTCD: null
  InstallDate: null
  RotSym: null
  Rel_GlobalID: {00000000-0000-0000-0000-000000000000}
  CMT_Data_Key: null
  DirOfFace: null
  FaceMat: null
  SIGN_CATEGORY: 4
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 5
Name: Logos
Domains:
• WOAction:
  Inherited
• 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...
• Leds:
  Inherited
• DirOfFace:
  Inherited
• FaceMat:
  Inherited
• BlnkMat:
  Inherited
Templates:
• Name: Logos
  Description:
  Prototype:
  Legend: null
  WOAction: null
  CMT_Map_Style3: null
  CMT_Map_Style2: null
  CMT_Map_Style1: null
  isActive: null
  Leds: null
  CMT_Latitude: null
  WONumber: null
  SignNum: null
  Height: null
  Width: null
  CMT_Longitude: null
  BlnkMat: null
  CMT_Map_Label: null
  CMT_Job_Number: null
  Comments: null
  MUTCD: null
  InstallDate: null
  RotSym: null
  Rel_GlobalID: {00000000-0000-0000-0000-000000000000}
  CMT_Data_Key: null
  DirOfFace: null
  FaceMat: null
  SIGN_CATEGORY: 5
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 6
Name: Markers
Domains:
• WOAction:
  Inherited
• MUTCD:
  Coded Values: [Unknown: Unknown] , [M1-1: M1-1 Interstate Route Sign] , [M1-2: M1-2 Off-Interstate Route Sign (Loop)] , ...97 more...
• Leds:
  Inherited
• DirOfFace:
  Inherited
• FaceMat:
  Inherited
• BlnkMat:
  Inherited
Templates:
• Name: Markers
  Description:
  Prototype:
  Legend: null
  WOAction: null
  CMT_Map_Style3: null
  CMT_Map_Style2: null
  CMT_Map_Style1: null
  isActive: null
  Leds: null
  CMT_Latitude: null
  WONumber: null
  SignNum: null
  Height: null
  Width: null
  CMT_Longitude: null
  BlnkMat: null
  CMT_Map_Label: null
  CMT_Job_Number: null
  Comments: null
  MUTCD: null
  InstallDate: null
  RotSym: null
  Rel_GlobalID: {00000000-0000-0000-0000-000000000000}
  CMT_Data_Key: null
  DirOfFace: null
  FaceMat: null
  SIGN_CATEGORY: 6
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 7
Name: Miscellaneous (Guide)
Domains:
• WOAction:
  Inherited
• MUTCD:
  Coded Values: [Unknown: Unknown] , [Fully Designable: Fully Designable] , [E1-5aP: E1-5aP Left (plaque)] , ...47 more...
• Leds:
  Inherited
• DirOfFace:
  Inherited
• FaceMat:
  Inherited
• BlnkMat:
  Inherited
Templates:
• Name: Miscellaneous (Guide)
  Description:
  Prototype:
  Legend: null
  WOAction: null
  CMT_Map_Style3: null
  CMT_Map_Style2: null
  CMT_Map_Style1: null
  isActive: null
  Leds: null
  CMT_Latitude: null
  WONumber: null
  SignNum: null
  Height: null
  Width: null
  CMT_Longitude: null
  BlnkMat: null
  CMT_Map_Label: null
  CMT_Job_Number: null
  Comments: null
  MUTCD: null
  InstallDate: null
  RotSym: null
  Rel_GlobalID: {00000000-0000-0000-0000-000000000000}
  CMT_Data_Key: null
  DirOfFace: null
  FaceMat: null
  SIGN_CATEGORY: 7
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 8
Name: Recreational & Cultural
Domains:
• WOAction:
  Inherited
• MUTCD:
  Coded Values: [Unknown: Unknown] , [RS-002: RS-002 Smoking] , [RS-005: RS-005 Tunnel] , ...120 more...
• Leds:
  Inherited
• DirOfFace:
  Inherited
• FaceMat:
  Inherited
• BlnkMat:
  Inherited
Templates:
• Name: Recreational & Cultural
  Description:
  Prototype:
  Legend: null
  WOAction: null
  CMT_Map_Style3: null
  CMT_Map_Style2: null
  CMT_Map_Style1: null
  isActive: null
  Leds: null
  CMT_Latitude: null
  WONumber: null
  SignNum: null
  Height: null
  Width: null
  CMT_Longitude: null
  BlnkMat: null
  CMT_Map_Label: null
  CMT_Job_Number: null
  Comments: null
  MUTCD: null
  InstallDate: null
  RotSym: null
  Rel_GlobalID: {00000000-0000-0000-0000-000000000000}
  CMT_Data_Key: null
  DirOfFace: null
  FaceMat: null
  SIGN_CATEGORY: 8
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 9
Name: TODS
Domains:
• WOAction:
  Inherited
• MUTCD:
  Coded Values: [Unknown: Unknown] , [D9-H50: D9-H50 TODS Business Panel] , [D9-H51: D9-H51 TODS TOURIST ACTIVITIES] , ...5 more...
• Leds:
  Inherited
• DirOfFace:
  Inherited
• FaceMat:
  Inherited
• BlnkMat:
  Inherited
Templates:
• Name: TODS
  Description:
  Prototype:
  Legend: null
  WOAction: null
  CMT_Map_Style3: null
  CMT_Map_Style2: null
  CMT_Map_Style1: null
  isActive: null
  Leds: null
  CMT_Latitude: null
  WONumber: null
  SignNum: null
  Height: null
  Width: null
  CMT_Longitude: null
  BlnkMat: null
  CMT_Map_Label: null
  CMT_Job_Number: null
  Comments: null
  MUTCD: null
  InstallDate: null
  RotSym: null
  Rel_GlobalID: {00000000-0000-0000-0000-000000000000}
  CMT_Data_Key: null
  DirOfFace: null
  FaceMat: null
  SIGN_CATEGORY: 9
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 10
Name: Emergency Management
Domains:
• WOAction:
  Inherited
• MUTCD:
  Coded Values: [Unknown: Unknown] , [EM-1: EM-1 Evacuation Route] , [EM-1a: EM-1a Evacuation Route] , ...13 more...
• Leds:
  Inherited
• DirOfFace:
  Inherited
• FaceMat:
  Inherited
• BlnkMat:
  Inherited
Templates:
• Name: Emergency Management
  Description:
  Prototype:
  Legend: null
  WOAction: null
  CMT_Map_Style3: null
  CMT_Map_Style2: null
  CMT_Map_Style1: null
  isActive: null
  Leds: null
  CMT_Latitude: null
  WONumber: null
  SignNum: null
  Height: null
  Width: null
  CMT_Longitude: null
  BlnkMat: null
  CMT_Map_Label: null
  CMT_Job_Number: null
  Comments: null
  MUTCD: null
  InstallDate: null
  RotSym: null
  Rel_GlobalID: {00000000-0000-0000-0000-000000000000}
  CMT_Data_Key: null
  DirOfFace: null
  FaceMat: null
  SIGN_CATEGORY: 10
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 11
Name: Object / End-of-Roadway Markers
Domains:
• WOAction:
  Inherited
• MUTCD:
  Coded Values: [Unknown: Unknown] , [OM1-1: OM1-1 Obstructions within the Roadway] , [OM1-2: OM1-2 Obstructions within the Roadway] , ...12 more...
• Leds:
  Inherited
• DirOfFace:
  Inherited
• FaceMat:
  Inherited
• BlnkMat:
  Inherited
Templates:
• Name: Object / End-of-Roadway Markers
  Description:
  Prototype:
  Legend: null
  WOAction: null
  CMT_Map_Style3: null
  CMT_Map_Style2: null
  CMT_Map_Style1: null
  isActive: null
  Leds: null
  CMT_Latitude: null
  WONumber: null
  SignNum: null
  Height: null
  Width: null
  CMT_Longitude: null
  BlnkMat: null
  CMT_Map_Label: null
  CMT_Job_Number: null
  Comments: null
  MUTCD: null
  InstallDate: null
  RotSym: null
  Rel_GlobalID: {00000000-0000-0000-0000-000000000000}
  CMT_Data_Key: null
  DirOfFace: null
  FaceMat: null
  SIGN_CATEGORY: 11
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 12
Name: School
Domains:
• WOAction:
  Inherited
• MUTCD:
  Coded Values: [Unknown: Unknown] , [S1-1: S1-1 School] , [S3-1: S3-1 School Bus Stop Ahead] , ...15 more...
• Leds:
  Inherited
• DirOfFace:
  Inherited
• FaceMat:
  Inherited
• BlnkMat:
  Inherited
Templates:
• Name: School
  Description:
  Prototype:
  Legend: null
  WOAction: null
  CMT_Map_Style3: null
  CMT_Map_Style2: null
  CMT_Map_Style1: null
  isActive: null
  Leds: null
  CMT_Latitude: null
  WONumber: null
  SignNum: null
  Height: null
  Width: null
  CMT_Longitude: null
  BlnkMat: null
  CMT_Map_Label: null
  CMT_Job_Number: null
  Comments: null
  MUTCD: null
  InstallDate: null
  RotSym: null
  Rel_GlobalID: {00000000-0000-0000-0000-000000000000}
  CMT_Data_Key: null
  DirOfFace: null
  FaceMat: null
  SIGN_CATEGORY: 12
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 13
Name: Temporary Traffic Control
Domains:
• WOAction:
  Inherited
• MUTCD:
  Coded Values: [Unknown: Unknown] , [R1-1: R1-1 STOP] , [R1-2: R1-2 YIELD] , ...228 more...
• Leds:
  Inherited
• DirOfFace:
  Inherited
• FaceMat:
  Inherited
• BlnkMat:
  Inherited
Templates:
• Name: Temporary Traffic Control
  Description:
  Prototype:
  Legend: null
  WOAction: null
  CMT_Map_Style3: null
  CMT_Map_Style2: null
  CMT_Map_Style1: null
  isActive: null
  Leds: null
  CMT_Latitude: null
  WONumber: null
  SignNum: null
  Height: null
  Width: null
  CMT_Longitude: null
  BlnkMat: null
  CMT_Map_Label: null
  CMT_Job_Number: null
  Comments: null
  MUTCD: null
  InstallDate: null
  RotSym: null
  Rel_GlobalID: {00000000-0000-0000-0000-000000000000}
  CMT_Data_Key: null
  DirOfFace: null
  FaceMat: null
  SIGN_CATEGORY: 13
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 99
Name: Other
Domains:
• WOAction:
  Inherited
• MUTCD:
  Coded Values: [Other: Other]
• Leds:
  Inherited
• DirOfFace:
  Inherited
• FaceMat:
  Inherited
• BlnkMat:
  Inherited
Templates:
• Name: Other
  Description:
  Prototype:
  Legend: null
  WOAction: null
  CMT_Map_Style3: null
  CMT_Map_Style2: null
  CMT_Map_Style1: null
  isActive: null
  Leds: null
  CMT_Latitude: null
  WONumber: null
  SignNum: null
  Height: null
  Width: null
  CMT_Longitude: null
  BlnkMat: null
  CMT_Map_Label: null
  CMT_Job_Number: null
  Comments: null
  MUTCD: null
  InstallDate: null
  RotSym: null
  Rel_GlobalID: {00000000-0000-0000-0000-000000000000}
  CMT_Data_Key: null
  DirOfFace: null
  FaceMat: null
  SIGN_CATEGORY: 99
  
  Drawing Tool: esriFeatureEditToolNone

---

Relationships:

• Sign_Main (0) -- Related To: Sign Post Feature (1)
• Sign_Main (1) -- Related To: Sign Installation (2)

Capabilities: Query,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: 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: true

Supports Coordinates Quantization: false

Child Resources:

Supported Operations:   Query   Query Analytic   Query Related Records   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata