Name: wLateral

Display Field: STREETNAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: 9676b91ef3c84275825466b38c1d17c5

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 3600.0

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: 245811.81951880455
YMin: 190739.47965572774
XMax: 295749.24785897136
YMax: 231585.39829181135
Spatial Reference: 103436  (8150)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: SUBTYPE
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 1
  Label: Service
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [148, 196, 255, 255]
  Width: 1
Transparency: 0
Labeling Info:

Feature Draw Order:

N/A

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

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: SubType

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled , Coded Values: [0: False] , [1: True] )
• SUBTYPE ( type: esriFieldTypeInteger, alias: SubType )
• ADMINISTRATIVEAREA ( type: esriFieldTypeString, alias: Administrative Area, length: 30 , Coded Values: [East: East Side of Wisconsin River] , [West: West Side of Wisconsin River] )
• FACILITYID ( type: esriFieldTypeString, alias: Facility ID, length: 24 )
• UTILINSTALLDATE ( type: esriFieldTypeDate, alias: Utility Install Date, length: 8 )
• LIFECYCLESTATUS ( type: esriFieldTypeString, alias: Life Cycle Status, length: 10 , Coded Values: [ABANDONED: Abandoned] , [ACTIVE: Active] , [PROPOSED: Proposed] , ...1 more... )
• DATASOURCE ( type: esriFieldTypeString, alias: Data Source, length: 24 , Coded Values: [ACAD1: ACAD1] , [Aerometric1990: Aerometric1990] , [Aerometric2000: Aerometric2000] , ...6 more... )
• LOCATIONDESCRIPTION ( type: esriFieldTypeString, alias: LOCATION DESCRIPTION, length: 150 )
• UTILMATERIAL ( type: esriFieldTypeString, alias: Utility Material, length: 17 , Coded Values: [BRASS: Brass] , [CIP: Cast Iron Pipe] , [CONCRETE: Concrete] , ...11 more... )
• ACCOUNTNUMBER ( type: esriFieldTypeString, alias: Account Number, length: 8 )
• STREETNUMBER ( type: esriFieldTypeInteger, alias: Street Number )
• STREETDIRECTION ( type: esriFieldTypeString, alias: Street Direction, length: 2 , Coded Values: [N: N] , [S: S] , [E: E] , ...1 more... )
• STREETNAME ( type: esriFieldTypeString, alias: Street Name, length: 40 , Coded Values: [10th: 10th] , [11th: 11th] , [12th: 12th] , ...582 more... )
• STREETDESIGNATION ( type: esriFieldTypeString, alias: Street Designation, length: 4 , Coded Values: [Av: Avenue] , [Blvd: Boulevard] , [Cir: Circle] , ...13 more... )
• RENEWAL ( type: esriFieldTypeInteger, alias: Renewal , Coded Values: [1: True] , [0: False] )
• PLUMBER ( type: esriFieldTypeString, alias: Plumber, length: 50 )
• PIN ( type: esriFieldTypeString, alias: PIN, length: 17 )
• LATERALTYPE ( type: esriFieldTypeString, alias: Lateral Type, length: 17 , Coded Values: [Domestic: Domestic] , [Commercial: Commercial] , [Industrial: Industrial] , ...1 more... )
• DIAMETER ( type: esriFieldTypeDouble, alias: Diameter )
• ADDITIONALRECORDS ( type: esriFieldTypeInteger, alias: Additional Records , Coded Values: [1: True] , [0: False] )
• INSPECTDATE ( type: esriFieldTypeDate, alias: Inspect Date, length: 8 )
• ServiceLength ( type: esriFieldTypeDouble, alias: Service Length )
• CUSTMATERIAL ( type: esriFieldTypeString, alias: Customer Material, length: 25 , Coded Values: [BRASS: Brass] , [CIP: Cast Iron Pipe] , [CONCRETE: Concrete] , ...11 more... )
• GIS_Length ( type: esriFieldTypeDouble, alias: GIS_Length )
• 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 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• CUSTDIAMETER ( type: esriFieldTypeDouble, alias: Customer Diameter , Coded Values: [0.5: 0.5"] , [0.625: .625"] , [0.75: .75"] , ...11 more... )
• PRIVATE ( type: esriFieldTypeInteger, alias: Private , Coded Values: [1: True] , [0: False] )
• SHAPE ( type: esriFieldTypeGeometry, alias: Shape )
• METERSIZE ( type: esriFieldTypeDouble, alias: Meter Size , Coded Values: [0.625: .625"] , [14: 14"] , [16: 16"] , ...14 more... )
• METERNUMBER ( type: esriFieldTypeString, alias: Meter Number, length: 11 )
• SPRINKLERNUMBER ( type: esriFieldTypeString, alias: Sprinkler Number, length: 11 )
• INTERIORPLUMBING_MATERIAL ( type: esriFieldTypeString, alias: Interior Plumbing Material, length: 50 , Coded Values: [BRASS: Brass] , [CIP: Cast Iron Pipe] , [CONCRETE: Concrete] , ...11 more... )
• CUSTSOURCE ( type: esriFieldTypeString, alias: Customer Material Source, length: 20 , Coded Values: [Staff Verification: Staff Verification] , [Tap Card: Tap Card] , [Year Structure Built: Year Structure Built] )
• CUSTVERIDATE1 ( type: esriFieldTypeDate, alias: Customer Verification Date 1, length: 8 )
• CUSTVERIDATE2 ( type: esriFieldTypeDate, alias: Customer Verification Date 2, length: 8 )
• CUSTVERITECH1 ( type: esriFieldTypeString, alias: Customer Verification Tech 1, length: 75 )
• CUSTVERITECH2 ( type: esriFieldTypeString, alias: Customer Verification Tech 2, length: 75 )
• INTERIORVERIDATE1 ( type: esriFieldTypeDate, alias: Interior Verification Date 1, length: 8 )
• INTERIORVERIDATE2 ( type: esriFieldTypeDate, alias: Interior Verification Date 2, length: 8 )
• INTERIORVERITECH1 ( type: esriFieldTypeString, alias: Interior Verification Tech 1, length: 75 )
• INTERIORVERITECH2 ( type: esriFieldTypeString, alias: Interior Verification Tech 2, length: 75 )
• UTILSOURCE ( type: esriFieldTypeString, alias: Utility Material Source, length: 20 , Coded Values: [Staff Verification: Staff Verification] , [Tap Card: Tap Card] , [Year Structure Built: Year Structure Built] )
• UTILVERIDATE1 ( type: esriFieldTypeDate, alias: Utility Verification Date 1, length: 8 )
• UTILVERIDATE2 ( type: esriFieldTypeDate, alias: Utility Verification Date 2, length: 8 )
• UTILVERITECH1 ( type: esriFieldTypeString, alias: Utility Verification Tech 1, length: 75 )
• UTILVERITECH2 ( type: esriFieldTypeString, alias: Utility Verification Tech 2, length: 75 )
• CUSTINSTALLDATE ( type: esriFieldTypeDate, alias: Customer Install Date, length: 8 )
• YEARSTRUCTUREBUILT ( type: esriFieldTypeString, alias: Year Structure Built, length: 4 )
• CUSTPREVIOUSDIAMETER ( type: esriFieldTypeDouble, alias: Customer Previous Diameter , Coded Values: [0.5: 0.5"] , [0.625: .625"] , [0.75: .75"] , ...11 more... )
• CUSTPREVIOUSMATERIAL1 ( type: esriFieldTypeString, alias: Customer Previous Material 1, length: 17 , Coded Values: [BRASS: Brass] , [CIP: Cast Iron Pipe] , [CONCRETE: Concrete] , ...11 more... )
• CUSTPREVIOUSMATERIAL2 ( type: esriFieldTypeString, alias: Customer Previous Material 2, length: 17 , Coded Values: [BRASS: Brass] , [CIP: Cast Iron Pipe] , [CONCRETE: Concrete] , ...11 more... )
• TAIL ( type: esriFieldTypeSmallInteger, alias: Tail , Coded Values: [0: False] , [1: True] )
• TAILLENGTH ( type: esriFieldTypeDouble, alias: Tail Length )
• UTILPREVIOUSDIAMETER ( type: esriFieldTypeDouble, alias: Utility Previous Diameter , Coded Values: [0.5: 0.5"] , [0.625: .625"] , [0.75: .75"] , ...11 more... )
• UTILPREVIOUSMATERIAL1 ( type: esriFieldTypeString, alias: Utility Previous Material 1, length: 17 , Coded Values: [BRASS: Brass] , [CIP: Cast Iron Pipe] , [CONCRETE: Concrete] , ...11 more... )
• UTILPREVIOUSMATERIAL2 ( type: esriFieldTypeString, alias: Utility Previous Material 2, length: 17 , Coded Values: [BRASS: Brass] , [CIP: Cast Iron Pipe] , [CONCRETE: Concrete] , ...11 more... )
• REMARKS ( type: esriFieldTypeString, alias: Remarks, length: 100 )
• CENSUSTRACT2020 ( type: esriFieldTypeString, alias: Census Tract 2020, length: 5 )
• ENTIRELINEMATERIALCLASS ( type: esriFieldTypeString, alias: Entire Line Material Classification, length: 35 , Coded Values: [Lead: Lead] , [Non-Lead: Non-Lead] , [Lead Status Unknown: Lead Status Unknown] , ...1 more... )
• SITEID ( type: esriFieldTypeString, alias: Site ID, length: 60 )
• LOCATIONIDENTIFIER ( type: esriFieldTypeString, alias: Location Identifier, length: 60 )
• GOOSENECKCURRENTLYPRESENT ( type: esriFieldTypeString, alias: Gooseneck Currently Present, length: 3 )
• CURRENTSTREETSIDESERVLINEMAT ( type: esriFieldTypeString, alias: Current Street Side Service Line Material, length: 10 , Coded Values: [L: Confirmed Lead] , [C: Confirmed Copper] , [G: Confirmed Galvinized] , ...6 more... )
• WASSTRSIDESERVICEMATERIALLEAD ( type: esriFieldTypeString, alias: Was Street Side Service Line Material Ever Previously Lead, length: 10 , Coded Values: [Y: Yes] , [N: No] , [UNK: Unknown] )
• STREETSIDESERVICELINESIZE ( type: esriFieldTypeString, alias: Street Side Service Line Size, length: 5 )
• STRESIDESERVICEINSTALLDATE ( type: esriFieldTypeDate, alias: Street Side Service Line Install Date, length: 8 )
• CURRENTPROPSIDESERVLINEMAT ( type: esriFieldTypeString, alias: Current Property Side Service Line Material, length: 15 , Coded Values: [L: Confirmed Lead] , [C: Confirmed Copper] , [G: Confirmed Galvinized] , ...6 more... )
• PROPSIDESERVLINESIZE ( type: esriFieldTypeString, alias: Property Side Service Line Size, length: 5 )
• PROPSIDESERVLINEINSTALLDATE ( type: esriFieldTypeDate, alias: Property Side Service Line Install Date, length: 8 )
• BUILDINGTYPE ( type: esriFieldTypeString, alias: Building Type, length: 10 , Coded Values: [SF: Single-Family Residential] , [MF: Multi-Family Residential] , [SCH/CC: School or Child Care] , ...4 more... )
• POINTENTRYPOINTUSETREATMENT ( type: esriFieldTypeString, alias: Point of Entry or Point of Use Treatment Present, length: 5 )
• BUILDINGPLUMBINGMATERIAL1 ( type: esriFieldTypeString, alias: Building Plumbing Material 1, length: 17 )
• BUILDINGPLUMBINGMATERIAL2 ( type: esriFieldTypeString, alias: Building Plumbing Material 2, length: 5 )
• BUILDINGPLUMBMATINSTALLDATE ( type: esriFieldTypeDate, alias: Building Plumbing Material Install Date, length: 8 )
• COMMENTS ( type: esriFieldTypeString, alias: Comments, length: 55 )
• BASISOFSTSIDEMATCLASSIFICATIO ( type: esriFieldTypeString, alias: Basis of Street Side Material Classification, length: 50 )
• WASSTRESIDEMATFIELDVERIFIED ( type: esriFieldTypeString, alias: Was Street Side Material Field Verified, length: 5 )
• DATEOFSTRSIDEFIELDVERIFICATIO ( type: esriFieldTypeDate, alias: Date of Street Side Field Verification, length: 8 )
• METHODOFSTSIDEFIELDVERIFICATI ( type: esriFieldTypeString, alias: Method of Street Side Field Verification, length: 50 )
• BASISOFPROPSIDEMATCLASSIFICAT ( type: esriFieldTypeString, alias: Basis of Property Side Material Classification, length: 50 )
• WASPROPSIDMATFIELDVERIFIED ( type: esriFieldTypeString, alias: Was Property Side Material Field Verified, length: 5 )
• METHODOFPROPSIDEFIELDVERIFICA ( type: esriFieldTypeString, alias: Method of Property Side Field Verification, length: 50 )
• NOTESMATERIALCLASSIFICATION ( type: esriFieldTypeString, alias: Notes Material Classification, length: 35 )
• HouseNumbers ( type: esriFieldTypeString, alias: HouseNumbers, length: 20 )
• DATEOFPROPSIDEFIELDVERIFICATION ( type: esriFieldTypeDate, alias: Date of Property Side Field Verification, length: 8 )
• SHAPE.STLength() ( type: esriFieldTypeDouble, alias: SHAPE.STLength() )

Types:

ID: 1
Name: Service
Domains:
• ENABLED:
  Inherited
• SUBTYPE:
  Coded Values: [1: Water Service Lateral]
• ADMINISTRATIVEAREA:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• DATASOURCE:
  Inherited
• UTILMATERIAL:
  Inherited
• STREETDIRECTION:
  Coded Values: [N: North] , [S: South] , [E: East] , ...1 more...
• STREETNAME:
  Inherited
• STREETDESIGNATION:
  Coded Values: [Av: Avenue] , [Blvd: Boulevard] , [Ctr: Center] , ...14 more...
• RENEWAL:
  Inherited
• LATERALTYPE:
  Inherited
• DIAMETER:
  Coded Values: [0.5: 0.5"] , [0.625: .625"] , [0.75: .75"] , ...11 more...
• CUSTMATERIAL:
  Inherited
• CUSTDIAMETER:
  Inherited
• PRIVATE:
  Inherited
• METERSIZE:
  Inherited
• INTERIORPLUMBING_MATERIAL:
  Inherited
• CUSTSOURCE:
  Inherited
• UTILSOURCE:
  Inherited
• CUSTPREVIOUSDIAMETER:
  Inherited
• CUSTPREVIOUSMATERIAL1:
  Inherited
• CUSTPREVIOUSMATERIAL2:
  Inherited
• TAIL:
  Inherited
• UTILPREVIOUSDIAMETER:
  Inherited
• UTILPREVIOUSMATERIAL1:
  Inherited
• UTILPREVIOUSMATERIAL2:
  Inherited
• ENTIRELINEMATERIALCLASS:
  Inherited
• GOOSENECKCURRENTLYPRESENT:
  Coded Values: [Y: Yes - With Certainty] , [N: No - With Certainty] , [UNK: Not Known With Certainty]
• CURRENTSTREETSIDESERVLINEMAT:
  Inherited
• WASSTRSIDESERVICEMATERIALLEAD:
  Inherited
• CURRENTPROPSIDESERVLINEMAT:
  Inherited
• BUILDINGTYPE:
  Inherited
• BASISOFSTSIDEMATCLASSIFICATIO:
  Coded Values: [Installation record: Installation record (Tap Card)] , [Field inspection only: Field inspection only with no records] , [SL repair/replace record: Service line repair or replacement record] , ...4 more...
• METHODOFSTSIDEFIELDVERIFICATI:
  Coded Values: [Visual insp during install or repair: Visual inspection during construction or repair] , [Visual insp at meter: Visual inspection at the meter pit] , [Mech excavc: Mechanical excavation at one location] , ...5 more...
• BASISOFPROPSIDEMATCLASSIFICAT:
  Coded Values: [Installation record: Installation record (Tap Card)] , [Field inspection only: Field inspection only with no records] , [SL repair/replace record: Service line repair or replacement record] , ...4 more...
• METHODOFPROPSIDEFIELDVERIFICA:
  Coded Values: [Visual insp during install or repair: Visual inspection during construction or repair] , [Visual insp at meter: Visual inspection at the meter pit] , [Mech excavc: Mechanical excavation at one location] , ...5 more...

---

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

  Iteminfo   Thumbnail   Metadata