Name: Sign Panel

Display Field: PanelJobNumber

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

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: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• SignPanelId ( type: esriFieldTypeGlobalID, alias: Sign Panel ID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: SignPanelId )
• SignInstallationId ( type: esriFieldTypeGUID, alias: Sign Installation ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: SignInstallationId )
• PanelJobNumber ( type: esriFieldTypeString, alias: Panel Job Number, editable: true, nullable: true, length: 30, defaultValue: null, modelName: PanelJobNumber )
• PlusMinus ( type: esriFieldTypeString, alias: Plus Minus, editable: true, nullable: true, length: 1, defaultValue: null, modelName: PlusMinus , Coded Values: [+: +] , [-: -] )
• LocationCode ( type: esriFieldTypeString, alias: Location Code, editable: true, nullable: true, length: 10, defaultValue: null, modelName: LocationCode , Coded Values: [A: A] , [AL: AL] , [AR: AR] , ...14 more... )
• SignCode ( type: esriFieldTypeString, alias: Sign Code, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SignCode , Coded Values: [D1-1: D1-1] , [D1-1A: D1-1A] , [D1-2: D1-2] , ...1157 more... )
• FaceDirection ( type: esriFieldTypeString, alias: Face Direction, editable: true, nullable: true, length: 10, defaultValue: null, modelName: FaceDirection , Coded Values: [North: North] , [East: East] , [South: South] , ...5 more... )
• ColorCode ( type: esriFieldTypeString, alias: Color Code, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ColorCode , Coded Values: [Black On Fluorescent Yellow: Black On Fluorescent Yellow] , [Black On Orange: Black On Orange] , [Black On White: Black On White] , ...14 more... )
• Width ( type: esriFieldTypeSmallInteger, alias: Width, editable: true, nullable: true, defaultValue: null, modelName: Width )
• Height ( type: esriFieldTypeSmallInteger, alias: Height, editable: true, nullable: true, defaultValue: null, modelName: Height )
• MDOT_Prod.DBO.SignPanel.Area ( type: esriFieldTypeDouble, alias: MDOT_Prod.DBO.SignPanel.Area, editable: true, nullable: true, defaultValue: null, modelName: MDOT_Prod.DBO.SignPanel.Area )
• ClusterLocation ( type: esriFieldTypeInteger, alias: Cluster Location, editable: true, nullable: true, defaultValue: null, modelName: ClusterLocation )
• SignMessage ( type: esriFieldTypeString, alias: Sign Message, editable: true, nullable: true, length: 100, defaultValue: null, modelName: SignMessage )
• Substrate ( type: esriFieldTypeString, alias: Substrate, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Substrate , Coded Values: [O - Overhead Plastic Or Plexiglass: O - Overhead Plastic Or Plexiglass] , [I - Aluminum Extruded Section: I - Aluminum Extruded Section] , [II - Plywood: II - Plywood] , ...5 more... )
• BackgroundSheetingType ( type: esriFieldTypeString, alias: Background Sheeting Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BackgroundSheetingType , Coded Values: [Non-Reflectorized: Non-Reflectorized] , [Engineering Grade: Engineering Grade] , [Reflectorized-High Intensity: Reflectorized-High Intensity] , ...5 more... )
• LegendSheetingType ( type: esriFieldTypeString, alias: Legend Sheeting Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LegendSheetingType , Coded Values: [Non-Reflectorized: Non-Reflectorized] , [Engineering Grade: Engineering Grade] , [Reflectorized-High Intensity: Reflectorized-High Intensity] , ...5 more... )
• MdotSuppliedSign ( type: esriFieldTypeString, alias: MDOT Supplied Sign, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MdotSuppliedSign )
• SignPhoto ( type: esriFieldTypeString, alias: Sign Photo, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SignPhoto )
• SignCadFile ( type: esriFieldTypeString, alias: Sign CAD File, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SignCadFile )
• SignComments ( type: esriFieldTypeString, alias: SignComments, editable: true, nullable: true, length: 100, defaultValue: null, modelName: SignComments )
• YearSignInstalled ( type: esriFieldTypeSmallInteger, alias: Year Sign Installed, editable: true, nullable: true, defaultValue: null, modelName: YearSignInstalled )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Status , Coded Values: [Inservice: Inservice] , [Recommendation: Recommendation] )
• SystemCreateDate ( type: esriFieldTypeDate, alias: System Create Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: SystemCreateDate )
• SystemModifiedDate ( type: esriFieldTypeDate, alias: System Modified Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: SystemModifiedDate )
• UserCreate ( type: esriFieldTypeString, alias: User Create, editable: false, nullable: true, length: 50, defaultValue: null, modelName: UserCreate )
• UserModified ( type: esriFieldTypeString, alias: User Modified, editable: false, nullable: true, length: 50, defaultValue: null, modelName: UserModified )
• TemporarySignId ( type: esriFieldTypeInteger, alias: Temporary Sign ID, editable: true, nullable: true, defaultValue: null, modelName: TemporarySignId )

Templates:

• Name: Sign Panel
  Description:
  Prototype:
  YearSignInstalled: null
  TemporarySignId: null
  Status: null
  SignInstallationId: null
  PanelJobNumber: null
  PlusMinus: null
  LocationCode: null
  SignCode: null
  FaceDirection: null
  ColorCode: null
  Width: null
  Height: null
  MDOT_Prod.DBO.SignPanel.Area: null
  ClusterLocation: null
  SignMessage: null
  Substrate: null
  BackgroundSheetingType: null
  LegendSheetingType: null
  MdotSuppliedSign: null
  SignPhoto: null
  SignCadFile: null
  SignComments: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• SignStructure (2) -- Related To: Sign Structure (5)

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: SystemCreateDate
• Creator Field: UserCreate
• Edit Date Field: SystemModifiedDate
• Editor Field: UserModified

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata