Data Dictionary - Dataset Information

General
Dataset Name Property Valuation and Assessment data Tax Classes 2,3,4
Agency Name Department of finance
Update Frequency Annually
Dataset Description Real Estate Assessment Property data
Dataset Keywords Property, Assessment, Evaluation
Dataset Category City Government

Detailed Description
List any additional information in order to
provide context to the data for someone not
familiar with your agency's operations.
Data Dictionary - Column Information

Additional Notes
(where applicable, include the range of possible values, units of measure, how to
interpret null/zero values, whether there are specific relationships between columns,
Column Name Column Description Term, Acronym, or Code Definitions and information on column source)
PARID PARID uniquely identifies each assessment record PARID Key - This field is a combination of Boro, Block, Lot, Easement & Sub-ID (only
record type 3 properties have a sub-id all other record types will have 10 blanks at the end
of the field)
BORO Borough Borough Codes:
1 = Manhattan
2 = Bronx
3 = Brooklyn

4 = Queens
5 = Staten Island
BLOCK Valid Block Ranges
Manhattan: 1 to 2255
Bronx: 2260 to 5958
Brooklyn: 1 to 8955
Queens: 1 to
16350
Staten Island: 1 to 8050
LOT Unique number within BORO/BLOCK
EASEMENT
Easement
A = Air Rights
B = Non-Air Rights
E = Land Easement

F thru M = Used when property has

more than one easements

N = Non-Transit
P = Piers
R = Railroads
S = Street
U = U.S.
Government
SUBIDENT_REUC REUC only (Rectype = 2 or 3)
1 = ORE
RECTYPE 2 = REUC Ident

Record Type 3 = REUC Sub Ident

YEAR Four digit year YYYY
IDENT REUC only (Rectype = 2 or 3)
SUBIDENT
ROLL_SECTION REUC only (Rectype = 2 or 3)
 9 - 1 to 19 - 06
SECVOL Brooklyn: 1-
1 to 26 - 05
Queens: 1 - 1 to 63 - 03

Section Volume Number (2 Digits each) Staten Island: 1 - 1 to 32 - 03 Only Rectype = 1

