Name: Sign Post Maintenance

Display Field: RoadName

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

Templates:

• Name: Sign Post Maintenance
  Description:
  Prototype:
  ActivityComment: null
  MaintDateDate: null
  PostMaintenanceActivityCode2: null
  MaintenanceReasonCode2: null
  PostTypeCode2: null
  RoadName: null
  RoadNumText: null
  MilePostsDouble: null
  NumPostLong: null
  SideOfRoad2: null
  PostTreatmentCode2: null
  Comment2: null
  PostTreatmentCode: null
  DateInstalled: null
  DateRemoved: null
  PostGUID: null
  RoadNumber: null
  Milepost: null
  InitialInstallYear: null
  Latitude: null
  Longitude: null
  NumberOfPosts: null
  TransactionAppliedToGISInventor: null
  PostGlobalID: null
  PostMaintenanceTransactionsID: null
  UserID: null
  SignPostGlobalID: null
  MaintDate: null
  PostMaintenanceActivityCode: null
  MaintenanceActivityReasonCode: null
  PostTypeCode: null
  SideOfRoad: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

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

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