Name: Sign Table

Display Field: SignNum

Type: Table

Geometry Type: N/A

Description:

Service Item Id: c27e2260a46b42a08720bffb65ada620

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

---

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

---

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

---

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

---

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

---

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

---

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

---

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

---

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

---

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

---

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
Templates:
• Name: Object / End-of-Roadway Markers
  Description:
  Prototype:
  isActive: null
  Rel_GlobalID: {00000000-0000-0000-0000-000000000000}
  SignNum: null
  MUTCD: null
  Width: null
  Height: null
  FaceMat: null
  BlnkMat: null
  Legend: null
  DirOfFace: null
  Leds: null
  RotSym: null
  InstallDate: null
  Comments: null
  WONumber: null
  WOAction: null
  SIGN_CATEGORY: 11
  CMT_Latitude: null
  CMT_Longitude: null
  CMT_Map_Label: null
  CMT_Map_Style1: null
  CMT_Map_Style2: null
  CMT_Map_Style3: null
  CMT_Data_Key: null
  CMT_Job_Number: null
  
  Drawing Tool: esriFeatureEditToolNone

---

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

---

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

---

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

---

Relationships:

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

Capabilities: Query,Create,Update,Delete,Uploads,Editing,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   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata