Table 2. Model results for all CBGs, for trips up to 3km in length, in 2019.
Trips to amenity clusters in Somerville (Aggregate models < 3kms) - 2019 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
Dependent variable: log(number of visits) | ||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
Constant | 0.068** (0.031) | -0.006 (0.030) | 0.074** (0.031) | 0.033 (0.030) | 0.023 (0.029) | 0.040 (0.029) | 0.025 (0.031) | 0.051* (0.030) | 0.053* (0.032) | 0.057* (0.031) | 0.045 (0.030) | 0.064** (0.029) |
Distance | -0.426*** (0.041) | -0.448*** (0.042) | -0.469*** (0.040) | -0.504*** (0.040) | -0.527*** (0.038) | -0.416*** (0.037) | -0.438*** (0.041) | -0.432*** (0.039) | -0.483*** (0.040) | -0.443*** (0.042) | -0.416*** (0.042) | -0.440*** (0.041) |
Nr Establishments | -0.023 (0.097) | 0.093 (0.097) | 0.223** (0.101) | 0.011 (0.092) | 0.089 (0.091) | -0.099 (0.087) | 0.040 (0.101) | 0.095 (0.097) | -0.028 (0.102) | 0.002 (0.100) | -0.001 (0.094) | -0.072 (0.094) |
% Large | 0.958* (0.510) | 1.722*** (0.643) | 2.578*** (0.621) | 2.601*** (0.606) | 2.089*** (0.575) | 1.161*** (0.435) | 1.743*** (0.624) | 2.058*** (0.496) | 1.101** (0.519) | 2.058*** (0.538) | 0.807 (0.534) | 2.074*** (0.542) |
Land Value | -0.039 (0.041) | 0.035 (0.045) | -0.013 (0.042) | -0.018 (0.037) | -0.022 (0.037) | -0.086** (0.038) | -0.073* (0.039) | 0.004 (0.041) | 0.0003 (0.042) | -0.011 (0.042) | -0.041 (0.041) | -0.075* (0.04) |
Diversity | 1.131*** (0.204) | 0.691*** (0.213) | 0.553*** (0.205) | 1.158*** (0.192) | 0.727*** (0.171) | 0.752*** (0.184) | 0.647*** (0.198) | 0.649*** (0.202) | 0.806*** (0.192) | 0.689*** (0.213) | 0.877*** (0.196) | 0.760*** (0.220) |
Cluster Area | 0.120 (0.082) | 0.001 (0.086) | -0.092 (0.089) | 0.057 (0.079) | -0.070 (0.082) | 0.151** (0.074) | -0.021 (0.088) | -0.045 (0.085) | 0.146* (0.088) | 0.021 (0.088) | 0.081 (0.080) | 0.083 (0.080) |
Parking | -0.001 (0.001) | -0.001 (0.001) | -0.002*** (0.001) | -0.0001 (0.001) | -0.002** (0.001) | -0.001* (0.0003) | -0.001 (0.001) | -0.002*** (0.001) | -0.002*** (0.001) | -0.002*** (0.001) | -0.001 (0.001) | -0.001** (0.001) |
% Comparison | 0.998*** (0.284) | 0.544 (0.333) | 0.553* (0.297) | 0.476 (0.290) | 0.929*** (0.284) | 0.478* (0.248) | 0.962*** (0.324) | 0.899*** (0.268) | 1.063*** (0.273) | 0.780*** (0.290) | 0.960*** (0.264) | 0.977*** (0.281) |
% Convenience | -0.628 (0.499) | 0.392 (0.523) | -0.559 (0.532) | -1.076** (0.483) | 0.198 (0.463) | -0.225 (0.433) | -0.118 (0.488) | 0.063 (0.497) | 0.767 (0.478) | -0.158 (0.480) | 0.076 (0.484) | -0.799* (0.484) |
% F&B | 0.354 (0.281) | 0.389 (0.291) | 0.101 (0.277) | 0.349 (0.272) | 0.540** (0.243) | 0.302 (0.229) | 0.484* (0.279) | 0.047 (0.253) | 0.666** (0.263) | 0.696** (0.282) | 0.432 (0.277) | 0.998*** (0.287) |
% Entertainment | -1.847 (1.312) | 2.563** (1.228) | 0.223 (1.214) | 0.085 (1.234) | 0.420 (0.967) | -1.232 (1.154) | 0.479 (1.109) | -0.963 (1.223) | 1.571 (1.099) | 0.141 (1.186) | 0.955 (1.007) | -1.146 (1.044) |
% Personal | 1.120*** (0.422) | 0.411 (0.414) | 0.602 (0.405) | 0.802** (0.361) | 0.695** (0.349) | 0.551 (0.344) | 0.819** (0.395) | 0.360 (0.393) | 0.412 (0.396) | 0.628 (0.414) | 0.788** (0.367) | 1.007** (0.407) |
Open Space | 0.012 (0.008) | 0.013 (0.008) | 0.014* (0.008) | 0.024*** (0.007) | 0.028*** (0.007) | 0.029*** (0.007) | 0.027*** (0.008) | 0.021*** (0.008) | 0.009 (0.007) | 0.018** (0.007) | 0.016** (0.007) | 0.008 (0.007) |
Observations | 533 | 534 | 599 | 635 | 633 | 625 | 560 | 588 | 665 | 575 | 534 | 509 |
R 2 | 0.26 | 0.243 | 0.244 | 0.274 | 0.315 | 0.254 | 0.243 | 0.25 | 0.249 | 0.216 | 0.238 | 0.245 |
Adjusted R 2 | 0.242 | 0.224 | 0.227 | 0.259 | 0.3 | 0.238 | 0.225 | 0.233 | 0.234 | 0.198 | 0.219 | 0.225 |
Residual Std. Error | 0.598 (df = 519) | 0.598 (df = 520) | 0.646 (df = 585) | 0.624 (df = 621) | 0.593 (df = 619) | 0.585 (df = 611) | 0.603 (df = 546) | 0.593 (df = 574) | 0.678 (df = 651) | 0.616 (df = 561) | 0.579 (df = 520) | 0.563 (df = 495) |
F Statistic | 14.060*** | 12.807*** | 14.501*** | 18.032*** | 21.866*** | 16.026*** | 13.511*** | 14.683*** | 16.642*** | 11.880*** | 12.470*** | 12.355*** |
(df = 13; 519) | (df = 13; 520) | (df = 13; 585) | (df = 13; 621) | (df = 13; 619) | (df = 13; 611) | (df = 13; 546) | (df = 13; 574) | (df = 13; 651) | (df = 13; 561) | (df = 13; 520) | (df = 13; 495) |
Note
*p<0.1
**p<0.05
***p<0.01
Standard errors in brackets.