Parent Layer: Sanitary Sewer Dataset

Name: Sanitary Sewer

Display Field: pipe_id

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: f1ff5e57cda2419c932189bd3c5e261e

Copyright Text:

Default Visibility: true

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

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 1.3466578249671921E7
YMin: 379774.27395012975
XMax: 1.3499786279855639E7
YMax: 413788.07874016464
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: 201984
  Label: Sanitary Sewer
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [168, 112, 0, 255]
  Width: 5
• Value: 502199
  Label: Sanitary Interceptor
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [168, 112, 0, 255]
  Width: 4
• Value: 502152
  Label: Force Main
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 7
• Value: 201987
  Label: Sanitary Service
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 0, 0, 255]
  Width: 1
• Value: 201981
  Label: Abandoned Sewer
  Description: N/A
  Symbol:
  Style: esriSLSDash
  Color: [255, 0, 0, 255]
  Width: 1
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: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: SUBTYPEID

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• SUBTYPEID ( type: esriFieldTypeInteger, alias: SubTypeIdentifier )
• pipe_id ( type: esriFieldTypeString, alias: PKPipeID, 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... )
• use_d ( type: esriFieldTypeString, alias: UseDOM, length: 16 , Coded Values: [ABANDONED: abandoned/inactive pipe] , [FM: force main] , [MAIN: main line] , ...3 more... )
• type_d ( type: esriFieldTypeString, alias: TypeDOM, length: 16 , Coded Values: [UNKNOWN: Unknown] , [C-76 CL III: C-76 CL III] , [C-76 CL IV: C-76 CL IV] , ...10 more... )
• mat_d ( type: esriFieldTypeString, alias: MatDOM, length: 16 , Coded Values: [ABS: Acrylonitrile Butadiene Styrene] , [AC: Asbestos Cement] , [BR: Brick] , ...26 more... )
• lined_d ( type: esriFieldTypeString, alias: LinedDOM, length: 16 , Coded Values: [N: No.] , [NO: No.] , [UNKNOWN: Unknown.] , ...2 more... )
• pipe_lgth ( type: esriFieldTypeDouble, alias: PipeLgth )
• size_d ( type: esriFieldTypeString, alias: SizeDOM, length: 16 , Coded Values: [0.25: 1/4 inch] , [0.5: 1/2 inch] , [0.75: 3/4 inch] , ...46 more... )
• 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... )
• inv_elv_1 ( type: esriFieldTypeDouble, alias: InvElv1 )
• inv_elv_2 ( type: esriFieldTypeDouble, alias: InvElv2 )
• 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... )
• press_max ( type: esriFieldTypeDouble, alias: PressMax )
• press_norm ( type: esriFieldTypeDouble, alias: PressNorm )
• press_u_d ( type: esriFieldTypeString, alias: PressUOM, length: 16 , Coded Values: [ATM: Atmosphere (101325 kg per m*sec2(PA)).] , [BAR: Bar (1.0E+5 kg per m*sec2(PA)).] , [BARYEA: Barye - dynes/cm2 (absolute).] , ...25 more... )
• slope_bot ( type: esriFieldTypeDouble, alias: SlopeBot )
• slope_u_d ( type: esriFieldTypeString, alias: SlopeUOM, length: 16 , Coded Values: [ARCSEC: Arc seconds.] , [DDMMSS: Degrees:minutes:seconds.] , [DEG: Degrees.] , ...17 more... )
• drng_pat_d ( type: esriFieldTypeString, alias: DrngPatDOM, length: 16 , Coded Values: [ANGULATE: Angulate.] , [ANNULAR: Annular.] , [ARTIFICIAL: Artificial.] , ...31 more... )
• drng_tex_d ( type: esriFieldTypeString, alias: DrngTexDOM, length: 16 , Coded Values: [COARSE: coarse] , [FINE: fine] , [MEDIUM: medium] , ...3 more... )
• wwtplnt_id ( type: esriFieldTypeString, alias: FKWwtplntID, length: 20 )
• area_size ( type: esriFieldTypeDouble, alias: AreaSize )
• area_u_d ( type: esriFieldTypeString, alias: AreaUOM, length: 16 , Coded Values: [AC: Acre - 43,560 Square Feet] , [ACR: Acres – 43,560 sq. feet.] , [ARE: Ares - 1 sq. decameter.] , ...17 more... )
• perim ( type: esriFieldTypeDouble, alias: Perim )
• perim_u_d ( type: esriFieldTypeString, alias: PerimUOM, 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... )
• manuf_id ( type: esriFieldTypeString, alias: FKManufID, length: 50 )
• model_no ( type: esriFieldTypeString, alias: ModelNo, length: 12 )
• distrct_id ( type: esriFieldTypeString, alias: FKDistrctID, length: 20 )
• wwstank_id ( type: esriFieldTypeString, alias: FKWwstankID, length: 20 )
• tribut_cod ( type: esriFieldTypeString, alias: TributCod, 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 )
• station_id ( type: esriFieldTypeString, alias: FKStationID, length: 20 )
• wwtsect_id ( type: esriFieldTypeString, alias: FKWwtsectID, length: 20 )
• 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 )
• frcoord_x ( type: esriFieldTypeDouble, alias: FrcoordX )
• frcoord_y ( type: esriFieldTypeDouble, alias: FrcoordY )
• frcoord_z ( type: esriFieldTypeDouble, alias: FrcoordZ )
• tocoord_x ( type: esriFieldTypeDouble, alias: TocoordX )
• tocoord_y ( type: esriFieldTypeDouble, alias: TocoordY )
• tocoord_z ( type: esriFieldTypeDouble, alias: TocoordZ )
• owner_id ( type: esriFieldTypeString, alias: FKOwnerID, length: 50 , Coded Values: [DWSD: DWSD] , [City of Sterling Heights: City of Sterling Heights] , [Private: Private] )
• piplty_d ( type: esriFieldTypeString, alias: PipltyDOM, length: 16 , Coded Values: [ABOVE_GROUND: above ground] , [ELEVATED: elevated] , [SUBMERGED: submerged] , ...3 more... )
• ww_util_id ( type: esriFieldTypeString, alias: FKWwUtilID, length: 20 )
• coverdepth ( type: esriFieldTypeDouble, alias: Coverdepth )
• depth_u_d ( type: esriFieldTypeString, alias: DepthUOM, 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... )
• length_u_d ( type: esriFieldTypeString, alias: LengthUOM, 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... )
• Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled , Coded Values: [0: False] , [1: True] )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• DownMh_Id ( type: esriFieldTypeString, alias: FKDownMhId, length: 20 )
• UpMh_Id ( type: esriFieldTypeString, alias: FKUpMhId, length: 20 )
• Shape.STLength() ( type: esriFieldTypeDouble, alias: Shape.STLength() )
• Video_Link ( type: esriFieldTypeString, alias: Video_Link, length: 200 )
• Video_Link_R ( type: esriFieldTypeString, alias: Video_Link_R, length: 255 )

