View In:   ArcGIS Online Map Viewer

Name: Service Replacement Locations

Display Field: customer_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 0

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.3242917790026248E7
YMin: 750905.6876640469
XMax: 1.3258684592191607E7
YMax: 785319.4130577445
Spatial Reference: 2898  (2898)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: ReplacementStatus
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
N/A
Default Label: null
UniqueValueInfos:
• Value: No Authorization
  Label: No Authorization
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [255, 0, 0, 255]
  Size: 8.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: Replacement Complete
  Label: Replacement Complete
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [0, 92, 230, 255]
  Size: 8.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: Replacement Pending
  Label: Replacement Pending
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [85, 255, 0, 255]
  Size: 8.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 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

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: ReplacementStatus

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• globalid ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: globalid )
• CreationDate ( type: esriFieldTypeDate, alias: CreationDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CreationDate )
• Creator ( type: esriFieldTypeString, alias: Creator, editable: false, nullable: true, length: 128, defaultValue: null, modelName: Creator )
• EditDate ( type: esriFieldTypeDate, alias: EditDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: EditDate )
• Editor ( type: esriFieldTypeString, alias: Editor, editable: false, nullable: true, length: 128, defaultValue: null, modelName: Editor )
• street_address ( type: esriFieldTypeString, alias: Street Address, editable: true, nullable: true, length: 255, defaultValue: null, modelName: street_address )
• F_date ( type: esriFieldTypeDate, alias: Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: F_date )
• customer_name ( type: esriFieldTypeString, alias: Customer Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: customer_name )
• customer_phone_number ( type: esriFieldTypeString, alias: Customer Phone Number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: customer_phone_number )
• property_owner_name ( type: esriFieldTypeString, alias: Property Owner Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: property_owner_name )
• property_owner_phone_number ( type: esriFieldTypeString, alias: Property Owner Phone Number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: property_owner_phone_number )
• has_property_owner_signed_relea ( type: esriFieldTypeString, alias: Has property owner signed release of liability form?, editable: true, nullable: true, length: 5, defaultValue: null, modelName: has_property_owner_signed_relea , Coded Values: [Yes: Yes] , [No: No] )
• has_property_owner_signed_worki ( type: esriFieldTypeString, alias: Has property owner signed working on private property form?, editable: true, nullable: true, length: 5, defaultValue: null, modelName: has_property_owner_signed_worki , Coded Values: [Yes: Yes] , [No: No] )
• did_property_owner_sign_refusal ( type: esriFieldTypeString, alias: Did property owner sign refusal form?, editable: true, nullable: true, length: 5, defaultValue: null, modelName: did_property_owner_sign_refusal , Coded Values: [Yes: Yes] , [No: No] )
• project_details ( type: esriFieldTypeString, alias: Project Details:, editable: true, nullable: true, length: 255, defaultValue: null, modelName: project_details )
• project_details_other ( type: esriFieldTypeString, alias: Other - Project Details:, editable: true, nullable: true, length: 255, defaultValue: null, modelName: project_details_other )
• service_replacement ( type: esriFieldTypeString, alias: Service Replacement, editable: true, nullable: true, length: 255, defaultValue: null, modelName: service_replacement )
• length_of_customer_side_service ( type: esriFieldTypeDouble, alias: Length of customer side service to be replaced., editable: true, nullable: true, defaultValue: null, modelName: length_of_customer_side_service )
• does_meter_location_need_to_be_ ( type: esriFieldTypeString, alias: Does meter location need to be changed?, editable: true, nullable: true, length: 5, defaultValue: null, modelName: does_meter_location_need_to_be_ , Coded Values: [Yes: Yes] , [No: No] )
• length_of_city_side_service_to_ ( type: esriFieldTypeDouble, alias: Length of City Side service to be replaced., editable: true, nullable: true, defaultValue: null, modelName: length_of_city_side_service_to_ )
• remarks_regarding_customer_side ( type: esriFieldTypeString, alias: Remarks regarding customer side service, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: remarks_regarding_customer_side )
• description_of_additional_under ( type: esriFieldTypeString, alias: Description of additional underground work needed, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: description_of_additional_under )
• contractor_assigned_to_job ( type: esriFieldTypeString, alias: Contractor assigned to job, editable: true, nullable: true, length: 255, defaultValue: null, modelName: contractor_assigned_to_job )
• date_scheduled ( type: esriFieldTypeDate, alias: Date Scheduled, editable: true, nullable: true, length: 8, defaultValue: null, modelName: date_scheduled )
• date_of_advanced_notice ( type: esriFieldTypeDate, alias: Date of advanced notice, editable: true, nullable: true, length: 8, defaultValue: null, modelName: date_of_advanced_notice )
• date_completedinspected ( type: esriFieldTypeDate, alias: Date completed/Inspected, editable: true, nullable: true, length: 8, defaultValue: null, modelName: date_completedinspected )
• inspected_by ( type: esriFieldTypeString, alias: Inspected by:, editable: true, nullable: true, length: 255, defaultValue: null, modelName: inspected_by )
• record_updates ( type: esriFieldTypeString, alias: Record Updates:, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: record_updates , Coded Values: [Yes: Yes] , [No: No] )
• size_of_customer_service ( type: esriFieldTypeString, alias: Size of customer service., editable: true, nullable: true, length: 255, defaultValue: null, modelName: size_of_customer_service , Coded Values: [1: 1/2"] , [2: 5/8"] , [3: 3/4"] , ...17 more... )
• building_foundation ( type: esriFieldTypeString, alias: Building Foundation, editable: true, nullable: true, length: 255, defaultValue: null, modelName: building_foundation , Coded Values: [Basement: Basement] , [Crawl Space: Crawl Space] , [Slab: Slab] , ...1 more... )
• meter_location ( type: esriFieldTypeString, alias: Meter Location, editable: true, nullable: true, length: 255, defaultValue: null, modelName: meter_location , Coded Values: [Basement: Basement] , [Crawl Space: Crawl Space] , [Utility Room: Utility Room] , ...2 more... )
• meter_location_other ( type: esriFieldTypeString, alias: Other - Meter Location, editable: true, nullable: true, length: 255, defaultValue: null, modelName: meter_location_other )
• ReplacementStatus ( type: esriFieldTypeString, alias: Replacement Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ReplacementStatus , Coded Values: [No Authorization: No Authorization] , [Replacement Pending: Replacement Pending] , [Replacement Complete: Replacement Complete] )
• ReplacementType ( type: esriFieldTypeString, alias: Reason For Replacement, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ReplacementType , Coded Values: [Frozen Service: Frozen Service] , [Watermain Project: Watermain Project] , [Lead/Galvanized: Lead/Galvanized] )
• ProjectYr ( type: esriFieldTypeString, alias: ProjectYr, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectYr )

Types:

ID: No Authorization
Name: No Authorization
Domains:
• has_property_owner_signed_relea:
  Inherited
• has_property_owner_signed_worki:
  Inherited
• did_property_owner_sign_refusal:
  Inherited
• does_meter_location_need_to_be_:
  Inherited
• record_updates:
  Inherited
• size_of_customer_service:
  Inherited
• building_foundation:
  Inherited
• meter_location:
  Inherited
• ReplacementStatus:
  Inherited
• ReplacementType:
  Inherited
Templates:
• Name: No Authorization
  Description:
  Prototype:
  ReplacementType: null
  ReplacementStatus: No Authorization
  ProjectYr: null
  meter_location_other: null
  meter_location: null
  building_foundation: null
  size_of_customer_service: null
  street_address: null
  F_date: null
  customer_name: null
  customer_phone_number: null
  property_owner_name: null
  property_owner_phone_number: null
  has_property_owner_signed_relea: null
  has_property_owner_signed_worki: null
  did_property_owner_sign_refusal: null
  project_details: null
  project_details_other: null
  service_replacement: null
  length_of_customer_side_service: null
  does_meter_location_need_to_be_: null
  length_of_city_side_service_to_: null
  remarks_regarding_customer_side: null
  description_of_additional_under: null
  contractor_assigned_to_job: null
  date_scheduled: null
  date_of_advanced_notice: null
  date_completedinspected: null
  inspected_by: null
  record_updates: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Replacement Complete
Name: Replacement Complete
Domains:
• has_property_owner_signed_relea:
  Inherited
• has_property_owner_signed_worki:
  Inherited
• did_property_owner_sign_refusal:
  Inherited
• does_meter_location_need_to_be_:
  Inherited
• record_updates:
  Inherited
• size_of_customer_service:
  Inherited
• building_foundation:
  Inherited
• meter_location:
  Inherited
• ReplacementStatus:
  Inherited
• ReplacementType:
  Inherited
Templates:
• Name: Replacement Complete
  Description:
  Prototype:
  ReplacementType: null
  ReplacementStatus: Replacement Complete
  ProjectYr: null
  meter_location_other: null
  meter_location: null
  building_foundation: null
  size_of_customer_service: null
  street_address: null
  F_date: null
  customer_name: null
  customer_phone_number: null
  property_owner_name: null
  property_owner_phone_number: null
  has_property_owner_signed_relea: null
  has_property_owner_signed_worki: null
  did_property_owner_sign_refusal: null
  project_details: null
  project_details_other: null
  service_replacement: null
  length_of_customer_side_service: null
  does_meter_location_need_to_be_: null
  length_of_city_side_service_to_: null
  remarks_regarding_customer_side: null
  description_of_additional_under: null
  contractor_assigned_to_job: null
  date_scheduled: null
  date_of_advanced_notice: null
  date_completedinspected: null
  inspected_by: null
  record_updates: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Replacement Pending
Name: Replacement Pending
Domains:
• has_property_owner_signed_relea:
  Inherited
• has_property_owner_signed_worki:
  Inherited
• did_property_owner_sign_refusal:
  Inherited
• does_meter_location_need_to_be_:
  Inherited
• record_updates:
  Inherited
• size_of_customer_service:
  Inherited
• building_foundation:
  Inherited
• meter_location:
  Inherited
• ReplacementStatus:
  Inherited
• ReplacementType:
  Inherited
Templates:
• Name: Replacement Pending
  Description:
  Prototype:
  ReplacementType: null
  ReplacementStatus: Replacement Pending
  ProjectYr: null
  meter_location_other: null
  meter_location: null
  building_foundation: null
  size_of_customer_service: null
  street_address: null
  F_date: null
  customer_name: null
  customer_phone_number: null
  property_owner_name: null
  property_owner_phone_number: null
  has_property_owner_signed_relea: null
  has_property_owner_signed_worki: null
  did_property_owner_sign_refusal: null
  project_details: null
  project_details_other: null
  service_replacement: null
  length_of_customer_side_service: null
  does_meter_location_need_to_be_: null
  length_of_city_side_service_to_: null
  remarks_regarding_customer_side: null
  description_of_additional_under: null
  contractor_assigned_to_job: null
  date_scheduled: null
  date_of_advanced_notice: null
  date_completedinspected: null
  inspected_by: null
  record_updates: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

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: CreationDate
• Creator Field: Creator
• Edit Date Field: EditDate
• Editor Field: Editor

Supports Query With Historic Moment: true

Supports Coordinates Quantization: true

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