{ "preferredTimeReference": null, "useStandardizedQueries": true, "maxRecordCount": 2000, "description": null, "datesInUnknownTimezone": false, "type": "Table", "subtypes": [], "relationships": [{ "keyField": "rel_meter_guid", "role": "esriRelRoleDestination", "catalogID": "{6FD9D841-4E25-4677-86CB-56F4C41688F7}", "composite": false, "name": "DBO.rel_building_meters", "relatedTableId": 1, "id": 1, "cardinality": "esriRelCardinalityOneToMany" }], "indexes": [ { "name": "R379_SDE_ROWID_UK", "isUnique": true, "description": "", "fields": "OBJECTID", "isAscending": true }, { "name": "GDB_1023_rel_meter_guid", "isUnique": false, "description": "", "fields": "rel_meter_guid", "isAscending": true } ], "htmlPopupType": "esriServerHTMLPopupTypeNone", "cimVersion": "3.6.0", "isDataArchived": false, "id": 2, "archivingInfo": { "startArchivingMoment": -1, "supportsQueryWithHistoricMoment": false }, "hasAttachments": false, "advancedQueryCapabilities": { "supportsStatistics": true, "supportsSqlExpression": true, "supportsTrueCurve": false, "supportsOrderBy": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "useStandardizedQueries": true, "supportsQueryWithDistance": true, "supportsCountDistinct": true, "supportsCurrentUserQueries": true, "supportsAdvancedQueryRelated": true, "supportsReturningQueryExtent": true, "supportsPagination": true, "supportsDistinct": true, "supportsTimeRelation": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": null, "subtypeFieldName": null, "supportsStatistics": true, "serviceItemId": "a86f04cf0c9f4e82b54999cc7596adec", "capabilities": "Map,Query,Data", "supportsExceedsLimitStatistics": true, "isDataVersioned": false, "supportsAdvancedQueries": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": true }, "hasMetadata": true, "currentVersion": 12, "typeIdField": null, "defaultSubtypeCode": null, "supportedQueryFormats": "JSON, PBF", "name": "Gas and Electric Meter Readings", "displayField": "OBJECTID", "copyrightText": null, "fields": [ { "nullable": false, "domain": null, "name": "OBJECTID", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "domain": null, "name": "BuildingName", "length": 255, "alias": "BuildingName", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "AccountNumber", "length": 255, "alias": "AccountNumber", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "MeterNumber", "length": 255, "alias": "MeterNumber", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "ReadingType", "length": 255, "alias": "ReadingType", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "CurrentReading", "length": 255, "alias": "CurrentReading", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "PreviousReading", "length": 255, "alias": "PreviousReading", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "CurrentReadingDate", "length": 8, "alias": "CurrentReadingDate", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "PreviousReadingDate", "length": 8, "alias": "PreviousReadingDate", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "Consumption", "length": 255, "alias": "Consumption", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "AdjustedConsumption", "length": 255, "alias": "AdjustedConsumption", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "UnitOfMeasure", "length": 255, "alias": "UnitOfMeasure", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "rel_meter_guid", "length": 38, "alias": "rel_meter_guid", "type": "esriFieldTypeGUID" }, { "nullable": true, "domain": null, "name": "UTConsumptionDetailID", "alias": "UTConsumptionDetailID", "type": "esriFieldTypeInteger" }, { "nullable": true, "domain": null, "name": "UTConsumptionHeaderID", "alias": "UTConsumptionHeaderID", "type": "esriFieldTypeInteger" }, { "nullable": true, "domain": null, "name": "id", "alias": "id", "type": "esriFieldTypeInteger" } ], "dateFieldsTimeReference": null }