{
 "currentVersion": 11.5,
 "cimVersion": "3.5.0",
 "id": 23,
 "name": "COMMERCIAL (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",
 "editFieldsInfo": null,
 "ownershipBasedAccessControlForFeatures": null,
 "syncCanReturnChanges": false,
 "relationships": [],
 "isDataVersioned": false,
 "isDataArchived": false,
 "infoInEstimates": [
  "count"
 ],
 "isDataBranchVersioned": false,
 "isDataReplicaTracked": false,
 "isCoGoEnabled": false,
 "supportsRollbackOnFailureParameter": true,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 },
 "supportsStatistics": true,
 "supportsExceedsLimitStatistics": true,
 "supportsAdvancedQueries": true,
 "supportsValidateSQL": true,
 "supportsCoordinatesQuantization": false,
 "supportsCalculate": true,
 "supportsASyncCalculate": true,
 "supportsDurableUrlForSyncModelNone": false,
 "advancedQueryCapabilities": {
  "supportsPagination": true,
  "supportsQueryWithDistance": true,
  "supportsReturningQueryExtent": true,
  "supportsStatistics": true,
  "supportsPercentileStatistics": true,
  "supportsHavingClause": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsCountDistinct": true,
  "supportsAdvancedQueryRelated": true,
  "supportsQueryRelatedPagination": true,
  "supportsCurrentUserQueries": true,
  "supportsFullTextSearch": true,
  "fullTextSearchCapabilities": {
   "supportsSearchOperator": true,
   "supportsOperator": false,
   "supportsSqlExpressionInFullText": true
  },
  "fullTextSearchableFields": [],
  "supportsQueryWithResultType": true,
  "supportsReturningGeometryCentroid": false,
  "supportsReturningGeometryEnvelope": false,
  "supportsSqlExpression": true,
  "supportsLod": false,
  "supportsQueryWithLodSR": false,
  "supportsQueryAnalytic": true,
  "supportsQueryWithCacheHint": false
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": true,
  "supportsPercentileAnalytic": true
 },
 "advancedEditingCapabilities": {
  "supportedSqlFormatsInCalculate": [
   "standard"
  ],
  "supportsAsyncApplyEdits": true,
  "supportsApplyEditsbyUploadID": true,
  "supportedApplyEditsUploadIDFormats": "JSON,PBF"
 },
 "hasMetadata": true,
 "hasAttachments": false,
 "supportsApplyEditsWithGlobalIds": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "objectIdField": "OBJECTID",
 "globalIdField": "",
 "displayField": "SSL",
 "typeIdField": "",
 "subtypeField": "",
 "fields": [
  {
   "name": "SSL",
   "type": "esriFieldTypeString",
   "alias": "Square, Suffix, Lot",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "SSL"
  },
  {
   "name": "BLDG_NUM",
   "type": "esriFieldTypeDouble",
   "alias": "Building Number",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "BLDG_NUM"
  },
  {
   "name": "SECT_NUM",
   "type": "esriFieldTypeDouble",
   "alias": "Section Number",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "SECT_NUM"
  },
  {
   "name": "STRUCT_CL",
   "type": "esriFieldTypeString",
   "alias": "Structure Class Code",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 10,
   "defaultValue": null,
   "modelName": "STRUCT_CL"
  },
  {
   "name": "STRUCT_CL_D",
   "type": "esriFieldTypeString",
   "alias": "Structure Type Description",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "STRUCT_CL_D"
  },
  {
   "name": "GRADE",
   "type": "esriFieldTypeDouble",
   "alias": "Grade Class",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "GRADE"
  },
  {
   "name": "GRADE_D",
   "type": "esriFieldTypeString",
   "alias": "Grade Description",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "GRADE_D"
  },
  {
   "name": "EXTWALL",
   "type": "esriFieldTypeString",
   "alias": "Exterior Wall Code",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 10,
   "defaultValue": null,
   "modelName": "EXTWALL"
  },
  {
   "name": "EXTWALL_D",
   "type": "esriFieldTypeString",
   "alias": "Exterior Wall Description",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "EXTWALL_D"
  },
  {
   "name": "WALL_HGT",
   "type": "esriFieldTypeDouble",
   "alias": "Wall Height",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "WALL_HGT"
  },
  {
   "name": "NUM_UNITS",
   "type": "esriFieldTypeDouble",
   "alias": "Number of Units",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "NUM_UNITS"
  },
  {
   "name": "SALEDATE",
   "type": "esriFieldTypeDate",
   "alias": "Sale Date",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "SALEDATE"
  },
  {
   "name": "PRICE",
   "type": "esriFieldTypeDouble",
   "alias": "Price",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "PRICE"
  },
  {
   "name": "QUALIFIED",
   "type": "esriFieldTypeString",
   "alias": "Qualified",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 20,
   "defaultValue": null,
   "modelName": "QUALIFIED"
  },
  {
   "name": "AYB",
   "type": "esriFieldTypeDouble",
   "alias": "Average Year Built",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "AYB"
  },
  {
   "name": "YR_RMDL",
   "type": "esriFieldTypeDouble",
   "alias": "Year Remodeled",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "YR_RMDL"
  },
  {
   "name": "EYB",
   "type": "esriFieldTypeDouble",
   "alias": "Improvement Year Built",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "EYB"
  },
  {
   "name": "SALE_NUM",
   "type": "esriFieldTypeDouble",
   "alias": "Sale Number",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "SALE_NUM"
  },
  {
   "name": "LIVING_GBA",
   "type": "esriFieldTypeDouble",
   "alias": "Living Gross Building Area",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "LIVING_GBA"
  },
  {
   "name": "USECODE",
   "type": "esriFieldTypeDouble",
   "alias": "Property Use Code",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "USECODE"
  },
  {
   "name": "LANDAREA",
   "type": "esriFieldTypeDouble",
   "alias": "Property Land Area",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "LANDAREA"
  },
  {
   "name": "GIS_LAST_MOD_DTTM",
   "type": "esriFieldTypeDate",
   "alias": "GIS Last Modified Date",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "GIS_LAST_MOD_DTTM"
  },
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null,
   "editable": false,
   "nullable": false,
   "defaultValue": null,
   "modelName": "OBJECTID"
  }
 ],
 "datesInUnknownTimezone": false,
 "dateFieldsTimeReference": {
  "timeZone": "Eastern Standard Time",
  "timeZoneIANA": "America/New_York",
  "respectsDaylightSaving": true
 },
 "preferredTimeReference": null,
 "types": [],
 "templates": [
  {
   "name": "COMMERCIAL (CAMA)",
   "description": "",
   "prototype": {
    "attributes": {
     "GIS_LAST_MOD_DTTM": null,
     "SSL": null,
     "BLDG_NUM": null,
     "SECT_NUM": null,
     "STRUCT_CL": null,
     "STRUCT_CL_D": null,
     "GRADE": null,
     "GRADE_D": null,
     "EXTWALL": null,
     "EXTWALL_D": null,
     "WALL_HGT": null,
     "NUM_UNITS": null,
     "SALEDATE": null,
     "PRICE": null,
     "QUALIFIED": null,
     "AYB": null,
     "YR_RMDL": null,
     "EYB": null,
     "SALE_NUM": null,
     "LIVING_GBA": null,
     "USECODE": null,
     "LANDAREA": null
    }
   },
   "drawingTool": "esriFeatureEditToolNone"
  }
 ],
 "maxRecordCount": 2000,
 "supportedQueryFormats": "JSON, geoJSON, PBF",
 "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson",
 "capabilities": "Query,Extract",
 "useStandardizedQueries": true,
 "bigIntegerRestrictedTo53Bits": true,
 "supportsAppend": true,
 "supportedAppendFormats": "FILEGDB,PBF",
 "standardMaxRecordCount": 32000,
 "tileMaxRecordCount": 2000,
 "maxRecordCountFactor": 1
}