{ "layers" : [ { "currentVersion" : 12, "id" : 0, "name" : "BPCCCP_2020_2021", "type" : "Feature Layer", "serviceItemId" : "74d2eb58807f4cdd9cb8807efdea4bde", "cacheMaxAge" : 30, "displayField" : "BUSINESS_NAME__CIS_", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1678397247431, "schemaLastEditDate" : 1678397247431, "dataLastEditDate" : 1678397247431 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : false, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : 3130808.4636819605, "ymin" : 1649968.8337021435, "xmax" : 3151954.0399013031, "ymax" : 1672073.7903822614, "spatialReference" : { "wkid" : 103013, "latestWkid" : 6428 } }, "drawingInfo":{"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}, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "c_account__billing_", "type" : "esriFieldTypeString", "alias" : "c_account (billing)", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "BUSINESS_NAME__CIS_", "type" : "esriFieldTypeString", "alias" : "BUSINESS NAME (CIS)", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Updated_Business_Names", "type" : "esriFieldTypeString", "alias" : "Updated Business Names", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Service_Address__Text_", "type" : "esriFieldTypeString", "alias" : "Service Address (Text)", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Address__Concat_", "type" : "esriFieldTypeString", "alias" : "Address (Concat)", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Primary_Contact", "type" : "esriFieldTypeString", "alias" : "Primary Contact", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Primary_Email", "type" : "esriFieldTypeString", "alias" : "Primary Email", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Primary_Phone_Number", "type" : "esriFieldTypeString", "alias" : "Primary Phone Number", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Owner_Name", "type" : "esriFieldTypeString", "alias" : "Owner Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Owner_Email", "type" : "esriFieldTypeString", "alias" : "Owner Email", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Owner_Phone_Number", "type" : "esriFieldTypeString", "alias" : "Owner Phone Number", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Owner_Address", "type" : "esriFieldTypeString", "alias" : "Owner Address", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Property_Manager", "type" : "esriFieldTypeString", "alias" : "Property Manager", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PM_Email", "type" : "esriFieldTypeString", "alias" : "PM Email", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Property_Manager_Phone", "type" : "esriFieldTypeString", "alias" : "Property Manager Phone", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PM_Mailing_Address", "type" : "esriFieldTypeString", "alias" : "PM Mailing Address", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_streetnum", "type" : "esriFieldTypeString", "alias" : "c_streetnum", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_streetprefix", "type" : "esriFieldTypeString", "alias" : "c_streetprefix", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_street", "type" : "esriFieldTypeString", "alias" : "c_street", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_streetsuffix", "type" : "esriFieldTypeString", "alias" : "c_streetsuffix", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_town", "type" : "esriFieldTypeString", "alias" : "c_town", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_prov", "type" : "esriFieldTypeString", "alias" : "c_prov", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_postcode", "type" : "esriFieldTypeString", "alias" : "c_postcode", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_service", "type" : "esriFieldTypeString", "alias" : "c_service", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_billcode", "type" : "esriFieldTypeString", "alias" : "c_billcode", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_cycle", "type" : "esriFieldTypeString", "alias" : "c_cycle", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "exp", "type" : "esriFieldTypeString", "alias" : "exp", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_structuretype1", "type" : "esriFieldTypeString", "alias" : "c_structuretype1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_accountstatus1", "type" : "esriFieldTypeString", "alias" : "c_accountstatus1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_streetprefix1", "type" : "esriFieldTypeString", "alias" : "c_streetprefix1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_streetsuffix1", "type" : "esriFieldTypeString", "alias" : "c_streetsuffix1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_prov1", "type" : "esriFieldTypeString", "alias" : "c_prov1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_service1", "type" : "esriFieldTypeString", "alias" : "c_service1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_billcode1", "type" : "esriFieldTypeString", "alias" : "c_billcode1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_cycle1", "type" : "esriFieldTypeString", "alias" : "c_cycle1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Number_of_Units___multi_family_", "type" : "esriFieldTypeInteger", "alias" : "Number of Units \n(multi-family only)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "F1st_Survey_Form_Request_Date", "type" : "esriFieldTypeDate", "alias" : "1st Survey Form Request Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "F2nd_Survey_Form_Request_Date", "type" : "esriFieldTypeString", "alias" : "2nd Survey Form Request Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Date_Survey_Completed", "type" : "esriFieldTypeString", "alias" : "Date Survey Completed", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Survey_Completed_By", "type" : "esriFieldTypeString", "alias" : "Survey Completed By", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Bldg_No_", "type" : "esriFieldTypeString", "alias" : "Bldg No.", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Type_of_Business", "type" : "esriFieldTypeString", "alias" : "Type of Business", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Bldg_Type", "type" : "esriFieldTypeString", "alias" : "Bldg\nType", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Total_Number_of_Cross_Connectio", "type" : "esriFieldTypeInteger", "alias" : "Total Number of Cross-Connections", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Number_of_Backflow_Devices_at_P", "type" : "esriFieldTypeInteger", "alias" : "Number of Backflow Devices at Property", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Number_of_Uncontrolled_Cross_Co", "type" : "esriFieldTypeInteger", "alias" : "Number of Uncontrolled Cross Connections", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "BSI_Record_No__of_BF_Devices_at", "type" : "esriFieldTypeString", "alias" : "BSI Record No. of BF Devices at Property", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Type_of_BF_Device_in_BSI", "type" : "esriFieldTypeString", "alias" : "Type of BF Device in BSI", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Survey_Inspection_Report_Data", "type" : "esriFieldTypeString", "alias" : "Survey/Inspection Report Data ", "sqlType" : "sqlTypeOther", "length" : 354, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Description_of_Uncontrolled_Cro", "type" : "esriFieldTypeString", "alias" : "Description of Uncontrolled Cross Connections", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Contained_Isolated_No_Hazard", "type" : "esriFieldTypeString", "alias" : "Contained/Isolated/No Hazard", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Date_Uncontrolled_CC_Confirmed", "type" : "esriFieldTypeString", "alias" : "Date Uncontrolled CC Confirmed", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Number_of_Backflow_Methods_at_P", "type" : "esriFieldTypeString", "alias" : "Number of Backflow Methods at Property (ex. air gap, vac breaker, rpv)", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Date_Methods_Inpected__if_appli", "type" : "esriFieldTypeString", "alias" : "Date Methods Inpected (if applicable)", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "COE___Uncontrolled_XX_Risk_Leve", "type" : "esriFieldTypeInteger", "alias" : "COE - Uncontrolled XX Risk Level (None 0, Low 1, Med 2 , High 3)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Date_Risk_Level_Categorized", "type" : "esriFieldTypeDate", "alias" : "Date Risk Level Categorized", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Date_Customer_Informed_of_Uncon", "type" : "esriFieldTypeDate", "alias" : "Date Customer Informed of Uncontrolled CC", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Actively_Addressing_Uncontrolle", "type" : "esriFieldTypeString", "alias" : "Actively Addressing Uncontrolled CC", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Resolution_Due_Date__Per_State_", "type" : "esriFieldTypeString", "alias" : "Resolution Due Date \nPer State Extension", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Date_Uncontroled_CC_Resolved", "type" : "esriFieldTypeString", "alias" : "Date Uncontroled CC Resolved", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Days_Until_Controlled", "type" : "esriFieldTypeString", "alias" : "Days Until Controlled", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Date_Survey_Completed____In_Com", "type" : "esriFieldTypeDate", "alias" : "Date Survey Completed \n& In Compliance", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Comments", "type" : "esriFieldTypeString", "alias" : "Comments", "sqlType" : "sqlTypeOther", "length" : 715, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Resolution_Due_Date_Required_by", "type" : "esriFieldTypeString", "alias" : "Resolution Due Date Required by COE in Correspondence ", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GIS_Service_Line_ID", "type" : "esriFieldTypeInteger", "alias" : "GIS Service Line ID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Follow_Up_Inspections_BSI", "type" : "esriFieldTypeString", "alias" : "Follow Up Inspections BSI", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Inspection_Phase", "type" : "esriFieldTypeString", "alias" : "Inspection Phase ", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Jody_Comments_on_Emails_During_", "type" : "esriFieldTypeString", "alias" : "Jody Comments on Emails During Inspections", "sqlType" : "sqlTypeOther", "length" : 377, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Latitude", "type" : "esriFieldTypeString", "alias" : "Latitude", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Longitude", "type" : "esriFieldTypeString", "alias" : "Longitude", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "COL_BS", "type" : "esriFieldTypeString", "alias" : "COL_BS", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "COL_BT", "type" : "esriFieldTypeString", "alias" : "COL_BT", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "COL_BU", "type" : "esriFieldTypeString", "alias" : "COL_BU", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "COL_BV", "type" : "esriFieldTypeString", "alias" : "COL_BV", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Lat", "type" : "esriFieldTypeDouble", "alias" : "Lat", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Long", "type" : "esriFieldTypeDouble", "alias" : "Long", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__BPCCCP_D__F4B70D8558EBFB46", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_9494.BPCCCP_DATA_BPCCCP_2020_20212_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "BPCCCP_2020_2021", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "Lat" : null, "c_account__billing_" : null, "BUSINESS_NAME__CIS_" : null, "Updated_Business_Names" : null, "Service_Address__Text_" : null, "Address__Concat_" : null, "Primary_Contact" : null, "Primary_Email" : null, "Primary_Phone_Number" : null, "Owner_Name" : null, "Owner_Email" : null, "Owner_Phone_Number" : null, "Owner_Address" : null, "Property_Manager" : null, "PM_Email" : null, "Property_Manager_Phone" : null, "PM_Mailing_Address" : null, "c_streetnum" : null, "c_streetprefix" : null, "c_street" : null, "c_streetsuffix" : null, "c_town" : null, "c_prov" : null, "c_postcode" : null, "c_service" : null, "c_billcode" : null, "c_cycle" : null, "exp" : null, "c_structuretype1" : null, "c_accountstatus1" : null, "c_streetprefix1" : null, "c_streetsuffix1" : null, "c_prov1" : null, "c_service1" : null, "c_billcode1" : null, "c_cycle1" : null, "Number_of_Units___multi_family_" : null, "F1st_Survey_Form_Request_Date" : null, "F2nd_Survey_Form_Request_Date" : null, "Date_Survey_Completed" : null, "Survey_Completed_By" : null, "Bldg_No_" : null, "Type_of_Business" : null, "Bldg_Type" : null, "Total_Number_of_Cross_Connectio" : null, "Number_of_Backflow_Devices_at_P" : null, "Number_of_Uncontrolled_Cross_Co" : null, "BSI_Record_No__of_BF_Devices_at" : null, "Type_of_BF_Device_in_BSI" : null, "Survey_Inspection_Report_Data" : null, "Description_of_Uncontrolled_Cro" : null, "Contained_Isolated_No_Hazard" : null, "Date_Uncontrolled_CC_Confirmed" : null, "Number_of_Backflow_Methods_at_P" : null, "Date_Methods_Inpected__if_appli" : null, "COE___Uncontrolled_XX_Risk_Leve" : null, "Date_Risk_Level_Categorized" : null, "Date_Customer_Informed_of_Uncon" : null, "Actively_Addressing_Uncontrolle" : null, "Resolution_Due_Date__Per_State_" : null, "Date_Uncontroled_CC_Resolved" : null, "Days_Until_Controlled" : null, "Date_Survey_Completed____In_Com" : null, "Comments" : null, "Resolution_Due_Date_Required_by" : null, "GIS_Service_Line_ID" : null, "Follow_Up_Inspections_BSI" : null, "Inspection_Phase" : null, "Jody_Comments_on_Emails_During_" : null, "Latitude" : null, "Longitude" : null, "COL_BS" : null, "COL_BT" : null, "COL_BU" : null, "COL_BV" : null, "Long" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 1, "name" : "BPCCCP_2022", "type" : "Feature Layer", "serviceItemId" : "74d2eb58807f4cdd9cb8807efdea4bde", "cacheMaxAge" : 30, "displayField" : "BUSINESS_NAME__CIS_", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1678397250175, "schemaLastEditDate" : 1678397250175, "dataLastEditDate" : 1678397250175 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : false, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : 3130904.5968890879, "ymin" : 1649960.9576755939, "xmax" : 3152231.29250906, "ymax" : 1672430.5844066096, "spatialReference" : { "wkid" : 103013, "latestWkid" : 6428 } }, "drawingInfo":{"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}, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "c_account__billing_", "type" : "esriFieldTypeString", "alias" : "c_account (billing)", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "BUSINESS_NAME__CIS_", "type" : "esriFieldTypeString", "alias" : "BUSINESS NAME (CIS)", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Updated_Business_Names", "type" : "esriFieldTypeString", "alias" : "Updated Business Names", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Service_Address__Text_", "type" : "esriFieldTypeString", "alias" : "Service Address (Text)", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Address__Concat_", "type" : "esriFieldTypeString", "alias" : "Address (Concat)", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Primary_Contact", "type" : "esriFieldTypeString", "alias" : "Primary Contact", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Primary_Email", "type" : "esriFieldTypeString", "alias" : "Primary Email", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Primary_Phone_Number", "type" : "esriFieldTypeString", "alias" : "Primary Phone Number", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Owner_Name", "type" : "esriFieldTypeString", "alias" : "Owner Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Owner_Email", "type" : "esriFieldTypeString", "alias" : "Owner Email", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Owner_Phone_Number", "type" : "esriFieldTypeString", "alias" : "Owner Phone Number", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Owner_Address", "type" : "esriFieldTypeString", "alias" : "Owner Address", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Property_Manager", "type" : "esriFieldTypeString", "alias" : "Property Manager", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PM_Email", "type" : "esriFieldTypeString", "alias" : "PM Email", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Property_Manager_Phone", "type" : "esriFieldTypeString", "alias" : "Property Manager Phone", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PM_Mailing_Address", "type" : "esriFieldTypeString", "alias" : "PM Mailing Address", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_streetnum", "type" : "esriFieldTypeString", "alias" : "c_streetnum", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_streetprefix", "type" : "esriFieldTypeString", "alias" : "c_streetprefix", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_street", "type" : "esriFieldTypeString", "alias" : "c_street", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_streetsuffix", "type" : "esriFieldTypeString", "alias" : "c_streetsuffix", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_town", "type" : "esriFieldTypeString", "alias" : "c_town", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_prov", "type" : "esriFieldTypeString", "alias" : "c_prov", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_postcode", "type" : "esriFieldTypeString", "alias" : "c_postcode", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_service", "type" : "esriFieldTypeString", "alias" : "c_service", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_billcode", "type" : "esriFieldTypeString", "alias" : "c_billcode", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_cycle", "type" : "esriFieldTypeString", "alias" : "c_cycle", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "exp", "type" : "esriFieldTypeString", "alias" : "exp", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_structuretype1", "type" : "esriFieldTypeString", "alias" : "c_structuretype1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_accountstatus1", "type" : "esriFieldTypeString", "alias" : "c_accountstatus1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_streetprefix1", "type" : "esriFieldTypeString", "alias" : "c_streetprefix1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_streetsuffix1", "type" : "esriFieldTypeString", "alias" : "c_streetsuffix1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_prov1", "type" : "esriFieldTypeString", "alias" : "c_prov1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_service1", "type" : "esriFieldTypeString", "alias" : "c_service1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_billcode1", "type" : "esriFieldTypeString", "alias" : "c_billcode1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_cycle1", "type" : "esriFieldTypeString", "alias" : "c_cycle1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Number_of_Units___multi_family_", "type" : "esriFieldTypeInteger", "alias" : "Number of Units \n(multi-family only)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "F1st_Survey_Form_Request_Date", "type" : "esriFieldTypeDate", "alias" : "1st Survey Form Request Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "F2nd_Survey_Form_Request_Date", "type" : "esriFieldTypeString", "alias" : "2nd Survey Form Request Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Date_Survey_Completed", "type" : "esriFieldTypeString", "alias" : "Date Survey Completed", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Survey_Completed_By", "type" : "esriFieldTypeString", "alias" : "Survey Completed By", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Bldg_No_", "type" : "esriFieldTypeString", "alias" : "Bldg No.", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Type_of_Business", "type" : "esriFieldTypeString", "alias" : "Type of Business", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Bldg_Type", "type" : "esriFieldTypeString", "alias" : "Bldg\nType", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Total_Number_of_Cross_Connectio", "type" : "esriFieldTypeInteger", "alias" : "Total Number of Cross-Connections", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Number_of_Backflow_Devices_at_P", "type" : "esriFieldTypeInteger", "alias" : "Number of Backflow Devices at Property", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Number_of_Uncontrolled_Cross_Co", "type" : "esriFieldTypeInteger", "alias" : "Number of Uncontrolled Cross Connections", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "BSI_Record_No__of_BF_Devices_at", "type" : "esriFieldTypeString", "alias" : "BSI Record No. of BF Devices at Property", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Type_of_BF_Device_in_BSI", "type" : "esriFieldTypeString", "alias" : "Type of BF Device in BSI", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Survey_Inspection_Report_Data", "type" : "esriFieldTypeString", "alias" : "Survey/Inspection Report Data ", "sqlType" : "sqlTypeOther", "length" : 354, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Description_of_Uncontrolled_Cro", "type" : "esriFieldTypeString", "alias" : "Description of Uncontrolled Cross Connections", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Contained_Isolated_No_Hazard", "type" : "esriFieldTypeString", "alias" : "Contained/Isolated/No Hazard", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Date_Uncontrolled_CC_Confirmed", "type" : "esriFieldTypeString", "alias" : "Date Uncontrolled CC Confirmed", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Number_of_Backflow_Methods_at_P", "type" : "esriFieldTypeString", "alias" : "Number of Backflow Methods at Property (ex. air gap, vac breaker, rpv)", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Date_Methods_Inpected__if_appli", "type" : "esriFieldTypeString", "alias" : "Date Methods Inpected (if applicable)", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "COE___Uncontrolled_XX_Risk_Leve", "type" : "esriFieldTypeInteger", "alias" : "COE - Uncontrolled XX Risk Level (None 0, Low 1, Med 2 , High 3)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Date_Risk_Level_Categorized", "type" : "esriFieldTypeDate", "alias" : "Date Risk Level Categorized", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Date_Customer_Informed_of_Uncon", "type" : "esriFieldTypeDate", "alias" : "Date Customer Informed of Uncontrolled CC", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Actively_Addressing_Uncontrolle", "type" : "esriFieldTypeString", "alias" : "Actively Addressing Uncontrolled CC", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Resolution_Due_Date__Per_State_", "type" : "esriFieldTypeString", "alias" : "Resolution Due Date \nPer State Extension", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Date_Uncontroled_CC_Resolved", "type" : "esriFieldTypeString", "alias" : "Date Uncontroled CC Resolved", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Days_Until_Controlled", "type" : "esriFieldTypeString", "alias" : "Days Until Controlled", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Date_Survey_Completed____In_Com", "type" : "esriFieldTypeDate", "alias" : "Date Survey Completed \n& In Compliance", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Comments", "type" : "esriFieldTypeString", "alias" : "Comments", "sqlType" : "sqlTypeOther", "length" : 715, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Resolution_Due_Date_Required_by", "type" : "esriFieldTypeString", "alias" : "Resolution Due Date Required by COE in Correspondence ", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GIS_Service_Line_ID", "type" : "esriFieldTypeInteger", "alias" : "GIS Service Line ID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Follow_Up_Inspections_BSI", "type" : "esriFieldTypeString", "alias" : "Follow Up Inspections BSI", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Inspection_Phase", "type" : "esriFieldTypeString", "alias" : "Inspection Phase ", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Jody_Comments_on_Emails_During_", "type" : "esriFieldTypeString", "alias" : "Jody Comments on Emails During Inspections", "sqlType" : "sqlTypeOther", "length" : 377, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Latitude", "type" : "esriFieldTypeString", "alias" : "Latitude", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Longitude", "type" : "esriFieldTypeString", "alias" : "Longitude", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "COL_BS", "type" : "esriFieldTypeString", "alias" : "COL_BS", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "COL_BT", "type" : "esriFieldTypeString", "alias" : "COL_BT", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "COL_BU", "type" : "esriFieldTypeString", "alias" : "COL_BU", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "COL_BV", "type" : "esriFieldTypeString", "alias" : "COL_BV", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Lat", "type" : "esriFieldTypeDouble", "alias" : "Lat", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Long", "type" : "esriFieldTypeDouble", "alias" : "Long", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__BPCCCP_D__F4B70D85DD7170C9", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_9494.BPCCCP_DATA_BPCCCP_20222_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "BPCCCP_2022", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "Lat" : null, "c_account__billing_" : null, "BUSINESS_NAME__CIS_" : null, "Updated_Business_Names" : null, "Service_Address__Text_" : null, "Address__Concat_" : null, "Primary_Contact" : null, "Primary_Email" : null, "Primary_Phone_Number" : null, "Owner_Name" : null, "Owner_Email" : null, "Owner_Phone_Number" : null, "Owner_Address" : null, "Property_Manager" : null, "PM_Email" : null, "Property_Manager_Phone" : null, "PM_Mailing_Address" : null, "c_streetnum" : null, "c_streetprefix" : null, "c_street" : null, "c_streetsuffix" : null, "c_town" : null, "c_prov" : null, "c_postcode" : null, "c_service" : null, "c_billcode" : null, "c_cycle" : null, "exp" : null, "c_structuretype1" : null, "c_accountstatus1" : null, "c_streetprefix1" : null, "c_streetsuffix1" : null, "c_prov1" : null, "c_service1" : null, "c_billcode1" : null, "c_cycle1" : null, "Number_of_Units___multi_family_" : null, "F1st_Survey_Form_Request_Date" : null, "F2nd_Survey_Form_Request_Date" : null, "Date_Survey_Completed" : null, "Survey_Completed_By" : null, "Bldg_No_" : null, "Type_of_Business" : null, "Bldg_Type" : null, "Total_Number_of_Cross_Connectio" : null, "Number_of_Backflow_Devices_at_P" : null, "Number_of_Uncontrolled_Cross_Co" : null, "BSI_Record_No__of_BF_Devices_at" : null, "Type_of_BF_Device_in_BSI" : null, "Survey_Inspection_Report_Data" : null, "Description_of_Uncontrolled_Cro" : null, "Contained_Isolated_No_Hazard" : null, "Date_Uncontrolled_CC_Confirmed" : null, "Number_of_Backflow_Methods_at_P" : null, "Date_Methods_Inpected__if_appli" : null, "COE___Uncontrolled_XX_Risk_Leve" : null, "Date_Risk_Level_Categorized" : null, "Date_Customer_Informed_of_Uncon" : null, "Actively_Addressing_Uncontrolle" : null, "Resolution_Due_Date__Per_State_" : null, "Date_Uncontroled_CC_Resolved" : null, "Days_Until_Controlled" : null, "Date_Survey_Completed____In_Com" : null, "Comments" : null, "Resolution_Due_Date_Required_by" : null, "GIS_Service_Line_ID" : null, "Follow_Up_Inspections_BSI" : null, "Inspection_Phase" : null, "Jody_Comments_on_Emails_During_" : null, "Latitude" : null, "Longitude" : null, "COL_BS" : null, "COL_BT" : null, "COL_BU" : null, "COL_BV" : null, "Long" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 2, "name" : "BPCCCP Inactives and Shutoffs", "type" : "Feature Layer", "serviceItemId" : "74d2eb58807f4cdd9cb8807efdea4bde", "cacheMaxAge" : 30, "displayField" : "BUSINESS_NAME__CIS_", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1678397252505, "schemaLastEditDate" : 1678397252505, "dataLastEditDate" : 1678397252505 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : false, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : 3138211.7187860138, "ymin" : 1656450.9593990848, "xmax" : 3147477.1477469751, "ymax" : 1670215.2730990939, "spatialReference" : { "wkid" : 103013, "latestWkid" : 6428 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[230,0,0,255],"size":7,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.6}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "c_account__billing_", "type" : "esriFieldTypeString", "alias" : "c_account (billing)", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "BUSINESS_NAME__CIS_", "type" : "esriFieldTypeString", "alias" : "BUSINESS NAME (CIS)", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Updated_Business_Names", "type" : "esriFieldTypeString", "alias" : "Updated Business Names", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Service_Address__Text_", "type" : "esriFieldTypeString", "alias" : "Service Address (Text)", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Address__Concat_", "type" : "esriFieldTypeString", "alias" : "Address (Concat)", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Primary_Contact", "type" : "esriFieldTypeString", "alias" : "Primary Contact", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Primary_Email", "type" : "esriFieldTypeString", "alias" : "Primary Email", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Primary_Phone_Number", "type" : "esriFieldTypeString", "alias" : "Primary Phone Number", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Owner_Name", "type" : "esriFieldTypeString", "alias" : "Owner Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Owner_Email", "type" : "esriFieldTypeString", "alias" : "Owner Email", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Owner_Phone_Number", "type" : "esriFieldTypeString", "alias" : "Owner Phone Number", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Owner_Address", "type" : "esriFieldTypeString", "alias" : "Owner Address", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Property_Manager", "type" : "esriFieldTypeString", "alias" : "Property Manager", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PM_Email", "type" : "esriFieldTypeString", "alias" : "PM Email", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Property_Manager_Phone", "type" : "esriFieldTypeString", "alias" : "Property Manager Phone", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PM_Mailing_Address", "type" : "esriFieldTypeString", "alias" : "PM Mailing Address", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_streetnum", "type" : "esriFieldTypeString", "alias" : "c_streetnum", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_streetprefix", "type" : "esriFieldTypeString", "alias" : "c_streetprefix", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_street", "type" : "esriFieldTypeString", "alias" : "c_street", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_streetsuffix", "type" : "esriFieldTypeString", "alias" : "c_streetsuffix", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_town", "type" : "esriFieldTypeString", "alias" : "c_town", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_prov", "type" : "esriFieldTypeString", "alias" : "c_prov", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_postcode", "type" : "esriFieldTypeString", "alias" : "c_postcode", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_service", "type" : "esriFieldTypeString", "alias" : "c_service", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_billcode", "type" : "esriFieldTypeString", "alias" : "c_billcode", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_cycle", "type" : "esriFieldTypeString", "alias" : "c_cycle", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "exp", "type" : "esriFieldTypeString", "alias" : "exp", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_structuretype1", "type" : "esriFieldTypeString", "alias" : "c_structuretype1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_accountstatus1", "type" : "esriFieldTypeString", "alias" : "c_accountstatus1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_streetprefix1", "type" : "esriFieldTypeString", "alias" : "c_streetprefix1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_streetsuffix1", "type" : "esriFieldTypeString", "alias" : "c_streetsuffix1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_prov1", "type" : "esriFieldTypeString", "alias" : "c_prov1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_service1", "type" : "esriFieldTypeString", "alias" : "c_service1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_billcode1", "type" : "esriFieldTypeString", "alias" : "c_billcode1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_cycle1", "type" : "esriFieldTypeString", "alias" : "c_cycle1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Number_of_Units___multi_family_", "type" : "esriFieldTypeInteger", "alias" : "Number of Units \n(multi-family only)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "F1st_Survey_Form_Request_Date", "type" : "esriFieldTypeString", "alias" : "1st Survey Form Request Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "F2nd_Survey_Form_Request_Date", "type" : "esriFieldTypeDate", "alias" : "2nd Survey Form Request Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Date_Survey_Completed", "type" : "esriFieldTypeString", "alias" : "Date Survey Completed", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Survey_Completed_By", "type" : "esriFieldTypeString", "alias" : "Survey Completed By", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Bldg_No_", "type" : "esriFieldTypeString", "alias" : "Bldg No.", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Type_of_Business", "type" : "esriFieldTypeString", "alias" : "Type of Business", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Bldg_Type", "type" : "esriFieldTypeString", "alias" : "Bldg\nType", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Total_Number_of_Cross_Connectio", "type" : "esriFieldTypeInteger", "alias" : "Total Number of Cross-Connections", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Number_of_Backflow_Devices_at_P", "type" : "esriFieldTypeInteger", "alias" : "Number of Backflow Devices at Property", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Number_of_Uncontrolled_Cross_Co", "type" : "esriFieldTypeInteger", "alias" : "Number of Uncontrolled Cross Connections", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "BSI_Record_No__of_BF_Devices_at", "type" : "esriFieldTypeInteger", "alias" : "BSI Record No. of BF Devices at Property", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Type_of_BF_Device_in_BSI", "type" : "esriFieldTypeString", "alias" : "Type of BF Device in BSI", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Survey_Inspection_Report_Data", "type" : "esriFieldTypeString", "alias" : "Survey/Inspection Report Data ", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Description_of_Uncontrolled_Cro", "type" : "esriFieldTypeString", "alias" : "Description of Uncontrolled Cross Connections", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Contained_Isolated_No_Hazard", "type" : "esriFieldTypeString", "alias" : "Contained/Isolated/No Hazard", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Date_Uncontrolled_CC_Confirmed", "type" : "esriFieldTypeString", "alias" : "Date Uncontrolled CC Confirmed", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Number_of_Backflow_Methods_at_P", "type" : "esriFieldTypeString", "alias" : "Number of Backflow Methods at Property (ex. air gap, vac breaker, rpv)", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Date_Methods_Inpected__if_appli", "type" : "esriFieldTypeString", "alias" : "Date Methods Inpected (if applicable)", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "COE___Uncontrolled_XX_Risk_Leve", "type" : "esriFieldTypeInteger", "alias" : "COE - Uncontrolled XX Risk Level (None 0, Low 1, Med 2 , High 3)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Date_Risk_Level_Categorized", "type" : "esriFieldTypeDate", "alias" : "Date Risk Level Categorized", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Date_Customer_Informed_of_Uncon", "type" : "esriFieldTypeString", "alias" : "Date Customer Informed of Uncontrolled CC", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Actively_Addressing_Uncontrolle", "type" : "esriFieldTypeString", "alias" : "Actively Addressing Uncontrolled CC", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Resolution_Due_Date__Per_State_", "type" : "esriFieldTypeDate", "alias" : "Resolution Due Date \nPer State Extension", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Date_Uncontroled_CC_Resolved", "type" : "esriFieldTypeString", "alias" : "Date Uncontroled CC Resolved", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Days_Until_Controlled", "type" : "esriFieldTypeInteger", "alias" : "Days Until Controlled", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Date_Survey_Completed____In_Com", "type" : "esriFieldTypeDate", "alias" : "Date Survey Completed \n& In Compliance", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Comments", "type" : "esriFieldTypeString", "alias" : "Comments", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Resolution_Due_Date_Required_by", "type" : "esriFieldTypeString", "alias" : "Resolution Due Date Required by COE in Correspondence ", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GIS_Service_Line_ID", "type" : "esriFieldTypeString", "alias" : "GIS Service Line ID", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Follow_Up_Inspections_BSI", "type" : "esriFieldTypeString", "alias" : "Follow Up Inspections BSI", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Inspection_Phase", "type" : "esriFieldTypeString", "alias" : "Inspection Phase ", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Jody_Comments_on_Emails_During_", "type" : "esriFieldTypeString", "alias" : "Jody Comments on Emails During Inspections", "sqlType" : "sqlTypeOther", "length" : 377, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Latitude", "type" : "esriFieldTypeDouble", "alias" : "Latitude", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Longitude", "type" : "esriFieldTypeDouble", "alias" : "Longitude", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__BPCCCP_D__F4B70D85E56E391F", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_9494.BPCCCP_DATA_BPCCCP_INACTIVES_AND_SHUTOFFS_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "BPCCCP Inactives and Shutoffs", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "Latitude" : null, "Longitude" : null, "c_account__billing_" : null, "BUSINESS_NAME__CIS_" : null, "Updated_Business_Names" : null, "Service_Address__Text_" : null, "Address__Concat_" : null, "Primary_Contact" : null, "Primary_Email" : null, "Primary_Phone_Number" : null, "Owner_Name" : null, "Owner_Email" : null, "Owner_Phone_Number" : null, "Owner_Address" : null, "Property_Manager" : null, "PM_Email" : null, "Property_Manager_Phone" : null, "PM_Mailing_Address" : null, "c_streetnum" : null, "c_streetprefix" : null, "c_street" : null, "c_streetsuffix" : null, "c_town" : null, "c_prov" : null, "c_postcode" : null, "c_service" : null, "c_billcode" : null, "c_cycle" : null, "exp" : null, "c_structuretype1" : null, "c_accountstatus1" : null, "c_streetprefix1" : null, "c_streetsuffix1" : null, "c_prov1" : null, "c_service1" : null, "c_billcode1" : null, "c_cycle1" : null, "Number_of_Units___multi_family_" : null, "F1st_Survey_Form_Request_Date" : null, "F2nd_Survey_Form_Request_Date" : null, "Date_Survey_Completed" : null, "Survey_Completed_By" : null, "Bldg_No_" : null, "Type_of_Business" : null, "Bldg_Type" : null, "Total_Number_of_Cross_Connectio" : null, "Number_of_Backflow_Devices_at_P" : null, "Number_of_Uncontrolled_Cross_Co" : null, "BSI_Record_No__of_BF_Devices_at" : null, "Type_of_BF_Device_in_BSI" : null, "Survey_Inspection_Report_Data" : null, "Description_of_Uncontrolled_Cro" : null, "Contained_Isolated_No_Hazard" : null, "Date_Uncontrolled_CC_Confirmed" : null, "Number_of_Backflow_Methods_at_P" : null, "Date_Methods_Inpected__if_appli" : null, "COE___Uncontrolled_XX_Risk_Leve" : null, "Date_Risk_Level_Categorized" : null, "Date_Customer_Informed_of_Uncon" : null, "Actively_Addressing_Uncontrolle" : null, "Resolution_Due_Date__Per_State_" : null, "Date_Uncontroled_CC_Resolved" : null, "Days_Until_Controlled" : null, "Date_Survey_Completed____In_Com" : null, "Comments" : null, "Resolution_Due_Date_Required_by" : null, "GIS_Service_Line_ID" : null, "Follow_Up_Inspections_BSI" : null, "Inspection_Phase" : null, "Jody_Comments_on_Emails_During_" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" } ], "tables" : [ { "currentVersion" : 12, "id" : 3, "name" : "BPCCCP_Inactives_Shutoffs", "type" : "Table", "serviceItemId" : "74d2eb58807f4cdd9cb8807efdea4bde", "cacheMaxAge" : 30, "displayField" : "BUSINESS_NAME__CIS_", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1678397252942, "schemaLastEditDate" : 1678397252942, "dataLastEditDate" : 1678397252942 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsReturningQueryExtent" : false, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "count" ], "useStandardizedQueries" : true, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "c_account__billing_", "type" : "esriFieldTypeString", "alias" : "c_account (billing)", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "BUSINESS_NAME__CIS_", "type" : "esriFieldTypeString", "alias" : "BUSINESS NAME (CIS)", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Updated_Business_Names", "type" : "esriFieldTypeString", "alias" : "Updated Business Names", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Service_Address__Text_", "type" : "esriFieldTypeString", "alias" : "Service Address (Text)", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Address__Concat_", "type" : "esriFieldTypeString", "alias" : "Address (Concat)", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Primary_Contact", "type" : "esriFieldTypeString", "alias" : "Primary Contact", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Primary_Email", "type" : "esriFieldTypeString", "alias" : "Primary Email", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Primary_Phone_Number", "type" : "esriFieldTypeString", "alias" : "Primary Phone Number", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Owner_Name", "type" : "esriFieldTypeString", "alias" : "Owner Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Owner_Email", "type" : "esriFieldTypeString", "alias" : "Owner Email", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Owner_Phone_Number", "type" : "esriFieldTypeString", "alias" : "Owner Phone Number", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Owner_Address", "type" : "esriFieldTypeString", "alias" : "Owner Address", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Property_Manager", "type" : "esriFieldTypeString", "alias" : "Property Manager", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PM_Email", "type" : "esriFieldTypeString", "alias" : "PM Email", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Property_Manager_Phone", "type" : "esriFieldTypeString", "alias" : "Property Manager Phone", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PM_Mailing_Address", "type" : "esriFieldTypeString", "alias" : "PM Mailing Address", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_streetnum", "type" : "esriFieldTypeString", "alias" : "c_streetnum", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_streetprefix", "type" : "esriFieldTypeString", "alias" : "c_streetprefix", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_street", "type" : "esriFieldTypeString", "alias" : "c_street", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_streetsuffix", "type" : "esriFieldTypeString", "alias" : "c_streetsuffix", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_town", "type" : "esriFieldTypeString", "alias" : "c_town", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_prov", "type" : "esriFieldTypeString", "alias" : "c_prov", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_postcode", "type" : "esriFieldTypeString", "alias" : "c_postcode", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_service", "type" : "esriFieldTypeString", "alias" : "c_service", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_billcode", "type" : "esriFieldTypeString", "alias" : "c_billcode", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_cycle", "type" : "esriFieldTypeString", "alias" : "c_cycle", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "exp", "type" : "esriFieldTypeString", "alias" : "exp", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_structuretype1", "type" : "esriFieldTypeString", "alias" : "c_structuretype1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_accountstatus1", "type" : "esriFieldTypeString", "alias" : "c_accountstatus1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_streetprefix1", "type" : "esriFieldTypeString", "alias" : "c_streetprefix1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_streetsuffix1", "type" : "esriFieldTypeString", "alias" : "c_streetsuffix1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_prov1", "type" : "esriFieldTypeString", "alias" : "c_prov1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_service1", "type" : "esriFieldTypeString", "alias" : "c_service1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_billcode1", "type" : "esriFieldTypeString", "alias" : "c_billcode1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "c_cycle1", "type" : "esriFieldTypeString", "alias" : "c_cycle1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Number_of_Units___multi_family_", "type" : "esriFieldTypeInteger", "alias" : "Number of Units \n(multi-family only)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "F1st_Survey_Form_Request_Date", "type" : "esriFieldTypeString", "alias" : "1st Survey Form Request Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "F2nd_Survey_Form_Request_Date", "type" : "esriFieldTypeDate", "alias" : "2nd Survey Form Request Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Date_Survey_Completed", "type" : "esriFieldTypeString", "alias" : "Date Survey Completed", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Survey_Completed_By", "type" : "esriFieldTypeString", "alias" : "Survey Completed By", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Bldg_No_", "type" : "esriFieldTypeString", "alias" : "Bldg No.", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Type_of_Business", "type" : "esriFieldTypeString", "alias" : "Type of Business", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Bldg_Type", "type" : "esriFieldTypeString", "alias" : "Bldg\nType", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Total_Number_of_Cross_Connectio", "type" : "esriFieldTypeInteger", "alias" : "Total Number of Cross-Connections", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Number_of_Backflow_Devices_at_P", "type" : "esriFieldTypeInteger", "alias" : "Number of Backflow Devices at Property", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Number_of_Uncontrolled_Cross_Co", "type" : "esriFieldTypeInteger", "alias" : "Number of Uncontrolled Cross Connections", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "BSI_Record_No__of_BF_Devices_at", "type" : "esriFieldTypeInteger", "alias" : "BSI Record No. of BF Devices at Property", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Type_of_BF_Device_in_BSI", "type" : "esriFieldTypeString", "alias" : "Type of BF Device in BSI", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Survey_Inspection_Report_Data", "type" : "esriFieldTypeString", "alias" : "Survey/Inspection Report Data ", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Description_of_Uncontrolled_Cro", "type" : "esriFieldTypeString", "alias" : "Description of Uncontrolled Cross Connections", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Contained_Isolated_No_Hazard", "type" : "esriFieldTypeString", "alias" : "Contained/Isolated/No Hazard", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Date_Uncontrolled_CC_Confirmed", "type" : "esriFieldTypeString", "alias" : "Date Uncontrolled CC Confirmed", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Number_of_Backflow_Methods_at_P", "type" : "esriFieldTypeString", "alias" : "Number of Backflow Methods at Property (ex. air gap, vac breaker, rpv)", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Date_Methods_Inpected__if_appli", "type" : "esriFieldTypeString", "alias" : "Date Methods Inpected (if applicable)", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "COE___Uncontrolled_XX_Risk_Leve", "type" : "esriFieldTypeInteger", "alias" : "COE - Uncontrolled XX Risk Level (None 0, Low 1, Med 2 , High 3)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Date_Risk_Level_Categorized", "type" : "esriFieldTypeDate", "alias" : "Date Risk Level Categorized", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Date_Customer_Informed_of_Uncon", "type" : "esriFieldTypeString", "alias" : "Date Customer Informed of Uncontrolled CC", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Actively_Addressing_Uncontrolle", "type" : "esriFieldTypeString", "alias" : "Actively Addressing Uncontrolled CC", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Resolution_Due_Date__Per_State_", "type" : "esriFieldTypeDate", "alias" : "Resolution Due Date \nPer State Extension", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Date_Uncontroled_CC_Resolved", "type" : "esriFieldTypeString", "alias" : "Date Uncontroled CC Resolved", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Days_Until_Controlled", "type" : "esriFieldTypeInteger", "alias" : "Days Until Controlled", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Date_Survey_Completed____In_Com", "type" : "esriFieldTypeDate", "alias" : "Date Survey Completed \n& In Compliance", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Comments", "type" : "esriFieldTypeString", "alias" : "Comments", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Resolution_Due_Date_Required_by", "type" : "esriFieldTypeString", "alias" : "Resolution Due Date Required by COE in Correspondence ", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GIS_Service_Line_ID", "type" : "esriFieldTypeString", "alias" : "GIS Service Line ID", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Follow_Up_Inspections_BSI", "type" : "esriFieldTypeString", "alias" : "Follow Up Inspections BSI", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Inspection_Phase", "type" : "esriFieldTypeString", "alias" : "Inspection Phase ", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Jody_Comments_on_Emails_During_", "type" : "esriFieldTypeString", "alias" : "Jody Comments on Emails During Inspections", "sqlType" : "sqlTypeOther", "length" : 377, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Latitude", "type" : "esriFieldTypeDouble", "alias" : "Latitude", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Longitude", "type" : "esriFieldTypeDouble", "alias" : "Longitude", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__BPCCCP_D__F4B70D85677E3479", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "BPCCCP_Inactives_Shutoffs", "description" : "", "drawingTool" : "esriFeatureEditToolNone", "prototype" : { "attributes" : { "Latitude" : null, "Longitude" : null, "c_account__billing_" : null, "BUSINESS_NAME__CIS_" : null, "Updated_Business_Names" : null, "Service_Address__Text_" : null, "Address__Concat_" : null, "Primary_Contact" : null, "Primary_Email" : null, "Primary_Phone_Number" : null, "Owner_Name" : null, "Owner_Email" : null, "Owner_Phone_Number" : null, "Owner_Address" : null, "Property_Manager" : null, "PM_Email" : null, "Property_Manager_Phone" : null, "PM_Mailing_Address" : null, "c_streetnum" : null, "c_streetprefix" : null, "c_street" : null, "c_streetsuffix" : null, "c_town" : null, "c_prov" : null, "c_postcode" : null, "c_service" : null, "c_billcode" : null, "c_cycle" : null, "exp" : null, "c_structuretype1" : null, "c_accountstatus1" : null, "c_streetprefix1" : null, "c_streetsuffix1" : null, "c_prov1" : null, "c_service1" : null, "c_billcode1" : null, "c_cycle1" : null, "Number_of_Units___multi_family_" : null, "F1st_Survey_Form_Request_Date" : null, "F2nd_Survey_Form_Request_Date" : null, "Date_Survey_Completed" : null, "Survey_Completed_By" : null, "Bldg_No_" : null, "Type_of_Business" : null, "Bldg_Type" : null, "Total_Number_of_Cross_Connectio" : null, "Number_of_Backflow_Devices_at_P" : null, "Number_of_Uncontrolled_Cross_Co" : null, "BSI_Record_No__of_BF_Devices_at" : null, "Type_of_BF_Device_in_BSI" : null, "Survey_Inspection_Report_Data" : null, "Description_of_Uncontrolled_Cro" : null, "Contained_Isolated_No_Hazard" : null, "Date_Uncontrolled_CC_Confirmed" : null, "Number_of_Backflow_Methods_at_P" : null, "Date_Methods_Inpected__if_appli" : null, "COE___Uncontrolled_XX_Risk_Leve" : null, "Date_Risk_Level_Categorized" : null, "Date_Customer_Informed_of_Uncon" : null, "Actively_Addressing_Uncontrolle" : null, "Resolution_Due_Date__Per_State_" : null, "Date_Uncontroled_CC_Resolved" : null, "Days_Until_Controlled" : null, "Date_Survey_Completed____In_Com" : null, "Comments" : null, "Resolution_Due_Date_Required_by" : null, "GIS_Service_Line_ID" : null, "Follow_Up_Inspections_BSI" : null, "Inspection_Phase" : null, "Jody_Comments_on_Emails_During_" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 32000, "maxIdsCount" : 1000000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" } ] }