View In:   ArcGIS Online Map Viewer

Name: UTIL_Sanitary_Main

Display Field: asset_name

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: The sanitary main layer depicts all the sanitary mains within the city of Fond du Lac, Wisconsin. It has information about the ID, size, material, etc. The City Engineering & Traffic Division in the Department of Public Works maintains the data.

Service Item Id: 9b7d386c8ab345dfa7bda1c5012e4c40

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 803587.3000266626
YMin: 365459.24636698514
XMax: 838063.2202479132
YMax: 395553.33283223957
Spatial Reference: 103419  (103419)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: function_
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSLSSolid
Color: [130, 130, 130, 255]
Width: 1
Default Label:
UniqueValueInfos:
• Value: 0
  Label: Main
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [76, 230, 0, 255]
  Width: 1
• Value: 1
  Label: Force Main
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [206, 252, 179, 255]
  Width: 1
• Value: 2
  Label: Interceptor
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [252, 193, 179, 255]
  Width: 1
• Value: 4
  Label: Plug
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [184, 243, 252, 255]
  Width: 1
• Value: 5
  Label: Stub
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [252, 246, 212, 255]
  Width: 1
• Value: 6
  Label: Overflow
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [252, 189, 221, 255]
  Width: 1
• Value: 7
  Label: Unknown
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [194, 252, 219, 255]
  Width: 1
• Value: 8
  Label: Abandoned
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [212, 224, 252, 255]
  Width: 1
Transparency: 0
Labeling Info:
Label Placement: esriServerLinePlacementAboveAlong
Label Expression: N/A
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 10
Font Family: Arial
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 0.0
Max. Scale: 0.0

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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: true

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: function_

Fields:

