Name: Detention Basins

Display Field: DetBasinID

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: Geography and attributes complete from inspections cir 1999, list available, CAD drawing cir 2007. Also attachments added of Inspection forms, photos, descriptions.

Service Item Id: e646768a0eba4592bbbe5f59d9fdfa9e

Copyright Text: City of Kettering

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 1488961.7848172756
YMin: 607366.6499611139
XMax: 1517293.7075076504
YMax: 633386.1799429506
Spatial Reference: 102723  (3735)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: RESPONSIBILITY
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSFSSolid
Color: [255, 0, 0, 255]
Outline:
Style: esriSLSSolid
Color: [110, 110, 110, 255]
Width: 0
Default Label: No Data
UniqueValueInfos:
• Value: City
  Label: City
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [82, 91, 186, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Value: Easement / Private
  Label: Easement / Private
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [169, 237, 123, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Value: Private
  Label: Private
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [230, 112, 106, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Value: Private (No esmt on record)
  Label: Private (No esmt on record)
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [84, 153, 156, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
Transparency: 51
Labeling Info:

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: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: true

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• DetBasinID ( type: esriFieldTypeString, alias: DetBasinID, length: 50 )
• LOCATION ( type: esriFieldTypeString, alias: LOCATION, length: 255 )
• OWNER ( type: esriFieldTypeString, alias: OWNER, length: 255 , Coded Values: [City: City] , [Private: Private] )
• RESPONSIBILITY ( type: esriFieldTypeString, alias: RESPONSIBILITY, length: 255 , Coded Values: [City: City] , [Easement / Private: Easement / Private] , [Private: Private] , ...1 more... )
• DetBasinIDInt ( type: esriFieldTypeSmallInteger, alias: DetBasinIDInt )
• DescriptionAttachKey ( type: esriFieldTypeString, alias: DescriptionAttachKey, length: 50 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• UniqueID ( type: esriFieldTypeString, alias: UniqueID, length: 50 )
• StreetDist ( type: esriFieldTypeString, alias: StreetDist, length: 50 )
• Shape.STArea() ( type: esriFieldTypeDouble, alias: Shape.STArea() )
• Shape.STLength() ( type: esriFieldTypeDouble, alias: Shape.STLength() )
• BasinClassification ( type: esriFieldTypeString, alias: Basin Classification, length: 255 , Coded Values: [Low Hazard: Low Hazard] , [High Hazard: High Hazard] , [Significant Hazard: Significant Hazard] )
• SafetyInsp ( type: esriFieldTypeString, alias: Safety Inspection Required, length: 255 , Coded Values: [No: No] , [Yes: Yes] )
• DateInspected ( type: esriFieldTypeDate, alias: Date Inspected, length: 8 )
• Weather ( type: esriFieldTypeString, alias: Weather, length: 255 , Coded Values: [Clear: Clear] , [Rain: Rain] , [Snow: Snow] )
• Temperature ( type: esriFieldTypeString, alias: Temperature, length: 255 , Coded Values: [20: 20's] , [30: 30's] , [40: 40's] , ...5 more... )
• Remark1 ( type: esriFieldTypeString, alias: Remark #1, length: 255 )
• Remark2 ( type: esriFieldTypeString, alias: Remark #2, length: 255 )
• Remark3 ( type: esriFieldTypeString, alias: Remark#3, length: 255 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• Watershed ( type: esriFieldTypeSmallInteger, alias: Estimated Watershed (Acres) )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• BasinTypeRemarks ( type: esriFieldTypeString, alias: Basin Type Remarks, length: 255 )
• StructureRemarks ( type: esriFieldTypeString, alias: Structure Remarks, length: 255 )
• PhotoRemarks ( type: esriFieldTypeString, alias: Photo Remarks, length: 255 )
• InspectorRemarks ( type: esriFieldTypeString, alias: Inspector Remarks, length: 255 )
• RemarksLetter ( type: esriFieldTypeString, alias: Remarks for the Letter, length: 255 )
• Inspector ( type: esriFieldTypeString, alias: Inspector, length: 255 , Coded Values: [BMW: BMW] , [CEI: CEI] , [DLA: DLA] , ...5 more... )
• BasinType ( type: esriFieldTypeString, alias: Basin type, length: 255 , Coded Values: [Detention: Detention] , [Retention: Retention] , [Underground: Underground] , ...1 more... )
• LasrRainfall ( type: esriFieldTypeString, alias: Last Rainfall Event, length: 255 , Coded Values: [< 24 Hours: < 24 Hours] , [24-72 Hours: 24-72 Hours] , [>72 Hours: > 72 Hours] )
• DetentionSturcture ( type: esriFieldTypeString, alias: Structures, length: 255 , Coded Values: [Fountain: Fountain] , [Inlet Basin: Inlet Basin] , [Emergency Spillway: Emergency Spillway] , ...3 more... )
• InsepctionCondition ( type: esriFieldTypeString, alias: Inspection Condition, length: 255 , Coded Values: [Good Condition: 1 Good. Well maintained, no action required.] , [Moderate Condition: 2 Moderate. Adequately maintained, routine maintenance needed.] , [Serious Condition: 3 Serious. Immediate need for repair or replacement.] , ...1 more... )
• OwnerName ( type: esriFieldTypeString, alias: Owner Name, length: 255 )
• Sediment1 ( type: esriFieldTypeString, alias: Sediment1, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Trash1 ( type: esriFieldTypeString, alias: Trash1, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Water2 ( type: esriFieldTypeString, alias: Water2, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Structural3 ( type: esriFieldTypeString, alias: Structural3, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Sediment3 ( type: esriFieldTypeString, alias: Sediment3, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Erosion3 ( type: esriFieldTypeString, alias: Erosion3, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Sinkhole4 ( type: esriFieldTypeString, alias: Sinkhole4, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Tree4 ( type: esriFieldTypeString, alias: Tree4, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Trash5 ( type: esriFieldTypeString, alias: Trash5, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Plant5 ( type: esriFieldTypeString, alias: Plant5, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Erosion5 ( type: esriFieldTypeString, alias: Erosion5, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Sediment5 ( type: esriFieldTypeString, alias: Sediment5, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Sinkhole5 ( type: esriFieldTypeString, alias: Sinkhole5, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Erosion6 ( type: esriFieldTypeString, alias: Erosion6, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Sinkhole6 ( type: esriFieldTypeString, alias: Sinkhole6, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Structural7 ( type: esriFieldTypeString, alias: Structural7, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Sediment7 ( type: esriFieldTypeString, alias: Sediment7, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Erosion7 ( type: esriFieldTypeString, alias: Erosion7, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Joint7 ( type: esriFieldTypeString, alias: Joint7, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• LastInsp ( type: esriFieldTypeDate, alias: LastInsp, length: 8 )
• Rain ( type: esriFieldTypeString, alias: Rain, length: 10 , Coded Values: [No: No] , [Yes: Yes] , [Comment: See Comment] )
• RainAmt ( type: esriFieldTypeString, alias: RainAmt, length: 200 )
• Pretreatment ( type: esriFieldTypeString, alias: Pretreatment, length: 200 )
• SitePlan ( type: esriFieldTypeString, alias: SitePlan, length: 10 , Coded Values: [No: No] , [Yes: Yes] , [Comment: See Comment] )
• SinkholeSeep ( type: esriFieldTypeString, alias: SinkholeSeep, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Trash4b ( type: esriFieldTypeString, alias: Trash4b, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Sediment5b ( type: esriFieldTypeString, alias: Sediment5b, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Plants5 ( type: esriFieldTypeString, alias: Plants5, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Erosion5b ( type: esriFieldTypeString, alias: Erosion5b, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Algae5 ( type: esriFieldTypeString, alias: Algae5, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Height6 ( type: esriFieldTypeString, alias: Height6, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• SedimentChamber ( type: esriFieldTypeString, alias: SedimentChamber, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• TrashChamber ( type: esriFieldTypeString, alias: TrashChamber, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• WetWeather ( type: esriFieldTypeString, alias: WetWeather, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• StructureOther ( type: esriFieldTypeString, alias: StructureOther, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Ponding ( type: esriFieldTypeString, alias: Ponding, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Convey ( type: esriFieldTypeString, alias: Convey, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• CommentPretreat ( type: esriFieldTypeString, alias: CommentPretreat, length: 255 )
• CommentDewater ( type: esriFieldTypeString, alias: CommentDewater, length: 255 )
• CommentInlet ( type: esriFieldTypeString, alias: CommentInlet, length: 255 )
• CommentChamber ( type: esriFieldTypeString, alias: CommentChamber, length: 255 )
• CommentEmbank ( type: esriFieldTypeString, alias: CommentEmbank, length: 255 )
• CommentOtherSys ( type: esriFieldTypeString, alias: CommentOtherSys, length: 255 )
• CommentBasinBowl ( type: esriFieldTypeString, alias: CommentBasinBowl, length: 255 )
• CommentBasinPerm ( type: esriFieldTypeString, alias: CommentBasinPerm, length: 255 )
• CommentSide ( type: esriFieldTypeString, alias: CommentSide, length: 255 )
• CommentOutlet ( type: esriFieldTypeString, alias: CommentOutlet, length: 255 )
• CommentOther ( type: esriFieldTypeString, alias: CommentOther, length: 255 )
• VegWilt ( type: esriFieldTypeString, alias: VegWilt, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• VegMow ( type: esriFieldTypeString, alias: VegMow, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• TrashBio ( type: esriFieldTypeString, alias: TrashBio, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• SedimentBio ( type: esriFieldTypeString, alias: SedimentBio, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• TopmostLayer ( type: esriFieldTypeString, alias: TopmostLayer, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• ErosionBio ( type: esriFieldTypeString, alias: ErosionBio, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Mulch ( type: esriFieldTypeString, alias: Mulch, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• SinkholeBio ( type: esriFieldTypeString, alias: SinkholeBio, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• CommentVeg ( type: esriFieldTypeString, alias: CommentVeg, length: 255 )
• CommentBio ( type: esriFieldTypeString, alias: CommentBio, length: 255 )

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

  Iteminfo   Thumbnail   Metadata