View In:   ArcGIS Online Map Viewer

Name: wtrServiceLateral

Display Field: stname

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: eef310124b8f4299aae27a1d5f4bcb8d

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 6000.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: 1599359.8450927734
YMin: 672105.771118179
XMax: 1707612.573486358
YMax: 754176.604675293
Spatial Reference: 102722  (3734)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: svctype
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 1
  Label: Domestic
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 255, 255, 255]
  Width: 2
• Value: 2
  Label: Fire
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 255, 255, 255]
  Width: 3
• Value: 3
  Label: Irrigation
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 255, 255, 255]
  Width: 3
• Value: 4
  Label: Null
  Description: N/A
  Symbol:
  Style: esriSLSDash
  Color: [115, 223, 255, 255]
  Width: 2
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: true
Supports Query With LOD Spatial Reference: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: svctype

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
• assetid ( modelName: AssetID, nullable: true, editable: true, defaultValue: null, length: 20, alias: AssetID, type: esriFieldTypeString )
• legacyid ( modelName: LegacyID, nullable: true, editable: true, defaultValue: null, length: 20, alias: LegacyID, type: esriFieldTypeString )
• installationdate ( modelName: InstallationDate, nullable: true, editable: true, defaultValue: null, length: 29, alias: InstallationDate, type: esriFieldTypeDate )
• location ( modelName: Location, nullable: true, editable: true, defaultValue: null, length: 250, alias: Location, type: esriFieldTypeString )
• status ( modelName: Status, nullable: true, editable: true, defaultValue: null, length: 10, alias: Status, type: esriFieldTypeString , Coded Values: [A: Abandoned] , [EOC: End of Contract] , [P: Abandoned and Filled] , ...9 more... )
• source ( modelName: Source, nullable: true, editable: true, defaultValue: null, length: 20, alias: Source, type: esriFieldTypeString , Coded Values: [ATL: Atlas] , [ASB: As Built] , [FVE: Field Verified] , ...14 more... )
• comments ( modelName: Comments, nullable: true, editable: true, defaultValue: null, length: 250, alias: Comments, type: esriFieldTypeString )
• svctype ( modelName: SvcType, nullable: true, editable: true, defaultValue: 1, alias: Type, type: esriFieldTypeInteger )
• diameter ( modelName: Diameter, nullable: true, editable: true, defaultValue: null, alias: Service Size, type: esriFieldTypeDouble , Coded Values: [0.625: 5/8] , [0.75: 3/4] , [1: 1] , ...9 more... )
• asbuilt ( modelName: Asbuilt, nullable: true, editable: true, defaultValue: null, length: 20, alias: Asbuilt, type: esriFieldTypeString )
• tapmaindiam ( modelName: TapMainDiam, nullable: true, editable: true, defaultValue: null, alias: Tapped Main Diameter, type: esriFieldTypeDouble , Coded Values: [4: 4] , [6: 6] , [8: 8] , ...16 more... )
• address ( modelName: Address, nullable: true, editable: true, defaultValue: null, length: 60, alias: Address, type: esriFieldTypeString )
• depthofcover ( modelName: DepthOfCover, nullable: true, editable: true, defaultValue: null, alias: Depth of Main at Tap, type: esriFieldTypeDouble )
• stnumber ( modelName: StNumber, nullable: true, editable: true, defaultValue: null, length: 25, alias: Street Number, type: esriFieldTypeString )
• stname ( modelName: StName, nullable: true, editable: true, defaultValue: null, length: 50, alias: Street Name, type: esriFieldTypeString )
• length ( modelName: Length, nullable: true, editable: true, defaultValue: null, alias: Pipe Length, type: esriFieldTypeDouble )
• wo ( modelName: WO, nullable: true, editable: true, defaultValue: null, length: 7, alias: WO, type: esriFieldTypeString )
• overtap ( modelName: OverTap, nullable: true, editable: true, defaultValue: null, length: 3, alias: OverTap, type: esriFieldTypeString , Coded Values: [NO: NO] , [YES: YES] )
• split ( modelName: Split, nullable: true, editable: true, defaultValue: null, length: 10, alias: Split, type: esriFieldTypeString , Coded Values: [NO: NO] , [YES: YES] )
• urllink ( modelName: URLLink, nullable: true, editable: true, defaultValue: null, length: 200, alias: URLLink, type: esriFieldTypeString )
• date_material_verified ( modelName: Date_Material_Verified, nullable: true, editable: true, defaultValue: null, length: 29, alias: Date_Material_Verified, type: esriFieldTypeDate )
• cityownedmaterial ( modelName: Material, nullable: true, editable: true, defaultValue: null, length: 30, alias: CityOwnedMaterial, type: esriFieldTypeString , Coded Values: [LEAD: LEAD] , [GALVANIZED: GALVANIZED] , [UNKNOWN: UNKNOWN] , ...4 more... )
• customerownedmaterial ( modelName: Mat_Cust, nullable: true, editable: true, defaultValue: null, length: 30, alias: Customer Owned Material, type: esriFieldTypeString , Coded Values: [LEAD: LEAD] , [GALVANIZED: GALVANIZED] , [UNKNOWN: UNKNOWN] , ...4 more... )
• datecitymaterialreplaced ( modelName: DateLeadReplaced, nullable: true, editable: true, defaultValue: null, length: 29, alias: Date City Material Replaced, type: esriFieldTypeDate )
• datecustomermaterialreplaced ( modelName: DateCustSideReplaced, nullable: true, editable: true, defaultValue: null, length: 29, alias: DateCustomerMaterialReplaced, type: esriFieldTypeDate )
• datekilled ( modelName: DateKilled, nullable: true, editable: true, defaultValue: null, length: 29, alias: Date Killed, type: esriFieldTypeDate )
• city ( modelName: Owner, nullable: true, editable: true, defaultValue: null, length: 50, alias: City, type: esriFieldTypeString )
• zipcode ( modelName: CustomerType, nullable: true, editable: true, defaultValue: null, length: 20, alias: ZipCode, type: esriFieldTypeString )
• plan_hyperlink ( modelName: Plan, nullable: true, editable: true, defaultValue: null, length: 150, alias: Plan Hyperlink, type: esriFieldTypeString )
• longitude ( modelName: X, nullable: true, editable: true, defaultValue: null, alias: Longitude, type: esriFieldTypeDouble )
• latitude ( modelName: Y, nullable: true, editable: true, defaultValue: null, alias: Latitude, type: esriFieldTypeDouble )
• pwsid ( modelName: PWSID, nullable: true, editable: true, defaultValue: null, length: 25, alias: PWSID, type: esriFieldTypeString )
• county ( modelName: County, nullable: true, editable: true, defaultValue: null, length: 50, alias: County, type: esriFieldTypeString )
• premise ( modelName: ConObj, nullable: true, editable: true, defaultValue: null, length: 50, alias: Premise, type: esriFieldTypeString )
• requiredreplacement ( modelName: RequiredReplacement, nullable: true, editable: true, defaultValue: null, length: 50, alias: RequiredReplacement, type: esriFieldTypeString , Coded Values: [LEAD: LEAD] , [GALVANIZED: GALVANIZED] , [UNKNOWN: UNKNOWN] )
• planname ( modelName: PlanName, nullable: true, editable: true, defaultValue: null, length: 30, alias: PlanName, type: esriFieldTypeString )
• SHAPE__Length ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Length, type: esriFieldTypeDouble )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, alias: globalid, type: esriFieldTypeGlobalID )