• objectid ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ds_inv_elev ( type: esriFieldTypeDouble, alias: DS Inv. Elev., editable: true, nullable: true, defaultValue: null, modelName: DOWN_INV_ELEV )
• ds_inv_accuracy ( type: esriFieldTypeString, alias: DS Inv. Accuracy, editable: true, nullable: true, length: 20, defaultValue: null, modelName: DOWN_INV_ACCURACY , Coded Values: [CONSULTANT: Consultant] , [CSM: CSM] , [DIGITIZED: Digitized] , ...12 more... )
• us_inv_elev ( type: esriFieldTypeDouble, alias: US Inv. Elev., editable: true, nullable: true, defaultValue: null, modelName: UP_INV_ELEV )
• us_inv_accuracy ( type: esriFieldTypeString, alias: US Inv. Accuracy, editable: true, nullable: true, length: 20, defaultValue: null, modelName: UP_INV_ACCURACY , Coded Values: [CONSULTANT: Consultant] , [CSM: CSM] , [DIGITIZED: Digitized] , ...12 more... )
• ds_mh ( type: esriFieldTypeString, alias: DS MH, editable: true, nullable: true, length: 10, defaultValue: null, modelName: DOWN_MANHOLE )
• us_mh ( type: esriFieldTypeString, alias: US MH, editable: true, nullable: true, length: 10, defaultValue: null, modelName: UP_MANHOLE )
• function_ ( type: esriFieldTypeSmallInteger, alias: Function, editable: true, nullable: true, defaultValue: 0, modelName: FUNCTION_ )
• asset_name ( type: esriFieldTypeString, alias: Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NAME )
• diameter ( type: esriFieldTypeSmallInteger, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: DIAMETER )
• material ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PIPE_MATERIAL , Coded Values: [ABS: ABS] , [CI: CI] , [CIP: CIP] , ...12 more... )
• tv_date ( type: esriFieldTypeDate, alias: TV Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: TV_DATE )
• tv_rating ( type: esriFieldTypeSmallInteger, alias: TV Rating, editable: true, nullable: true, defaultValue: null, modelName: TV_RATING )
• tv_notes ( type: esriFieldTypeString, alias: TV Notes, editable: true, nullable: true, length: 250, defaultValue: null, modelName: TV_NOTES )
• tv_priority ( type: esriFieldTypeString, alias: TV Priority, editable: true, nullable: true, length: 20, defaultValue: null, modelName: TV_PRIORITY )
• notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 250, defaultValue: null, modelName: NOTES )
• constructed ( type: esriFieldTypeSmallInteger, alias: Constructed, editable: true, nullable: true, defaultValue: null, modelName: YEAR_CONSTRUCTED )
• status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 20, defaultValue: PROPOSED, modelName: STATUS , Coded Values: [ABANDONED: Abandoned] , [ACTIVE: Active] , [HISTORIC: Historic] , ...3 more... )
• owner ( type: esriFieldTypeString, alias: Owner, editable: true, nullable: true, length: 50, defaultValue: CITY, modelName: OWNER , Coded Values: [CITY: City] , [CITY & COUNTY: City & County] , [CITY & TOWN: City & Town] , ...9 more... )
• creator ( type: esriFieldTypeString, alias: Creator, editable: false, nullable: true, length: 20, defaultValue: null, modelName: CREATE_USR )
• editor ( type: esriFieldTypeString, alias: Editor, editable: false, nullable: true, length: 20, defaultValue: null, modelName: LST_EDT_USR )
• ml_assetid ( type: esriFieldTypeString, alias: Asset ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Asset_ID )
• street ( type: esriFieldTypeString, alias: Street, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ON_STREET , Coded Values: [*see parcel: *see parcel] , [01ST ST E: E 1st St] , [01ST ST W: W 1st St] , ...599 more... )
• created ( type: esriFieldTypeDate, alias: Created, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CREATIONDATE )
• edited ( type: esriFieldTypeDate, alias: Edited, editable: false, nullable: true, length: 8, defaultValue: null, modelName: EDITDATE )
• us_vert_datum ( type: esriFieldTypeString, alias: US Vert. Datum, editable: true, nullable: true, length: 10, defaultValue: null, modelName: UP_VERT_DATUM , Coded Values: [NAVD88: NAVD88] , [NGVD29: NGVD29] , [NA: NA] )
• ds_vert_datum ( type: esriFieldTypeString, alias: DS Vert. Datum, editable: true, nullable: true, length: 10, defaultValue: null, modelName: DOWN_VERT_DATUM , Coded Values: [NAVD88: NAVD88] , [NGVD29: NGVD29] , [NA: NA] )
• globalid ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• lining ( type: esriFieldTypeString, alias: Lining, editable: true, nullable: true, length: 30, defaultValue: null, modelName: LINING )
• easement ( type: esriFieldTypeString, alias: EASEMENT, editable: true, nullable: true, length: 10, defaultValue: null, modelName: EASEMENT )
• flow ( type: esriFieldTypeString, alias: Flow, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PIPE_DIRECTION , Coded Values: [N: North] , [NE: Northeast] , [E: East] , ...5 more... )
• lining_year ( type: esriFieldTypeSmallInteger, alias: Lining Year, editable: true, nullable: true, defaultValue: null, modelName: LINING_YEAR )
• source_accuracy ( type: esriFieldTypeString, alias: Source/Accuracy, editable: true, nullable: true, length: 25, defaultValue: null, modelName: SOURCE_ACCURACY , Coded Values: [CONSULTANT: Consultant] , [CSM: CSM] , [DIGITIZED: Digitized] , ...12 more... )
• Shape__Length ( type: esriFieldTypeDouble, alias: st_length(shape), editable: false, nullable: false, defaultValue: null, modelName: st_length(shape) )

Types:

ID: 0
Name: Main
Domains:
• ds_inv_accuracy:
  Inherited
• us_inv_accuracy:
  Inherited
• material:
  Inherited
• status:
  Inherited
• owner:
  Inherited
• street:
  Inherited
• lining:
  Coded Values: [CIP: Cured in Place] , [SL: Slip Lined] , [NONE: None] , ...1 more...
• easement:
  Coded Values: [NO: No] , [YES: Yes]
• flow:
  Coded Values: [N: North] , [NE: Northeast] , [E: East] , ...5 more...
• source_accuracy:
  Inherited
Templates:
• Name: Main
  Description:
  Prototype:
  function_: 0
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 1
Name: Force Main
Domains:
• ds_inv_accuracy:
  Inherited
• us_inv_accuracy:
  Inherited
• material:
  Inherited
• status:
  Inherited
• owner:
  Inherited
• street:
  Inherited
• us_vert_datum:
  Inherited
• ds_vert_datum:
  Inherited
• lining:
  Coded Values: [CIP: Cured in Place] , [SL: Slip Lined] , [NONE: None] , ...1 more...
• easement:
  Coded Values: [NO: No] , [YES: Yes]
• flow:
  Coded Values: [N: North] , [NE: Northeast] , [E: East] , ...5 more...
• source_accuracy:
  Inherited
