Parent Layer: Storm Sewer Dataset

Name: Storm Sewer Structure

Display Field: manhole_id

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This feature class denotes the location of known storm junction points, also known as storm manholes, within the City of Sterling Heights. These manholes are located on streets, in parking lots and in grassy areas, and provide maintenance access to the storm water system. Many of these structures are fitted with vented covers, functioning as another entry point 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 11,000 storm manholes within the City.

Service Item Id: d4fbd91c53934b70aec40a98d3e8cdf5

Copyright Text: The City of Sterling Heights, MI

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.3466613403871387E7
YMin: 379763.164041996
XMax: 1.3499921811023623E7
YMax: 413979.8907480389
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:
Unique Value Renderer:
Field 1: SUBTYPEID
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 201800
  Label: Storm Manhole
  Description: N/A
  Symbol:
  
• Value: 201788
  Label: Storm Junction Box
  Description: N/A
  Symbol:
  
• Value: 201900
  Label: Storm Cleanout
  Description: N/A
  Symbol:
  
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:

• SUBTYPEID ( type: esriFieldTypeInteger, alias: SubTypeIdentifier )
• manhole_id ( type: esriFieldTypeString, alias: PKManholeID, 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 )
• 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... )
• use_d ( type: esriFieldTypeString, alias: UseDOM, length: 16 , Coded Values: [JUNCTION_BOX: junction box] , [MANHOLE: manhole] )
• type_d ( type: esriFieldTypeString, alias: TypeDOM, length: 16 , Coded Values: [ABOVEGROUND: above ground] , [DIST_BOX: distribution box] , [DRAINPIT: drain pit] , ...7 more... )
• mat_d ( type: esriFieldTypeString, alias: MatDOM, length: 16 , Coded Values: [ABS: Acrylonitrile Butadiene Styrene] , [AC: Asbestos Cement] , [BR: Brick] , ...26 more... )
• no_pipes ( type: esriFieldTypeSmallInteger, alias: NoPipes )
• mh_width ( type: esriFieldTypeDouble, alias: MhWidth )
• mh_len ( type: esriFieldTypeDouble, alias: MhLen )
• mh_dia ( type: esriFieldTypeDouble, alias: MhDia )
• dim_u_d ( type: esriFieldTypeString, alias: DimUOM, 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... )
• rim_elv ( type: esriFieldTypeDouble, alias: RimElv )
• invert_elv ( type: esriFieldTypeDouble, alias: InvertElv )
• 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... )
• drain_ty_d ( type: esriFieldTypeString, alias: DrainTyDOM, length: 16 , Coded Values: [FAN: fan] , [NETWORK: network] , [OTHER: other] , ...7 more... )
• manuf_id ( type: esriFieldTypeString, alias: FKManufID, length: 50 )
• model_no ( type: esriFieldTypeString, alias: ModelNo, length: 12 )
• basin_id ( type: esriFieldTypeString, alias: FKBasinID, length: 20 )
• stodcrg_id ( type: esriFieldTypeString, alias: FKStodcrgID, length: 20 )
• instln_id ( type: esriFieldTypeString, alias: FKInstlnID, length: 20 )
• buildng_id ( type: esriFieldTypeString, alias: FKBuildngID, 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 )
• date_acqrd ( type: esriFieldTypeInteger, alias: DateAcqrd )
• 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 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• 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: 201788
Name: JUNCTION_BOX
Domains:
• dispostn_d:
  Inherited
• use_d:
  Inherited
• type_d:
  Inherited
• mat_d:
  Coded Values: [ABS: acrylonitrile butadiene styrene] , [AC: asbestos cement] , [AL: Aluminum] , ...80 more...
• dim_u_d:
  Inherited
• elv_u_d:
  Inherited
• drain_ty_d:
  Inherited
• Enabled:
  Inherited

---

ID: 201800
Name: MANHOLE
Domains:
• dispostn_d:
  Inherited
• use_d:
  Inherited
• type_d:
  Inherited
• mat_d:
  Coded Values: [ABS: acrylonitrile butadiene styrene] , [AC: asbestos cement] , [AL: Aluminum] , ...80 more...
• dim_u_d:
  Inherited
• elv_u_d:
  Inherited
• drain_ty_d:
  Inherited
• Enabled:
  Inherited

---

ID: 201900
Name: CLEANOUT
Domains:
• dispostn_d:
  Inherited
• use_d:
  Inherited
• type_d:
  Inherited
• mat_d:
  Coded Values: [ABS: acrylonitrile butadiene styrene] , [AC: asbestos cement] , [AL: Aluminum] , ...80 more...
• dim_u_d:
  Inherited
• elv_u_d:
  Inherited
• drain_ty_d:
  Inherited
• Enabled:
  Inherited

---

Relationships:

• GISDB.DBO.Storm_Sewer_StructureAnno (6) -- Related To: Storm Sewer Structure Annotation (105)

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

  Iteminfo   Thumbnail   Metadata