Parent Layer: Storm Sewer Dataset

Name: Catch Basin

Display Field: stoinlt_id

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This feature class denotes the location of known storm sewer inlet points, also known as catch basins, within the City of Sterling Heights. These catch basins are located on streets, in parking lots and in grassy areas, and are the main entry points for water to enter the City's storm system. These structures were field located with sub foot accuracy between September 2017 and June 2018, and were built using a combination of existing Microstation data, scanned plan and as-built drawings. In all, there are approximately 30,000 catch basins within the City.

Service Item Id: d4fbd91c53934b70aec40a98d3e8cdf5

Copyright Text: The City of Sterling Heights

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Effective Min Scale: 10000

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: true

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 1.3466596916338578E7
YMin: 379784.5344488174
XMax: 1.349992881036745E7
YMax: 413982.3057742715
Spatial Reference: PROJCS["NAD_1983_HARN_StatePlane_Michigan_South_FIPS_2113_Feet_Intl",GEOGCS["GCS_North_American_1983_HARN",DATUM["D_North_American_1983_HARN",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",13123359.58005249],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-84.36666666666666],PARAMETER["Standard_Parallel_1",42.1],PARAMETER["Standard_Parallel_2",43.66666666666666],PARAMETER["Latitude_Of_Origin",41.5],UNIT["Foot",0.3048]],VERTCS["NAVD_1988",VDATUM["North_American_Vertical_Datum_1988"],PARAMETER["Vertical_Shift",0.0],PARAMETER["Direction",1.0],UNIT["Foot",0.3048]]

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
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: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: SUBTYPEID

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: ObjectIdentifier )
• SUBTYPEID ( type: esriFieldTypeInteger, alias: SubTypeIdentifier )
• stoinlt_id ( type: esriFieldTypeString, alias: PKStoinltID, length: 20 )
• map_id ( type: esriFieldTypeInteger, alias: PKMapID )
• meta_id ( type: esriFieldTypeString, alias: FKMetaID, length: 20 )
• media_id ( type: esriFieldTypeString, alias: FKMediaID, length: 20 )
• coord_id ( type: esriFieldTypeString, alias: FKCoordID, length: 20 )
• date_acqrd ( type: esriFieldTypeInteger, alias: DateAcqrd )
• dispostn_d ( type: esriFieldTypeString, alias: DispostnDOM, length: 16 , Coded Values: [ABANDONED: abandoned in place (not in use)] , [BURIED: buried] , [IN_SERVICE: In service and being used.] , ...9 more... )
• inlet_st_d ( type: esriFieldTypeString, alias: InletStDOM, length: 16 , Coded Values: [AC_CONDENSATE: air conditioner condensate] , [BWV_DRAIN: backwater valve drain] , [CATCH_BASIN: catch basin] , ...5 more... )
• invert_elv ( type: esriFieldTypeDouble, alias: InvertElv )
• weir_elv ( type: esriFieldTypeDouble, alias: WeirElv )
• elv_u_d ( type: esriFieldTypeString, alias: ElvUOM, length: 16 , Coded Values: [ANGSTROM: A unit of length equal to 0.1 nanometer.] , [CABLN: Cable lengths - 720 feet.] , [CH: Chains - 66 feet or 100 links (Gunter).] , ...29 more... )
• cpcty_dgn ( type: esriFieldTypeDouble, alias: CpctyDgn )
• flow_u_d ( type: esriFieldTypeString, alias: FlowUOM, length: 16 , Coded Values: [BBL_D: A rate equal to one barrel per day.] , [BBL_HR: A rate equal to one barrel per hour.] , [BBL_MO: A rate equal to one barrel per month.] , ...172 more... )
• manuf_id ( type: esriFieldTypeString, alias: FKManufID, length: 50 )
• model_no ( type: esriFieldTypeString, alias: ModelNo, length: 12 )
• stodcrg_id ( type: esriFieldTypeString, alias: FKStodcrgID, length: 20 )
• basin_id ( type: esriFieldTypeString, alias: FKBasinID, length: 20 )
• weir_id ( type: esriFieldTypeString, alias: FKWeirID, length: 20 )
• instln_id ( type: esriFieldTypeString, alias: FKInstlnID, length: 20 )
• project_id ( type: esriFieldTypeString, alias: FKProjectID, length: 50 )
• narrative ( type: esriFieldTypeString, alias: Narrative, length: 240 )
• user_flag ( type: esriFieldTypeString, alias: UserFlag, length: 20 )
• facil_id ( type: esriFieldTypeString, alias: FKFacilID, length: 20 )
• grid_value ( type: esriFieldTypeDouble, alias: GridValue )
• coord_x ( type: esriFieldTypeDouble, alias: CoordX )
• coord_y ( type: esriFieldTypeDouble, alias: CoordY )
• coord_z ( type: esriFieldTypeDouble, alias: CoordZ )
• owner_id ( type: esriFieldTypeString, alias: FKOwnerID, length: 50 )
• 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 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• rim_elv ( type: esriFieldTypeDouble, alias: rim_elv )
• Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled , Coded Values: [0: False] , [1: True] )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• Sump ( type: esriFieldTypeString, alias: Sump, length: 50 , Coded Values: [Yes: Yes] , [No: No] )

Types:

ID: 201779
Name: CURB_INLET
Domains:
• dispostn_d:
  Inherited
• inlet_st_d:
  Inherited
• elv_u_d:
  Inherited
• flow_u_d:
  Inherited
• Enabled:
  Inherited

---

ID: 201782
Name: DROP_INLET
Domains:
• dispostn_d:
  Inherited
• inlet_st_d:
  Inherited
• elv_u_d:
  Inherited
• flow_u_d:
  Inherited
• Enabled:
  Inherited

---

ID: 201785
Name: SURFACE_LINEAR
Domains:
• dispostn_d:
  Inherited
• inlet_st_d:
  Inherited
• elv_u_d:
  Inherited
• flow_u_d:
  Inherited
• Enabled:
  Inherited

---

ID: 209059
Name: CATCH_BASIN
Domains:
• dispostn_d:
  Inherited
• inlet_st_d:
  Inherited
• elv_u_d:
  Inherited
• flow_u_d:
  Inherited
• Enabled:
  Inherited

---

ID: 209062
Name: ROOF_DRAIN
Domains:
• dispostn_d:
  Inherited
• inlet_st_d:
  Inherited
• elv_u_d:
  Inherited
• flow_u_d:
  Inherited
• Enabled:
  Inherited

---

ID: 209066
Name: BWV_DRAIN
Domains:
• dispostn_d:
  Inherited
• inlet_st_d:
  Inherited
• elv_u_d:
  Inherited
• flow_u_d:
  Inherited
• Enabled:
  Inherited

---

ID: 209069
Name: AC_CONDENSATE
Domains:
• dispostn_d:
  Inherited
• inlet_st_d:
  Inherited
• elv_u_d:
  Inherited
• flow_u_d:
  Inherited
• Enabled:
  Inherited

---

ID: 209063
Name: CONDENSATE_DRAIN
Domains:
• dispostn_d:
  Inherited
• inlet_st_d:
  Inherited
• elv_u_d:
  Inherited
• flow_u_d:
  Inherited
• Enabled:
  Inherited

---

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

  Iteminfo   Thumbnail   Metadata