View In:   ArcGIS Online Map Viewer

Name: D Small Service

Display Field: DIAMETER

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: 3931679a96d24ec3a9c0b767bb20e1ad

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 1201.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

Supports Datum Transformation: true

Extent:

XMin: 1304888.5580245964
YMin: -2141236.2657040507
XMax: 6857209.124293014
YMax: 3373599.237411283
Spatial Reference: 102717  (2262)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: MATERIAL
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSLSSolid
Color: [255, 255, 0, 255]
Width: 4
Default Label: <all other values>
UniqueValueInfos:
• Value: Copper
  Label: Copper
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [230, 152, 0, 255]
  Width: 1
• Value: Galvanized
  Label: Galvanized
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [168, 56, 0, 255]
  Width: 1
• Value: Lead
  Label: Lead
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [78, 78, 78, 255]
  Width: 1
• Value: Lead Lined
  Label: Lead Lined
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [168, 112, 0, 255]
  Width: 1
• Value: PVC
  Label: PVC
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 197, 255, 255]
  Width: 1
• Value: PVCO
  Label: PVCO
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 168, 132, 255]
  Width: 1
• Value: Plastic
  Label: Plastic
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 230, 169, 255]
  Width: 1
• Value: Polyethylene
  Label: Polyethylene
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 132, 168, 255]
  Width: 1
