Name: CO_Share.DBO.SignWork_1

Display Field: WorkType

Type: Table

Geometry Type: N/A

Description: null

Definition Expression: N/A

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, AMF

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID )
• WorkType ( type: esriFieldTypeString , alias: Work Type , length: 50 , Coded Values: [Install: Install Sign] , [Replace: Replace Sign] , [Remove: Remove Sign] , ...2 more... )
• Inspect_da ( type: esriFieldTypeDate , alias: Inspection Date , length: 8 )
• CompletionDate ( type: esriFieldTypeDate , alias: Completion Date , length: 8 )
• Comments ( type: esriFieldTypeString , alias: Comments , length: 150 )
• txtImageNa ( type: esriFieldTypeString , alias: Picture , length: 125 )
• Route_num ( type: esriFieldTypeString , alias: Route # , length: 254 )
• Descriptio ( type: esriFieldTypeString , alias: Description , length: 254 )
• Sign_code ( type: esriFieldTypeString , alias: Sign Code , length: 254 )
• Height ( type: esriFieldTypeDouble , alias: Height )
• Width ( type: esriFieldTypeDouble , alias: Width )
• Sign_statu ( type: esriFieldTypeString , alias: Sign Status , length: 254 , Coded Values: [Warehouse: Warehouse] , [On Truck: On Truck] , [Trashed: Trashed] , ...1 more... )
• Log_point ( type: esriFieldTypeDouble , alias: Log Point )
• Side_of_ro ( type: esriFieldTypeString , alias: Side of Road , length: 254 , Coded Values: [L: Left] , [R: Right] , [A: Ahead] , ...1 more... )
• Symbol_rot ( type: esriFieldTypeString , alias: Sign Faces , length: 254 , Coded Values: [N: North] , [S: South] , [E: East] , ...5 more... )
• Offset ( type: esriFieldTypeDouble , alias: Offset )
• Sign_numb ( type: esriFieldTypeString , alias: New Sign # , length: 50 )
• Sign_num ( type: esriFieldTypeString , alias: Old Sign # , length: 50 )
• Route ( type: esriFieldTypeString , alias: Route Name , length: 50 )
• Work_reason ( type: esriFieldTypeString , alias: Work Reason , length: 50 , Coded Values: [Accident: Accident] , [Routine: Routine Manitenance] , [Vandalism: Vandalism] , ...2 more... )
• X ( type: esriFieldTypeDouble , alias: GPS X )
• Y ( type: esriFieldTypeDouble , alias: GPS Y )
• SignID ( type: esriFieldTypeInteger , alias: SignID )
• GlobalID ( type: esriFieldTypeGlobalID , alias: GlobalID , length: 38 )

Relationships:

• CO_Share.DBO.Signs_1 (0) -- Related To: Shelby Signs (0)

Supported Operations:   Query   Query Related Records   Generate Renderer   Return Updates