Name: Operations.GIS_ADMIN.Grease_Inventory

Display Field: LAST_USER

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON

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:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• LAST_USER ( type: esriFieldTypeString, alias: LAST_USER, length: 20 )
• EDIT_DATE ( type: esriFieldTypeDate, alias: EDIT_DATE, length: 8 )
• SEWER_ID ( type: esriFieldTypeString, alias: SEWER_ID, length: 15 )
• FROM_MANHOLE_ID ( type: esriFieldTypeString, alias: FROM_MANHOLE_ID, length: 15 )
• TO_MANHOLE_ID ( type: esriFieldTypeString, alias: TO_MANHOLE_ID, length: 15 )
• ADDED_BY ( type: esriFieldTypeString, alias: ADDED_BY, length: 30 )
• DATE_ADDED ( type: esriFieldTypeDate, alias: DATE_ADDED, length: 8 )
• ACTIVE_INVENTORY ( type: esriFieldTypeString, alias: ACTIVE_INVENTORY, length: 1 , Coded Values: [Y: Yes] , [N: No] , [U: Unknown] )
• REMOVED_BY ( type: esriFieldTypeString, alias: REMOVED_BY, length: 30 )
• DATE_REMOVED ( type: esriFieldTypeDate, alias: DATE_REMOVED, length: 8 )
• PROBLEM_LOCATION ( type: esriFieldTypeString, alias: PROBLEM_LOCATION, length: 100 )
• GREASE ( type: esriFieldTypeString, alias: GREASE, length: 1 , Coded Values: [Y: Yes] , [N: No] , [U: Unknown] )
• GREASE_AREA ( type: esriFieldTypeSmallInteger, alias: GREASE_AREA )
• FREQUENCY ( type: esriFieldTypeSmallInteger, alias: FREQUENCY , Coded Values: [0: One Time] , [1: Monthly] , [2: 2 Months] , ...10 more... )
• LAST_TREATMENT_DATE ( type: esriFieldTypeDate, alias: LAST_TREATMENT_DATE, length: 8 )
• MAP_REF ( type: esriFieldTypeSmallInteger, alias: MAP_REF )
• REVIEW_COMMENT ( type: esriFieldTypeString, alias: REVIEW_COMMENT, length: 255 )
• LENGTH ( type: esriFieldTypeDouble, alias: LENGTH )
• REMOVAL_APPROVED ( type: esriFieldTypeString, alias: REMOVAL_APPROVED, length: 1 , Coded Values: [Y: Yes] , [N: No] , [U: Unknown] )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• PAGE ( type: esriFieldTypeSmallInteger, alias: PAGE )
• PAGE_COUNT ( type: esriFieldTypeSmallInteger, alias: PAGE_COUNT )

Supported Operations:   Query   Query Attachments   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata