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

Sunday, May 11, 2014

GDG growth over time and space :)

#gdg #io14 #photo



See http://gdg.brooklyncoop.org/io#attendees for a preliminary visualization of GDG  - Google Developer Group (https://developers.google.com/groups/) attendance over time and space.

The size of the bubble relates to the number of attendees for that particular GDG meeting.

Note: the numbers are preliminary :)

Thursday, May 8, 2014

Wednesday, May 7, 2014

2014 Brooklyn Businesses that Lost Tax Exempt Status

Here it is: a map of 2014 Brooklyn Businesses that Lost Tax Exempt Status.

source: https://opendata.socrata.com/api/views/adkv-6cqd/rows.pdf?app_token=U29jcmF0YS0td2VraWNrYXNz0


Thursday, May 1, 2014

Map of some FAA Five Letter Location Fixes

Does anyone know where all the FAA 5 Letter Location Fixes exist for download?

See http://www.faa.gov/air_traffic/publications/atpubs/lid/L_PD.htm

This seems to be a subset of the entire set.

Zoom out to see more locations.

Presentation at Civic Meeting (BetaNYC) about Property Tax Analysis and Reform


Friday, April 25, 2014

New York City Class 1 Property Tax Assessment Ratio Map by Zipcode

The Assessment Ratio is the Assessed Value divided by the Market Value.
Yellow is low and Purple is high.

It appears Park Slope and surrounding areas and others lead the list in paying the lowest property tax assessment ratio.


For access to a query ready data see https://bigquery.cloud.google.com/table/personal-real-estate:acris_nyc.nyc_dof_tc_Tentative_Assessment_Roll?pli=1


For the original in Microsoft Access format see http://www.nyc.gov/html/dof/html/property/assessment.shtml