Name: Sign Pole Work Orders

Display Field: SignOrder

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: f0438499ad8f4b72a421e851145a5a05

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• WorkPerformed ( type: esriFieldTypeString, alias: Work Performed, length: 50 , 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, length: 50 , Coded Values: [Vehicle Accident: Vehicle Accident] , [Vandalism: Vandalism] , [Faded/Rusted: Faded/Rusted] , ...6 more... )
• CostPost ( type: esriFieldTypeString, alias: Post Cost, length: 50 )
• CostSign ( type: esriFieldTypeString, alias: Sign Cost, length: 50 )
• WO_Comments ( type: esriFieldTypeString, alias: Work Order Comments, length: 300 )
• CreateBy ( type: esriFieldTypeString, alias: CreateBy, length: 50 )
• CreateDate ( type: esriFieldTypeDate, alias: CreateDate, length: 8 )
• EditBy ( type: esriFieldTypeString, alias: EditBy, length: 50 )
• EditDate ( type: esriFieldTypeDate, alias: EditDate, length: 8 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• GUID_Pole ( type: esriFieldTypeGUID, alias: GUID_Pole, length: 38 )
• AssignmentType ( type: esriFieldTypeString, alias: AssignmentT ype, length: 50 , Coded Values: [General Ordinance: General Ordinance] , [Engineering Judgement: Engineering Judgement] )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• AssetType ( type: esriFieldTypeString, alias: Asset Type, length: 255 )
• WorkDate ( type: esriFieldTypeString, alias: Work Order Date, length: 255 )
• GUID_Sign ( type: esriFieldTypeGUID, alias: GUID_Sign, length: 38 )

Relationships:

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

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

  Iteminfo   Thumbnail   Metadata