Types:

ID: 201984
Name: MAIN
Domains:
• dispostn_d:
  Inherited
• use_d:
  Inherited
• type_d:
  Inherited
• mat_d:
  Inherited
• lined_d:
  Inherited
• size_d:
  Inherited
• dim_u_d:
  Inherited
• elv_u_d:
  Inherited
• press_u_d:
  Inherited
• slope_u_d:
  Inherited
• drng_pat_d:
  Inherited
• drng_tex_d:
  Inherited
• area_u_d:
  Inherited
• perim_u_d:
  Inherited
• owner_id:
  Inherited
• piplty_d:
  Inherited
• depth_u_d:
  Inherited
• length_u_d:
  Inherited
• Enabled:
  Inherited

---

ID: 201987
Name: SERVICE
Domains:
• dispostn_d:
  Inherited
• use_d:
  Inherited
• type_d:
  Inherited
• mat_d:
  Inherited
• lined_d:
  Inherited
• size_d:
  Inherited
• dim_u_d:
  Inherited
• elv_u_d:
  Inherited
• press_u_d:
  Inherited
• slope_u_d:
  Inherited
• drng_pat_d:
  Inherited
• drng_tex_d:
  Inherited
• area_u_d:
  Inherited
• perim_u_d:
  Inherited
• owner_id:
  Inherited
