We should all thank Noel. See http://legistar.council.nyc.gov/MeetingDetail.aspx?ID=304808&GUID=BE632D0E-7B62-4660-A260-B3082B9886F8&Search=#
I recommend that everyone listen to it and participate.
One of the topics was how can we make the data more accessible.
One way to access our public data is to load the data in a place where you can query it directly.
This data started at the NYC Department of Finance as a compressed MDB file. For those that don't know that is a Microsoft Access File. Why is our public data distributed in a proprietary format? See http://www.nyc.gov/html/dof/html/property/assessment.shtml
You can run a query such as:
- SELECT '>=[masked]',count(*),sum(fn_avt)/sum(new_fv_t) FROM [personal-real-estate:acris_nyc.nyc_dof_tc_Tentative_Assessment_Roll] where txcl='1' and new_fv_t >=[masked]
This Query is used to show for market value greater than or equal to $10 Million what is the sum of assessment values / sum of market values
- Answer at this point in time is 3%
- While for <[masked] it is 4.6%
- A very regressive tax. The lower market home pay a much larger tax as a percentage of market value.
For a history of how it was made public (Many thanks to @felipehoffa at Google) see: https://twitter.com/fedex1/status/458376165032353792
It seemed that only Mr. Vacca and Mr. Weprin attended.
Committee Green Sheet
Committee on Technology
James Vacca, Chair
Members: Annabel Palma, Mark S. Weprin,
David G. Greenfield and Steven Matteo
On Thursday, April 17,[masked]:34:08 PM UTC-4, Noel Hidalgo wrote:
After last month's gas leak, I've been asked by CM Vacca to ask YOU to come to next week's CC Committee on technology. Next Wednesday's hearing on using technology to proactively address health and safety issues. < http://on.nyc.gov/1peiXhB
* Better data analysis to find vulnerabilities in the City's infrastructure.
* Crowd sourced tools to inform the city of water quality within buildings.
* Better health inspection score data to prevent trips to the emergency room.
* Notifications on sanitation issues around the city.
* Notification tools on air quality, regardless of air quality status.
* Better NYPD public safety data.
This is your chance to give CM Vacca and the City Council a few idea on how to improve the future.
If anyone is interested in giving testimony, please let me know. I can give you some tips on giving testimony.