{
 "currentVersion": 11.5,
 "cimVersion": "3.5.0",
 "id": 56,
 "name": "ITSPE FACTS",
 "type": "Table",
 "description": "The tax assessment roll public extract (ITSPE) is used for assessment and property analysis, to send property tax bills and notices, and stores comprehensive tax information such as ownership, mailing addresses,  non-contiguous Air Rights lots (Multifamily or Development), Air Rights lots, possessory interest lots, record lots, tax lots, parcels, condominiums, and federally owned lands such as reservations and appropriations. The linkage from the Vector Property layers to this database is SSL (Square, Suffix, and Lot).  It should be noted that not all record lots have a direct 1:1 relationship to information in this database. The most obvious examples would be when a tax lot was created from existing record lots. In this case, only the tax lot would have linkage to the ITSPE, not the underlying record lots (though they still exist). Reservations that have been converted into tax lots are an additional example where the reservation still exists, however for taxation purposes the tax lot (overlay) supersedes and has corresponding linkage to ITS.  The same is true for most Condominiums and the ground surface lot (Record) which still exist (common space) or the previous overlay (Air Right or Tax lot), only the Condo lot would have linkage to (ITSPE).  This table has fewer fields than the ITSPE and clarifies the abbreviated column names from the Data Dictionary.",
 "copyrightText": "Office of the Chief Financial Officer",
 "editFieldsInfo": null,
 "ownershipBasedAccessControlForFeatures": null,
 "syncCanReturnChanges": false,
 "relationships": [
  {
   "id": 7,
   "name": "DCGIS.OwnerPLY",
   "relatedTableId": 40,
   "cardinality": "esriRelCardinalityOneToMany",
   "role": "esriRelRoleDestination",
   "keyField": "SSL",
   "composite": false,
   "catalogID": "{F148C078-1EFC-409C-8861-E37588658ACB}"
  },
  {
   "id": 17,
   "name": "DCGIS.OwnerPLY",
   "relatedTableId": 49,
   "cardinality": "esriRelCardinalityOneToMany",
   "role": "esriRelRoleDestination",
   "keyField": "SSL",
   "composite": false,
   "catalogID": "{F148C078-1EFC-409C-8861-E37588658ACB}"
  },
  {
   "id": 24,
   "name": "DCGIS.OwnerPLY",
   "relatedTableId": 50,
   "cardinality": "esriRelCardinalityOneToMany",
   "role": "esriRelRoleDestination",
   "keyField": "SSL",
   "composite": false,
   "catalogID": "{F148C078-1EFC-409C-8861-E37588658ACB}"
  },
  {
   "id": 30,
   "name": "DCGIS.CONDORELATE",
   "relatedTableId": 52,
   "cardinality": "esriRelCardinalityOneToMany",
   "role": "esriRelRoleDestination",
   "keyField": "SSL",
   "composite": false,
   "catalogID": "{1932D731-ACAD-4C26-854E-331A0D0B182F}"
  }
 ],
 "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": "ASSESSOR_NAME",
 "typeIdField": "",
 "subtypeField": "",
 "fields": [
  {
   "name": "SSL",
   "type": "esriFieldTypeString",
   "alias": "Square, Suffix, Lot",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 12,
   "defaultValue": null,
   "modelName": "SSL"
  },
  {
   "name": "ASSESSOR_NAME",
   "type": "esriFieldTypeString",
   "alias": "Assessor Name",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 25,
   "defaultValue": null,
   "modelName": "ASSESSOR_NAME"
  },
  {
   "name": "LAND_USE_CODE",
   "type": "esriFieldTypeString",
   "alias": "Land Use Code",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 3,
   "defaultValue": null,
   "modelName": "LAND_USE_CODE"
  },
  {
   "name": "LAND_USE_DESCRIPTION",
   "type": "esriFieldTypeString",
   "alias": "Land Use Description",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "LAND_USE_DESCRIPTION"
  },
  {
   "name": "LANDAREA",
   "type": "esriFieldTypeDouble",
   "alias": "Land Area",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "LANDAREA"
  },
  {
   "name": "PROPERTY_ADDRESS",
   "type": "esriFieldTypeString",
   "alias": "Property Address",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "PROPERTY_ADDRESS"
  },
  {
   "name": "OTR_NEIGHBORHOOD_CODE",
   "type": "esriFieldTypeString",
   "alias": "Assessor's Neighborhood Code",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 3,
   "defaultValue": null,
   "modelName": "OTR_NEIGHBORHOOD_CODE"
  },
  {
   "name": "OTR_NEIGHBORHOOD_NAME",
   "type": "esriFieldTypeString",
   "alias": "Assessor's Neighborhood Name",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "OTR_NEIGHBORHOOD_NAME"
  },
  {
   "name": "OWNER_NAME_PRIMARY",
   "type": "esriFieldTypeString",
   "alias": "Primary Owner Name",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 70,
   "defaultValue": null,
   "modelName": "OWNER_NAME_PRIMARY"
  },
  {
   "name": "OWNER_NAME_SECONDARY",
   "type": "esriFieldTypeString",
   "alias": "Secondary Owner Name",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 70,
   "defaultValue": null,
   "modelName": "OWNER_NAME_SECONDARY"
  },
  {
   "name": "CAREOF_NAME",
   "type": "esriFieldTypeString",
   "alias": "Care of Name",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 40,
   "defaultValue": null,
   "modelName": "CAREOF_NAME"
  },
  {
   "name": "OWNER_ADDRESS_LINE1",
   "type": "esriFieldTypeString",
   "alias": "Owner Address Line 1",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 40,
   "defaultValue": null,
   "modelName": "OWNER_ADDRESS_LINE1"
  },
  {
   "name": "OWNER_ADDRESS_LINE2",
   "type": "esriFieldTypeString",
   "alias": "Owner Address Line 2",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 40,
   "defaultValue": null,
   "modelName": "OWNER_ADDRESS_LINE2"
  },
  {
   "name": "OWNER_ADDRESS_CITYSTZIP",
   "type": "esriFieldTypeString",
   "alias": "Owner Address City, State, Zip",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 40,
   "defaultValue": null,
   "modelName": "OWNER_ADDRESS_CITYSTZIP"
  },
  {
   "name": "APPRAISED_VALUE_PRIOR_LAND",
   "type": "esriFieldTypeDouble",
   "alias": "Prior Year Land Value",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "APPRAISED_VALUE_PRIOR_LAND"
  },
  {
   "name": "APPRAISED_VALUE_PRIOR_IMPR",
   "type": "esriFieldTypeDouble",
   "alias": "Prior Year Building Value",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "APPRAISED_VALUE_PRIOR_IMPR"
  },
  {
   "name": "APPRAISED_VALUE_PRIOR_TOTAL",
   "type": "esriFieldTypeDouble",
   "alias": "Prior Year Total Value",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "APPRAISED_VALUE_PRIOR_TOTAL"
  },
  {
   "name": "APPRAISED_VALUE_PROPOSED_LAND",
   "type": "esriFieldTypeDouble",
   "alias": "Proposed Land Value",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "APPRAISED_VALUE_PROPOSED_LAND"
  },
  {
   "name": "APPRAISED_VALUE_PROPOSED_IMPR",
   "type": "esriFieldTypeDouble",
   "alias": "Proposed Building Value",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "APPRAISED_VALUE_PROPOSED_IMPR"
  },
  {
   "name": "APPRAISED_VALUE_PROPOSED_TOTAL",
   "type": "esriFieldTypeDouble",
   "alias": "Proposed Total Value",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "APPRAISED_VALUE_PROPOSED_TOTAL"
  },
  {
   "name": "APPRAISED_VALUE_CURRENT_LAND",
   "type": "esriFieldTypeDouble",
   "alias": "Current Land Value",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "APPRAISED_VALUE_CURRENT_LAND"
  },
  {
   "name": "APPRAISED_VALUE_CURRENT_BLDG",
   "type": "esriFieldTypeDouble",
   "alias": "Current Building Value",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "APPRAISED_VALUE_CURRENT_BLDG"
  },
  {
   "name": "APPRAISED_VALUE_CURRENT_TOTAL",
   "type": "esriFieldTypeDouble",
   "alias": "Current Total Value",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "APPRAISED_VALUE_CURRENT_TOTAL"
  },
  {
   "name": "VACANT_USE",
   "type": "esriFieldTypeString",
   "alias": "Vacant Use",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 3,
   "defaultValue": null,
   "modelName": "VACANT_USE"
  },
  {
   "name": "HOMESTEAD_DESCRIPTION",
   "type": "esriFieldTypeString",
   "alias": "Homestead Description",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "HOMESTEAD_DESCRIPTION"
  },
  {
   "name": "TAX_TYPE_DESCRIPTION",
   "type": "esriFieldTypeString",
   "alias": "Tax Type Description",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 75,
   "defaultValue": null,
   "modelName": "TAX_TYPE_DESCRIPTION"
  },
  {
   "name": "TAXRATE",
   "type": "esriFieldTypeDouble",
   "alias": "Tax Rate",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "TAXRATE"
  },
  {
   "name": "MIXED_USE",
   "type": "esriFieldTypeString",
   "alias": "Mixed Use",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 1,
   "defaultValue": null,
   "modelName": "MIXED_USE"
  },
  {
   "name": "OWNER_OCCUPIED_COOP_UNITS",
   "type": "esriFieldTypeDouble",
   "alias": "Number of Co-Op Units",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "OWNER_OCCUPIED_COOP_UNITS"
  },
  {
   "name": "LAST_SALE_PRICE",
   "type": "esriFieldTypeDouble",
   "alias": "Last Sale Price",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "LAST_SALE_PRICE"
  },
  {
   "name": "LAST_SALE_DATE",
   "type": "esriFieldTypeDate",
   "alias": "Last Sale Date",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "LAST_SALE_DATE"
  },
  {
   "name": "DEED_DATE",
   "type": "esriFieldTypeDate",
   "alias": "Deed Date",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "DEED_DATE"
  },
  {
   "name": "CURRENT_ASSESSMENT_CAP",
   "type": "esriFieldTypeDouble",
   "alias": "Cap Assessment for Current Year",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "CURRENT_ASSESSMENT_CAP"
  },
  {
   "name": "PROPOSED_ASSESSMENT_CAP",
   "type": "esriFieldTypeDouble",
   "alias": "Cap Assessment for Proposed Year",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "PROPOSED_ASSESSMENT_CAP"
  },
  {
   "name": "ADDRESS_ID",
   "type": "esriFieldTypeString",
   "alias": "Master Address Repository Identifier",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 1000,
   "defaultValue": null,
   "modelName": "ADDRESS_ID"
  },
  {
   "name": "LASTMODIFIEDDATE",
   "type": "esriFieldTypeDate",
   "alias": "Last Modified Date",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "LASTMODIFIEDDATE"
  },
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null,
   "editable": false,
   "nullable": false,
   "defaultValue": null,
   "modelName": "OBJECTID"
  }
 ],
 "indexes": [
  {
   "name": "GDB_83041_SSL",
   "isAscending": true,
   "isUnique": false,
   "description": "",
   "fields": "SSL"
  },
  {
   "name": "R18855_SDE_ROWID_UK",
   "isAscending": true,
   "isUnique": true,
   "description": "",
   "fields": "OBJECTID"
  }
 ],
 "datesInUnknownTimezone": false,
 "dateFieldsTimeReference": {
  "timeZone": "Eastern Standard Time",
  "timeZoneIANA": "America/New_York",
  "respectsDaylightSaving": true
 },
 "preferredTimeReference": null,
 "types": [],
 "templates": [
  {
   "name": "ITSPE FACTS",
   "description": "",
   "prototype": {
    "attributes": {
     "LASTMODIFIEDDATE": null,
     "SSL": null,
     "ASSESSOR_NAME": null,
     "LAND_USE_CODE": null,
     "LAND_USE_DESCRIPTION": null,
     "LANDAREA": null,
     "PROPERTY_ADDRESS": null,
     "OTR_NEIGHBORHOOD_CODE": null,
     "OTR_NEIGHBORHOOD_NAME": null,
     "OWNER_NAME_PRIMARY": null,
     "OWNER_NAME_SECONDARY": null,
     "CAREOF_NAME": null,
     "OWNER_ADDRESS_LINE1": null,
     "OWNER_ADDRESS_LINE2": null,
     "OWNER_ADDRESS_CITYSTZIP": null,
     "APPRAISED_VALUE_PRIOR_LAND": null,
     "APPRAISED_VALUE_PRIOR_IMPR": null,
     "APPRAISED_VALUE_PRIOR_TOTAL": null,
     "APPRAISED_VALUE_PROPOSED_LAND": null,
     "APPRAISED_VALUE_PROPOSED_IMPR": null,
     "APPRAISED_VALUE_PROPOSED_TOTAL": null,
     "APPRAISED_VALUE_CURRENT_LAND": null,
     "APPRAISED_VALUE_CURRENT_BLDG": null,
     "APPRAISED_VALUE_CURRENT_TOTAL": null,
     "VACANT_USE": null,
     "HOMESTEAD_DESCRIPTION": null,
     "TAX_TYPE_DESCRIPTION": null,
     "TAXRATE": null,
     "MIXED_USE": null,
     "OWNER_OCCUPIED_COOP_UNITS": null,
     "LAST_SALE_PRICE": null,
     "LAST_SALE_DATE": null,
     "DEED_DATE": null,
     "CURRENT_ASSESSMENT_CAP": null,
     "PROPOSED_ASSESSMENT_CAP": null,
     "ADDRESS_ID": 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
}