Appendix A: Data Dictionary

FILE: FINAL_All_Quincy_Block_Scores_Bluebikes_9_24.geojson
MAP: FINAL_Map_All_Quincy_Block_Scores_Bluebikes_9_24.html
Contains all of the census blocks in Quincy with their scores and normalized (0 to 1) or logical (TRUE/FALSE) metrics contributing to their scores.
Column Name Description Example Value
GEOID Census designated ID for the census block; character 2.50214E+14
rt_coverage Whether or not the block is near a rapid transit station; logical FALSE
SCORE Total points from weighted inputs; numeric Calculated as 20*BG_total_pop_sqmi_scale + 15*pi_coverage + 15*bike_coverage + 10*avg_bike_ed_block_scale + 10*avg_bike_pd_block_scale + 10*TRACT_zero_veh_hh_sqmi_scale + 10*mixed_use_metric + 5*min_city_owned_ft + 5*multiple_bus_routes + 5*cr_coverage 49.611082
BG_total_pop_sqmi_scale Population density for the block's census block group, normalized relative to other blocks between 0 (least) to 1 (most); numeric 0.37723432
pi_coverage Whether or not the block is near a public input location; logical TRUE
bike_coverage Whether or not the block is near existing or planned bike infrastructure; logical FALSE
avg_bike_ed_block_scale Average existing biking demand of the network within the census block, normalized relative to other blocks between 0 (least) to 1 (most); numeric 0.48802824
avg_bike_pd_block_scale Average potential biking demand of the network within the census block, normalized relative to other blocks between 0 (least) to 1 (most); numeric 0.8840059
mixed_use_metric Balance of commerical, residential, and civic building area for the block's census block group, normalized from 0.33 to 1; numeric 0.4974644
TRACT_zero_veh_hh_sqmi_scale Density of zero-vehicle households for the block's census tract, normalized relative to other blocks between 0 (least) to 1 (most); numeric 0.33676611
min_city_owned_ft Whether or not the block has at least 936 sq ft of city-owned land (approx 5 times the space of a standard 19-dock Bluebikes station); logical TRUE
multiple_bus_routes Whether or not the block is near multiple bus routes; logical FALSE
cr_coverage Whether or not the block is near a commuter rail station; logical TRUE

 

FILE: FINAL_Quincy_Block_Scores_Bluebikes_RT_Proximity_Split_9_24.geojson
MAP: FINAL_Map_Quincy_Block_Scores_Bluebikes_RT_Proximity_Split_9_24.html
Contians a subset of Quincy blocks, particularly those that either a) are near a rapid transit station, or b) are outside of a 1/2 mile buffer of a rapid transit station.
Contains their scores and normalized (0 to 1) or logical (TRUE/FALSE) metrics contributing to their scores.
Column Name Description Example Value
GEOID Census designated ID for the census block; character 2.50214E+14
rt_coverage Whether or not the block is near a rapid transit station; logical FALSE
SCORE Total points from weighted inputs; numeric Calculated as 20*BG_total_pop_sqmi_scale + 15*pi_coverage + 15*bike_coverage + 10*avg_bike_ed_block_scale + 10*avg_bike_pd_block_scale + 10*TRACT_zero_veh_hh_sqmi_scale + 10*mixed_use_metric + 5*min_city_owned_ft + 5*multiple_bus_routes + 5*cr_coverage 49.611082
BG_total_pop_sqmi_scale Population density for the block's census block group, normalized relative to other blocks between 0 (least) to 1 (most); numeric 0.37723432
pi_coverage Whether or not the block is near a public input location; logical TRUE
bike_coverage Whether or not the block is near existing or planned bike infrastructure; logical FALSE
avg_bike_ed_block_scale Average existing biking demand of the network within the census block, normalized relative to other blocks between 0 (least) to 1 (most); numeric 0.48802824
avg_bike_pd_block_scale Average potential biking demand of the network within the census block, normalized relative to other blocks between 0 (least) to 1 (most); numeric 0.8840059
mixed_use_metric Balance of commerical, residential, and civic building area for the block's census block group, normalized from 0.33 to 1; numeric 0.4974644
TRACT_zero_veh_hh_sqmi_scale Density of zero-vehicle households for the block's census tract, normalized relative to other blocks between 0 (least) to 1 (most); numeric 0.33676611
min_city_owned_ft Whether or not the block has at least 936 sq ft of city-owned land (approx 5 times the space of a standard 19-dock Bluebikes station); logical TRUE
multiple_bus_routes Whether or not the block is near multiple bus routes; logical FALSE
cr_coverage Whether or not the block is near a commuter rail station; logical TRUE
near_RT Whether or not the block is near a rapid transit station; logical FALSE

 

