Layer: Phase1_August102022 (ID:1)

View In: Map Viewer

Name: Phase1_August102022

Display Field: c_firstname__billing_

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,0,0,255],"size":10,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
c_account__billing_ (type: esriFieldTypeString, alias: c_account (billing), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Active_Inactive_for__Survey_Req (type: esriFieldTypeString, alias: Active/Inactive for Survey Requirement, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
c_firstname__billing_ (type: esriFieldTypeString, alias: c_firstname (billing), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
c_lastname__billing_ (type: esriFieldTypeString, alias: c_lastname (billing), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
BUSINESS_NAME__CIS_ (type: esriFieldTypeString, alias: BUSINESS NAME (CIS), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Combined_Name__CIS__CALC_ (type: esriFieldTypeString, alias: Combined Name (CIS -CALC) , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Service_Address__Text_ (type: esriFieldTypeString, alias: Service Address (Text), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Address__Concat_Formula_ (type: esriFieldTypeString, alias: Address (Concat Formula), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Primary_Business_Contact (type: esriFieldTypeString, alias: Primary Business Contact, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Primary_Email (type: esriFieldTypeString, alias: Primary Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Primary_Phone_Number (type: esriFieldTypeString, alias: Primary Phone Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Owner_Name (type: esriFieldTypeString, alias: Owner Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Owner_Email (type: esriFieldTypeString, alias: Owner Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Owner_Phone_Number (type: esriFieldTypeString, alias: Owner Phone Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Owner_Address (type: esriFieldTypeString, alias: Owner Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Property_Manager (type: esriFieldTypeString, alias: Property Manager, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
PM_Email (type: esriFieldTypeString, alias: PM Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Property_Manager_Phone (type: esriFieldTypeString, alias: Property Manager Phone, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
PM_Mailing_Address (type: esriFieldTypeString, alias: PM Mailing Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
c_streetnum (type: esriFieldTypeString, alias: c_streetnum, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
c_streetprefix (type: esriFieldTypeString, alias: c_streetprefix, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
c_street (type: esriFieldTypeString, alias: c_street, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
c_streetsuffix (type: esriFieldTypeString, alias: c_streetsuffix, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
c_town (type: esriFieldTypeString, alias: c_town, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
c_prov (type: esriFieldTypeString, alias: c_prov, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
c_postcode (type: esriFieldTypeString, alias: c_postcode, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
c_service (type: esriFieldTypeString, alias: c_service, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
c_billcode (type: esriFieldTypeString, alias: c_billcode, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
c_cycle (type: esriFieldTypeString, alias: c_cycle, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
exp (type: esriFieldTypeString, alias: exp, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
c_structuretype1 (type: esriFieldTypeString, alias: c_structuretype1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
c_accountstatus1 (type: esriFieldTypeString, alias: c_accountstatus1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
c_streetprefix1 (type: esriFieldTypeString, alias: c_streetprefix1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
c_streetsuffix1 (type: esriFieldTypeString, alias: c_streetsuffix1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
c_prov1 (type: esriFieldTypeString, alias: c_prov1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
c_service1 (type: esriFieldTypeString, alias: c_service1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
c_billcode1 (type: esriFieldTypeString, alias: c_billcode1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
c_cycle1 (type: esriFieldTypeString, alias: c_cycle1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Number_of_Units___multi_family_ (type: esriFieldTypeInteger, alias: Number of Units (multi-family only), SQL Type: sqlTypeOther, nullable: true, editable: true)
F1st_Survey_Form_Request_Date (type: esriFieldTypeDate, alias: 1st Survey Form Request Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
F2nd_Survey_Form_Request_Date (type: esriFieldTypeString, alias: 2nd Survey Form Request Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Date_Survey_Completed (type: esriFieldTypeDate, alias: Date Survey Completed, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Survey_Completed_By (type: esriFieldTypeString, alias: Survey Completed By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Bldg_No_ (type: esriFieldTypeString, alias: Bldg No., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Type_of_Business (type: esriFieldTypeString, alias: Type of Business, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Bldg_Type (type: esriFieldTypeString, alias: Bldg Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Total_Number_of_Cross_Connectio (type: esriFieldTypeInteger, alias: Total Number of Cross-Connections, SQL Type: sqlTypeOther, nullable: true, editable: true)
Number_of_Backflow_Devices_at_P (type: esriFieldTypeInteger, alias: Number of Backflow Devices at Property, SQL Type: sqlTypeOther, nullable: true, editable: true)
Number_of_Uncontrolled_Cross_Co (type: esriFieldTypeInteger, alias: Number of Uncontrolled Cross Connections, SQL Type: sqlTypeOther, nullable: true, editable: true)
Survey_Inspection_Report_Data (type: esriFieldTypeString, alias: Survey/Inspection Report Data, SQL Type: sqlTypeOther, length: 354, nullable: true, editable: true)
COE_Record_No__of_BF_Devices_at (type: esriFieldTypeString, alias: COE Record No. of BF Devices at Property, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Description_of_Uncontrolled_Cro (type: esriFieldTypeString, alias: Description of Uncontrolled Cross Connections, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Contained_Isolated_No_Hazard (type: esriFieldTypeString, alias: Contained/Isolated/No Hazard, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Date_Uncontrolled_CC_Discovered (type: esriFieldTypeString, alias: Date Uncontrolled CC Discovered, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Number_of_Backflow_Methods_at_P (type: esriFieldTypeString, alias: Number of Backflow Methods at Property (ex. air gap, vac breaker, rpv), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Date_Methods_Inpected__if_appli (type: esriFieldTypeString, alias: Date Methods Inpected (if applicable), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
COE___Uncontrolled_XX_Risk_Leve (type: esriFieldTypeInteger, alias: COE - Uncontrolled XX Risk Level (None 0, Low 1, Med 2 , High 3), SQL Type: sqlTypeOther, nullable: true, editable: true)
Date_Risk_Level_Categorized (type: esriFieldTypeDate, alias: Date Risk Level Categorized, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Date_Customer_Informed_of_Uncon (type: esriFieldTypeDate, alias: Date Customer Informed of Uncontrolled CC, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Actively_Addressing_Uncontrolle (type: esriFieldTypeString, alias: Actively Addressing Uncontrolled CC, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Resolution_Due_Date__Per_State_ (type: esriFieldTypeString, alias: Resolution Due Date Per State Extension, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Date_Uncontroled_CC_Resolved (type: esriFieldTypeString, alias: Date Uncontroled CC Resolved, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Days_Until_Controlled (type: esriFieldTypeString, alias: Days Until Controlled, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Date_Survey_Completed____In_Com (type: esriFieldTypeDate, alias: Date Survey Completed & In Compliance, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 715, nullable: true, editable: true)
Resolution_Due_Date_Required_by (type: esriFieldTypeString, alias: Resolution Due Date Required by COE in Correspondence , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
GIS_Service_Line_ID (type: esriFieldTypeInteger, alias: GIS Service Line ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
Inspection_Phase (type: esriFieldTypeString, alias: Inspection Phase , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Jody_Comments_on_Emails_During_ (type: esriFieldTypeString, alias: Jody Comments on Emails During Inspections, SQL Type: sqlTypeOther, length: 377, nullable: true, editable: true)
Latitude (type: esriFieldTypeString, alias: Latitude, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Longitude (type: esriFieldTypeString, alias: Longitude, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
COL_BT (type: esriFieldTypeString, alias: COL_BT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
COL_BU (type: esriFieldTypeString, alias: COL_BU, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
COL_BV (type: esriFieldTypeString, alias: COL_BV, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
COL_BW (type: esriFieldTypeString, alias: COL_BW, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Field (type: esriFieldTypeInteger, alias: Field, SQL Type: sqlTypeOther, nullable: true, editable: true)
Lat (type: esriFieldTypeDouble, alias: Lat, SQL Type: sqlTypeOther, nullable: true, editable: true)
Long (type: esriFieldTypeDouble, alias: Long, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/30/2022 7:13:09 PM

Schema Last Edit Date: 8/30/2022 7:13:09 PM

Data Last Edit Date: 8/30/2022 7:13:09 PM

Supported Operations: Query Query Pivot Query Top Features Query Analytic Query Bins Generate Renderer Validate SQL Get Estimates ConvertFormat