-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathMapping_Civic_Data.html
321 lines (204 loc) · 9.59 KB
/
Mapping_Civic_Data.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
<!DOCTYPE html>
<html>
<head>
<title>Mapping Open Data for Civic Activism</title>
<meta charset="utf-8">
<meta name="author" content="Kent Johnson" />
<link href="libs/remark-css-0.0.1/example.css" rel="stylesheet" />
<link href="libs/font-awesome-4.5.0/css/font-awesome.min.css" rel="stylesheet" />
</head>
<body>
<textarea id="source">
class: center, middle, inverse, title-slide
# Mapping Open Data for Civic Activism
## How can open data inform local politics?
### Kent Johnson
### 2018/01/17
---
# Who am I?
### Software developer <i class='fa fa-laptop'></i> / Data geek <i class='fa fa-database'></i> / Amateur mapper <i class='fa fa-map-o'></i>
### I love maps and data <i class='fa fa-heart-o'></i>
### [kentsjohnson.com](http://kentsjohnson.com)
### http://kentsj.com/Preso/Mapping_Civic_Data.html
???
Slippy maps are a great way to explore detailed geographic data.
---
# Who is voting for &lt;my candidate> ? 🗳
### My first slippy map, for Somerville Alderman elections, 2013
Map of canvassing data
👣 using Leaflet.js.
Shows location of supporters, non-supporters, not reached, etc.
Non-public data, sorry! 🤦♂️
---
# Cambridge Open Data portal launch 🚀
### 2015 - We have data...
Cambridge Vice Mayor Jan Devereux (then FPRA president) suggested that FPRA
might need a “data person”. I volunteered. 🙌
Coincidentally, [Leaflet for R](http://rstudio.github.io/leaflet/) was
released around the same time.
.center[[](http://data.cambridgema.gov)]
.center[[<img src="http://leafletjs.com/docs/images/logo.png" alt="Leaflet.js logo" style="height: 80px;"/>](http://leafletjs.com/)]
### .center[⛈️ ⚡ A perfect storm ⚡ ⛈️]
???
Show the open data site and assessor's data!!
FPRA is ?
Ask who is familiar with Leaflet.
Ask who is a programmer.
What is R?
---
# Let's explore! 🔎
--
<h3>How about some exploratory maps?</h3>
---
# Who owns Cambridge?
## 🏛 Institutional ownership of Cambridge property
- Based on assessor's data and parcel map (the first of many)
- Each parcel links to assessor's property page
### Issues
- Spelling - At least __7__ ways to spell
__`PRESIDENT & FELLOWS OF HARVARD COLLEGE`__
- Linking to property page via map-lot was problematic
- City staff were _very_ helpful with
- understanding mysterious codes
- updating the [Property Database](http://www.cambridgema.gov/propertydatabase/) website to support map-lot links
### [Town/Gown Map](http://kentsj.com/FPRA/TownGown.html)
???
Most of my Cambridge maps are mashups of assessor's data and the parcel map.
Assessor's data has information about deeded properties
Parcel map has locations
Many-to-one relationship, e.g. many condos in a single parcel
---
# Where are the most valuable residential properties?
### An exploration of property values 💰
### [Top 100 Residential Properties map](http://kentsj.com/FPRA/Top100Residential.html)
- Updated for 2018 data, preserving the (crude) style
- Most field names changed from 2015 to 2018 🙁
---
# Seriously, now... 🤔
--
<h3>It helps to have interesting questions.</h3>
???
Many of the following started with an email with the subject "Quick Question"
---
# Where is Cambridge Affordable Housing?
### An attempt to map all affordable housing in Cambridge
### Ultimately a failure 🤷♀️
- Many, many owners 👨🏻⚕️ 👨🏻🎓 👨🏻 👨 👨🏼 👨🏼 👨 👨🏽 👨🏾 👨⚕️
- No centralized data source
- What counts as affordable, anyway?
### [Affordable Housing Map](http://kentsj.com/FPRA/AffordableHousing2.html)
???
Note Stamen toner.lite base map
---
# Who can create Accessory Housing? 🏘️
### Combridge 2015 accessory housing ordinance was very restrictive.
### Limitations on lot size, building size, zone, etc.
#### How many properties might qualify for an accessory unit?
#### How could changes in the ordinance increase availability?
[Interactive application](http://kentsj.com/FPRA/AccessoryHousing.html)
made with [R](http://r-project.org) and [Shiny](http://shiny.rstudio.com) allows
exploration of eligible properties as the limitations
are changed.
Resulted in a change to the Cambridge zoning ordinance! 🎉
---
# Where are non-conforming lots?
### OK, where are lots with less than 20' frontage?
### .center[Twenty feet <i class='fa fa-long-arrow-right'></i>👣👣👣👣👣👣👣👣👣👣]
### Answering this required extensive geospatial processing.
- Buffer roads and sidewalks
- Split parcels into segments
- Segments fully in the buffer are frontage segments
The [map](http://kentsj.com/FPRA/SmallFrontage.html) itself is mostly confirmatory.
#### [Cambridge GIS](http://gis.cambridgema.gov) has _many_ useful datasets, yay!
???
Is anyone from Cambridge GIS here? Thank you!
Show the GIS web site, talk about some of the useful datasets.
---
# How will the Cambridge Lighting Ordinance affect me?
### Changes proposed to allowable outdoor lighting 💡 🚨 🏮
### Who is affected?
[Map](http://kentsj.com/LZ/ProposedLightingZones.html) based on existing zoning and proposed changes was used as part of a
campaign for a stronger ordinance.
Simple geospatial analysis to find areas of the zones and length of the border between zones.
---
# Who is building in the Alewife area?
### Alewife development has soared in the past ten years .
### 🏘 🏢 🏨 🏘 🏢 🏨 🏘 🏢 🏨 🏘 🏢 🏨 🏘 🏢 🏨
### There is no end in sight. &nbsp; <i class='fa fa-binoculars'></i>
[Alewife Development Map](http://kentsj.com/FPRA/Alewife_Projects.html) combines
- curated development information
- parcel map
- overlays for tree cover, parking, flood plain (please can we have open raster data?)
to shine light on development in this sensitive area.
---
# How has Alewife development increased tax revenue? 💵
### Alewife development has increased tax revenue by $7 million over five years.
#### [Tax Revenue Report](http://kentsj.com/FPRA/AlewifeTaxRevenue.html) shows increase in valuation and taxes over six years.
Acquiring data for six years was difficult:
- Changing data format—different data, different names
- Missing data—residential exemption was supplied separately or not at all
- Mangled data—data in the wrong columns required fixup
- Auxiliary data—historical tax rates
---
# Where are SeeClickFix requests? 🔧
### [SeeClickFix](https://seeclickfix.com/cambridge) allows citizens to request services and report problems.
#### Original goal was to track tree planting requests. 🌳
#### Result is an [interactive app](http://kentsj.com/FPRA/SeeClickFix.html) showing stats on open and closed requests, and the location of open requests.
Data is pulled from the Open Data Portal as needed using the Socrata API.
---
# Do you want more?
--
<h3>Really?</h3>
---
# Do you want more?
### Really? &nbsp; OK 😁
#### [Cambridge Street Trees](http://kentsj.com/FPRA/Cambridge_Street_Trees.html)
#### [Cambridge Development Projects](http://kentsj.com/FPRA/Cambridge_Development_Projects.html)
#### [Building Permits](http://kentsj.com/FPRA/Building_Permits_2015-2017.html)
#### [Board of Zoning Appeals Requests](http://kentsj.com/FPRA/Board_of_Zoning_Appeal_Requests_CT.html)
---
# Why R?
[R](http://r-project.org) is a free software environment for statistical computing and graphics. It has
- Excellent data analysis
- Excellent static graphics
- Some interactive graphics
- Good geospatial support
- Easy integration with Leaflet
- Flexible, reproducible report generation with R Markdown
- A world-class IDE ([RStudio](https://www.rstudio.com/products/rstudio/))
.center[]
---
# .center[❓Questions❓]
### .center[[<i class='fa fa-envelope-o'></i> [email protected]](mailto://[email protected])]
### .center[[kentsj.com/Preso/Mapping_Civic_Data.html](http://kentsj.com/Preso/Mapping_Civic_Data.html)]
### .center[[kentsj.com/Preso/Mapping_with_R.html](http://kentsj.com/Preso/Mapping_with_R.html)]
### .center[[<i class='fa fa-bitbucket'></i> bitbucket.org/kent37/fpra](https://bitbucket.org/kent37/fpra)]
<hr />
### .center[[data.cambridgema.gov](http://data.cambridgema.gov)]
### .center[[gis.cambridgema.gov](http://gis.cambridgema.gov)]
</textarea>
<script src="https://remarkjs.com/downloads/remark-latest.min.js"></script>
<script>var slideshow = remark.create();
if (window.HTMLWidgets) slideshow.on('afterShowSlide', function (slide) {window.dispatchEvent(new Event('resize'));});
(function() {var d = document, s = d.createElement("style"), r = d.querySelector(".remark-slide-scaler"); if (!r) return; s.type = "text/css"; s.innerHTML = "@page {size: " + r.style.width + " " + r.style.height +"; }"; d.head.appendChild(s);})();</script>
<script type="text/x-mathjax-config">
MathJax.Hub.Config({
tex2jax: {
skipTags: ['script', 'noscript', 'style', 'textarea', 'pre']
}
});
</script>
<!-- dynamically load mathjax for compatibility with self-contained -->
<script>
(function () {
var script = document.createElement('script');
script.type = 'text/javascript';
script.src = 'https://cdn.bootcss.com/mathjax/2.7.1/MathJax.js?config=TeX-MML-AM_CHTML';
if (location.protocol !== 'file:' && /^https?:/.test(script.src))
script.src = script.src.replace(/^https?:/, '');
document.getElementsByTagName('head')[0].appendChild(script);
})();
</script>
</body>
</html>