Name: ITSPE VACANT PROPERTY

Display Field: OWNER_NAME_PRIMARY

Type: Table

Geometry Type: N/A

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).

Copyright Text: Office of the Chief Financial Officer

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• SSL ( type: esriFieldTypeString, alias: SSL, editable: true, nullable: true, length: 12, defaultValue: null, modelName: SSL )
• LAND_USE_CODE ( type: esriFieldTypeString, alias: LAND_USE_CODE, editable: true, nullable: true, length: 3, defaultValue: null, modelName: LAND_USE_CODE )
• LAND_USE_DESCRIPTION ( type: esriFieldTypeString, alias: LAND_USE_DESCRIPTION, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LAND_USE_DESCRIPTION )
• LANDAREA ( type: esriFieldTypeDouble, alias: LANDAREA, editable: true, nullable: true, defaultValue: null, modelName: LANDAREA )
• PROPERTY_ADDRESS ( type: esriFieldTypeString, alias: PROPERTY_ADDRESS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PROPERTY_ADDRESS )
• OWNER_NAME_PRIMARY ( type: esriFieldTypeString, alias: OWNER_NAME_PRIMARY, editable: true, nullable: true, length: 70, defaultValue: null, modelName: OWNER_NAME_PRIMARY )
• APPRAISED_VALUE_PRIOR_LAND ( type: esriFieldTypeDouble, alias: APPRAISED_VALUE_PRIOR_LAND, editable: true, nullable: true, defaultValue: null, modelName: APPRAISED_VALUE_PRIOR_LAND )
• APPRAISED_VALUE_PRIOR_IMPR ( type: esriFieldTypeDouble, alias: APPRAISED_VALUE_PRIOR_IMPR, editable: true, nullable: true, defaultValue: null, modelName: APPRAISED_VALUE_PRIOR_IMPR )
• APPRAISED_VALUE_PRIOR_TOTAL ( type: esriFieldTypeDouble, alias: APPRAISED_VALUE_PRIOR_TOTAL, editable: true, nullable: true, defaultValue: null, modelName: APPRAISED_VALUE_PRIOR_TOTAL )
• APPRAISED_VALUE_PROPOSED_LAND ( type: esriFieldTypeDouble, alias: APPRAISED_VALUE_PROPOSED_LAND, editable: true, nullable: true, defaultValue: null, modelName: APPRAISED_VALUE_PROPOSED_LAND )
• APPRAISED_VALUE_PROPOSED_IMPR ( type: esriFieldTypeDouble, alias: APPRAISED_VALUE_PROPOSED_IMPR, editable: true, nullable: true, defaultValue: null, modelName: APPRAISED_VALUE_PROPOSED_IMPR )
• APPRAISED_VALUE_PROPOSED_TOTAL ( type: esriFieldTypeDouble, alias: APPRAISED_VALUE_PROPOSED_TOTAL, editable: true, nullable: true, defaultValue: null, modelName: APPRAISED_VALUE_PROPOSED_TOTAL )
• APPRAISED_VALUE_CURRENT_LAND ( type: esriFieldTypeDouble, alias: APPRAISED_VALUE_CURRENT_LAND, editable: true, nullable: true, defaultValue: null, modelName: APPRAISED_VALUE_CURRENT_LAND )
• APPRAISED_VALUE_CURRENT_BLDG ( type: esriFieldTypeDouble, alias: APPRAISED_VALUE_CURRENT_BLDG, editable: true, nullable: true, defaultValue: null, modelName: APPRAISED_VALUE_CURRENT_BLDG )
• VACANT_USE ( type: esriFieldTypeString, alias: VACANT_USE, editable: true, nullable: true, length: 3, defaultValue: null, modelName: VACANT_USE )
• HOMESTEAD_CODE ( type: esriFieldTypeString, alias: HOMESTEAD_CODE, editable: true, nullable: true, length: 1, defaultValue: null, modelName: HOMESTEAD_CODE )
• HOMESTEAD_DESCRIPTION ( type: esriFieldTypeString, alias: HOMESTEAD_DESCRIPTION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HOMESTEAD_DESCRIPTION )
• TAX_TYPE_DESCRIPTION ( type: esriFieldTypeString, alias: TAX_TYPE_DESCRIPTION, editable: true, nullable: true, length: 75, defaultValue: null, modelName: TAX_TYPE_DESCRIPTION )
• TAXRATE ( type: esriFieldTypeDouble, alias: TAXRATE, editable: true, nullable: true, defaultValue: null, modelName: TAXRATE )
• MIXED_USE ( type: esriFieldTypeString, alias: MIXED_USE, editable: true, nullable: true, length: 1, defaultValue: null, modelName: MIXED_USE )
• OWNER_OCCUPIED_COOP_UNITS ( type: esriFieldTypeDouble, alias: OWNER_OCCUPIED_COOP_UNITS, editable: true, nullable: true, defaultValue: null, modelName: OWNER_OCCUPIED_COOP_UNITS )
• LAST_SALE_PRICE ( type: esriFieldTypeDouble, alias: LAST_SALE_PRICE, editable: true, nullable: true, defaultValue: null, modelName: LAST_SALE_PRICE )
• LAST_SALE_DATE ( type: esriFieldTypeDate, alias: LAST_SALE_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_SALE_DATE )
• DEED_DATE ( type: esriFieldTypeDate, alias: DEED_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DEED_DATE )
• CURRENT_ASSESSMENT_CAP ( type: esriFieldTypeDouble, alias: CURRENT_ASSESSMENT_CAP, editable: true, nullable: true, defaultValue: null, modelName: CURRENT_ASSESSMENT_CAP )
• PROPOSED_ASSESSMENT_CAP ( type: esriFieldTypeDouble, alias: PROPOSED_ASSESSMENT_CAP, editable: true, nullable: true, defaultValue: null, modelName: PROPOSED_ASSESSMENT_CAP )
• OWNER_NAME_SECONDARY ( type: esriFieldTypeString, alias: OWNER_NAME_SECONDARY, editable: true, nullable: true, length: 70, defaultValue: null, modelName: OWNER_NAME_SECONDARY )
• ADDRESS_ID ( type: esriFieldTypeString, alias: ADDRESS_ID, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: ADDRESS_ID )
• LASTMODIFIEDDATE ( type: esriFieldTypeDate, alias: LASTMODIFIEDDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTMODIFIEDDATE )
• APPRAISED_VALUE_CURRENT_TOTAL ( type: esriFieldTypeDouble, alias: APPRAISED_VALUE_CURRENT_TOTAL, editable: true, nullable: true, defaultValue: null, modelName: APPRAISED_VALUE_CURRENT_TOTAL )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )

Templates:

• Name: ITSPE VACANT PROPERTY
  Description:
  Prototype:
  APPRAISED_VALUE_CURRENT_TOTAL: null
  SSL: null
  LAND_USE_CODE: null
  LAND_USE_DESCRIPTION: null
  LANDAREA: null
  PROPERTY_ADDRESS: null
  OWNER_NAME_PRIMARY: 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
  VACANT_USE: null
  HOMESTEAD_CODE: 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
  OWNER_NAME_SECONDARY: null
  ADDRESS_ID: null
  LASTMODIFIEDDATE: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• DCGIS.OwnerPLY (7) -- Related To: Owner Polygons (Common Ownership Layer) (40)
• DCGIS.OwnerPLY (22) -- Related To: District Land (RPTA Ownership) (49)
• DCGIS.OwnerPLY (33) -- Related To: Federal Land (RPTA Ownership) (50)

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:

Supported Operations:   Query   Query Analytic   Query Related Records   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata