{
 "currentVersion": 11.5,
 "cimVersion": "3.5.0",
 "id": 25,
 "name": "RESIDENTIAL (CAMA)",
 "type": "Table",
 "description": "Data source is the Office of Tax and Revenue\u2019s Computer-Assisted Mass Appraisal (CAMA) system. The CAMA system is used by the Assessment Division (AD) within the Real Property Tax Administration to value real estate for ad valorem real property tax purposes. The intent of this data is to provide a sale history for active properties listed among the District of Columbia\u2019s real property tax assessment roll. This data is updated daily. The AD constantly maintains sale data, adding new data and updating existing data. Daily updates represent a \u201csnapshot\u201d at the time the data was extracted from the CAMA system, and data is always subject to change.",
 "copyrightText": "Office of the Chief Financial Officer",
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "SSL",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "SSL",
   "type": "esriFieldTypeString",
   "alias": "Square, Suffix, Lot",
   "length": 50,
   "domain": null
  },
  {
   "name": "BATHRM",
   "type": "esriFieldTypeDouble",
   "alias": "Bathroom",
   "domain": null
  },
  {
   "name": "HF_BATHRM",
   "type": "esriFieldTypeDouble",
   "alias": "Half Bathroom",
   "domain": null
  },
  {
   "name": "HEAT",
   "type": "esriFieldTypeDouble",
   "alias": "Heat",
   "domain": null
  },
  {
   "name": "HEAT_D",
   "type": "esriFieldTypeString",
   "alias": "Heat Description",
   "length": 50,
   "domain": null
  },
  {
   "name": "AC",
   "type": "esriFieldTypeString",
   "alias": "AC",
   "length": 10,
   "domain": null
  },
  {
   "name": "NUM_UNITS",
   "type": "esriFieldTypeDouble",
   "alias": "Number of Units",
   "domain": null
  },
  {
   "name": "ROOMS",
   "type": "esriFieldTypeDouble",
   "alias": "Rooms",
   "domain": null
  },
  {
   "name": "BEDRM",
   "type": "esriFieldTypeDouble",
   "alias": "Bedrooms",
   "domain": null
  },
  {
   "name": "AYB",
   "type": "esriFieldTypeDouble",
   "alias": "Average Year Built",
   "domain": null
  },
  {
   "name": "YR_RMDL",
   "type": "esriFieldTypeDouble",
   "alias": "Year Remodeled",
   "domain": null
  },
  {
   "name": "EYB",
   "type": "esriFieldTypeDouble",
   "alias": "Improvement Year Built",
   "domain": null
  },
  {
   "name": "STORIES",
   "type": "esriFieldTypeDouble",
   "alias": "Stories",
   "domain": null
  },
  {
   "name": "SALEDATE",
   "type": "esriFieldTypeDate",
   "alias": "Sale Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "PRICE",
   "type": "esriFieldTypeDouble",
   "alias": "Price",
   "domain": null
  },
  {
   "name": "QUALIFIED",
   "type": "esriFieldTypeString",
   "alias": "Qualified",
   "length": 20,
   "domain": null
  },
  {
   "name": "SALE_NUM",
   "type": "esriFieldTypeDouble",
   "alias": "Sale Number",
   "domain": null
  },
  {
   "name": "GBA",
   "type": "esriFieldTypeDouble",
   "alias": "Gross Building Area",
   "domain": null
  },
  {
   "name": "BLDG_NUM",
   "type": "esriFieldTypeDouble",
   "alias": "Building Number",
   "domain": null
  },
  {
   "name": "STYLE",
   "type": "esriFieldTypeDouble",
   "alias": "Style Code",
   "domain": null
  },
  {
   "name": "STYLE_D",
   "type": "esriFieldTypeString",
   "alias": "Style Description",
   "length": 50,
   "domain": null
  },
  {
   "name": "STRUCT",
   "type": "esriFieldTypeDouble",
   "alias": "Structure Code",
   "domain": null
  },
  {
   "name": "STRUCT_D",
   "type": "esriFieldTypeString",
   "alias": "Structure Description",
   "length": 50,
   "domain": null
  },
  {
   "name": "GRADE",
   "type": "esriFieldTypeDouble",
   "alias": "Grade Code",
   "domain": null
  },
  {
   "name": "GRADE_D",
   "type": "esriFieldTypeString",
   "alias": "Grade Description",
   "length": 50,
   "domain": null
  },
  {
   "name": "CNDTN",
   "type": "esriFieldTypeDouble",
   "alias": "Condition Code",
   "domain": null
  },
  {
   "name": "CNDTN_D",
   "type": "esriFieldTypeString",
   "alias": "Condition Description",
   "length": 50,
   "domain": null
  },
  {
   "name": "EXTWALL",
   "type": "esriFieldTypeDouble",
   "alias": "Exterior Wall Code",
   "domain": null
  },
  {
   "name": "EXTWALL_D",
   "type": "esriFieldTypeString",
   "alias": "Exterior Wall Description",
   "length": 50,
   "domain": null
  },
  {
   "name": "ROOF",
   "type": "esriFieldTypeDouble",
   "alias": "Roof Code",
   "domain": null
  },
  {
   "name": "ROOF_D",
   "type": "esriFieldTypeString",
   "alias": "Roof Description",
   "length": 50,
   "domain": null
  },
  {
   "name": "INTWALL",
   "type": "esriFieldTypeDouble",
   "alias": "Interior Wall Code",
   "domain": null
  },
  {
   "name": "INTWALL_D",
   "type": "esriFieldTypeString",
   "alias": "Interior Wall Description",
   "length": 50,
   "domain": null
  },
  {
   "name": "KITCHENS",
   "type": "esriFieldTypeDouble",
   "alias": "Kitchens",
   "domain": null
  },
  {
   "name": "FIREPLACES",
   "type": "esriFieldTypeDouble",
   "alias": "Fireplaces",
   "domain": null
  },
  {
   "name": "USECODE",
   "type": "esriFieldTypeDouble",
   "alias": "Property Use Code",
   "domain": null
  },
  {
   "name": "LANDAREA",
   "type": "esriFieldTypeDouble",
   "alias": "Property Land Area",
   "domain": null
  },
  {
   "name": "GIS_LAST_MOD_DTTM",
   "type": "esriFieldTypeDate",
   "alias": "GIS Last Modified Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  }
 ],
 "indexes": null,
 "subtypes": [],
 "relationships": [],
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 2000,
 "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,
  "supportsAdvancedQueryRelated": true,
  "supportsQueryRelatedPagination": true,
  "supportsSqlFormat": false,
  "supportsQueryAnalytic": true,
  "supportsCurrentUserQueries": true
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": false,
  "supportsPercentileAnalytic": true
 },
 "dateFieldsTimeReference": {
  "timeZone": "Eastern Standard Time",
  "timeZoneIANA": "America/New_York",
  "respectsDaylightSaving": true
 },
 "preferredTimeReference": null,
 "datesInUnknownTimezone": false,
 "hasMetadata": true,
 "isDataArchived": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 }
}