Parent Layer: Water Main Dataset

Name: Non-Sterling Heights Water Lines

Display Field: watpipe_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.3466492317585304E7
YMin: 379533.1768372655
XMax: 1.3500064752624676E7
YMax: 413814.3897637725
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: owner_id
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: GLWA
  Label: GLWA
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 112, 255, 255]
  Width: 4
• Value: Clinton Twp.
  Label: Clinton Township/Warren
  Description: N/A
  Symbol:
  Style: esriSLSDash
  Color: [255, 0, 197, 255]
  Width: 1
• Value: Warren
  Label: Clinton Township/Warren
  Description: N/A
  Symbol:
  Style: esriSLSDash
  Color: [255, 0, 197, 255]
  Width: 1
• Value: Private
  Label: Private
  Description: N/A
  Symbol:
  Style: esriSLSDash
  Color: [197, 0, 255, 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: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: SUBTYPEID

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: ObjectIdentifier )
• SUBTYPEID ( type: esriFieldTypeInteger, alias: SubTypeIdentifier )
• watpipe_id ( type: esriFieldTypeString, alias: PKWatpipeID, 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] , [FIRE: fire protection] , [MAIN: main line] , ...4 more... )
• type_d ( type: esriFieldTypeString, alias: TypeDOM, length: 16 , Coded Values: [BOX: box] , [CIRCULAR: circular] , [OTHER: other] , ...6 more... )
• mat_d ( type: esriFieldTypeString, alias: MatDOM, length: 16 , Coded Values: [ABS: Acrylonitrile Butadiene Styrene] , [AC: Asbestos Cement] , [BR: Brick] , ...26 more... )
• 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... )
• pipe_lgth ( type: esriFieldTypeDouble, alias: PipeLgth )
• 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 )
• grnd_elv_1 ( type: esriFieldTypeDouble, alias: GrndElv1 )
• inv_elv_2 ( type: esriFieldTypeDouble, alias: InvElv2 )
• grnd_elv_2 ( type: esriFieldTypeDouble, alias: GrndElv2 )
• 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... )
• catprot_d ( type: esriFieldTypeString, alias: CatprotDOM, length: 16 , Coded Values: [N: No.] , [NO: No.] , [UNKNOWN: Unknown.] , ...2 more... )
• tape_d ( type: esriFieldTypeString, alias: TapeDOM, length: 16 , Coded Values: [N: No.] , [NO: No.] , [UNKNOWN: Unknown.] , ...2 more... )
• source_d ( type: esriFieldTypeString, alias: SourceDOM, length: 16 , Coded Values: [ARROYO: arroyo/draw/wash] , [ARTISAN_WELL: artisan well] , [BAYOU: bayou] , ...29 more... )
• watplnt_id ( type: esriFieldTypeString, alias: FKWatplntID, length: 20 )
• manuf_id ( type: esriFieldTypeString, alias: FKManufID, length: 50 )
• model_no ( type: esriFieldTypeString, alias: ModelNo, length: 12 )
• wattank_id ( type: esriFieldTypeString, alias: FKWattankID, 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 )
• watstat_id ( type: esriFieldTypeString, alias: FKWatstatID, length: 20 )
• watzone_id ( type: esriFieldTypeString, alias: FKWatzoneID, length: 20 )
• watsect_id ( type: esriFieldTypeString, alias: FKWatsectID, 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 )
• watsrce_id ( type: esriFieldTypeString, alias: FKWatsrceID, length: 20 )
• 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 )
• piplty_d ( type: esriFieldTypeString, alias: PipltyDOM, length: 16 , Coded Values: [ABOVE_GROUND: above ground] , [ELEVATED: elevated] , [SUBMERGED: submerged] , ...3 more... )
• w_util_id ( type: esriFieldTypeString, alias: FKWUtilID, length: 20 )
• 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... )
• coverdepth ( type: esriFieldTypeDouble, alias: Coverdepth )
• 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] )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• SHAPE.STLength() ( type: esriFieldTypeDouble, alias: SHAPE.STLength() )

Types:

ID: 201867
Name: MAIN
Domains:
• dispostn_d:
  Inherited
• use_d:
  Inherited
• type_d:
  Inherited
• mat_d:
  Inherited
