View In:   ArcGIS Online Map Viewer

Name: Services by Material

Display Field: TapNumber

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 4000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Supports Datum Transformation: true

Extent:

XMin: 1.3242752769685045E7
YMin: 746431.6056430489
XMax: 1.3259597155183733E7
YMax: 788049.9163385779
Spatial Reference: 2898  (2898)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: Service_Material
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
Style: esriSLSSolid
Color: [0, 86, 135, 255]
Width: 2
Default Label:
UniqueValueInfos:
• Value: 1
  Label: Copper
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [56, 168, 0, 255]
  Width: 2
• Value: 5
  Label: Ductile Iron
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [0, 132, 168, 255]
  Width: 2
• Value: 4
  Label: Galvanized
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [0, 38, 115, 255]
  Width: 2
• Value: 2
  Label: Lead
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [230, 0, 0, 255]
  Width: 2
• Value: 3
  Label: Plastic
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [205, 170, 102, 255]
  Width: 2
• Value: 6
  Label: Unknown
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [169, 0, 230, 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

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: Service_Material

Fields:

• OBJECTID_1 ( type: esriFieldTypeOID, alias: OBJECTID_1, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID_1 )
• OBJECTID ( type: esriFieldTypeDouble, alias: OBJECTID, editable: true, nullable: true, defaultValue: null, modelName: OBJECTID )
• TapDate ( type: esriFieldTypeDate, alias: TapDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: TapDate )
• TapNumber ( type: esriFieldTypeString, alias: TapNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TapNumber )
• TapSize ( type: esriFieldTypeString, alias: TapSize, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TapSize , Coded Values: [1: 1/2"] , [2: 5/8"] , [3: 3/4"] , ...17 more... )
• ServiceTyp ( type: esriFieldTypeString, alias: ServiceTyp, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ServiceTyp , Coded Values: [Sprinkler : Sprinkler] , [Private: Private] , [Residential: Residential] , ...6 more... )
• Material ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Material , Coded Values: )
• RepairDate ( type: esriFieldTypeDate, alias: RepairDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RepairDate )
• ServiceSiz ( type: esriFieldTypeDouble, alias: ServiceSiz, editable: true, nullable: true, defaultValue: null, modelName: ServiceSiz , Coded Values: [1: 1/2"] , [2: 5/8"] , [3: 3/4"] , ...10 more... )
• Label ( type: esriFieldTypeString, alias: Label, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Label )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• Source ( type: esriFieldTypeString, alias: Source, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Source )
• Service_Own ( type: esriFieldTypeInteger, alias: Service_Own, editable: true, nullable: true, defaultValue: 0, modelName: Service_Own )
• Service_Material ( type: esriFieldTypeInteger, alias: Service_Material, editable: true, nullable: true, defaultValue: 1, modelName: Service_Material )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• MaterialVerified ( type: esriFieldTypeString, alias: MaterialVerified, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MaterialVerified , Coded Values: [N: No] , [Y: Yes] )
• Measurements ( type: esriFieldTypeString, alias: Measurements, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Measurements )
• Address ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Address )
• Ward ( type: esriFieldTypeSmallInteger, alias: Ward, editable: true, nullable: true, defaultValue: null, modelName: Ward , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...6 more... )
• Email ( type: esriFieldTypeString, alias: Email, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Email )
• Phone ( type: esriFieldTypeString, alias: Phone, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Phone )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 500, defaultValue: null, modelName: Notes )

Types:

ID: 1
Name: Copper
Domains:
• TapSize:
  Inherited
• ServiceTyp:
  Inherited
• Material:
  Inherited
• ServiceSiz:
  Inherited
• Service_Own:
  Coded Values: [0: Customer] , [1: City]
• MaterialVerified:
  Inherited
Templates:
• Name: Copper
  Description:
  Prototype:
  Source: null
  Service_Own: 0
  Phone: null
  OBJECTID: null
  TapDate: null
  TapNumber: null
  TapSize: null
  ServiceTyp: null
  Material: null
  RepairDate: null
  ServiceSiz: null
  Label: null
  Email: null
  Ward: null
  Address: null
  Measurements: null
  Service_Material: 1
  Notes: null
  MaterialVerified: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 5
Name: Ductile Iron
Domains:
• TapSize:
  Inherited
• ServiceTyp:
  Inherited
• Material:
  Inherited
• ServiceSiz:
  Inherited
• Service_Own:
  Coded Values: [0: Customer] , [1: City]
• MaterialVerified:
  Inherited
Templates:
• Name: Ductile Iron
  Description:
  Prototype:
  Source: null
  Service_Own: 0
  Phone: null
  OBJECTID: null
  TapDate: null
  TapNumber: null
  TapSize: null
  ServiceTyp: null
  Material: null
  RepairDate: null
  ServiceSiz: null
  Label: null
  Email: null
  Ward: null
  Address: null
  Measurements: null
  Service_Material: 5
  Notes: null
  MaterialVerified: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 4
Name: Galvanized
Domains:
• TapSize:
  Inherited
• ServiceTyp:
  Inherited
• Material:
  Inherited
• ServiceSiz:
  Inherited
• Service_Own:
  Coded Values: [0: Customer] , [1: City]
• MaterialVerified:
  Inherited
Templates:
• Name: Galvanized
  Description:
  Prototype:
  Source: null
  Service_Own: 0
  Phone: null
  OBJECTID: null
  TapDate: null
  TapNumber: null
  TapSize: null
  ServiceTyp: null
  Material: null
  RepairDate: null
  ServiceSiz: null
  Label: null
  Email: null
  Ward: null
  Address: null
  Measurements: null
  Service_Material: 4
  Notes: null
  MaterialVerified: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 2
Name: Lead
Domains:
• TapSize:
  Inherited
• ServiceTyp:
  Inherited
• Material:
  Inherited
• ServiceSiz:
  Inherited
• Service_Own:
  Coded Values: [0: Customer] , [1: City]
• MaterialVerified:
  Inherited
Templates:
• Name: Lead
  Description:
  Prototype:
  Source: null
  Service_Own: 0
  Phone: null
  OBJECTID: null
  TapDate: null
  TapNumber: null
  TapSize: null
  ServiceTyp: null
  Material: null
  RepairDate: null
  ServiceSiz: null
  Label: null
  Email: null
  Ward: null
  Address: null
  Measurements: null
  Service_Material: 2
  Notes: null
  MaterialVerified: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 3
Name: Plastic
Domains:
• TapSize:
  Inherited
• ServiceTyp:
  Inherited
• Material:
  Inherited
• ServiceSiz:
  Inherited
• Service_Own:
  Coded Values: [0: Customer] , [1: City]
• MaterialVerified:
  Inherited
Templates:
• Name: Plastic
  Description:
  Prototype:
  Source: null
  Service_Own: 0
  Phone: null
  OBJECTID: null
  TapDate: null
  TapNumber: null
  TapSize: null
  ServiceTyp: null
  Material: null
  RepairDate: null
  ServiceSiz: null
  Label: null
  Email: null
  Ward: null
  Address: null
  Measurements: null
  Service_Material: 3
  Notes: null
  MaterialVerified: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 6
Name: Unknown
Domains:
• TapSize:
  Inherited
• ServiceTyp:
  Inherited
• Material:
  Inherited
• ServiceSiz:
  Inherited
• Service_Own:
  Coded Values: [0: Customer] , [1: City]
• MaterialVerified:
  Inherited
Templates:
• Name: Unknown
  Description:
  Prototype:
  Source: null
  Service_Own: 0
  Phone: null
  OBJECTID: null
  TapDate: null
  TapNumber: null
  TapSize: null
  ServiceTyp: null
  Material: null
  RepairDate: null
  ServiceSiz: null
  Label: null
  Email: null
  Ward: null
  Address: null
  Measurements: null
  Service_Material: 6
  Notes: null
  MaterialVerified: null
  
  Drawing Tool: esriFeatureEditToolLine

---

Relationships:

• WaterServiceMaterialInventory (1) -- Related To: Water Service Material Inventory (9)

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

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

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

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata