Brelsford, as part of 596 Acres, has joined forces with Partner & Partners and SmartSign to create an online map showing over 150 master plans for neighborhoods adopted by the City of New York. The process covered the follow up on a Freedom of Information Law request for the records and the translation of paper plans into machine-readable spreadsheets. The result, after two years of work, is urbanreviewer.org a map where you can take a look at which areas in New York have been affected and what those master plans were.
Master plans have been created for many cities in the US since the mid-twentieth century. The plans were often adopted by cities to receive federal funding that would facilitate redeveloping so-called “blighted” neighborhoods. This involved using eminent domain to acquire the land, relocating the people who lived there, and demolishing the structures on that land. Urban Reviewer maps New York City’s master plans that have been created since the 1950s.
These plans significantly changed our city’s neighborhoods. Whether the plans for new industrial or residential space made it to completion -and many did not- they still involved destroying structures and moving communities to other parts of the city. Part of our motivation for creating this map was that we wanted to see which pieces of land (“lots”) were affected by master plans and are still vacant. Our map’s filters enable this now:
Many volunteers gave a total of hundreds of hours in order to digitize paper records of the master plans provided by a city agency. These detailed records included information about the plans and each individual lot within them and are the definitive records of these plans. We are not aware of digital records of the plans, so we created them.
There was a moderate amount of processing that had to be done in order to make these records useful, but we will stick to the CartoDB side of this mapping here.
We use two CartoDB tables:
plans, which stores each plan’s name and other details, and
lots, which stores the geometries for each lot and points back to the
We style the lots using some pretty basic CartoCSS that makes the lines around the lots thicker when zoomed out:
The master plans can be complicated. They often consist of numerous lots that are rarely contiguous. It can be hard to tell if a lot is part of a plan, and some plans overlap. We rely on interactivity to make these relationships clearer, and we’re still tweaking how this works.
First of all, it’s helpful to be able to see the boundaries of a plan while moving your mouse over the map and while a plan is selected:
After testing the query in CartoDB’s SQL console, we added code to get the results as a GeoJSON file and add them to a Leaflet GeoJSON layer in just a few more lines:
When a plan is selected we also highlight the lots within that plan:
We accomplish this by setting the layer’s CartoCSS using the CartoCSS above and adding a little more:
PLAN_NAME with the name of the plan that was selected. You can see more details of how we do this in the code if that’s your thing.
Finally, when you mouse over a lot (either in the list view or on the map) the lot is highlighted in a similar way to how we highlight the plans. First we grab the lot’s geometry with some SQL:
And then we get the geometry using the SQL API and add the GeoJSON to a Leaflet layer. This is nice because we can overlay an outline around the lot without updating the layer’s CartoCSS. That would force the entire layer to refresh just to add a line around one shape!
Now that you know a bit about how the map works, come explore NYC’s master plans on Urban Reviewer.
See our other , and go to CartoDB to start creating your own maps.
Recently, as part of our ongoing mission to empower Data Scientists with the best data and analysis, we announced the integration of our platform with Databricks, using eit...Use Cases
Please fill out the below form and we'll be in touch real soon.