Hacks and Hackers Rochester Meetup - Neighborhood Data Map

Hacks and Hackers Rochester had a absolutely fantastic meetup this past Thursday, November 7th, 2013. We were lucky enough to have Pam Delaney and Harry Fits from the Rochester Department of Neighborhood & Business Development come in and talk to us about their Neighborhood Data Map tool!

We started the meetup off with introductions from those attending and I spoke briefly of what HHRoc is, and some of the projects we currently have going on. The goal of the meeting was to provide a platform for Pam and Harry to present the Data Map.

Below are the notes that Remy Decausemaker took during the meeting. I cleaned them up just slightly.

Back Story

About 1.5 years ago, Pam got a request from Beechwood community. They wanted to do some "down zoning" properties from multi to single family households. No one was keeping track of this, so Pam offered to provide a picture of the neighborhood. Pam decided to brake the neighborhood down into 7 areas, with 10 variables for each area. Went to a public meeting, divided into 7 tables based on natural boundaries, and then looked at maps, and came up with action items based on the data they saw.

It was a revelation of "wow, people want data". The people within the neighborhood were lower-middle income level, and they were working to come up with strategies to 'fix' their neighborhood. They weren't going to city hall, hocking for grants, but actually doing things to work toward making a difference.

After this realization that people from within the city would want this data, and would actually use it to work to make their particular slice of the world better, Pam brought it to her Administration. Carlos Carballada, told us to do this for each "quad". They told us to pick 3 other neighborhoods to do exactly what was done with the Beechwood inhabitants.

Pam said she had seen other cities that had done "quality of life" studies, but her and Harry thought "why not the whole city?". Lets get data out to the whole city. At first Pam and Harry though it would be a paper doc, but small groups with city departments. The document was, originally, going to have a ranking system, variables weighed, scored neighborhoods. This was controversial, so they didn't do that.

Implementation

Pam and Harry decided to use GIS. They created a table, based on census block groups. No one in city could decide on neighborhood boundaries. "lets do census level" so there would be no controversy". tabulated the data, built this doc, and then said "we've done ARCGIS explorer, why not interactive?"

Pam and Harry built this whole thing, based on 2012 data. Some data is a "snapshot" of data on one day. Crime rates for the whole year, for example, were tabulated from annual rates. We were ready with data in roughly March.

"let's go live!"

They got push back.

They wanted to make sure that the format made sense. They tested the tool with various neighborhood groups and got lots of feedback - Everyone liked it. After a few weeks, they got the green light to move forward.

"It's basic, we're not super technical, and we're using a Free Software for now." -Pam

There's no "live feed" with data, and that is okay. Explorer is a free client, anyone can go to ESRI, pull down csv's of data, and build your own maps for free. That being said, it is severely limited. They are going to stop supporting it in December - it will be paid only. Pam talked with their new coordinator, who says we'll be getting the paid version soon. It has more functionality, but will still be basic because neighborhood groups will be the target audience.

Demo

Raw Notes:

  • 3 components:
    • click and identify
      • search by address
    • Aggregating up to a larger level
      • shift+select multiple block groups
      • created a dashboard, which we manually created each thing shown here.
      • We did ones we though most peoples would ask for. it will aggregate things, or give a sum. it will also average... we wanted to do median.
      • ESRI does average, we did median during our information gathering... some city data is available as city data, which was newer. We used
      • RCSD for # of school kids, instead of census, as it is more accurate.
      • we foiled most of this data ourselves, or it was pulled from NBD data we had available. Assessment dept does a daily snapshot, we have the address of the parcel, and the mailing address. if they are different, we assume it is a rental property.
      • Monroe crime analysis center
        • state funded, shared city/county resource
        • city/state/sheriff budgets for diff things, comes out of year
        • IMPACT grant

Wrap-up

The tool's data will be updated in February 2013. Want to add "change" for next year, so users can see diff between this year and last. We had requests, but we didn't want to use data that we hadn't collected ourselves. We'll probably lump it into 4 year spreads.

Pam and Harry want to overlay diff variables on each other in the future. You can't do that with this software, but with full version in the future, maybe later.

They created a "base map" for every variable. You can flip through it, but you can't change the colors in a piece of paper (obv).

More GIS data here: http://cityofrochester.gov/gis

You can contact Pam and Harry here: neighborhooddata@cityofrochester.gov