PYMKTLAND Market Assessed Land Value Values as of the Final Roll for the Previous Tax Year
PYMKTTOT Market Assessed Total Value Values as of the Final Roll for the Previous Tax Year
PYACTLAND Actual Assessed Land Value Values as of the Final Roll for the Previous Tax Year
PYACTTOT Actual Assessed Total Value Values as of the Final Roll for the Previous Tax Year
PYACTEXTOT Actual Exemption Total Value Values as of the Final Roll for the Previous Tax Year
PYTRNLAND Transitional Assessed Land Value Values as of the Final Roll for the Previous Tax Year
PYTRNTOT Transitional Assessed Total Value Values as of the Final Roll for the Previous Tax Year
PYTRNEXTOT Transitional Exemption Total Value Values as of the Final Roll for the Previous Tax Year
PYTXBTOT Taxable Assessed Total Values as of the Final Roll for the Previous Tax Year
PYTXBEXTOT Taxable Exemption Total Values as of the Final Roll for the Previous Tax Year
PYTAXCLASS Property Tax Class Values as of the Final Roll for the Previous Tax Year
TENMKTLAND Tentative Market Assessed Land Value Values as of the publishing of the Tentative Assessment Roll in January
TENMKTTOT Tentative Market Assessed Total Value Values as of the publishing of the Tentative Assessment Roll in January
TENACTLAND Tentative Actual Assessed Land Value Values as of the publishing of the Tentative Assessment Roll in January
TENACTTOT Tentative Actual Assessed Total Value Values as of the publishing of the Tentative Assessment Roll in January
TENACTEXTOT Tentative Actual Exemption Total Value Values as of the publishing of the Tentative Assessment Roll in January
TENTRNLAND Tentative Transitional Assessed Land Value Values as of the publishing of the Tentative Assessment Roll in January
TENTRNTOT Tentative Transitional Assessed Total Value Values as of the publishing of the Tentative Assessment Roll in January
TENTRNEXTOT Tentative Transitional Exemption Total Value Values as of the publishing of the Tentative Assessment Roll in January
TENTXBTOT Tentative Taxable Assessed Total Values as of the publishing of the Tentative Assessment Roll in January
TENTXBEXTOT Tentative Taxable Exemption Total Values as of the publishing of the Tentative Assessment Roll in January
TENTAXCLASS Property Tax Class Values as of the publishing of the Tentative Assessment Roll in January
CBNMKTLAND Change By Notice Market Assessed Land Value Values as of the Change By Notice period in May
CBNMKTTOT Change By Notice Market Assessed Total Value Values as of the Change By Notice period in May
CBNACTLAND Change By Notice Actual Assessed Land Value Values as of the Change By Notice period in May
CBNACTTOT Change By Notice Actual Assessed Total Value Values as of the Change By Notice period in May
CBNACTEXTOT Change By Notice Actual Exemption Total Value Values as of the Change By Notice period in May
CBNTRNTLAND Change By Notice Transitional Assessed Land Value Values as of the Change By Notice period in May
CBNTRNTOT Change By Notice Transitional Assessed Total Value Values as of the Change By Notice period in May
CBNTRNEXTOT Change By Notice Transitional Exemption Total Value Values as of the Change By Notice period in May
CBNTXBTOT Change By Notice Taxable Assessed Total Value Values as of the Change By Notice period in May
CBNTXBEXTOT Change By Notice Taxable Exemption Total Value Values as of the Change By Notice period in May
CBNTAXCLASS Property Tax Class Values as of the Change By Notice period in May
FINMKTLAND Final Market Assessed Land Value Values as of the publishing of the Final Assessment Roll in May
FINMKTTOT Final Market Assessed Total Value Values as of the publishing of the Final Assessment Roll in May
FINACTLAND Final Actual Assessed Land Value Values as of the publishing of the Final Assessment Roll in May
FINACTTOT Final Actual Assessed Total Value Values as of the publishing of the Final Assessment Roll in May
FINACTEXTOT Final Actual Exemption Total Value Values as of the publishing of the Final Assessment Roll in May
FINTRNLAND Final Transitional Assessed Land Value Values as of the publishing of the Final Assessment Roll in May
FINTRNTOT Final Transitional Assessed Total Value Values as of the publishing of the Final Assessment Roll in May
FINTRNEXTOT Final Transitional Exemption Total Value Values as of the publishing of the Final Assessment Roll in May
FINTXBTOT Final Taxable Assessed Total Value Values as of the publishing of the Final Assessment Roll in May
FINTXBEXTOT Final Taxable Exemption Total Value Values as of the publishing of the Final Assessment Roll in May
FINTAXCLASS Property Tax Class Values as of the publishing of the Final Assessment Roll in May
CURMKTLAND Current Market Assessed Land Value Most current Values for this property
CURMKTTOT Current Market Assessed Total Value Most current Values for this property
CURACTLAND Current Actual Assessed Land Value Most current Values for this property
CURACTTOT Current Actual Assessed Total Value Most current Values for this property
CURACTEXTOT Current Actual Exemption Total Value Most current Values for this property
CURTRNLAND Current Transitional Assessed Land Value Most current Values for this property
CURTRNTOT Current Transitional Assessed Total Value Most current Values for this property
CURTRNEXTOT Current Transitional Exemption Total Value Most current Values for this property
CURTXBTOT Current Taxable Assessed Total Value Most current Values for this property
CURTXBEXTOT Current Taxable Exemption Total Value Most current Values for this property
CURTAXCLASS Property Tax Class Most current Values for this property
Field values are as follows:
0 = Starting value for the new Assessment Year (only the prior year
fields should have values)
1 = Tentative Roll has been published (Prior Year and
Tentative fields have values)
2 = Change by Notice Period has ended (Prior Year,
Tentative and CBN fields have values)
3 = Final Roll has been published (Prior
Year, Tentative, CBN and final fields have values)
4 = A Remission has been entered for
PERIOD this property (either AV or EX)
Indicates that the lot will be dropped at the end of the fiscal
NEWDROP year 1 = New lot (The drop lot indicator will be updated later)
NOAV A building in progress 1 = A building in progress
VALREF The parcel's values are reflected in another lot Y = The parcel's values are reflected in another lot
BLDG_CLASS Building Class There is a direct correlation between the Building Class and the Tax Class
OWNER Owner's Name Primary Owner of the property.
ZONING Zoning code from NYC Department of City Planning
HOUSENUM_LO The lowest house number of the property
HOUSENUM_HI The highest house number of the property
STREET_NAME Street Name for the property
ZIP_CODE Postal Zip code for the property
Blank = No Geosupport processing attempted
00 = Verified by Geosupport
All other values = Geosupport
GEOSUPPORT_RC Status of the address data verification from Geosupport exception existed
STCODE Street Code 10 Digit street code prefaced by borough code
LOT_FRT Lot Frontage in feet
LOT_DEP Lot Depth in feet
LOR_IRREG Irregular shaped lot 1 = Irregularly shaped lot
BLD_FRT Building Frontage in feet
BLD_DEP Building Depth in feet
E = Extension
G = Garage
BLD_EXT Extension EG = Extension and Garage
BLD_STORY The number of stories/floors for the building
CORNER The code to indicate a corner lot on two streets VALUES - 'NE', 'NW', 'SE', 'SW', AND 'CR'.
LAND_AREA Total Land Area If not 0, Total Land Area
NUM_BLDG The Number of Buildings on the property
YRBUILT The year the building was constructed
YRBUILT_RANGE The last year of the range If built over several years, this last year of the range. Otherwise it is 0
YRBUILT_FLAG Year Built is an estimate E = Year Built is an estimate
YRALT1 Year of alteration If building was altered, this is year of alteration
YRALT1_RANGE Last year of the alteration If alteration took more than 1 year, this is the last year of the alteration
YRALT2 Year of second alteration If building class was altered twice, this is year of second alteration
YRALT2_RANGE Last year of the second alteration If 2nd alteration took more than 1 year, this is last year of the alteration
COOP_APT Number of residential units
UNITS Contains the ident number (alpha/numeric) for REUC properties
Contains the ident number (alpha/numeric) for REUC (Real Estate of
REUC_REF properties Utility Corporations Tax Class 3 only)
APTNO Apartment Number for condominium properties
COOP_NUM Coop identification number
Borough code (1 - 5) for the community
CPB_BORO Borough code planning board
CPB_DIST Community planning board number
APPT_DATE Date of the most recent apportionment
APPT_BORO Apportionment Borough
APPT_BLOCK Apportionment Block
APPT_LOT Apportionment Lot
APPT_EASE Apportionment Easement
CONDO_Number Condo identification number
R=
Residential
Blank =
Entire condo is either all residential or all
CONDO_SFX1 commercial
CONDO_SFX2 Suffix 1 sequence number
CONDO_SFX3 Not Used
UAF_LAND Land percent of common interest in the entire condo
UAF_BLDG Building percent of common interest in the condo
 1st
character 1 = form TC101 (generally for
classes 2 and 4)
5 = form TC105 (REUC)
6 = form TC106 ( reclass)
8 = form TC108
(class 1 ) 9
= form TC109 (condos)
2nd character indicates duplicate
3rd character
PROTEST_1 Protest code not used
PROTEST_2 Indicates a second protest on the property Same Protest Codes
PROTEST_OLD Same codes as the protest indicator Same Protest Codes
ATTORNEY_GROUP1 Protest Attorney identification number
ATTORNEY_GROUP2 Protest Attorney identification number
ATTORNEY_GROUP_OLD Protest Attorney identification number
GROSS_SQFT Gross Square Footage of the building
HOTEL_AREA_GROSS Hotel Area Gross Square Footage
OFFICE_AREA_GROSS Office Area Gross Square Footage
RESIDENTIAL_AREA_GROSS Residential Area Gross Square Footage
RETAIL_AREA_GROSS Retail Area Gross Square Footage
LOFT_AREA_GROSS Loft Area Gross Square Footage
FACTORY_AREA_GROSS Factory Area Gross Square Footage
WAREHOUSE_AREA_GROSS Warehouse Area Gross Square Footage
STORAGE_AREA_GROSS Storage Area Gross Square Footage
GARAGE_AREA Garage Area Gross Square Footage
OTHER_AREA_GROSS Other Area Gross Square Footage
REUC_DESCRIPTION REUC Description
EXTRACTDT Data extract date YYYYMMDD
PYTAXFLAG Taxable Flag T' = Taxable, 'A' = Actual or blank
TENTAXFLAG Tentative Taxable Flag T' = Taxable, 'A' = Actual or blank
CBNTAXFLAG Change By Notice Taxable Flag T' = Taxable, 'A' = Actual or blank
FINTAXFLAG Final Taxable Flag T' = Taxable, 'A' = Actual or blank
CURTAXFLAG Current Taxable Flag T' = Taxable, 'A' = Actual or blank
Data Dictionary - Revision History
Description of all changes to the format, data, or method of collection of the dataset that have
taken place since the initial release.

Version Date Change Highlights Comments

1 6/30/2019
Dropdown Options
Update Frequency
Biannually
Triannually
Quarterly
Monthly
Bimonthly
Weekly
Biweekly
Daily
Several times per day
As needed
Historical

Dataset Category
City Government
Education
Environment
Health
Housing & Development
Public Safety
Recreation
Social Services
Transportation