Sunday, June 8, 2014

NYC Tax Assessment Ratio for our public representatives

For those that do not know the NYC Property Tax system is very simple.  Please do not allow public representatives to tell you that it is very complicated and if they do, ask them what do they mean.

The complexity is in changing our property tax system to make it more equally applied.  As in the phrase "nor deny to any person within its jurisdiction the equal protection of the laws".  If this phrase sounds familiar it is because it is the ending text of our 14th Amendment to our US Constitution.
(see http://en.wikipedia.org/wiki/Equal_Protection_Clause#Text)

Also from our New York State Constitution: The legislature shall provide for the supervision, review and equalization of assessments for purposes of taxation. Assessments shall in no case exceed full value. (see http://www.dos.ny.gov/info/constitution.htm)

From our New York State Department of Taxation and Finance: Equalization rates do not correct unfair assessments within a municipality.

Equalization rates measure the level of assessment for the entire municipality. They are not intended to correct unfair individual assessments in a city or town. The assessor has the primary role in ensuring the fairness of individual assessments. The more frequently properties are reassessed based on current market values, the more likely it will be that assessments are fair. Property owners also have a role to ensure their individual assessments are fair.
(see http://www.tax.ny.gov/pit/property/learn/eqrates.htm)

Here's a spreadsheet that shows current and past public representatives and their property tax assessment ratio.  The property tax assessment ratio is the property total assessed value  divided by the property total market value.  It is by law set at 6%.  But you'll see that it is rarely 6% unless you live in Queens and the Bronx and Staten Island (this is shown in the data)



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