[1]:
cd
C:\Users\jerem\Box Sync\Policy Evaluation\dofiles
[3]:
cd "..\working_data\analytical_panel_shapefile\"
// Convert shapefile to dta
*spshape2dta "analytical_panel_qt_shapefile_crosssec_thiessen_polygons_clipped_manhattan", replace
// Already ran this
C:\Users\jerem\Box Sync\Policy Evaluation\working_data\analytical_panel_shapefile
[4]:
clear
[5]:
use "analytical_panel_qt_shapefile_crosssec_thiessen_polygons_clipped_manhattan",clear
[5]:
codebook _CY _CX
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
_CY y-coordinate of area centroid
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
type: numeric (double)
range: [40.700958,40.876938] units: 1.000e-09
unique values: 2,736 missing .: 0/2,736
mean: 40.7718
std. dev: .0409
percentiles: 10% 25% 50% 75% 90%
40.7192 40.7377 40.7682 40.8006 40.8285
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
_CX x-coordinate of area centroid
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
type: numeric (double)
range: [-74.017895,-73.908756] units: 1.000e-09
unique values: 2,736 missing .: 0/2,736
mean: -73.9713
std. dev: .024253
percentiles: 10% 25% 50% 75% 90%
-74.0039 -73.9912 -73.9736 -73.9501 -73.9387
[6]:
gen test = _CY == y_left
tab test
gen test2 = _CX == x_left
tab test2
test | Freq. Percent Cum.
------------+-----------------------------------
0 | 2,736 100.00 100.00
------------+-----------------------------------
Total | 2,736 100.00
test2 | Freq. Percent Cum.
------------+-----------------------------------
0 | 2,736 100.00 100.00
------------+-----------------------------------
Total | 2,736 100.00
[7]:
drop test test2
[8]:
gen quarterly = yq(year_left, quarter_le)
format quarterly %tq
[9]:
tab quarterly, nolabel
quarterly | Freq. Percent Cum.
------------+-----------------------------------
2012q3 | 2,736 100.00 100.00
------------+-----------------------------------
Total | 2,736 100.00
[10]:
// Left this in here in case I use the full panel shapefile
keep if quarterly == tq(2012q3)
(0 observations deleted)
[11]:
codebook _ID
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
_ID Spatial-unit ID
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
type: numeric (int)
range: [1,2736] units: 1
unique values: 2,736 missing .: 0/2,736
mean: 1368.5
std. dev: 789.959
percentiles: 10% 25% 50% 75% 90%
274 684.5 1368.5 2052.5 2463
[11]:
duplicates tag _ID _CY _CX, gen(dup)
tab dup
drop dup
Duplicates in terms of _ID _CY _CX
dup | Freq. Percent Cum.
------------+-----------------------------------
0 | 2,736 100.00 100.00
------------+-----------------------------------
Total | 2,736 100.00
[13]:
codebook intersecti
codebook intersecti if flag_LPIS_ == 1
codebook intersecti if flag_LPIS_ == 0
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
intersecti intersecti
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
type: numeric (int)
range: [1,4218] units: 1
unique values: 2,736 missing .: 0/2,736
mean: 1450.23
std. dev: 833.591
percentiles: 10% 25% 50% 75% 90%
295 731.5 1453.5 2176.5 2594
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
intersecti intersecti
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
type: numeric (int)
range: [6,2868] units: 1
unique values: 673 missing .: 0/673
mean: 1626.07
std. dev: 658.469
percentiles: 10% 25% 50% 75% 90%
638 1185 1737 2171 2380
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
intersecti intersecti
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
type: numeric (int)
range: [1,4218] units: 1
unique values: 2,063 missing .: 0/2,063
mean: 1392.87
std. dev: 875.774
percentiles: 10% 25% 50% 75% 90%
227 617 1331 2188 2644
[14]:
describe, fullname
Contains data from analytical_panel_qt_shapefile_crosssec_thiessen_polygons_clipped_manhattan.dta
obs: 2,736
vars: 35 22 Feb 2019 15:49
size: 205,200
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
storage display value
variable name type format label variable label
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
_ID int %12.0g Spatial-unit ID
_CX double %10.0g x-coordinate of area centroid
_CY double %10.0g y-coordinate of area centroid
collision_ byte %9.0f collision_
personsinj byte %9.0f personsinj
pedestrian byte %9.0f pedestrian
cyclistinj byte %9.0f cyclistinj
motoristin byte %9.0f motoristin
bronx_left byte %9.0f bronx_left
brooklyn_l byte %9.0f brooklyn_l
manhattan_ byte %9.0f manhattan_
queens_lef byte %9.0f queens_lef
statenisla byte %9.0f statenisla
distance_t int %9.0f distance_t
distance_1 int %9.0f distance_1
distance_2 int %9.0f distance_2
distance_3 int %9.0f distance_3
distance_4 int %9.0f distance_4
distance_5 int %9.0f distance_5
flag_left_ byte %9.0f flag_left_
flag_lef_1 byte %9.0f flag_lef_1
flag_LPIS_ byte %9.0f flag_LPIS_
flag_LPI_1 byte %9.0f flag_LPI_1
bike_route byte %9.0f bike_route
bike_rou_1 byte %9.0f bike_rou_1
flag_senio byte %9.0f flag_senio
flag_prior byte %9.0f flag_prior
flag_schoo byte %9.0f flag_schoo
flag_stree byte %9.0f flag_stree
quarter_le byte %9.0f quarter_le
year_left int %9.0f year_left
intersecti int %9.0f intersecti
y_left double %24.15f y_left
x_left double %24.15f x_left
quarterly float %tq
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Sorted by: _ID
Note: Dataset has changed since last saved.
[12]:
spset
spset, coordsys(latlong, miles) modify
Sp dataset analytical_panel_qt_shapefile_crosssec_thiessen_polygons_clipped_manhattan.dta
data: cross sectional
spatial-unit id: _ID
coordinates: _CX, _CY (planar)
linked shapefile: analytical_panel_qt_shapefile_crosssec_thiessen_polygons_clipped_manhattan_shp.dta
Sp dataset analytical_panel_qt_shapefile_crosssec_thiessen_polygons_clipped_manhattan.dta
data: cross sectional
spatial-unit id: _ID
coordinates: _CY, _CX (latitude-and-longitude, miles)
linked shapefile: analytical_panel_qt_shapefile_crosssec_thiessen_polygons_clipped_manhattan_shp.dta
[16]:
grmap
Calculate Contiguity and Inverse Distance matrix¶
[17]:
// Create Matrix W
/*
spmatrix create contiguity W
cd "..\"
cd "..\working_data\"
spmatrix save W using "contiguity_W.stswm"
*/
[18]:
/*
spmatrix export W using "contiguity_W"
clear
import delimited using "contiguity_W.txt" , delimiters(" ")
drop if mi(v2)
save "contiguity_W.dta"
*/
[19]:
// Create Matrix M
/*
cd "..\working_data\analytical_panel_shapefile\"
spmatrix create idistance M if quarter==3 & year == 2012
cd "..\"
cd "..\working_data\"
spmatrix save M using "idistance_M.stswm"
*/
Use saved matrix¶
[13]:
cd
C:\Users\jerem\Box Sync\Policy Evaluation\working_data\analytical_panel_shapefile
[14]:
cd "..\"
*cd "..\working_data\"
spmatrix use W using "contiguity_W.stswm"
*spmatrix use M using "idistance_M.stswm"
C:\Users\jerem\Box Sync\Policy Evaluation\working_data
[15]:
spmatrix summarize W
Weighting matrix W
---------------------------------------
Type | contiguity
Normalization | spectral
Dimension | 2736 x 2736
Elements |
minimum | 0
minimum > 0 | .1600261
mean | .0003389
max | .1600261
Neighbors |
minimum | 2
mean | 5.79386
maximum | 12
---------------------------------------
[16]:
cd "..\dofiles"
C:\Users\jerem\Box Sync\Policy Evaluation\dofiles
[ ]:
[17]:
spmatrix dir
------------------------------------------------------------------------
Weighting matrix name N x N Type Normalization
------------------------------------------------------------------------
W 2736 x 2736 contiguity spectral
------------------------------------------------------------------------
[18]:
keep _ID _CX _CY intersecti
[19]:
mmerge intersecti using "..\working_data\analytical_file_panel_qt.dta", ///
type(1:n) ///
unmatched(master) ///
umatch(intersection_id)
-------------------------------------------------------------------------------
merge specs |
matching type | 1:n
mv's on match vars | none
unmatched obs from | master
---------------------+---------------------------------------------------------
master file | analytical_panel_qt_shapefile_crosssec_thiessen_polygons_clipped_manhattan.dta
obs | 2736
vars | 4
match vars | intersecti (key)
-------------------+---------------------------------------------------------
using file | ..\working_data\analytical_file_panel_qt.dta
obs | 324675
vars | 163
match vars | intersection_id (not a key)
---------------------+---------------------------------------------------------
variable intersecti does not uniquely identify observations in C:\Users\jerem\AppData\Local\Temp\ST_198c_000002.tmp
result file | analytical_panel_qt_shapefile_crosssec_thiessen_polygons_clipped_manhattan.dta
obs | 68400
vars | 168 (including _merge)
------------+---------------------------------------------------------
_merge | 68400 obs both in master and using data (code==3)
-------------------------------------------------------------------------------
[27]:
describe
Contains data from analytical_panel_qt_shapefile_crosssec_thiessen_polygons_clipped_manhattan.dta
obs: 68,400
vars: 167 22 Feb 2019 15:49
size: 45,007,200
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
storage display value
variable name type format label variable label
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
_ID int %12.0g Spatial-unit ID
_CX double %10.0g x-coordinate of area centroid
_CY double %10.0g y-coordinate of area centroid
intersecti int %9.0f intersecti
quarter byte %8.0g
year int %8.0g
quarterly int %tq
index int %12.0g
y double %10.0g
x double %10.0g
st1_name str31 %31s
st2_name str32 %32s
st3_name str35 %35s
st4_name str36 %36s
dup byte %8.0g
Coordinates str42 %42s
distance_to_L~S int %12.0g
nearest_LPIS int %12.0g
distance_to_S~t int %12.0g
nearest_Street long %12.0g
num_traveling~s float %10.0g
mi_number_tra~s byte %9.0g
num_parking_l~s byte %10.0g
mi_number_par~s byte %9.0g
num_total_lanes byte %10.0g
trafdir byte %80.0g trafdir1
distance_to_Sch int %12.0g
nearest_Sch long %10.0g
distance_to_LTC long %12.0g
nearest_LTC int %12.0g
left_turn_tre~t str80 %80s
left_turn_in~dt int %td
left_turn_in~qt int %tq
left_turn_in~mt int %tm
distance_to_S~o long %12.0g
nearest_StImpro int %12.0g
street_impro~dt int %td
street_impro~qt int %tq
street_impro~mt int %tm
street_impro~nt str53 %53s
distance_to_b~e int %12.0g
nearest_biker~e int %10.0g
distance_to_t~e int %12.0g
nearest_truck~e long %12.0g
bname str13 %13s
distance_to_p~s int %12.0g
nearest_prior~s int %12.0g
Name str26 %26s
seniors_ID byte %10.0g
bronx byte %9.0g
brooklyn byte %9.0g
manhattan byte %9.0g
queens byte %9.0g
statenisland byte %9.0g
tf_facilit str21 %21s
bike_route_i~dt int %td
bike_route_i~mt int %tm
bike_route_i~qt int %tq
bike_route_ever byte %9.0g Indicates that bike route passes through this intersection (<3 ft)
bike_route_tv byte %9.0g Indicates that bike route passes through this intersection timevarient(<3 ft)
truck_route byte %9.0g Indicates that truck route passes through this intersection (<3 ft)
left_turn_min int %10.0g
flag_left_tur~r byte %9.0g
flag_left_turn byte %9.0g
street_improv~n int %10.0g
flag_street_i~r byte %9.0g
flag_street_i~v byte %9.0g
LPIS_install_dt int %td
LPIS_install_mt int %tm
LPIS_install_qt int %tq
LPIS_install_yr int %9.0g
LPIS_min int %10.0g
flag_LPIS_ever byte %9.0g Indicates the intersection if they ever received LPIS intervention
flag_LPIS byte %9.0g Indicates the intersection at the time they became an LPIS intervention
flag_LPIS_1yr byte %9.0g
flag_LPIS_2yr byte %9.0g
flag_LPIS_3yrup byte %9.0g
flag_LPIS_2yrup byte %9.0g
flag_LPIS_since byte %9.0g
flag_LPIS_sin~q int %9.0g
LPIS_ID1 int %12.0g 1 LPIS_ID
LPIS_ID2 int %12.0g 2 LPIS_ID
LPIS_ID3 int %12.0g 3 LPIS_ID
LPIS_ID4 int %12.0g 4 LPIS_ID
LPIS_ID5 int %12.0g 5 LPIS_ID
LPIS_ID6 int %12.0g 6 LPIS_ID
LPIS_ID7 int %12.0g 7 LPIS_ID
LPIS_ID8 int %12.0g 8 LPIS_ID
LPIS_ID9 int %12.0g 9 LPIS_ID
LPIS_ID10 int %12.0g 10 LPIS_ID
LPIS_ID11 int %12.0g 11 LPIS_ID
LPIS_ID12 int %12.0g 12 LPIS_ID
LPIS_ID13 int %12.0g 13 LPIS_ID
LPIS_ID14 int %12.0g 14 LPIS_ID
LPIS_ID15 int %12.0g 15 LPIS_ID
LPIS_ID16 int %12.0g 16 LPIS_ID
LPIS_ID17 int %12.0g 17 LPIS_ID
LPIS_ID18 int %12.0g 18 LPIS_ID
LPIS_ID19 int %12.0g 19 LPIS_ID
LPIS_ID20 int %12.0g 20 LPIS_ID
LPIS_ID21 int %12.0g 21 LPIS_ID
LPIS_ID22 int %12.0g 22 LPIS_ID
LPIS_ID23 int %12.0g 23 LPIS_ID
LPIS_ID24 int %12.0g 24 LPIS_ID
LPIS_ID25 int %12.0g 25 LPIS_ID
LPIS_ID26 int %12.0g 26 LPIS_ID
LPIS_ID27 int %12.0g 27 LPIS_ID
LPIS_ID28 int %12.0g 28 LPIS_ID
LPIS_ID29 int %12.0g 29 LPIS_ID
LPIS_ID30 int %12.0g 30 LPIS_ID
LPIS_ID31 int %12.0g 31 LPIS_ID
LPIS_ID32 int %12.0g 32 LPIS_ID
LPIS_ID33 int %12.0g 33 LPIS_ID
LPIS_ID34 int %12.0g 34 LPIS_ID
LPIS_ID35 int %12.0g 35 LPIS_ID
LPIS_ID36 int %12.0g 36 LPIS_ID
LPIS_ID37 int %12.0g 37 LPIS_ID
LPIS_ID38 int %12.0g 38 LPIS_ID
LPIS_ID39 int %12.0g 39 LPIS_ID
LPIS_ID40 int %12.0g 40 LPIS_ID
LPIS_ID41 int %12.0g 41 LPIS_ID
LPIS_ID42 int %12.0g 42 LPIS_ID
LPIS_ID43 int %12.0g 43 LPIS_ID
LPIS_ID44 int %12.0g 44 LPIS_ID
LPIS_ID45 int %12.0g 45 LPIS_ID
LPIS_ID46 int %12.0g 46 LPIS_ID
LPIS_ID47 int %12.0g 47 LPIS_ID
LPIS_ID48 int %12.0g 48 LPIS_ID
LPIS_ID49 int %12.0g 49 LPIS_ID
LPIS_ID50 int %12.0g 50 LPIS_ID
LPIS_ID51 int %12.0g 51 LPIS_ID
LPIS_ID52 int %12.0g 52 LPIS_ID
LPIS_ID53 int %12.0g 53 LPIS_ID
flag_seniors byte %9.0g
flag_priority~s byte %9.0g
flag_school byte %9.0g
collision_count byte %9.0g No. of collisions occured during that month
latenight_col~t byte %9.0g No. of collisions occured during that month between 11pm - 5am
day_collision~t byte %9.0g No. of collisions occured during that month between 5am - 11pm
personsinjured byte %10.0g No. of persons injured during that month
personskilled byte %10.0g No. of persons killed during that month
pedestriansin~d byte %10.0g No. of pedestrians injured during that month
pedestrianski~d byte %10.0g No. of pedestrians killed during that month
cyclistinjured byte %10.0g No. of cyclist injured during that month
cyclistkilled byte %10.0g No. of cyclist killed during that month
motoristinjured byte %10.0g No. of motorist injured during that month
motoristkilled byte %10.0g No. of motorist killed during that month
late~onsinjured byte %9.0g No. of persons injured during that month between 11pm - 5am
laten~onskilled byte %9.0g No. of persons killed during that month between 11pm - 5am
late~ansinjured byte %9.0g No. of pedestrians injured during that month between 11pm - 5am
laten~anskilled byte %9.0g No. of pedestrians killed during that month between 11pm - 5am
latenight_c~red byte %9.0g No. of cyclist injured during that month between 11pm - 5am
latenight_c~led byte %9.0g No. of cyclist killed during that month between 11pm - 5am
latenight_m~red byte %9.0g No. of motorist injured during that month between 11pm - 5am
latenight_m~led byte %9.0g No. of motorist killed during that month between 11pm - 5am
day_personsin~d byte %9.0g No. of persons injured during that month between 5am - 11pm
day_personski~d byte %9.0g No. of persons killed during that month between 5am - 11pm
day_pedestr~red byte %9.0g No. of pedestrians injured during that month between 5am - 11pm
day_pedestr~led byte %9.0g No. of pedestrians killed during that month between 5am - 11pm
day_cyclistin~d byte %9.0g No. of cyclist injured during that month between 5am - 11pm
day_cyclistki~d byte %9.0g No. of cyclist killed during that month between 5am - 11pm
day_motoristi~d byte %9.0g No. of motorist injured during that month between 5am - 11pm
day_motoristk~d byte %9.0g No. of motorist killed during that month between 5am - 11pm
flag_collision byte %9.0g At least one collision occurred that month
latenight_fla~n byte %9.0g At least one collision occurred that month between 11pm - 5am
day_flag_coll~n byte %9.0g At least one collision occurred that month between 5am - 11pm
_merge byte %32.0g __MERGE
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Sorted by:
Note: Dataset has changed since last saved.
[20]:
sort _ID quarterly
[21]:
xtset _ID quarterly, quarterly
panel variable: _ID (strongly balanced)
time variable: quarterly, 2012q3 to 2018q3
delta: 1 quarter
[22]:
cd "..\manuscripts"
C:\Users\jerem\Box Sync\Policy Evaluation\manuscripts
Visualization¶
[31]:
cd "..\working_data\analytical_panel_shapefile\"
grmap,t(210)
C:\Users\jerem\Box Sync\Policy Evaluation\working_data\analytical_panel_shapefile
(65,664 observations deleted)
[32]:
egen total_collisions = total(collision_count), by(_ID)
[33]:
gen avg_collisions = total_collisions/25
[34]:
cd
C:\Users\jerem\Box Sync\Policy Evaluation\working_data\analytical_panel_shapefile
[35]:
*cd "..\working_data\analytical_panel_shapefile\"
grmap avg_collisions, t(210) clmethod(quantile) legend(position(3)) fcolor(Heat)
// Note that the graph viewed here is not correctly depicting the data
//graph export "D:\Box Sync\Policy Evaluation\manuscripts\choroplethmapmanhattan_avgcollision.png",as(png) replace
(65,664 observations deleted)
[36]:
tab flag_LPIS_ever if quarterly == 210
Indicates |
the |
intersectio |
n if they |
ever |
received |
LPIS |
interventio |
n | Freq. Percent Cum.
------------+-----------------------------------
0 | 2,063 75.40 75.40
1 | 673 24.60 100.00
------------+-----------------------------------
Total | 2,736 100.00
[37]:
grmap flag_LPIS_ever,clmethod(unique) t(210) fcolor(Blues) legend( position(3))
//graph export "D:\Box Sync\Policy Evaluation\manuscripts\choroplethmapmanhattan_lpis.png",as(png) replace
// Note the graphic display here is wrong, but the exported png copy is correct
(65,664 observations deleted)
Base line averages¶
[38]:
* Average number of collisions before LPIs were implemented at LPIs intersections
sum collision_count if flag_LPIS_ever == 1 & flag_LPIS == 0
Variable | Obs Mean Std. Dev. Min Max
-------------+---------------------------------------------------------
collision_~t | 11,663 3.115751 3.042033 0 33
[39]:
* Average number of persons injured before LPIs were implemented at LPIs intersections
sum personsinjured if flag_LPIS_ever == 1 & flag_LPIS == 0
Variable | Obs Mean Std. Dev. Min Max
-------------+---------------------------------------------------------
personsinj~d | 11,663 .6299408 1.132714 0 15
[67]:
* Average number of pedestrians injured before LPIs were implemented at LPIs intersections
sum pedestriansinjured if flag_LPIS_ever == 1 & flag_LPIS == 0
Variable | Obs Mean Std. Dev. Min Max
-------------+---------------------------------------------------------
pedestri~red | 11,663 .2287576 .5563493 0 13
[68]:
* Average number of cyclist injured before LPIs were implemented at LPIs intersections
sum cyclistinjured if flag_LPIS_ever == 1 & flag_LPIS == 0
Variable | Obs Mean Std. Dev. Min Max
-------------+---------------------------------------------------------
cyclistinj~d | 11,663 .1019463 .3338485 0 3
[69]:
* Average number of motorist injured before LPIs were implemented at LPIs intersections
sum motoristinjured if flag_LPIS_ever == 1 & flag_LPIS == 0
Variable | Obs Mean Std. Dev. Min Max
-------------+---------------------------------------------------------
motoristin~d | 11,663 .300866 .8507798 0 13
[40]:
codebook _ID if flag_LPIS_ever == 1
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
_ID Spatial-unit ID
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
type: numeric (int)
range: [6,2730] units: 1
unique values: 673 missing .: 0/16,825
mean: 1533.09
std. dev: 623.554
percentiles: 10% 25% 50% 75% 90%
597 1119 1634 2047 2254
[41]:
codebook _ID if flag_LPIS_ever == 0
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
_ID Spatial-unit ID
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
type: numeric (int)
range: [1,2736] units: 1
unique values: 2,063 missing .: 0/51,575
mean: 1314.81
std. dev: 829.92
percentiles: 10% 25% 50% 75% 90%
216 581 1251 2064 2513
[28]:
global time_var i.quarterly
global time_variant_var bike_route_tv flag_street_improv flag_left_turn
global time_trend i.flag_school##i.quarterly i.flag_priorityinters##i.quarterly i.flag_seniors##i.quarterly
[23]:
cd
cd "..\"
C:\Users\jerem\Box Sync\Policy Evaluation\manuscripts
C:\Users\jerem\Box Sync\Policy Evaluation
[ ]:
cd "..\manuscripts"
Non-spatial Models¶
[30]:
global filename manhattan_qt_results_xt
xtreg collision_count i.flag_LPIS $time_variant_var $time_var $time_trend, fe vce(robust)
outreg2 using "$filename", word replace ctitle(xtreg fe collision_count) title(Manhattan Fixed Effects Linear Models)
xtreg personsinjured i.flag_LPIS $time_variant_var $time_var $time_trend, fe vce(robust)
outreg2 using "$filename", word append ctitle(xtreg fe personsinjured)
xtreg pedestriansinjured i.flag_LPIS $time_variant_var $time_var $time_trend, fe vce(robust)
outreg2 using "$filename", word append ctitle(xtreg fe pedestriansinjured)
xtreg cyclistinjured i.flag_LPIS $time_variant_var $time_var $time_trend, fe vce(robust)
outreg2 using "$filename", word append ctitle(xtreg fe cyclistinjured)
xtreg motoristinjured i.flag_LPIS $time_variant_var $time_var $time_trend, fe vce(robust)
outreg2 using "$filename", word append ctitle(xtreg fe motoristinjured)
note: 1.flag_school omitted because of collinearity
note: 1.flag_priorityinters omitted because of collinearity
note: 1.flag_seniors omitted because of collinearity
Fixed-effects (within) regression Number of obs = 68,400
Group variable: _ID Number of groups = 2,736
R-sq: Obs per group:
within = 0.0892 min = 25
between = 0.0579 avg = 25.0
overall = 0.0038 max = 25
F(100,2735) = 18.18
corr(u_i, Xb) = -0.1620 Prob > F = 0.0000
(Std. Err. adjusted for 2,736 clusters in _ID)
-----------------------------------------------------------------------------------------------
| Robust
collision_count | Coef. Std. Err. t P>|t| [95% Conf. Interval]
------------------------------+----------------------------------------------------------------
1.flag_LPIS | -.0890491 .0678597 -1.31 0.190 -.2221106 .0440124
bike_route_tv | .1765528 .0879707 2.01 0.045 .0040571 .3490485
flag_street_improv | -.4530228 .3010891 -1.50 0.133 -1.043408 .1373622
flag_left_turn | -.9988322 .3281285 -3.04 0.002 -1.642237 -.3554274
|
quarterly |
211 | -.2761611 .0556496 -4.96 0.000 -.3852807 -.1670415
212 | -.4382398 .0556967 -7.87 0.000 -.5474516 -.329028
213 | .0326441 .056952 0.57 0.567 -.0790291 .1443173
214 | -.0533507 .0543473 -0.98 0.326 -.1599167 .0532153
215 | -.0883107 .0560127 -1.58 0.115 -.1981421 .0215207
216 | -.4661595 .0564405 -8.26 0.000 -.5768299 -.3554892
217 | .0036769 .0565187 0.07 0.948 -.1071467 .1145006
218 | -.0406692 .0565653 -0.72 0.472 -.1515842 .0702459
219 | -.1005995 .0558327 -1.80 0.072 -.210078 .008879
220 | -.5036454 .0587119 -8.58 0.000 -.6187695 -.3885214
221 | .0313099 .061193 0.51 0.609 -.0886793 .151299
222 | .0259014 .058279 0.44 0.657 -.088374 .1401768
223 | .0772105 .0579721 1.33 0.183 -.0364631 .1908841
224 | -.3452717 .0576232 -5.99 0.000 -.458261 -.2322824
225 | -.6928722 .0605908 -11.44 0.000 -.8116806 -.5740638
226 | -1.311649 .06232 -21.05 0.000 -1.433848 -1.18945
227 | -1.329731 .063998 -20.78 0.000 -1.45522 -1.204241
228 | -1.114373 .0628805 -17.72 0.000 -1.237671 -.9910747
229 | -.6533421 .0656725 -9.95 0.000 -.7821148 -.5245694
230 | -1.035482 .0642015 -16.13 0.000 -1.161371 -.909594
231 | -.9392744 .0636897 -14.75 0.000 -1.064159 -.8143896
232 | -.9536283 .0647732 -14.72 0.000 -1.080638 -.826619
233 | -.6702299 .0649482 -10.32 0.000 -.7975825 -.5428774
234 | -.8565109 .063752 -13.44 0.000 -.9815179 -.7315039
|
1.flag_school | 0 (omitted)
|
flag_school#quarterly |
1 211 | .3502199 .1853914 1.89 0.059 -.0133015 .7137413
1 212 | .3453154 .1736566 1.99 0.047 .004804 .6858268
1 213 | .2336494 .2026192 1.15 0.249 -.1636527 .6309515
1 214 | .0898933 .1706534 0.53 0.598 -.2447294 .4245159
1 215 | -.0153274 .2020421 -0.08 0.940 -.4114979 .3808431
1 216 | .1593314 .189693 0.84 0.401 -.2126246 .5312875
1 217 | .193699 .2430498 0.80 0.426 -.2828808 .6702788
1 218 | .0569088 .191328 0.30 0.766 -.3182532 .4320707
1 219 | .5021515 .1793159 2.80 0.005 .1505432 .8537599
1 220 | .4996789 .2061512 2.42 0.015 .0954511 .9039067
1 221 | .0409219 .2013813 0.20 0.839 -.3539531 .4357968
1 222 | .167688 .2071691 0.81 0.418 -.2385357 .5739117
1 223 | .1789226 .1842666 0.97 0.332 -.1823932 .5402383
1 224 | .1032539 .1777843 0.58 0.561 -.2453512 .451859
1 225 | .5057818 .2115288 2.39 0.017 .0910094 .9205542
1 226 | .2642157 .2058363 1.28 0.199 -.1393946 .667826
1 227 | .3118039 .1967954 1.58 0.113 -.0740787 .6976865
1 228 | .3301147 .1964459 1.68 0.093 -.0550826 .7153121
1 229 | .5313884 .2242141 2.37 0.018 .0917422 .9710345
1 230 | .4838656 .1930957 2.51 0.012 .1052375 .8624937
1 231 | .5774107 .207401 2.78 0.005 .1707322 .9840891
1 232 | .5327529 .2012038 2.65 0.008 .1382262 .9272797
1 233 | .267106 .2117736 1.26 0.207 -.1481464 .6823583
1 234 | .5575086 .1839139 3.03 0.002 .1968844 .9181327
|
1.flag_priorityinters | 0 (omitted)
|
flag_priorityinters#quarterly |
1 211 | -.7470684 .7666671 -0.97 0.330 -2.250374 .7562369
1 212 | -1.469431 .7526537 -1.95 0.051 -2.945258 .0063962
1 213 | -.7698995 .613412 -1.26 0.210 -1.972697 .4328983
1 214 | -.2803112 .6526394 -0.43 0.668 -1.560027 .9994049
1 215 | .0795555 .6357392 0.13 0.900 -1.167022 1.326133
1 216 | -1.87424 .7739471 -2.42 0.016 -3.39182 -.3566601
1 217 | -1.063644 .6105679 -1.74 0.082 -2.260865 .1335764
1 218 | -.7758454 .6586833 -1.18 0.239 -2.067413 .5157218
1 219 | -1.415201 .8792941 -1.61 0.108 -3.139348 .3089473
1 220 | -2.579036 .8759297 -2.94 0.003 -4.296587 -.8614856
1 221 | -1.522101 .6935043 -2.19 0.028 -2.881946 -.1622559
1 222 | .353946 .6510809 0.54 0.587 -.9227142 1.630606
1 223 | -1.16375 .7040304 -1.65 0.098 -2.544235 .2167348
1 224 | -1.619077 .9050444 -1.79 0.074 -3.393716 .1555631
1 225 | -2.677238 .8911052 -3.00 0.003 -4.424545 -.9299302
1 226 | -3.980985 1.008309 -3.95 0.000 -5.958109 -2.003862
1 227 | -4.50628 1.023344 -4.40 0.000 -6.512885 -2.499676
1 228 | -3.96689 .9441281 -4.20 0.000 -5.818167 -2.115614
1 229 | -3.861717 .8884362 -4.35 0.000 -5.603791 -2.119643
1 230 | -4.129126 .9381961 -4.40 0.000 -5.96877 -2.289481
1 231 | -4.380826 .9582154 -4.57 0.000 -6.259725 -2.501927
1 232 | -3.799428 .9713433 -3.91 0.000 -5.704068 -1.894787
1 233 | -3.688574 .9528744 -3.87 0.000 -5.557001 -1.820148
1 234 | -3.933986 .8957924 -4.39 0.000 -5.690484 -2.177488
|
1.flag_seniors | 0 (omitted)
|
flag_seniors#quarterly |
1 211 | .2555815 .1137814 2.25 0.025 .0324752 .4786877
1 212 | .0090916 .1054453 0.09 0.931 -.1976689 .215852
1 213 | .1005408 .1187933 0.85 0.397 -.132393 .3334745
1 214 | .1667646 .1114227 1.50 0.135 -.0517166 .3852458
1 215 | .2655109 .117135 2.27 0.023 .0358289 .4951928
1 216 | .1869071 .1157756 1.61 0.107 -.0401094 .4139237
1 217 | .2052494 .1139183 1.80 0.072 -.0181252 .4286239
1 218 | -.0701507 .1089679 -0.64 0.520 -.2838185 .143517
1 219 | .1402822 .1139793 1.23 0.219 -.0832119 .3637764
1 220 | -.0059166 .1171039 -0.05 0.960 -.2355376 .2237044
1 221 | .225221 .1227172 1.84 0.067 -.0154068 .4658488
1 222 | .1346187 .1185237 1.14 0.256 -.0977864 .3670239
1 223 | .2499158 .1173672 2.13 0.033 .0197785 .4800532
1 224 | -.0058064 .1171454 -0.05 0.960 -.2355089 .2238961
1 225 | -.3320294 .1223347 -2.71 0.007 -.5719072 -.0921515
1 226 | -.2310338 .1280055 -1.80 0.071 -.4820311 .0199635
1 227 | -.1620226 .1326691 -1.22 0.222 -.4221643 .0981191
1 228 | -.1032158 .1309756 -0.79 0.431 -.360037 .1536054
1 229 | -.0374342 .1348438 -0.28 0.781 -.3018402 .2269718
1 230 | .0402859 .1314471 0.31 0.759 -.2174598 .2980317
1 231 | -.02454 .1364547 -0.18 0.857 -.2921048 .2430247
1 232 | -.3438165 .1352923 -2.54 0.011 -.609102 -.078531
1 233 | -.1208768 .1287439 -0.94 0.348 -.3733219 .1315683
1 234 | -.3386191 .1250257 -2.71 0.007 -.5837735 -.0934647
|
_cons | 2.966889 .0448488 66.15 0.000 2.878948 3.05483
------------------------------+----------------------------------------------------------------
sigma_u | 2.7676387
sigma_e | 1.8750869
rho | .68539534 (fraction of variance due to u_i)
-----------------------------------------------------------------------------------------------
manhattan_qt_results_xt.rtf
dir : seeout
note: 1.flag_school omitted because of collinearity
note: 1.flag_priorityinters omitted because of collinearity
note: 1.flag_seniors omitted because of collinearity
Fixed-effects (within) regression Number of obs = 68,400
Group variable: _ID Number of groups = 2,736
R-sq: Obs per group:
within = 0.0158 min = 25
between = 0.1032 avg = 25.0
overall = 0.0008 max = 25
F(100,2735) = 8.16
corr(u_i, Xb) = -0.3368 Prob > F = 0.0000
(Std. Err. adjusted for 2,736 clusters in _ID)
-----------------------------------------------------------------------------------------------
| Robust
personsinjured | Coef. Std. Err. t P>|t| [95% Conf. Interval]
------------------------------+----------------------------------------------------------------
1.flag_LPIS | -.0644481 .0207813 -3.10 0.002 -.1051967 -.0236994
bike_route_tv | .0264822 .0249676 1.06 0.289 -.0224752 .0754395
flag_street_improv | -.0711796 .0637752 -1.12 0.264 -.1962321 .0538728
flag_left_turn | -.2908746 .0924338 -3.15 0.002 -.4721217 -.1096275
|
quarterly |
211 | -.0816929 .0333571 -2.45 0.014 -.1471005 -.0162854
212 | -.1136853 .0304925 -3.73 0.000 -.1734759 -.0538948
213 | -.0289309 .0309067 -0.94 0.349 -.0895338 .031672
214 | -.0249498 .0311975 -0.80 0.424 -.0861228 .0362233
215 | -.0782413 .0303598 -2.58 0.010 -.1377717 -.0187109
216 | -.1499837 .0299743 -5.00 0.000 -.2087583 -.0912091
217 | -.0721954 .0323175 -2.23 0.026 -.1355647 -.0088262
218 | -.0813737 .0316384 -2.57 0.010 -.1434112 -.0193362
219 | -.1130193 .0311614 -3.63 0.000 -.1741216 -.0519169
220 | -.2143398 .0291672 -7.35 0.000 -.2715318 -.1571478
221 | -.1280382 .0299885 -4.27 0.000 -.1868406 -.0692359
222 | -.0924132 .029177 -3.17 0.002 -.1496244 -.035202
223 | -.092327 .0305308 -3.02 0.003 -.1521927 -.0324613
224 | -.1630317 .0287858 -5.66 0.000 -.2194757 -.1065876
225 | -.2009617 .0298139 -6.74 0.000 -.2594217 -.1425018
226 | -.2825653 .0283669 -9.96 0.000 -.3381879 -.2269426
227 | -.2793448 .028964 -9.64 0.000 -.3361384 -.2225512
228 | -.2299277 .029502 -7.79 0.000 -.2877762 -.1720792
229 | -.1393751 .0304163 -4.58 0.000 -.1990164 -.0797338
230 | -.1934582 .0287095 -6.74 0.000 -.2497526 -.1371638
231 | -.1804036 .0312855 -5.77 0.000 -.2417493 -.1190579
232 | -.1947701 .029638 -6.57 0.000 -.2528853 -.1366548
233 | -.1508698 .0297721 -5.07 0.000 -.2092479 -.0924917
234 | -.1311745 .0302477 -4.34 0.000 -.1904852 -.0718638
|
1.flag_school | 0 (omitted)
|
flag_school#quarterly |
1 211 | .0975552 .1011972 0.96 0.335 -.1008755 .2959859
1 212 | .1222734 .1003812 1.22 0.223 -.0745572 .3191041
1 213 | .0758608 .1002832 0.76 0.449 -.1207778 .2724993
1 214 | .1003733 .1248386 0.80 0.421 -.1444142 .3451608
1 215 | .1185399 .1058936 1.12 0.263 -.0890996 .3261794
1 216 | -.024868 .0854764 -0.29 0.771 -.1924728 .1427368
1 217 | -.0758144 .0885911 -0.86 0.392 -.2495267 .0978979
1 218 | .0034265 .0896315 0.04 0.970 -.1723258 .1791789
1 219 | .2245694 .1129453 1.99 0.047 .0031025 .4460362
1 220 | .0647765 .0920528 0.70 0.482 -.1157235 .2452765
1 221 | .0986406 .109726 0.90 0.369 -.1165137 .3137948
1 222 | -.0074572 .0938448 -0.08 0.937 -.1914711 .1765567
1 223 | -.0874066 .0783719 -1.12 0.265 -.2410807 .0662675
1 224 | .0669207 .1006339 0.66 0.506 -.1304055 .264247
1 225 | .1513374 .1004384 1.51 0.132 -.0456054 .3482803
1 226 | .0268452 .0801407 0.33 0.738 -.1302972 .1839876
1 227 | .0026858 .0762253 0.04 0.972 -.1467793 .1521509
1 228 | .0147934 .0903377 0.16 0.870 -.1623437 .1919305
1 229 | -.0037128 .0884914 -0.04 0.967 -.1772296 .169804
1 230 | .0810394 .0799143 1.01 0.311 -.0756591 .2377379
1 231 | .1451799 .0930908 1.56 0.119 -.0373554 .3277153
1 232 | .1538395 .099609 1.54 0.123 -.041477 .349156
1 233 | .0811852 .0929304 0.87 0.382 -.1010357 .2634062
1 234 | .1814191 .0989459 1.83 0.067 -.0125972 .3754354
|
1.flag_priorityinters | 0 (omitted)
|
flag_priorityinters#quarterly |
1 211 | -.6067364 .378178 -1.60 0.109 -1.34828 .1348071
1 212 | -.4082 .4409806 -0.93 0.355 -1.272889 .4564887
1 213 | -.024769 .4277863 -0.06 0.954 -.8635859 .814048
1 214 | -.1384699 .49166 -0.28 0.778 -1.102532 .8255926
1 215 | .1670519 .4271605 0.39 0.696 -.670538 1.004642
1 216 | -.5369162 .4573009 -1.17 0.240 -1.433606 .3597739
1 217 | -.4081798 .3601583 -1.13 0.257 -1.11439 .2980301
1 218 | -.7331362 .3656557 -2.00 0.045 -1.450126 -.0161469
1 219 | -.789138 .4512068 -1.75 0.080 -1.673879 .0956026
1 220 | -1.222906 .3422005 -3.57 0.000 -1.893904 -.551909
1 221 | -.7621995 .3773076 -2.02 0.043 -1.502036 -.0223628
1 222 | -.5104212 .4164321 -1.23 0.220 -1.326974 .306132
1 223 | -.569376 .3947977 -1.44 0.149 -1.343508 .2047559
1 224 | -.7103552 .3440831 -2.06 0.039 -1.385044 -.0356661
1 225 | -.8223029 .3462613 -2.37 0.018 -1.501263 -.1433427
1 226 | -1.324275 .4417936 -3.00 0.003 -2.190558 -.4579922
1 227 | -1.252323 .4299815 -2.91 0.004 -2.095444 -.4092013
1 228 | -1.172232 .422508 -2.77 0.006 -2.000699 -.3437653
1 229 | -.4421633 .5127736 -0.86 0.389 -1.447626 .5632994
1 230 | -1.293741 .3566235 -3.63 0.000 -1.99302 -.5944628
1 231 | -1.249282 .3995375 -3.13 0.002 -2.032708 -.4658567
1 232 | -1.351855 .4004074 -3.38 0.001 -2.136987 -.5667235
1 233 | -1.146555 .4155013 -2.76 0.006 -1.961283 -.331827
1 234 | -1.158634 .3778149 -3.07 0.002 -1.899465 -.4178022
|
1.flag_seniors | 0 (omitted)
|
flag_seniors#quarterly |
1 211 | .04613 .0552291 0.84 0.404 -.0621651 .1544251
1 212 | .014135 .0573808 0.25 0.805 -.098379 .126649
1 213 | .015575 .0549535 0.28 0.777 -.0921796 .1233295
1 214 | .0678317 .0592099 1.15 0.252 -.0482689 .1839322
1 215 | .0488759 .0575293 0.85 0.396 -.0639293 .1616812
1 216 | .0640663 .0535542 1.20 0.232 -.0409445 .1690771
1 217 | .1116125 .0550732 2.03 0.043 .0036231 .2196019
1 218 | .0455876 .0588809 0.77 0.439 -.0698678 .1610431
1 219 | .075108 .0571309 1.31 0.189 -.0369162 .1871321
1 220 | .0397308 .0535761 0.74 0.458 -.0653228 .1447844
1 221 | .0552557 .0552834 1.00 0.318 -.0531458 .1636572
1 222 | -.0020417 .054016 -0.04 0.970 -.1079581 .1038746
1 223 | .1165343 .0573681 2.03 0.042 .0040452 .2290234
1 224 | .0704826 .0533518 1.32 0.187 -.0341314 .1750965
1 225 | .0455215 .054141 0.84 0.401 -.0606398 .1516829
1 226 | .032252 .0516954 0.62 0.533 -.0691139 .133618
1 227 | .0548579 .0539049 1.02 0.309 -.0508405 .1605564
1 228 | .0047376 .0529042 0.09 0.929 -.0989986 .1084738
1 229 | .0699751 .0683721 1.02 0.306 -.0640911 .2040413
1 230 | .0969088 .0547643 1.77 0.077 -.0104748 .2042924
1 231 | .0756696 .0567113 1.33 0.182 -.0355317 .1868709
1 232 | .0312543 .0535077 0.58 0.559 -.0736654 .136174
1 233 | .027213 .0545456 0.50 0.618 -.0797417 .1341677
1 234 | -.0005542 .0541945 -0.01 0.992 -.1068206 .1057122
|
_cons | .5817448 .0200652 28.99 0.000 .5424004 .6210893
------------------------------+----------------------------------------------------------------
sigma_u | .5225506
sigma_e | .86639323
rho | .26673841 (fraction of variance due to u_i)
-----------------------------------------------------------------------------------------------
manhattan_qt_results_xt.rtf
dir : seeout
note: 1.flag_school omitted because of collinearity
note: 1.flag_priorityinters omitted because of collinearity
note: 1.flag_seniors omitted because of collinearity
Fixed-effects (within) regression Number of obs = 68,400
Group variable: _ID Number of groups = 2,736
R-sq: Obs per group:
within = 0.0153 min = 25
between = 0.1502 avg = 25.0
overall = 0.0000 max = 25
F(100,2735) = 6.60
corr(u_i, Xb) = -0.3281 Prob > F = 0.0000
(Std. Err. adjusted for 2,736 clusters in _ID)
-----------------------------------------------------------------------------------------------
| Robust
pedestriansinjured | Coef. Std. Err. t P>|t| [95% Conf. Interval]
------------------------------+----------------------------------------------------------------
1.flag_LPIS | -.0389096 .0109102 -3.57 0.000 -.0603027 -.0175165
bike_route_tv | -.0110104 .0128063 -0.86 0.390 -.0361214 .0141005
flag_street_improv | -.0457458 .0301265 -1.52 0.129 -.1048187 .0133272
flag_left_turn | -.1676084 .0494322 -3.39 0.001 -.2645366 -.0706802
|
quarterly |
211 | .0134802 .0144283 0.93 0.350 -.0148113 .0417716
212 | .0205301 .0142177 1.44 0.149 -.0073485 .0484087
213 | .020869 .0147355 1.42 0.157 -.008025 .0497629
214 | .0011833 .0144453 0.08 0.935 -.0271415 .029508
215 | .0199535 .0147763 1.35 0.177 -.0090202 .0489273
216 | .0184185 .0144096 1.28 0.201 -.0098363 .0466734
217 | -.0105146 .0134318 -0.78 0.434 -.0368521 .0158229
218 | -.0355236 .0128223 -2.77 0.006 -.0606659 -.0103812
219 | .01597 .0139853 1.14 0.254 -.0114528 .0433928
220 | -.0241865 .0133525 -1.81 0.070 -.0503685 .0019955
221 | -.0290266 .0132177 -2.20 0.028 -.0549442 -.0031089
222 | -.0232654 .0136446 -1.71 0.088 -.0500201 .0034894
223 | .0041081 .0140965 0.29 0.771 -.0235328 .031749
224 | -.0146062 .0135574 -1.08 0.281 -.0411899 .0119775
225 | -.0717688 .0121003 -5.93 0.000 -.0954955 -.0480421
226 | -.0811499 .0124057 -6.54 0.000 -.1054754 -.0568244
227 | -.0701239 .0126792 -5.53 0.000 -.0949856 -.0452621
228 | -.0164721 .01446 -1.14 0.255 -.0448257 .0118814
229 | -.0345439 .0132476 -2.61 0.009 -.0605201 -.0085676
230 | -.075307 .0125927 -5.98 0.000 -.0999992 -.0506149
231 | -.027706 .0139795 -1.98 0.048 -.0551173 -.0002946
232 | -.0199675 .0134368 -1.49 0.137 -.0463148 .0063798
233 | -.0536704 .0128502 -4.18 0.000 -.0788675 -.0284734
234 | -.0611679 .0123874 -4.94 0.000 -.0854574 -.0368784
|
1.flag_school | 0 (omitted)
|
flag_school#quarterly |
1 211 | .0636086 .0462062 1.38 0.169 -.0269941 .1542112
1 212 | .0767626 .0540553 1.42 0.156 -.0292308 .182756
1 213 | .0010027 .0495238 0.02 0.984 -.0961052 .0981106
1 214 | .0046304 .0482614 0.10 0.924 -.090002 .0992628
1 215 | .045382 .0554882 0.82 0.414 -.063421 .1541851
1 216 | .0034269 .0531592 0.06 0.949 -.1008094 .1076632
1 217 | .0215105 .0479176 0.45 0.654 -.0724479 .1154689
1 218 | .0357236 .0465507 0.77 0.443 -.0555545 .1270017
1 219 | .0599164 .0546911 1.10 0.273 -.0473236 .1671563
1 220 | .0473785 .0514908 0.92 0.358 -.0535863 .1483433
1 221 | -.0278527 .0389018 -0.72 0.474 -.1041327 .0484273
1 222 | -.0240847 .038758 -0.62 0.534 -.1000827 .0519132
1 223 | -.0364002 .0455522 -0.80 0.424 -.1257205 .05292
1 224 | .0005069 .0488308 0.01 0.992 -.0952422 .096256
1 225 | .0601257 .0483702 1.24 0.214 -.0347201 .1549716
1 226 | .0108541 .0389063 0.28 0.780 -.0654346 .0871428
1 227 | -.008949 .0392734 -0.23 0.820 -.0859576 .0680595
1 228 | .0167639 .0452459 0.37 0.711 -.0719558 .1054835
1 229 | -.0151782 .046918 -0.32 0.746 -.1071766 .0768201
1 230 | .0818649 .0447252 1.83 0.067 -.0058337 .1695634
1 231 | .023594 .0445719 0.53 0.597 -.063804 .110992
1 232 | .0327669 .0481958 0.68 0.497 -.061737 .1272708
1 233 | .0136114 .039692 0.34 0.732 -.0642179 .0914407
1 234 | .0744941 .045615 1.63 0.103 -.0149492 .1639375
|
1.flag_priorityinters | 0 (omitted)
|
flag_priorityinters#quarterly |
1 211 | .0692465 .2114672 0.33 0.743 -.3454052 .4838982
1 212 | .0315256 .2197061 0.14 0.886 -.3992812 .4623324
1 213 | -.0585784 .1864602 -0.31 0.753 -.4241955 .3070387
1 214 | -.0405116 .1781852 -0.23 0.820 -.3899028 .3088797
1 215 | .3749948 .209857 1.79 0.074 -.0364995 .7864891
1 216 | -.0181737 .2136902 -0.09 0.932 -.4371841 .4008368
1 217 | -.2198118 .1572534 -1.40 0.162 -.5281592 .0885355
1 218 | -.3261224 .1678526 -1.94 0.052 -.655253 .0030082
1 219 | -.2873297 .1851706 -1.55 0.121 -.6504181 .0757586
1 220 | -.2615731 .1798415 -1.45 0.146 -.614212 .0910658
1 221 | -.4102507 .177241 -2.31 0.021 -.7577904 -.0627109
1 222 | -.3741167 .1623733 -2.30 0.021 -.6925035 -.0557299
1 223 | -.3127154 .2169994 -1.44 0.150 -.7382147 .1127838
1 224 | -.2915403 .1858554 -1.57 0.117 -.6559715 .0728909
1 225 | -.3826943 .1627264 -2.35 0.019 -.7017734 -.0636152
1 226 | -.5876138 .1663741 -3.53 0.000 -.9138455 -.2613821
1 227 | -.4963999 .1853722 -2.68 0.007 -.8598837 -.1329162
1 228 | -.4703513 .1999191 -2.35 0.019 -.8623591 -.0783436
1 229 | -.3991088 .1666318 -2.40 0.017 -.7258457 -.0723719
1 230 | -.5517612 .1732755 -3.18 0.001 -.8915254 -.211997
1 231 | -.6505178 .1727045 -3.77 0.000 -.9891624 -.3118733
1 232 | -.5295989 .1772602 -2.99 0.003 -.8771764 -.1820214
1 233 | -.6247164 .1720347 -3.63 0.000 -.9620475 -.2873852
1 234 | -.435988 .1899168 -2.30 0.022 -.8083829 -.0635931
|
1.flag_seniors | 0 (omitted)
|
flag_seniors#quarterly |
1 211 | .0088284 .0300745 0.29 0.769 -.0501426 .0677994
1 212 | -.0291783 .0288268 -1.01 0.312 -.0857028 .0273463
1 213 | -.0179459 .0289008 -0.62 0.535 -.0746155 .0387236
1 214 | -.0140875 .0287029 -0.49 0.624 -.0703691 .0421941
1 215 | .0103218 .0301903 0.34 0.732 -.0488762 .0695199
1 216 | .0035262 .0297563 0.12 0.906 -.0548208 .0618733
1 217 | .0234993 .0277572 0.85 0.397 -.0309278 .0779264
1 218 | .0164964 .0315266 0.52 0.601 -.045322 .0783148
1 219 | .0099515 .028425 0.35 0.726 -.0457852 .0656881
1 220 | -.0092797 .0277177 -0.33 0.738 -.0636295 .04507
1 221 | -.0045282 .0270736 -0.17 0.867 -.057615 .0485586
1 222 | -.0289338 .0267246 -1.08 0.279 -.0813362 .0234686
1 223 | .0393116 .029934 1.31 0.189 -.0193839 .0980072
1 224 | .0284557 .0286502 0.99 0.321 -.0277225 .0846338
1 225 | .0022798 .0262878 0.09 0.931 -.0492662 .0538258
1 226 | -.0033354 .0254486 -0.13 0.896 -.0532358 .0465651
1 227 | .0234572 .0269227 0.87 0.384 -.0293336 .0762481
1 228 | -.0140688 .0287275 -0.49 0.624 -.0703987 .0422611
1 229 | .0254135 .045984 0.55 0.581 -.0647535 .1155804
1 230 | .0261451 .0267899 0.98 0.329 -.0263855 .0786757
1 231 | .0040899 .0274098 0.15 0.881 -.0496561 .0578359
1 232 | .0153882 .0283394 0.54 0.587 -.0401807 .0709571
1 233 | .0056958 .026157 0.22 0.828 -.0455937 .0569852
1 234 | -.0079165 .0260335 -0.30 0.761 -.0589638 .0431307
|
_cons | .1940258 .0095533 20.31 0.000 .1752933 .2127582
------------------------------+----------------------------------------------------------------
sigma_u | .21613024
sigma_e | .44099032
rho | .19367842 (fraction of variance due to u_i)
-----------------------------------------------------------------------------------------------
manhattan_qt_results_xt.rtf
dir : seeout
note: 1.flag_school omitted because of collinearity
note: 1.flag_priorityinters omitted because of collinearity
note: 1.flag_seniors omitted because of collinearity
Fixed-effects (within) regression Number of obs = 68,400
Group variable: _ID Number of groups = 2,736
R-sq: Obs per group:
within = 0.0100 min = 25
between = 0.0399 avg = 25.0
overall = 0.0035 max = 25
F(100,2735) = 6.35
corr(u_i, Xb) = -0.1282 Prob > F = 0.0000
(Std. Err. adjusted for 2,736 clusters in _ID)
-----------------------------------------------------------------------------------------------
| Robust
cyclistinjured | Coef. Std. Err. t P>|t| [95% Conf. Interval]
------------------------------+----------------------------------------------------------------
1.flag_LPIS | -.0166129 .0066185 -2.51 0.012 -.0295906 -.0036353
bike_route_tv | .0035207 .0073469 0.48 0.632 -.0108854 .0179268
flag_street_improv | .0051524 .019795 0.26 0.795 -.0336622 .043967
flag_left_turn | -.0284481 .0250037 -1.14 0.255 -.0774761 .02058
|
quarterly |
211 | -.0371728 .0086886 -4.28 0.000 -.0542097 -.0201358
212 | -.0441928 .0085278 -5.18 0.000 -.0609145 -.0274712
213 | -.0027924 .0099347 -0.28 0.779 -.0222727 .0166878
214 | .0110591 .010218 1.08 0.279 -.0089767 .0310948
215 | -.0179172 .0092143 -1.94 0.052 -.0359849 .0001505
216 | -.0484222 .0084877 -5.71 0.000 -.0650651 -.0317793
217 | .0097852 .0101966 0.96 0.337 -.0102086 .029779
218 | .0276229 .0109104 2.53 0.011 .0062293 .0490164
219 | -.0204895 .0088711 -2.31 0.021 -.0378843 -.0030947
220 | -.0570681 .008035 -7.10 0.000 -.0728234 -.0413127
221 | -.0015868 .0093665 -0.17 0.865 -.019953 .0167794
222 | .0172596 .0099883 1.73 0.084 -.0023257 .036845
223 | .0097092 .0098777 0.98 0.326 -.0096593 .0290777
224 | -.0439921 .0085855 -5.12 0.000 -.0608269 -.0271573
225 | -.0115709 .0093305 -1.24 0.215 -.0298665 .0067247
226 | -.0324507 .0089306 -3.63 0.000 -.0499621 -.0149393
227 | -.0471605 .0085175 -5.54 0.000 -.0638618 -.0304591
228 | -.0521415 .0084349 -6.18 0.000 -.0686809 -.035602
229 | -.0148086 .0093758 -1.58 0.114 -.0331929 .0035757
230 | -.0133592 .0093761 -1.42 0.154 -.0317442 .0050258
231 | -.0324556 .0090442 -3.59 0.000 -.0501898 -.0147214
232 | -.0413213 .0085569 -4.83 0.000 -.0580999 -.0245427
233 | -.014736 .0095168 -1.55 0.122 -.0333969 .0039248
234 | .0063261 .0101906 0.62 0.535 -.013656 .0263082
|
1.flag_school | 0 (omitted)
|
flag_school#quarterly |
1 211 | .0107956 .0276384 0.39 0.696 -.0433987 .0649898
1 212 | .0219995 .0276499 0.80 0.426 -.0322173 .0762164
1 213 | .0236679 .0330308 0.72 0.474 -.0410999 .0884358
1 214 | .044808 .0353432 1.27 0.205 -.0244941 .1141102
1 215 | .0105308 .0315463 0.33 0.739 -.0513262 .0723878
1 216 | .0035951 .0264357 0.14 0.892 -.0482408 .055431
1 217 | -.0227782 .0316017 -0.72 0.471 -.0847437 .0391874
1 218 | -.0295869 .0318174 -0.93 0.353 -.0919754 .0328016
1 219 | .0074576 .0305399 0.24 0.807 -.052426 .0673412
1 220 | .0416436 .0275178 1.51 0.130 -.0123142 .0956014
1 221 | .0397611 .0352892 1.13 0.260 -.0294352 .1089573
1 222 | .0183553 .0348523 0.53 0.598 -.0499843 .0866948
1 223 | -.0198433 .0289005 -0.69 0.492 -.0765124 .0368258
1 224 | .0156825 .0265363 0.59 0.555 -.0363508 .0677158
1 225 | .0165924 .0307417 0.54 0.589 -.0436869 .0768717
1 226 | .0111913 .0296889 0.38 0.706 -.0470236 .0694062
1 227 | .0206266 .0274535 0.75 0.453 -.0332052 .0744584
1 228 | .030737 .0303476 1.01 0.311 -.0287696 .0902436
1 229 | .0422803 .030725 1.38 0.169 -.0179662 .1025269
1 230 | .0515067 .034697 1.48 0.138 -.0165282 .1195416
1 231 | .0345209 .028732 1.20 0.230 -.0218177 .0908595
1 232 | .0058112 .0244191 0.24 0.812 -.0420705 .0536929
1 233 | .032068 .0287518 1.12 0.265 -.0243094 .0884455
1 234 | .0189022 .0334983 0.56 0.573 -.0467823 .0845867
|
1.flag_priorityinters | 0 (omitted)
|
flag_priorityinters#quarterly |
1 211 | -.2164811 .1101621 -1.97 0.050 -.4324904 -.0004717
1 212 | -.0466008 .1401409 -0.33 0.740 -.3213935 .2281919
1 213 | -.1351913 .107294 -1.26 0.208 -.3455769 .0751942
1 214 | .073819 .1506295 0.49 0.624 -.2215402 .3691782
1 215 | -.1400154 .1043633 -1.34 0.180 -.3446542 .0646234
1 216 | -.1543123 .116268 -1.33 0.185 -.3822943 .0736697
1 217 | .0983448 .1273015 0.77 0.440 -.151272 .3479615
1 218 | .0484164 .1239021 0.39 0.696 -.1945348 .2913676
1 219 | -.0896254 .1229072 -0.73 0.466 -.3306258 .151375
1 220 | -.1612579 .0765237 -2.11 0.035 -.3113081 -.0112078
1 221 | -.1560971 .1175962 -1.33 0.184 -.3866835 .0744893
1 222 | .0522328 .1392251 0.38 0.708 -.2207642 .3252298
1 223 | .0003918 .1182005 0.00 0.997 -.2313795 .2321631
1 224 | -.1317263 .1310487 -1.01 0.315 -.3886908 .1252382
1 225 | -.0470462 .1199181 -0.39 0.695 -.2821853 .1880929
1 226 | -.0757914 .1311522 -0.58 0.563 -.3329589 .1813761
1 227 | -.131818 .123108 -1.07 0.284 -.3732121 .1095761
1 228 | -.1896702 .1145011 -1.66 0.098 -.4141876 .0348473
1 229 | -.0732765 .0987957 -0.74 0.458 -.2669982 .1204453
1 230 | -.1601849 .1112335 -1.44 0.150 -.378295 .0579252
1 231 | -.138609 .0966576 -1.43 0.152 -.3281384 .0509204
1 232 | -.1658836 .1093701 -1.52 0.129 -.38034 .0485728
1 233 | -.0889003 .1152564 -0.77 0.441 -.3148988 .1370981
1 234 | -.0641302 .1163757 -0.55 0.582 -.2923234 .164063
|
1.flag_seniors | 0 (omitted)
|
flag_seniors#quarterly |
1 211 | .0231077 .017898 1.29 0.197 -.0119873 .0582027
1 212 | .0024538 .0176025 0.14 0.889 -.0320618 .0369694
1 213 | .0095255 .0186046 0.51 0.609 -.026955 .0460059
1 214 | .0053455 .0204494 0.26 0.794 -.0347524 .0454433
1 215 | .0060306 .018784 0.32 0.748 -.0308016 .0428628
1 216 | .0087698 .0163742 0.54 0.592 -.0233373 .0408769
1 217 | .0125255 .020119 0.62 0.534 -.0269244 .0519754
1 218 | -.0193745 .0197744 -0.98 0.327 -.0581488 .0193997
1 219 | -.0015599 .0174136 -0.09 0.929 -.035705 .0325852
1 220 | -.0132583 .0151576 -0.87 0.382 -.0429797 .0164632
1 221 | .0024963 .0187996 0.13 0.894 -.0343665 .0393592
1 222 | .0034205 .0203178 0.17 0.866 -.0364194 .0432604
1 223 | -.0109725 .0185946 -0.59 0.555 -.0474333 .0254884
1 224 | .0061347 .0167368 0.37 0.714 -.0266834 .0389528
1 225 | -.0098287 .0176201 -0.56 0.577 -.0443788 .0247214
1 226 | .0071486 .0173757 0.41 0.681 -.0269223 .0412195
1 227 | .0266446 .0176512 1.51 0.131 -.0079665 .0612558
1 228 | .0153076 .0166416 0.92 0.358 -.0173237 .0479389
1 229 | .0187911 .0189738 0.99 0.322 -.0184133 .0559954
1 230 | .013647 .0182497 0.75 0.455 -.0221376 .0494315
1 231 | .0117325 .0175018 0.67 0.503 -.0225855 .0460505
1 232 | -.0068715 .0165379 -0.42 0.678 -.0392995 .0255564
1 233 | .0100051 .0180281 0.55 0.579 -.0253449 .0453551
1 234 | .0075772 .019216 0.39 0.693 -.0301021 .0452565
|
_cons | .0928261 .0061941 14.99 0.000 .0806804 .1049717
------------------------------+----------------------------------------------------------------
sigma_u | .10027676
sigma_e | .28082736
rho | .1130847 (fraction of variance due to u_i)
-----------------------------------------------------------------------------------------------
manhattan_qt_results_xt.rtf
dir : seeout
note: 1.flag_school omitted because of collinearity
note: 1.flag_priorityinters omitted because of collinearity
note: 1.flag_seniors omitted because of collinearity
Fixed-effects (within) regression Number of obs = 68,400
Group variable: _ID Number of groups = 2,736
R-sq: Obs per group:
within = 0.0061 min = 25
between = 0.0476 avg = 25.0
overall = 0.0001 max = 25
F(100,2735) = 3.60
corr(u_i, Xb) = -0.2673 Prob > F = 0.0000
(Std. Err. adjusted for 2,736 clusters in _ID)
-----------------------------------------------------------------------------------------------
| Robust
motoristinjured | Coef. Std. Err. t P>|t| [95% Conf. Interval]
------------------------------+----------------------------------------------------------------
1.flag_LPIS | -.0090599 .0153354 -0.59 0.555 -.03913 .0210102
bike_route_tv | .03614 .0188536 1.92 0.055 -.0008287 .0731087
flag_street_improv | -.0296986 .0461439 -0.64 0.520 -.1201789 .0607818
flag_left_turn | -.0965775 .0603787 -1.60 0.110 -.21497 .0218151
|
quarterly |
211 | -.0580241 .0276245 -2.10 0.036 -.1121912 -.0038571
212 | -.0900464 .0246476 -3.65 0.000 -.1383762 -.0417165
213 | -.0470399 .0241018 -1.95 0.051 -.0942995 .0002197
214 | -.0372343 .0249969 -1.49 0.136 -.086249 .0117804
215 | -.0803418 .0247274 -3.25 0.001 -.1288281 -.0318556
216 | -.1200441 .0240789 -4.99 0.000 -.1672588 -.0728294
217 | -.0715463 .0270494 -2.65 0.008 -.1245856 -.018507
218 | -.0735583 .0258206 -2.85 0.004 -.1241881 -.0229284
219 | -.1085884 .0254137 -4.27 0.000 -.1584204 -.0587564
220 | -.1331725 .0240519 -5.54 0.000 -.1803343 -.0860108
221 | -.0975397 .0243499 -4.01 0.000 -.1452859 -.0497936
222 | -.0865477 .0234244 -3.69 0.000 -.1324789 -.0406164
223 | -.1062888 .0242686 -4.38 0.000 -.1538755 -.0587022
224 | -.1158917 .0232765 -4.98 0.000 -.1615331 -.0702504
225 | -.1262286 .0240049 -5.26 0.000 -.1732982 -.0791591
226 | -.1659222 .0231949 -7.15 0.000 -.2114035 -.1204409
227 | -.1520061 .0236901 -6.42 0.000 -.1984584 -.1055539
228 | -.1284391 .0244038 -5.26 0.000 -.1762909 -.0805874
229 | -.0901649 .0244985 -3.68 0.000 -.1382022 -.0421276
230 | -.1049376 .0235767 -4.45 0.000 -.1511676 -.0587077
231 | -.1198362 .0248894 -4.81 0.000 -.1686402 -.0710322
232 | -.1341363 .0236992 -5.66 0.000 -.1806065 -.0876661
233 | -.0839298 .0243157 -3.45 0.001 -.1316089 -.0362508
234 | -.0784114 .024696 -3.18 0.002 -.1268362 -.0299866
|
1.flag_school | 0 (omitted)
|
flag_school#quarterly |
1 211 | .0231677 .0821774 0.28 0.778 -.1379685 .1843038
1 212 | .0235278 .0824072 0.29 0.775 -.1380588 .1851144
1 213 | .0511918 .0756496 0.68 0.499 -.0971442 .1995279
1 214 | .0509281 .1078939 0.47 0.637 -.1606337 .26249
1 215 | .0626379 .076683 0.82 0.414 -.0877245 .2130002
1 216 | -.0318794 .0654827 -0.49 0.626 -.1602799 .0965211
1 217 | -.0745217 .0638496 -1.17 0.243 -.19972 .0506767
1 218 | -.0026925 .0678144 -0.04 0.968 -.1356652 .1302802
1 219 | .1571835 .0953649 1.65 0.099 -.029811 .3441779
1 220 | -.0242574 .0638276 -0.38 0.704 -.1494127 .1008978
1 221 | .086712 .0920565 0.94 0.346 -.0937954 .2672193
1 222 | -.0017559 .0768057 -0.02 0.982 -.152359 .1488472
1 223 | -.031207 .0575369 -0.54 0.588 -.1440272 .0816131
1 224 | .0609712 .0744564 0.82 0.413 -.0850252 .2069676
1 225 | .0799422 .0747767 1.07 0.285 -.0666823 .2265667
1 226 | -.0027085 .0597125 -0.05 0.964 -.1197947 .1143777
1 227 | -.0250026 .0572203 -0.44 0.662 -.1372021 .0871968
1 228 | -.0415801 .0632831 -0.66 0.511 -.1656677 .0825075
1 229 | -.0308623 .071747 -0.43 0.667 -.1715461 .1098214
1 230 | -.054398 .0522844 -1.04 0.298 -.1569189 .0481229
1 231 | .0866718 .0692532 1.25 0.211 -.049122 .2224656
1 232 | .1155951 .0840025 1.38 0.169 -.0491196 .2803099
1 233 | .0378427 .0708133 0.53 0.593 -.1010103 .1766957
1 234 | .0820174 .0743279 1.10 0.270 -.0637271 .2277618
|
1.flag_priorityinters | 0 (omitted)
|
flag_priorityinters#quarterly |
1 211 | -.459468 .2782665 -1.65 0.099 -1.005102 .0861658
1 212 | -.3930911 .3475869 -1.13 0.258 -1.07465 .2884683
1 213 | .1690428 .3577072 0.47 0.637 -.5323609 .8704465
1 214 | -.1717086 .3742409 -0.46 0.646 -.9055321 .5621148
1 215 | -.0678395 .3342255 -0.20 0.839 -.7231995 .5875206
1 216 | -.3643394 .3179955 -1.15 0.252 -.987875 .2591962
1 217 | -.2866082 .3131389 -0.92 0.360 -.900621 .3274045
1 218 | -.4553161 .2762005 -1.65 0.099 -.9968988 .0862667
1 219 | -.4120285 .3526001 -1.17 0.243 -1.103418 .2793609
1 220 | -.7999219 .2617868 -3.06 0.002 -1.313242 -.286602
1 221 | -.1957726 .2888122 -0.68 0.498 -.7620847 .3705394
1 222 | -.1884546 .3214777 -0.59 0.558 -.8188183 .4419092
1 223 | -.2570023 .3031028 -0.85 0.397 -.8513359 .3373313
1 224 | -.2772169 .2391796 -1.16 0.247 -.7462079 .1917741
1 225 | -.3878235 .3132448 -1.24 0.216 -1.002044 .2263967
1 226 | -.6461232 .3223849 -2.00 0.045 -1.278266 -.0139805
1 227 | -.5724836 .3033321 -1.89 0.059 -1.167267 .0222997
1 228 | -.3704354 .3379779 -1.10 0.273 -1.033153 .2922823
1 229 | .0305077 .3936663 0.08 0.938 -.7414057 .8024211
1 230 | -.5384995 .2678459 -2.01 0.044 -1.0637 -.0132988
1 231 | -.4600553 .3071271 -1.50 0.134 -1.06228 .1421693
1 232 | -.6556237 .2811315 -2.33 0.020 -1.206875 -.1043721
1 233 | -.4526551 .3121299 -1.45 0.147 -1.064689 .1593792
1 234 | -.679156 .2866181 -2.37 0.018 -1.241166 -.1171462
|
1.flag_seniors | 0 (omitted)
|
flag_seniors#quarterly |
1 211 | .0141654 .0445512 0.32 0.751 -.073192 .1015228
1 212 | .0408312 .045191 0.90 0.366 -.0477807 .1294431
1 213 | .0239697 .0434047 0.55 0.581 -.0611397 .109079
1 214 | .0765045 .0482715 1.58 0.113 -.0181478 .1711567
1 215 | .0324672 .0432259 0.75 0.453 -.0522914 .1172259
1 216 | .0517139 .0407473 1.27 0.205 -.0281847 .1316126
1 217 | .0755363 .0445375 1.70 0.090 -.0117942 .1628668
1 218 | .0484029 .0443624 1.09 0.275 -.0385844 .1353902
1 219 | .0665596 .0443141 1.50 0.133 -.0203328 .153452
1 220 | .0621109 .0425182 1.46 0.144 -.02126 .1454819
1 221 | .0571455 .0430333 1.33 0.184 -.0272356 .1415265
1 222 | .0233548 .0407303 0.57 0.566 -.0565104 .10322
1 223 | .0880819 .0443048 1.99 0.047 .0012075 .1749562
1 224 | .038519 .0405712 0.95 0.342 -.0410342 .1180722
1 225 | .0623141 .041166 1.51 0.130 -.0184056 .1430337
1 226 | .0406596 .0406779 1.00 0.318 -.0391029 .1204222
1 227 | .0199484 .0409017 0.49 0.626 -.0602529 .1001497
1 228 | .0129173 .0417098 0.31 0.757 -.0688686 .0947031
1 229 | .0254928 .0423146 0.60 0.547 -.057479 .1084646
1 230 | .0611929 .0433807 1.41 0.158 -.0238693 .1462551
1 231 | .0590719 .0432009 1.37 0.172 -.0256379 .1437816
1 232 | .0229682 .0414104 0.55 0.579 -.0582307 .104167
1 233 | .0090049 .0419088 0.21 0.830 -.0731712 .0911809
1 234 | .0022732 .0426051 0.05 0.957 -.0812683 .0858147
|
_cons | .2942223 .0159184 18.48 0.000 .2630091 .3254356
------------------------------+----------------------------------------------------------------
sigma_u | .30129899
sigma_e | .67768256
rho | .16504609 (fraction of variance due to u_i)
-----------------------------------------------------------------------------------------------
manhattan_qt_results_xt.rtf
dir : seeout
[31]:
global filename manhattan_qt_results_xt_poisson
xtpoisson collision_count i.flag_LPIS $time_variant_var $time_var $time_trend, fe vce(robust)
outreg2 using "$filename", word replace ctitle(xtpoisson fe collision_count) title(Manhattan Fixed Effects Poisson Models)
xtpoisson personsinjured i.flag_LPIS $time_variant_var $time_var $time_trend, fe vce(robust)
outreg2 using "$filename", word append ctitle(xtpoisson fe personsinjured)
xtpoisson pedestriansinjured i.flag_LPIS $time_variant_var $time_var $time_trend, fe vce(robust)
outreg2 using "$filename", word append ctitle(xtpoisson fe pedestriansinjured)
xtpoisson cyclistinjured i.flag_LPIS $time_variant_var $time_var $time_trend, fe vce(robust)
outreg2 using "$filename", word append ctitle(xtpoisson fe cyclistinjured)
xtpoisson motoristinjured i.flag_LPIS $time_variant_var $time_var $time_trend, fe vce(robust)
outreg2 using "$filename", word append ctitle(xtpoisson fe motoristinjured)
note: 288 groups (7200 obs) dropped because of all zero outcomes
Iteration 0: log pseudolikelihood = -103566.94
Iteration 1: log pseudolikelihood = -99691.291
Iteration 2: log pseudolikelihood = -99649.254
Iteration 3: log pseudolikelihood = -99649.205
Iteration 4: log pseudolikelihood = -99649.205
Conditional fixed-effects Poisson regression Number of obs = 61,200
Group variable: _ID Number of groups = 2,448
Obs per group:
min = 25
avg = 25.0
max = 25
Wald chi2(100) = 3086.35
Log pseudolikelihood = -99649.205 Prob > chi2 = 0.0000
(Std. Err. adjusted for clustering on _ID)
-----------------------------------------------------------------------------------------------
| Robust
collision_count | Coef. Std. Err. z P>|z| [95% Conf. Interval]
------------------------------+----------------------------------------------------------------
1.flag_LPIS | .0048057 .0195622 0.25 0.806 -.0335355 .0431468
bike_route_tv | .0351656 .0297782 1.18 0.238 -.0231987 .0935299
flag_street_improv | -.0613567 .0635351 -0.97 0.334 -.1858832 .0631698
flag_left_turn | -.0260318 .0521309 -0.50 0.618 -.1282065 .0761429
|
quarterly |
211 | -.1049751 .0210917 -4.98 0.000 -.146314 -.0636361
212 | -.1733256 .0214262 -8.09 0.000 -.2153203 -.1313309
213 | .0124606 .0205447 0.61 0.544 -.0278062 .0527274
214 | -.01916 .0199126 -0.96 0.336 -.058188 .019868
215 | -.0320798 .0206721 -1.55 0.121 -.0725963 .0084368
216 | -.1851656 .0218022 -8.49 0.000 -.2278971 -.1424341
217 | .0025509 .0205056 0.12 0.901 -.0376394 .0427412
218 | -.0143907 .0207009 -0.70 0.487 -.0549636 .0261823
219 | -.0361593 .0206516 -1.75 0.080 -.0766357 .0043171
220 | -.2019574 .022836 -8.84 0.000 -.2467152 -.1571997
221 | .0119633 .0220853 0.54 0.588 -.0313231 .0552496
222 | .0089382 .0211165 0.42 0.672 -.0324494 .0503257
223 | .026523 .0206969 1.28 0.200 -.0140421 .0670881
224 | -.1364619 .0218993 -6.23 0.000 -.1793838 -.0935401
225 | -.293912 .0252341 -11.65 0.000 -.3433699 -.244454
226 | -.656013 .0288837 -22.71 0.000 -.7126241 -.5994019
227 | -.6720199 .0307651 -21.84 0.000 -.7323184 -.6117215
228 | -.5302557 .0265365 -19.98 0.000 -.5822663 -.4782451
229 | -.2795953 .0272673 -10.25 0.000 -.3330382 -.2261525
230 | -.4851792 .0283793 -17.10 0.000 -.5408016 -.4295568
231 | -.4346613 .0278103 -15.63 0.000 -.4891684 -.3801542
232 | -.4436832 .0274618 -16.16 0.000 -.4975073 -.3898591
233 | -.2974448 .0273272 -10.88 0.000 -.3510051 -.2438845
234 | -.3945939 .027056 -14.58 0.000 -.4476227 -.341565
|
1.flag_school | 0 (omitted)
|
flag_school#quarterly |
1 211 | .1390387 .0828313 1.68 0.093 -.0233076 .301385
1 212 | .1072472 .0831627 1.29 0.197 -.0557487 .2702431
1 213 | .1109154 .0872217 1.27 0.203 -.060036 .2818667
1 214 | .0428494 .0780116 0.55 0.583 -.1100504 .1957493
1 215 | -.0046906 .0944173 -0.05 0.960 -.1897452 .180364
1 216 | .0141465 .094059 0.15 0.880 -.1702058 .1984988
1 217 | .0950407 .1052606 0.90 0.367 -.1112663 .3013477
1 218 | .0155591 .0899941 0.17 0.863 -.160826 .1919442
1 219 | .2111066 .0752882 2.80 0.005 .0635445 .3586687
1 220 | .1742032 .0976229 1.78 0.074 -.0171341 .3655406
1 221 | .0331902 .0910281 0.36 0.715 -.1452216 .211602
1 222 | .0881207 .0911344 0.97 0.334 -.0904993 .2667408
1 223 | .0983925 .0809413 1.22 0.224 -.0602494 .2570344
1 224 | -.0068888 .0906384 -0.08 0.939 -.1845368 .1707592
1 225 | .1446717 .1072069 1.35 0.177 -.06545 .3547935
1 226 | -.1873878 .1419223 -1.32 0.187 -.4655503 .0907747
1 227 | -.1416774 .1281812 -1.11 0.269 -.3929079 .1095532
1 228 | -.042237 .1107416 -0.38 0.703 -.2592865 .1748124
1 229 | .1717648 .1108201 1.55 0.121 -.0454385 .3889681
1 230 | .0930484 .1017895 0.91 0.361 -.1064554 .2925522
1 231 | .1572654 .1080143 1.46 0.145 -.0544387 .3689696
1 232 | .1095634 .1064298 1.03 0.303 -.0990352 .318162
1 233 | .0011373 .1106108 0.01 0.992 -.2156558 .2179305
1 234 | .1402674 .0924661 1.52 0.129 -.0409629 .3214976
|
1.flag_priorityinters | 0 (omitted)
|
flag_priorityinters#quarterly |
1 211 | -.0275089 .078609 -0.35 0.726 -.1815797 .1265619
1 212 | -.0483881 .0788076 -0.61 0.539 -.2028481 .1060719
1 213 | -.0938721 .0648451 -1.45 0.148 -.2209662 .033222
1 214 | -.0266151 .0662994 -0.40 0.688 -.1565594 .1033293
1 215 | .0115485 .064107 0.18 0.857 -.1140989 .137196
1 216 | -.1027087 .0804082 -1.28 0.201 -.2603058 .0548884
1 217 | -.1253614 .0620532 -2.02 0.043 -.2469834 -.0037394
1 218 | -.0660093 .0685169 -0.96 0.335 -.2003 .0682814
1 219 | -.1393874 .0903634 -1.54 0.123 -.3164964 .0377216
1 220 | -.1754995 .0922634 -1.90 0.057 -.3563326 .0053335
1 221 | -.1826911 .073609 -2.48 0.013 -.326962 -.0384202
1 222 | .0144736 .0658428 0.22 0.826 -.1145759 .1435231
1 223 | -.1554113 .07084 -2.19 0.028 -.2942551 -.0165676
1 224 | -.0899633 .0928176 -0.97 0.332 -.2718825 .0919559
1 225 | -.1097008 .0937184 -1.17 0.242 -.2933855 .073984
1 226 | -.1168685 .1148068 -1.02 0.309 -.3418857 .1081486
1 227 | -.2540728 .1236993 -2.05 0.040 -.4965191 -.0116266
1 228 | -.220849 .1057107 -2.09 0.037 -.4280381 -.0136599
1 229 | -.346719 .0959984 -3.61 0.000 -.5348725 -.1585656
1 230 | -.3024791 .1066545 -2.84 0.005 -.511518 -.0934401
1 231 | -.3799313 .1161181 -3.27 0.001 -.6075185 -.152344
1 232 | -.2300388 .1126405 -2.04 0.041 -.4508102 -.0092674
1 233 | -.3085084 .1028622 -3.00 0.003 -.5101146 -.1069022
1 234 | -.2847532 .094525 -3.01 0.003 -.4700189 -.0994875
|
1.flag_seniors | 0 (omitted)
|
flag_seniors#quarterly |
1 211 | .0961813 .0345365 2.78 0.005 .028491 .1638716
1 212 | .0401023 .0335592 1.19 0.232 -.0256726 .1058772
1 213 | .0238883 .0347844 0.69 0.492 -.0442879 .0920644
1 214 | .0502925 .0329563 1.53 0.127 -.0143006 .1148856
1 215 | .0798141 .0344083 2.32 0.020 .0123751 .147253
1 216 | .0992869 .0362228 2.74 0.006 .0282915 .1702823
1 217 | .0534696 .0332592 1.61 0.108 -.0117173 .1186565
1 218 | -.0185252 .0333839 -0.55 0.579 -.0839564 .046906
1 219 | .0464841 .0339771 1.37 0.171 -.0201098 .1130781
1 220 | .0430048 .037234 1.15 0.248 -.0299724 .115982
1 221 | .0585169 .0358164 1.63 0.102 -.0116819 .1287157
1 222 | .0336544 .0344917 0.98 0.329 -.0339482 .1012569
1 223 | .0593458 .0336972 1.76 0.078 -.0066994 .1253911
1 224 | .0265531 .0364995 0.73 0.467 -.0449846 .0980909
1 225 | -.059627 .04139 -1.44 0.150 -.14075 .021496
1 226 | .0644741 .0486249 1.33 0.185 -.030829 .1597771
1 227 | .1030042 .0506192 2.03 0.042 .0037924 .2022159
1 228 | .087729 .0448068 1.96 0.050 -.0000908 .1755488
1 229 | .0444603 .043829 1.01 0.310 -.041443 .1303635
1 230 | .1314936 .0442361 2.97 0.003 .0447924 .2181949
1 231 | .086929 .0455952 1.91 0.057 -.002436 .1762939
1 232 | -.0471691 .0466531 -1.01 0.312 -.1386074 .0442692
1 233 | .0184857 .0438874 0.42 0.674 -.0675321 .1045034
1 234 | -.0505826 .0426442 -1.19 0.236 -.1341637 .0329985
-----------------------------------------------------------------------------------------------
manhattan_qt_results_xt_poisson.rtf
dir : seeout
note: 370 groups (9250 obs) dropped because of all zero outcomes
Iteration 0: log pseudolikelihood = -48273.197
Iteration 1: log pseudolikelihood = -47662.614
Iteration 2: log pseudolikelihood = -47652.686
Iteration 3: log pseudolikelihood = -47652.663
Iteration 4: log pseudolikelihood = -47652.663
Conditional fixed-effects Poisson regression Number of obs = 59,150
Group variable: _ID Number of groups = 2,366
Obs per group:
min = 25
avg = 25.0
max = 25
Wald chi2(100) = 892.11
Log pseudolikelihood = -47652.663 Prob > chi2 = 0.0000
(Std. Err. adjusted for clustering on _ID)
-----------------------------------------------------------------------------------------------
| Robust
personsinjured | Coef. Std. Err. z P>|z| [95% Conf. Interval]
------------------------------+----------------------------------------------------------------
1.flag_LPIS | -.072317 .0353581 -2.05 0.041 -.1416175 -.0030165
bike_route_tv | .0361453 .0550298 0.66 0.511 -.0717111 .1440017
flag_street_improv | -.0770219 .0964664 -0.80 0.425 -.2660926 .1120489
flag_left_turn | -.1835375 .0900486 -2.04 0.042 -.3600296 -.0070454
|
quarterly |
211 | -.1531624 .0637346 -2.40 0.016 -.27808 -.0282448
212 | -.2227939 .0592041 -3.76 0.000 -.3388318 -.1067561
213 | -.0521531 .0555644 -0.94 0.348 -.1610573 .056751
214 | -.043134 .0558725 -0.77 0.440 -.1526422 .0663741
215 | -.1480303 .0569416 -2.60 0.009 -.2596337 -.0364269
216 | -.306179 .0602621 -5.08 0.000 -.4242905 -.1880676
217 | -.1346471 .0607746 -2.22 0.027 -.2537631 -.015531
218 | -.1525619 .0598265 -2.55 0.011 -.2698197 -.0353041
219 | -.217666 .0605328 -3.60 0.000 -.3363082 -.0990238
220 | -.4718929 .0627851 -7.52 0.000 -.5949494 -.3488364
221 | -.2531286 .0591373 -4.28 0.000 -.3690355 -.1372216
222 | -.1779567 .0555272 -3.20 0.001 -.2867881 -.0691252
223 | -.177824 .058286 -3.05 0.002 -.2920624 -.0635856
224 | -.3391987 .0588815 -5.76 0.000 -.4546043 -.2237931
225 | -.4383218 .0649687 -6.75 0.000 -.5656583 -.3109854
226 | -.6966112 .067696 -10.29 0.000 -.829293 -.5639295
227 | -.6889166 .0722918 -9.53 0.000 -.8306059 -.5472272
228 | -.5282647 .0664409 -7.95 0.000 -.6584865 -.3980429
229 | -.288455 .0613572 -4.70 0.000 -.4087129 -.1681972
230 | -.4239792 .0611257 -6.94 0.000 -.5437833 -.304175
231 | -.3925998 .0677908 -5.79 0.000 -.5254672 -.2597324
232 | -.4325669 .063451 -6.82 0.000 -.5569286 -.3082052
233 | -.321761 .0620182 -5.19 0.000 -.4433145 -.2002075
234 | -.2751052 .0618221 -4.45 0.000 -.3962743 -.1539362
|
1.flag_school | 0 (omitted)
|
flag_school#quarterly |
1 211 | .1917259 .2320809 0.83 0.409 -.2631444 .6465961
1 212 | .2333462 .2334874 1.00 0.318 -.2242807 .6909732
1 213 | .1576652 .2207398 0.71 0.475 -.2749767 .5903072
1 214 | .2152551 .2556366 0.84 0.400 -.2857834 .7162936
1 215 | .2346587 .2303098 1.02 0.308 -.2167403 .6860577
1 216 | -.2246195 .2500539 -0.90 0.369 -.7147161 .2654771
1 217 | -.2533591 .2390424 -1.06 0.289 -.7218736 .2151554
1 218 | -.0501536 .2292955 -0.22 0.827 -.4995646 .3992574
1 219 | .4493493 .2293873 1.96 0.050 -.0002416 .8989401
1 220 | .0077674 .2747776 0.03 0.977 -.5307869 .5463216
1 221 | .1780923 .2664933 0.67 0.504 -.344225 .7004095
1 222 | -.1102145 .2575317 -0.43 0.669 -.6149674 .3945383
1 223 | -.3322578 .2219931 -1.50 0.134 -.7673562 .1028406
1 224 | .073059 .2737793 0.27 0.790 -.4635385 .6096566
1 225 | .2934167 .2545382 1.15 0.249 -.205469 .7923024
1 226 | -.3426205 .2979333 -1.15 0.250 -.9265589 .241318
1 227 | -.4805972 .2871648 -1.67 0.094 -1.04343 .0822355
1 228 | -.292564 .3393837 -0.86 0.389 -.9577439 .3726159
1 229 | -.1414976 .2537066 -0.56 0.577 -.6387534 .3557582
1 230 | .0855763 .2133125 0.40 0.688 -.3325086 .5036611
1 231 | .2768622 .2322949 1.19 0.233 -.1784274 .7321518
1 232 | .2945175 .260342 1.13 0.258 -.2157435 .8047785
1 233 | .0937983 .2493638 0.38 0.707 -.3949458 .5825424
1 234 | .3700395 .228578 1.62 0.105 -.0779652 .8180442
|
1.flag_priorityinters | 0 (omitted)
|
flag_priorityinters#quarterly |
1 211 | -.1913236 .1761347 -1.09 0.277 -.5365414 .1538941
1 212 | -.0258434 .199683 -0.13 0.897 -.4172149 .3655281
1 213 | .0189773 .1783871 0.11 0.915 -.3306549 .3686095
1 214 | -.0549996 .2072855 -0.27 0.791 -.4612716 .3512724
1 215 | .156071 .1744425 0.89 0.371 -.18583 .4979719
1 216 | -.0340431 .2288043 -0.15 0.882 -.4824913 .4144052
1 217 | -.1088036 .1638935 -0.66 0.507 -.4300291 .2124218
1 218 | -.2522114 .1684874 -1.50 0.134 -.5824407 .0780179
1 219 | -.2703122 .2323079 -1.16 0.245 -.7256274 .1850029
1 220 | -.3992463 .1729705 -2.31 0.021 -.7382622 -.0602304
1 221 | -.2122754 .1813344 -1.17 0.242 -.5676843 .1431335
1 222 | -.085611 .1934976 -0.44 0.658 -.4648593 .2936373
1 223 | -.1546396 .1828211 -0.85 0.398 -.5129624 .2036832
1 224 | -.115179 .1760391 -0.65 0.513 -.4602094 .2298513
1 225 | -.1125642 .1775734 -0.63 0.526 -.4606017 .2354733
1 226 | -.3440405 .2977987 -1.16 0.248 -.9277153 .2396343
1 227 | -.2875839 .2849661 -1.01 0.313 -.8461071 .2709393
1 228 | -.2872752 .2590263 -1.11 0.267 -.7949574 .2204069
1 229 | .0252844 .2592801 0.10 0.922 -.4828952 .533464
1 230 | -.5222357 .2167288 -2.41 0.016 -.9470162 -.0974551
1 231 | -.4922229 .2289587 -2.15 0.032 -.9409736 -.0434722
1 232 | -.5641936 .2256691 -2.50 0.012 -1.006497 -.1218903
1 233 | -.4142919 .2274741 -1.82 0.069 -.860133 .0315491
1 234 | -.4542555 .2036028 -2.23 0.026 -.8533097 -.0552014
|
1.flag_seniors | 0 (omitted)
|
flag_seniors#quarterly |
1 211 | .0815561 .0979532 0.83 0.405 -.1104287 .273541
1 212 | .0278311 .1062334 0.26 0.793 -.1803824 .2360447
1 213 | .0281683 .0932397 0.30 0.763 -.1545782 .2109148
1 214 | .1116487 .096845 1.15 0.249 -.0781641 .3014615
1 215 | .0942672 .0993912 0.95 0.343 -.100536 .2890703
1 216 | .1354404 .100227 1.35 0.177 -.0610008 .3318816
1 217 | .1938925 .0937896 2.07 0.039 .0100682 .3777168
1 218 | .0796968 .1045577 0.76 0.446 -.1252325 .2846261
1 219 | .1395537 .1009753 1.38 0.167 -.0583543 .3374617
1 220 | .0944247 .1106965 0.85 0.394 -.1225364 .3113859
1 221 | .1086889 .1009556 1.08 0.282 -.0891803 .3065582
1 222 | -.010492 .1003346 -0.10 0.917 -.2071441 .1861601
1 223 | .2088398 .0983934 2.12 0.034 .0159922 .4016874
1 224 | .1474454 .1006684 1.46 0.143 -.0498611 .3447519
1 225 | .1011541 .1103732 0.92 0.359 -.1151734 .3174817
1 226 | .0848005 .1193857 0.71 0.478 -.1491912 .3187922
1 227 | .1539448 .1245359 1.24 0.216 -.090141 .3980307
1 228 | -.0134917 .1151233 -0.12 0.907 -.2391292 .2121457
1 229 | .1355776 .1303129 1.04 0.298 -.119831 .3909862
1 230 | .2041495 .1076111 1.90 0.058 -.0067643 .4150634
1 231 | .1474019 .1115043 1.32 0.186 -.0711426 .3659464
1 232 | .0422775 .1098475 0.38 0.700 -.1730196 .2575746
1 233 | .0344718 .1073192 0.32 0.748 -.17587 .2448135
1 234 | -.030703 .1060116 -0.29 0.772 -.2384819 .1770758
-----------------------------------------------------------------------------------------------
manhattan_qt_results_xt_poisson.rtf
dir : seeout
note: 608 groups (15200 obs) dropped because of all zero outcomes
Iteration 0: log pseudolikelihood = -22987.224
Iteration 1: log pseudolikelihood = -22610.373
Iteration 2: log pseudolikelihood = -22600.101
Iteration 3: log pseudolikelihood = -22600.064
Iteration 4: log pseudolikelihood = -22600.064
Conditional fixed-effects Poisson regression Number of obs = 53,200
Group variable: _ID Number of groups = 2,128
Obs per group:
min = 25
avg = 25.0
max = 25
Wald chi2(100) = 863.52
Log pseudolikelihood = -22600.064 Prob > chi2 = 0.0000
(Std. Err. adjusted for clustering on _ID)
-----------------------------------------------------------------------------------------------
| Robust
pedestriansinjured | Coef. Std. Err. z P>|z| [95% Conf. Interval]
------------------------------+----------------------------------------------------------------
1.flag_LPIS | -.140633 .0543931 -2.59 0.010 -.2472416 -.0340244
bike_route_tv | -.1287292 .0775872 -1.66 0.097 -.2807973 .0233389
flag_street_improv | -.1316498 .112578 -1.17 0.242 -.3522986 .088999
flag_left_turn | -.199892 .1167923 -1.71 0.087 -.4288006 .0290166
|
quarterly |
211 | .0812437 .0808419 1.00 0.315 -.0772036 .239691
212 | .1167459 .0783968 1.49 0.136 -.0369091 .2704008
213 | .1189744 .0813512 1.46 0.144 -.0404711 .2784199
214 | .0091711 .0843801 0.11 0.913 -.156211 .1745531
215 | .1160422 .0814103 1.43 0.154 -.0435191 .2756036
216 | .1085323 .0802057 1.35 0.176 -.0486679 .2657325
217 | -.0567817 .0811746 -0.70 0.484 -.2158811 .1023176
218 | -.2287014 .084183 -2.72 0.007 -.3936971 -.0637057
219 | .0990231 .0784711 1.26 0.207 -.0547775 .2528237
220 | -.1492976 .0842412 -1.77 0.076 -.3144073 .0158121
221 | -.1848741 .0856729 -2.16 0.031 -.3527899 -.0169584
222 | -.1457866 .0874969 -1.67 0.096 -.3172774 .0257042
223 | .0284403 .0826272 0.34 0.731 -.133506 .1903866
224 | -.0870659 .0839211 -1.04 0.300 -.2515482 .0774164
225 | -.5618593 .0926997 -6.06 0.000 -.7435475 -.3801712
226 | -.676639 .1027493 -6.59 0.000 -.878024 -.4752541
227 | -.5599955 .1000345 -5.60 0.000 -.7560594 -.3639316
228 | -.1037967 .0920783 -1.13 0.260 -.2842668 .0766735
229 | -.2402555 .0892666 -2.69 0.007 -.4152148 -.0652963
230 | -.6219522 .1016977 -6.12 0.000 -.8212761 -.4226283
231 | -.1934262 .094384 -2.05 0.040 -.3784155 -.008437
232 | -.1380432 .0871854 -1.58 0.113 -.3089233 .032837
233 | -.4279201 .0962723 -4.44 0.000 -.6166103 -.23923
234 | -.5093002 .0950198 -5.36 0.000 -.6955357 -.3230648
|
1.flag_school | 0 (omitted)
|
flag_school#quarterly |
1 211 | .3892412 .2741903 1.42 0.156 -.1481619 .9266444
1 212 | .4474799 .3016229 1.48 0.138 -.1436901 1.03865
1 213 | .0337127 .3461393 0.10 0.922 -.6447078 .7121332
1 214 | .0196828 .3592187 0.05 0.956 -.6843728 .7237385
1 215 | .294978 .3250151 0.91 0.364 -.3420398 .9319958
1 216 | .0597722 .3634158 0.16 0.869 -.6525097 .772054
1 217 | .1446352 .3383414 0.43 0.669 -.5185016 .8077721
1 218 | .2097147 .3456522 0.61 0.544 -.4677511 .8871805
1 219 | .3794857 .3103092 1.22 0.221 -.2287093 .9876806
1 220 | .2911088 .3635689 0.80 0.423 -.4214732 1.003691
1 221 | -.4657895 .3946522 -1.18 0.238 -1.239293 .3077146
1 222 | -.436992 .3893789 -1.12 0.262 -1.200161 .3261767
1 223 | -.2665477 .3851348 -0.69 0.489 -1.021398 .4883027
1 224 | -.0169328 .3866709 -0.04 0.965 -.7747938 .7409282
1 225 | .3848894 .4008431 0.96 0.337 -.4007486 1.170527
1 226 | -.3673264 .5133728 -0.72 0.474 -1.373519 .6388658
1 227 | -.5559874 .4877705 -1.14 0.254 -1.512 .4000252
1 228 | .0593123 .3711735 0.16 0.873 -.6681744 .786799
1 229 | -.3121307 .4664792 -0.67 0.503 -1.226413 .6021518
1 230 | .5729422 .3422319 1.67 0.094 -.0978199 1.243704
1 231 | .0878436 .3741448 0.23 0.814 -.6454667 .8211539
1 232 | .1917924 .3638858 0.53 0.598 -.5214106 .9049955
1 233 | -.1493672 .4060925 -0.37 0.713 -.9452938 .6465593
1 234 | .5004061 .3643345 1.37 0.170 -.2136763 1.214489
|
1.flag_priorityinters | 0 (omitted)
|
flag_priorityinters#quarterly |
1 211 | -.0242751 .2126701 -0.11 0.909 -.441101 .3925507
1 212 | -.0546643 .2181465 -0.25 0.802 -.4822235 .3728949
1 213 | -.1364411 .2029958 -0.67 0.501 -.5343055 .2614234
1 214 | -.0360583 .1941839 -0.19 0.853 -.4166519 .3445352
1 215 | .2010843 .193992 1.04 0.300 -.1791331 .5813016
1 216 | -.1013307 .2222191 -0.46 0.648 -.5368721 .3342106
1 217 | -.2309046 .1881417 -1.23 0.220 -.5996556 .1378464
1 218 | -.2548415 .2164615 -1.18 0.239 -.6790982 .1694153
1 219 | -.4264584 .2242547 -1.90 0.057 -.8659895 .0130727
1 220 | -.1896633 .2177892 -0.87 0.384 -.6165223 .2371957
1 221 | -.377064 .2407303 -1.57 0.117 -.8488868 .0947588
1 222 | -.3052466 .2046848 -1.49 0.136 -.7064215 .0959283
1 223 | -.4006171 .2657952 -1.51 0.132 -.921566 .1203319
1 224 | -.2885314 .2493693 -1.16 0.247 -.7772862 .2002235
1 225 | -.0807131 .2336139 -0.35 0.730 -.5385879 .3771618
1 226 | -.4534106 .2927766 -1.55 0.121 -1.027242 .1204211
1 227 | -.3328577 .3123878 -1.07 0.287 -.9451265 .2794112
1 228 | -.5356932 .3108926 -1.72 0.085 -1.145032 .0736451
1 229 | -.3335224 .2389895 -1.40 0.163 -.8019332 .1348885
1 230 | -.488295 .2984062 -1.64 0.102 -1.07316 .0965704
1 231 | -1.011072 .2999122 -3.37 0.001 -1.598889 -.4232551
1 232 | -.6844272 .2768799 -2.47 0.013 -1.227102 -.1417526
1 233 | -.7907722 .284656 -2.78 0.005 -1.348688 -.2328567
1 234 | -.201626 .3028422 -0.67 0.506 -.7951858 .3919339
|
1.flag_seniors | 0 (omitted)
|
flag_seniors#quarterly |
1 211 | .0257042 .1352801 0.19 0.849 -.2394399 .2908482
1 212 | -.143556 .1352203 -1.06 0.288 -.4085828 .1214709
1 213 | -.0958954 .1359349 -0.71 0.481 -.3623228 .1705321
1 214 | -.0624674 .1410222 -0.44 0.658 -.3388659 .2139311
1 215 | .0326144 .1340456 0.24 0.808 -.23011 .2953389
1 216 | .0002691 .1353548 0.00 0.998 -.2650214 .2655595
1 217 | .1193169 .132586 0.90 0.368 -.1405468 .3791806
1 218 | .13265 .1613219 0.82 0.411 -.1835351 .4488352
1 219 | .0236857 .1296732 0.18 0.855 -.2304691 .2778406
1 220 | -.020648 .1441067 -0.14 0.886 -.3030921 .261796
1 221 | .011208 .145405 0.08 0.939 -.2737806 .2961966
1 222 | -.1483512 .1493629 -0.99 0.321 -.441097 .1443946
1 223 | .1641722 .1373477 1.20 0.232 -.1050244 .4333688
1 224 | .1498745 .1392812 1.08 0.282 -.1231116 .4228607
1 225 | .1273102 .1612484 0.79 0.430 -.1887308 .4433512
1 226 | .1106324 .1686054 0.66 0.512 -.2198281 .4410929
1 227 | .2788039 .1619983 1.72 0.085 -.038707 .5963148
1 228 | -.074627 .1567358 -0.48 0.634 -.3818236 .2325695
1 229 | .176435 .2458606 0.72 0.473 -.305443 .6583129
1 230 | .2946303 .1619975 1.82 0.069 -.022879 .6121396
1 231 | .0281107 .1514435 0.19 0.853 -.2687131 .3249345
1 232 | .0848854 .1483467 0.57 0.567 -.2058687 .3756395
1 233 | .1000461 .1580415 0.63 0.527 -.2097096 .4098019
1 234 | .0196438 .1655296 0.12 0.906 -.3047882 .3440757
-----------------------------------------------------------------------------------------------
manhattan_qt_results_xt_poisson.rtf
dir : seeout
note: 961 groups (24025 obs) dropped because of all zero outcomes
Iteration 0: log pseudolikelihood = -12811.614
Iteration 1: log pseudolikelihood = -12513.913
Iteration 2: log pseudolikelihood = -12503.6
Iteration 3: log pseudolikelihood = -12503.503
Iteration 4: log pseudolikelihood = -12503.503
Conditional fixed-effects Poisson regression Number of obs = 44,375
Group variable: _ID Number of groups = 1,775
Obs per group:
min = 25
avg = 25.0
max = 25
Wald chi2(100) = 891.31
Log pseudolikelihood = -12503.503 Prob > chi2 = 0.0000
(Std. Err. adjusted for clustering on _ID)
-----------------------------------------------------------------------------------------------
| Robust
cyclistinjured | Coef. Std. Err. z P>|z| [95% Conf. Interval]
------------------------------+----------------------------------------------------------------
1.flag_LPIS | -.1619309 .0686342 -2.36 0.018 -.2964514 -.0274104
bike_route_tv | .0281343 .1105567 0.25 0.799 -.1885528 .2448213
flag_street_improv | .0638574 .1847954 0.35 0.730 -.298335 .4260499
flag_left_turn | -.157705 .1820943 -0.87 0.386 -.5146032 .1991933
|
quarterly |
211 | -.5242879 .124894 -4.20 0.000 -.7690756 -.2795002
212 | -.6671506 .1300575 -5.13 0.000 -.9220586 -.4122426
213 | -.0291091 .1113606 -0.26 0.794 -.2473718 .1891536
214 | .11391 .1057822 1.08 0.282 -.0934193 .3212393
215 | -.2168387 .1134465 -1.91 0.056 -.4391897 .0055123
216 | -.7583243 .1372133 -5.53 0.000 -1.027257 -.4893911
217 | .1022627 .1065269 0.96 0.337 -.1065262 .3110517
218 | .266147 .1046582 2.54 0.011 .0610206 .4712733
219 | -.2529064 .11112 -2.28 0.023 -.4706976 -.0351151
220 | -.9910512 .1459794 -6.79 0.000 -1.277166 -.7049368
221 | -.0128036 .104238 -0.12 0.902 -.2171063 .1914991
222 | .1782935 .1008149 1.77 0.077 -.0193001 .375887
223 | .1065323 .1039758 1.02 0.306 -.0972566 .3103212
224 | -.6633795 .1326108 -5.00 0.000 -.9232918 -.4034672
225 | -.133959 .1107622 -1.21 0.226 -.351049 .0831309
226 | -.444395 .1253139 -3.55 0.000 -.6900058 -.1987842
227 | -.74128 .1397628 -5.30 0.000 -1.01521 -.4673501
228 | -.8676367 .1480884 -5.86 0.000 -1.157885 -.5773888
229 | -.1759858 .1146871 -1.53 0.125 -.4007684 .0487969
230 | -.1556284 .1134593 -1.37 0.170 -.3780045 .0667478
231 | -.449246 .1266388 -3.55 0.000 -.6974535 -.2010385
232 | -.6189847 .1307419 -4.73 0.000 -.875234 -.3627353
233 | -.1777673 .1181227 -1.50 0.132 -.4092835 .053749
234 | .0758206 .11221 0.68 0.499 -.144107 .2957482
|
1.flag_school | 0 (omitted)
|
flag_school#quarterly |
1 211 | -.0245755 .5733777 -0.04 0.966 -1.148375 1.099224
1 212 | .1553304 .5799305 0.27 0.789 -.9813125 1.291973
1 213 | .342653 .4651677 0.74 0.461 -.5690589 1.254365
1 214 | .5595319 .4042682 1.38 0.166 -.2328192 1.351883
1 215 | .0793315 .5634097 0.14 0.888 -1.024931 1.183594
1 216 | -.6782638 1.066534 -0.64 0.525 -2.768631 1.412104
1 217 | -.2755303 .5603948 -0.49 0.623 -1.373884 .8228234
1 218 | -.354701 .5669005 -0.63 0.532 -1.465806 .7564035
1 219 | -.0253818 .5962387 -0.04 0.966 -1.193988 1.143225
1 220 | .6086637 .6080117 1.00 0.317 -.5830174 1.800345
1 221 | .5202174 .4516086 1.15 0.249 -.3649193 1.405354
1 222 | .3294478 .4329744 0.76 0.447 -.5191664 1.178062
1 223 | -.3278458 .549233 -0.60 0.551 -1.404323 .7486311
1 224 | -.0232447 .6207474 -0.04 0.970 -1.239887 1.193398
1 225 | .2054498 .5117252 0.40 0.688 -.7975131 1.208413
1 226 | -.0200667 .6455386 -0.03 0.975 -1.285299 1.245166
1 227 | .1671487 .5904022 0.28 0.777 -.9900185 1.324316
1 228 | .3689744 .6625657 0.56 0.578 -.9296306 1.667579
1 229 | .5828662 .4203922 1.39 0.166 -.2410874 1.40682
1 230 | .6764869 .4618619 1.46 0.143 -.2287458 1.58172
1 231 | .4742712 .4758473 1.00 0.319 -.4583725 1.406915
1 232 | -.6466278 .8026097 -0.81 0.420 -2.219714 .9264582
1 233 | .4490178 .4281408 1.05 0.294 -.3901227 1.288158
1 234 | .3087908 .4785155 0.65 0.519 -.6290823 1.246664
|
1.flag_priorityinters | 0 (omitted)
|
flag_priorityinters#quarterly |
1 211 | -.9206355 .6107302 -1.51 0.132 -2.117645 .2763738
1 212 | .3264964 .5095742 0.64 0.522 -.6722506 1.325244
1 213 | -.5225174 .4141447 -1.26 0.207 -1.334226 .2891912
1 214 | .0859351 .4096188 0.21 0.834 -.716903 .8887732
1 215 | -.431231 .4126852 -1.04 0.296 -1.240079 .3776172
1 216 | -.2023942 .5653475 -0.36 0.720 -1.310455 .9056665
1 217 | .1679932 .3486624 0.48 0.630 -.5153726 .851359
1 218 | -.011021 .3537522 -0.03 0.975 -.7043625 .6823206
1 219 | -.1364657 .4588847 -0.30 0.766 -1.035863 .7629319
1 220 | -.0245883 .3667322 -0.07 0.947 -.7433701 .6941936
1 221 | -.6306705 .5039604 -1.25 0.211 -1.618415 .3570737
1 222 | .0239832 .3903826 0.06 0.951 -.7411527 .7891191
1 223 | -.0237163 .3619542 -0.07 0.948 -.7331335 .685701
1 224 | -.1013506 .6353334 -0.16 0.873 -1.346581 1.14388
1 225 | -.0180805 .4048776 -0.04 0.964 -.811626 .775465
1 226 | .0533552 .502481 0.11 0.915 -.9314894 1.0382
1 227 | -.1201081 .5541408 -0.22 0.828 -1.206204 .9659878
1 228 | -.5037774 .7080269 -0.71 0.477 -1.891485 .8839299
1 229 | -.1457704 .3542636 -0.41 0.681 -.8401142 .5485734
1 230 | -.5885685 .4775845 -1.23 0.218 -1.524617 .3474799
1 231 | -.283459 .4312797 -0.66 0.511 -1.128752 .5618337
1 232 | -.311045 .5454587 -0.57 0.569 -1.380124 .7580343
1 233 | -.1772432 .423915 -0.42 0.676 -1.008101 .653615
1 234 | -.2288726 .4047151 -0.57 0.572 -1.022099 .5643544
|
1.flag_seniors | 0 (omitted)
|
flag_seniors#quarterly |
1 211 | .355187 .2168093 1.64 0.101 -.0697514 .7801254
1 212 | .08173 .2474689 0.33 0.741 -.4033001 .56676
1 213 | .0936033 .1919529 0.49 0.626 -.2826175 .4698241
1 214 | .0518184 .193258 0.27 0.789 -.3269603 .4305971
1 215 | .0762735 .2136016 0.36 0.721 -.342378 .494925
1 216 | .2030256 .2333256 0.87 0.384 -.2542842 .6603354
1 217 | .1064931 .1902685 0.56 0.576 -.2664263 .4794126
1 218 | -.1822759 .1926402 -0.95 0.344 -.5598438 .1952919
1 219 | -.0156894 .2061379 -0.08 0.939 -.4197122 .3883334
1 220 | -.3553497 .2855428 -1.24 0.213 -.9150033 .2043039
1 221 | .0198643 .1951038 0.10 0.919 -.362532 .4022607
1 222 | .0242165 .1894281 0.13 0.898 -.3470558 .3954887
1 223 | -.1200998 .1935174 -0.62 0.535 -.4993868 .2591873
1 224 | .1317439 .239031 0.55 0.582 -.3367482 .600236
1 225 | -.124344 .2049548 -0.61 0.544 -.5260479 .2773599
1 226 | .118073 .2215819 0.53 0.594 -.3162196 .5523656
1 227 | .4775706 .229404 2.08 0.037 .0279471 .9271942
1 228 | .3399171 .2497286 1.36 0.173 -.149542 .8293761
1 229 | .215272 .2021134 1.07 0.287 -.1808631 .611407
1 230 | .1538667 .198255 0.78 0.438 -.2347059 .5424393
1 231 | .1762262 .217794 0.81 0.418 -.2506422 .6030946
1 232 | -.1761768 .2605636 -0.68 0.499 -.6868721 .3345186
1 233 | .117706 .201673 0.58 0.559 -.2775658 .5129779
1 234 | .067203 .1934793 0.35 0.728 -.3120094 .4464154
-----------------------------------------------------------------------------------------------
manhattan_qt_results_xt_poisson.rtf
dir : seeout
note: 606 groups (15150 obs) dropped because of all zero outcomes
Iteration 0: log pseudolikelihood = -30322.121
Iteration 1: log pseudolikelihood = -30011.156
Iteration 2: log pseudolikelihood = -30002.564
Iteration 3: log pseudolikelihood = -30002.522
Iteration 4: log pseudolikelihood = -30002.522
Conditional fixed-effects Poisson regression Number of obs = 53,250
Group variable: _ID Number of groups = 2,130
Obs per group:
min = 25
avg = 25.0
max = 25
Wald chi2(100) = 465.67
Log pseudolikelihood = -30002.522 Prob > chi2 = 0.0000
(Std. Err. adjusted for clustering on _ID)
-----------------------------------------------------------------------------------------------
| Robust
motoristinjured | Coef. Std. Err. z P>|z| [95% Conf. Interval]
------------------------------+----------------------------------------------------------------
1.flag_LPIS | .0017582 .0550925 0.03 0.975 -.1062211 .1097375
bike_route_tv | .1634696 .0823095 1.99 0.047 .0021459 .3247932
flag_street_improv | -.0702311 .1573518 -0.45 0.655 -.3786348 .2381727
flag_left_turn | -.1494563 .148127 -1.01 0.313 -.4397799 .1408672
|
quarterly |
211 | -.2081105 .1010033 -2.06 0.039 -.4060733 -.0101476
212 | -.3463587 .0945857 -3.66 0.000 -.5317433 -.1609741
213 | -.1696537 .08443 -2.01 0.044 -.3351335 -.0041738
214 | -.1277735 .0864258 -1.48 0.139 -.2971649 .041618
215 | -.3057988 .092957 -3.29 0.001 -.4879912 -.1236064
216 | -.4972785 .098499 -5.05 0.000 -.690333 -.304224
217 | -.2669669 .1014425 -2.63 0.008 -.4657906 -.0681431
218 | -.2730727 .0956987 -2.85 0.004 -.4606386 -.0855067
219 | -.4315808 .1016347 -4.25 0.000 -.6307812 -.2323804
220 | -.5658681 .1017061 -5.56 0.000 -.7652085 -.3665277
221 | -.382697 .0945443 -4.05 0.000 -.5680003 -.1973936
222 | -.3364984 .087407 -3.85 0.000 -.5078129 -.165184
223 | -.4292364 .0955603 -4.49 0.000 -.6165312 -.2419416
224 | -.4778348 .0928155 -5.15 0.000 -.6597498 -.2959198
225 | -.5304191 .1017291 -5.21 0.000 -.7298044 -.3310338
226 | -.778891 .1082018 -7.20 0.000 -.9909626 -.5668193
227 | -.6878498 .1111694 -6.19 0.000 -.9057379 -.4699618
228 | -.5504343 .1043032 -5.28 0.000 -.7548649 -.3460037
229 | -.3599256 .0938531 -3.83 0.000 -.5438742 -.1759769
230 | -.4260411 .0932423 -4.57 0.000 -.6087927 -.2432895
231 | -.5031383 .1042085 -4.83 0.000 -.7073832 -.2988934
232 | -.5830456 .0984874 -5.92 0.000 -.7760774 -.3900138
233 | -.3313887 .0931299 -3.56 0.000 -.5139199 -.1488575
234 | -.3053144 .093748 -3.26 0.001 -.4890571 -.1215716
|
1.flag_school | 0 (omitted)
|
flag_school#quarterly |
1 211 | .0497706 .3940752 0.13 0.899 -.7226027 .8221439
1 212 | .0184947 .4301133 0.04 0.966 -.8245119 .8615014
1 213 | .1867724 .3164902 0.59 0.555 -.433537 .8070818
1 214 | .1936475 .4228728 0.46 0.647 -.635168 1.022463
1 215 | .2241159 .3377857 0.66 0.507 -.4379319 .8861636
1 216 | -.516036 .4375089 -1.18 0.238 -1.373538 .3414658
1 217 | -.6170551 .3921158 -1.57 0.116 -1.385588 .1514778
1 218 | -.1127132 .3447808 -0.33 0.744 -.7884712 .5630448
1 219 | .6049258 .3549894 1.70 0.088 -.0908407 1.300692
1 220 | -.5210988 .4704613 -1.11 0.268 -1.443186 .4009885
1 221 | .3285321 .3916164 0.84 0.402 -.439022 1.096086
1 222 | -.1413826 .4261814 -0.33 0.740 -.9766828 .6939176
1 223 | -.3702552 .3299323 -1.12 0.262 -1.016911 .2764003
1 224 | .202161 .3672666 0.55 0.582 -.5176682 .9219903
1 225 | .3003672 .347617 0.86 0.388 -.3809496 .981684
1 226 | -.5021801 .4678492 -1.07 0.283 -1.419148 .4147875
1 227 | -.8032077 .464662 -1.73 0.084 -1.713928 .107513
1 228 | -.8188469 .5266817 -1.55 0.120 -1.851124 .2134303
1 229 | -.3713226 .4430854 -0.84 0.402 -1.239754 .4971088
1 230 | -.6776659 .3511487 -1.93 0.054 -1.365905 .0105729
1 231 | .3312512 .3166211 1.05 0.295 -.2893148 .9518172
1 232 | .4967025 .3907112 1.27 0.204 -.2690773 1.262482
1 233 | .0874135 .3419271 0.26 0.798 -.5827513 .7575782
1 234 | .3179282 .326568 0.97 0.330 -.3221333 .9579897
|
1.flag_priorityinters | 0 (omitted)
|
flag_priorityinters#quarterly |
1 211 | -.3823619 .3202365 -1.19 0.232 -1.010014 .2452901
1 212 | -.2079476 .3885176 -0.54 0.592 -.9694281 .5535329
1 213 | .2479381 .3015041 0.82 0.411 -.3429991 .8388753
1 214 | -.12177 .359727 -0.34 0.735 -.826822 .583282
1 215 | .1438644 .3133077 0.46 0.646 -.4702074 .7579361
1 216 | -.0581157 .3671459 -0.16 0.874 -.7777085 .6614771
1 217 | -.1347454 .3259457 -0.41 0.679 -.7735872 .5040965
1 218 | -.3513684 .289043 -1.22 0.224 -.9178824 .2151456
1 219 | -.2212744 .4644208 -0.48 0.634 -1.131522 .6889737
1 220 | -1.04117 .3720242 -2.80 0.005 -1.770324 -.3120155
1 221 | .0330361 .2940877 0.11 0.911 -.5433652 .6094375
1 222 | .0504648 .3258149 0.15 0.877 -.5881207 .6890502
1 223 | -.0138015 .3193623 -0.04 0.966 -.6397402 .6121372
1 224 | .0284929 .247462 0.12 0.908 -.4565236 .5135094
1 225 | -.1125391 .3650179 -0.31 0.758 -.8279611 .6028829
1 226 | -.4294914 .5014902 -0.86 0.392 -1.412394 .5534114
1 227 | -.2782253 .4206679 -0.66 0.508 -1.102719 .5462687
1 228 | .0131349 .3882523 0.03 0.973 -.7478256 .7740953
1 229 | .3081686 .3628934 0.85 0.396 -.4030893 1.019427
1 230 | -.4034699 .3695641 -1.09 0.275 -1.127802 .3208624
1 231 | -.235649 .3697664 -0.64 0.524 -.9603778 .4890798
1 232 | -.5926137 .3321292 -1.78 0.074 -1.243575 .0583476
1 233 | -.2879961 .3528063 -0.82 0.414 -.9794838 .4034915
1 234 | -.7760505 .3828664 -2.03 0.043 -1.526455 -.0256461
|
1.flag_seniors | 0 (omitted)
|
flag_seniors#quarterly |
1 211 | .0164084 .1709093 0.10 0.924 -.3185677 .3513845
1 212 | .130391 .1792792 0.73 0.467 -.2209898 .4817717
1 213 | .0821604 .1558429 0.53 0.598 -.223286 .3876067
1 214 | .254668 .1601966 1.59 0.112 -.0593115 .5686475
1 215 | .105141 .1649216 0.64 0.524 -.2180994 .4283813
1 216 | .1908394 .1689055 1.13 0.259 -.1402093 .521888
1 217 | .27116 .1624875 1.67 0.095 -.0473097 .5896297
1 218 | .1589548 .1666869 0.95 0.340 -.1677455 .4856552
1 219 | .2431909 .1701036 1.43 0.153 -.090206 .5765879
1 220 | .2406771 .1821827 1.32 0.186 -.1163944 .5977486
1 221 | .2071205 .1647449 1.26 0.209 -.1157736 .5300146
1 222 | .0584859 .1612369 0.36 0.717 -.2575326 .3745044
1 223 | .3408325 .1666927 2.04 0.041 .0141208 .6675441
1 224 | .1224748 .165737 0.74 0.460 -.2023637 .4473134
1 225 | .2353289 .1683631 1.40 0.162 -.0946567 .5653144
1 226 | .1288232 .2009168 0.64 0.521 -.2649664 .5226129
1 227 | -.0114234 .2095632 -0.05 0.957 -.4221598 .3993129
1 228 | -.0318945 .1887113 -0.17 0.866 -.4017619 .337973
1 229 | .0684211 .1655764 0.41 0.679 -.2561028 .3929449
1 230 | .2185607 .1733956 1.26 0.207 -.1212885 .5584099
1 231 | .2098508 .1747361 1.20 0.230 -.1326256 .5523273
1 232 | .0059025 .1860687 0.03 0.975 -.3587854 .3705905
1 233 | -.0285653 .1687669 -0.17 0.866 -.3593424 .3022118
1 234 | -.0687441 .1716179 -0.40 0.689 -.405109 .2676207
-----------------------------------------------------------------------------------------------
manhattan_qt_results_xt_poisson.rtf
dir : seeout
Spatial Lag Model¶
[44]:
global filename splm_qt_results_xt
C:\Users\jerem\Box Sync\Policy Evaluation\manuscripts
[45]:
// Spatial Lagged Model collision_count
global outcome collision_count
spxtregress $outcome i.flag_LPIS $time_variant_var $time_var $time_trend, fe dvarlag(W)
outreg2 using "$filename", word replace ctitle(spxtregress fe $outcome) title(Spatial Lagged Model)
(68400 observations)
(68400 observations used)
(data contain 2736 panels (places) )
(weighting matrix defines 2736 places)
Performing grid search ... finished
Optimizing concentrated log likelihood:
Iteration 0: log likelihood = -133972.25
Iteration 1: log likelihood = -133970.39
Iteration 2: log likelihood = -133970.39
Optimizing unconcentrated log likelihood:
Iteration 0: log likelihood = -133970.39
Iteration 1: log likelihood = -133970.39 (backed up)
Fixed-effects spatial regression Number of obs = 68,400
Group variable: _ID Number of groups = 2,736
Obs per group = 25
Wald chi2(101) = 7445.38
Prob > chi2 = 0.0000
Log likelihood = -1.340e+05 Pseudo R2 = 0.0036
-----------------------------------------------------------------------------------------------
collision_count | Coef. Std. Err. z P>|z| [95% Conf. Interval]
------------------------------+----------------------------------------------------------------
collision_count |
1.flag_LPIS | -.1057683 .0376708 -2.81 0.005 -.1796017 -.0319349
bike_route_tv | .1529832 .0512547 2.98 0.003 .052526 .2534405
flag_street_improv | -.4548321 .0936469 -4.86 0.000 -.6383767 -.2712875
flag_left_turn | -.9472238 .1044778 -9.07 0.000 -1.151997 -.7424509
|
quarterly |
211 | -.2286899 .0605049 -3.78 0.000 -.3472772 -.1101025
212 | -.3613775 .0605386 -5.97 0.000 -.480031 -.242724
213 | .0290274 .0604864 0.48 0.631 -.0895238 .1475785
214 | -.046482 .0604901 -0.77 0.442 -.1650404 .0720765
215 | -.0755549 .0605019 -1.25 0.212 -.1941364 .0430267
216 | -.3842826 .0605623 -6.35 0.000 -.5029825 -.2655827
217 | .0061105 .0605112 0.10 0.920 -.1124893 .1247104
218 | -.0317946 .0605155 -0.53 0.599 -.1504027 .0868135
219 | -.0809867 .060521 -1.34 0.181 -.1996056 .0376323
220 | -.4075397 .0606046 -6.72 0.000 -.5263226 -.2887568
221 | .0301147 .0605451 0.50 0.619 -.0885514 .1487809
222 | .0201174 .0605954 0.33 0.740 -.0986473 .1388822
223 | .0647168 .0606145 1.07 0.286 -.0540855 .1835191
224 | -.2794743 .0606563 -4.61 0.000 -.3983585 -.1605901
225 | -.5605923 .0607807 -9.22 0.000 -.6797204 -.4414642
226 | -1.069358 .0612061 -17.47 0.000 -1.189319 -.9493959
227 | -1.082989 .0612365 -17.69 0.000 -1.20301 -.9629674
228 | -.9051357 .0611171 -14.81 0.000 -1.024923 -.7853484
229 | -.5222711 .0609247 -8.57 0.000 -.6416813 -.4028608
230 | -.8355903 .0611451 -13.67 0.000 -.9554325 -.7157482
231 | -.7541349 .0611268 -12.34 0.000 -.8739412 -.6343285
232 | -.7659619 .0611503 -12.53 0.000 -.8858143 -.6461094
233 | -.5306819 .0611893 -8.67 0.000 -.6506108 -.410753
234 | -.6844269 .0614037 -11.15 0.000 -.804776 -.5640778
|
1.flag_school | 0 (omitted)
|
flag_school#quarterly |
1 211 | .3475187 .2309691 1.50 0.132 -.1051724 .8002098
1 212 | .3377302 .2309692 1.46 0.144 -.1149611 .7904216
1 213 | .2423385 .2309698 1.05 0.294 -.2103541 .695031
1 214 | .1003283 .2309699 0.43 0.664 -.3523643 .5530209
1 215 | -.0028737 .2309701 -0.01 0.990 -.4555667 .4498193
1 216 | .1553831 .2309698 0.67 0.501 -.2973094 .6080755
1 217 | .20832 .2309703 0.90 0.367 -.2443734 .6610135
1 218 | .0627602 .2309694 0.27 0.786 -.3899316 .515452
1 219 | .5219715 .2309699 2.26 0.024 .0692788 .9746642
1 220 | .4756751 .2309704 2.06 0.039 .0229815 .9283686
1 221 | .0664535 .2309709 0.29 0.774 -.3862412 .5191481
1 222 | .1800464 .230971 0.78 0.436 -.2726485 .6327413
1 223 | .1921536 .2309725 0.83 0.405 -.2605441 .6448513
1 224 | .1040838 .2309723 0.45 0.652 -.3486137 .5567812
1 225 | .4898059 .2309729 2.12 0.034 .0371074 .9425044
1 226 | .2593691 .230983 1.12 0.261 -.1933492 .7120875
1 227 | .3061311 .2309798 1.33 0.185 -.146581 .7588433
1 228 | .3092696 .2309823 1.34 0.181 -.1434475 .7619867
1 229 | .5195877 .2309759 2.25 0.024 .0668833 .9722921
1 230 | .4594732 .2309762 1.99 0.047 .0067683 .9121782
1 231 | .5458256 .2309778 2.36 0.018 .0931175 .9985337
1 232 | .5251141 .2309758 2.27 0.023 .0724099 .9778182
1 233 | .2639302 .2309754 1.14 0.253 -.1887732 .7166336
1 234 | .5291465 .2309758 2.29 0.022 .0764422 .9818507
|
1.flag_priorityinters | 0 (omitted)
|
flag_priorityinters#quarterly |
1 211 | -.7766743 .3947448 -1.97 0.049 -1.55036 -.0029887
1 212 | -1.435385 .3947452 -3.64 0.000 -2.209072 -.661699
1 213 | -.7706868 .394744 -1.95 0.051 -1.544371 .0029972
1 214 | -.2585809 .3947467 -0.66 0.512 -1.03227 .5151085
1 215 | .091362 .3947488 0.23 0.817 -.6823314 .8650554
1 216 | -1.840716 .3947526 -4.66 0.000 -2.614416 -1.067015
1 217 | -1.074648 .3947529 -2.72 0.006 -1.84835 -.3009469
1 218 | -.8034885 .3947551 -2.04 0.042 -1.577194 -.0297827
1 219 | -1.457292 .3947635 -3.69 0.000 -2.231015 -.6835702
1 220 | -2.497653 .3947695 -6.33 0.000 -3.271387 -1.723919
1 221 | -1.497446 .3947496 -3.79 0.000 -2.271142 -.7237514
1 222 | .4100963 .3948687 1.04 0.299 -.3638322 1.184025
1 223 | -1.192517 .394868 -3.02 0.003 -1.966444 -.4185897
1 224 | -1.559013 .3948685 -3.95 0.000 -2.332941 -.7850849
1 225 | -2.578821 .3948734 -6.53 0.000 -3.352758 -1.804883
1 226 | -3.84311 .3949488 -9.73 0.000 -4.617196 -3.069025
1 227 | -4.373403 .3951514 -11.07 0.000 -5.147885 -3.59892
1 228 | -3.82152 .3951202 -9.67 0.000 -4.595941 -3.047099
1 229 | -3.781369 .3950642 -9.57 0.000 -4.555681 -3.007057
1 230 | -3.995494 .3953501 -10.11 0.000 -4.770366 -3.220621
1 231 | -4.256165 .3954148 -10.76 0.000 -5.031164 -3.481167
1 232 | -3.666383 .3954135 -9.27 0.000 -4.44138 -2.891387
1 233 | -3.586055 .3953749 -9.07 0.000 -4.360975 -2.811135
1 234 | -3.871123 .3953709 -9.79 0.000 -4.646035 -3.09621
|
1.flag_seniors | 0 (omitted)
|
flag_seniors#quarterly |
1 211 | .2086088 .1115945 1.87 0.062 -.0101125 .4273301
1 212 | .006489 .1115835 0.06 0.954 -.2122107 .2251887
1 213 | .0846442 .1115843 0.76 0.448 -.134057 .3033455
1 214 | .141129 .1115967 1.26 0.206 -.0775965 .3598545
1 215 | .2247747 .1115975 2.01 0.044 .0060477 .4435017
1 216 | .1633361 .1115919 1.46 0.143 -.0553801 .3820522
1 217 | .1627366 .1116029 1.46 0.145 -.056001 .3814741
1 218 | -.0563359 .1115965 -0.50 0.614 -.2750611 .1623893
1 219 | .11098 .1116457 0.99 0.320 -.1078416 .3298016
1 220 | -.0163657 .1116426 -0.15 0.883 -.2351812 .2024497
1 221 | .1931593 .1116358 1.73 0.084 -.0256429 .4119615
1 222 | .113286 .1116297 1.01 0.310 -.1055041 .3320761
1 223 | .2228152 .1116457 2.00 0.046 .0039937 .4416368
1 224 | .0037507 .1116441 0.03 0.973 -.2150678 .2225692
1 225 | -.2884587 .1116582 -2.58 0.010 -.5073048 -.0696126
1 226 | -.1957706 .1117706 -1.75 0.080 -.414837 .0232957
1 227 | -.1402731 .1118617 -1.25 0.210 -.3595181 .0789718
1 228 | -.0895315 .1119226 -0.80 0.424 -.3088957 .1298327
1 229 | -.0366937 .1120358 -0.33 0.743 -.2562799 .1828925
1 230 | .0285671 .1120405 0.25 0.799 -.1910282 .2481625
1 231 | -.0277308 .1120545 -0.25 0.805 -.2473536 .191892
1 232 | -.2955704 .1120651 -2.64 0.008 -.515214 -.0759267
1 233 | -.10731 .1119498 -0.96 0.338 -.3267277 .1121076
1 234 | -.2854474 .1119494 -2.55 0.011 -.5048641 -.0660306
------------------------------+----------------------------------------------------------------
W |
collision_count | .1879056 .0062804 29.92 0.000 .1755963 .2002149
------------------------------+----------------------------------------------------------------
/sigma_e | 1.856253 .0051341 1.846218 1.866343
-----------------------------------------------------------------------------------------------
Wald test of spatial terms: chi2(1) = 895.18 Prob > chi2 = 0.0000
splm_qt_results_xt.rtf
dir : seeout
[48]:
estat impact flag_LPIS
progress : 50% 100%
Average impacts Number of obs = 68,400
------------------------------------------------------------------------------
| Delta-Method
| dy/dx Std. Err. z P>|z| [95% Conf. Interval]
-------------+----------------------------------------------------------------
direct |
flag_LPIS |
1 | -.1063638 .0378835 -2.81 0.005 -.1806141 -.0321134
-------------+----------------------------------------------------------------
indirect |
flag_LPIS |
1 | -.0219132 .0078668 -2.79 0.005 -.0373318 -.0064946
-------------+----------------------------------------------------------------
total |
flag_LPIS |
1 | -.128277 .0457104 -2.81 0.005 -.2178678 -.0386861
------------------------------------------------------------------------------
splm_qt_results_xt.rtf
dir : seeout
. rend, fe vce(cluster intersection_id)
command rend is unrecognized
r(199);
r(199);
[49]:
// Spatial Lagged Model personsinjured
global outcome personsinjured
spxtregress $outcome i.flag_LPIS $time_variant_var $time_var $time_trend, fe dvarlag(W)
outreg2 using "$filename", word append ctitle(spxtregress fe $outcome)
(68400 observations)
(68400 observations used)
(data contain 2736 panels (places) )
(weighting matrix defines 2736 places)
Performing grid search ... finished
Optimizing concentrated log likelihood:
Iteration 0: log likelihood = -83705.847
Iteration 1: log likelihood = -83702.951
Iteration 2: log likelihood = -83702.951
Optimizing unconcentrated log likelihood:
Iteration 0: log likelihood = -83702.951
Iteration 1: log likelihood = -83702.951 (backed up)
Fixed-effects spatial regression Number of obs = 68,400
Group variable: _ID Number of groups = 2,736
Obs per group = 25
Wald chi2(101) = 1057.24
Prob > chi2 = 0.0000
Log likelihood = -8.370e+04 Pseudo R2 = 0.0008
-----------------------------------------------------------------------------------------------
personsinjured | Coef. Std. Err. z P>|z| [95% Conf. Interval]
------------------------------+----------------------------------------------------------------
personsinjured |
1.flag_LPIS | -.0642533 .0175663 -3.66 0.000 -.0986826 -.029824
bike_route_tv | .0259784 .023901 1.09 0.277 -.0208667 .0728236
flag_street_improv | -.0712077 .0436729 -1.63 0.103 -.1568049 .0143896
flag_left_turn | -.2899753 .0487187 -5.95 0.000 -.3854622 -.1944883
|
quarterly |
211 | -.080483 .0282116 -2.85 0.004 -.1357768 -.0251892
212 | -.1121403 .0282144 -3.97 0.000 -.1674396 -.056841
213 | -.0286502 .0282084 -1.02 0.310 -.0839377 .0266373
214 | -.0248531 .0282098 -0.88 0.378 -.0801433 .0304371
215 | -.077408 .0282169 -2.74 0.006 -.1327121 -.0221039
216 | -.1476869 .0282309 -5.23 0.000 -.2030184 -.0923553
217 | -.07105 .0282238 -2.52 0.012 -.1263676 -.0157324
218 | -.0801546 .028226 -2.84 0.005 -.1354765 -.0248327
219 | -.1114053 .0282307 -3.95 0.000 -.1667364 -.0560743
220 | -.2108822 .0282601 -7.46 0.000 -.266271 -.1554933
221 | -.1260923 .0282471 -4.46 0.000 -.1814557 -.0707289
222 | -.0908856 .028266 -3.22 0.001 -.1462861 -.0354852
223 | -.0909396 .0282732 -3.22 0.001 -.146354 -.0355251
224 | -.1605432 .0282878 -5.68 0.000 -.2159862 -.1051003
225 | -.1977931 .028301 -6.99 0.000 -.2532621 -.1423242
226 | -.2779041 .028359 -9.80 0.000 -.3334867 -.2223215
227 | -.2746072 .0283662 -9.68 0.000 -.3302039 -.2190105
228 | -.2259165 .0283641 -7.96 0.000 -.2815091 -.1703239
229 | -.1369248 .0283574 -4.83 0.000 -.1925042 -.0813453
230 | -.1900187 .0283806 -6.70 0.000 -.2456437 -.1343936
231 | -.1769843 .028396 -6.23 0.000 -.2326393 -.1213292
232 | -.1913043 .0284039 -6.74 0.000 -.246975 -.1356337
233 | -.1482106 .0284744 -5.21 0.000 -.2040195 -.0924017
234 | -.128671 .0285291 -4.51 0.000 -.184587 -.0727551
|
1.flag_school | 0 (omitted)
|
flag_school#quarterly |
1 211 | .0973775 .107714 0.90 0.366 -.1137381 .3084931
1 212 | .1224571 .107714 1.14 0.256 -.0886585 .3335727
1 213 | .0762032 .1077143 0.71 0.479 -.134913 .2873194
1 214 | .0999176 .1077144 0.93 0.354 -.1111988 .3110339
1 215 | .1187999 .1077143 1.10 0.270 -.0923163 .3299161
1 216 | -.0248527 .1077143 -0.23 0.818 -.2359689 .1862634
1 217 | -.0745455 .1077156 -0.69 0.489 -.2856642 .1365732
1 218 | .0035347 .1077141 0.03 0.974 -.2075811 .2146505
1 219 | .2248694 .107714 2.09 0.037 .0137538 .435985
1 220 | .0650213 .107714 0.60 0.546 -.1460942 .2761368
1 221 | .099063 .1077142 0.92 0.358 -.112053 .3101791
1 222 | -.0077227 .1077148 -0.07 0.943 -.2188397 .2033944
1 223 | -.0876926 .1077154 -0.81 0.416 -.2988109 .1234258
1 224 | .06652 .1077156 0.62 0.537 -.1445987 .2776388
1 225 | .1514554 .1077155 1.41 0.160 -.059663 .3625739
1 226 | .027074 .1077205 0.25 0.802 -.1840543 .2382023
1 227 | .0027623 .107719 0.03 0.980 -.208363 .2138876
1 228 | .0151825 .1077198 0.14 0.888 -.1959444 .2263095
1 229 | -.0046934 .1077178 -0.04 0.965 -.2158164 .2064295
1 230 | .080294 .1077171 0.75 0.456 -.1308275 .2914156
1 231 | .1444909 .1077173 1.34 0.180 -.0666311 .3556129
1 232 | .1545376 .1077174 1.43 0.151 -.0565847 .3656599
1 233 | .0815181 .107717 0.76 0.449 -.1296034 .2926395
1 234 | .1806489 .1077167 1.68 0.094 -.030472 .3917697
|
1.flag_priorityinters | 0 (omitted)
|
flag_priorityinters#quarterly |
1 211 | -.6071898 .1840914 -3.30 0.001 -.9680024 -.2463773
1 212 | -.4067897 .1840923 -2.21 0.027 -.7676039 -.0459756
1 213 | -.0266383 .1840932 -0.14 0.885 -.3874542 .3341777
1 214 | -.1384189 .1840925 -0.75 0.452 -.4992336 .2223957
1 215 | .1676965 .1840939 0.91 0.362 -.1931208 .5285139
1 216 | -.5353423 .184096 -2.91 0.004 -.8961638 -.1745209
1 217 | -.4090908 .184096 -2.22 0.026 -.7699123 -.0482693
1 218 | -.7323103 .1840965 -3.98 0.000 -1.093133 -.3714877
1 219 | -.787929 .1841001 -4.28 0.000 -1.148759 -.4270994
1 220 | -1.219653 .184104 -6.62 0.000 -1.58049 -.8588161
1 221 | -.7616042 .1840939 -4.14 0.000 -1.122422 -.4007867
1 222 | -.5085249 .1841493 -2.76 0.006 -.8694509 -.1475989
1 223 | -.5681309 .1841495 -3.09 0.002 -.9290574 -.2072044
1 224 | -.7096571 .1841474 -3.85 0.000 -1.070579 -.3487349
1 225 | -.8205644 .1841469 -4.46 0.000 -1.181486 -.4596431
1 226 | -1.321201 .1841789 -7.17 0.000 -1.682185 -.9602175
1 227 | -1.250933 .1842708 -6.79 0.000 -1.612097 -.8897688
1 228 | -1.170448 .1842545 -6.35 0.000 -1.53158 -.8093155
1 229 | -.4444053 .184239 -2.41 0.016 -.805507 -.0833036
1 230 | -1.291143 .1843656 -7.00 0.000 -1.652492 -.9297927
1 231 | -1.247607 .1843954 -6.77 0.000 -1.609015 -.8861985
1 232 | -1.350357 .1843931 -7.32 0.000 -1.711761 -.9889535
1 233 | -1.143716 .1843826 -6.20 0.000 -1.505099 -.7823328
1 234 | -1.15723 .1843822 -6.28 0.000 -1.518612 -.7958472
|
1.flag_seniors | 0 (omitted)
|
flag_seniors#quarterly |
1 211 | .0460779 .0520377 0.89 0.376 -.0559141 .1480699
1 212 | .0143304 .0520378 0.28 0.783 -.0876618 .1163225
1 213 | .0155588 .0520375 0.30 0.765 -.0864328 .1175504
1 214 | .0674945 .0520425 1.30 0.195 -.0345069 .1694959
1 215 | .0486202 .0520404 0.93 0.350 -.0533772 .1506176
1 216 | .0636044 .0520407 1.22 0.222 -.0383935 .1656022
1 217 | .1100155 .0520467 2.11 0.035 .0080058 .2120253
1 218 | .0456058 .0520433 0.88 0.381 -.0563973 .1476089
1 219 | .0743308 .0520657 1.43 0.153 -.0277161 .1763778
1 220 | .0396032 .052065 0.76 0.447 -.0624424 .1416487
1 221 | .0551083 .0520597 1.06 0.290 -.0469269 .1571435
1 222 | -.001819 .0520582 -0.03 0.972 -.1038513 .1002133
1 223 | .1157909 .0520659 2.22 0.026 .0137436 .2178382
1 224 | .0703766 .0520658 1.35 0.176 -.0316704 .1724237
1 225 | .0451418 .0520684 0.87 0.386 -.0569103 .1471939
1 226 | .0322205 .0521221 0.62 0.536 -.0699369 .1343778
1 227 | .0543094 .0521668 1.04 0.298 -.0479357 .1565546
1 228 | .0048687 .0521954 0.09 0.926 -.0974324 .1071698
1 229 | .0694605 .0522491 1.33 0.184 -.0329458 .1718668
1 230 | .0958905 .0522522 1.84 0.066 -.006522 .1983029
1 231 | .0746657 .052259 1.43 0.153 -.02776 .1770915
1 232 | .0309175 .0522571 0.59 0.554 -.0715045 .1333395
1 233 | .0274331 .0522082 0.53 0.599 -.0748931 .1297592
1 234 | -.0001724 .052202 -0.00 0.997 -.1024865 .1021416
------------------------------+----------------------------------------------------------------
W |
personsinjured | .0170821 .0070908 2.41 0.016 .0031844 .0309798
------------------------------+----------------------------------------------------------------
/sigma_e | .8656763 .0023888 .8610069 .870371
-----------------------------------------------------------------------------------------------
Wald test of spatial terms: chi2(1) = 5.80 Prob > chi2 = 0.0160
splm_qt_results_xt.rtf
dir : seeout
[50]:
estat impact flag_LPIS
progress : 50% 100%
Average impacts Number of obs = 68,400
------------------------------------------------------------------------------
| Delta-Method
| dy/dx Std. Err. z P>|z| [95% Conf. Interval]
-------------+----------------------------------------------------------------
direct |
flag_LPIS |
1 | -.0642561 .017567 -3.66 0.000 -.0986869 -.0298253
-------------+----------------------------------------------------------------
indirect |
flag_LPIS |
1 | -.0010319 .0005169 -2.00 0.046 -.0020449 -.0000189
-------------+----------------------------------------------------------------
total |
flag_LPIS |
1 | -.065288 .0178525 -3.66 0.000 -.1002783 -.0302978
------------------------------------------------------------------------------
[51]:
// Spatial Lagged Model pedestriansinjured
global outcome pedestriansinjured
spxtregress $outcome i.flag_LPIS $time_variant_var $time_var $time_trend, fe dvarlag(W)
outreg2 using "$filename", word append ctitle(spxtregress fe $outcome)
(68400 observations)
(68400 observations used)
(data contain 2736 panels (places) )
(weighting matrix defines 2736 places)
Performing grid search ... finished
Optimizing concentrated log likelihood:
Iteration 0: log likelihood = -39361.9
Iteration 1: log likelihood = -39361.896
Iteration 2: log likelihood = -39361.896
Optimizing unconcentrated log likelihood:
Iteration 0: log likelihood = -39361.896
Iteration 1: log likelihood = -39361.896 (backed up)
Fixed-effects spatial regression Number of obs = 68,400
Group variable: _ID Number of groups = 2,736
Obs per group = 25
Wald chi2(101) = 1022.21
Prob > chi2 = 0.0000
Log likelihood = -3.936e+04 Pseudo R2 = 0.0000
-----------------------------------------------------------------------------------------------
pedestriansinjured | Coef. Std. Err. z P>|z| [95% Conf. Interval]
------------------------------+----------------------------------------------------------------
pedestriansinjured |
1.flag_LPIS | -.0389064 .0089417 -4.35 0.000 -.0564319 -.021381
bike_route_tv | -.011015 .012166 -0.91 0.365 -.0348599 .0128298
flag_street_improv | -.0457492 .0222308 -2.06 0.040 -.0893208 -.0021777
flag_left_turn | -.1676037 .0247986 -6.76 0.000 -.216208 -.1189994
|
quarterly |
211 | .013472 .0143586 0.94 0.348 -.0146702 .0416142
212 | .0205154 .0143592 1.43 0.153 -.0076281 .0486589
213 | .020862 .014359 1.45 0.146 -.0072811 .0490051
214 | .0011847 .0143596 0.08 0.934 -.0269596 .029329
215 | .0199367 .0143634 1.39 0.165 -.008215 .0480884
216 | .0184068 .0143627 1.28 0.200 -.0097437 .0465572
217 | -.0105067 .014365 -0.73 0.465 -.0386615 .0176481
218 | -.0355044 .0143671 -2.47 0.013 -.0636634 -.0073453
219 | .0159608 .0143665 1.11 0.267 -.0121971 .0441187
220 | -.0241698 .0143679 -1.68 0.093 -.0523303 .0039907
221 | -.0290043 .0143749 -2.02 0.044 -.0571785 -.00083
222 | -.0232439 .0143866 -1.62 0.106 -.0514411 .0049533
223 | .0041092 .0143889 0.29 0.775 -.0240925 .0323109
224 | -.0145966 .0143901 -1.01 0.310 -.0428006 .0136075
225 | -.0717218 .0144 -4.98 0.000 -.0999453 -.0434983
226 | -.0810929 .0144159 -5.63 0.000 -.1093476 -.0528382
227 | -.0700716 .0144163 -4.86 0.000 -.098327 -.0418163
228 | -.0164496 .0144154 -1.14 0.254 -.0447033 .0118041
229 | -.0345124 .0144297 -2.39 0.017 -.0627941 -.0062307
230 | -.0752539 .0144405 -5.21 0.000 -.1035566 -.0469511
231 | -.0276754 .0144403 -1.92 0.055 -.0559779 .0006272
232 | -.0199434 .0144424 -1.38 0.167 -.0482499 .0083631
233 | -.053625 .0144923 -3.70 0.000 -.0820294 -.0252207
234 | -.0611189 .0145228 -4.21 0.000 -.089583 -.0326548
|
1.flag_school | 0 (omitted)
|
flag_school#quarterly |
1 211 | .0636056 .0548295 1.16 0.246 -.0438583 .1710695
1 212 | .0767844 .0548301 1.40 0.161 -.0306805 .1842494
1 213 | .0010202 .05483 0.02 0.985 -.1064446 .108485
1 214 | .0046344 .0548297 0.08 0.933 -.1028298 .1120986
1 215 | .0453862 .0548297 0.83 0.408 -.062078 .1528505
1 216 | .0034298 .0548297 0.06 0.950 -.1040344 .110894
1 217 | .0215262 .05483 0.39 0.695 -.0859385 .128991
1 218 | .0357364 .0548298 0.65 0.515 -.071728 .1432008
1 219 | .0599221 .0548295 1.09 0.274 -.0475418 .167386
1 220 | .0473926 .0548297 0.86 0.387 -.0600717 .1548568
1 221 | -.0278285 .0548302 -0.51 0.612 -.1352938 .0796368
1 222 | -.0240829 .0548299 -0.44 0.660 -.1315475 .0833818
1 223 | -.036385 .0548305 -0.66 0.507 -.1438508 .0710808
1 224 | .000519 .0548305 0.01 0.992 -.1069467 .1079848
1 225 | .0601342 .0548304 1.10 0.273 -.0473313 .1675998
1 226 | .0108596 .0548329 0.20 0.843 -.0966108 .11833
1 227 | -.0089297 .0548325 -0.16 0.871 -.1163994 .09854
1 228 | .0167808 .0548328 0.31 0.760 -.0906894 .124251
1 229 | -.0151744 .0548311 -0.28 0.782 -.1226413 .0922925
1 230 | .0818701 .0548309 1.49 0.135 -.0255964 .1893367
1 231 | .0236034 .0548311 0.43 0.667 -.0838636 .1310704
1 232 | .0327841 .0548314 0.60 0.550 -.0746835 .1402517
1 233 | .0136188 .0548311 0.25 0.804 -.0938481 .1210858
1 234 | .0744949 .0548307 1.36 0.174 -.0329712 .1819611
|
1.flag_priorityinters | 0 (omitted)
|
flag_priorityinters#quarterly |
1 211 | .0692439 .0937078 0.74 0.460 -.1144201 .2529079
1 212 | .0315615 .0937087 0.34 0.736 -.1521042 .2152272
1 213 | -.0586093 .0937086 -0.63 0.532 -.2422747 .1250562
1 214 | -.0405052 .0937084 -0.43 0.666 -.2241704 .14316
1 215 | .3750102 .0937092 4.00 0.000 .1913436 .5586769
1 216 | -.0181434 .0937102 -0.19 0.846 -.2018121 .1655252
1 217 | -.2198184 .09371 -2.35 0.019 -.4034867 -.0361501
1 218 | -.3260997 .0937107 -3.48 0.001 -.5097692 -.1424302
1 219 | -.2873309 .093712 -3.07 0.002 -.471003 -.1036589
1 220 | -.2615014 .0937152 -2.79 0.005 -.4451798 -.0778231
1 221 | -.4102273 .0937094 -4.38 0.000 -.5938944 -.2265602
1 222 | -.3740662 .0937382 -3.99 0.000 -.5577897 -.1903428
1 223 | -.3126676 .0937386 -3.34 0.001 -.496392 -.1289433
1 224 | -.2914831 .0937384 -3.11 0.002 -.475207 -.1077591
1 225 | -.3826288 .0937383 -4.08 0.000 -.5663524 -.1989052
1 226 | -.5875321 .0937546 -6.27 0.000 -.7712877 -.4037765
1 227 | -.4963389 .0938012 -5.29 0.000 -.6801859 -.3124919
1 228 | -.4703037 .0937916 -5.01 0.000 -.654132 -.2864755
1 229 | -.3990841 .0937822 -4.26 0.000 -.5828938 -.2152744
1 230 | -.5516818 .09385 -5.88 0.000 -.7356245 -.3677392
1 231 | -.6504625 .093864 -6.93 0.000 -.8344325 -.4664924
1 232 | -.5295524 .0938624 -5.64 0.000 -.7135192 -.3455855
1 233 | -.6246465 .0938574 -6.66 0.000 -.8086036 -.4406894
1 234 | -.4359571 .0938561 -4.64 0.000 -.6199116 -.2520025
|
1.flag_seniors | 0 (omitted)
|
flag_seniors#quarterly |
1 211 | .0088211 .0264888 0.33 0.739 -.043096 .0607383
1 212 | -.0291647 .0264891 -1.10 0.271 -.0810825 .022753
1 213 | -.0179442 .0264886 -0.68 0.498 -.0698609 .0339725
1 214 | -.0140784 .0264912 -0.53 0.595 -.0660003 .0378434
1 215 | .0103188 .0264901 0.39 0.697 -.0416007 .0622384
1 216 | .0035248 .02649 0.13 0.894 -.0483947 .0554443
1 217 | .0234876 .0264915 0.89 0.375 -.0284347 .0754099
1 218 | .0165042 .0264917 0.62 0.533 -.0354186 .0684269
1 219 | .0099538 .0265025 0.38 0.707 -.04199 .0618977
1 220 | -.0092747 .0265027 -0.35 0.726 -.0612189 .0426696
1 221 | -.0045252 .0264999 -0.17 0.864 -.0564641 .0474137
1 222 | -.0289212 .0264995 -1.09 0.275 -.0808592 .0230169
1 223 | .0392993 .026503 1.48 0.138 -.0126455 .0912441
1 224 | .0284564 .026503 1.07 0.283 -.0234885 .0804013
1 225 | .0022805 .0265042 0.09 0.931 -.0496668 .0542277
1 226 | -.0033315 .0265317 -0.13 0.900 -.0553326 .0486696
1 227 | .0234409 .0265548 0.88 0.377 -.0286056 .0754874
1 228 | -.0140671 .026569 -0.53 0.596 -.0661413 .0380072
1 229 | .0254057 .0265962 0.96 0.339 -.026722 .0775333
1 230 | .026133 .0265974 0.98 0.326 -.0259969 .0782629
1 231 | .0040916 .0266005 0.15 0.878 -.0480445 .0562276
1 232 | .0153814 .0266004 0.58 0.563 -.0367544 .0675172
1 233 | .0056984 .0265755 0.21 0.830 -.0463885 .0577854
1 234 | -.0079098 .0265723 -0.30 0.766 -.0599905 .044171
------------------------------+----------------------------------------------------------------
W |
pedestriansinjured | .0006401 .0071392 0.09 0.929 -.0133526 .0146327
------------------------------+----------------------------------------------------------------
/sigma_e | .4406544 .001216 .4382776 .4430441
-----------------------------------------------------------------------------------------------
Wald test of spatial terms: chi2(1) = 0.01 Prob > chi2 = 0.9286
splm_qt_results_xt.rtf
dir : seeout
[52]:
estat impact flag_LPIS
progress : 50% 100%
Average impacts Number of obs = 68,400
------------------------------------------------------------------------------
| Delta-Method
| dy/dx Std. Err. z P>|z| [95% Conf. Interval]
-------------+----------------------------------------------------------------
direct |
flag_LPIS |
1 | -.0389064 .0089417 -4.35 0.000 -.0564319 -.021381
-------------+----------------------------------------------------------------
indirect |
flag_LPIS |
1 | -.0000231 .0002578 -0.09 0.929 -.0005284 .0004822
-------------+----------------------------------------------------------------
total |
flag_LPIS |
1 | -.0389295 .0089497 -4.35 0.000 -.0564707 -.0213884
------------------------------------------------------------------------------
[53]:
// Spatial Lagged Model cyclistinjured
global outcome cyclistinjured
spxtregress $outcome i.flag_LPIS $time_variant_var $time_var $time_trend, fe dvarlag(W)
outreg2 using "$filename", word append ctitle(spxtregress fe $outcome)
(68400 observations)
(68400 observations used)
(data contain 2736 panels (places) )
(weighting matrix defines 2736 places)
Performing grid search ... finished
Optimizing concentrated log likelihood:
Iteration 0: log likelihood = -9728.8655
Iteration 1: log likelihood = -9718.5737
Iteration 2: log likelihood = -9718.5734
Optimizing unconcentrated log likelihood:
Iteration 0: log likelihood = -9718.5734
Iteration 1: log likelihood = -9718.5734 (backed up)
Fixed-effects spatial regression Number of obs = 68,400
Group variable: _ID Number of groups = 2,736
Obs per group = 25
Wald chi2(101) = 682.36
Prob > chi2 = 0.0000
Log likelihood = -9718.5734 Pseudo R2 = 0.0035
-----------------------------------------------------------------------------------------------
cyclistinjured | Coef. Std. Err. z P>|z| [95% Conf. Interval]
------------------------------+----------------------------------------------------------------
cyclistinjured |
1.flag_LPIS | -.0166249 .0056928 -2.92 0.003 -.0277826 -.0054671
bike_route_tv | .0032725 .0077457 0.42 0.673 -.0119089 .0184538
flag_street_improv | .0049408 .0141536 0.35 0.727 -.0227996 .0326813
flag_left_turn | -.0280938 .0157885 -1.78 0.075 -.0590387 .002851
|
quarterly |
211 | -.0360871 .0091445 -3.95 0.000 -.05401 -.0181643
212 | -.0428867 .0091459 -4.69 0.000 -.0608123 -.0249611
213 | -.002762 .0091417 -0.30 0.763 -.0206794 .0151554
214 | .0105291 .009143 1.15 0.249 -.0073908 .0284489
215 | -.0173163 .0091448 -1.89 0.058 -.0352398 .0006071
216 | -.0469431 .0091496 -5.13 0.000 -.064876 -.0290102
217 | .0095068 .0091457 1.04 0.299 -.0084184 .027432
218 | .0268743 .0091475 2.94 0.003 .0089456 .044803
219 | -.0198102 .0091476 -2.17 0.030 -.0377392 -.0018812
220 | -.0552931 .009155 -6.04 0.000 -.0732367 -.0373496
221 | -.0015899 .0091506 -0.17 0.862 -.0195247 .0163449
222 | .0167037 .009159 1.82 0.068 -.0012475 .034655
223 | .0095183 .009161 1.04 0.299 -.0084369 .0274734
224 | -.0426232 .0091663 -4.65 0.000 -.0605889 -.0246576
225 | -.0111797 .0091623 -1.22 0.222 -.0291374 .006778
226 | -.0314541 .0091718 -3.43 0.001 -.0494305 -.0134778
227 | -.0456934 .0091765 -4.98 0.000 -.0636789 -.0277079
228 | -.0504781 .0091837 -5.50 0.000 -.0684777 -.0324784
229 | -.0143299 .0091847 -1.56 0.119 -.0323317 .0036718
230 | -.0129047 .0091865 -1.40 0.160 -.0309099 .0051004
231 | -.031365 .0091942 -3.41 0.001 -.0493853 -.0133448
232 | -.0399482 .0091983 -4.34 0.000 -.0579765 -.0219199
233 | -.01421 .0092218 -1.54 0.123 -.0322844 .0038643
234 | .0061884 .0092396 0.67 0.503 -.0119209 .0242977
|
1.flag_school | 0 (omitted)
|
flag_school#quarterly |
1 211 | .0110542 .0349079 0.32 0.751 -.057364 .0794725
1 212 | .0221572 .0349079 0.63 0.526 -.046261 .0905754
1 213 | .0236273 .0349079 0.68 0.499 -.0447911 .0920456
1 214 | .0442721 .0349081 1.27 0.205 -.0241466 .1126908
1 215 | .0105355 .034908 0.30 0.763 -.0578828 .0789539
1 216 | .0036352 .034908 0.10 0.917 -.0647831 .0720536
1 217 | -.022552 .034908 -0.65 0.518 -.0909705 .0458664
1 218 | -.0303903 .0349084 -0.87 0.384 -.0988094 .0380288
1 219 | .0079712 .034908 0.23 0.819 -.0604473 .0763897
1 220 | .0415078 .0349079 1.19 0.234 -.0269104 .1099259
1 221 | .0399237 .0349079 1.14 0.253 -.0284946 .108342
1 222 | .0181288 .0349081 0.52 0.604 -.0502899 .0865474
1 223 | -.0205392 .0349087 -0.59 0.556 -.0889589 .0478805
1 224 | .0158756 .0349084 0.45 0.649 -.0525436 .0842948
1 225 | .0166098 .0349083 0.48 0.634 -.0518093 .0850289
1 226 | .0109257 .03491 0.31 0.754 -.0574966 .0793481
1 227 | .0206171 .0349095 0.59 0.555 -.0478042 .0890384
1 228 | .0309668 .0349098 0.89 0.375 -.0374551 .0993887
1 229 | .0421628 .0349089 1.21 0.227 -.0262573 .1105829
1 230 | .0508598 .034909 1.46 0.145 -.0175606 .1192802
1 231 | .0338148 .0349092 0.97 0.333 -.0346059 .1022355
1 232 | .0055969 .0349089 0.16 0.873 -.0628232 .0740171
1 233 | .0323838 .0349089 0.93 0.354 -.0360363 .100804
1 234 | .0190372 .0349086 0.55 0.586 -.0493824 .0874569
|
1.flag_priorityinters | 0 (omitted)
|
flag_priorityinters#quarterly |
1 211 | -.2169715 .0596603 -3.64 0.000 -.3339035 -.1000395
1 212 | -.0461183 .0596603 -0.77 0.440 -.1630503 .0708137
1 213 | -.1369321 .0596615 -2.30 0.022 -.2538665 -.0199978
1 214 | .0732003 .0596607 1.23 0.220 -.0437326 .1901331
1 215 | -.1393858 .0596611 -2.34 0.019 -.2563194 -.0224522
1 216 | -.1544507 .0596613 -2.59 0.010 -.2713847 -.0375167
1 217 | .0978163 .0596617 1.64 0.101 -.0191185 .214751
1 218 | .0482485 .0596618 0.81 0.419 -.0686864 .1651834
1 219 | -.0898942 .0596628 -1.51 0.132 -.2068312 .0270428
1 220 | -.1608285 .0596628 -2.70 0.007 -.2777654 -.0438916
1 221 | -.1561498 .059661 -2.62 0.009 -.2730832 -.0392164
1 222 | .0529695 .0596786 0.89 0.375 -.0639985 .1699375
1 223 | -.0008465 .0596794 -0.01 0.989 -.1178161 .116123
1 224 | -.1316326 .0596783 -2.21 0.027 -.2485999 -.0146653
1 225 | -.046459 .0596779 -0.78 0.436 -.1634255 .0705075
1 226 | -.0750748 .0596873 -1.26 0.208 -.1920598 .0419102
1 227 | -.1330616 .0597187 -2.23 0.026 -.250108 -.0160151
1 228 | -.1882213 .0597134 -3.15 0.002 -.3052575 -.0711851
1 229 | -.0739517 .0597075 -1.24 0.216 -.1909762 .0430727
1 230 | -.1595165 .0597482 -2.67 0.008 -.2766209 -.0424121
1 231 | -.1388065 .0597583 -2.32 0.020 -.2559307 -.0216823
1 232 | -.1655472 .0597577 -2.77 0.006 -.2826701 -.0484243
1 233 | -.0890723 .0597534 -1.49 0.136 -.2061868 .0280422
1 234 | -.062679 .059755 -1.05 0.294 -.1797967 .0544386
|
1.flag_seniors | 0 (omitted)
|
flag_seniors#quarterly |
1 211 | .0227077 .0168646 1.35 0.178 -.0103463 .0557617
1 212 | .0022226 .0168644 0.13 0.895 -.0308311 .0352763
1 213 | .0095357 .0168643 0.57 0.572 -.0235176 .0425891
1 214 | .0054346 .0168659 0.32 0.747 -.0276219 .0384911
1 215 | .0057881 .0168653 0.34 0.731 -.0272672 .0388435
1 216 | .0085337 .0168653 0.51 0.613 -.0245217 .041589
1 217 | .0119231 .0168664 0.71 0.480 -.0211345 .0449807
1 218 | -.0189629 .0168664 -1.12 0.261 -.0520205 .0140947
1 219 | -.0018013 .0168732 -0.11 0.915 -.0348721 .0312695
1 220 | -.0130468 .0168733 -0.77 0.439 -.0461178 .0200242
1 221 | .0026555 .0168715 0.16 0.875 -.030412 .0357231
1 222 | .0033236 .016871 0.20 0.844 -.029743 .0363901
1 223 | -.0106455 .0168734 -0.63 0.528 -.0437167 .0224256
1 224 | .0059371 .0168735 0.35 0.725 -.0271343 .0390086
1 225 | -.0096282 .0168743 -0.57 0.568 -.0427012 .0234447
1 226 | .006959 .0168917 0.41 0.680 -.0261482 .0400663
1 227 | .0260375 .0169066 1.54 0.124 -.0070987 .0591738
1 228 | .0148636 .0169157 0.88 0.380 -.0182906 .0480178
1 229 | .0184043 .0169329 1.09 0.277 -.0147836 .0515923
1 230 | .0133846 .0169334 0.79 0.429 -.0198043 .0465735
1 231 | .0114624 .0169356 0.68 0.499 -.0217308 .0446556
1 232 | -.0066474 .0169355 -0.39 0.695 -.0398403 .0265455
1 233 | .0098359 .0169196 0.58 0.561 -.023326 .0429977
1 234 | .0076153 .0169175 0.45 0.653 -.0255425 .040773
------------------------------+----------------------------------------------------------------
W |
cyclistinjured | .0320246 .0070454 4.55 0.000 .0182159 .0458332
------------------------------+----------------------------------------------------------------
/sigma_e | .280548 .0007742 .2790346 .2820695
-----------------------------------------------------------------------------------------------
Wald test of spatial terms: chi2(1) = 20.66 Prob > chi2 = 0.0000
splm_qt_results_xt.rtf
dir : seeout
[54]:
estat impact flag_LPIS
progress : 50% 100%
Average impacts Number of obs = 68,400
------------------------------------------------------------------------------
| Delta-Method
| dy/dx Std. Err. z P>|z| [95% Conf. Interval]
-------------+----------------------------------------------------------------
direct |
flag_LPIS |
1 | -.0166274 .0056937 -2.92 0.003 -.0277868 -.005468
-------------+----------------------------------------------------------------
indirect |
flag_LPIS |
1 | -.0005068 .000208 -2.44 0.015 -.0009144 -.0000992
-------------+----------------------------------------------------------------
total |
flag_LPIS |
1 | -.0171342 .0058684 -2.92 0.004 -.0286361 -.0056323
------------------------------------------------------------------------------
[55]:
// Spatial Lagged Model motoristinjured
global outcome motoristinjured
spxtregress $outcome i.flag_LPIS $time_variant_var $time_var $time_trend, fe dvarlag(W)
outreg2 using "$filename", word append ctitle(spxtregress fe $outcome)
(68400 observations)
(68400 observations used)
(data contain 2736 panels (places) )
(weighting matrix defines 2736 places)
Performing grid search ... finished
Optimizing concentrated log likelihood:
Iteration 0: log likelihood = -67574.835
Iteration 1: log likelihood = -67573.072
Iteration 2: log likelihood = -67573.072
Optimizing unconcentrated log likelihood:
Iteration 0: log likelihood = -67573.072
Iteration 1: log likelihood = -67573.072 (backed up)
Fixed-effects spatial regression Number of obs = 68,400
Group variable: _ID Number of groups = 2,736
Obs per group = 25
Wald chi2(101) = 407.21
Prob > chi2 = 0.0000
Log likelihood = -6.757e+04 Pseudo R2 = 0.0001
-----------------------------------------------------------------------------------------------
motoristinjured | Coef. Std. Err. z P>|z| [95% Conf. Interval]
------------------------------+----------------------------------------------------------------
motoristinjured |
1.flag_LPIS | -.0089702 .0137404 -0.65 0.514 -.0359009 .0179606
bike_route_tv | .0359249 .0186952 1.92 0.055 -.0007171 .0725668
flag_street_improv | -.029545 .0341614 -0.86 0.387 -.0965 .0374101
flag_left_turn | -.0961304 .0381078 -2.52 0.012 -.1708204 -.0214404
|
quarterly |
211 | -.0573583 .0220667 -2.60 0.009 -.1006083 -.0141084
212 | -.0890739 .0220699 -4.04 0.000 -.1323301 -.0458176
213 | -.046686 .0220655 -2.12 0.034 -.0899335 -.0034384
214 | -.0369663 .0220664 -1.68 0.094 -.0802156 .006283
215 | -.0795873 .0220735 -3.61 0.000 -.1228505 -.0363241
216 | -.1186153 .0220829 -5.37 0.000 -.161897 -.0753335
217 | -.0706966 .0220784 -3.20 0.001 -.1139694 -.0274237
218 | -.0726908 .0220799 -3.29 0.001 -.1159665 -.029415
219 | -.1074137 .0220849 -4.86 0.000 -.1506993 -.0641281
220 | -.1315519 .0220936 -5.95 0.000 -.1748546 -.0882492
221 | -.0964786 .0220933 -4.37 0.000 -.1397807 -.0531765
222 | -.0855645 .0221105 -3.87 0.000 -.1289004 -.0422286
223 | -.1051435 .0221193 -4.75 0.000 -.1484966 -.0617904
224 | -.1146001 .0221228 -5.18 0.000 -.1579601 -.0712402
225 | -.1248069 .0221263 -5.64 0.000 -.1681736 -.0814401
226 | -.1639219 .0221565 -7.40 0.000 -.2073479 -.1204959
227 | -.1501255 .0221575 -6.78 0.000 -.1935533 -.1066976
228 | -.1268572 .0221643 -5.72 0.000 -.1702985 -.0834158
229 | -.0891028 .0221743 -4.02 0.000 -.1325636 -.045642
230 | -.1035554 .0221836 -4.67 0.000 -.1470346 -.0600763
231 | -.1182552 .0221997 -5.33 0.000 -.1617659 -.0747446
232 | -.132491 .0222065 -5.97 0.000 -.176015 -.088967
233 | -.0829937 .0222618 -3.73 0.000 -.126626 -.0393614
234 | -.0773852 .0223076 -3.47 0.001 -.1211072 -.0336632
|
1.flag_school | 0 (omitted)
|
flag_school#quarterly |
1 211 | .0229818 .0842548 0.27 0.785 -.1421545 .1881182
1 212 | .0231484 .084255 0.27 0.784 -.1419883 .1882851
1 213 | .0511107 .084255 0.61 0.544 -.114026 .2162474
1 214 | .0507112 .084255 0.60 0.547 -.1144256 .215848
1 215 | .0627521 .084255 0.74 0.456 -.1023846 .2278889
1 216 | -.0319452 .084255 -0.38 0.705 -.1970819 .1331915
1 217 | -.0739506 .0842555 -0.88 0.380 -.2390884 .0911873
1 218 | -.0025395 .0842549 -0.03 0.976 -.167676 .162597
1 219 | .1570837 .0842547 1.86 0.062 -.0080525 .3222199
1 220 | -.0243028 .0842547 -0.29 0.773 -.189439 .1408333
1 221 | .0864695 .0842549 1.03 0.305 -.0786671 .2516061
1 222 | -.0019083 .0842553 -0.02 0.982 -.1670457 .1632292
1 223 | -.0314582 .0842559 -0.37 0.709 -.1965968 .1336804
1 224 | .0604551 .0842564 0.72 0.473 -.1046843 .2255946
1 225 | .0798553 .0842559 0.95 0.343 -.0852833 .2449938
1 226 | -.0024508 .0842599 -0.03 0.977 -.1675972 .1626956
1 227 | -.025202 .0842587 -0.30 0.765 -.190346 .139942
1 228 | -.0415845 .0842592 -0.49 0.622 -.2067294 .1235605
1 229 | -.0316908 .0842582 -0.38 0.707 -.1968339 .1334523
1 230 | -.0547945 .0842571 -0.65 0.515 -.2199353 .1103463
1 231 | .0862341 .0842573 1.02 0.306 -.0789073 .2513755
1 232 | .1158659 .0842572 1.38 0.169 -.0492752 .2810071
1 233 | .0378177 .084257 0.45 0.654 -.127323 .2029584
1 234 | .0813363 .0842573 0.97 0.334 -.0838049 .2464775
|
1.flag_priorityinters | 0 (omitted)
|
flag_priorityinters#quarterly |
1 211 | -.4595643 .1439977 -3.19 0.001 -.7417946 -.1773339
1 212 | -.3929388 .1439977 -2.73 0.006 -.6751692 -.1107084
1 213 | .1689508 .1439979 1.17 0.241 -.1132799 .4511814
1 214 | -.1715436 .1439986 -1.19 0.234 -.4537758 .1106885
1 215 | -.0679209 .1439996 -0.47 0.637 -.3501549 .214313
1 216 | -.3636811 .1440009 -2.53 0.012 -.6459176 -.0814446
1 217 | -.286964 .1440012 -1.99 0.046 -.5692011 -.0047268
1 218 | -.4550736 .1440016 -3.16 0.002 -.7373116 -.1728357
1 219 | -.4109444 .1440052 -2.85 0.004 -.6931895 -.1286994
1 220 | -.7990524 .1440045 -5.55 0.000 -1.081296 -.5168088
1 221 | -.1957728 .1439996 -1.36 0.174 -.4780069 .0864612
1 222 | -.1883312 .1440418 -1.31 0.191 -.4706478 .0939855
1 223 | -.2565087 .1440429 -1.78 0.075 -.5388277 .0258102
1 224 | -.2770973 .1440414 -1.92 0.054 -.5594133 .0052187
1 225 | -.3880546 .1440401 -2.69 0.007 -.6703681 -.1057412
1 226 | -.6455891 .144063 -4.48 0.000 -.9279475 -.3632308
1 227 | -.5725377 .1441374 -3.97 0.000 -.8550418 -.2900336
1 228 | -.3708984 .1441244 -2.57 0.010 -.653377 -.0884198
1 229 | .0285202 .1441152 0.20 0.843 -.2539405 .3109808
1 230 | -.5385657 .1442098 -3.73 0.000 -.8212117 -.2559198
1 231 | -.4598624 .1442346 -3.19 0.001 -.742557 -.1771677
1 232 | -.6555685 .144233 -4.55 0.000 -.9382599 -.3728771
1 233 | -.4518502 .1442232 -3.13 0.002 -.7345225 -.1691779
1 234 | -.6793271 .1442246 -4.71 0.000 -.962002 -.3966522
|
1.flag_seniors | 0 (omitted)
|
flag_seniors#quarterly |
1 211 | .0144445 .0407046 0.35 0.723 -.065335 .0942241
1 212 | .0407979 .0407043 1.00 0.316 -.0389811 .120577
1 213 | .0239164 .0407042 0.59 0.557 -.0558623 .1036951
1 214 | .0760141 .0407088 1.87 0.062 -.0037736 .1558018
1 215 | .0324318 .0407064 0.80 0.426 -.0473513 .1122148
1 216 | .0514811 .0407066 1.26 0.206 -.0283023 .1312645
1 217 | .0747813 .0407101 1.84 0.066 -.005009 .1545715
1 218 | .0480837 .0407091 1.18 0.238 -.0317047 .127872
1 219 | .0660026 .0407265 1.62 0.105 -.01382 .1458251
1 220 | .0618173 .040726 1.52 0.129 -.0180041 .1416388
1 221 | .0569017 .0407217 1.40 0.162 -.0229115 .1367148
1 222 | .0233072 .0407203 0.57 0.567 -.0565032 .1031176
1 223 | .0876218 .0407264 2.15 0.031 .0077996 .1674441
1 224 | .0384409 .0407263 0.94 0.345 -.0413812 .1182629
1 225 | .0618867 .0407287 1.52 0.129 -.0179402 .1417135
1 226 | .0405181 .0407704 0.99 0.320 -.0393904 .1204266
1 227 | .0199502 .0408049 0.49 0.625 -.060026 .0999265
1 228 | .0130042 .0408277 0.32 0.750 -.0670166 .093025
1 229 | .0254153 .0408693 0.62 0.534 -.0546872 .1055177
1 230 | .0607255 .0408715 1.49 0.137 -.0193812 .1408323
1 231 | .0583743 .0408778 1.43 0.153 -.0217447 .1384933
1 232 | .0227598 .0408759 0.56 0.578 -.0573556 .1028751
1 233 | .0092282 .0408378 0.23 0.821 -.0708124 .0892688
1 234 | .0023886 .0408327 0.06 0.953 -.077642 .0824192
------------------------------+----------------------------------------------------------------
W |
motoristinjured | .0133925 .007125 1.88 0.060 -.0005723 .0273572
------------------------------+----------------------------------------------------------------
/sigma_e | .6771391 .0018686 .6734867 .6808113
-----------------------------------------------------------------------------------------------
Wald test of spatial terms: chi2(1) = 3.53 Prob > chi2 = 0.0602
splm_qt_results_xt.rtf
dir : seeout
[56]:
estat impact flag_LPIS
progress : 50% 100%
Average impacts Number of obs = 68,400
------------------------------------------------------------------------------
| Delta-Method
| dy/dx Std. Err. z P>|z| [95% Conf. Interval]
-------------+----------------------------------------------------------------
direct |
flag_LPIS |
1 | -.0089704 .0137408 -0.65 0.514 -.0359019 .0179611
-------------+----------------------------------------------------------------
indirect |
flag_LPIS |
1 | -.0001126 .0001826 -0.62 0.537 -.0004705 .0002453
-------------+----------------------------------------------------------------
total |
flag_LPIS |
1 | -.009083 .0139132 -0.65 0.514 -.0363524 .0181864
------------------------------------------------------------------------------
Spatial Error Model¶
[57]:
global filename spem_qt_results_xt
[58]:
// Spatial Error Model collision_count
global outcome collision_count
spxtregress $outcome i.flag_LPIS $time_variant_var $time_var $time_trend, fe errorlag(W)
outreg2 using "$filename", word replace ctitle(spxtregress fe $outcome) title(Spatial Error Model)
(68400 observations)
(68400 observations used)
(data contain 2736 panels (places) )
(weighting matrix defines 2736 places)
Performing grid search ... finished
Optimizing concentrated log likelihood:
Iteration 0: log likelihood = -133985.86
Iteration 1: log likelihood = -133984.21
Iteration 2: log likelihood = -133984.21
Optimizing unconcentrated log likelihood:
Iteration 0: log likelihood = -133984.21
Iteration 1: log likelihood = -133984.21 (backed up)
Fixed-effects spatial regression Number of obs = 68,400
Group variable: _ID Number of groups = 2,736
Obs per group = 25
Wald chi2(100) = 4704.37
Prob > chi2 = 0.0000
Log likelihood = -1.340e+05 Pseudo R2 = 0.0039
-----------------------------------------------------------------------------------------------
collision_count | Coef. Std. Err. z P>|z| [95% Conf. Interval]
------------------------------+----------------------------------------------------------------
collision_count |
1.flag_LPIS | -.1294168 .0387183 -3.34 0.001 -.2053034 -.0535302
bike_route_tv | .1407518 .0537343 2.62 0.009 .0354345 .2460691
flag_street_improv | -.4711026 .0953038 -4.94 0.000 -.6578947 -.2843105
flag_left_turn | -.9038746 .1045866 -8.64 0.000 -1.108861 -.6988886
|
quarterly |
211 | -.2673721 .0716621 -3.73 0.000 -.4078272 -.126917
212 | -.4373628 .0716613 -6.10 0.000 -.5778164 -.2969092
213 | .0420336 .0716643 0.59 0.558 -.0984259 .182493
214 | -.0531105 .0716656 -0.74 0.459 -.1935726 .0873515
215 | -.0845811 .0716743 -1.18 0.238 -.2250602 .055898
216 | -.4651976 .0716742 -6.49 0.000 -.6056764 -.3247188
217 | .0166714 .071685 0.23 0.816 -.1238285 .1571714
218 | -.0400952 .0716857 -0.56 0.576 -.1805967 .1004063
219 | -.0879663 .0716909 -1.23 0.220 -.228478 .0525453
220 | -.4865736 .0716943 -6.79 0.000 -.6270918 -.3460554
221 | .042314 .0717178 0.59 0.555 -.0982504 .1828783
222 | .0337994 .0717607 0.47 0.638 -.106849 .1744478
223 | .082293 .0717777 1.15 0.252 -.0583888 .2229748
224 | -.3387349 .0717814 -4.72 0.000 -.479424 -.1980459
225 | -.6797072 .0717861 -9.47 0.000 -.8204054 -.539009
226 | -1.302355 .071837 -18.13 0.000 -1.443153 -1.161557
227 | -1.320706 .0718453 -18.38 0.000 -1.46152 -1.179892
228 | -1.102278 .0718793 -15.34 0.000 -1.243159 -.9613976
229 | -.6314304 .0719383 -8.78 0.000 -.7724269 -.4904339
230 | -1.008659 .0719523 -14.02 0.000 -1.149683 -.867635
231 | -.9149774 .071978 -12.71 0.000 -1.056052 -.773903
232 | -.934863 .0719906 -12.99 0.000 -1.075962 -.7937639
233 | -.6500721 .0721568 -9.01 0.000 -.7914969 -.5086473
234 | -.8401344 .0722684 -11.63 0.000 -.981778 -.6984909
|
1.flag_school | 0 (omitted)
|
flag_school#quarterly |
1 211 | .3499512 .2328839 1.50 0.133 -.1064929 .8063954
1 212 | .337098 .232884 1.45 0.148 -.1193463 .7935422
1 213 | .2552392 .2328856 1.10 0.273 -.2012081 .7116865
1 214 | .1119862 .232886 0.48 0.631 -.344462 .5684344
1 215 | .0070214 .2328854 0.03 0.976 -.4494257 .4634685
1 216 | .1540055 .2328844 0.66 0.508 -.3024396 .6104506
1 217 | .2290229 .2328872 0.98 0.325 -.2274276 .6854733
1 218 | .0679914 .2328843 0.29 0.770 -.3884534 .5244362
1 219 | .5515511 .2328907 2.37 0.018 .0950937 1.008008
1 220 | .4616977 .2328883 1.98 0.047 .005245 .9181504
1 221 | .0938358 .2328915 0.40 0.687 -.3626231 .5502948
1 222 | .1940827 .2328887 0.83 0.405 -.2623707 .6505361
1 223 | .2101705 .2328908 0.90 0.367 -.2462872 .6666281
1 224 | .102951 .2328888 0.44 0.658 -.3535025 .5594046
1 225 | .4768202 .2328909 2.05 0.041 .0203624 .933278
1 226 | .2504184 .2328998 1.08 0.282 -.2060569 .7068937
1 227 | .2961787 .2328966 1.27 0.203 -.1602901 .7526476
1 228 | .2887736 .2329003 1.24 0.215 -.1677026 .7452499
1 229 | .5150898 .2328939 2.21 0.027 .0586261 .9715534
1 230 | .4385619 .2328959 1.88 0.060 -.0179056 .8950294
1 231 | .5190943 .2328987 2.23 0.026 .0626214 .9755673
1 232 | .5188351 .2328919 2.23 0.026 .0623753 .9752949
1 233 | .2604016 .2328917 1.12 0.264 -.1960578 .716861
1 234 | .5047731 .2328966 2.17 0.030 .0483042 .961242
|
1.flag_priorityinters | 0 (omitted)
|
flag_priorityinters#quarterly |
1 211 | -.810824 .3952036 -2.05 0.040 -1.585409 -.0362392
1 212 | -1.417468 .3952014 -3.59 0.000 -2.192049 -.6428878
1 213 | -.7785217 .3951994 -1.97 0.049 -1.553098 -.0039451
1 214 | -.2402559 .3952036 -0.61 0.543 -1.014841 .534329
1 215 | .1005427 .3952041 0.25 0.799 -.6740432 .8751285
1 216 | -1.82542 .395209 -4.62 0.000 -2.600016 -1.050825
1 217 | -1.094598 .3952083 -2.77 0.006 -1.869192 -.3200041
1 218 | -.8330192 .3952125 -2.11 0.035 -1.607621 -.0584169
1 219 | -1.510197 .3952281 -3.82 0.000 -2.28483 -.7355643
1 220 | -2.445791 .3952364 -6.19 0.000 -3.22044 -1.671142
1 221 | -1.48635 .3952053 -3.76 0.000 -2.260938 -.7117617
1 222 | .4604002 .395328 1.16 0.244 -.3144285 1.235229
1 223 | -1.229855 .3953284 -3.11 0.002 -2.004684 -.4550258
1 224 | -1.515602 .3953326 -3.83 0.000 -2.29044 -.7407649
1 225 | -2.507237 .3953511 -6.34 0.000 -3.282111 -1.732363
1 226 | -3.746962 .3954467 -9.48 0.000 -4.522024 -2.971901
1 227 | -4.28631 .3956422 -10.83 0.000 -5.061754 -3.510865
1 228 | -3.717741 .3956257 -9.40 0.000 -4.493153 -2.942329
1 229 | -3.741524 .3955266 -9.46 0.000 -4.516742 -2.966307
1 230 | -3.904754 .3958448 -9.86 0.000 -4.680595 -3.128912
1 231 | -4.177648 .395907 -10.55 0.000 -4.953612 -3.401685
1 232 | -3.570456 .3959188 -9.02 0.000 -4.346443 -2.794469
1 233 | -3.519881 .3958583 -8.89 0.000 -4.295749 -2.744013
1 234 | -3.84415 .3958323 -9.71 0.000 -4.619967 -3.068333
|
1.flag_seniors | 0 (omitted)
|
flag_seniors#quarterly |
1 211 | .2240542 .1285535 1.74 0.081 -.027906 .4760145
1 212 | .0002724 .1285479 0.00 0.998 -.2516769 .2522218
1 213 | .0954619 .1285471 0.74 0.458 -.1564857 .3474096
1 214 | .1601147 .1285598 1.25 0.213 -.0918578 .4120872
1 215 | .2541637 .1285559 1.98 0.048 .0021989 .5061286
1 216 | .1847838 .1285552 1.44 0.151 -.0671797 .4367473
1 217 | .1657745 .128568 1.29 0.197 -.0862141 .417763
1 218 | -.0631382 .1285613 -0.49 0.623 -.3151137 .1888374
1 219 | .1139398 .1286133 0.89 0.376 -.1381376 .3660171
1 220 | -.0407934 .1286172 -0.32 0.751 -.2928785 .2112917
1 221 | .2208709 .1285965 1.72 0.086 -.0311736 .4729154
1 222 | .127847 .1285924 0.99 0.320 -.1241894 .3798834
1 223 | .2633668 .1286075 2.05 0.041 .0113008 .5154329
1 224 | .0074932 .1286083 0.06 0.954 -.2445744 .2595608
1 225 | -.3492169 .1286137 -2.72 0.007 -.601295 -.0971387
1 226 | -.2425033 .128706 -1.88 0.060 -.4947624 .0097557
1 227 | -.1856339 .1288004 -1.44 0.150 -.438078 .0668103
1 228 | -.1242051 .1288534 -0.96 0.335 -.3767531 .1283428
1 229 | -.0653259 .128931 -0.51 0.612 -.318026 .1873743
1 230 | .0016791 .1289385 0.01 0.990 -.2510356 .2543939
1 231 | -.0635057 .1289521 -0.49 0.622 -.3162471 .1892358
1 232 | -.3627133 .1289417 -2.81 0.005 -.6154343 -.1099923
1 233 | -.1463003 .1288668 -1.14 0.256 -.3988746 .106274
1 234 | -.3394852 .1288525 -2.63 0.008 -.5920315 -.086939
------------------------------+----------------------------------------------------------------
W |
e.collision_count | .1884038 .0063947 29.46 0.000 .1758704 .2009372
------------------------------+----------------------------------------------------------------
/sigma_e | 1.856616 .0051356 1.846578 1.866709
-----------------------------------------------------------------------------------------------
Wald test of spatial terms: chi2(1) = 868.04 Prob > chi2 = 0.0000
spem_qt_results_xt.rtf
dir : seeout
[59]:
// Spatial Error Model collision_count
global outcome personsinjured
spxtregress $outcome i.flag_LPIS $time_variant_var $time_var $time_trend, fe errorlag(W)
outreg2 using "$filename", word append ctitle(spxtregress fe $outcome)
(68400 observations)
(68400 observations used)
(data contain 2736 panels (places) )
(weighting matrix defines 2736 places)
Performing grid search ... finished
Optimizing concentrated log likelihood:
Iteration 0: log likelihood = -83705.847
Iteration 1: log likelihood = -83703.625
Iteration 2: log likelihood = -83703.625
Optimizing unconcentrated log likelihood:
Iteration 0: log likelihood = -83703.625
Iteration 1: log likelihood = -83703.625 (backed up)
Fixed-effects spatial regression Number of obs = 68,400
Group variable: _ID Number of groups = 2,736
Obs per group = 25
Wald chi2(100) = 1030.31
Prob > chi2 = 0.0000
Log likelihood = -8.370e+04 Pseudo R2 = 0.0008
-----------------------------------------------------------------------------------------------
personsinjured | Coef. Std. Err. z P>|z| [95% Conf. Interval]
------------------------------+----------------------------------------------------------------
personsinjured |
1.flag_LPIS | -.0644151 .0176081 -3.66 0.000 -.0989264 -.0299038
bike_route_tv | .0257167 .0239981 1.07 0.284 -.0213186 .0727521
flag_street_improv | -.0712783 .0437444 -1.63 0.103 -.1570157 .014459
flag_left_turn | -.2893237 .0487362 -5.94 0.000 -.3848449 -.1938026
|
quarterly |
211 | -.0818592 .028562 -2.87 0.004 -.1378397 -.0258787
212 | -.1140973 .0285626 -3.99 0.000 -.170079 -.0581156
213 | -.029118 .0285631 -1.02 0.308 -.0851005 .0268646
214 | -.0252689 .0285649 -0.88 0.376 -.0812551 .0307172
215 | -.0786186 .02857 -2.75 0.006 -.1346147 -.0226225
216 | -.1502113 .0285696 -5.26 0.000 -.2062067 -.0942159
217 | -.0722123 .0285744 -2.53 0.011 -.1282171 -.0162076
218 | -.0816787 .0285764 -2.86 0.004 -.1376873 -.02567
219 | -.1131949 .0285774 -3.96 0.000 -.1692056 -.0571842
220 | -.2145317 .0285784 -7.51 0.000 -.2705443 -.1585191
221 | -.1282402 .0285903 -4.49 0.000 -.1842762 -.0722042
222 | -.0925481 .0286134 -3.23 0.001 -.1486292 -.0364669
223 | -.0926406 .0286221 -3.24 0.001 -.1487388 -.0365423
224 | -.1633157 .0286236 -5.71 0.000 -.2194169 -.1072145
225 | -.2010974 .0286249 -7.03 0.000 -.257201 -.1449937
226 | -.2827573 .0286476 -9.87 0.000 -.3389055 -.2266091
227 | -.2793258 .0286523 -9.75 0.000 -.3354833 -.2231682
228 | -.2299002 .0286695 -8.02 0.000 -.2860913 -.1737091
229 | -.139215 .0286937 -4.85 0.000 -.1954535 -.0829765
230 | -.1932757 .0286992 -6.73 0.000 -.2495252 -.1370262
231 | -.1799292 .0287155 -6.27 0.000 -.2362107 -.1236478
232 | -.1947384 .0287216 -6.78 0.000 -.2510318 -.1384451
233 | -.1511494 .028807 -5.25 0.000 -.20761 -.0946888
234 | -.1311498 .0288635 -4.54 0.000 -.1877211 -.0745784
|
1.flag_school | 0 (omitted)
|
flag_school#quarterly |
1 211 | .0974288 .1078097 0.90 0.366 -.1138744 .3087319
1 212 | .1227632 .1078099 1.14 0.255 -.0885404 .3340668
1 213 | .0765732 .1078105 0.71 0.478 -.1347314 .2878779
1 214 | .0997691 .1078103 0.93 0.355 -.1115353 .3110735
1 215 | .1191269 .1078103 1.10 0.269 -.0921775 .3304312
1 216 | -.0249504 .10781 -0.23 0.817 -.2362541 .1863533
1 217 | -.0736911 .1078147 -0.68 0.494 -.285004 .1376218
1 218 | .0036443 .1078098 0.03 0.973 -.2076592 .2149477
1 219 | .2255113 .1078106 2.09 0.036 .0142064 .4368162
1 220 | .0652687 .1078099 0.61 0.545 -.1460348 .2765723
1 221 | .0995483 .1078107 0.92 0.356 -.1117567 .3108534
1 222 | -.0080001 .1078108 -0.07 0.941 -.2193054 .2033051
1 223 | -.0880835 .1078116 -0.82 0.414 -.2993903 .1232234
1 224 | .0662453 .1078117 0.61 0.539 -.1450618 .2775524
1 225 | .1516961 .1078114 1.41 0.159 -.0596103 .3630024
1 226 | .0271292 .1078163 0.25 0.801 -.1841868 .2384453
1 227 | .0026281 .1078147 0.02 0.981 -.2086848 .213941
1 228 | .0153123 .1078157 0.14 0.887 -.1960025 .2266271
1 229 | -.0056001 .1078165 -0.05 0.959 -.2169166 .2057163
1 230 | .0797553 .1078141 0.74 0.459 -.1315564 .291067
1 231 | .1440652 .1078139 1.34 0.181 -.0672462 .3553765
1 232 | .1551572 .1078145 1.44 0.150 -.0561554 .3664698
1 233 | .0817475 .107813 0.76 0.448 -.129562 .293057
1 234 | .1802302 .1078134 1.67 0.095 -.0310803 .3915406
|
1.flag_priorityinters | 0 (omitted)
|
flag_priorityinters#quarterly |
1 211 | -.607943 .1841485 -3.30 0.001 -.9688675 -.2470185
1 212 | -.4059861 .1841506 -2.20 0.027 -.7669146 -.0450576
1 213 | -.0280808 .1841545 -0.15 0.879 -.389017 .3328553
1 214 | -.1385103 .1841488 -0.75 0.452 -.4994353 .2224147
1 215 | .1682274 .1841508 0.91 0.361 -.1927016 .5291563
1 216 | -.5344563 .1841548 -2.90 0.004 -.8953931 -.1735196
1 217 | -.4100439 .184154 -2.23 0.026 -.7709791 -.0491087
1 218 | -.7321311 .1841531 -3.98 0.000 -1.093065 -.3711977
1 219 | -.7875799 .1841572 -4.28 0.000 -1.148521 -.4266384
1 220 | -1.217937 .1841703 -6.61 0.000 -1.578905 -.8569703
1 221 | -.7616498 .1841502 -4.14 0.000 -1.122578 -.400722
1 222 | -.5073339 .1842095 -2.75 0.006 -.8683779 -.1462899
1 223 | -.5674953 .1842073 -3.08 0.002 -.9285349 -.2064557
1 224 | -.7095376 .1842039 -3.85 0.000 -1.070571 -.3485046
1 225 | -.8197211 .1842058 -4.45 0.000 -1.180758 -.4586843
1 226 | -1.319587 .1842442 -7.16 0.000 -1.680699 -.9584748
1 227 | -1.250575 .1843281 -6.78 0.000 -1.611852 -.8892987
1 228 | -1.16972 .1843132 -6.35 0.000 -1.530967 -.8084726
1 229 | -.4463609 .1843036 -2.42 0.015 -.8075894 -.0851325
1 230 | -1.28998 .1844274 -6.99 0.000 -1.651451 -.9285085
1 231 | -1.247094 .1844537 -6.76 0.000 -1.608617 -.8855714
1 232 | -1.350006 .1844509 -7.32 0.000 -1.711523 -.988489
1 233 | -1.142221 .1844469 -6.19 0.000 -1.503731 -.7807121
1 234 | -1.156946 .1844394 -6.27 0.000 -1.51844 -.7954509
|
1.flag_seniors | 0 (omitted)
|
flag_seniors#quarterly |
1 211 | .0469488 .052605 0.89 0.372 -.0561551 .1500527
1 212 | .0147038 .0526042 0.28 0.780 -.0883986 .1178062
1 213 | .0158899 .0526035 0.30 0.763 -.0872111 .1189909
1 214 | .0687254 .0526099 1.31 0.191 -.0343882 .171839
1 215 | .0494993 .0526071 0.94 0.347 -.0536086 .1526073
1 216 | .0644694 .0526066 1.23 0.220 -.0386375 .1675764
1 217 | .1110541 .052609 2.11 0.035 .0079424 .2141659
1 218 | .046441 .0526108 0.88 0.377 -.0566742 .1495563
1 219 | .0752526 .0526307 1.43 0.153 -.0279016 .1784068
1 220 | .040098 .0526312 0.76 0.446 -.0630572 .1432533
1 221 | .0560576 .052627 1.07 0.287 -.0470894 .1592046
1 222 | -.0018706 .052624 -0.04 0.972 -.1050118 .1012706
1 223 | .1175231 .052633 2.23 0.026 .0143644 .2206818
1 224 | .0715743 .0526342 1.36 0.174 -.0315868 .1747354
1 225 | .0455414 .0526339 0.87 0.387 -.0576191 .1487019
1 226 | .0324535 .0526872 0.62 0.538 -.0708115 .1357185
1 227 | .0546103 .0527314 1.04 0.300 -.0487414 .157962
1 228 | .004594 .0527601 0.09 0.931 -.0988139 .1080019
1 229 | .0701467 .052812 1.33 0.184 -.033363 .1736563
1 230 | .0966255 .052814 1.83 0.067 -.0068879 .200139
1 231 | .0749615 .0528217 1.42 0.156 -.028567 .17849
1 232 | .0307339 .0528206 0.58 0.561 -.0727927 .1342605
1 233 | .0277217 .0527728 0.53 0.599 -.0757111 .1311545
1 234 | -.0003138 .0527661 -0.01 0.995 -.1037335 .103106
------------------------------+----------------------------------------------------------------
W |
e.personsinjured | .0150479 .0071318 2.11 0.035 .0010698 .0290261
------------------------------+----------------------------------------------------------------
/sigma_e | .8656894 .0023889 .8610199 .8703841
-----------------------------------------------------------------------------------------------
Wald test of spatial terms: chi2(1) = 4.45 Prob > chi2 = 0.0349
spem_qt_results_xt.rtf
dir : seeout
[60]:
// Spatial Error Model collision_count
global outcome pedestriansinjured
spxtregress $outcome i.flag_LPIS $time_variant_var $time_var $time_trend, fe errorlag(W)
outreg2 using "$filename", word append ctitle(spxtregress fe $outcome)
(68400 observations)
(68400 observations used)
(data contain 2736 panels (places) )
(weighting matrix defines 2736 places)
Performing grid search ... finished
Optimizing concentrated log likelihood:
Iteration 0: log likelihood = -39361.9
Iteration 1: log likelihood = -39361.88
Iteration 2: log likelihood = -39361.88
Optimizing unconcentrated log likelihood:
Iteration 0: log likelihood = -39361.88
Iteration 1: log likelihood = -39361.88 (backed up)
Fixed-effects spatial regression Number of obs = 68,400
Group variable: _ID Number of groups = 2,736
Obs per group = 25
Wald chi2(100) = 1023.56
Prob > chi2 = 0.0000
Log likelihood = -3.936e+04 Pseudo R2 = 0.0000
-----------------------------------------------------------------------------------------------
pedestriansinjured | Coef. Std. Err. z P>|z| [95% Conf. Interval]
------------------------------+----------------------------------------------------------------
pedestriansinjured |
1.flag_LPIS | -.0389057 .0089396 -4.35 0.000 -.056427 -.0213843
bike_route_tv | -.0109777 .0121624 -0.90 0.367 -.0348155 .0128601
flag_street_improv | -.0457265 .0222275 -2.06 0.040 -.0892916 -.0021614
flag_left_turn | -.1676263 .024798 -6.76 0.000 -.2162295 -.1190231
|
quarterly |
211 | .0134697 .0143415 0.94 0.348 -.014639 .0415785
212 | .0205368 .0143414 1.43 0.152 -.0075718 .0486454
213 | .0208513 .0143422 1.45 0.146 -.0072589 .0489614
214 | .0011781 .0143427 0.08 0.935 -.0269331 .0292893
215 | .0199552 .0143452 1.39 0.164 -.008161 .0480714
216 | .0184234 .0143453 1.28 0.199 -.0096928 .0465396
217 | -.0105191 .0143478 -0.73 0.463 -.0386404 .0176021
218 | -.0355089 .0143488 -2.47 0.013 -.0636321 -.0073857
219 | .0159734 .0143493 1.11 0.266 -.0121507 .0440975
220 | -.0241884 .0143498 -1.69 0.092 -.0523134 .0039367
221 | -.0290267 .0143558 -2.02 0.043 -.0571636 -.0008898
222 | -.0232709 .0143678 -1.62 0.105 -.0514312 .0048894
223 | .0041098 .014372 0.29 0.775 -.0240588 .0322784
224 | -.0145964 .0143729 -1.02 0.310 -.0427668 .0135739
225 | -.0717736 .0143736 -4.99 0.000 -.0999453 -.0436018
226 | -.0811572 .0143851 -5.64 0.000 -.1093515 -.052963
227 | -.0701418 .0143879 -4.88 0.000 -.0983415 -.0419421
228 | -.0164937 .0143968 -1.15 0.252 -.0447109 .0117234
229 | -.0345624 .0144088 -2.40 0.016 -.0628032 -.0063216
230 | -.0753194 .0144115 -5.23 0.000 -.1035655 -.0470734
231 | -.0277225 .0144197 -1.92 0.055 -.0559845 .0005395
232 | -.0199827 .0144232 -1.39 0.166 -.0482516 .0082862
233 | -.0536797 .0144667 -3.71 0.000 -.0820338 -.0253256
234 | -.0611836 .0144959 -4.22 0.000 -.089595 -.0327722
|
1.flag_school | 0 (omitted)
|
flag_school#quarterly |
1 211 | .0636096 .0548249 1.16 0.246 -.0438452 .1710644
1 212 | .0766514 .0548277 1.40 0.162 -.0308089 .1841118
1 213 | .0009225 .0548265 0.02 0.987 -.1065355 .1083804
1 214 | .0046116 .0548251 0.08 0.933 -.1028435 .1120668
1 215 | .0453571 .0548252 0.83 0.408 -.0620983 .1528124
1 216 | .0034111 .0548251 0.06 0.950 -.1040441 .1108663
1 217 | .0214334 .0548264 0.39 0.696 -.0860244 .1288912
1 218 | .0356584 .0548259 0.65 0.515 -.0717985 .1431152
1 219 | .0598747 .0548252 1.09 0.275 -.0475808 .1673302
1 220 | .0473064 .054826 0.86 0.388 -.0601506 .1547635
1 221 | -.0279579 .0548275 -0.51 0.610 -.1354178 .0795019
1 222 | -.0240885 .0548252 -0.44 0.660 -.131544 .083367
1 223 | -.0364655 .0548265 -0.67 0.506 -.1439235 .0709926
1 224 | .0004518 .0548263 0.01 0.993 -.1070058 .1079095
1 225 | .0600818 .0548261 1.10 0.273 -.0473754 .1675389
1 226 | .0108312 .0548283 0.20 0.843 -.0966303 .1182926
1 227 | -.0090294 .0548289 -0.16 0.869 -.1164921 .0984332
1 228 | .0166874 .0548291 0.30 0.761 -.0907757 .1241505
1 229 | -.0151908 .0548264 -0.28 0.782 -.1226486 .092267
1 230 | .0818324 .0548265 1.49 0.136 -.0256255 .1892903
1 231 | .0235518 .0548268 0.43 0.668 -.0839067 .1310103
1 232 | .0326877 .0548279 0.60 0.551 -.074773 .1401483
1 233 | .0135814 .0548266 0.25 0.804 -.0938767 .1210394
1 234 | .0744866 .054826 1.36 0.174 -.0329704 .1819436
|
1.flag_priorityinters | 0 (omitted)
|
flag_priorityinters#quarterly |
1 211 | .0692576 .0937051 0.74 0.460 -.114401 .2529162
1 212 | .0313654 .0937085 0.33 0.738 -.1522999 .2150308
1 213 | -.058437 .0937079 -0.62 0.533 -.242101 .125227
1 214 | -.0405378 .0937057 -0.43 0.665 -.2241977 .1431221
1 215 | .3749076 .0937073 4.00 0.000 .1912447 .5585705
1 216 | -.0183066 .0937092 -0.20 0.845 -.2019733 .1653601
1 217 | -.2197672 .0937075 -2.35 0.019 -.4034306 -.0361039
1 218 | -.326203 .0937084 -3.48 0.000 -.5098682 -.1425379
1 219 | -.2873044 .0937093 -3.07 0.002 -.4709712 -.1036376
1 220 | -.2618763 .0937214 -2.79 0.005 -.4455668 -.0781858
1 221 | -.4103319 .0937072 -4.38 0.000 -.5939946 -.2266692
1 222 | -.3743244 .0937395 -3.99 0.000 -.5580505 -.1905983
1 223 | -.3129119 .0937395 -3.34 0.001 -.496638 -.1291858
1 224 | -.2917803 .0937412 -3.11 0.002 -.4755098 -.1080509
1 225 | -.3829675 .0937427 -4.09 0.000 -.5666998 -.1992353
1 226 | -.5879487 .0937625 -6.27 0.000 -.7717198 -.4041776
1 227 | -.4966465 .0938041 -5.29 0.000 -.6804992 -.3127938
1 228 | -.4705395 .0937921 -5.02 0.000 -.6543687 -.2867103
1 229 | -.3991966 .0937801 -4.26 0.000 -.5830021 -.2153911
1 230 | -.552082 .0938569 -5.88 0.000 -.7360381 -.3681258
1 231 | -.6507307 .0938653 -6.93 0.000 -.8347033 -.4667581
1 232 | -.5297783 .0938624 -5.64 0.000 -.7137453 -.3458112
1 233 | -.6249951 .0938618 -6.66 0.000 -.8089608 -.4410293
1 234 | -.436098 .0938543 -4.65 0.000 -.620049 -.252147
|
1.flag_seniors | 0 (omitted)
|
flag_seniors#quarterly |
1 211 | .008839 .0264617 0.33 0.738 -.043025 .0607029
1 212 | -.0291826 .0264617 -1.10 0.270 -.0810465 .0226813
1 213 | -.0179175 .0264619 -0.68 0.498 -.0697819 .0339469
1 214 | -.0140986 .0264641 -0.53 0.594 -.0659672 .03777
1 215 | .0103071 .0264631 0.39 0.697 -.0415596 .0621738
1 216 | .0035248 .026463 0.13 0.894 -.0483417 .0553913
1 217 | .0235076 .0264641 0.89 0.374 -.0283611 .0753764
1 218 | .016435 .0264663 0.62 0.535 -.035438 .068308
1 219 | .0099235 .0264758 0.37 0.708 -.041968 .0618151
1 220 | -.0092783 .0264755 -0.35 0.726 -.0611694 .0426128
1 221 | -.0045229 .0264729 -0.17 0.864 -.0564088 .0473629
1 222 | -.0289195 .0264722 -1.09 0.275 -.080804 .022965
1 223 | .0392967 .0264756 1.48 0.138 -.0125946 .091188
1 224 | .028405 .0264772 1.07 0.283 -.0234893 .0802993
1 225 | .0022866 .0264772 0.09 0.931 -.0496077 .0541808
1 226 | -.0033236 .0265047 -0.13 0.900 -.0552719 .0486246
1 227 | .023505 .0265283 0.89 0.376 -.0284894 .0754994
1 228 | -.0140253 .0265429 -0.53 0.597 -.0660484 .0379978
1 229 | .0254257 .0265692 0.96 0.339 -.026649 .0775004
1 230 | .026178 .0265706 0.99 0.325 -.0258994 .0782554
1 231 | .0041078 .0265737 0.15 0.877 -.0479757 .0561914
1 232 | .0154186 .0265738 0.58 0.562 -.036665 .0675023
1 233 | .0057029 .0265485 0.21 0.830 -.0463312 .0577369
1 234 | -.007904 .0265453 -0.30 0.766 -.0599319 .0441238
------------------------------+----------------------------------------------------------------
W |
e.pedestriansinjured | -.0014294 .0071792 -0.20 0.842 -.0155005 .0126416
------------------------------+----------------------------------------------------------------
/sigma_e | .4406542 .001216 .4382774 .4430439
-----------------------------------------------------------------------------------------------
Wald test of spatial terms: chi2(1) = 0.04 Prob > chi2 = 0.8422
spem_qt_results_xt.rtf
dir : seeout
[61]:
// Spatial Error Model collision_count
global outcome cyclistinjured
spxtregress $outcome i.flag_LPIS $time_variant_var $time_var $time_trend, fe errorlag(W)
outreg2 using "$filename", word append ctitle(spxtregress fe $outcome)
(68400 observations)
(68400 observations used)
(data contain 2736 panels (places) )
(weighting matrix defines 2736 places)
Performing grid search ... finished
Optimizing concentrated log likelihood:
Iteration 0: log likelihood = -9728.8655
Iteration 1: log likelihood = -9718.6889
Iteration 2: log likelihood = -9718.6886
Optimizing unconcentrated log likelihood:
Iteration 0: log likelihood = -9718.6886
Iteration 1: log likelihood = -9718.6886 (backed up)
Fixed-effects spatial regression Number of obs = 68,400
Group variable: _ID Number of groups = 2,736
Obs per group = 25
Wald chi2(100) = 630.35
Prob > chi2 = 0.0000
Log likelihood = -9718.6886 Pseudo R2 = 0.0035
-----------------------------------------------------------------------------------------------
cyclistinjured | Coef. Std. Err. z P>|z| [95% Conf. Interval]
------------------------------+----------------------------------------------------------------
cyclistinjured |
1.flag_LPIS | -.0167778 .0057214 -2.93 0.003 -.0279917 -.005564
bike_route_tv | .0030761 .0078113 0.39 0.694 -.0122337 .0183859
flag_street_improv | .0047863 .0142018 0.34 0.736 -.0230488 .0326214
flag_left_turn | -.0277437 .0157971 -1.76 0.079 -.0587054 .0032181
|
quarterly |
211 | -.0372621 .0093887 -3.97 0.000 -.0556637 -.0188605
212 | -.0441531 .0093887 -4.70 0.000 -.0625547 -.0257516
213 | -.0029174 .0093891 -0.31 0.756 -.0213197 .0154848
214 | .01085 .0093897 1.16 0.248 -.0075534 .0292534
215 | -.0178358 .0093911 -1.90 0.058 -.036242 .0005705
216 | -.0484062 .0093911 -5.15 0.000 -.0668124 -.03
217 | .0098849 .0093927 1.05 0.293 -.0085245 .0282942
218 | .0276423 .0093932 2.94 0.003 .0092319 .0460526
219 | -.0203962 .0093936 -2.17 0.030 -.0388074 -.001985
220 | -.0569642 .009394 -6.06 0.000 -.0753761 -.0385524
221 | -.0017146 .0093978 -0.18 0.855 -.020134 .0167049
222 | .0172415 .0094052 1.83 0.067 -.0011924 .0356754
223 | .009765 .0094079 1.04 0.299 -.0086743 .0282042
224 | -.0439322 .0094085 -4.67 0.000 -.0623725 -.025492
225 | -.0115463 .0094089 -1.23 0.220 -.0299875 .0068949
226 | -.0324375 .0094163 -3.44 0.001 -.0508931 -.0139818
227 | -.0470282 .0094179 -4.99 0.000 -.0654871 -.0285694
228 | -.051991 .0094235 -5.52 0.000 -.0704607 -.0335214
229 | -.0146981 .0094313 -1.56 0.119 -.0331831 .0037868
230 | -.0132917 .0094331 -1.41 0.159 -.0317801 .0051968
231 | -.032293 .0094381 -3.42 0.001 -.0507912 -.0137947
232 | -.0412975 .0094403 -4.37 0.000 -.0598001 -.0227949
233 | -.0146782 .0094676 -1.55 0.121 -.0332344 .003878
234 | .0062508 .0094859 0.66 0.510 -.0123413 .0248428
|
1.flag_school | 0 (omitted)
|
flag_school#quarterly |
1 211 | .0113533 .0349713 0.32 0.745 -.0571891 .0798957
1 212 | .0223227 .0349711 0.64 0.523 -.0462195 .0908649
1 213 | .0237172 .0349712 0.68 0.498 -.044825 .0922594
1 214 | .0439175 .0349717 1.26 0.209 -.0246258 .1124608
1 215 | .0105771 .0349711 0.30 0.762 -.057965 .0791193
1 216 | .003642 .0349712 0.10 0.917 -.0649002 .0721842
1 217 | -.0224042 .0349712 -0.64 0.522 -.0909466 .0461382
1 218 | -.0312872 .0349731 -0.89 0.371 -.0998332 .0372589
1 219 | .0084801 .0349718 0.24 0.808 -.0600634 .0770236
1 220 | .0414411 .0349711 1.19 0.236 -.027101 .1099832
1 221 | .0402696 .0349713 1.15 0.250 -.0282729 .1088121
1 222 | .0179871 .0349714 0.51 0.607 -.0505557 .0865298
1 223 | -.0213282 .0349731 -0.61 0.542 -.0898742 .0472178
1 224 | .0160555 .0349717 0.46 0.646 -.0524878 .0845987
1 225 | .0166441 .0349716 0.48 0.634 -.0518989 .0851872
1 226 | .0106306 .0349734 0.30 0.761 -.057916 .0791772
1 227 | .0206132 .0349727 0.59 0.556 -.047932 .0891585
1 228 | .0312296 .0349731 0.89 0.372 -.0373164 .0997756
1 229 | .0421736 .0349721 1.21 0.228 -.0263705 .1107177
1 230 | .0503953 .0349728 1.44 0.150 -.0181501 .1189408
1 231 | .033178 .0349733 0.95 0.343 -.0353684 .1017243
1 232 | .0053021 .0349722 0.15 0.879 -.0632422 .0738464
1 233 | .0327716 .0349724 0.94 0.349 -.035773 .1013162
1 234 | .0192257 .0349719 0.55 0.582 -.049318 .0877693
|
1.flag_priorityinters | 0 (omitted)
|
flag_priorityinters#quarterly |
1 211 | -.2177463 .0596952 -3.65 0.000 -.3347468 -.1007458
1 212 | -.0457007 .0596949 -0.77 0.444 -.1627005 .0712991
1 213 | -.1388376 .0597 -2.33 0.020 -.2558474 -.0218277
1 214 | .0726586 .0596955 1.22 0.224 -.0443424 .1896595
1 215 | -.138954 .0596958 -2.33 0.020 -.2559555 -.0219524
1 216 | -.1547799 .0596958 -2.59 0.010 -.2717815 -.0377783
1 217 | .0974372 .0596963 1.63 0.103 -.0195653 .2144397
1 218 | .0481861 .0596961 0.81 0.420 -.0688162 .1651884
1 219 | -.0902663 .0596973 -1.51 0.131 -.207271 .0267383
1 220 | -.160622 .0596972 -2.69 0.007 -.2776263 -.0436176
1 221 | -.1564524 .0596954 -2.62 0.009 -.2734532 -.0394515
1 222 | .0537376 .0597136 0.90 0.368 -.0632989 .1707741
1 223 | -.0020377 .0597156 -0.03 0.973 -.1190781 .1150028
1 224 | -.1316949 .0597127 -2.21 0.027 -.2487297 -.0146601
1 225 | -.0459411 .0597126 -0.77 0.442 -.1629757 .0710935
1 226 | -.0744525 .0597223 -1.25 0.213 -.1915061 .0426011
1 227 | -.1344819 .0597554 -2.25 0.024 -.2516003 -.0173635
1 228 | -.1870577 .0597498 -3.13 0.002 -.3041651 -.0699502
1 229 | -.0747729 .0597426 -1.25 0.211 -.1918662 .0423204
1 230 | -.1591242 .0597829 -2.66 0.008 -.2762966 -.0419518
1 231 | -.1392079 .0597931 -2.33 0.020 -.2564003 -.0220155
1 232 | -.1654014 .0597924 -2.77 0.006 -.2825924 -.0482105
1 233 | -.0893845 .0597881 -1.50 0.135 -.206567 .027798
1 234 | -.0614069 .0597916 -1.03 0.304 -.1785963 .0557825
|
1.flag_seniors | 0 (omitted)
|
flag_seniors#quarterly |
1 211 | .0232742 .0172572 1.35 0.177 -.0105494 .0570977
1 212 | .0020325 .0172575 0.12 0.906 -.0317915 .0358565
1 213 | .0099694 .0172574 0.58 0.563 -.0238546 .0437933
1 214 | .0058519 .0172591 0.34 0.735 -.0279753 .0396792
1 215 | .0057613 .0172582 0.33 0.739 -.0280642 .0395867
1 216 | .0085893 .0172581 0.50 0.619 -.025236 .0424146
1 217 | .0119056 .0172593 0.69 0.490 -.0219221 .0457333
1 218 | -.0194232 .0172591 -1.13 0.260 -.0532503 .0144039
1 219 | -.0021802 .0172666 -0.13 0.900 -.0360222 .0316617
1 220 | -.0135423 .0172662 -0.78 0.433 -.0473835 .0202989
1 221 | .0029342 .0172647 0.17 0.865 -.0309039 .0367724
1 222 | .0034272 .0172638 0.20 0.843 -.0304093 .0372637
1 223 | -.0108597 .0172661 -0.63 0.529 -.0447005 .0229812
1 224 | .0058899 .0172664 0.34 0.733 -.0279515 .0397314
1 225 | -.0099518 .017267 -0.58 0.564 -.0437946 .023891
1 226 | .0069833 .017284 0.40 0.686 -.0268928 .0408594
1 227 | .0265135 .0172983 1.53 0.125 -.0073906 .0604176
1 228 | .0149204 .0173077 0.86 0.389 -.0190022 .0488429
1 229 | .0187108 .0173238 1.08 0.280 -.0152433 .0526649
1 230 | .0135578 .0173244 0.78 0.434 -.0203974 .047513
1 231 | .0115019 .0173267 0.66 0.507 -.0224577 .0454615
1 232 | -.007012 .0173264 -0.40 0.686 -.0409711 .0269472
1 233 | .0099852 .0173113 0.58 0.564 -.0239443 .0439146
1 234 | .0079035 .0173094 0.46 0.648 -.0260224 .0418293
------------------------------+----------------------------------------------------------------
W |
e.cyclistinjured | .0319438 .0070671 4.52 0.000 .0180924 .0457952
------------------------------+----------------------------------------------------------------
/sigma_e | .2805486 .0007742 .2790352 .2820701
-----------------------------------------------------------------------------------------------
Wald test of spatial terms: chi2(1) = 20.43 Prob > chi2 = 0.0000
spem_qt_results_xt.rtf
dir : seeout
[62]:
// Spatial Error Model collision_count
global outcome motoristinjured
spxtregress $outcome i.flag_LPIS $time_variant_var $time_var $time_trend, fe errorlag(W)
outreg2 using "$filename", word append ctitle(spxtregress fe $outcome)
(68400 observations)
(68400 observations used)
(data contain 2736 panels (places) )
(weighting matrix defines 2736 places)
Performing grid search ... finished
Optimizing concentrated log likelihood:
Iteration 0: log likelihood = -67574.835
Iteration 1: log likelihood = -67573.218
Iteration 2: log likelihood = -67573.218
Optimizing unconcentrated log likelihood:
Iteration 0: log likelihood = -67573.218
Iteration 1: log likelihood = -67573.218 (backed up)
Fixed-effects spatial regression Number of obs = 68,400
Group variable: _ID Number of groups = 2,736
Obs per group = 25
Wald chi2(100) = 397.46
Prob > chi2 = 0.0000
Log likelihood = -6.757e+04 Pseudo R2 = 0.0001
-----------------------------------------------------------------------------------------------
motoristinjured | Coef. Std. Err. z P>|z| [95% Conf. Interval]
------------------------------+----------------------------------------------------------------
motoristinjured |
1.flag_LPIS | -.0089336 .0137685 -0.65 0.516 -.0359193 .0180522
bike_route_tv | .0359407 .0187587 1.92 0.055 -.0008256 .072707
flag_street_improv | -.0294274 .0342091 -0.86 0.390 -.096476 .0376213
flag_left_turn | -.0957196 .0381187 -2.51 0.012 -.1704308 -.0210083
|
quarterly |
211 | -.0582257 .0223005 -2.61 0.009 -.1019339 -.0145174
212 | -.0903529 .0223009 -4.05 0.000 -.1340618 -.0466439
213 | -.0473122 .0223016 -2.12 0.034 -.0910225 -.003602
214 | -.0374714 .0223026 -1.68 0.093 -.0811838 .006241
215 | -.0806799 .0223069 -3.62 0.000 -.1244007 -.0369591
216 | -.1201995 .0223063 -5.39 0.000 -.163919 -.07648
217 | -.0716411 .0223101 -3.21 0.001 -.115368 -.0279142
218 | -.0736918 .0223114 -3.30 0.001 -.1174214 -.0299623
219 | -.1087433 .0223124 -4.87 0.000 -.1524749 -.0650117
220 | -.1333949 .0223134 -5.98 0.000 -.1771283 -.0896616
221 | -.0976624 .0223225 -4.38 0.000 -.1414136 -.0539112
222 | -.086705 .0223406 -3.88 0.000 -.1304919 -.0429182
223 | -.1065628 .0223476 -4.77 0.000 -.1503633 -.0627624
224 | -.1160991 .0223486 -5.19 0.000 -.1599015 -.0722967
225 | -.1264147 .0223497 -5.66 0.000 -.1702193 -.0826101
226 | -.1661544 .0223675 -7.43 0.000 -.209994 -.1223149
227 | -.1521838 .0223712 -6.80 0.000 -.1960306 -.108337
228 | -.1285954 .0223846 -5.74 0.000 -.1724684 -.0847224
229 | -.0902444 .0224033 -4.03 0.000 -.134154 -.0463348
230 | -.1049271 .0224076 -4.68 0.000 -.1488452 -.061009
231 | -.1196456 .02242 -5.34 0.000 -.163588 -.0757032
232 | -.1342603 .0224253 -5.99 0.000 -.1782132 -.0903075
233 | -.0842764 .0224926 -3.75 0.000 -.1283612 -.0401916
234 | -.0785006 .0225363 -3.48 0.000 -.122671 -.0343302
|
1.flag_school | 0 (omitted)
|
flag_school#quarterly |
1 211 | .022845 .0843183 0.27 0.786 -.1424158 .1881058
1 212 | .0228159 .084319 0.27 0.787 -.1424463 .1880781
1 213 | .0510608 .0843183 0.61 0.545 -.1142001 .2163217
1 214 | .0506013 .0843185 0.60 0.548 -.11466 .2158625
1 215 | .0628944 .0843184 0.75 0.456 -.1023667 .2281555
1 216 | -.0321104 .0843184 -0.38 0.703 -.1973715 .1331507
1 217 | -.0735526 .08432 -0.87 0.383 -.2388168 .0917117
1 218 | -.0024092 .0843183 -0.03 0.977 -.1676701 .1628517
1 219 | .1571998 .0843181 1.86 0.062 -.0080606 .3224602
1 220 | -.0244042 .0843181 -0.29 0.772 -.1896647 .1408563
1 221 | .0863367 .0843185 1.02 0.306 -.0789245 .2515979
1 222 | -.0021073 .0843189 -0.02 0.980 -.1673694 .1631548
1 223 | -.0317738 .0843198 -0.38 0.706 -.1970376 .13349
1 224 | .0600096 .084321 0.71 0.477 -.1052565 .2252758
1 225 | .0798471 .0843193 0.95 0.344 -.0854157 .2451099
1 226 | -.0022953 .0843235 -0.03 0.978 -.1675663 .1629758
1 227 | -.0255189 .0843225 -0.30 0.762 -.1907879 .1397502
1 228 | -.0417537 .0843226 -0.50 0.620 -.207023 .1235156
1 229 | -.032602 .084326 -0.39 0.699 -.197878 .132674
1 230 | -.0552958 .0843217 -0.66 0.512 -.2205632 .1099717
1 231 | .0858865 .0843215 1.02 0.308 -.0793806 .2511536
1 232 | .116202 .0843212 1.38 0.168 -.0490644 .2814685
1 233 | .0377733 .0843204 0.45 0.654 -.1274916 .2030383
1 234 | .0807853 .0843227 0.96 0.338 -.084484 .2460547
|
1.flag_priorityinters | 0 (omitted)
|
flag_priorityinters#quarterly |
1 211 | -.4598878 .1440345 -3.19 0.001 -.7421903 -.1775853
1 212 | -.3930008 .1440344 -2.73 0.006 -.675303 -.1106986
1 213 | .168955 .1440345 1.17 0.241 -.1133475 .4512575
1 214 | -.17151 .1440353 -1.19 0.234 -.453814 .1107941
1 215 | -.0680448 .1440362 -0.47 0.637 -.3503506 .2142611
1 216 | -.3632487 .1440383 -2.52 0.012 -.6455586 -.0809387
1 217 | -.2874322 .1440384 -2.00 0.046 -.5697424 -.0051221
1 218 | -.4550864 .1440382 -3.16 0.002 -.7373961 -.1727766
1 219 | -.4102165 .1440442 -2.85 0.004 -.6925379 -.1278951
1 220 | -.7986583 .1440421 -5.54 0.000 -1.080976 -.516341
1 221 | -.1958953 .1440363 -1.36 0.174 -.4782012 .0864106
1 222 | -.1882845 .1440783 -1.31 0.191 -.4706728 .0941037
1 223 | -.25618 .1440801 -1.78 0.075 -.5385717 .0262117
1 224 | -.277126 .1440781 -1.92 0.054 -.5595139 .0052619
1 225 | -.388473 .1440772 -2.70 0.007 -.6708592 -.1060869
1 226 | -.6454005 .1441 -4.48 0.000 -.9278314 -.3629696
1 227 | -.5728437 .1441742 -3.97 0.000 -.85542 -.2902674
1 228 | -.3714653 .144162 -2.58 0.010 -.6540177 -.0889129
1 229 | .0267384 .1441632 0.19 0.853 -.2558164 .3092931
1 230 | -.5388861 .1442466 -3.74 0.000 -.8216043 -.2561678
1 231 | -.4599372 .1442715 -3.19 0.001 -.7427042 -.1771703
1 232 | -.6558575 .1442699 -4.55 0.000 -.9386214 -.3730936
1 233 | -.4513243 .1442614 -3.13 0.002 -.7340714 -.1685772
1 234 | -.6798427 .1442618 -4.71 0.000 -.9625905 -.3970948
|
1.flag_seniors | 0 (omitted)
|
flag_seniors#quarterly |
1 211 | .0148926 .0410835 0.36 0.717 -.0656296 .0954147
1 212 | .0414426 .0410829 1.01 0.313 -.0390783 .1219636
1 213 | .0243211 .0410817 0.59 0.554 -.0561977 .1048398
1 214 | .0769656 .0410859 1.87 0.061 -.0035613 .1574925
1 215 | .032971 .0410845 0.80 0.422 -.0475532 .1134952
1 216 | .0521145 .0410842 1.27 0.205 -.0284089 .132638
1 217 | .0753795 .0410853 1.83 0.067 -.0051462 .1559052
1 218 | .0485854 .041086 1.18 0.237 -.0319417 .1291125
1 219 | .0666732 .0411027 1.62 0.105 -.0138866 .147233
1 220 | .0625486 .0411036 1.52 0.128 -.0180129 .1431102
1 221 | .0577046 .0410999 1.40 0.160 -.0228497 .1382589
1 222 | .023628 .0410977 0.57 0.565 -.0569221 .1041781
1 223 | .0887424 .0411045 2.16 0.031 .0081791 .1693056
1 224 | .0390076 .0411043 0.95 0.343 -.0415553 .1195705
1 225 | .0625524 .0411054 1.52 0.128 -.0180127 .1431176
1 226 | .0410135 .0411474 1.00 0.319 -.0396339 .121661
1 227 | .0202028 .0411817 0.49 0.624 -.0605119 .1009175
1 228 | .0132333 .0412044 0.32 0.748 -.0675259 .0939924
1 229 | .0257813 .0412451 0.63 0.532 -.0550575 .1066202
1 230 | .061307 .0412462 1.49 0.137 -.0195342 .1421481
1 231 | .0587323 .0412519 1.42 0.155 -.0221201 .1395846
1 232 | .0228777 .0412512 0.55 0.579 -.0579731 .1037285
1 233 | .0095337 .0412147 0.23 0.817 -.0712456 .090313
1 234 | .0024558 .0412089 0.06 0.952 -.0783121 .0832237
------------------------------+----------------------------------------------------------------
W |
e.motoristinjured | .0128532 .0071423 1.80 0.072 -.0011455 .0268519
------------------------------+----------------------------------------------------------------
/sigma_e | .6771414 .0018686 .6734889 .6808136
-----------------------------------------------------------------------------------------------
Wald test of spatial terms: chi2(1) = 3.24 Prob > chi2 = 0.0719
spem_qt_results_xt.rtf
dir : seeout
[ ]:
[ ]:
Spatial Lag and Error Model¶
[63]:
spxtregress collision_count i.flag_LPIS $time_variant_var $time_var $time_trend, fe dvarlag(W) errorlag(W)
(68400 observations)
(68400 observations used)
(data contain 2736 panels (places) )
(weighting matrix defines 2736 places)
Performing grid search ... finished
Optimizing concentrated log likelihood:
Iteration 0: log likelihood = -133586.36
Iteration 1: log likelihood = -133573.19
Iteration 2: log likelihood = -133572.65
Iteration 3: log likelihood = -133572.65
Optimizing unconcentrated log likelihood:
Iteration 0: log likelihood = -133572.65
Iteration 1: log likelihood = -133572.65 (backed up)
Fixed-effects spatial regression Number of obs = 68,400
Group variable: _ID Number of groups = 2,736
Obs per group = 25
Wald chi2(101) = 25284.33
Prob > chi2 = 0.0000
Log likelihood = -1.336e+05 Pseudo R2 = 0.0027
-----------------------------------------------------------------------------------------------
collision_count | Coef. Std. Err. z P>|z| [95% Conf. Interval]
------------------------------+----------------------------------------------------------------
collision_count |
1.flag_LPIS | -.0516921 .030707 -1.68 0.092 -.1118767 .0084925
bike_route_tv | .1147776 .0394251 2.91 0.004 .0375057 .1920495
flag_street_improv | -.3318003 .0787364 -4.21 0.000 -.4861209 -.1774798
flag_left_turn | -.885839 .0930796 -9.52 0.000 -1.068272 -.7034063
|
quarterly |
211 | -.1174941 .0368295 -3.19 0.001 -.1896786 -.0453095
212 | -.167079 .036935 -4.52 0.000 -.2394703 -.0946878
213 | .0094998 .0367686 0.26 0.796 -.0625655 .081565
214 | -.0231315 .0367755 -0.63 0.529 -.0952102 .0489471
215 | -.042171 .0367927 -1.15 0.252 -.1142835 .0299414
216 | -.1738485 .0369869 -4.70 0.000 -.2463414 -.1013555
217 | -.0029465 .0367995 -0.08 0.936 -.0750722 .0691792
218 | -.0117604 .0368056 -0.32 0.749 -.0838982 .0603773
219 | -.0457019 .0368146 -1.24 0.214 -.1178572 .0264535
220 | -.1891872 .0370451 -5.11 0.000 -.2617943 -.1165801
221 | .0199443 .0368273 0.54 0.588 -.0522358 .0921245
222 | .002976 .0368807 0.08 0.936 -.0693089 .0752608
223 | .0290764 .0369011 0.79 0.431 -.0432485 .1014013
224 | -.1222348 .0370164 -3.30 0.001 -.1947855 -.0496841
225 | -.2528537 .0373424 -6.77 0.000 -.3260435 -.179664
226 | -.475929 .038486 -12.37 0.000 -.5513601 -.4004979
227 | -.4794731 .0385444 -12.44 0.000 -.5550187 -.4039275
228 | -.3974049 .0381504 -10.42 0.000 -.4721784 -.3226314
229 | -.225335 .0374606 -6.02 0.000 -.2987563 -.1519136
230 | -.3710734 .0380611 -9.75 0.000 -.4456719 -.296475
231 | -.3266014 .0379435 -8.61 0.000 -.4009693 -.2522335
232 | -.323758 .0379972 -8.52 0.000 -.3982312 -.2492848
233 | -.2146279 .0377667 -5.68 0.000 -.2886493 -.1406064
234 | -.2856686 .0381463 -7.49 0.000 -.3604339 -.2109034
|
1.flag_school | 0 (omitted)
|
flag_school#quarterly |
1 211 | .3082438 .2000799 1.54 0.123 -.0839056 .7003932
1 212 | .2560657 .2000946 1.28 0.201 -.1361125 .648244
1 213 | .1963802 .20008 0.98 0.326 -.1957694 .5885297
1 214 | .0579097 .200079 0.29 0.772 -.3342379 .4500572
1 215 | -.017428 .2000811 -0.09 0.931 -.4095798 .3747239
1 216 | .1088057 .2000871 0.54 0.587 -.2833578 .5009692
1 217 | .1199953 .2000895 0.60 0.549 -.272173 .5121635
1 218 | .0506867 .2000799 0.25 0.800 -.3414626 .4428361
1 219 | .3876644 .2000991 1.94 0.053 -.0045225 .7798514
1 220 | .4145231 .2000998 2.07 0.038 .0223347 .8067115
1 221 | .0004567 .2000799 0.00 0.998 -.3916927 .3926062
1 222 | .1223798 .2000797 0.61 0.541 -.2697691 .5145287
1 223 | .130693 .2000813 0.65 0.514 -.2614591 .5228451
1 224 | .088307 .2000798 0.44 0.659 -.3038422 .4804563
1 225 | .4424421 .200091 2.21 0.027 .0502708 .8346133
1 226 | .1797586 .2001171 0.90 0.369 -.2124638 .571981
1 227 | .2307662 .2001157 1.15 0.249 -.1614535 .6229858
1 228 | .2409313 .2001297 1.20 0.229 -.1513157 .6331782
1 229 | .4239813 .2001135 2.12 0.034 .031766 .8161966
1 230 | .392668 .2001201 1.96 0.050 .0004398 .7848961
1 231 | .4898955 .2001266 2.45 0.014 .0976546 .8821363
1 232 | .3935846 .2001517 1.97 0.049 .0012945 .7858747
1 233 | .1801852 .2001139 0.90 0.368 -.2120308 .5724012
1 234 | .4588124 .2001276 2.29 0.022 .0665695 .8510553
|
1.flag_priorityinters | 0 (omitted)
|
flag_priorityinters#quarterly |
1 211 | -.5751033 .3507834 -1.64 0.101 -1.262626 .1124196
1 212 | -1.233083 .3508368 -3.51 0.000 -1.920711 -.5454558
1 213 | -.6424402 .3507673 -1.83 0.067 -1.329931 .0450511
1 214 | -.2912092 .3507497 -0.83 0.406 -.978666 .3962476
1 215 | .0613562 .3507522 0.17 0.861 -.6261055 .7488178
1 216 | -1.590457 .350877 -4.53 0.000 -2.278163 -.9027508
1 217 | -.8683592 .3508048 -2.48 0.013 -1.555924 -.1807944
1 218 | -.6218693 .3507891 -1.77 0.076 -1.309403 .0656647
1 219 | -1.090065 .3508914 -3.11 0.002 -1.7778 -.4023306
1 220 | -2.216844 .3510001 -6.32 0.000 -2.904792 -1.528897
1 221 | -1.33025 .3508095 -3.79 0.000 -2.017824 -.6426758
1 222 | .2779453 .3508926 0.79 0.428 -.4097916 .9656821
1 223 | -.8906082 .3509542 -2.54 0.011 -1.578466 -.2027507
1 224 | -1.387796 .3509645 -3.95 0.000 -2.075674 -.699918
1 225 | -2.312902 .3511203 -6.59 0.000 -3.001085 -1.624719
1 226 | -3.407367 .3515288 -9.69 0.000 -4.096351 -2.718383
1 227 | -3.840309 .3518799 -10.91 0.000 -4.529981 -3.150637
1 228 | -3.441195 .3516134 -9.79 0.000 -4.130345 -2.752046
1 229 | -3.227735 .3516662 -9.18 0.000 -3.916988 -2.538482
1 230 | -3.571693 .3518512 -10.15 0.000 -4.261308 -2.882077
1 231 | -3.725028 .3520448 -10.58 0.000 -4.415023 -3.035033
1 232 | -3.305301 .3517851 -9.40 0.000 -3.994787 -2.615815
1 233 | -3.156746 .3517703 -8.97 0.000 -3.846203 -2.467289
1 234 | -3.308564 .3519005 -9.40 0.000 -3.998276 -2.618851
|
1.flag_seniors | 0 (omitted)
|
flag_seniors#quarterly |
1 211 | .1141962 .0698097 1.64 0.102 -.0226284 .2510208
1 212 | .0073476 .0697722 0.11 0.916 -.1294033 .1440986
1 213 | .0438778 .0697772 0.63 0.529 -.092883 .1806387
1 214 | .0745046 .0697909 1.07 0.286 -.062283 .2112922
1 215 | .1179637 .0698098 1.69 0.091 -.018861 .2547884
1 216 | .0838082 .0697935 1.20 0.230 -.0529845 .220601
1 217 | .0998681 .0698068 1.43 0.153 -.0369508 .2366869
1 218 | -.0340714 .0697844 -0.49 0.625 -.1708464 .1027036
1 219 | .0619339 .0698315 0.89 0.375 -.0749334 .1988012
1 220 | .0010767 .0698198 0.02 0.988 -.1357676 .1379211
1 221 | .0960844 .0698402 1.38 0.169 -.0408 .2329687
1 222 | .053589 .069825 0.77 0.443 -.0832655 .1904435
1 223 | .1113778 .069854 1.59 0.111 -.0255336 .2482891
1 224 | -.0066082 .06983 -0.09 0.925 -.1434724 .130256
1 225 | -.1474223 .0698727 -2.11 0.035 -.2843703 -.0104742
1 226 | -.0946805 .069992 -1.35 0.176 -.2318622 .0425013
1 227 | -.0598291 .0700701 -0.85 0.393 -.197164 .0775057
1 228 | -.0391855 .0701353 -0.56 0.576 -.1766482 .0982773
1 229 | -.0156615 .0703157 -0.22 0.824 -.1534777 .1221548
1 230 | .0278731 .0703254 0.40 0.692 -.1099621 .1657084
1 231 | -.0063968 .0703394 -0.09 0.928 -.1442595 .1314658
1 232 | -.1512687 .0703822 -2.15 0.032 -.2892153 -.013322
1 233 | -.0494111 .0701925 -0.70 0.481 -.1869859 .0881637
1 234 | -.1591636 .0702044 -2.27 0.023 -.2967616 -.0215655
------------------------------+----------------------------------------------------------------
W |
collision_count | .6437354 .0081489 79.00 0.000 .6277639 .6597069
e.collision_count | -.654983 .0145243 -45.10 0.000 -.6834502 -.6265159
------------------------------+----------------------------------------------------------------
/sigma_e | 1.72776 .0062935 1.715469 1.740139
-----------------------------------------------------------------------------------------------
Wald test of spatial terms: chi2(2) = 7949.75 Prob > chi2 = 0.0000
[64]:
estat impact
progress : 9% 18% 27% 36% 45% 55% 64% 73% 82% 91% 100%
Average impacts Number of obs = 68,400
-------------------------------------------------------------------------------------
| Delta-Method
| dy/dx Std. Err. z P>|z| [95% Conf. Interval]
--------------------+----------------------------------------------------------------
direct |
flag_LPIS |
1 | -.0565016 .0335629 -1.68 0.092 -.1222836 .0092805
|
bike_route_tv | .1254566 .043077 2.91 0.004 .0410273 .2098859
flag_street_improv | -.3626713 .0860279 -4.22 0.000 -.531283 -.1940597
flag_left_turn | -.9682582 .1016223 -9.53 0.000 -1.167434 -.7690822
|
flag_school |
1 | .2473642 .1515252 1.63 0.103 -.0496197 .5443482
|
flag_priorityinters |
1 | -1.997887 .2657963 -7.52 0.000 -2.518839 -1.476936
|
flag_seniors |
1 | .0056752 .0529768 0.11 0.915 -.0981575 .1095078
--------------------+----------------------------------------------------------------
indirect |
flag_LPIS |
1 | -.0768607 .0457071 -1.68 0.093 -.166445 .0127236
|
bike_route_tv | .1706622 .0586265 2.91 0.004 .0557564 .2855681
flag_street_improv | -.4933523 .1176155 -4.19 0.000 -.7238743 -.2628302
flag_left_turn | -1.31715 .1429579 -9.21 0.000 -1.597342 -1.036957
|
flag_school |
1 | .3364967 .2062843 1.63 0.103 -.0678131 .7408066
|
flag_priorityinters |
1 | -2.717784 .3691573 -7.36 0.000 -3.441319 -1.994249
|
flag_seniors |
1 | .0077201 .072065 0.11 0.915 -.1335246 .1489649
--------------------+----------------------------------------------------------------
total |
flag_LPIS |
1 | -.1333623 .0792444 -1.68 0.092 -.2886785 .0219539
|
bike_route_tv | .2961188 .1016051 2.91 0.004 .0969765 .4952611
flag_street_improv | -.8560236 .2032332 -4.21 0.000 -1.254353 -.4576939
flag_left_turn | -2.285408 .2421658 -9.44 0.000 -2.760044 -1.810772
|
flag_school |
1 | .583861 .3577009 1.63 0.103 -.1172198 1.284942
|
flag_priorityinters |
1 | -4.715671 .6309795 -7.47 0.000 -5.952368 -3.478974
|
flag_seniors |
1 | .0133953 .1250416 0.11 0.915 -.2316818 .2584723
-------------------------------------------------------------------------------------
[65]:
spxtregress personsinjured i.flag_LPIS $time_variant_var $time_var $time_trend, fe dvarlag(W) errorlag(W)
(68400 observations)
(68400 observations used)
(data contain 2736 panels (places) )
(weighting matrix defines 2736 places)
Performing grid search ... finished
Optimizing concentrated log likelihood:
Iteration 0: log likelihood = -83695.412
Iteration 1: log likelihood = -83695.244
Iteration 2: log likelihood = -83695.24
Optimizing unconcentrated log likelihood:
Iteration 0: log likelihood = -83695.24
Iteration 1: log likelihood = -83695.24 (backed up)
Fixed-effects spatial regression Number of obs = 68,400
Group variable: _ID Number of groups = 2,736
Obs per group = 25
Wald chi2(101) = 1433.50
Prob > chi2 = 0.0000
Log likelihood = -8.370e+04 Pseudo R2 = 0.0009
-----------------------------------------------------------------------------------------------
personsinjured | Coef. Std. Err. z P>|z| [95% Conf. Interval]
------------------------------+----------------------------------------------------------------
personsinjured |
1.flag_LPIS | -.0613041 .0167868 -3.65 0.000 -.0942055 -.0284026
bike_route_tv | .0285043 .0223226 1.28 0.202 -.0152471 .0722558
flag_street_improv | -.068704 .0421651 -1.63 0.103 -.151346 .0139381
flag_left_turn | -.2950874 .0479824 -6.15 0.000 -.3891313 -.2010436
|
quarterly |
211 | -.0640118 .0238783 -2.68 0.007 -.1108123 -.0172113
212 | -.0887109 .0240296 -3.69 0.000 -.1358081 -.0416138
213 | -.0231208 .0237407 -0.97 0.330 -.0696518 .0234101
214 | -.0199008 .0237384 -0.84 0.402 -.0664271 .0266256
215 | -.0627195 .0238529 -2.63 0.009 -.1094704 -.0159685
216 | -.117352 .0242625 -4.84 0.000 -.1649056 -.0697984
217 | -.0568867 .0238599 -2.38 0.017 -.1036513 -.0101221
218 | -.0619741 .0239235 -2.59 0.010 -.1088633 -.0150849
219 | -.0896769 .0240187 -3.73 0.000 -.1367527 -.042601
220 | -.1669259 .0248559 -6.72 0.000 -.2156426 -.1182092
221 | -.1001194 .024146 -4.15 0.000 -.1474447 -.0527942
222 | -.0711046 .024003 -2.96 0.003 -.1181496 -.0240596
223 | -.070535 .0240206 -2.94 0.003 -.1176146 -.0234555
224 | -.1271362 .0244294 -5.20 0.000 -.1750169 -.0792556
225 | -.1580904 .0247022 -6.40 0.000 -.2065058 -.109675
226 | -.2196987 .0257222 -8.54 0.000 -.2701132 -.1692842
227 | -.217964 .0256547 -8.50 0.000 -.2682462 -.1676818
228 | -.1781082 .0251571 -7.08 0.000 -.2274151 -.1288012
229 | -.1096386 .0242992 -4.51 0.000 -.1572642 -.062013
230 | -.1507708 .0247776 -6.08 0.000 -.199334 -.1022076
231 | -.1411771 .0246769 -5.72 0.000 -.1895429 -.0928113
232 | -.149971 .0248855 -6.03 0.000 -.1987456 -.1011964
233 | -.1129888 .0246788 -4.58 0.000 -.1613584 -.0646192
234 | -.0990262 .0245495 -4.03 0.000 -.1471425 -.05091
|
1.flag_school | 0 (omitted)
|
flag_school#quarterly |
1 211 | .095559 .10512 0.91 0.363 -.1104725 .3015905
1 212 | .1153178 .1051308 1.10 0.273 -.0907349 .3213704
1 213 | .0698457 .1051253 0.66 0.506 -.1361962 .2758875
1 214 | .1017035 .105119 0.97 0.333 -.104326 .307733
1 215 | .1126579 .1051265 1.07 0.284 -.0933862 .3187021
1 216 | -.0226358 .1051206 -0.22 0.830 -.2286683 .1833967
1 217 | -.0875913 .1051403 -0.83 0.405 -.2936625 .1184799
1 218 | .0016149 .1051197 0.02 0.988 -.2044159 .2076456
1 219 | .2124702 .1051489 2.02 0.043 .0063821 .4185584
1 220 | .0604112 .1051222 0.57 0.566 -.1456246 .266447
1 221 | .0911328 .1051281 0.87 0.386 -.1149144 .29718
1 222 | -.0033917 .1051212 -0.03 0.974 -.2094255 .2026421
1 223 | -.0801459 .1051304 -0.76 0.446 -.2861977 .1259058
1 224 | .0700816 .1051208 0.67 0.505 -.1359513 .2761145
1 225 | .1447908 .1051319 1.38 0.168 -.0612639 .3508456
1 226 | .0247635 .1051265 0.24 0.814 -.1812806 .2308076
1 227 | .0034206 .1051238 0.03 0.974 -.2026184 .2094595
1 228 | .011625 .1051278 0.11 0.912 -.1944217 .2176717
1 229 | .0099576 .1051515 0.09 0.925 -.1961356 .2160508
1 230 | .0875739 .1051264 0.83 0.405 -.11847 .2936179
1 231 | .1481213 .1051232 1.41 0.159 -.0579165 .3541591
1 232 | .1421223 .1051528 1.35 0.177 -.0639733 .348218
1 233 | .0767252 .1051266 0.73 0.465 -.1293192 .2827696
1 234 | .1840054 .105122 1.75 0.080 -.0220301 .3900408
|
1.flag_priorityinters | 0 (omitted)
|
flag_priorityinters#quarterly |
1 211 | -.5849193 .1813037 -3.23 0.001 -.940268 -.2295706
1 212 | -.4141957 .1812211 -2.29 0.022 -.7693825 -.0590088
1 213 | -.0034981 .181262 -0.02 0.985 -.3587651 .351769
1 214 | -.1374249 .1812201 -0.76 0.448 -.4926098 .2177599
1 215 | .1575023 .1812325 0.87 0.385 -.1977068 .5127114
1 216 | -.542192 .1812249 -2.99 0.003 -.8973863 -.1869977
1 217 | -.3879158 .1812818 -2.14 0.032 -.7432217 -.03261
1 218 | -.7251517 .1812512 -4.00 0.000 -1.080398 -.3699058
1 219 | -.7833765 .1812484 -4.32 0.000 -1.138617 -.4281363
1 220 | -1.229507 .1812454 -6.78 0.000 -1.584741 -.8742723
1 221 | -.7510325 .181258 -4.14 0.000 -1.106292 -.3957733
1 222 | -.5198371 .1812817 -2.87 0.004 -.8751428 -.1645314
1 223 | -.5687168 .1812857 -3.14 0.002 -.9240302 -.2134034
1 224 | -.6983981 .1813247 -3.85 0.000 -1.053788 -.3430081
1 225 | -.8186528 .1813033 -4.52 0.000 -1.174001 -.4633048
1 226 | -1.325291 .1813409 -7.31 0.000 -1.680713 -.9698695
1 227 | -1.234969 .1815176 -6.80 0.000 -1.590737 -.8792009
1 228 | -1.163813 .1814368 -6.41 0.000 -1.519422 -.8082032
1 229 | -.4046277 .1815435 -2.23 0.026 -.7604464 -.048809
1 230 | -1.289478 .1815388 -7.10 0.000 -1.645287 -.9336681
1 231 | -1.234344 .1816204 -6.80 0.000 -1.590314 -.8783745
1 232 | -1.33531 .1816224 -7.35 0.000 -1.691283 -.9793363
1 233 | -1.151573 .181514 -6.34 0.000 -1.507334 -.7958124
1 234 | -1.142515 .181606 -6.29 0.000 -1.498456 -.7865738
|
1.flag_seniors | 0 (omitted)
|
flag_seniors#quarterly |
1 211 | .0354279 .0445563 0.80 0.427 -.0519009 .1227567
1 212 | .0099189 .0445316 0.22 0.824 -.0773614 .0971991
1 213 | .0114866 .0445317 0.26 0.796 -.0757939 .098767
1 214 | .0526222 .0445891 1.18 0.238 -.0347709 .1400153
1 215 | .0376773 .0445627 0.85 0.398 -.049664 .1250187
1 216 | .0521904 .044572 1.17 0.242 -.0351691 .1395499
1 217 | .096179 .0446128 2.16 0.031 .0087394 .1836186
1 218 | .0353396 .0445595 0.79 0.428 -.0519955 .1226746
1 219 | .0623594 .0446021 1.40 0.162 -.025059 .1497778
1 220 | .0326687 .0445695 0.73 0.464 -.054686 .1200234
1 221 | .0430863 .044589 0.97 0.334 -.0443065 .130479
1 222 | -.0014341 .044548 -0.03 0.974 -.0887466 .0858784
1 223 | .0937692 .0446998 2.10 0.036 .0061592 .1813791
1 224 | .0546061 .044629 1.22 0.221 -.0328651 .1420774
1 225 | .039451 .0445714 0.89 0.376 -.0479072 .1268093
1 226 | .0283396 .0446264 0.64 0.525 -.0591265 .1158057
1 227 | .0491418 .0446799 1.10 0.271 -.0384292 .1367127
1 228 | .0071739 .0446977 0.16 0.872 -.080432 .0947797
1 229 | .0600659 .044799 1.34 0.180 -.0277385 .1478704
1 230 | .0852189 .0448203 1.90 0.057 -.0026272 .173065
1 231 | .0689439 .0448014 1.54 0.124 -.0188652 .1567531
1 232 | .0317509 .0447784 0.71 0.478 -.056013 .1195149
1 233 | .0229691 .0447233 0.51 0.608 -.0646869 .1106251
1 234 | .0004668 .0447088 0.01 0.992 -.0871609 .0880944
------------------------------+----------------------------------------------------------------
W |
personsinjured | .2190278 .0336343 6.51 0.000 .1531057 .2849498
e.personsinjured | -.2199309 .0390275 -5.64 0.000 -.2964234 -.1434385
------------------------------+----------------------------------------------------------------
/sigma_e | .8593726 .0031355 .8532491 .8655401
-----------------------------------------------------------------------------------------------
Wald test of spatial terms: chi2(2) = 57.46 Prob > chi2 = 0.0000
[66]:
estat impact
progress : 9% 18% 27% 36% 45% 55% 64% 73% 82% 91% 100%
Average impacts Number of obs = 68,400
-------------------------------------------------------------------------------------
| Delta-Method
| dy/dx Std. Err. z P>|z| [95% Conf. Interval]
--------------------+----------------------------------------------------------------
direct |
flag_LPIS |
1 | -.0617799 .0169117 -3.65 0.000 -.0949263 -.0286336
|
bike_route_tv | .0287256 .0224962 1.28 0.202 -.0153661 .0728173
flag_street_improv | -.0692373 .0424901 -1.63 0.103 -.1525163 .0140417
flag_left_turn | -.2973781 .048358 -6.15 0.000 -.3921581 -.2025981
|
flag_school |
1 | .063293 .0733947 0.86 0.388 -.080558 .2071439
|
flag_priorityinters |
1 | -.7372484 .1265863 -5.82 0.000 -.9853529 -.4891438
|
flag_seniors |
1 | .0406902 .0311751 1.31 0.192 -.020412 .1017924
--------------------+----------------------------------------------------------------
indirect |
flag_LPIS |
1 | -.0153102 .0050135 -3.05 0.002 -.0251364 -.005484
|
bike_route_tv | .0071187 .0057416 1.24 0.215 -.0041345 .018372
flag_street_improv | -.0171583 .0109783 -1.56 0.118 -.0386753 .0043588
flag_left_turn | -.0736957 .0184385 -4.00 0.000 -.1098344 -.037557
|
flag_school |
1 | .0156851 .0184146 0.85 0.394 -.0204069 .0517772
|
flag_priorityinters |
1 | -.1827036 .0462929 -3.95 0.000 -.273436 -.0919712
|
flag_seniors |
1 | .0100838 .0078826 1.28 0.201 -.0053658 .0255333
--------------------+----------------------------------------------------------------
total |
flag_LPIS |
1 | -.0770901 .0212116 -3.63 0.000 -.1186642 -.0355161
|
bike_route_tv | .0358443 .0281112 1.28 0.202 -.0192526 .0909412
flag_street_improv | -.0863956 .053081 -1.63 0.104 -.1904323 .0176412
flag_left_turn | -.3710738 .0620763 -5.98 0.000 -.4927411 -.2494065
|
flag_school |
1 | .0789781 .0916187 0.86 0.389 -.1005913 .2585475
|
flag_priorityinters |
1 | -.9199519 .1612878 -5.70 0.000 -1.23607 -.6038336
|
flag_seniors |
1 | .050774 .0388725 1.31 0.191 -.0254146 .1269626
-------------------------------------------------------------------------------------
[ ]:
spxtregress personsinjured i.flag_LPIS $time_variant_var $time_var $time_trend, fe dvarlag(W) errorlag(W)
[ ]:
[ ]:
spxtregress personsinjured i.flag_LPIS $time_variant_var $time_var $time_trend, fe dvarlag(W) errorlag(W)
[ ]:
[ ]: