Name: Sign Plate Maintenance

Display Field: SignMaintenanceTransactionsID

Type: Table

Geometry Type: N/A

Description:

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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• MaintDateDate ( type: esriFieldTypeDate, alias: Maintenance Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MaintDateDate )
• SignMaintenanceActivityCode2 ( type: esriFieldTypeString, alias: Maintenance Activity, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SignMaintenanceActivityCode2 , Coded Values: [INSPSIGN: Inspect Sign] , [CLEASIGN: Clean Sign] , [ADDSIGN: Inventory Correction - Add Sign] , ...7 more... )
• MaintenanceReasonCode2 ( type: esriFieldTypeString, alias: Maintenance Reason, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MaintenanceReasonCode2 , Coded Values: [BALLBANK: Ball Bank] , [CNSTPROJ: Construction Project] , [CNTYCODE: County Code] , ...14 more... )
• Legend2 ( type: esriFieldTypeString, alias: Legend, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Legend2 , Coded Values: [% GRADE FOR-MILES: % GRADE FOR-MILES] , [% GRADE PLAQUE: % GRADE PLAQUE] , [_ MILE(S): _ MILE(S)] , ...456 more... )
• SignCode2 ( type: esriFieldTypeString, alias: Sign Code, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SignCode2 , Coded Values: [12-101C: 12-101C] , [12.13: 12.13] , [ARTERIAL-C: ARTERIAL-C] , ...477 more... )
• LegendDetail2 ( type: esriFieldTypeString, alias: Legend Detail, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LegendDetail2 )
• SignSheetingMaterialTypeCode2 ( type: esriFieldTypeString, alias: Sheeting Material, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SignSheetingMaterialTypeCode2 , Coded Values: [EG: Engineering Grade] , [HIP: High Intensity/ Prismatic] , [EC: Electronic Cutable] , ...1 more... )
• SignSizeTypeCode2 ( type: esriFieldTypeString, alias: Sign Size, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SignSizeTypeCode2 , Coded Values: [6 X 8: 6 X 8] , [6 X 12: 6 X 12] , [6 X 24: 6 X 24] , ...64 more... )
• SignColorTypeCode2 ( type: esriFieldTypeString, alias: Sign Color, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SignColorTypeCode2 , Coded Values: [AMBER: Amber] , [Blk/G: Black legend, Green background] , [Blk/O: Black legend, Orange background] , ...44 more... )
• SignPlateMaterialTypeCode2 ( type: esriFieldTypeString, alias: Plate Material, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SignPlateMaterialTypeCode2 , Coded Values: [AL: Aluminum] , [FG: Fiberglass] , [PW: Plywood] , ...2 more... )
• MountPosition2 ( type: esriFieldTypeString, alias: Mount Position, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MountPosition2 )
• Orientation2 ( type: esriFieldTypeString, alias: Orientation, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Orientation2 )
• UserID2 ( type: esriFieldTypeString, alias: User ID, editable: false, nullable: true, length: 255, defaultValue: null, modelName: UserID2 )
• Comment2 ( type: esriFieldTypeString, alias: Comment, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comment2 )
• RoadNumber ( type: esriFieldTypeString, alias: Road Number, editable: true, nullable: true, length: 5, defaultValue: null, modelName: RoadNumber )
• MP ( type: esriFieldTypeDouble, alias: Milepost, editable: true, nullable: true, defaultValue: null, modelName: MP )
• RoadName ( type: esriFieldTypeString, alias: Road Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RoadName )
• PostRelID ( type: esriFieldTypeGUID, alias: Post ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: PostRelID )
• SignPlateGUID ( type: esriFieldTypeGUID, alias: Plate ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: SignPlateGUID )
• SignMaintenanceTransactionsID ( type: esriFieldTypeInteger, alias: SignMaintenanceTransactionsID, editable: true, nullable: true, defaultValue: null, modelName: SignMaintenanceTransactionsID )
• SignPlateGlobalID ( type: esriFieldTypeString, alias: SignPlateGlobalID, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: SignPlateGlobalID )
• SignPostGlobalID ( type: esriFieldTypeString, alias: SignPostGlobalID, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: SignPostGlobalID )
• MaintDate ( type: esriFieldTypeString, alias: MaintDate, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: MaintDate )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• InitialInstallYear ( type: esriFieldTypeString, alias: InitialInstallYear, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: InitialInstallYear )
• DateInstalled ( type: esriFieldTypeString, alias: DateInstalled, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: DateInstalled )
• DateRemoved ( type: esriFieldTypeString, alias: DateRemoved, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: DateRemoved )
• TransactionAppliedToGISInventor ( type: esriFieldTypeInteger, alias: TransactionAppliedToGISInventory, editable: true, nullable: true, defaultValue: null, modelName: TransactionAppliedToGISInventor )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• SignMaintenanceActivityCode ( type: esriFieldTypeString, alias: Maintenance Activity OLD, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: SignMaintenanceActivityCode , Coded Values: [INSPSIGN: Inspect Sign] , [CLEASIGN: Clean Sign] , [ADDSIGN: Inventory Correction - Add Sign] , ...7 more... )
• MaintenanceActivityReasonCode ( type: esriFieldTypeString, alias: Maintenance Reason OLD, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: MaintenanceActivityReasonCode , Coded Values: [BALLBANK: Ball Bank] , [CNSTPROJ: Construction Project] , [CNTYCODE: County Code] , ...14 more... )
• Legend ( type: esriFieldTypeString, alias: Legend OLD, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Legend , Coded Values: [% GRADE FOR-MILES: % GRADE FOR-MILES] , [% GRADE PLAQUE: % GRADE PLAQUE] , [_ MILE(S): _ MILE(S)] , ...456 more... )
• SignCode ( type: esriFieldTypeString, alias: Sign Code OLD, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: SignCode , Coded Values: [12-101C: 12-101C] , [12.13: 12.13] , [ARTERIAL-C: ARTERIAL-C] , ...477 more... )
• LegendDetail ( type: esriFieldTypeString, alias: Legend Detail OLD, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: LegendDetail )
• SignSheetingMaterialTypeCode ( type: esriFieldTypeString, alias: Sheeting Material OLD, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: SignSheetingMaterialTypeCode )
• SignSizeTypeCode ( type: esriFieldTypeString, alias: Sign Size OLD, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: SignSizeTypeCode , Coded Values: [6 X 8: 6 X 8] , [6 X 12: 6 X 12] , [6 X 24: 6 X 24] , ...64 more... )
• SignColorTypeCode ( type: esriFieldTypeString, alias: Sign Color OLD, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: SignColorTypeCode )
• SignPlateMaterialTypeCode ( type: esriFieldTypeString, alias: Plate Material OLD, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: SignPlateMaterialTypeCode )
• MountPosition ( type: esriFieldTypeString, alias: Mount Position OLD, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: MountPosition )
• Orientation ( type: esriFieldTypeString, alias: Orientation OLD, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Orientation )
• UserID ( type: esriFieldTypeString, alias: User ID OLD, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: UserID )
• ActivityComment ( type: esriFieldTypeString, alias: Comment OLD, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ActivityComment )

