Name: BPCCCP_2022

Display Field: BUSINESS_NAME__CIS_

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:

XMin: 3130904.59688909
YMin: 1649960.95767559
XMax: 3152231.29250906
YMax: 1672430.58440661
Spatial Reference: 103013 (6428)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[76,230,0,255],"size":7,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.5}}},"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:

Name : OBJECTID

IsSystemMaintained : True

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)
• BUSINESS_NAME__CIS_ (type: esriFieldTypeString, alias: BUSINESS NAME (CIS), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Updated_Business_Names (type: esriFieldTypeString, alias: Updated Business Names, 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_ (type: esriFieldTypeString, alias: Address (Concat), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Primary_Contact (type: esriFieldTypeString, alias: Primary 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: esriFieldTypeString, alias: Date Survey Completed, SQL Type: sqlTypeOther, length: 255, 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)
• BSI_Record_No__of_BF_Devices_at (type: esriFieldTypeString, alias: BSI Record No. of BF Devices at Property, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Type_of_BF_Device_in_BSI (type: esriFieldTypeString, alias: Type of BF Device in BSI, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Survey_Inspection_Report_Data (type: esriFieldTypeString, alias: Survey/Inspection Report Data , SQL Type: sqlTypeOther, length: 354, 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_Confirmed (type: esriFieldTypeString, alias: Date Uncontrolled CC Confirmed, 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)
• Follow_Up_Inspections_BSI (type: esriFieldTypeString, alias: Follow Up Inspections BSI, SQL Type: sqlTypeOther, length: 255, 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_BS (type: esriFieldTypeString, alias: COL_BS, 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)
• 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:

Name: BPCCCP_2022
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/9/2023 9:27:30 PM

Schema Last Edit Date: 3/9/2023 9:27:30 PM

Data Last Edit Date: 3/9/2023 9:27:30 PM

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