Name: Sanitary Mains

Display Field: SanitaryLineNumber

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: A map of all sanitary mains in the city of Waterloo, Iowa sewer system.

Service Item Id: ac99dc44cc0c42dc8ce485dfe7933f76

Copyright Text: Ben Wagner, City of Waterloo, Iowa Engineering Dept.

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 12000.000000000002

Max Scale: 0.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: 5210748.93194872
YMin: 3618494.528772562
XMax: 5257469.656420473
YMax: 3673431.8214568067
Spatial Reference: 102675  (3417)  VCSWkid(5703)  LatestVCSWkid(5703)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: Owner
Field 2: Type
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSLSSolid
Color: [110, 110, 110, 255]
Width: 4
Default Label: <all other values>
UniqueValueInfos:
• Value: CITY OF WATERLOO,ABANDONED
  Label: City, Abandoned
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 0, 0, 255]
  Width: 2
• Value: CITY OF WATERLOO,FORCE
  Label: City, Force
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 0, 0, 255]
  Width: 2
• Value: CITY OF WATERLOO,GRAVITY
  Label: City, Gravity
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 0, 0, 255]
  Width: 2
• Value: CITY OF WATERLOO,SIPHON
  Label: City, Siphon
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 0, 0, 255]
  Width: 2
• Value: BLACK HAWK COUNTY,ABANDONED
  Label: County, Abandoned
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 0, 0, 255]
  Width: 2
• Value: BLACK HAWK COUNTY,FORCE
  Label: County, Force
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 0, 0, 255]
  Width: 2
• Value: BLACK HAWK COUNTY,GRAVITY
  Label: County, Gravity
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 0, 0, 255]
  Width: 2
• Value: PRIVATE,ABANDONED
  Label: Private, Abandoned
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 0, 0, 255]
  Width: 2
• Value: PRIVATE,FORCE
  Label: Private, Force
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 0, 0, 255]
  Width: 2
• Value: PRIVATE,GRAVITY
  Label: Private, Gravity
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 0, 0, 255]
  Width: 2
• Value: SCHOOLS,ABANDONED
  Label: Schools, Abandoned
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 0, 0, 255]
  Width: 2
• Value: SCHOOLS,FORCE
  Label: Schools, Force
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 0, 0, 255]
  Width: 2
• Value: SCHOOLS,GRAVITY
  Label: Schools, Gravity
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 0, 0, 255]
  Width: 2
• Value: STATE,ABANDONED
  Label: State, Abandoned
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 0, 0, 255]
  Width: 2
• Value: STATE,FORCE
  Label: State, Force
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 0, 0, 255]
  Width: 2
• Value: STATE,GRAVITY
  Label: State, Gravity
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 0, 0, 255]
  Width: 2
• Value: OTHER,ABANDONED
  Label: Other, Abandoned
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 0, 0, 255]
  Width: 2
• Value: OTHER,FORCE
  Label: Other, Force
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 0, 0, 255]
  Width: 2
