{
 "currentVersion": 11.5,
 "cimVersion": "3.5.0",
 "id": 58,
 "name": "ITSPE VACANT PROPERTY",
 "type": "Table",
 "description": "This table is a subset of ITSPE and represents vacant property.  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).",
 "copyrightText": "Office of the Chief Financial Officer",
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "OWNER_NAME_PRIMARY",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "SSL",
   "type": "esriFieldTypeString",
   "alias": "Square, Suffix, Lot",
   "length": 12,
   "domain": null
  },
  {
   "name": "LAND_USE_CODE",
   "type": "esriFieldTypeString",
   "alias": "Land Use Code",
   "length": 3,
   "domain": null
  },
  {
   "name": "LAND_USE_DESCRIPTION",
   "type": "esriFieldTypeString",
   "alias": "Land Use Description",
   "length": 255,
   "domain": null
  },
  {
   "name": "LANDAREA",
   "type": "esriFieldTypeDouble",
   "alias": "Land Area",
   "domain": null
  },
  {
   "name": "PROPERTY_ADDRESS",
   "type": "esriFieldTypeString",
   "alias": "Property Address",
   "length": 50,
   "domain": null
  },
  {
   "name": "OWNER_NAME_PRIMARY",
   "type": "esriFieldTypeString",
   "alias": "Primary Owner Name",
   "length": 70,
   "domain": null
  },
  {
   "name": "APPRAISED_VALUE_PRIOR_LAND",
   "type": "esriFieldTypeDouble",
   "alias": "Prior Year Land Value",
   "domain": null
  },
  {
   "name": "APPRAISED_VALUE_PRIOR_IMPR",
   "type": "esriFieldTypeDouble",
   "alias": "Prior Year Building Value",
   "domain": null
  },
  {
   "name": "APPRAISED_VALUE_PRIOR_TOTAL",
   "type": "esriFieldTypeDouble",
   "alias": "Prior Year Total Value",
   "domain": null
  },
  {
   "name": "APPRAISED_VALUE_PROPOSED_LAND",
   "type": "esriFieldTypeDouble",
   "alias": "Proposed Land Value",
   "domain": null
  },
  {
   "name": "APPRAISED_VALUE_PROPOSED_IMPR",
   "type": "esriFieldTypeDouble",
   "alias": "Proposed Building Value",
   "domain": null
  },
  {
   "name": "APPRAISED_VALUE_PROPOSED_TOTAL",
   "type": "esriFieldTypeDouble",
   "alias": "Proposed Total Value",
   "domain": null
  },
  {
   "name": "APPRAISED_VALUE_CURRENT_LAND",
   "type": "esriFieldTypeDouble",
   "alias": "Current Land Value",
   "domain": null
  },
  {
   "name": "APPRAISED_VALUE_CURRENT_BLDG",
   "type": "esriFieldTypeDouble",
   "alias": "Current Building Value",
   "domain": null
  },
  {
   "name": "APPRAISED_VALUE_CURRENT_TOTAL",
   "type": "esriFieldTypeDouble",
   "alias": "Current Total",
   "domain": null
  },
  {
   "name": "VACANT_USE",
   "type": "esriFieldTypeString",
   "alias": "Vacant Use",
   "length": 3,
   "domain": null
  },
  {
   "name": "HOMESTEAD_CODE",
   "type": "esriFieldTypeString",
   "alias": "Homestead Code",
   "length": 1,
   "domain": null
  },
  {
   "name": "HOMESTEAD_DESCRIPTION",
   "type": "esriFieldTypeString",
   "alias": "Homestead Description",
   "length": 50,
   "domain": null
  },
  {
   "name": "TAX_TYPE_DESCRIPTION",
   "type": "esriFieldTypeString",
   "alias": "Tax Type Description",
   "length": 75,
   "domain": null
  },
  {
   "name": "TAXRATE",
   "type": "esriFieldTypeDouble",
   "alias": "Tas Rate",
   "domain": null
  },
  {
   "name": "MIXED_USE",
   "type": "esriFieldTypeString",
   "alias": "Mixed Use",
   "length": 1,
   "domain": null
  },
  {
   "name": "OWNER_OCCUPIED_COOP_UNITS",
   "type": "esriFieldTypeDouble",
   "alias": "Number of Co-Op Units",
   "domain": null
  },
  {
   "name": "LAST_SALE_PRICE",
   "type": "esriFieldTypeDouble",
   "alias": "Last Sale Price",
   "domain": null
  },
  {
   "name": "LAST_SALE_DATE",
   "type": "esriFieldTypeDate",
   "alias": "Last Sale Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "DEED_DATE",
   "type": "esriFieldTypeDate",
   "alias": "Deed Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "CURRENT_ASSESSMENT_CAP",
   "type": "esriFieldTypeDouble",
   "alias": "Cap Assessment for Current Year",
   "domain": null
  },
  {
   "name": "PROPOSED_ASSESSMENT_CAP",
   "type": "esriFieldTypeDouble",
   "alias": "Cap Assessment for Proposed Year",
   "domain": null
  },
  {
   "name": "OWNER_NAME_SECONDARY",
   "type": "esriFieldTypeString",
   "alias": "Secondary Owner Name",
   "length": 70,
   "domain": null
  },
  {
   "name": "ADDRESS_ID",
   "type": "esriFieldTypeString",
   "alias": "Master Address Repository Identifier",
   "length": 1000,
   "domain": null
  },
  {
   "name": "LASTMODIFIEDDATE",
   "type": "esriFieldTypeDate",
   "alias": "Last Modified Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "GDB_83039_SSL",
   "fields": "SSL",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "R18853_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 6,
   "name": "DCGIS.OwnerPLY",
   "relatedTableId": 40,
   "role": "esriRelRoleDestination",
   "keyField": "SSL",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{63D87CB3-6669-4754-A71A-628354B2F3F3}"
  },
  {
   "id": 16,
   "name": "DCGIS.OwnerPLY",
   "relatedTableId": 49,
   "role": "esriRelRoleDestination",
   "keyField": "SSL",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{63D87CB3-6669-4754-A71A-628354B2F3F3}"
  },
  {
   "id": 23,
   "name": "DCGIS.OwnerPLY",
   "relatedTableId": 50,
   "role": "esriRelRoleDestination",
   "keyField": "SSL",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{63D87CB3-6669-4754-A71A-628354B2F3F3}"
  }
 ],
 "capabilities": "Query,Map,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
 }
}