Name: Outlets and Discharges Inspection Table

Display Field: streetnameno

Type: Table

Geometry Type: N/A

Description:

Service Item Id: fd0a0b99e90d43a0a3d4f7619024af0b

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
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: false
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:

Fields:

• objectid ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: objectid )
• surveyedby ( type: esriFieldTypeString, alias: Surveyed By, editable: true, nullable: true, length: 100, defaultValue: null, modelName: surveyedby )
• certificateno ( type: esriFieldTypeString, alias: Certificate #, editable: true, nullable: true, length: 100, defaultValue: null, modelName: certificateno )
• reviewedby ( type: esriFieldTypeString, alias: Reviewed By, editable: true, nullable: true, length: 100, defaultValue: null, modelName: reviewedby )
• owner ( type: esriFieldTypeString, alias: Owner (Public or Private), editable: true, nullable: true, length: 20, defaultValue: null, modelName: owner , Coded Values: [PUBLIC: PUBLIC] , [PRIVATE: PRIVATE] )
• ifpublic ( type: esriFieldTypeString, alias: IF PUBLIC, editable: true, nullable: true, length: 25, defaultValue: null, modelName: ifpublic , Coded Values: [COH: COH] , [STATE: STATE] , [COUNTY: COUNTY] )
• ifprivate ( type: esriFieldTypeString, alias: IF PRIVATE, editable: true, nullable: true, length: 25, defaultValue: null, modelName: ifprivate , Coded Values: [COMMERCIAL: COMMERCIAL] , [RESIDENTIAL: RESIDENTIAL] , [HOA/COLLECTIVE: HOA/COLLECTIVE] )
• bmpfordevelopment ( type: esriFieldTypeString, alias: BMP for a Development?, editable: true, nullable: true, length: 10, defaultValue: null, modelName: bmpfordevelopment , Coded Values: [YES: YES] , [NO: NO] )
• hasbeenmaintained ( type: esriFieldTypeString, alias: From first appearance, has it been maintained?, editable: true, nullable: true, length: 10, defaultValue: null, modelName: hasbeenmaintained , Coded Values: [YES: YES] , [NO: NO] )
• project ( type: esriFieldTypeString, alias: Project, editable: true, nullable: true, length: 100, defaultValue: 2025 STORMWATER ASSET INVENTORY, modelName: project , Coded Values: [2025 STORMWATER ASSET INVENTORY: 2025 STORMWATER ASSET INVENTORY] )
• inspectiondate ( type: esriFieldTypeDate, alias: Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: inspectiondate )
• installdate ( type: esriFieldTypeDate, alias: Installation Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: installdate )
• weather ( type: esriFieldTypeString, alias: Weather, editable: true, nullable: true, length: 50, defaultValue: null, modelName: weather , Coded Values: [DRY: DRY] , [HEAVY RAIN: HEAVY RAIN] , [LIGHT RAIN: LIGHT RAIN] , ...2 more... )
• precleaning ( type: esriFieldTypeString, alias: Pre-Cleaning?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: precleaning , 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, editable: true, nullable: true, length: 8, defaultValue: null, modelName: lastmaintenancedate )
• directionofsurvey ( type: esriFieldTypeString, alias: Direction of Survey, editable: true, nullable: true, length: 255, defaultValue: null, modelName: directionofsurvey )
• inspectionstatus ( type: esriFieldTypeString, alias: Inspection Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: inspectionstatus , 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 , editable: true, nullable: true, length: 255, defaultValue: null, modelName: consequenceoffailure )
• rainfall ( type: esriFieldTypeString, alias: Rainfall in the last 48 hours, editable: true, nullable: true, length: 10, defaultValue: null, modelName: rainfall , Coded Values: [YES: YES] , [NO: NO] )
• rainfallinches ( type: esriFieldTypeDouble, alias: If yes, how much?, editable: true, nullable: true, defaultValue: null, modelName: rainfallinches )
• landusen ( type: esriFieldTypeString, alias: Land Use North, editable: true, nullable: true, length: 25, defaultValue: null, modelName: landusen , Coded Values: [RESIDENTIAL: RESIDENTIAL] , [COMMERCIAL: COMMERCIAL] , [INDUSTRIAL: INDUSTRIAL] , ...2 more... )
• landuses ( type: esriFieldTypeString, alias: Land Use South, editable: true, nullable: true, length: 25, defaultValue: null, modelName: landuses , Coded Values: [RESIDENTIAL: RESIDENTIAL] , [COMMERCIAL: COMMERCIAL] , [INDUSTRIAL: INDUSTRIAL] , ...2 more... )
• landusee ( type: esriFieldTypeString, alias: Land Use East, editable: true, nullable: true, length: 25, defaultValue: null, modelName: landusee , Coded Values: [RESIDENTIAL: RESIDENTIAL] , [COMMERCIAL: COMMERCIAL] , [INDUSTRIAL: INDUSTRIAL] , ...2 more... )
• landusew ( type: esriFieldTypeString, alias: Land Use West, editable: true, nullable: true, length: 25, defaultValue: null, modelName: landusew , Coded Values: [RESIDENTIAL: RESIDENTIAL] , [COMMERCIAL: COMMERCIAL] , [INDUSTRIAL: INDUSTRIAL] , ...2 more... )
• landusedescription ( type: esriFieldTypeString, alias: Land Use Description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: landusedescription )
• huc12_code ( type: esriFieldTypeString, alias: HUC12 Code, editable: true, nullable: true, length: 25, defaultValue: null, modelName: huc12_code , Coded Values: [040400010507: 040400010507] , [040400010505: 040400010505] , [040400010508: 040400010508] , ...3 more... )
• drainagearea ( type: esriFieldTypeString, alias: Drainage Area, editable: true, nullable: true, length: 10, defaultValue: null, modelName: drainagearea , Coded Values: [TUR: TUR] , [DER: DER] , [DUC: DUC] , ...3 more... )
• assetid ( type: esriFieldTypeString, alias: Asset ID, editable: true, nullable: true, length: 100, defaultValue: null, modelName: assetid )
• streetnameno ( type: esriFieldTypeString, alias: Street (Name & Number), editable: true, nullable: true, length: 255, defaultValue: null, modelName: streetnameno )
• city ( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 20, defaultValue: null, modelName: city , Coded Values: [HOBART: HOBART] , [MERRILLVILLE: MERRILLVILLE] )
• locationcode ( type: esriFieldTypeString, alias: Location Code, editable: true, nullable: true, length: 50, defaultValue: null, modelName: locationcode , 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, editable: true, nullable: true, length: 255, defaultValue: null, modelName: locationdetails )
• gradetoinvert ( type: esriFieldTypeDouble, alias: Grade to invert, editable: true, nullable: true, defaultValue: null, modelName: gradetoinvert )
• northing ( type: esriFieldTypeDouble, alias: Northing, editable: true, nullable: true, defaultValue: null, modelName: northing )
• easting ( type: esriFieldTypeDouble, alias: Easting, editable: true, nullable: true, defaultValue: null, modelName: easting )
• elevation ( type: esriFieldTypeDouble, alias: Elevation, editable: true, nullable: true, defaultValue: null, modelName: elevation )
• coordinatesystem ( type: esriFieldTypeString, alias: Coordinate System, editable: true, nullable: true, length: 100, defaultValue: null, modelName: coordinatesystem )
• verticaldatum ( type: esriFieldTypeString, alias: Vertical Datum, editable: true, nullable: true, length: 100, defaultValue: null, modelName: verticaldatum )
• gpsaccuracy ( type: esriFieldTypeString, alias: GPS Accuracy, editable: true, nullable: true, length: 25, defaultValue: SURVEY GRADE, modelName: gpsaccuracy , Coded Values: [SURVEY GRADE: SURVEY GRADE] )
• assettype ( type: esriFieldTypeString, alias: Asset Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: assettype , Coded Values: [TREATED OUTLET: TREATED OUTLET] , [OUTFALL: OUTFALL] , [TERMINAL DISCHARGE POINT: TERMINAL DISCHARGE POINT] , ...2 more... )
• dischargesto ( type: esriFieldTypeString, alias: Discharges to?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: dischargesto , Coded Values: [LAKE: LAKE] , [STREAM: STREAM] , [RIVER: RIVER] , ...8 more... )
• receptacleid ( type: esriFieldTypeString, alias: Receptacle ID, editable: true, nullable: true, length: 100, defaultValue: null, modelName: receptacleid )
• height ( type: esriFieldTypeDouble, alias: Height (Diameter), editable: true, nullable: true, defaultValue: null, modelName: height )
• pipethickness ( type: esriFieldTypeDouble, alias: Pipe thickness, editable: true, nullable: true, defaultValue: null, modelName: pipethickness )
• featureshape ( type: esriFieldTypeString, alias: Shape, editable: true, nullable: true, length: 50, defaultValue: null, modelName: featureshape , Coded Values: [ARCHED (WITH FLAT BOTTOM): ARCHED (WITH FLAT BOTTOM)] , [BARREL: BARREL] , [CIRCULAR: CIRCULAR] , ...6 more... )
• material ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 50, defaultValue: null, modelName: material , Coded Values: [ABS: ABS] , [ASBESTOS CEMENT: ASBESTOS CEMENT] , [BRICK: BRICK] , ...21 more... )
• liningmethod ( type: esriFieldTypeString, alias: Lining/Coating Method, editable: true, nullable: true, length: 50, defaultValue: null, modelName: liningmethod , Coded Values: [CURED-IN-PLACE PIPE: CURED-IN-PLACE PIPE] , [FOLD AND FORM OR DEFORM/REFORM: FOLD AND FORM OR DEFORM/REFORM] , [FORMED-IN-PLACE LINER: FORMED-IN-PLACE LINER] , ...9 more... )
• indcomdisch ( type: esriFieldTypeString, alias: Industrial or Commercial Discharge, editable: true, nullable: true, length: 10, defaultValue: null, modelName: indcomdisch , Coded Values: [YES: YES] , [NO: NO] )
• erosionsigns ( type: esriFieldTypeString, alias: Signs of Erosion?, editable: true, nullable: true, length: 10, defaultValue: null, modelName: erosionsigns , Coded Values: [YES: YES] , [NO: NO] )
• erosionextent ( type: esriFieldTypeString, alias: Erosion Extent, editable: true, nullable: true, length: 10, defaultValue: null, modelName: erosionextent , Coded Values: [NO: NO EROSION DAMAGE] , [<100: LESS THAN 100 FT2] , [100-500: 100 FT2 TO 500 FT2] , ...1 more... )
• condition ( type: esriFieldTypeString, alias: Condition, editable: true, nullable: true, length: 5, defaultValue: null, modelName: condition , Coded Values: [NO: NO DAMAGE] , [CRK: CRACKING] , [SPL: SPALLING] , ...3 more... )
• cracksordamage ( type: esriFieldTypeString, alias: Presence of Cracks or Damage?, editable: true, nullable: true, length: 10, defaultValue: null, modelName: cracksordamage , Coded Values: [YES: YES] , [NO: NO] )
• settlementorshifting ( type: esriFieldTypeString, alias: Settlement or Shifting?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: settlementorshifting , Coded Values: [SETTLEMENT: SETTLEMENT] , [SHIFTING: SHIFTING] , [BOTH SETTLEMENT AND SHIFTING: BOTH SETTLEMENT AND SHIFTING] , ...1 more... )
• floodingevidence ( type: esriFieldTypeString, alias: Evidence of Flooding?, editable: true, nullable: true, length: 10, defaultValue: null, modelName: floodingevidence , Coded Values: [YES: YES] , [NO: NO] )
• flowcontrol ( type: esriFieldTypeString, alias: Flow Control, editable: true, nullable: true, length: 10, defaultValue: null, modelName: flowcontrol , Coded Values: [YES: YES] , [NO: NO] )
• flowobservations ( type: esriFieldTypeString, alias: Flow Observations, editable: true, nullable: true, length: 5, defaultValue: null, modelName: flowobservations , Coded Values: [NONE: NO FLOW] , [TKL: TRICKLE] , [MOD: MODERATE] , ...2 more... )
• sedimentdebris ( type: esriFieldTypeString, alias: Sediment & Debris Build-Up?, editable: true, nullable: true, length: 20, defaultValue: null, modelName: sedimentdebris , Coded Values: [NONE: NONE] , [LOW: LOW] , [MEDIUM: MEDIUM] , ...1 more... )
• odor ( type: esriFieldTypeString, alias: Odor, editable: true, nullable: true, length: 5, defaultValue: null, modelName: odor , Coded Values: [SEW: SEWAGE] , [SUL: SULFIDE] , [OIL: OIL] , ...4 more... )
• color ( type: esriFieldTypeString, alias: Color, editable: true, nullable: true, length: 5, defaultValue: null, modelName: color , Coded Values: [BR: BROWN] , [CL: CLEAR] , [GR: GRAY] , ...4 more... )
• turbidity ( type: esriFieldTypeString, alias: Turbidity, editable: true, nullable: true, length: 5, defaultValue: null, modelName: turbidity , Coded Values: [CL: CLEAR] , [CLD: CLOUDY] , [OPQ: OPAQUE] , ...2 more... )
• floatables ( type: esriFieldTypeString, alias: Floatables, editable: true, nullable: true, length: 5, defaultValue: null, modelName: floatables , Coded Values: [NO: NO FLOATABLES] , [PET: PETROLEUM SLICK] , [SEW: RAW SEWAGE] , ...4 more... )
• deposits ( type: esriFieldTypeString, alias: Deposits, editable: true, nullable: true, length: 5, defaultValue: null, modelName: deposits , Coded Values: [OIL: OILY] , [FL: FLOW LINE] , [PT: PAINT] , ...3 more... )
• vegetation ( type: esriFieldTypeString, alias: Vegetation, editable: true, nullable: true, length: 5, defaultValue: null, modelName: vegetation , Coded Values: [NRM: NORMAL GROWTH] , [EXG: EXCESSIVE GROWTH] , [ING: INHIBITED GROWTH] , ...1 more... )
• typeofdebris ( type: esriFieldTypeString, alias: Type of Debris (e.g., leaves, trash), editable: true, nullable: true, length: 255, defaultValue: null, modelName: typeofdebris )
• dissipator ( type: esriFieldTypeString, alias: Is there riprap or an energy dissipator?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: dissipator , Coded Values: [RIPRAP: RIPRAP] , [ENERGY DISSIPATOR: ENERGY DISSIPATOR] , [nan: nan] )
• maintenancepriority ( type: esriFieldTypeString, alias: Maintenance Priority, editable: true, nullable: true, length: 5, defaultValue: null, modelName: maintenancepriority , Coded Values: [1: PRIORITY 1] , [2: PRIORITY 2] , [3: PRIORITY 3] )
• grate ( type: esriFieldTypeString, alias: Grate, editable: true, nullable: true, length: 10, defaultValue: null, modelName: grate , Coded Values: [YES: YES] , [NO: NO] )
• endsection ( type: esriFieldTypeString, alias: EndSection, editable: true, nullable: true, length: 10, defaultValue: null, modelName: endsection , Coded Values: [YES: YES] , [NO: NO] )
• comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 500, defaultValue: null, modelName: comments )
• totallength ( type: esriFieldTypeDouble, alias: Total Length, editable: true, nullable: true, defaultValue: null, modelName: totallength )
• ripraplength ( type: esriFieldTypeDouble, alias: Length of RipRap (Feet), editable: true, nullable: true, defaultValue: null, modelName: ripraplength )
• lengthsurveyed ( type: esriFieldTypeDouble, alias: Length Surveyed, editable: true, nullable: true, defaultValue: null, modelName: lengthsurveyed )
• globalid ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: globalid )
• invertelevation ( type: esriFieldTypeDouble, alias: Invert Elevation, editable: true, nullable: true, defaultValue: null, modelName: invertelevation )