Templates:

• Name: Sign Plate Maintenance
  Description:
  Prototype:
  UserID: null
  MaintDateDate: null
  SignMaintenanceActivityCode2: null
  MaintenanceReasonCode2: null
  Legend2: null
  SignCode2: null
  LegendDetail2: null
  SignSheetingMaterialTypeCode2: null
  SignSizeTypeCode2: null
  SignColorTypeCode2: null
  SignPlateMaterialTypeCode2: null
  MountPosition2: null
  Orientation2: null
  Orientation: null
  Comment2: null
  RoadNumber: null
  MP: null
  RoadName: null
  PostRelID: null
  SignPlateGUID: null
  SignMaintenanceTransactionsID: null
  SignPlateGlobalID: null
  SignPostGlobalID: null
  MaintDate: null
  InitialInstallYear: null
  DateInstalled: null
  DateRemoved: null
  TransactionAppliedToGISInventor: null
  ActivityComment: null
  SignMaintenanceActivityCode: null
  MaintenanceActivityReasonCode: null
  Legend: null
  SignCode: null
  LegendDetail: null
  SignSheetingMaterialTypeCode: null
  SignSizeTypeCode: null
  SignColorTypeCode: null
  SignPlateMaterialTypeCode: null
  MountPosition: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• maintenance_to_plate (2) -- Related To: Sign Plates (22)

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

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field:
• Creator Field: UserID2
• Edit Date Field:
• Editor Field:

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

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