View In:   ArcGIS Online Map Viewer

Name: Sanitary Lateral

Display Field: material

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: The sanitary lateral layer depicts all the sanitary laterals within the city of Fond du Lac, Wisconsin. It has information about the material, diameter, installation date, etc. The City Engineering & Traffic Division in the Department of Public Works maintains the data.

Service Item Id: 1450673ec26e45a7aee97ee25f6a70c7

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 1000

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: 291.1999291628599
YMin: 367804.7830144912
XMax: 837974.3952943273
YMax: 395528.3804543242
Spatial Reference: PROJCS["NAD_1983_HARN_WISCRS_Fond_du_Lac_County_Feet",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["Transverse_Mercator"],PARAMETER["False_Easting",802999.999],PARAMETER["False_Northing",0.016],PARAMETER["Central_Meridian",-88.5],PARAMETER["Scale_Factor",1.0000286569],PARAMETER["Latitude_Of_Origin",42.71944444444445],UNIT["Foot_US",0.3048006096012192]],VERTCS["NAVD_1988",VDATUM["North_American_Vertical_Datum_1988"],PARAMETER["Vertical_Shift",0.0],PARAMETER["Direction",1.0],UNIT["Foot_US",0.3048006096012192]]

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: status
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: ACTIVE
  Label: Active
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [85, 255, 0, 255]
  Width: 2
• Value: PROPOSED
  Label: Proposed
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 255, 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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: status

Fields:

• objectid ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• 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... )
• diameter ( type: esriFieldTypeSmallInteger, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: DIAMETER , Coded Values: [2: 2] , [3: 3] , [4: 4] , ...4 more... )
• date_installed ( type: esriFieldTypeDate, alias: Date Installed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE_INSTALLED )
• status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, 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... )
• inspected_by ( type: esriFieldTypeString, alias: Inspected By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Inspected_By , Coded Values: [ANDREW FREUND: Andrew Freund] , [CONSULTANT: Consultant] , [JAKE FREIBERG: Jake Freiberg] , ...4 more... )
• length ( type: esriFieldTypeDouble, alias: Length, editable: true, nullable: true, defaultValue: null, modelName: Length )
• pipe_quantity ( type: esriFieldTypeDouble, alias: Pipe Quantity, editable: true, nullable: true, defaultValue: null, modelName: Pipe_Quantity )
• riser ( type: esriFieldTypeString, alias: Riser, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Riser , Coded Values: [YES: Yes] , [NO: No] , [UNKNOWN: Unknown] , ...1 more... )
• riser_height ( type: esriFieldTypeDouble, alias: Riser Height, editable: true, nullable: true, defaultValue: null, modelName: Riser_Height )
• connected ( type: esriFieldTypeString, alias: Connected?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Connected , Coded Values: [Y: Yes] , [N: No] )
• connect_date ( type: esriFieldTypeDate, alias: Connect Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Connect_Date )
• connection_location ( type: esriFieldTypeString, alias: Connection Location, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Connection_Location , Coded Values: [BACK-OF-CURB: Back-of-curb] , [BACK-OF-WALK: Back-of-walk] , [FRONT-OF-WALK: Front-of-walk] , ...2 more... )
• ref_point_to_connection ( type: esriFieldTypeString, alias: Reference Point to Connection, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Ref_Point_to_Connection , Coded Values: [DOWNSTREAM MANHOLE: Downstream manhole] , [UPSTREAM MANHOLE: Upstream manhole] , [DOWNSTREAM CATCH BASIN: Downstream catch basin] , ...3 more... )
• connection_depth ( type: esriFieldTypeDouble, alias: Connection Depth, editable: true, nullable: true, defaultValue: null, modelName: Connection_Depth )
• distance_to_connection ( type: esriFieldTypeDouble, alias: Distance to Connection, editable: true, nullable: true, defaultValue: null, modelName: Distance_to_Connection )
• connection_elevation ( type: esriFieldTypeDouble, alias: Connection Elevation, editable: true, nullable: true, defaultValue: null, modelName: Connection_Elevation )
• location_description ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Location_Description )
• distance_to_wyecore ( type: esriFieldTypeDouble, alias: Distance to Wye/Core, editable: true, nullable: true, defaultValue: null, modelName: Distance_to_WyeCore )
• ref_point_to_wyecore ( type: esriFieldTypeString, alias: Reference Point to Wye/Core, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Ref_Point_to_WyeCore , Coded Values: [DOWNSTREAM MANHOLE: Downstream manhole] , [UPSTREAM MANHOLE: Upstream manhole] , [DOWNSTREAM CATCH BASIN: Downstream catch basin] , ...3 more... )
• down_inv_elevation ( type: esriFieldTypeDouble, alias: Down. Inv. Elevation, editable: true, nullable: true, defaultValue: null, modelName: Down_Inv_Elevation )
• notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 300, defaultValue: null, modelName: Notes )
• id ( type: esriFieldTypeString, alias: ID, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ML_Asset_ID )
• address_number ( type: esriFieldTypeDouble, alias: Address Number, editable: true, nullable: true, defaultValue: null, modelName: Address_Number )
• street ( type: esriFieldTypeString, alias: Street, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Street , Coded Values: [*see parcel: *see parcel] , [01ST ST E: E 1st St] , [01ST ST W: W 1st St] , ...599 more... )
• full_address ( type: esriFieldTypeString, alias: Full Address, editable: true, nullable: true, length: 150, defaultValue: null, modelName: Full_Address )
• creator ( type: esriFieldTypeString, alias: Creator, editable: false, nullable: true, length: 20, defaultValue: null, modelName: CREATE_USR )
• created ( type: esriFieldTypeDate, alias: Created, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CREATIONDATE )
• editor ( type: esriFieldTypeString, alias: Editor, editable: false, nullable: true, length: 20, defaultValue: null, modelName: LST_EDT_USR )
• edited ( type: esriFieldTypeDate, alias: Edited, editable: false, nullable: true, length: 8, defaultValue: null, modelName: EDITDATE )
• globalid ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• 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: ACTIVE
Name: Active
Domains:
• material:
  Inherited
• diameter:
  Inherited
• status:
  Inherited
• owner:
  Inherited
• inspected_by:
  Inherited
• riser:
  Inherited
• connected:
  Inherited
• connection_location:
  Inherited
• ref_point_to_connection:
  Inherited
• ref_point_to_wyecore:
  Inherited
• street:
  Inherited
• source_accuracy:
  Inherited
Templates:
• Name: Active
  Description:
  Prototype:
  status: ACTIVE
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: PROPOSED
Name: Proposed
Domains:
• material:
  Inherited
• diameter:
  Inherited
• status:
  Inherited
• owner:
  Inherited
• inspected_by:
  Inherited
• riser:
  Inherited
• connected:
  Inherited
• connection_location:
  Inherited
• ref_point_to_connection:
  Inherited
• ref_point_to_wyecore:
  Inherited
• street:
  Inherited
• source_accuracy:
  Inherited
Templates:
• Name: Proposed
  Description:
  Prototype:
  status: PROPOSED
  
  Drawing Tool: esriFeatureEditToolLine

---

Capabilities: Query,Create,Update,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

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   Apply Edits   Add Features   Update Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata