addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobegmailgooglegroupshelp-with-circleimageimagesinstagramlinklocation-pinm-swarmSearchmailmessagesminusmoremuplabelShape 3 + Rectangle 1ShapeoutlookpersonJoin Group on CardStartprice-ribbonShapeShapeShapeShapeImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruserwarningyahoo

Re: An opportunity to tell City Council about tech 2 PROACTIVELY address health and safety.

From: Ralph Y.
Sent on: Thursday, April 24, 2014 12:10 PM
We should all thank Noel.  See

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


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: 

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. < >


* 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.
* Etc...

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.


People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy