Sunday, June 1, 2014

New York City Property Tax: Largest Increases by percentage (Class 1 only)

Here's a list of Class 1 properties in New York City where the assessed value is increased by the largest percentage.

The assessed value directly affects the property tax paid by these properties and their owners.


Direct document link: https://docs.google.com/spreadsheets/d/1QBGQ9RtPF4UPDtaAGkJe4JuzMenNdKVva4_QYkb-1Lw/pubhtml

Direct spreadsheet link: https://docs.google.com/spreadsheets/d/1QBGQ9RtPF4UPDtaAGkJe4JuzMenNdKVva4_QYkb-1Lw/edit?usp=sharing




source: http://www.nyc.gov/html/dof/html/property/assessment.shtml

To access the source data in a format that can be queried directly see:



The query used to generate this data:

select (max(fn_avt)-min(fn_avt))/min(fn_avt) percentdelta, max(fn_avt), min(fn_avt),SOA.nm_recipient_1,SOA.nm_recipient_2,SOA.AD_NAME_ATTENTION,SOA.ad_street_no,SOA.ad_street_1,SOA.ad_street_2,SOA.AD_CITY,SOA.CD_ADDR_STATE,SOA.CD_ADDR_ZIP,SOA.AD_STREET_NO_PROP,SOA.AD_STREET_1_PROP,SOA.AD_CITY_PROP,SOA.CD_ADDR_STATE_PROP,SOA.CD_ADDR_ZIP_PROP,boro,block,lot from [nyc.assessment] ASSESS join each (select nm_recipient_1,nm_recipient_2,AD_NAME_ATTENTION,ad_street_no,ad_street_1,ad_street_2,AD_CITY,CD_ADDR_STATE,CD_ADDR_ZIP,AD_STREET_NO_PROP,AD_CITY_PROP,CD_ADDR_STATE_PROP,CD_ADDR_ZIP_PROP,AD_STREET_1_PROP,id_boro,id_block,id_lot from [acris_nyc.nyc_dof_SOA]) SOA on ASSESS.boro = SOA.id_boro and ASSESS.block = SOA.id_block and ASSESS.lot = SOA.id_lot where ASSESS.owner like '%'  group by boro,block,lot,SOA.AD_STREET_1_PROP,SOA.nm_recipient_1,SOA.nm_recipient_2,SOA.AD_NAME_ATTENTION,SOA.ad_street_no,SOA.ad_street_1,SOA.ad_street_2,SOA.AD_CITY,SOA.CD_ADDR_STATE,SOA.CD_ADDR_ZIP,SOA.AD_STREET_NO_PROP,SOA.AD_CITY_PROP,SOA.CD_ADDR_STATE_PROP,SOA.CD_ADDR_ZIP_PROP order by percentdelta desc


Direct document link: https://docs.google.com/spreadsheets/d/1QBGQ9RtPF4UPDtaAGkJe4JuzMenNdKVva4_QYkb-1Lw/pubhtml

Direct spreadsheet link: https://docs.google.com/spreadsheets/d/1QBGQ9RtPF4UPDtaAGkJe4JuzMenNdKVva4_QYkb-1Lw/edit?usp=sharing