Name: High Priority Outfall Inspections

Display Field: inspector

Type: Table

Geometry Type: N/A

Description: N/A

Service Item Id: 6ce326d2b67c4dde9a0925ee4535fcf5

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Feature Draw Order:

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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: N/A

Fields:

• objectid ( nullable: false, alias: OBJECTID, type: esriFieldTypeOID )
• inspector ( nullable: true, length: 50, alias: Inspector, type: esriFieldTypeString )
• inspectdt ( nullable: true, length: 8, alias: Inspection Date, type: esriFieldTypeDate )
• dryweather ( nullable: true, alias: Dry Weather Inspection?, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
• dateprecip ( nullable: true, length: 8, alias: Date of Last Precipitation, type: esriFieldTypeDate )
• amountprecip ( nullable: true, alias: Amount of Last Precipitation, type: esriFieldTypeDouble )
• flow ( nullable: true, alias: Flow Present?, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
• flowcolor ( nullable: true, alias: Flow contains color?, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
• colordesc ( nullable: true, alias: Color Description, type: esriFieldTypeSmallInteger , Coded Values: [1: Redish hue] , [2: Brownish hue] , [3: Yellowish hue] , ...2 more... )
• colordesc_other ( nullable: true, length: 50, alias: Specify other, type: esriFieldTypeString )
• flowodor ( nullable: true, alias: Flow contains odor?, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
• odordesc ( nullable: true, alias: Odor Description, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: Musty] , [2: Sewage] , ...5 more... )
• odordesc_other ( nullable: true, length: 50, alias: Specify other, type: esriFieldTypeString )
• flowfloatable ( nullable: true, alias: Flow contains floatables?, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
• floatabledesc ( nullable: true, length: 255, alias: Floatable Description, type: esriFieldTypeString )
• recievingwater ( nullable: true, alias: Change in recieving water?, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
• recievingwaterdesc ( nullable: true, length: 150, alias: Description of Change, type: esriFieldTypeString )
• illicitdischarge ( nullable: true, alias: Is Flow Illicit Discharge?, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
• illicitdischargesource ( nullable: true, length: 150, alias: Efforts to determine source, type: esriFieldTypeString )
• illicitdischargeaction ( nullable: true, length: 150, alias: Corrective Action Taken, type: esriFieldTypeString )
• notes ( nullable: true, length: 2000, alias: Notes, type: esriFieldTypeString )
• assetguid ( nullable: true, length: 38, alias: Asset GUID, type: esriFieldTypeGUID )
• globalid ( nullable: false, length: 38, alias: globalid, type: esriFieldTypeGUID )
• creationdate ( nullable: true, length: 8, alias: Creation date, type: esriFieldTypeDate )
• creator ( nullable: true, length: 255, alias: Creator, type: esriFieldTypeString )
• lastupdate ( nullable: true, length: 8, alias: Last update, type: esriFieldTypeDate )
• updatedby ( nullable: true, length: 255, alias: Updated by, type: esriFieldTypeString )
• erosion ( nullable: true, alias: Erosion Severity, type: esriFieldTypeSmallInteger , Coded Values: [1: 1 - Channel bottom, toe and bank are stable] , [2: 2 - Channel bottom is scoured, toe & bank are stable] , [4: 4 - Channel bottom scoured, toe is undercut, bank stable] , ...3 more... )
• structure_condition ( nullable: true, alias: Outfall Structural Condition, type: esriFieldTypeSmallInteger , Coded Values: [1: 1 - No signs of failure] , [2: 2 - Cracks are present] , [5: 5 - Structure has moved from original constructure location] , ...2 more... )
• turbidity ( nullable: true, alias: Turbidity, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: Clear] , [2: Slighly Cloudy] , ...2 more... )
• GlobalID_1 ( nullable: false, length: 38, alias: GlobalID_1, type: esriFieldTypeGlobalID )
• inspector2 ( nullable: true, alias: inspector2, type: esriFieldTypeSmallInteger , Coded Values: [1: JSHELTON] , [2: JHOPWOOD] , [3: JMANKLE] , ...5 more... )
• maintenance_required ( nullable: true, alias: maintenance_required, type: esriFieldTypeSmallInteger , Coded Values: [1: 1 - No maintenance required] , [2: 2 - Minor maintenance required (Flow not impeded / routine cleaning only)] , [5: 5 - Moderate maintenance required (Flow impeded / immediate cleaning necessary)] , ...1 more... )
• maintenance_note ( nullable: true, length: 255, alias: maintenance_note, type: esriFieldTypeString )

Relationships:

• SDE.StormwaterDevice (0) -- Related To: High Priority Outfalls (0)

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

  Iteminfo   Thumbnail   Metadata