A People’s History of
the New York City Property Tax System
Current Property Tax Rate
Effective Property Tax Rate
Effective Property Tax Rate
Class 1: 0.06 * 0.19191 = 1.2%
Class 2: 0.45 * 0.13145 = 5.9%
Current State of Affairs
Collaborate
Apps Script, BigQuery
vs. New York City Property Tax
Which will win?
Why should you care?
Common Wisdom
I’m a renter, it doesn’t affect me.
I don’t live in New York City, it doesn’t affect me.
Property tax are low
Furman Center Study
Missing ? Dollars
Cost of universal preschool
But one way or another, you have to spend money to create a high-quality, universal preschool program. One group estimated that it could cost $4 billion to create one in New York. De Blasio is willing to put his money where his campaign promise is with his tax on the wealthy,
which is expected to bring in about $530 million a year, enough to cover the $340 million price tag for the city. Cuomo, on the other hand, made his quick preschool reference in the State of the State amid a big, concrete plan to lower taxes. He just unveiled a $2 billion package of reduced taxes for businesses, renters, property owners
and upstate manufacturers. In his address, “He mentioned the word tax or taxes about 40 times, mostly to make the assertion that he had managed to drive them down,” The New York Times reports. That $2 billion means $2 billion less in revenues that the state could use on early childhood education.
DeBlasio Plan
How many property values
in the NYC DOF database?
Actually
24
Land Value
Total Value
Assessed
Exempt
Actual vs. Transitional
Current,
Final,
Tentative
2*2*2*3
=24
Current Actual Assessed Land Value
Current Actual Assessed Total Value
Current Actual Exempt Land Value
Current Actual Exempt Total Value
Current Transitional Assessed Land Value
Current Transitional Assessed Total Value
Current Transitional Exempt Land Value
Current Transitional Exempt Total Value
Final Actual Assessed Land Value
Final Actual Assessed Total Value
Final Actual Exempt Land Value
Final Actual Exempt Total Value
Final Transitional Assessed Land Value
Final Transitional Assessed Total Value
Final Transitional Exempt Land Value
Final Transitional Exempt Total Value
Tentative Actual Assessed Land Value
Tentative Actual Assessed Total Value
Tentative Actual Exempt Land Value
Tentative Actual Exempt Total Value
Tentative Transitional Assessed Land Value
Tentative Transitional Assessed Total Value
Tentative Transitional Exempt Land Value
Tentative Transitional Exempt Total Value
Why?
Venn
Why?
Security by
Obscurity
"If you don't find it in the index, look carefully through the entire catalogue." — Sears Roebuck catalogue of 1897.
An answer is
Adding users to MySQL
mysql> CREATE USER 'monty'@'localhost' IDENTIFIED BY 'some_pass';�mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'� -> WITH GRANT OPTION;�mysql> CREATE USER 'monty'@'%' IDENTIFIED BY 'some_pass';�
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%'� -> WITH GRANT OPTION;�mysql> CREATE USER 'admin'@'localhost';�mysql> GRANT RELOAD,PROCESS ON *.* TO 'admin'@'localhost';�mysql> CREATE USER 'dummy'@'localhost';
Another answer is
Demonstration of using
How did this happen?
“If you clean a ship or put a new ship to sea, it’s coated with microbes within a day,” said Van Mooy. “Not enough to see, but the first microbes are starting to lie down.
And then the slime begins to grow over the course of weeks. That is essentially a gateway community to the barnacles and other things.”
“The slime” is a biofilm, a thin sheet of bacteria that stick to each other and to a matrix of molecules they exude to communicate with each other and to provide a hospitable environment for themselves.
Once the slime forms, the rush is on, as algae and the larvae of creatures such as barnacles attach and begin to grow.
RES_UNIT, TOT_UNIT, EX_COUNT, CUREXT_A, TN_EXL, DELCHG, BORO, EXT, TN_EXT, NOAV, FN_EXT_A, FN_EXL_A, APPLIC2, CUREXL_A, CONDO_S3, CONDO_S2, CONDO_S1, YRB_FLAG, PROTEST, TN_AVL_A, AP_TIME, COMINT_B, ZIP,
NEW_FV_L, NEWLOT, BLDGS, COMINT_L, NEW_FV_T, O_AT_GRP, NODESC, YRA2_RNG, COOP_NUM, BLD_VAR, REUC, YRA2, YRA1, DROPLOT, [LIMIT], CP_DIST, CUR_FV_L, TXCL, CURAVL, L_ACRE, O_LIMIT, CUR_FV_T, BLOCK, CURAVT, DCHGDT,
TN_EXT_A, AP_BLOCK, APPLIC, CORCHG, AT_GRP, CHGDT, TN_EXL_A, APTNO, EX_CHGDT, GEO_RC, FCHGDT, STATUS1, DISTRICT, STATUS2, TN_AVT_A, FN_AVT, VALREF, CONDO_NM, GR_SQFT, CUREXT, O_TXCL, CORNER, CUREXL, EASE, CP_BORO, YEAR4, FN_AVL_A,
CONDO_A, BLDGCL, MBLDG, YRB, FV_CHGDT, FN_EXT, AP_LOT, BFRT_DEC, AT_GRP2, FN_EXL, IRREG, TN_AVT, AP_BORO, FN_AVL, LND_AREA, O_PROTST, YRB_RNG, SM_CHGDT, BBLE, SECVOL, BDEP_DEC, TN_AVL, O_APPLIC,
IDEAS
USE HADOOP, PIG
to GET/PROCESS DATA
COMPUTE ENGINE
What next?
Local Law 11 of 2012 – Publishing Open Data
See http://www.nyc.gov/html/doitt/html/open/local_law_11_2012.shtml
Pick information and make it truly transparent
What next?
Appendix
23-505 Internet data set policy and technical standards
a. Within one hundred eighty days of the effective date of this chapter, the department shall prepare and publish a technical standards manual for the publishing of public data sets in raw or unprocessed form through a single web portal by city agencies for the purpose of making public data available to the greatest number of users and for the greatest number of applications and shall, whenever practicable,
use open standards for web publishing and e-government. Such manual shall identify the reasons why each technical standard was selected and for which types of data it is applicable and may recommend or require that data be published in more than one technical standard. The manual shall include a plan to adopt or utilize a web application programming interface that permits application programs to request and receive public data sets directly from the web portal. Such manual shall be updated by the department as necessary.
Local Civic Developer Group