Templates:

• Name: Outlets and Discharges Inspection Table
  Description:
  Prototype:
  invertelevation: null
  lengthsurveyed: null
  surveyedby: null
  certificateno: null
  reviewedby: null
  owner: null
  ifpublic: null
  ifprivate: null
  bmpfordevelopment: null
  hasbeenmaintained: null
  project: 2025 STORMWATER ASSET INVENTORY
  inspectiondate: null
  installdate: null
  weather: null
  precleaning: null
  lastmaintenancedate: null
  directionofsurvey: null
  inspectionstatus: null
  consequenceoffailure: null
  rainfall: null
  rainfallinches: null
  landusen: null
  landuses: null
  landusee: null
  landusew: null
  landusedescription: null
  huc12_code: null
  drainagearea: null
  assetid: null
  streetnameno: null
  city: null
  locationcode: null
  locationdetails: null
  gradetoinvert: null
  northing: null
  easting: null
  elevation: null
  coordinatesystem: null
  verticaldatum: null
  gpsaccuracy: SURVEY GRADE
  assettype: null
  dischargesto: null
  receptacleid: null
  height: null
  pipethickness: null
  featureshape: null
  material: null
  liningmethod: null
  indcomdisch: null
  erosionsigns: null
  erosionextent: null
  condition: null
  cracksordamage: null
  settlementorshifting: null
  floodingevidence: null
  flowcontrol: null
  flowobservations: null
  sedimentdebris: null
  odor: null
  color: null
  turbidity: null
  floatables: null
  deposits: null
  vegetation: null
  typeofdebris: null
  dissipator: null
  maintenancepriority: null
  grate: null
  endsection: null
  comments: null
  totallength: null
  ripraplength: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• geohub.GIS.OutletsAndDischarges (2) -- Related To: Outlets and Discharges (2)

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata