Name: ITSPE VACANT/BLIGHTED BUILDING
Display Field: ASRNAME
Type: Table
Geometry Type: N/A
Description: This table is a subset of ITSPE and represents vacant and blighted 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, PBF
Supports Advanced Queries: true
Supports Statistics: true
Use Standardized Queries: true
Extent:
Drawing Info:
Feature Draw Order:
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: false
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: true
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: null
Fields:
-
SSL
(
type: esriFieldTypeString, alias: Square, Suffix, Lot, length: 12
)
-
SQUARE
(
type: esriFieldTypeString, alias: Square, length: 4
)
-
SUFFIX
(
type: esriFieldTypeString, alias: Suffix, length: 4
)
-
LOT
(
type: esriFieldTypeString, alias: Lot, length: 4
)
-
ARN
(
type: esriFieldTypeString, alias: Assessor ID Number, length: 3
)
-
ASRNAME
(
type: esriFieldTypeString, alias: Assessor's Name, length: 25
)
-
PROPTYPE
(
type: esriFieldTypeString, alias: Type of property, length: 30
)
-
TRIGROUP
(
type: esriFieldTypeString, alias: Triennial Tax Assessment Group, length: 1
)
-
USECODE
(
type: esriFieldTypeString, alias: Property Use Code, length: 3
)
-
LANDAREA
(
type: esriFieldTypeDouble, alias: Square footage of land per
)
-
PREMISEADD
(
type: esriFieldTypeString, alias: Property address, length: 50
)
-
NBHD
(
type: esriFieldTypeString, alias: Assessor's Neighborhood Code, length: 3
)
-
SUBNBHD
(
type: esriFieldTypeString, alias: Assessor's Sub-Neighborhood code, length: 1
)
-
UNITNUMBER
(
type: esriFieldTypeString, alias: Unit number, length: 6
)
-
OWNERNAME
(
type: esriFieldTypeString, alias: Property Owner's Name, length: 70
)
-
CAREOFNAME
(
type: esriFieldTypeString, alias: Name to whom the tax bill is sent, length: 40
)
-
ADDRESS1
(
type: esriFieldTypeString, alias: Tax billing address part 1, length: 40
)
-
ADDRESS2
(
type: esriFieldTypeString, alias: Tax billing address part 2, length: 40
)
-
CITYSTZIP
(
type: esriFieldTypeString, alias: Tax billing address part 3, length: 40
)
-
OLDLAND
(
type: esriFieldTypeDouble, alias: Prior Year Land
)
-
OLDIMPR
(
type: esriFieldTypeDouble, alias: Prior Year Build
)
-
OLDTOTAL
(
type: esriFieldTypeDouble, alias: Prior year Total
)
-
NEWLAND
(
type: esriFieldTypeDouble, alias: Proposed Land
)
-
NEWIMPR
(
type: esriFieldTypeDouble, alias: Proposed Build
)
-
NEWTOTAL
(
type: esriFieldTypeDouble, alias: Proposed Total
)
-
PHASELAND
(
type: esriFieldTypeDouble, alias: Current Land
)
-
PHASEBUILD
(
type: esriFieldTypeDouble, alias: Current Build
)
-
PARTPART
(
type: esriFieldTypeString, alias: Part and Part, length: 1
)
-
VACLNDUSE
(
type: esriFieldTypeString, alias: Vacant Landuse, length: 1
)
-
LOWNUMBER
(
type: esriFieldTypeString, alias: Base House Number of the property address, length: 4
)
-
STREETNAME
(
type: esriFieldTypeString, alias: Street name portion of the property address, length: 40
)
-
QDRNTNAME
(
type: esriFieldTypeString, alias: Quadrant name, length: 30
)
-
DELCODE
(
type: esriFieldTypeString, alias: Dead or Active SSL, length: 1
)
-
HSTDCODE
(
type: esriFieldTypeString, alias: Homestead flag, length: 1
)
-
CLASSTYPE
(
type: esriFieldTypeString, alias: Tax Class of the property, length: 3
)
-
TAXRATE
(
type: esriFieldTypeDouble, alias: Tax Rate of the Class
)
-
MIXEDUSE
(
type: esriFieldTypeString, alias: Mixed Use, length: 1
)
-
MIX1TXTYPE
(
type: esriFieldTypeString, alias: Tax type one, length: 2
)
-
MIX1CLASS
(
type: esriFieldTypeString, alias: Tax class of first mix, length: 3
)
-
MIX1RATE
(
type: esriFieldTypeDouble, alias: Tax rate for first mix
)
-
MIX1LNDPCT
(
type: esriFieldTypeDouble, alias: Percentage of the land affected by the first use type
)
-
MIX1LNDVAL
(
type: esriFieldTypeDouble, alias: Value of the land affected by the first use type
)
-
MIX1BLDPCT
(
type: esriFieldTypeDouble, alias: Percentage of the improvements affected by the first use code
)
-
MIX1BLDVAL
(
type: esriFieldTypeDouble, alias: Value of the improvements affected by the first use code
)
-
MIX2TXTYPE
(
type: esriFieldTypeString, alias: Tax type two, length: 2
)
-
MIX2CLASS
(
type: esriFieldTypeString, alias: Tax class of second mix, length: 3
)
-
MIX2RATE
(
type: esriFieldTypeDouble, alias: Tax rate for second mix
)
-
MIX2LNDPCT
(
type: esriFieldTypeDouble, alias: Percentage of the land affected by the second use type
)
-
MIX2LNDVAL
(
type: esriFieldTypeDouble, alias: Value of the land affected by the second use type
)
-
MIX2BLDPCT
(
type: esriFieldTypeDouble, alias: Percentage of the improvements affected by the second use code
)
-
MIX2BLDVAL
(
type: esriFieldTypeDouble, alias: Value of the improvements affected by the second use code
)
-
OWNOCCT
(
type: esriFieldTypeInteger, alias: Number of occupied co-op units
)
-
COOPUNITS
(
type: esriFieldTypeInteger, alias: Number of available co-op units
)
-
PCHILDCODE
(
type: esriFieldTypeString, alias: Refers to Child Lot, length: 1
)
-
ABTLOTCODE
(
type: esriFieldTypeString, alias: SSL of the abutting property, length: 12
)
-
SALEPRICE
(
type: esriFieldTypeDouble, alias: Most recent property sale price
)
-
SALEDATE
(
type: esriFieldTypeDate, alias: Most recent property sale date, length: 8
)
-
ACCEPTCODE
(
type: esriFieldTypeString, alias: Property sale acceptance code, length: 25
)
-
SALETYPE
(
type: esriFieldTypeString, alias: Type of property sale, length: 30
)
-
DEEDDATE
(
type: esriFieldTypeDate, alias: Date of deed, length: 8
)
-
ASSESSMENT
(
type: esriFieldTypeDouble, alias: Current Assessed Value Total
)
-
ANNUALTAX
(
type: esriFieldTypeDouble, alias: Current amount of annual tax
)
-
DUEDATE1
(
type: esriFieldTypeString, alias: First due date for bill, length: 10
)
-
AMTDUE1
(
type: esriFieldTypeDouble, alias: Bill amount due at first due date
)
-
DUEDATE2
(
type: esriFieldTypeString, alias: Second due date for bill, length: 10
)
-
AMTDUE2
(
type: esriFieldTypeDouble, alias: Bill amount due at second due date
)
-
DUEDATE3
(
type: esriFieldTypeString, alias: Third due date for bill, length: 10
)
-
AMTDUE3
(
type: esriFieldTypeDouble, alias: Bill amount due at third due date
)
-
TOTDUEAMT
(
type: esriFieldTypeDouble, alias: Total of all liabilities
)
-
TOTCOLAMT
(
type: esriFieldTypeDouble, alias: Total of all collections
)
-
TOTBALAMT
(
type: esriFieldTypeDouble, alias: Total balance due for property
)
-
EXTRACTDAT
(
type: esriFieldTypeDate, alias: Date of last extraction from database, length: 8
)
-
CAPCURR
(
type: esriFieldTypeDouble, alias: Cap assessment for current year
)
-
CAPPROP
(
type: esriFieldTypeDouble, alias: Cap assessment for proposed year
)
-
REASONCD
(
type: esriFieldTypeString, alias: Reason property was updated, length: 35
)
-
CY1YEAR
(
type: esriFieldTypeString, alias: CY1YEAR, length: 50
)
-
CY1TXSALE
(
type: esriFieldTypeString, alias: CY1TXSALE, length: 2
)
-
CY1TAX
(
type: esriFieldTypeDouble, alias: CY1TAX
)
-
CY1PEN
(
type: esriFieldTypeDouble, alias: CY1PEN
)
-
CY1INT
(
type: esriFieldTypeDouble, alias: CY1INT
)
-
CY1FEE
(
type: esriFieldTypeDouble, alias: CY1FEE
)
-
CY1TOTDUE
(
type: esriFieldTypeDouble, alias: CY1TOTDUE
)
-
CY1COLL
(
type: esriFieldTypeDouble, alias: CY1COLL
)
-
CY1BAL
(
type: esriFieldTypeDouble, alias: CY1BAL
)
-
CY1CR
(
type: esriFieldTypeDouble, alias: CY1CR
)
-
CY2YEAR
(
type: esriFieldTypeString, alias: CY2YEAR, length: 50
)
-
CY2TXSALE
(
type: esriFieldTypeString, alias: CY2TXSALE, length: 2
)
-
CY2TAX
(
type: esriFieldTypeDouble, alias: CY2TAX
)
-
CY2PEN
(
type: esriFieldTypeDouble, alias: CY2PEN
)
-
CY2INT
(
type: esriFieldTypeDouble, alias: CY2INT
)
-
CY2FEE
(
type: esriFieldTypeDouble, alias: CY2FEE
)
-
CY2TOTDUE
(
type: esriFieldTypeDouble, alias: CY2TOTDUE
)
-
CY2COLL
(
type: esriFieldTypeDouble, alias: CY2COLL
)
-
CY2BAL
(
type: esriFieldTypeDouble, alias: CY2BAL
)
-
CY2CR
(
type: esriFieldTypeDouble, alias: CY2CR
)
-
PY1YEAR
(
type: esriFieldTypeString, alias: PY1YEAR, length: 50
)
-
PY1TXSALE
(
type: esriFieldTypeString, alias: PY1TXSALE, length: 2
)
-
PY1TAX
(
type: esriFieldTypeDouble, alias: PY1TAX
)
-
PY1PEN
(
type: esriFieldTypeDouble, alias: PY1PEN
)
-
PY1INT
(
type: esriFieldTypeDouble, alias: PY1INT
)
-
PY1FEE
(
type: esriFieldTypeDouble, alias: PY1FEE
)
-
PY1TOTDUE
(
type: esriFieldTypeDouble, alias: PY1TOTDUE
)
-
PY1COLL
(
type: esriFieldTypeDouble, alias: PY1COLL
)
-
PY1BAL
(
type: esriFieldTypeDouble, alias: PY1BAL
)
-
PY1CR
(
type: esriFieldTypeDouble, alias: PY1CR
)
-
PY2YEAR
(
type: esriFieldTypeString, alias: PY2YEAR, length: 50
)
-
PY2TXSALE
(
type: esriFieldTypeString, alias: PY2TXSALE, length: 2
)
-
PY2TAX
(
type: esriFieldTypeDouble, alias: PY2TAX
)
-
PY2PEN
(
type: esriFieldTypeDouble, alias: PY2PEN
)
-
PY2INT
(
type: esriFieldTypeDouble, alias: PY2INT
)
-
PY2FEE
(
type: esriFieldTypeDouble, alias: PY2FEE
)
-
PY2TOTDUE
(
type: esriFieldTypeDouble, alias: PY2TOTDUE
)
-
PY2COLL
(
type: esriFieldTypeDouble, alias: PY2COLL
)
-
PY2BAL
(
type: esriFieldTypeDouble, alias: PY2BAL
)
-
PY2CR
(
type: esriFieldTypeDouble, alias: PY2CR
)
-
PY3YEAR
(
type: esriFieldTypeString, alias: PY3YEAR, length: 50
)
-
PY3TXSALE
(
type: esriFieldTypeString, alias: PY3TXSALE, length: 2
)
-
PY3TAX
(
type: esriFieldTypeDouble, alias: PY3TAX
)
-
PY3PEN
(
type: esriFieldTypeDouble, alias: PY3PEN
)
-
PY3INT
(
type: esriFieldTypeDouble, alias: PY3INT
)
-
PY3FEE
(
type: esriFieldTypeDouble, alias: PY3FEE
)
-
PY3TOTDUE
(
type: esriFieldTypeDouble, alias: PY3TOTDUE
)
-
PY3COLL
(
type: esriFieldTypeDouble, alias: PY3COLL
)
-
PY3BAL
(
type: esriFieldTypeDouble, alias: PY3BAL
)
-
PY3CR
(
type: esriFieldTypeDouble, alias: PY3CR
)
-
PY4YEAR
(
type: esriFieldTypeString, alias: PY4YEAR, length: 50
)
-
PY4TXSALE
(
type: esriFieldTypeString, alias: PY4TXSALE, length: 2
)
-
PY4TAX
(
type: esriFieldTypeDouble, alias: PY4TAX
)
-
PY4PEN
(
type: esriFieldTypeDouble, alias: PY4PEN
)
-
PY4INT
(
type: esriFieldTypeDouble, alias: PY4INT
)
-
PY4FEE
(
type: esriFieldTypeDouble, alias: PY4FEE
)
-
PY4TOTDUE
(
type: esriFieldTypeDouble, alias: PY4TOTDUE
)
-
PY4COLL
(
type: esriFieldTypeDouble, alias: PY4COLL
)
-
PY4BAL
(
type: esriFieldTypeDouble, alias: PY4BAL
)
-
PY4CR
(
type: esriFieldTypeDouble, alias: PY4CR
)
-
PY5YEAR
(
type: esriFieldTypeString, alias: PY5YEAR, length: 50
)
-
PY5TXSALE
(
type: esriFieldTypeString, alias: PY5TXSALE, length: 2
)
-
PY5TAX
(
type: esriFieldTypeDouble, alias: PY5TAX
)
-
PY5PEN
(
type: esriFieldTypeDouble, alias: PY5PEN
)
-
PY5INT
(
type: esriFieldTypeDouble, alias: PY5INT
)
-
PY5FEE
(
type: esriFieldTypeDouble, alias: PY5FEE
)
-
PY5TOTDUE
(
type: esriFieldTypeDouble, alias: PY5TOTDUE
)
-
PY5COLL
(
type: esriFieldTypeDouble, alias: PY5COLL
)
-
PY5BAL
(
type: esriFieldTypeDouble, alias: PY5BAL
)
-
PY5CR
(
type: esriFieldTypeDouble, alias: PY5CR
)
-
PY6YEAR
(
type: esriFieldTypeString, alias: PY6YEAR, length: 50
)
-
PY6TXSALE
(
type: esriFieldTypeString, alias: PY6TXSALE, length: 2
)
-
PY6TAX
(
type: esriFieldTypeDouble, alias: PY6TAX
)
-
PY6PEN
(
type: esriFieldTypeDouble, alias: PY6PEN
)
-
PY6INT
(
type: esriFieldTypeDouble, alias: PY6INT
)
-
PY6FEE
(
type: esriFieldTypeDouble, alias: PY6FEE
)
-
PY6TOTDUE
(
type: esriFieldTypeDouble, alias: PY6TOTDUE
)
-
PY6COLL
(
type: esriFieldTypeDouble, alias: PY6COLL
)
-
PY6BAL
(
type: esriFieldTypeDouble, alias: PY6BAL
)
-
PY6CR
(
type: esriFieldTypeDouble, alias: PY6CR
)
-
PY7YEAR
(
type: esriFieldTypeString, alias: PY7YEAR, length: 50
)
-
PY7TXSALE
(
type: esriFieldTypeString, alias: PY7TXSALE, length: 2
)
-
PY7TAX
(
type: esriFieldTypeDouble, alias: PY7TAX
)
-
PY7PEN
(
type: esriFieldTypeDouble, alias: PY7PEN
)
-
PY7INT
(
type: esriFieldTypeDouble, alias: PY7INT
)
-
PY7FEE
(
type: esriFieldTypeDouble, alias: PY7FEE
)
-
PY7TOTDUE
(
type: esriFieldTypeDouble, alias: PY7TOTDUE
)
-
PY7COLL
(
type: esriFieldTypeDouble, alias: PY7COLL
)
-
PY7BAL
(
type: esriFieldTypeDouble, alias: PY7BAL
)
-
PY7CR
(
type: esriFieldTypeDouble, alias: PY7CR
)
-
PY8YEAR
(
type: esriFieldTypeString, alias: PY8YEAR, length: 50
)
-
PY8TXSALE
(
type: esriFieldTypeString, alias: PY8TXSALE, length: 2
)
-
PY8TAX
(
type: esriFieldTypeDouble, alias: PY8TAX
)
-
PY8PEN
(
type: esriFieldTypeDouble, alias: PY8PEN
)
-
PY8INT
(
type: esriFieldTypeDouble, alias: PY8INT
)
-
PY8FEE
(
type: esriFieldTypeDouble, alias: PY8FEE
)
-
PY8TOTDUE
(
type: esriFieldTypeDouble, alias: PY8TOTDUE
)
-
PY8COLL
(
type: esriFieldTypeDouble, alias: PY8COLL
)
-
PY8BAL
(
type: esriFieldTypeDouble, alias: PY8BAL
)
-
PY8CR
(
type: esriFieldTypeDouble, alias: PY8CR
)
-
PY9YEAR
(
type: esriFieldTypeString, alias: PY9YEAR, length: 50
)
-
PY9TXSALE
(
type: esriFieldTypeString, alias: PY9TXSALE, length: 2
)
-
PY9TAX
(
type: esriFieldTypeDouble, alias: PY9TAX
)
-
PY9PEN
(
type: esriFieldTypeDouble, alias: PY9PEN
)
-
PY9INT
(
type: esriFieldTypeDouble, alias: PY9INT
)
-
PY9FEE
(
type: esriFieldTypeDouble, alias: PY9FEE
)
-
PY9TOTDUE
(
type: esriFieldTypeDouble, alias: PY9TOTDUE
)
-
PY9COLL
(
type: esriFieldTypeDouble, alias: PY9COLL
)
-
PY9BAL
(
type: esriFieldTypeDouble, alias: PY9BAL
)
-
PY9CR
(
type: esriFieldTypeDouble, alias: PY9CR
)
-
PY10YEAR
(
type: esriFieldTypeString, alias: PY10YEAR, length: 50
)
-
PY10TXSALE
(
type: esriFieldTypeString, alias: PY10TXSALE, length: 2
)
-
PY10TAX
(
type: esriFieldTypeDouble, alias: PY10TAX
)
-
PY10PEN
(
type: esriFieldTypeDouble, alias: PY10PEN
)
-
PY10INT
(
type: esriFieldTypeDouble, alias: PY10INT
)
-
PY10FEE
(
type: esriFieldTypeDouble, alias: PY10FEE
)
-
PY10TOTDUE
(
type: esriFieldTypeDouble, alias: PY10TOTDUE
)
-
PY10COLL
(
type: esriFieldTypeDouble, alias: PY10COLL
)
-
PY10BAL
(
type: esriFieldTypeDouble, alias: PY10BAL
)
-
PY10CR
(
type: esriFieldTypeDouble, alias: PY10CR
)
-
LASTPAYDT
(
type: esriFieldTypeDate, alias: LASTPAYDT, length: 8
)
-
OWNNAME2
(
type: esriFieldTypeString, alias: OWNNAME2, length: 70
)
-
INST_NO
(
type: esriFieldTypeString, alias: INST_NO, length: 50
)
-
MORTGAGECO
(
type: esriFieldTypeString, alias: MORTGAGECO, length: 50
)
-
NBHDNAME
(
type: esriFieldTypeString, alias: NBHDNAME, length: 50
)
-
PRMS_WARD
(
type: esriFieldTypeString, alias: PRMS_WARD, length: 50
)
-
PRESSL
(
type: esriFieldTypeString, alias: PRESSL, length: 12
)
-
PIPARENTLOT
(
type: esriFieldTypeString, alias: PIPARENTLOT, length: 50
)
-
BIDNAME
(
type: esriFieldTypeString, alias: BIDNAME, length: 50
)
-
BIDTOTALDUE
(
type: esriFieldTypeDouble, alias: BIDTOTALDUE
)
-
BIDCOLLECTED
(
type: esriFieldTypeDouble, alias: BIDCOLLECTED
)
-
BIDBALANCE
(
type: esriFieldTypeDouble, alias: BIDBALANCE
)
-
SEWSTOTALDUE
(
type: esriFieldTypeDouble, alias: SEWSTOTALDUE
)
-
SEWSCOLLECTED
(
type: esriFieldTypeDouble, alias: SEWSCOLLECTED
)
-
SEWSBALANCE
(
type: esriFieldTypeDouble, alias: SEWSBALANCE
)
-
PACETOTALDUE
(
type: esriFieldTypeDouble, alias: PACETOTALDUE
)
-
PACECOLLECTED
(
type: esriFieldTypeDouble, alias: PACECOLLECTED
)
-
PACEBALANCE
(
type: esriFieldTypeDouble, alias: PACEBALANCE
)
-
SWWSADTOTALDUE
(
type: esriFieldTypeDouble, alias: SWWSADTOTALDUE
)
-
SWWSADCOLLECTED
(
type: esriFieldTypeDouble, alias: SWWSADCOLLECTED
)
-
SWWSADBALANCE
(
type: esriFieldTypeDouble, alias: SWWSADBALANCE
)
-
INTERNALID
(
type: esriFieldTypeDouble, alias: INTERNALID
)
-
OBJECTID
(
type: esriFieldTypeOID, alias: OBJECTID
)
Supported Operations:
Query
Query Attachments
Query Analytic
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata