Eric Brelsford
Eric Brelsford
freelance programmer and mapmaker
Eric Brelsford
@ebrelsford
call Parks and say "where's our park?"
What is urban renewal?
Urban
Renewal
we make maps—let's map them!
we weren't the first to have this idea
Community Development Program Progress Report (1968)
Atlas of Urban Renewal (1984)
what will it take?
what will it take?
- get the data
- clean the data
- merge the data with other useful datasets
FOIL
FOILed!
thank you, awesome volunteers!
tiles created via OpenStreetMap and Mapbox
~10,000 polygons
6 MB
not particularly fast
list plans
outline plans
search for plans
highlight parcels
CartoDB
- Leaflet
- Mapbox tiles
- CartoDB layer on top with cartodb.js
making it interactive
making it interactive
SELECT p.name
FROM plans p
WHERE p.name ILIKE '%lincol%'
ST_Union, ST_ConvexHull, ST_Buffer
yeah we use the SQL API here too
dynamic styles
dynamic styles
setCartoCSS()
dynamic data
dynamic data
setSQL()
you CAN have it both ways
show ALL your data and interact with it too