• Value: Wrought Iron
  Label: Wrought Iron
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [230, 96, 110, 255]
  Width: 1
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: MATERIAL

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• SYSTEMNAME ( type: esriFieldTypeString, alias: System Name, editable: true, nullable: true, length: 25, defaultValue: null, modelName: SYSTEMNAME , Coded Values: [Bypass: Bypass] , [Canadice: Canadice] , [Domestic: Domestic] , ...5 more... )
• SerialNumber ( type: esriFieldTypeString, alias: Serial Number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SerialNumber )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• DIAMETER ( type: esriFieldTypeDouble, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: DIAMETER , Coded Values: [0.375: 3/8"] , [0.5: 1/2"] , [0.625: 5/8"] , ...26 more... )
• MATERIAL ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MATERIAL , Coded Values: [Brass: Brass] , [Cast Iron: Cast Iron] , [Copper: Copper] , ...14 more... )
• LOCDESC ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LOCDESC )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: null, modelName: OWNEDBY , Coded Values: [1: City] , [2: MCWA] , [3: Private] , ...3 more... )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: null, modelName: MAINTBY , Coded Values: [1: Our Agency] , [-1: Private] , [-2: Other] )
• MAPSTATUS ( type: esriFieldTypeString, alias: Map Status, editable: true, nullable: true, length: 30, defaultValue: null, modelName: MAPSTATUS , Coded Values: [Planned: Planned] , [Undedicated: Undedicated] , [Active: Active] , ...3 more... )
• STATUS ( type: esriFieldTypeString, alias: Mainframe Status, editable: true, nullable: true, length: 30, defaultValue: null, modelName: STATUS , Coded Values: [Planned: Planned] , [Undedicated: Undedicated] , [Active: Active] , ...3 more... )
• PilotTemp ( type: esriFieldTypeString, alias: Install Year, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PilotTemp )
• ExtendedLateral ( type: esriFieldTypeString, alias: Old Service Material, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ExtendedLateral )
• COMMENTS ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 250, defaultValue: null, modelName: COMMENTS )
• FIELDBOOK_PAGE ( type: esriFieldTypeString, alias: Field Book - Field Page, editable: true, nullable: true, length: 10, defaultValue: null, modelName: FIELDBOOK_PAGE )
• LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, editable: false, nullable: true, length: 50, defaultValue: null, modelName: LASTEDITOR )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LASTUPDATE )
• Shape__Length ( type: esriFieldTypeDouble, alias: Shape.STLength(), editable: false, nullable: true, defaultValue: null, modelName: Shape.STLength(), required: true )
• FACILITYID ( type: esriFieldTypeString, alias: Facility Identifier, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• OLDSERVICEMATERIAL ( type: esriFieldTypeString, alias: Old Service Material, editable: true, nullable: true, length: 20, defaultValue: null, modelName: OLDSERVICEMATERIAL , Coded Values: [Brass: Brass] , [Cast Iron: Cast Iron] , [Copper: Copper] , ...14 more... )
• MATERIALVERIFICATION ( type: esriFieldTypeString, alias: Material Verification, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MATERIALVERIFICATION , Coded Values: [Records: Records] , [Excavation: Excavation] , [Statistical: Statistical] , ...6 more... )
• ACCOUNTID ( type: esriFieldTypeString, alias: Account Number, editable: true, nullable: true, length: 30, defaultValue: null, modelName: ACCOUNTID )
• ReplacementProject ( type: esriFieldTypeString, alias: ReplacementProject, editable: true, nullable: true, length: 24, defaultValue: null, modelName: ReplacementProject )

Types:

ID: Copper
Name: Copper
Domains:
• SYSTEMNAME:
  Inherited
• DIAMETER:
  Inherited
• MATERIAL:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• MAPSTATUS:
  Inherited
• STATUS:
  Inherited
• OLDSERVICEMATERIAL:
  Inherited
• MATERIALVERIFICATION:
  Inherited
• LINETYPE:
  Inherited
• WATERTYPE:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
Templates:
• Name: Copper
  Description:
  Prototype:
  LOCDESC: null
  MAPSTATUS: Active
  MATERIALVERIFICATION: null
  FACILITYID: null
  OWNEDBY: 1
  DIAMETER: 0.75
  ReplacementProject: null
  ACCOUNTID: null
  OLDSERVICEMATERIAL: null
  INSTALLDATE: null
  MAINTBY: 1
  SYSTEMNAME: Domestic
  SerialNumber: null
  MATERIAL: Copper
  STATUS: Active
  PilotTemp: null
  ExtendedLateral: null
  COMMENTS: null
  FIELDBOOK_PAGE: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Galvanized
Name: Galvanized
Domains:
• SYSTEMNAME:
  Inherited
• DIAMETER:
  Inherited
• MATERIAL:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• MAPSTATUS:
  Inherited
• STATUS:
  Inherited
• OLDSERVICEMATERIAL:
  Inherited
• MATERIALVERIFICATION:
  Inherited
• LINETYPE:
  Inherited
• WATERTYPE:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
Templates:
• Name: Galvanized
  Description:
  Prototype:
  LOCDESC: null
  MAPSTATUS: Active
  MATERIALVERIFICATION: null
  FACILITYID: null
  OWNEDBY: 1
  DIAMETER: 0.75
  ReplacementProject: null
  ACCOUNTID: null
  OLDSERVICEMATERIAL: null
  INSTALLDATE: null
  MAINTBY: 1
  SYSTEMNAME: Domestic
  SerialNumber: null
  MATERIAL: Galvanized
  STATUS: Active
  PilotTemp: null
  ExtendedLateral: null
  COMMENTS: null
  FIELDBOOK_PAGE: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Lead
Name: Lead
Domains:
• SYSTEMNAME:
  Inherited
• DIAMETER:
  Inherited
• MATERIAL:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• MAPSTATUS:
  Inherited
• STATUS:
  Inherited
• OLDSERVICEMATERIAL:
  Inherited
• MATERIALVERIFICATION:
  Inherited
• LINETYPE:
  Inherited
• WATERTYPE:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
Templates:
• Name: Lead
  Description:
  Prototype:
  LOCDESC: null
  MAPSTATUS: Active
  MATERIALVERIFICATION: null
  FACILITYID: null
  OWNEDBY: 1
  DIAMETER: 0.75
  ReplacementProject: null
  ACCOUNTID: null
  OLDSERVICEMATERIAL: null
  INSTALLDATE: null
  MAINTBY: 1
  SYSTEMNAME: Domestic
  SerialNumber: null
  MATERIAL: Lead
  STATUS: Active
  PilotTemp: null
  ExtendedLateral: null
  COMMENTS: null
  FIELDBOOK_PAGE: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Lead Lined
Name: Lead Lined
Domains:
• SYSTEMNAME:
  Inherited
• DIAMETER:
  Inherited
• MATERIAL:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• MAPSTATUS:
  Inherited
• STATUS:
  Inherited
• OLDSERVICEMATERIAL:
  Inherited
• MATERIALVERIFICATION:
  Inherited
• LINETYPE:
  Inherited
• WATERTYPE:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
Templates:
• Name: Lead Lined
  Description:
  Prototype:
  LOCDESC: null
  MAPSTATUS: Active
  MATERIALVERIFICATION: null
  FACILITYID: null
  OWNEDBY: 1
  DIAMETER: 0.75
  ReplacementProject: null
  ACCOUNTID: null
  OLDSERVICEMATERIAL: null
  INSTALLDATE: null
  MAINTBY: 1
  SYSTEMNAME: Domestic
  SerialNumber: null
  MATERIAL: Lead Lined
  STATUS: Active
  PilotTemp: null
  ExtendedLateral: null
  COMMENTS: null
  FIELDBOOK_PAGE: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: PVC
Name: PVC
Domains:
• SYSTEMNAME:
  Inherited
• DIAMETER:
  Inherited
• MATERIAL:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• MAPSTATUS:
  Inherited
• STATUS:
  Inherited
• OLDSERVICEMATERIAL:
  Inherited
• MATERIALVERIFICATION:
  Inherited
• LINETYPE:
  Inherited
• WATERTYPE:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
Templates:
• Name: PVC
  Description:
  Prototype:
  LOCDESC: null
  MAPSTATUS: Active
  MATERIALVERIFICATION: null
  FACILITYID: null
  OWNEDBY: 1
  DIAMETER: 1
  ReplacementProject: null
  ACCOUNTID: null
  OLDSERVICEMATERIAL: null
  INSTALLDATE: null
  MAINTBY: 1
  SYSTEMNAME: Domestic
  SerialNumber: null
  MATERIAL: PVC
  STATUS: Active
  PilotTemp: null
  ExtendedLateral: null
  COMMENTS: null
  FIELDBOOK_PAGE: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: PVCO
Name: PVCO
Domains:
• SYSTEMNAME:
  Inherited
• DIAMETER:
  Inherited
• MATERIAL:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• MAPSTATUS:
  Inherited
• STATUS:
  Inherited
• OLDSERVICEMATERIAL:
  Inherited
• MATERIALVERIFICATION:
  Inherited
• LINETYPE:
  Inherited
• WATERTYPE:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
Templates:
• Name: PVCO
  Description:
  Prototype:
  LOCDESC: null
  MAPSTATUS: Active
  MATERIALVERIFICATION: null
  FACILITYID: null
  OWNEDBY: 1
  DIAMETER: 1
  ReplacementProject: null
  ACCOUNTID: null
  OLDSERVICEMATERIAL: null
  INSTALLDATE: null
  MAINTBY: 1
  SYSTEMNAME: Domestic
  SerialNumber: null
  MATERIAL: PVCO
  STATUS: Active
  PilotTemp: null
  ExtendedLateral: null
  COMMENTS: null
  FIELDBOOK_PAGE: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Plastic
Name: Plastic
Domains:
• SYSTEMNAME:
  Inherited
• DIAMETER:
  Inherited
• MATERIAL:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• MAPSTATUS:
  Inherited
• STATUS:
  Inherited
• OLDSERVICEMATERIAL:
  Inherited
• MATERIALVERIFICATION:
  Inherited
• LINETYPE:
  Inherited
• WATERTYPE:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
Templates:
• Name: Plastic
  Description:
  Prototype:
  LOCDESC: null
  MAPSTATUS: Active
  MATERIALVERIFICATION: null
  FACILITYID: null
  OWNEDBY: 1
  DIAMETER: 1
  ReplacementProject: null
  ACCOUNTID: null
  OLDSERVICEMATERIAL: null
  INSTALLDATE: null
  MAINTBY: 1
  SYSTEMNAME: Domestic
  SerialNumber: null
  MATERIAL: Plastic
  STATUS: Active
  PilotTemp: null
  ExtendedLateral: null
  COMMENTS: null
  FIELDBOOK_PAGE: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Polyethylene
Name: Polyethylene
Domains:
• SYSTEMNAME:
  Inherited
• DIAMETER:
  Inherited
• MATERIAL:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• MAPSTATUS:
  Inherited
• STATUS:
  Inherited
• OLDSERVICEMATERIAL:
  Inherited
• MATERIALVERIFICATION:
  Inherited
• LINETYPE:
  Inherited
• WATERTYPE:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
Templates:
• Name: Polyethylene
  Description:
  Prototype:
  LOCDESC: null
  MAPSTATUS: Active
  MATERIALVERIFICATION: null
  FACILITYID: null
  OWNEDBY: 1
  DIAMETER: 1
  ReplacementProject: null
  ACCOUNTID: null
  OLDSERVICEMATERIAL: null
  INSTALLDATE: null
  MAINTBY: 1
  SYSTEMNAME: Domestic
  SerialNumber: null
  MATERIAL: Polyethylene
  STATUS: Active
  PilotTemp: null
  ExtendedLateral: null
  COMMENTS: null
  FIELDBOOK_PAGE: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Wrought Iron
Name: Wrought Iron
Domains:
• SYSTEMNAME:
  Inherited
• DIAMETER:
  Inherited
• MATERIAL:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• MAPSTATUS:
  Inherited
• STATUS:
  Inherited
• OLDSERVICEMATERIAL:
  Inherited
• MATERIALVERIFICATION:
  Inherited
• LINETYPE:
  Inherited
• WATERTYPE:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
Templates:
• Name: Wrought Iron
  Description:
  Prototype:
  LOCDESC: null
  MAPSTATUS: Active
  MATERIALVERIFICATION: null
  FACILITYID: null
  OWNEDBY: 1
  DIAMETER: 0.75
  ReplacementProject: null
  ACCOUNTID: null
  OLDSERVICEMATERIAL: null
  INSTALLDATE: null
  MAINTBY: 1
  SYSTEMNAME: Domestic
  SerialNumber: null
  MATERIAL: Wrought Iron
  STATUS: Active
  PilotTemp: null
  ExtendedLateral: null
  COMMENTS: null
  FIELDBOOK_PAGE: null
  
  Drawing Tool: esriFeatureEditToolLine

---

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

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field:
• Creator Field:
• Edit Date Field: LASTUPDATE
• Editor Field: LASTEDITOR

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

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