Templates:
• Name: Force Main
  Description:
  Prototype:
  function_: 1
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 2
Name: Interceptor
Domains:
• ds_inv_accuracy:
  Inherited
• us_inv_accuracy:
  Inherited
• material:
  Inherited
• status:
  Inherited
• owner:
  Inherited
• street:
  Inherited
• us_vert_datum:
  Inherited
• ds_vert_datum:
  Inherited
• lining:
  Coded Values: [CIP: Cured in Place] , [SL: Slip Lined] , [NONE: None] , ...1 more...
• easement:
  Coded Values: [NO: No] , [YES: Yes]
• flow:
  Coded Values: [N: North] , [NE: Northeast] , [E: East] , ...5 more...
• source_accuracy:
  Inherited
Templates:
• Name: Interceptor
  Description:
  Prototype:
  function_: 2
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 4
Name: Plug
Domains:
• ds_inv_accuracy:
  Inherited
• us_inv_accuracy:
  Inherited
• material:
  Inherited
• status:
  Inherited
• owner:
  Inherited
• street:
  Inherited
• us_vert_datum:
  Inherited
• ds_vert_datum:
  Inherited
• lining:
  Coded Values: [CIP: Cured in Place] , [SL: Slip Lined] , [NONE: None] , ...1 more...
• easement:
  Coded Values: [NO: No] , [YES: Yes]
• flow:
  Coded Values: [N: North] , [NE: Northeast] , [E: East] , ...5 more...
• source_accuracy:
  Inherited
Templates:
• Name: Plug
  Description:
  Prototype:
  function_: 4
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 5
Name: Stub
Domains:
• ds_inv_accuracy:
  Inherited
• us_inv_accuracy:
  Inherited
• material:
  Inherited
• status:
  Inherited
• owner:
  Inherited
• street:
  Inherited
• us_vert_datum:
  Inherited
• ds_vert_datum:
  Inherited
• lining:
  Coded Values: [CIP: Cured in Place] , [SL: Slip Lined] , [NONE: None] , ...1 more...
• easement:
  Coded Values: [NO: No] , [YES: Yes]
• flow:
  Coded Values: [N: North] , [NE: Northeast] , [E: East] , ...5 more...
• source_accuracy:
  Inherited
Templates:
• Name: Stub
  Description:
  Prototype:
  function_: 5
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 6
Name: Overflow
Domains:
• ds_inv_accuracy:
  Inherited
• us_inv_accuracy:
  Inherited
• material:
  Inherited
• status:
  Inherited
• owner:
  Inherited
• street:
  Inherited
• us_vert_datum:
  Inherited
• ds_vert_datum:
  Inherited
• lining:
  Coded Values: [CIP: Cured in Place] , [SL: Slip Lined] , [NONE: None] , ...1 more...
• easement:
  Coded Values: [NO: No] , [YES: Yes]
• flow:
  Coded Values: [N: North] , [NE: Northeast] , [E: East] , ...5 more...
• source_accuracy:
  Inherited
Templates:
• Name: Overflow
  Description:
  Prototype:
  function_: 6
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 7
Name: Unknown
Domains:
• ds_inv_accuracy:
  Inherited
• us_inv_accuracy:
  Inherited
• material:
  Inherited
• status:
  Inherited
• owner:
  Inherited
• street:
  Inherited
• us_vert_datum:
  Inherited
• ds_vert_datum:
  Inherited
• lining:
  Coded Values: [CIP: Cured in Place] , [SL: Slip Lined] , [NONE: None] , ...1 more...
• easement:
  Coded Values: [NO: No] , [YES: Yes]
• flow:
  Coded Values: [N: North] , [NE: Northeast] , [E: East] , ...5 more...
• source_accuracy:
  Inherited
Templates:
• Name: Unknown
  Description:
  Prototype:
  function_: 7
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 8
Name: Abandoned
Domains:
• ds_inv_accuracy:
  Inherited
• us_inv_accuracy:
  Inherited
• material:
  Inherited
• status:
  Inherited
• owner:
  Inherited
• street:
  Inherited
• us_vert_datum:
  Inherited
• ds_vert_datum:
  Inherited
• flow:
  Inherited
• source_accuracy:
  Inherited
Templates:
• Name: Abandoned
  Description:
  Prototype:
  function_: 8
  
  Drawing Tool: esriFeatureEditToolLine

---

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Edit Fields Info:

• Creation Date Field: created
• Creator Field: creator
• Edit Date Field: edited
• Editor Field: editor

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Analytic   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata