{ "layers" : [ { "currentVersion" : 12, "id" : 0, "name" : "Scheduled Disconnects", "inDedicatedHosting" : true, "preferredHost" : "p3eplmys2rvchkjx.svcs.arcgis.com", "type" : "Feature Layer", "serviceItemId" : "918a31f64a824f3f8f77fec904fb3cfb", "cacheMaxAge" : 30, "displayField" : "CUSTNAME", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : null }, "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" : -9815877.45538149, "ymin" : 5125727.41051157, "xmax" : -9810253.06804802, "ymax" : 5130533.04746822, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"745170b1fc27452f220013720fc9e487","imageData":"iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAA3dJREFUWIXtlVtoFFcYx3+7m+5IsyybXQluUTZpA0qKxiAoFcFVUkoKBVsKUqkKWn1pQUErLfF+qU+iYr0gFpRC6YOlFVFMapuARnwQog8+iNGopE1i4mzZy8yeMTvHh8ludnV3ZnOrL34wzJmZP9/3O+f8zzcVvOaoeAMwRXnleSXI50IFcE0GgMwb2yYE6F0bJh2H60Nhllzrs9U6AgSDwfm3mxXSSUhrMO9P+4SKokTlMJgm+DxO2csAUFW1q6oqwr9JAzJWASFERym9EKL92bY2zEyGxsYGgqHQfFVVb48bIBvShEC1VQCHbXjv3Rru33+Qm4CdviwA37FHaF13mN3YAL86WgCfz1dO2vIB+voHyk441nAE2L/1a/r7+stOePbDIL1fvoMyBE/D3okDfLxqQ8Hz6TM/sfGr9SX1zQ1zSPX0IIHBPoND21vYsv/AuAF6Qr9s5tmqIwCosRj1P35rp49V/dDBNF1nmqaT1tM0JZMwAYAaz8A9/Pua0TV4lAD5HLAaUzE3BkrkKaV33gJpWk0FE8wMyGF7/dP1EbQ4aAnQVEjFhK3eESB05iHptEDXdQxhoOk61M+xBc5dFPbwMQNEo1E8brcTYy4WhxWkHC0sEZgTAfjr0gXcXi8pTc+9q66ezkeRCK2PH7+iv/BJEC1uzZ7MiF8MmA3cGwfA74PfzKOyEgZ6DNIpEAmY/oGXTUaC1pfEiqIcNjN5yz/iFxM4qAT5TKjtwLKxAKyQErTU6H6aGetDkX0NHD9xarO8sRspDcu4FHrg6t8d0abl0VdOg+0WSAy0ZN6SFn6OAVXZcU1NLfJanvky1pWN/hLt3B5AjhQnCyAAL9I6WYVn3gV315xjcHCIf3p70XSdtyoqmDlrFuEZM/CX+Ic5rMDoXWKZ6ubFRDHpH03Loyvq6uro7u4GYM/eA3z/ndU1FUVh3bri7bsUQPvQxgi6buRMlW1CL53trLE+BXLFAXbtbMmNhRCcPHmibIDYlbarAXl+NeQ1k/zCJtB29Djuue8XNdZYohhAwOPxWMWl1YbzzcQISHLbDty//TzeurYAuFwuLi89hLjVxtJUqzX7YWEdRQNurfyC2kULibxdOTUAndc78fv9ULuAy7ULAIjH49Y7IATE/4vT+aRzSgBcu3a2OP1DCvSTDTDhpJMB8L/Fawd4ARyWf2eWhxGbAAAAAElFTkSuQmCC","contentType":"image/png","width":24,"height":24,"angle":0,"xoffset":0,"yoffset":0},"label":"","description":""},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "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" : "METERID", "type" : "esriFieldTypeString", "alias" : "Meter ID\n", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ACCOUNTID", "type" : "esriFieldTypeString", "alias" : "Account ID\n", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CUSTNAME", "type" : "esriFieldTypeString", "alias" : "Customer name", "sqlType" : "sqlTypeOther", "length" : 80, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "BILLADDR", "type" : "esriFieldTypeString", "alias" : "Billing address", "sqlType" : "sqlTypeOther", "length" : 125, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LOCADDR", "type" : "esriFieldTypeString", "alias" : "Address", "sqlType" : "sqlTypeOther", "length" : 125, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DISREASON", "type" : "esriFieldTypeString", "alias" : "Reason for disconnect:", "sqlType" : "sqlTypeOther", "length" : 80, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wDisconnectReason", "codedValues" : [ { "name" : "Unauthorized Connection", "code" : "Unauthorized Connection" }, { "name" : "Delinquent Account", "code" : "Delinquent Account" }, { "name" : "Unpaid Bill - Previous Address", "code" : "Unpaid Bill - Previous Address" }, { "name" : "Denied Utility Access", "code" : "Denied Utility Access" }, { "name" : "Unsafe Condition", "code" : "Unsafe Condition" } ] }, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__Customer__F4B70D85B90621D8", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" }, { "name" : "dbo.Customer_Information_Scheduled_Disconnects_Shape_sidx", "fields" : "Shape", "isAscending" : false, "isUnique" : false, "description" : "Shape Index", "indexType" : "Spatial" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Scheduled Disconnects", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "DISREASON" : null, "METERID" : null, "ACCOUNTID" : null, "CUSTNAME" : null, "BILLADDR" : null, "LOCADDR" : 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" : true, "maxRecordCount" : 1000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 1, "name" : "Delinquent Accounts", "inDedicatedHosting" : true, "preferredHost" : "p3eplmys2rvchkjx.svcs.arcgis.com", "type" : "Feature Layer", "serviceItemId" : "918a31f64a824f3f8f77fec904fb3cfb", "cacheMaxAge" : 30, "displayField" : "CUSTNAME", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : null }, "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" : -9816379.24855734, "ymin" : 5125718.65786158, "xmax" : -9809846.02532278, "ymax" : 5130553.15797524, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"42beef08d0c8af0234fb578f22b36226","imageData":"iVBORw0KGgoAAAANSUhEUgAAABoAAAAaCAYAAACpSkzOAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAlhJREFUSIntls9r02AYxz9NuzetGbg5h83EvUN60A6RiOBRQQQvA3fx5smrZy+OucPwfxBvstMuQTyK+B84hhAvAxt/LDusOt3q0iR96yFNtWvXxINDweeSB95838/7ffjyJgWOqAr/QUcCktL84thiDKA6H+C6Xu6PgIojjCX9y8dQuZldmxkkpdl+vSooTO7iTzUw18tIabazusoMcmwBgH8CAi0WOrbAuJRNnwkkpdkG2D+/BUDOh6+Wy/E1mdlVKqhSqVxbXw0BmCj6PWvBbBHHLlOdT4elgsKw8QoE27Mu08DMzBQAtdomn0STU8Dpk+C6w/cZCpLSbDu2wLfu0lSLfeuRgg+Wy4snMtXVUNCje/FzJ1gkGvBmBOhB3KcF41CQlGb71nVB3boCgYumDQZpxK7OpATjUFAS5xH/GaEGSnV2PSAeAYqB3tVcvG0ubWx4S5lASZy3rXMIf4sCOmHUBNEvLgCaiqNfelsmDHkIpIOkNN85tkCbGAeK6MoAGl03tdrmT3EEmtLRFIiWwY7l4tiDgzHI0QzA5+kbjNdXaJdAVwDxeH6Nd6kDKWJAS8d4LwF4uiy4emeIoyTOu9YDNOqohkDLQyE/4DiArgzyQC7QUd8FKoLW7BaX6b8He0BJAHKUyDGJioBvAs3owI4dGF2gQwtUI4YARB/L5OmPexdkmuaFpB9dW2DPWiY8u9zjYJ8VAEr1+6gmEAlQnUQmLvd6JvTcdb25HpDneW+q82bX1ejawuB5ASA4ZJrd6nwY5/ocAbiul8t67f9u/Z3/DP8E6AfWYuYw+bg2FwAAAABJRU5ErkJggg==","contentType":"image/png","width":19,"height":19,"angle":0,"xoffset":0,"yoffset":0},"label":"","description":""},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "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" : "METERID", "type" : "esriFieldTypeString", "alias" : "Meter ID\n", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ACCOUNTID", "type" : "esriFieldTypeString", "alias" : "Account ID\n", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CUSTNAME", "type" : "esriFieldTypeString", "alias" : "Customer name", "sqlType" : "sqlTypeOther", "length" : 80, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "BILLADDR", "type" : "esriFieldTypeString", "alias" : "Billing address", "sqlType" : "sqlTypeOther", "length" : 125, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LOCADDR", "type" : "esriFieldTypeString", "alias" : "Address", "sqlType" : "sqlTypeOther", "length" : 125, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DAYOVERDUE", "type" : "esriFieldTypeSmallInteger", "alias" : "Days overdue", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__Customer__F4B70D853FE86644", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" }, { "name" : "dbo.Customer_Information_Delinquent_Accounts_Shape_sidx", "fields" : "Shape", "isAscending" : false, "isUnique" : false, "description" : "Shape Index", "indexType" : "Spatial" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Delinquent Accounts", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "DAYOVERDUE" : null, "METERID" : null, "ACCOUNTID" : null, "CUSTNAME" : null, "BILLADDR" : null, "LOCADDR" : 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" : true, "maxRecordCount" : 1000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 2, "name" : "Disconnected Customers", "inDedicatedHosting" : true, "preferredHost" : "p3eplmys2rvchkjx.svcs.arcgis.com", "type" : "Feature Layer", "serviceItemId" : "918a31f64a824f3f8f77fec904fb3cfb", "cacheMaxAge" : 30, "displayField" : "CUSTNAME", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : null }, "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" : -9816520.33140494, "ymin" : 5125865.35800178, "xmax" : -9809577.49580858, "ymax" : 5130546.9626359, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"a5ccb7bbfafc555833621b4fd24f0835","imageData":"iVBORw0KGgoAAAANSUhEUgAAABoAAAAaCAYAAACpSkzOAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAo5JREFUSIndlM9LVFEYhp9zZ+beHCtqIOgSLYRBI8JMsLXb2lSEOzdFSEuJFg1CTqHYQmpvi/ZJ1B/QwpUitQhrE0gNIV0SHcdfM3POvXO/FnewGceZDNRF7+5yzv2e877nO1+cI1L8vweJiKCUegfcAm4Cb2vW1UGBMMYAnAKkOOGil6G4DGYFSgXk4rwH8Am40qLuK+BOS1AQgfqLEy5tj35yrLzJya0C/toalcI6C0N3Kf/a7rnqeVILdBznhdZ6uKZUa5AfBAAzyYzXLw+22Bztorhso1ehtGpIuF2cuTfA/OMxLIeeN+TlWjrFhU44kY5qJDNeQ8QNIB05AqD0vJPjw+8pjVxHWdEF6W9fWRofA6DtUjf302eJJ7aQjY9IaGgf8fbMstHRH1AH8F3K6yjLgAXKjmCWDaGG4pcFKj8WaD8HyfMQ+nsyWkYHkEtmPIIbG1gxdhypXX9IBSohiG8jgaGZGqPTuu7bzL1ExWyUZbAsIFEFAmiQdhADEoCE/+AoMPWnkqVZUDZK2RADi13rVVciBvHt/YOMXx90ov8h5deTYNkoa48KfgQLA5DAMDWQYmg6vw9HNaCpgRT+7CQqDipmoshioBKAA1RTlgAIbUJjGOx1GJpG2DVFWt2RDPY6AKiYzdzKJn4BLsednb1CTXSBQUIb2LshGruuxtHprEeV2wHkABzHyWqtRz+4LkJUV/xqM1QiSHHCJZnx6lw1m3VVd41DVGudBbJ9ngcgo6kUtwOHEJtcwdCX8eoO1hRUc0f7mdTqST7Ps20nS44ZrfVMs40NoLJp/uiaqeqypf76jg5KLZvhUEHmqBwdCch13e6n4+Ok0+ntxcXFwwN5nvf5QKs3Ax2mfgMdHisL9VzlZAAAAABJRU5ErkJggg==","contentType":"image/png","width":19,"height":19,"angle":0,"xoffset":0,"yoffset":0},"label":"","description":""},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "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" : "METERID", "type" : "esriFieldTypeString", "alias" : "Meter ID\n", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ACCOUNTID", "type" : "esriFieldTypeString", "alias" : "Account ID\n", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CUSTNAME", "type" : "esriFieldTypeString", "alias" : "Customer Name\n", "sqlType" : "sqlTypeOther", "length" : 80, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "BILLADDR", "type" : "esriFieldTypeString", "alias" : "Billing Address\n", "sqlType" : "sqlTypeOther", "length" : 125, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LOCADDR", "type" : "esriFieldTypeString", "alias" : "Address", "sqlType" : "sqlTypeOther", "length" : 125, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DATEDISC", "type" : "esriFieldTypeDate", "alias" : "Date Disconnected", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "DISREASON", "type" : "esriFieldTypeString", "alias" : "Reason for disconnect:", "sqlType" : "sqlTypeOther", "length" : 80, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wDisconnectReason", "codedValues" : [ { "name" : "Unauthorized Connection", "code" : "Unauthorized Connection" }, { "name" : "Delinquent Account", "code" : "Delinquent Account" }, { "name" : "Unpaid Bill - Previous Address", "code" : "Unpaid Bill - Previous Address" }, { "name" : "Denied Utility Access", "code" : "Denied Utility Access" }, { "name" : "Unsafe Condition", "code" : "Unsafe Condition" } ] }, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__Customer__F4B70D85FD1D0C07", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" }, { "name" : "dbo.Customer_Information_Disconnected_Customers_Shape_sidx", "fields" : "Shape", "isAscending" : false, "isUnique" : false, "description" : "Shape Index", "indexType" : "Spatial" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Disconnected Customers", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "DISREASON" : null, "METERID" : null, "ACCOUNTID" : null, "CUSTNAME" : null, "BILLADDR" : null, "LOCADDR" : null, "DATEDISC" : 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" : true, "maxRecordCount" : 1000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" } ], "tables" : [] }