• piplty_d:
  Inherited
• depth_u_d:
  Inherited
• length_u_d:
  Inherited
• Enabled:
  Inherited

---

ID: 201981
Name: ABANDONED
Domains:
• dispostn_d:
  Inherited
• use_d:
  Inherited
• type_d:
  Inherited
• mat_d:
  Inherited
• lined_d:
  Inherited
• size_d:
  Inherited
• dim_u_d:
  Inherited
• elv_u_d:
  Inherited
• press_u_d:
  Inherited
• slope_u_d:
  Inherited
• drng_pat_d:
  Inherited
• drng_tex_d:
  Inherited
• area_u_d:
  Inherited
• perim_u_d:
  Inherited
• owner_id:
  Inherited
• piplty_d:
  Inherited
• depth_u_d:
  Inherited
• length_u_d:
  Inherited
• Enabled:
  Inherited

---

ID: 502148
Name: OVERFLOW
Domains:
• dispostn_d:
  Inherited
• use_d:
  Inherited
• type_d:
  Inherited
• mat_d:
  Inherited
• lined_d:
  Inherited
• size_d:
  Inherited
• dim_u_d:
  Inherited
• elv_u_d:
  Inherited
• press_u_d:
  Inherited
• slope_u_d:
  Inherited
• drng_pat_d:
  Inherited
• drng_tex_d:
  Inherited
• area_u_d:
  Inherited
• perim_u_d:
  Inherited
• owner_id:
  Inherited
• piplty_d:
  Inherited
• depth_u_d:
  Inherited
• length_u_d:
  Inherited
• Enabled:
  Inherited

---

ID: 502152
Name: FM
Domains:
• dispostn_d:
  Inherited
• use_d:
  Inherited
• type_d:
  Inherited
• mat_d:
  Inherited
• lined_d:
  Inherited
• size_d:
  Inherited
• dim_u_d:
  Inherited
• elv_u_d:
  Inherited
• press_u_d:
  Inherited
• slope_u_d:
  Inherited
• drng_pat_d:
  Inherited
• drng_tex_d:
  Inherited
• area_u_d:
  Inherited
• perim_u_d:
  Inherited
• owner_id:
  Inherited
• piplty_d:
  Inherited
• depth_u_d:
  Inherited
• length_u_d:
  Inherited
• Enabled:
  Inherited

---

ID: 209197
Name: SLUDGE
Domains:
• dispostn_d:
  Inherited
• use_d:
  Inherited
• type_d:
  Inherited
• mat_d:
  Inherited
• lined_d:
  Inherited
• size_d:
  Inherited
• dim_u_d:
  Inherited
• elv_u_d:
  Inherited
• press_u_d:
  Inherited
• slope_u_d:
  Inherited
• drng_pat_d:
  Inherited
• drng_tex_d:
  Inherited
• area_u_d:
  Inherited
• perim_u_d:
  Inherited
• owner_id:
  Inherited
• piplty_d:
  Inherited
• depth_u_d:
  Inherited
• length_u_d:
  Inherited
• Enabled:
  Inherited

---

ID: 502199
Name: INTERCEPTOR
Domains:
• dispostn_d:
  Inherited
• use_d:
  Inherited
• type_d:
  Inherited
• mat_d:
  Inherited
• lined_d:
  Inherited
• size_d:
  Inherited
• dim_u_d:
  Inherited
• elv_u_d:
  Inherited
• press_u_d:
  Inherited
• slope_u_d:
  Inherited
• drng_pat_d:
  Inherited
• drng_tex_d:
  Inherited
• area_u_d:
  Inherited
• perim_u_d:
  Inherited
• owner_id:
  Inherited
• piplty_d:
  Inherited
• depth_u_d:
  Inherited
• length_u_d:
  Inherited
• Enabled:
  Inherited

---

Relationships:

• GISDB.DBO.Sanitary_SewerAnno (5) -- Related To: Sanitary Sewer Annotation (104)

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

  Iteminfo   Thumbnail   Metadata