Name: Sign Post Maintenance

Display Field: RoadName

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 )
• PostMaintenanceActivityCode2 ( type: esriFieldTypeString, alias: Maintenance Activity, length: 255 , Coded Values: [INSPPOST: Inspect Post] , [CLSIGHTD: Clear Sight Distance] , [ADDPOST: Inventory Correction - Add Post] , ...10 more... )
• MaintenanceReasonCode2 ( type: esriFieldTypeString, alias: Maintenance Reason, length: 255 , Coded Values: [BALLBANK: Ball Bank] , [CNSTPROJ: Construction Project] , [CNTYCODE: County Code] , ...14 more... )
• PostTypeCode2 ( type: esriFieldTypeString, alias: Post Type, length: 255 , Coded Values: [SC: Steel Channel] , [SMA: Signal Mast Arm] , [BP: Beacon Pole] , ...2 more... )
• RoadName ( type: esriFieldTypeString, alias: Road Name, length: 50 )
• RoadNumText ( type: esriFieldTypeString, alias: Road Number, length: 5 )
• MilePostsDouble ( type: esriFieldTypeDouble, alias: Milepost )
• NumPostLong ( type: esriFieldTypeInteger, alias: Number of Posts )
• SideOfRoad2 ( type: esriFieldTypeString, alias: Side of Road, length: 255 , Coded Values: [NULL: NULL] , [A: A] , [B: B] , ...19 more... )
• PostTreatmentCode2 ( type: esriFieldTypeString, alias: Post Treatment, length: 255 , Coded Values: [PA: Paint] , [GA: Galvanizing] , [OT: Other] , ...1 more... )
• Comment2 ( type: esriFieldTypeString, alias: Comment, length: 255 )
• UserID2 ( type: esriFieldTypeString, alias: User ID, length: 255 )
• DateInstalled ( type: esriFieldTypeString, alias: Date Installed, length: 1073741822 )
• DateRemoved ( type: esriFieldTypeString, alias: Date Removed, length: 1073741822 )
• PostGUID ( type: esriFieldTypeGUID, alias: Post ID, length: 38 )
• RoadNumber ( type: esriFieldTypeInteger, alias: RoadNumber )
• Milepost ( type: esriFieldTypeString, alias: Milepost, length: 1073741822 )
• InitialInstallYear ( type: esriFieldTypeString, alias: InitialInstallYear, length: 1073741822 )
• Latitude ( type: esriFieldTypeString, alias: Latitude, length: 1073741822 )
• Longitude ( type: esriFieldTypeString, alias: Longitude, length: 1073741822 )
• NumberOfPosts ( type: esriFieldTypeString, alias: NumberOfPosts, length: 1073741822 )
• TransactionAppliedToGISInventor ( type: esriFieldTypeInteger, alias: TransactionAppliedToGISInventory )
• PostGlobalID ( type: esriFieldTypeGUID, alias: PostGlobalID, length: 38 )
• PostMaintenanceTransactionsID ( type: esriFieldTypeInteger, alias: PostMaintenanceTransactionsID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• SignPostGlobalID ( type: esriFieldTypeString, alias: SignPostGlobalID, length: 1073741822 )
• MaintDate ( type: esriFieldTypeString, alias: MaintDate, length: 1073741822 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• PostMaintenanceActivityCode ( type: esriFieldTypeString, alias: Maintenance Activity OLD, length: 1073741822 , Coded Values: [INSPPOST: Inspect Post] , [CLSIGHTD: Clear Sight Distance] , [ADDPOST: Inventory Correction - Add Post] , ...10 more... )
• MaintenanceActivityReasonCode ( type: esriFieldTypeString, alias: Maintenance Reason OLD, length: 1073741822 , Coded Values: [BALLBANK: Ball Bank] , [CNSTPROJ: Construction Project] , [CNTYCODE: County Code] , ...14 more... )
• PostTypeCode ( type: esriFieldTypeString, alias: Post Type OLD, length: 1073741822 , Coded Values: [SC: Steel Channel] , [SMA: Signal Mast Arm] , [BP: Beacon Pole] , ...2 more... )
• SideOfRoad ( type: esriFieldTypeString, alias: Side of Road OLD, length: 1073741822 )
• PostTreatmentCode ( type: esriFieldTypeString, alias: Post Treatment OLD, length: 1073741822 )
• ActivityComment ( type: esriFieldTypeString, alias: Comment OLD, length: 1073741822 )
• UserID ( type: esriFieldTypeString, alias: User ID OLD, length: 1073741822 )

Relationships:

• PWSDE.PUBWORKS.Sign_Posts_NEW_Staging (1) -- Related To: Sign Posts (21)

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

  Iteminfo   Thumbnail   Metadata