Name: Sign Plate Maintenance

Display Field: SignMaintenanceTransactionsID

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

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

Relationships:

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

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

  Iteminfo   Thumbnail   Metadata