• size_d:
  Inherited
• dim_u_d:
  Inherited
• elv_u_d:
  Inherited
• press_u_d:
  Inherited
• slope_u_d:
  Inherited
• catprot_d:
  Inherited
• tape_d:
  Inherited
• source_d:
  Inherited
• piplty_d:
  Inherited
• depth_u_d:
  Inherited
• length_u_d:
  Inherited
• Enabled:
  Inherited

---

ID: 201873
Name: SERVICE
Domains:
• dispostn_d:
  Inherited
• use_d:
  Inherited
• type_d:
  Inherited
• mat_d:
  Inherited
• size_d:
  Inherited
• dim_u_d:
  Inherited
• elv_u_d:
  Inherited
• press_u_d:
  Inherited
• slope_u_d:
  Inherited
• catprot_d:
  Inherited
• tape_d:
  Inherited
• source_d:
  Inherited
• piplty_d:
  Inherited
• depth_u_d:
  Inherited
• length_u_d:
  Inherited
• Enabled:
  Inherited

---

ID: 201870
Name: RAW_WATER
Domains:
• dispostn_d:
  Inherited
• use_d:
  Inherited
• type_d:
  Inherited
• mat_d:
  Inherited
• size_d:
  Inherited
• dim_u_d:
  Inherited
• elv_u_d:
  Inherited
• press_u_d:
  Inherited
• slope_u_d:
  Inherited
• catprot_d:
  Inherited
• tape_d:
  Inherited
• source_d:
  Inherited
• piplty_d:
  Inherited
• depth_u_d:
  Inherited
• length_u_d:
  Inherited
• Enabled:
  Inherited

---

ID: 201876
Name: SPRINKLER
Domains:
• dispostn_d:
  Inherited
• use_d:
  Inherited
• type_d:
  Inherited
• mat_d:
  Inherited
• size_d:
  Inherited
• dim_u_d:
  Inherited
• elv_u_d:
  Inherited
• press_u_d:
  Inherited
• slope_u_d:
  Inherited
• catprot_d:
  Inherited
• tape_d:
  Inherited
• source_d:
  Inherited
• piplty_d:
  Inherited
• depth_u_d:
  Inherited
• length_u_d:
  Inherited
• Enabled:
  Inherited

---

ID: 201864
Name: ABANDONED
Domains:
• dispostn_d:
  Inherited
• use_d:
  Inherited
• type_d:
  Inherited
• mat_d:
  Inherited
• size_d:
  Inherited
• dim_u_d:
  Inherited
• elv_u_d:
  Inherited
• press_u_d:
  Inherited
• slope_u_d:
  Inherited
• catprot_d:
  Inherited
• tape_d:
  Inherited
• source_d:
  Inherited
• piplty_d:
  Inherited
• depth_u_d:
  Inherited
• length_u_d:
  Inherited
• Enabled:
  Inherited

---

ID: 203674
Name: FIRE
Domains:
• dispostn_d:
  Inherited
• use_d:
  Inherited
• type_d:
  Inherited
• mat_d:
  Inherited
• size_d:
  Inherited
• dim_u_d:
  Inherited
• elv_u_d:
  Inherited
• press_u_d:
  Inherited
• slope_u_d:
  Inherited
• catprot_d:
  Inherited
• tape_d:
  Inherited
• source_d:
  Inherited
• piplty_d:
  Inherited
• depth_u_d:
  Inherited
• length_u_d:
  Inherited
• Enabled:
  Inherited

---

ID: 204261
Name: SIPHON
Domains:
• dispostn_d:
  Inherited
• use_d:
  Inherited
• type_d:
  Inherited
• mat_d:
  Inherited
• size_d:
  Inherited
• dim_u_d:
  Inherited
• elv_u_d:
  Inherited
• press_u_d:
  Inherited
• slope_u_d:
  Inherited
• catprot_d:
  Inherited
• tape_d:
  Inherited
• source_d:
  Inherited
• piplty_d:
  Inherited
• depth_u_d:
  Inherited
• length_u_d:
  Inherited
• Enabled:
  Inherited

---

Relationships:

• GISDB.DBO.Water_LinesAnno (3) -- Related To: Water Lines Annotation (111)

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

  Iteminfo   Thumbnail   Metadata