Name: Sign Pole Work Orders

Display Field: SignOrder

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 71b833423c4948e7b3092f6dc1195e0e

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• WorkPerformed ( type: esriFieldTypeString, alias: Work Performed, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WorkPerformed , Coded Values: [Replace Sign and Post: Replace Sign and Post] , [Breakaway and Post: Breakaway and Post] , [Sign: Sign] , ...8 more... )
• DamageType ( type: esriFieldTypeString, alias: Damage Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DamageType , Coded Values: [Vehicle Accident: Vehicle Accident] , [Vandalism: Vandalism] , [Faded/Rusted: Faded/Rusted] , ...6 more... )
• CostPost ( type: esriFieldTypeString, alias: Post Cost, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CostPost )
• CostSign ( type: esriFieldTypeString, alias: Sign Cost, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CostSign )
• WO_Comments ( type: esriFieldTypeString, alias: Work Order Comments, editable: true, nullable: true, length: 300, defaultValue: null, modelName: WO_Comments )
• CreateBy ( type: esriFieldTypeString, alias: CreateBy, editable: false, nullable: true, length: 50, defaultValue: null, modelName: CreateBy )
• CreateDate ( type: esriFieldTypeDate, alias: CreateDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CreateDate )
• EditBy ( type: esriFieldTypeString, alias: EditBy, editable: false, nullable: true, length: 50, defaultValue: null, modelName: EditBy )
• EditDate ( type: esriFieldTypeDate, alias: EditDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: EditDate )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• GUID_Pole ( type: esriFieldTypeGUID, alias: GUID_Pole, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GUID_Pole )
• AssignmentType ( type: esriFieldTypeString, alias: AssignmentT ype, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AssignmentType , Coded Values: [General Ordinance: General Ordinance] , [Engineering Judgement: Engineering Judgement] )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• AssetType ( type: esriFieldTypeString, alias: Asset Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: AssetType )
• WorkDate ( type: esriFieldTypeString, alias: Work Order Date, editable: true, nullable: true, length: 255, defaultValue: null, modelName: WorkDate )
• GUID_Sign ( type: esriFieldTypeGUID, alias: GUID_Sign, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GUID_Sign )

Templates:

• Name: Sign Pole Work Orders
  Description:
  Prototype:
  WorkDate: null
  WorkPerformed: null
  DamageType: null
  CostPost: null
  CostSign: null
  WO_Comments: null
  AssetType: null
  AssignmentType: null
  GUID_Pole: null
  GUID_Sign: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• CityOfSheboygan.OWNER.Signs_Table (2) -- Related To: Signs_Table (1)
• SignPoles (0) -- Related To: SignPoles (0)

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

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Edit Fields Info:

• Creation Date Field: CreateDate
• Creator Field: CreateBy
• Edit Date Field: EditDate
• Editor Field: EditBy

Supports Query With Historic Moment: true

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