FILE: FINAL_Recommended_Blocks_Quincy_Bluebikes_9_24.geojson
MAP: FINAL_Map_Recommended_Blocks_Quincy_Bluebikes_9_24.html
Column Name Description Example Value
GEOID Census designated ID for the census block; character 2.50214E+14
near_RT Whether or not the block is near a rapid transit station; logical FALSE
rt_station Name of the rapid transit station the census block is near, NA otherwise; character North Quincy
rank_rt_station Relative score rank (1 or 2) of the proposed census block near its rt_station, NA otherwise; numeric 2
rank_non_rt_group Relative score rank (1 to 12) of the proposed census block outside of a 1/2 mile buffer of a rapid transit station, NA otherwise; numeric 8
SCORE Total points from weighted inputs; numeric 74.58721
top_factors A list of the inputs that the census block scored above average for relative to all Quincy blocks; character Public input, Mixed use, City land

 

FILE: FINAL_Equity_Enhancing_Alternative_Blocks_Quincy_Bluebikes_9_24.geojson
MAP: FINAL_Map_Equity_Enhancing_Alternative_Blocks_Quincy_Bluebikes_9_24.html
Contians a subset of Quincy blocks, particularly those that scored within the top 100 of blocks outside of a 1/2 mile buffer of rapid transit stations but were not initially proposed, either to fit spatial considerations or due to having slightly lower scores
Contains their scores and normalized (0 to 1) or logical (TRUE/FALSE) metrics contributing to their scores, alongside demographic information
Column Name Description Example Value
GEOID Census designated ID for the census block; character 2.50214E+14
rt_coverage Whether or not the block is near a rapid transit station; logical FALSE
SCORE Total points from weighted inputs; numeric Calculated as 20*BG_total_pop_sqmi_scale + 15*pi_coverage + 15*bike_coverage + 10*avg_bike_ed_block_scale + 10*avg_bike_pd_block_scale + 10*TRACT_zero_veh_hh_sqmi_scale + 10*mixed_use_metric + 5*min_city_owned_ft + 5*multiple_bus_routes + 5*cr_coverage 49.611082
BG_total_pop_sqmi_scale Population density for the block's census block group, normalized relative to other blocks between 0 (least) to 1 (most); numeric 0.37723432
pi_coverage Whether or not the block is near a public input location; logical TRUE
bike_coverage Whether or not the block is near existing or planned bike infrastructure; logical FALSE
avg_bike_ed_block_scale Average existing biking demand of the network within the census block, normalized relative to other blocks between 0 (least) to 1 (most); numeric 0.48802824
avg_bike_pd_block_scale Average potential biking demand of the network within the census block, normalized relative to other blocks between 0 (least) to 1 (most); numeric 0.8840059
mixed_use_metric Balance of commerical, residential, and civic building area for the block's census block group, normalized from 0.33 to 1; numeric 0.4974644
TRACT_zero_veh_hh_sqmi_scale Density of zero-vehicle households for the block's census tract, normalized relative to other blocks between 0 (least) to 1 (most); numeric 0.33676611
min_city_owned_ft Whether or not the block has at least 936 sq ft of city-owned land (approx 5 times the space of a standard 19-dock Bluebikes station); logical TRUE
multiple_bus_routes Whether or not the block is near multiple bus routes; logical FALSE
cr_coverage Whether or not the block is near a commuter rail station; logical TRUE
GEOID_BG Census designated ID for the census block group that the block is within, referenced to source demographic information; character 2.50214E+11
BG_minority_pct Percent population that is minority (non-white or hispanic) within the block's block group; numeric 0.5223214
BG_lowincome_pct Percent population that is low-income (< 200% federal poverty level) within the block's block group; numeric 0.2072667