Types:

ID: 1
Name: Domestic
Domains:
• split:
  Inherited
• diameter:
  Inherited
• customerownedmaterial:
  Inherited
• tapmaindiam:
  Inherited
• cityownedmaterial:
  Inherited
• source:
  Inherited
• overtap:
  Inherited
• status:
  Inherited
Templates:
• Name: Domestic
  Description:
  Prototype:
  city: null
  pwsid: null
  installationdate: null
  latitude: null
  county: null
  requiredreplacement: null
  date_material_verified: null
  source: null
  urllink: null
  split: null
  diameter: null
  premise: null
  planname: null
  wo: null
  asbuilt: null
  depthofcover: null
  longitude: null
  comments: null
  address: null
  customerownedmaterial: null
  tapmaindiam: null
  datekilled: null
  svctype: 1
  length: null
  datecitymaterialreplaced: null
  zipcode: null
  assetid: null
  cityownedmaterial: null
  stnumber: null
  legacyid: null
  location: null
  overtap: null
  plan_hyperlink: null
  datecustomermaterialreplaced: null
  status: null
  stname: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 2
Name: Fire
Domains:
• split:
  Inherited
• diameter:
  Inherited
• customerownedmaterial:
  Inherited
• tapmaindiam:
  Inherited
• cityownedmaterial:
  Inherited
