Name: Open Channels and Ditches Inspection Table

Display Field: streetnameno

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: da928797e44d46e39b5e8d8ce1b78bb2

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
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: null

Fields:

• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• surveyedby ( type: esriFieldTypeString, alias: Surveyed by, length: 100 )
• reviewedby ( type: esriFieldTypeString, alias: Reviewed by, length: 100 )
• owner ( type: esriFieldTypeString, alias: Owner (Public or Private), length: 20 , Coded Values: [PUBLIC: PUBLIC] , [PRIVATE: PRIVATE] )
• ifpublic ( type: esriFieldTypeString, alias: IF PUBLIC, length: 25 , Coded Values: [COH: COH] , [STATE: STATE] , [COUNTY: COUNTY] )
• ifprivate ( type: esriFieldTypeString, alias: IF PRIVATE, length: 25 , Coded Values: [COMMERCIAL: COMMERCIAL] , [RESIDENTIAL: RESIDENTIAL] , [HOA/COLLECTIVE: HOA/COLLECTIVE] )
• bmpfordevelopment ( type: esriFieldTypeString, alias: BMP for a Development?, length: 10 , Coded Values: [YES: YES] , [NO: NO] )
• hasbeenmaintained ( type: esriFieldTypeString, alias: From first appearance, has it been maintained?, length: 10 , Coded Values: [YES: YES] , [NO: NO] )
• project ( type: esriFieldTypeString, alias: Project, length: 100 , Coded Values: [2025 STORMWATER ASSET INVENTORY: 2025 STORMWATER ASSET INVENTORY] )
• inspectiondate ( type: esriFieldTypeDate, alias: Inspection Date, length: 8 )
• weather ( type: esriFieldTypeString, alias: Weather, length: 50 , Coded Values: [DRY: DRY] , [HEAVY RAIN: HEAVY RAIN] , [LIGHT RAIN: LIGHT RAIN] , ...2 more... )
• precleaning ( type: esriFieldTypeString, alias: Pre-Cleaning?, length: 50 , Coded Values: [HEAVY CLEANING: HEAVY CLEANING] , [LIGHT CLEANING (JETTING): LIGHT CLEANING (JETTING)] , [NO PRE-CLEAN: NO PRE-CLEAN] , ...3 more... )
• lastmaintenancedate ( type: esriFieldTypeDate, alias: Date Last Maintained, length: 8 )
• directionofsurvey ( type: esriFieldTypeString, alias: Direction of Survey, length: 255 )
• inspectionstatus ( type: esriFieldTypeString, alias: Inspection Status, length: 50 , Coded Values: [COMPLETED INSPECTION: COMPLETED INSPECTION] , [BURIED AND MARKED: BURIED AND MARKED] , [NO ACCESS: NO ACCESS] , ...6 more... )
• consequenceoffailure ( type: esriFieldTypeString, alias: Consequence of failure , length: 255 )
• rainfall ( type: esriFieldTypeString, alias: Rainfall in the last 48 hours, length: 10 , Coded Values: [YES: YES] , [NO: NO] )
• rainfallinches ( type: esriFieldTypeDouble, alias: If yes, how much? )
• landusen ( type: esriFieldTypeString, alias: Land Use North, length: 25 , Coded Values: [RESIDENTIAL: RESIDENTIAL] , [COMMERCIAL: COMMERCIAL] , [INDUSTRIAL: INDUSTRIAL] , ...2 more... )
• landuses ( type: esriFieldTypeString, alias: Land Use South, length: 25 , Coded Values: [RESIDENTIAL: RESIDENTIAL] , [COMMERCIAL: COMMERCIAL] , [INDUSTRIAL: INDUSTRIAL] , ...2 more... )
• landusee ( type: esriFieldTypeString, alias: Land Use East, length: 25 , Coded Values: [RESIDENTIAL: RESIDENTIAL] , [COMMERCIAL: COMMERCIAL] , [INDUSTRIAL: INDUSTRIAL] , ...2 more... )
• landusew ( type: esriFieldTypeString, alias: Land Use West, length: 25 , Coded Values: [RESIDENTIAL: RESIDENTIAL] , [COMMERCIAL: COMMERCIAL] , [INDUSTRIAL: INDUSTRIAL] , ...2 more... )
• landusedescription ( type: esriFieldTypeString, alias: Land Use Description, length: 255 )
• drainagearea ( type: esriFieldTypeString, alias: Drainage Area, length: 10 , Coded Values: [TUR: TUR] , [DER: DER] , [DUC: DUC] , ...3 more... )
• streetnameno ( type: esriFieldTypeString, alias: Street (Name & Number), length: 255 )
• city ( type: esriFieldTypeString, alias: City, length: 20 , Coded Values: [HOBART: HOBART] , [MERRILLVILLE: MERRILLVILLE] )
• locationcode ( type: esriFieldTypeString, alias: Location Code, length: 50 , Coded Values: [PRIMARY MAJOR ARTERIAL ROAD: PRIMARY MAJOR ARTERIAL ROAD] , [SECONDARY ROAD: SECONDARY ROAD] , [LOCAL/RURAL STREET: LOCAL/RURAL STREET] , ...15 more... )
• locationdetails ( type: esriFieldTypeString, alias: Location Details, length: 255 )
• usintakenorthing ( type: esriFieldTypeDouble, alias: US Intake Northing )
• usintakeeasting ( type: esriFieldTypeDouble, alias: US Intake Easting )
• usintakeelevationlowestpoint ( type: esriFieldTypeDouble, alias: US Intake elevation (lowest point) )
• dsoutletnorthing ( type: esriFieldTypeDouble, alias: DS Outlet Northing )
• dsoutleteasting ( type: esriFieldTypeDouble, alias: DS Outlet Easting )
• dsoutletelevationlowestpoint ( type: esriFieldTypeDouble, alias: DS Outlet elevation (lowest point) )
• coordinatesystem ( type: esriFieldTypeString, alias: Coordinate System, length: 100 )
• verticaldatum ( type: esriFieldTypeString, alias: Vertical Datum, length: 100 )
• gpsaccuracy ( type: esriFieldTypeString, alias: GPS Accuracy, length: 25 , Coded Values: [SURVEY GRADE: SURVEY GRADE] )
• dischargesto ( type: esriFieldTypeString, alias: Discharges to?, length: 50 , Coded Values: [LAKE: LAKE] , [STREAM: STREAM] , [RIVER: RIVER] , ...8 more... )
• receptacleid ( type: esriFieldTypeString, alias: Receptacle ID, length: 100 )
• assetid ( type: esriFieldTypeString, alias: Asset ID, length: 100 )
• assettype ( type: esriFieldTypeString, alias: Asset Type, length: 30 , Coded Values: [OPEN CHANNEL: OPEN CHANNEL] , [ROAD SIDE DITCH: ROAD SIDE DITCH] , [SWALE: SWALE] )
• openchanneltype ( type: esriFieldTypeString, alias: Open Channel Type, length: 20 , Coded Values: [NATURAL: NATURAL] , [VEGETATED: VEGETATED] , [HARDENED: HARDENED] )
• depth ( type: esriFieldTypeDouble, alias: Depth )
• width ( type: esriFieldTypeDouble, alias: Width )
• featureshape ( type: esriFieldTypeString, alias: Shape, length: 10 , Coded Values: [V: V] , [U: U] , [FLAT: FLAT] )
• totallength ( type: esriFieldTypeDouble, alias: Total Length )
• lengthsurveyed ( type: esriFieldTypeDouble, alias: Length Surveyed )
• erosionsigns ( type: esriFieldTypeString, alias: Signs of Erosion?, length: 10 , Coded Values: [YES: YES] , [NO: NO] )
• cracksordamage ( type: esriFieldTypeString, alias: Presence of Cracks or Damage?, length: 10 , Coded Values: [YES: YES] , [NO: NO] )
• settlementorshifting ( type: esriFieldTypeString, alias: Settlement or shifting?, length: 50 , Coded Values: [SETTLEMENT: SETTLEMENT] , [SHIFTING: SHIFTING] , [BOTH SETTLEMENT AND SHIFTING: BOTH SETTLEMENT AND SHIFTING] , ...1 more... )
• floodingevidence ( type: esriFieldTypeString, alias: Evidence of Flooding?, length: 10 , Coded Values: [YES: YES] , [NO: NO] )
• flowcontrol ( type: esriFieldTypeString, alias: Flow Control, length: 10 , Coded Values: [YES: YES] , [NO: NO] )
• flowobservations ( type: esriFieldTypeString, alias: Flow Observations, length: 255 )
• sedimentdebris ( type: esriFieldTypeString, alias: Sediment & Debris Build-Up?, length: 20 , Coded Values: [NONE: NONE] , [LOW: LOW] , [MEDIUM: MEDIUM] , ...1 more... )
• typeofdebris ( type: esriFieldTypeString, alias: Type of Debris (e.g., leaves, trash), length: 255 )
• upstreamassetidnumber ( type: esriFieldTypeString, alias: Upstream Asset ID Number, length: 100 )
• downstreamassetidnumber ( type: esriFieldTypeString, alias: Downstream Asset ID Number, length: 100 )
• globalid ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• obstruction ( type: esriFieldTypeString, alias: Obstruction?, length: 255 , Coded Values: [Blocked By Pavement (Without Culvert): Blocked By Pavement (Without Culvert)] , [Blocked By Structure: Blocked By Structure] , [Blocked By Vegetation: Blocked By Vegetation] , ...2 more... )

Relationships:

• geohub.GIS.OpenChannelsAndDitches (4) -- Related To: Open Channels and Ditches (4)

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

  Iteminfo   Thumbnail   Metadata