{ "tables": [ { "preferredTimeReference": null, "useStandardizedQueries": true, "maxRecordCount": 2000, "description": null, "datesInUnknownTimezone": false, "type": "Table", "subtypes": [], "relationships": [ { "keyField": "GlobalID", "role": "esriRelRoleOrigin", "catalogID": "{6FD9D841-4E25-4677-86CB-56F4C41688F7}", "composite": false, "name": "DBO.MeterReadings", "relatedTableId": 2, "id": 1, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "rel_building_guid", "role": "esriRelRoleDestination", "catalogID": "{D1793FD6-612E-416E-9BDA-5B4908E21565}", "composite": false, "name": "DBO.CityBuilds_Energy", "relatedTableId": 0, "id": 0, "cardinality": "esriRelCardinalityOneToMany" } ], "indexes": [ { "name": "R378_SDE_ROWID_UK", "isUnique": true, "description": "", "fields": "OBJECTID", "isAscending": true }, { "name": "UUID_378", "isUnique": true, "description": "", "fields": "GlobalID", "isAscending": true }, { "name": "GDB_1022_rel_building_guid", "isUnique": false, "description": "", "fields": "rel_building_guid", "isAscending": true } ], "htmlPopupType": "esriServerHTMLPopupTypeNone", "cimVersion": "3.6.0", "isDataArchived": false, "id": 1, "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": "Related Building Meters", "displayField": "OBJECTID", "copyrightText": null, "fields": [ { "nullable": false, "domain": null, "name": "OBJECTID", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "domain": null, "name": "MeterNumber", "length": 255, "alias": "MeterNumber", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "MeterType", "length": 255, "alias": "MeterType", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "rel_building_guid", "length": 38, "alias": "rel_building_guid", "type": "esriFieldTypeGUID" }, { "nullable": true, "domain": null, "name": "rel_reading_guid", "alias": "rel_reading_guid", "type": "esriFieldTypeInteger" }, { "nullable": false, "domain": null, "name": "GlobalID", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" } ], "dateFieldsTimeReference": null }, { "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 } ], "layers": [{ "extent": { "ymin": 550533.9599994719, "zmin": 0, "xmin": 1629130.4958713055, "ymax": 662069.12931714952, "zmax": 0, "xmax": 1711128.3200643063, "spatialReference": { "falseM": -100000, "xyTolerance": 0.0032808333333333331, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3734, "zTolerance": 0.001, "wkid": 102722, "xyUnits": 3048.00609601219276, "mTolerance": 0.001, "falseX": -118963900, "falseY": -96373800, "falseZ": -100000 } }, "maxRecordCount": 2000, "datesInUnknownTimezone": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "type": "Feature Layer", "maxSelectionCount": 2000, "subtypes": [], "relationships": [{ "keyField": "GlobalID", "role": "esriRelRoleOrigin", "catalogID": "{D1793FD6-612E-416E-9BDA-5B4908E21565}", "composite": false, "name": "DBO.rel_building_meters", "relatedTableId": 1, "id": 0, "cardinality": "esriRelCardinalityOneToMany" }], "cimVersion": "3.6.0", "isDataArchived": false, "id": 0, "archivingInfo": { "startArchivingMoment": -1, "supportsQueryWithHistoricMoment": false }, "spatialReference": { "falseM": -100000, "xyTolerance": 0.0032808333333333331, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3734, "zTolerance": 0.001, "wkid": 102722, "xyUnits": 3048.00609601219276, "mTolerance": 0.001, "falseX": -118963900, "falseY": -96373800, "falseZ": -100000 }, "subtypeFieldName": null, "supportsStatistics": true, "isDataVersioned": false, "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "subLayers": [], "currentVersion": 12, "referenceScale": 0, "canScaleSymbols": false, "hasZ": true, "name": "City Buildings", "displayField": "OBJECTID", "fields": [ { "nullable": false, "domain": null, "name": "OBJECTID", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "domain": null, "name": "SHAPE", "alias": "SHAPE", "type": "esriFieldTypeGeometry" }, { "nullable": true, "domain": null, "name": "CityBuilding", "length": 255, "alias": "CityBuilding", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "Address", "length": 255, "alias": "Address", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "BuildDate", "length": 8, "alias": "BuildDate", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "Remodel", "length": 255, "alias": "Remodel", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "SquareFoot", "length": 255, "alias": "SquareFoot", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "TrackElectric", "length": 255, "alias": "TrackElectric", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "TrackGas", "length": 255, "alias": "TrackGas", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "WRTracking", "length": 255, "alias": "WRTracking", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "TrackCO", "length": 255, "alias": "TrackCO", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "Plans", "length": 255, "alias": "Plans", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "PDF", "length": 255, "alias": "PDF", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "WRUpload", "length": 255, "alias": "WRUpload", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "BuildingID", "alias": "BuildingID", "type": "esriFieldTypeSmallInteger" }, { "nullable": false, "domain": null, "name": "GlobalID", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" }, { "nullable": true, "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "created_date", "length": 8, "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "last_edited_date", "length": 8, "alias": "last_edited_date", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "SHAPE.STArea()", "alias": "Shape.STArea()", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "SHAPE.STLength()", "alias": "Shape.STLength()", "type": "esriFieldTypeDouble" } ], "dateFieldsTimeReference": null, "preferredTimeReference": null, "useStandardizedQueries": true, "sourceSpatialReference": { "falseM": 0, "xyTolerance": 0.0032808333333333331, "mUnits": 1, "zUnits": 10000, "latestWkid": 3734, "zTolerance": 0.001, "wkid": 102722, "xyUnits": 3048.00609601219276, "mTolerance": 0.001, "falseX": -118963900, "falseY": -96373800, "falseZ": -100000 }, "description": "", "canModifyLayer": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "geometryProperties": { "shapeAreaFieldName": "SHAPE.STArea()", "shapeLengthFieldName": "SHAPE.STLength()", "units": "esriFeet", "mapUnits": {"uwkid": 9003} }, "indexes": [ { "name": "R381_pk", "isUnique": true, "description": "", "fields": "OBJECTID", "isAscending": true }, { "name": "UUID_381", "isUnique": true, "description": "", "fields": "GlobalID", "isAscending": true }, { "name": "S334_idx", "isUnique": true, "description": "", "fields": "SHAPE", "isAscending": true } ], "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "supportsDatumTransformation": true, "minScale": 0, "supportsDynamicLegends": true, "hasAttachments": false, "advancedQueryCapabilities": { "supportsStatistics": true, "supportsSqlExpression": true, "supportsTrueCurve": true, "supportsOrderBy": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "useStandardizedQueries": true, "supportsLod": false, "supportsQueryWithDistance": true, "supportsQueryWithDatumTransformation": true, "supportsCountDistinct": true, "supportsCurrentUserQueries": true, "supportsAdvancedQueryRelated": true, "supportsReturningQueryExtent": true, "supportsQueryWithLodSR": false, "supportsPagination": true, "supportsDistinct": true, "supportsTimeRelation": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": null, "serviceItemId": "a86f04cf0c9f4e82b54999cc7596adec", "supportsCoordinatesQuantization": true, "capabilities": "Map,Query,Data", "maxScale": 0, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": true }, "hasMetadata": true, "typeIdField": null, "defaultSubtypeCode": null, "supportedQueryFormats": "JSON, geoJSON, PBF", "hasLabels": false, "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 110, 110, 110, 255 ], "width": 0.69999999999999996, "style": "esriSLSSolid", "type": "esriSLS" }, "color": [ 212, 252, 234, 255 ], "style": "esriSFSSolid", "type": "esriSFS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "name": "SHAPE", "alias": "SHAPE", "type": "esriFieldTypeGeometry" }, "copyrightText": "", "geometryType": "esriGeometryPolygon" }] }