• source:
  Inherited
• overtap:
  Inherited
• status:
  Inherited
Templates:
• Name: Fire
  Description:
  Prototype:
  city: null
  pwsid: null
  installationdate: null
  latitude: null
  county: null
  requiredreplacement: null
  date_material_verified: null
  source: null
  urllink: null
  split: null
  diameter: null
  premise: null
  planname: null
  wo: null
  asbuilt: null
  depthofcover: null
  longitude: null
  comments: null
  address: null
  customerownedmaterial: null
  tapmaindiam: null
  datekilled: null
  svctype: 2
  length: null
  datecitymaterialreplaced: null
  zipcode: null
  assetid: null
  cityownedmaterial: null
  stnumber: null
  legacyid: null
  location: null
  overtap: null
  plan_hyperlink: null
  datecustomermaterialreplaced: null
  status: null
  stname: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 3
Name: Irrigation
Domains:
• split:
  Inherited
• diameter:
  Inherited
• customerownedmaterial:
  Inherited
• tapmaindiam:
  Inherited
• cityownedmaterial:
  Inherited
• source:
  Inherited
• overtap:
  Inherited
• status:
  Inherited
Templates:
• Name: Irrigation
  Description:
  Prototype:
  city: null
  pwsid: null
  installationdate: null
  latitude: null
  county: null
  requiredreplacement: null
  date_material_verified: null
  source: null
  urllink: null
  split: null
  diameter: null
  premise: null
  planname: null
  wo: null
  asbuilt: null
  depthofcover: null
  longitude: null
  comments: null
  address: null
  customerownedmaterial: null
  tapmaindiam: null
  datekilled: null
  svctype: 3
  length: null
  datecitymaterialreplaced: null
  zipcode: null
  assetid: null
  cityownedmaterial: null
  stnumber: null
  legacyid: null
  location: null
  overtap: null
  plan_hyperlink: null
  datecustomermaterialreplaced: null
  status: null
  stname: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 4
Name: Unknown
Domains:
• split:
  Inherited
• diameter:
  Inherited
• customerownedmaterial:
  Inherited
• tapmaindiam:
  Inherited
• cityownedmaterial:
  Inherited
• source:
  Inherited
• overtap:
  Inherited
• status:
  Coded Values: [I: In Service] , [R: Removed] , [K: Killed] , ...2 more...
Templates:
• Name: Null
  Description:
  Prototype:
  city: null
  pwsid: null
  installationdate: null
  latitude: null
  county: null
  requiredreplacement: null
  date_material_verified: null
  source: null
  urllink: null
  split: null
  diameter: null
  premise: null
  planname: null
  wo: null
  asbuilt: null
  depthofcover: null
  longitude: null
  comments: null
  address: null
  customerownedmaterial: null
  tapmaindiam: null
  datekilled: null
  svctype: 4
  length: null
  datecitymaterialreplaced: null
  zipcode: null
  assetid: null
  cityownedmaterial: null
  stnumber: null
  legacyid: null
  location: null
  overtap: null
  plan_hyperlink: null
  datecustomermaterialreplaced: null
  status: null
  stname: null
  
  Drawing Tool: esriFeatureEditToolLine

---

Capabilities: Create,Editing,Uploads,Query,Update,Delete

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Metadata