View In:   ArcGIS Online Map Viewer

Name: UTIL_Water_Service_Line_Inventory

Display Field: site

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 598e6c28686b489897c33d679d5ed1b5

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 2400.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: 803651.8012099974
YMin: 368615.02089532465
XMax: 837977.4759968296
YMax: 395526.8975176513
Spatial Reference: 103419  (103419)  VCSWkid(5703)  LatestVCSWkid(5703)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [137, 93, 59, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
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: 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: 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: true

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: objectid )
• locno ( type: esriFieldTypeInteger, alias: Location Number - SITEID, editable: true, nullable: true, defaultValue: null, modelName: locno )
• site ( type: esriFieldTypeString, alias: Site - Address, editable: true, nullable: true, length: 100, defaultValue: null, modelName: site )
• pin ( type: esriFieldTypeString, alias: Parcel PIN, editable: true, nullable: true, length: 50, defaultValue: null, modelName: pin )
• gooseneck ( type: esriFieldTypeString, alias: LEAD GOOSENECK CURRENTLY PRESENT, editable: true, nullable: true, length: 10, defaultValue: null, modelName: gooseneck , Coded Values: [Y: YES - WITH CERTAINTY] , [N: NO - WITH CERTAINTY] , [UNK: NOT KNOWN WITH CERTAINTY] )
• pub_material ( type: esriFieldTypeString, alias: CURRENT STREET SIDE SERVICE LINE MATERIAL, editable: true, nullable: true, length: 50, defaultValue: null, modelName: pub_material , Coded Values: [CI: Cast Iron] , [DI: Ductile Iron] , [HDPE: High Density Polyethylene] , ...8 more... )
• pub_mat_prev_pb ( type: esriFieldTypeString, alias: WAS STREET SIDE SERVICE LINE MATERIAL EVER PREVIOUSLY LEAD, editable: true, nullable: true, length: 10, defaultValue: null, modelName: pub_mat_prev_pb , Coded Values: [Y: YES - WITH CERTAINTY] , [N: NO - WITH CERTAINTY] , [UNK: NOT KNOWN WITH CERTAINTY] )
• pub_dia ( type: esriFieldTypeDouble, alias: STREET SIDE SERVICE LINE SIZE, editable: true, nullable: true, defaultValue: null, modelName: pub_dia , Coded Values: [0.625: 5/8"] , [0.75: 3/4"] , [1: 1"] , ...10 more... )
• pub_installdt ( type: esriFieldTypeDate, alias: STREET SIDE SERVICE LINE INSTALL DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: pub_installdt )
• pvt_material ( type: esriFieldTypeString, alias: CURRENT PROPERTY SIDE SERVICE LINE MATERIAL, editable: true, nullable: true, length: 50, defaultValue: null, modelName: pvt_material , Coded Values: [CAST IRON: Cast Iron] , [COPPER: Copper] , [DUCTILE IRON: Ductile Iron] , ...9 more... )
• pvt_dia ( type: esriFieldTypeDouble, alias: PROPERTY SIDE SERVICE LINE SIZE, editable: true, nullable: true, defaultValue: null, modelName: pvt_dia , Coded Values: [0.625: 5/8"] , [0.75: 3/4"] , [1: 1"] , ...10 more... )
• pvt_installdt ( type: esriFieldTypeDate, alias: PROPERTY SIDE SERVICE LINE INSTALL DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: pvt_installdt )
• building_type ( type: esriFieldTypeString, alias: BUILDING TYPE, editable: true, nullable: true, length: 25, defaultValue: null, modelName: building_type , Coded Values: [SF: SINGLE-FAMILY RESIDENTIAL] , [MF: MULTI-FAMILY RESIDENTIAL] , [SCH/CC: SCHOOL OR CHILD CARE] , ...4 more... )
• poe_treat ( type: esriFieldTypeString, alias: POINT-OF-ENTRY OR POINT-OF-USE TREATMENT PRESENT, editable: true, nullable: true, length: 10, defaultValue: null, modelName: poe_treat , Coded Values: [Y: YES - WITH CERTAINTY] , [N: NO - WITH CERTAINTY] , [UNK: NOT KNOWN WITH CERTAINTY] )
• premise_plumbing_material_1 ( type: esriFieldTypeString, alias: BUILDING PLUMBING MATERIAL 1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: premise_plumbing_material_1 , Coded Values: [COPPER: Copper] , [GALVANIZED: Galvanized] , [LEAD: Lead] , ...5 more... )
• premise_plumbing_material_2 ( type: esriFieldTypeString, alias: BUILDING PLUMBING MATERIAL 2, editable: true, nullable: true, length: 50, defaultValue: null, modelName: premise_plumbing_material_2 , Coded Values: [COPPER: Copper] , [GALVANIZED: Galvanized] , [LEAD: Lead] , ...5 more... )
• premise_plumbing_installdt ( type: esriFieldTypeDate, alias: BUILDING PLUMBING MATERIAL INSTALL DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: premise_plumbing_installdt )
• notes ( type: esriFieldTypeString, alias: Notes - COMMENTS, editable: true, nullable: true, length: 300, defaultValue: null, modelName: notes )
• basis_pub_mat_class ( type: esriFieldTypeString, alias: BASIS OF STREET SIDE MATERIAL CLASSIFICATION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: basis_pub_mat_class , Coded Values: [Previous eval : Previous Materials Evaluation] , [Installation record: Installation record (e.g., tap card)] , [Installed after lead ban: Installation date after lead ban (1986)] , ...5 more... )
• pub_field_verf ( type: esriFieldTypeString, alias: WAS STREET SIDE MATERIAL FIELD VERIFIED, editable: true, nullable: true, length: 10, defaultValue: null, modelName: pub_field_verf , Coded Values: [Y: Yes] , [N: No] )
• pub_field_ver_dt ( type: esriFieldTypeDate, alias: DATE OF STREET SIDE FIELD VERIFICATION IF APPLICABLE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: pub_field_ver_dt )
• pub_field_ver_method ( type: esriFieldTypeString, alias: METHOD OF STREET SIDE FIELD VERIFICATION IF APPLICABLE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: pub_field_ver_method , Coded Values: [Customer self id: Customer self-identification] , [CCTV - internal: CCTV investigation at curb stop - internal] , [CCTV - external: CCTV investigation at curb stop - external] , ...5 more... )
• basis_pvt_mat_class ( type: esriFieldTypeString, alias: BASIS OF PROPERTY SIDE MATERIAL CLASSIFICATION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: basis_pvt_mat_class , Coded Values: [Previous eval : Previous Materials Evaluation] , [Installation record: Installation record (e.g., tap card)] , [Installed after lead ban: Installation date after lead ban (1986)] , ...5 more... )
• pvt_field_verf ( type: esriFieldTypeString, alias: WAS PROPERTY SIDE MATERIAL FIELD VERIFIED, editable: true, nullable: true, length: 10, defaultValue: null, modelName: pvt_field_verf , Coded Values: [Y: Yes] , [N: No] )
• pvt_field_ver_dt ( type: esriFieldTypeDate, alias: DATE OF PROPERTY SIDE FIELD VERIFICATION IF APPLICABLE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: pvt_field_ver_dt )
• pvt_field_ver_method ( type: esriFieldTypeString, alias: METHOD OF PROPERTY SIDE FIELD VERIFICATION IF APPLICABLE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: pvt_field_ver_method , Coded Values: [Customer self id: Customer self-identification] , [CCTV - internal: CCTV investigation at curb stop - internal] , [CCTV - external: CCTV investigation at curb stop - external] , ...5 more... )
• basis_notes ( type: esriFieldTypeString, alias: NOTES ON BASIS OF MATERIAL CLASSIFICATION, editable: true, nullable: true, length: 200, defaultValue: null, modelName: basis_notes )
• lst_cntct_dt ( type: esriFieldTypeDate, alias: Date of Last Contact, editable: true, nullable: true, length: 8, defaultValue: null, modelName: lst_cntct_dt )
• pb_rmvd_dt ( type: esriFieldTypeDate, alias: Date of All Lead Removal, editable: true, nullable: true, length: 8, defaultValue: null, modelName: pb_rmvd_dt )
• pws_ctrl_vlv_locno ( type: esriFieldTypeInteger, alias: pws_ctrl_vlv_locno, editable: true, nullable: true, defaultValue: null, modelName: pws_ctrl_vlv_locno )
• conn_type ( type: esriFieldTypeString, alias: conn_type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: conn_type )
• creator ( type: esriFieldTypeString, alias: Creator, editable: false, nullable: true, length: 50, defaultValue: null, modelName: creator )
• created ( type: esriFieldTypeDate, alias: Created, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created )
• editor ( type: esriFieldTypeString, alias: Editor, editable: false, nullable: true, length: 50, defaultValue: null, modelName: editor )
• edited ( type: esriFieldTypeDate, alias: Edited, editable: false, nullable: true, length: 8, defaultValue: null, modelName: edited )

Templates:

• Name: Cast Iron & Ductile Iron
  Description:
  Prototype:
  pub_installdt: null
  conn_type: null
  locno: null
  site: null
  pin: null
  gooseneck: null
  pub_material: null
  pub_mat_prev_pb: null
  pub_dia: null
  pvt_material: CAST IRON
  pvt_dia: null
  pvt_installdt: null
  building_type: null
  poe_treat: null
  premise_plumbing_material_1: null
  premise_plumbing_material_2: null
  premise_plumbing_installdt: null
  notes: null
  basis_pub_mat_class: null
  pub_field_verf: null
  pub_field_ver_dt: null
  pub_field_ver_method: null
  basis_pvt_mat_class: null
  pvt_field_verf: null
  pvt_field_ver_dt: null
  pvt_field_ver_method: null
  basis_notes: null
  lst_cntct_dt: null
  pb_rmvd_dt: null
  pws_ctrl_vlv_locno: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Cast Iron & Ductile Iron (1)
  Description:
  Prototype:
  pub_installdt: null
  conn_type: null
  locno: null
  site: null
  pin: null
  gooseneck: null
  pub_material: null
  pub_mat_prev_pb: null
  pub_dia: null
  pvt_material: DUCTILE IRON
  pvt_dia: null
  pvt_installdt: null
  building_type: null
  poe_treat: null
  premise_plumbing_material_1: null
  premise_plumbing_material_2: null
  premise_plumbing_installdt: null
  notes: null
  basis_pub_mat_class: null
  pub_field_verf: null
  pub_field_ver_dt: null
  pub_field_ver_method: null
  basis_pvt_mat_class: null
  pvt_field_verf: null
  pvt_field_ver_dt: null
  pvt_field_ver_method: null
  basis_notes: null
  lst_cntct_dt: null
  pb_rmvd_dt: null
  pws_ctrl_vlv_locno: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Copper
  Description:
  Prototype:
  pub_installdt: null
  conn_type: null
  locno: null
  site: null
  pin: null
  gooseneck: null
  pub_material: null
  pub_mat_prev_pb: null
  pub_dia: null
  pvt_material: COPPER
  pvt_dia: null
  pvt_installdt: null
  building_type: null
  poe_treat: null
  premise_plumbing_material_1: null
  premise_plumbing_material_2: null
  premise_plumbing_installdt: null
  notes: null
  basis_pub_mat_class: null
  pub_field_verf: null
  pub_field_ver_dt: null
  pub_field_ver_method: null
  basis_pvt_mat_class: null
  pvt_field_verf: null
  pvt_field_ver_dt: null
  pvt_field_ver_method: null
  basis_notes: null
  lst_cntct_dt: null
  pb_rmvd_dt: null
  pws_ctrl_vlv_locno: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Galvanized
  Description:
  Prototype:
  pub_installdt: null
  conn_type: null
  locno: null
  site: null
  pin: null
  gooseneck: null
  pub_material: null
  pub_mat_prev_pb: null
  pub_dia: null
  pvt_material: GALVANIZED
  pvt_dia: null
  pvt_installdt: null
  building_type: null
  poe_treat: null
  premise_plumbing_material_1: null
  premise_plumbing_material_2: null
  premise_plumbing_installdt: null
  notes: null
  basis_pub_mat_class: null
  pub_field_verf: null
  pub_field_ver_dt: null
  pub_field_ver_method: null
  basis_pvt_mat_class: null
  pvt_field_verf: null
  pvt_field_ver_dt: null
  pvt_field_ver_method: null
  basis_notes: null
  lst_cntct_dt: null
  pb_rmvd_dt: null
  pws_ctrl_vlv_locno: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Lead
  Description:
  Prototype:
  pub_installdt: null
  conn_type: null
  locno: null
  site: null
  pin: null
  gooseneck: null
  pub_material: null
  pub_mat_prev_pb: null
  pub_dia: null
  pvt_material: LEAD
  pvt_dia: null
  pvt_installdt: null
  building_type: null
  poe_treat: null
  premise_plumbing_material_1: null
  premise_plumbing_material_2: null
  premise_plumbing_installdt: null
  notes: null
  basis_pub_mat_class: null
  pub_field_verf: null
  pub_field_ver_dt: null
  pub_field_ver_method: null
  basis_pvt_mat_class: null
  pvt_field_verf: null
  pvt_field_ver_dt: null
  pvt_field_ver_method: null
  basis_notes: null
  lst_cntct_dt: null
  pb_rmvd_dt: null
  pws_ctrl_vlv_locno: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Non-Lead by Date
  Description:
  Prototype:
  pub_installdt: null
  conn_type: null
  locno: null
  site: null
  pin: null
  gooseneck: null
  pub_material: null
  pub_mat_prev_pb: null
  pub_dia: null
  pvt_material: NON LEAD DT
  pvt_dia: null
  pvt_installdt: null
  building_type: null
  poe_treat: null
  premise_plumbing_material_1: null
  premise_plumbing_material_2: null
  premise_plumbing_installdt: null
  notes: null
  basis_pub_mat_class: null
  pub_field_verf: null
  pub_field_ver_dt: null
  pub_field_ver_method: null
  basis_pvt_mat_class: null
  pvt_field_verf: null
  pvt_field_ver_dt: null
  pvt_field_ver_method: null
  basis_notes: null
  lst_cntct_dt: null
  pb_rmvd_dt: null
  pws_ctrl_vlv_locno: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Site Not Inspected
  Description:
  Prototype:
  pub_installdt: null
  conn_type: null
  locno: null
  site: null
  pin: null
  gooseneck: null
  pub_material: null
  pub_mat_prev_pb: null
  pub_dia: null
  pvt_material: NOT_INSPECTED
  pvt_dia: null
  pvt_installdt: null
  building_type: null
  poe_treat: null
  premise_plumbing_material_1: null
  premise_plumbing_material_2: null
  premise_plumbing_installdt: null
  notes: null
  basis_pub_mat_class: null
  pub_field_verf: null
  pub_field_ver_dt: null
  pub_field_ver_method: null
  basis_pvt_mat_class: null
  pvt_field_verf: null
  pvt_field_ver_dt: null
  pvt_field_ver_method: null
  basis_notes: null
  lst_cntct_dt: null
  pb_rmvd_dt: null
  pws_ctrl_vlv_locno: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Material Not Recorded During OR Could Not Confirm
  Description:
  Prototype:
  pub_installdt: null
  conn_type: null
  locno: null
  site: null
  pin: null
  gooseneck: null
  pub_material: null
  pub_mat_prev_pb: null
  pub_dia: null
  pvt_material: NOT_RECORDED
  pvt_dia: null
  pvt_installdt: null
  building_type: null
  poe_treat: null
  premise_plumbing_material_1: null
  premise_plumbing_material_2: null
  premise_plumbing_installdt: null
  notes: null
  basis_pub_mat_class: null
  pub_field_verf: null
  pub_field_ver_dt: null
  pub_field_ver_method: null
  basis_pvt_mat_class: null
  pvt_field_verf: null
  pvt_field_ver_dt: null
  pvt_field_ver_method: null
  basis_notes: null
  lst_cntct_dt: null
  pb_rmvd_dt: null
  pws_ctrl_vlv_locno: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Material Not Recorded During OR Could Not Confirm (1)
  Description:
  Prototype:
  pub_installdt: null
  conn_type: null
  locno: null
  site: null
  pin: null
  gooseneck: null
  pub_material: null
  pub_mat_prev_pb: null
  pub_dia: null
  pvt_material: UNKNOWN
  pvt_dia: null
  pvt_installdt: null
  building_type: null
  poe_treat: null
  premise_plumbing_material_1: null
  premise_plumbing_material_2: null
  premise_plumbing_installdt: null
  notes: null
  basis_pub_mat_class: null
  pub_field_verf: null
  pub_field_ver_dt: null
  pub_field_ver_method: null
  basis_pvt_mat_class: null
  pvt_field_verf: null
  pvt_field_ver_dt: null
  pvt_field_ver_method: null
  basis_notes: null
  lst_cntct_dt: null
  pb_rmvd_dt: null
  pws_ctrl_vlv_locno: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Private Side not Connected or Developed
  Description:
  Prototype:
  pub_installdt: null
  conn_type: null
  locno: null
  site: null
  pin: null
  gooseneck: null
  pub_material: null
  pub_mat_prev_pb: null
  pub_dia: null
  pvt_material: NO_MATERIAL
  pvt_dia: null
  pvt_installdt: null
  building_type: null
  poe_treat: null
  premise_plumbing_material_1: null
  premise_plumbing_material_2: null
  premise_plumbing_installdt: null
  notes: null
  basis_pub_mat_class: null
  pub_field_verf: null
  pub_field_ver_dt: null
  pub_field_ver_method: null
  basis_pvt_mat_class: null
  pvt_field_verf: null
  pvt_field_ver_dt: null
  pvt_field_ver_method: null
  basis_notes: null
  lst_cntct_dt: null
  pb_rmvd_dt: null
  pws_ctrl_vlv_locno: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Polyethylene & PVC
  Description:
  Prototype:
  pub_installdt: null
  conn_type: null
  locno: null
  site: null
  pin: null
  gooseneck: null
  pub_material: null
  pub_mat_prev_pb: null
  pub_dia: null
  pvt_material: POLYETHYLENE
  pvt_dia: null
  pvt_installdt: null
  building_type: null
  poe_treat: null
  premise_plumbing_material_1: null
  premise_plumbing_material_2: null
  premise_plumbing_installdt: null
  notes: null
  basis_pub_mat_class: null
  pub_field_verf: null
  pub_field_ver_dt: null
  pub_field_ver_method: null
  basis_pvt_mat_class: null
  pvt_field_verf: null
  pvt_field_ver_dt: null
  pvt_field_ver_method: null
  basis_notes: null
  lst_cntct_dt: null
  pb_rmvd_dt: null
  pws_ctrl_vlv_locno: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Polyethylene & PVC (1)
  Description:
  Prototype:
  pub_installdt: null
  conn_type: null
  locno: null
  site: null
  pin: null
  gooseneck: null
  pub_material: null
  pub_mat_prev_pb: null
  pub_dia: null
  pvt_material: PVC
  pvt_dia: null
  pvt_installdt: null
  building_type: null
  poe_treat: null
  premise_plumbing_material_1: null
  premise_plumbing_material_2: null
  premise_plumbing_installdt: null
  notes: null
  basis_pub_mat_class: null
  pub_field_verf: null
  pub_field_ver_dt: null
  pub_field_ver_method: null
  basis_pvt_mat_class: null
  pvt_field_verf: null
  pvt_field_ver_dt: null
  pvt_field_ver_method: null
  basis_notes: null
  lst_cntct_dt: null
  pb_rmvd_dt: null
  pws_ctrl_vlv_locno: null
  
  Drawing Tool: esriFeatureEditToolPoint

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: created
• Creator Field: creator
• Edit Date Field: edited
• Editor Field: editor

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

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