{ "layers": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 0, "name": "Water Meter by Account Service Address", "type": "Feature Layer", "description": "The service addresses from the City's Utility Billing system listing report (UBL300) was geocoded. Account Number and service address were retained. UB_AccountType, a custom field, contains a code that indicates if it is residential, commercial or tax-exempt, was added. Other information about the meter itself can be found in the water meters layer.", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102685, "latestWkid": 2248, "vcsWkid": 5703, "latestVcsWkid": 5703, "xyTolerance": 0.0032808333333333335, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -120561100, "falseY": -95444400, "xyUnits": 3048.0060960121914, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "sourceHeightModelInfo": { "heightModel": "gravity_related_height", "vertCRS": "NAVD_1988", "heightUnit": "meter" }, "copyrightText": "City of Rockville", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "ub_customer_class", "uniqueValueInfos": [ { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 178, 178, 178, 255 ], "size": 10, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 225, 225, 225, 255 ], "width": 1 } }, "value": "", "label": "" }, { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 255, 167, 127, 255 ], "size": 10, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 225, 225, 225, 255 ], "width": 1 } }, "value": "Multi-Family", "label": "Multi-Family" }, { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 255, 115, 223, 255 ], "size": 10, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 225, 225, 225, 255 ], "width": 1 } }, "value": "Non-Residential", "label": "Non-Residential" }, { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 163, 255, 115, 255 ], "size": 10, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 225, 225, 225, 255 ], "width": 1 } }, "value": "Single Family", "label": "Single Family" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 139, 163, 51, 255 ], "toColor": [ 139, 163, 51, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 114, 45, 161, 255 ], "toColor": [ 114, 45, 161, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 189, 40, 60, 255 ], "toColor": [ 189, 40, 60, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 50, 153, 179, 255 ], "toColor": [ 50, 153, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 53, 196, 137, 255 ], "toColor": [ 53, 196, 137, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 163, 111, 59, 255 ], "toColor": [ 163, 111, 59, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 41, 101, 196, 255 ], "toColor": [ 41, 101, 196, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 194, 58, 128, 255 ], "toColor": [ 194, 58, 128, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 67, 184, 59, 255 ], "toColor": [ 67, 184, 59, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 40, 62, 189, 255 ], "toColor": [ 40, 62, 189, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 194, 58, 192, 255 ], "toColor": [ 194, 58, 192, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 196, 157, 47, 255 ], "toColor": [ 196, 157, 47, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 156, 61, 83, 255 ], "toColor": [ 156, 61, 83, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -120561100, "ymin": -95444400, "xmax": 1279867.742117852, "ymax": 525402.490457356, "spatialReference": { "wkid": 102685, "latestWkid": 2248, "xyTolerance": 0.003280833333333333, "zTolerance": 2, "mTolerance": 0.001, "falseX": -1.266531483871059E8, "falseY": -1.0024289012452286E8, "xyUnits": 3.605202196410561E7, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "Service_Address", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "Service_Address", "type": "esriFieldTypeString", "alias": "Service Address", "length": 255, "domain": null }, { "name": "ACCOUNT", "type": "esriFieldTypeString", "alias": "Account Number", "length": 11, "domain": null }, { "name": "UB_ACCT_TYPE", "type": "esriFieldTypeString", "alias": "Account Type", "length": 1, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "ub_customer_type", "type": "esriFieldTypeString", "alias": "UB Customer Type", "length": 50, "domain": null }, { "name": "ub_customer_class", "type": "esriFieldTypeString", "alias": "UB Customer Class", "length": 50, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "Enabled", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "EnabledDomain", "description": "", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 10, "domain": { "type": "codedValue", "name": "Watermeter Account Status", "description": "Status of water meter account", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "InActive", "code": "InActive" }, { "name": "Retired", "code": "Retired" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 100, "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R1729_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_19557_ACCOUN", "fields": "ACCOUNT", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S1264_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Have Rolling Averages", "relatedTableId": 1, "role": "esriRelRoleOrigin", "keyField": "ACCOUNT", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": false, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 20000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true } ], "tables": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 1, "name": "RockGIS.DPWUTIL.water_MeterConsumptionData_w_RollingAverages", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AvgDailyUsg", "type": "esriFieldTypeDouble", "alias": "AvgDailyUsg", "domain": null }, { "name": "AvgDailyUsg_4R", "type": "esriFieldTypeDouble", "alias": "AvgDailyUsg_4R", "domain": null }, { "name": "AvgDailyUsg_12R", "type": "esriFieldTypeDouble", "alias": "AvgDailyUsg_12R", "domain": null }, { "name": "AccountNo", "type": "esriFieldTypeString", "alias": "AccountNo", "length": 20, "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 255, "domain": null }, { "name": "ServiceAddress", "type": "esriFieldTypeString", "alias": "ServiceAddress", "length": 255, "domain": null }, { "name": "MeterNo", "type": "esriFieldTypeString", "alias": "MeterNo", "length": 20, "domain": null }, { "name": "BilCd", "type": "esriFieldTypeString", "alias": "BilCd", "length": 10, "domain": null }, { "name": "ReadDate", "type": "esriFieldTypeDate", "alias": "ReadDate", "length": 8, "domain": null }, { "name": "Usage", "type": "esriFieldTypeInteger", "alias": "Usage", "domain": null }, { "name": "Days", "type": "esriFieldTypeInteger", "alias": "Days", "domain": null }, { "name": "Per", "type": "esriFieldTypeString", "alias": "Per", "length": 10, "domain": null } ], "indexes": [ { "name": "R1602_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_16217_Accoun", "fields": "AccountNo", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Rolling Averages By Account", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "AccountNo", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 20000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } } ] }