• Value: OTHER,GRAVITY
  Label: Other, Gravity
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 0, 0, 255]
  Width: 2
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: true

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• SHAPE ( type: esriFieldTypeGeometry, alias: Shape )
• SanitaryLineNumber ( type: esriFieldTypeString, alias: SanitaryLineNumber, length: 50 )
• x_upstream ( type: esriFieldTypeDouble, alias: x_upstream )
• y_upstream ( type: esriFieldTypeDouble, alias: y_upstream )
• x_downstream ( type: esriFieldTypeDouble, alias: x_downstream )
• y_downstream ( type: esriFieldTypeDouble, alias: y_downstream )
• Length ( type: esriFieldTypeDouble, alias: Length )
• Owner ( type: esriFieldTypeString, alias: Owner, length: 50 , Coded Values: [CITY OF WATERLOO: CITY OF WATERLOO] , [BLACK HAWK COUNTY: BLACK HAWK COUNTY] , [PRIVATE: PRIVATE] , ...4 more... )
• Size ( type: esriFieldTypeDouble, alias: Size )
• YearCon ( type: esriFieldTypeDate, alias: YearCon, length: 8 )
• Type ( type: esriFieldTypeString, alias: Type, length: 50 , Coded Values: [GRAVITY: GRAVITY] , [FORCE: FORCE] , [SIPHON: SIPHON] , ...1 more... )
• Material ( type: esriFieldTypeString, alias: Material, length: 50 , Coded Values: [DIP: DIP] , [RCP: RCP] , [CLAY: CLAY] , ...8 more... )
• PipeShape ( type: esriFieldTypeString, alias: PipeShape, length: 50 , Coded Values: [ROUND: ROUND] , [ELLIPTICAL: ELLIPTICAL] , [ARCH: ARCH] , ...2 more... )
• Slope ( type: esriFieldTypeDouble, alias: Slope )
• EncasedPipe ( type: esriFieldTypeString, alias: EncasedPipe, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• HookOnCharge ( type: esriFieldTypeString, alias: HookOnCharge, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• ServiceArea ( type: esriFieldTypeInteger, alias: ServiceArea , Coded Values: [10: 10] , [11: 11] , [12: 12] , ...12 more... )
• SubServiceArea ( type: esriFieldTypeInteger, alias: SubServiceArea )
• z_upstream ( type: esriFieldTypeDouble, alias: z_upstream )
• z_downstream ( type: esriFieldTypeDouble, alias: z_downstream )
• InspectionYear ( type: esriFieldTypeDate, alias: InspectionYear, length: 8 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 300 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• SHAPE.STLength() ( type: esriFieldTypeDouble, alias: Shape.STLength() )
• CleanDate ( type: esriFieldTypeDate, alias: Clean Date, length: 8 )
• 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 )
• UpstreamManholeNumber ( type: esriFieldTypeInteger, alias: UpstreamManholeNumber )
• DownstreamManholeNumber ( type: esriFieldTypeInteger, alias: DownstreamManholeNumber )
• PipeLiningPhase ( type: esriFieldTypeString, alias: Pipe Lining Phase, length: 50 , Coded Values: [Phase IVB1: Phase IVB1] , [Phase IVA3: Phase IVA3] , [Phase IVA2: Phase IVA2] , ...7 more... )
• City_ID_2 ( type: esriFieldTypeString, alias: City Pipe ID 2, length: 50 )
• F_IMSID ( type: esriFieldTypeString, alias: US Model ID, length: 20 )
• T_IMSID ( type: esriFieldTypeString, alias: DS Model ID, length: 20 )
• XWIDTH ( type: esriFieldTypeInteger, alias: Pipe Width )
• XHEIGHT ( type: esriFieldTypeInteger, alias: Pipe Height )
• MATERIAL_1 ( type: esriFieldTypeString, alias: Material 1, length: 50 )
• CITY_USID ( type: esriFieldTypeString, alias: City US ID, length: 20 )
• CITY_DSID ( type: esriFieldTypeString, alias: City DS ID, length: 20 )
• C_ID ( type: esriFieldTypeString, alias: Cartegraph Pipe ID, length: 50 )
• CITY_ID ( type: esriFieldTypeString, alias: City Pipe ID, length: 50 )
• C_USID ( type: esriFieldTypeString, alias: Cartegraph US ID, length: 20 )
• C_DSID ( type: esriFieldTypeString, alias: Cartegraph DS ID, length: 20 )
• S_IMSID ( type: esriFieldTypeString, alias: Model Pipe ID, length: 50 )
• SA ( type: esriFieldTypeSmallInteger, alias: SA )
• SSA ( type: esriFieldTypeSmallInteger, alias: SSA )
• Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled )
• INFO ( type: esriFieldTypeString, alias: INFO, length: 50 )
• Type_1 ( type: esriFieldTypeString, alias: Type 1, length: 50 )
• OWNER_1 ( type: esriFieldTypeString, alias: Owner 1, length: 50 )
• CH_DT ( type: esriFieldTypeString, alias: CH_DT, length: 15 )
• Assumption ( type: esriFieldTypeString, alias: Assumption, length: 50 )
• Exit_Loss ( type: esriFieldTypeString, alias: Exit_Loss, length: 50 )
• Private_Included ( type: esriFieldTypeString, alias: Private_Included, length: 50 )
• Note ( type: esriFieldTypeString, alias: Note, length: 50 )
• CalcField ( type: esriFieldTypeString, alias: CalcField, length: 50 )
• Status ( type: esriFieldTypeString, alias: Asset Status, length: 50 , Coded Values: [Active: Active] , [Removed: Removed] , [Abandoned: Abandoned] )
• F_ELEV ( type: esriFieldTypeDouble, alias: US Pipe Elevation )
• T_ELEV ( type: esriFieldTypeDouble, alias: DS Pipe Elevation )
• LENGTH_1 ( type: esriFieldTypeDouble, alias: Length 1 )
• Slope_1 ( type: esriFieldTypeDouble, alias: Slope 1 )
• Roughness ( type: esriFieldTypeDouble, alias: Roughness )
• AssetID ( type: esriFieldTypeString, alias: Asset ID, length: 255 )
• PipeLiningYear ( type: esriFieldTypeString, alias: Pipe Lining Year, length: 255 , Coded Values: [2012: 2012] , [2013: 2013] , [2014: 2014] , ...11 more... )

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

  Iteminfo   Thumbnail   Metadata