{
 "isCoGoEnabled": false,
 "isDataBranchVersioned": false,
 "supportsApplyEditsWithGlobalIds": true,
 "maxRecordCount": 2000,
 "infoInEstimates": [
  "extent",
  "count"
 ],
 "type": "Table",
 "supportsAttachmentsByUploadId": true,
 "relationships": [
  {
   "keyField": "buildingid",
   "role": "esriRelRoleDestination",
   "composite": false,
   "name": "BenchmarkingDSMBuilding",
   "relatedTableId": 0,
   "id": 0,
   "cardinality": "esriRelCardinalityOneToOne"
  }
 ],
 "hasViews": false,
 "supportsAttachmentsResizing": true,
 "cimVersion": "2.3.0",
 "isDataArchived": false,
 "id": 2,
 "supportsStatistics": true,
 "supportedExportFormats": "sqlite,filegdb",
 "standardMaxRecordCount": 16000,
 "isDataVersioned": false,
 "templates": [
  {
   "name": "BenchmarkingDSMEnergyReport",
   "description": "",
   "drawingTool": "esriFeatureEditToolNone",
   "prototype": {
    "attributes": {
     "weathernormalizedsitenaturalgas": null,
     "propertynotes": null,
     "occupancy": null,
     "wateruseintensity": null,
     "remark": null,
     "energystarscore": null,
     "siteenergy": null,
     "electricityuse": null,
     "thirdlargestpropertyusetype_gro": null,
     "buildingid": null,
     "wateruse": null,
     "propertygfa_selfreported": null,
     "propertygfa_epacalculated_build": null,
     "thirdlargestpropertyusetype": null,
     "last_edited_date": null,
     "weathernormalizedsiteeui": null,
     "reportyear": null,
     "totalghgemissions": null,
     "waterscore": null,
     "propertygfa_epacalculated_parki": null,
     "numberofbuildings": null,
     "pkid": null,
     "propertyname": null,
     "created_user": null,
     "property_data_administrator_ema": null,
     "secondlargestpropertyusetype": null,
     "secondlargestpropertyusetype_gr": null,
     "largestpropertyusetype": null,
     "weathernormalizedsiteenergyuse": null,
     "extlid": null,
     "yearbuilt": null,
     "parentpropertyname": null,
     "last_edited_user": null,
     "propertydataadministrator": null,
     "dataowner": null,
     "primarypropertytype": null,
     "siteeui": null,
     "energystarcertlength": null,
     "created_date": null,
     "energystarcertified": null,
     "naturalgasuse": null,
     "propertyaddress": null,
     "largestpropertyusetype_grossflo": null
    }
   }
  }
 ],
 "supportsAdvancedQueries": true,
 "currentVersion": 10.91,
 "objectIdField": "objectid",
 "supportsQuantizationEditMode": true,
 "name": "BenchmarkingDSMEnergyReport",
 "displayField": "propertyname",
 "supportsCalculate": true,
 "fields": [
  {
   "nullable": false,
   "editable": false,
   "defaultValue": null,
   "domain": null,
   "name": "objectid",
   "alias": "OBJECTID",
   "type": "esriFieldTypeOID"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "buildingid",
   "length": 256,
   "alias": "Des Moines Building ID",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "reportyear",
   "length": 128,
   "alias": "Report Year",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "yearbuilt",
   "alias": "Year Built",
   "type": "esriFieldTypeSmallInteger"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "propertyaddress",
   "length": 256,
   "alias": "Property Address",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "occupancy",
   "length": 256,
   "alias": "Occupancy",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "primarypropertytype",
   "length": 256,
   "alias": "Primary Property Type",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "numberofbuildings",
   "alias": "Number of Buildings",
   "type": "esriFieldTypeSmallInteger"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "propertydataadministrator",
   "length": 256,
   "alias": "Property Data Administrator",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "property_data_administrator_ema",
   "length": 256,
   "alias": "Property Data Administrator Email",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "energystarcertified",
   "length": 256,
   "alias": "Energy Star Certified",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "propertyname",
   "length": 256,
   "alias": "Property Name",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "parentpropertyname",
   "length": 256,
   "alias": "Parent Property Name",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "propertygfa_selfreported",
   "alias": "Property GFA - Self Reported SqFt",
   "type": "esriFieldTypeDouble"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "propertygfa_epacalculated_build",
   "alias": "Property GFA - EPA Calculated (Buildings) SqFt",
   "type": "esriFieldTypeDouble"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "propertygfa_epacalculated_parki",
   "alias": "Property GFA - EPA Calculated (Parking) SqFt",
   "type": "esriFieldTypeDouble"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "largestpropertyusetype",
   "length": 256,
   "alias": "Largest Property Use Type",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "largestpropertyusetype_grossflo",
   "alias": "Largest Property Use Type - Gross Floor Area SqFt",
   "type": "esriFieldTypeDouble"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "secondlargestpropertyusetype",
   "length": 256,
   "alias": "2nd Largest Property Use Type",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "secondlargestpropertyusetype_gr",
   "alias": "2nd Largest Property Use Type - Gross Floor Area SqFt",
   "type": "esriFieldTypeDouble"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "thirdlargestpropertyusetype",
   "length": 256,
   "alias": "3rd Largest Property Use Type",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "thirdlargestpropertyusetype_gro",
   "alias": "3rd Largest Property Use Type - Gross Floor Area SqFt",
   "type": "esriFieldTypeDouble"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "energystarscore",
   "length": 256,
   "alias": "Energy Star Score",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "electricityuse",
   "alias": "Electricity Use (kWh)",
   "type": "esriFieldTypeDouble"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "naturalgasuse",
   "alias": "Natural Gas Use (therms)",
   "type": "esriFieldTypeDouble"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "wateruse",
   "alias": "Water Use (All Sources - Kgal)",
   "type": "esriFieldTypeDouble"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "siteenergy",
   "alias": "Site Energy Use (kBtu)",
   "type": "esriFieldTypeDouble"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "siteeui",
   "alias": "Site EUI (kBtu/ft2)",
   "type": "esriFieldTypeDouble"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "totalghgemissions",
   "alias": "Total GHG Emissions (Metric Tons CO2e)",
   "type": "esriFieldTypeDouble"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "propertynotes",
   "length": 256,
   "alias": "Property Notes",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "weathernormalizedsiteenergyuse",
   "alias": "Weather Normalized Site Energy Use (kBtu)",
   "type": "esriFieldTypeDouble"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "weathernormalizedsiteeui",
   "alias": "Weather Normalized Site EUI (kBtu/ft2)",
   "type": "esriFieldTypeDouble"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "weathernormalizedsitenaturalgas",
   "alias": "Weather Normalized Site Natural Gas Intensity (therms/ft2)",
   "type": "esriFieldTypeDouble"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "waterscore",
   "length": 256,
   "alias": "Water Score (Multi-Family only)",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "wateruseintensity",
   "alias": "Water Use Intensity (gal/ft2)",
   "type": "esriFieldTypeDouble"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "energystarcertlength",
   "alias": "Energy Star Certification - Year(s) Certified",
   "type": "esriFieldTypeSmallInteger"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "remark",
   "length": 256,
   "alias": "Remark",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "pkid",
   "alias": "PKId",
   "type": "esriFieldTypeInteger"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "dataowner",
   "length": 256,
   "alias": "DataOwner",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "extlid",
   "alias": "ExtlID",
   "type": "esriFieldTypeDouble"
  },
  {
   "nullable": false,
   "editable": false,
   "defaultValue": null,
   "domain": null,
   "name": "globalid",
   "length": 38,
   "alias": "GlobalID",
   "type": "esriFieldTypeGlobalID"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "created_user",
   "length": 255,
   "alias": "created_user",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "created_date",
   "length": 29,
   "alias": "created_date",
   "type": "esriFieldTypeDate"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "last_edited_user",
   "length": 255,
   "alias": "last_edited_user",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "last_edited_date",
   "length": 29,
   "alias": "last_edited_date",
   "type": "esriFieldTypeDate"
  }
 ],
 "maxRecordCountFactor": 1,
 "dateFieldsTimeReference": {
  "respectsDaylightSaving": false,
  "timeZone": "UTC"
 },
 "supportsFieldDescriptionProperty": true,
 "allowGeometryUpdates": true,
 "useStandardizedQueries": true,
 "globalIdField": "globalid",
 "description": "",
 "syncCanReturnChanges": true,
 "supportsAsyncDelete": true,
 "supportedSpatialRelationships": [
  "esriSpatialRelIntersects",
  "esriSpatialRelContains",
  "esriSpatialRelCrosses",
  "esriSpatialRelEnvelopeIntersects",
  "esriSpatialRelOverlaps",
  "esriSpatialRelTouches",
  "esriSpatialRelWithin",
  "esriSpatialRelRelation"
 ],
 "supportsRollbackOnFailureParameter": true,
 "indexes": [
  {
   "name": "g811buildingid",
   "isUnique": false,
   "description": "",
   "fields": "buildingid",
   "isAscending": true
  },
  {
   "name": "r269_sde_rowid_uk",
   "isUnique": true,
   "description": "",
   "fields": "objectid",
   "isAscending": true
  },
  {
   "name": "uuid_269",
   "isUnique": true,
   "description": "",
   "fields": "globalid",
   "isAscending": true
  }
 ],
 "editFieldsInfo": {
  "editDateField": "last_edited_date",
  "editorField": "last_edited_user",
  "creationDateField": "created_date",
  "creatorField": "created_user"
 },
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "hasAttachments": false,
 "advancedQueryCapabilities": {
  "supportsSqlExpression": true,
  "supportsStatistics": true,
  "supportsQueryWithResultType": true,
  "supportsOrderBy": true,
  "supportsLod": false,
  "supportsQueryWithCacheHint": false,
  "supportsQueryWithDatumTransformation": true,
  "supportsQueryAttachmentsWithReturnUrl": true,
  "supportsQueryAttachments": true,
  "supportsQueryDateBins": false,
  "supportsQueryAttachmentsCountOnly": true,
  "supportsOrderByOnlyOnLayerFields": false,
  "supportsOutFieldSqlExpression": true,
  "supportsQueryWithLodSR": false,
  "supportsTopFeaturesQuery": true,
  "supportsPaginationOnAggregatedQueries": true,
  "supportsMaxRecordCountFactor": true,
  "supportsPagination": true,
  "supportsDistinct": true,
  "supportsQueryAnalytic": true,
  "supportsPercentileStatistics": true,
  "supportsHavingClause": true
 },
 "supportsValidateSQL": true,
 "enableZDefaults": true,
 "serviceItemId": "b9fc8808e5394d29b0b0c218ca22dece",
 "allowUpdateWithoutMValues": true,
 "supportsCoordinatesQuantization": true,
 "types": [],
 "capabilities": "Create,Editing,Query,Update,Uploads,Delete",
 "supportsAppend": true,
 "supportsExceedsLimitStatistics": true,
 "advancedQueryAnalyticCapabilities": {
  "supportsAsync": false,
  "supportsLinearRegression": true,
  "supportsPercentileAnalytic": false
 },
 "hasMetadata": true,
 "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel",
 "tileMaxRecordCount": 4000,
 "typeIdField": "",
 "supportedQueryFormats": "JSON, geoJSON, PBF",
 "sqlParserVersion": "PG_10.9.1",
 "copyrightText": "",
 "zDefault": 0
}