Built Environment Indicators

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "n_6_digit_tract_code" BIGINT  -- 6 Digit Tract Code,
  "census_id" BIGINT,
  "n_1_1_proximity_to_schools_raw_values" DOUBLE  -- 1.1: Proximity To Schools (raw Values),
  "n_1_2_proximity_to_modernized_schools_raw_values" DOUBLE  -- 1.2: Proximity To Modernized Schools (raw Values),
  "n_1_3_proximity_to_playgrounds_raw_values" DOUBLE  -- 1.3: Proximity To Playgrounds (raw Values),
  "n_1_4_proximity_to_crossing_guards_raw_values" DOUBLE  -- 1.4: Proximity To Crossing Guards (raw Values),
  "n_1_5_safe_routes_to_school_raw_values" DOUBLE  -- 1.5: Safe Routes To School (raw Values),
  "n_1_6_proximity_to_libraries_raw_values" DOUBLE  -- 1.6: Proximity To Libraries (raw Values),
  "n_1_7_access_to_wireless_hotspots_raw_values" DOUBLE  -- 1.7: Access To Wireless Hotspots (raw Values),
  "n_1_8_access_to_broadband_internet_raw_values" DOUBLE  -- 1.8: Access To Broadband Internet (raw Values),
  "n_1_9_proximity_to_recreation_centers_raw_values" DOUBLE  -- 1.9: Proximity To Recreation Centers (raw Values),
  "n_2_1_travel_time_to_work_raw_values" DOUBLE  -- 2.1: Travel Time To Work (raw Values),
  "n_3_1_proximity_to_banking_institutions_raw_values" DOUBLE  -- 3.1: Proximity To Banking Institutions (raw Values),
  "n_3_2_proximity_to_cash_checking_institutions_raw_values" DOUBLE  -- 3.2: Proximity To Cash Checking Institutions (raw Values),
  "n_4_1_housing_stock_quality_raw_values" DOUBLE  -- 4.1: Housing Stock Quality (raw Values),
  "n_4_2_share_of_homes_built_since_1970_raw_values" DOUBLE  -- 4.2: Share Of Homes Built Since 1970 (raw Values),
  "n_4_3_distribution_of_affordable_housing_raw_values" DOUBLE  -- 4.3: Distribution Of Affordable Housing (raw Values),
  "n_4_4_proximity_to_vacant_or_blighted_houses_raw_values" DOUBLE  -- 4.4: Proximity To Vacant Or Blighted Houses (raw Values),
  "n_5_1_proximity_to_metro_bus_raw_values" DOUBLE  -- 5.1: Proximity To Metro Bus (raw Values),
  "n_5_2_proximity_to_metro_station_raw_values" DOUBLE  -- 5.2: Proximity To Metro Station (raw Values),
  "n_5_3_proximity_to_capital_bikeshare_locations_raw_values" DOUBLE  -- 5.3: Proximity To Capital Bikeshare Locations (raw Values),
  "n_5_4_access_to_bike_lanes_raw_values" DOUBLE  -- 5.4: Access To Bike Lanes (raw Values),
  "n_5_5_sidewalk_quality_raw_values" DOUBLE  -- 5.5: Sidewalk Quality (raw Values),
  "n_5_6_parking_availability_raw_values" DOUBLE  -- 5.6: Parking Availability (raw Values),
  "n_6_1_proximity_to_grocery_stores_raw_values" DOUBLE  -- 6.1: Proximity To Grocery Stores (raw Values),
  "n_6_2_low_food_access_areas_raw_values" DOUBLE  -- 6.2: Low Food Access Areas (raw Values),
  "n_6_3_proximity_to_farmers_markets_raw_values" DOUBLE  -- 6.3: Proximity To Farmers Markets (raw Values),
  "n_6_4_availability_of_healthy_food_within_stores_raw_values" DOUBLE  -- 6.4: Availability Of Healthy Food Within Stores (raw Values),
  "n_6_5_proximity_to_restaurants_raw_values" DOUBLE  -- 6.5: Proximity To Restaurants (raw Values),
  "n_6_6_proximity_to_liquor_stores_raw_values" DOUBLE  -- 6.6: Proximity To Liquor Stores (raw Values),
  "n_7_1_proximity_to_health_care_facilities_raw_values" DOUBLE  -- 7.1: Proximity To Health Care Facilities (raw Values),
  "n_7_2_proximity_to_mental_health_facilities_and_provid_e7d43254" DOUBLE  -- 7.2: Proximity To Mental Health Facilities And Providers (raw Values),
  "n_8_1_tree_canopy_raw_values" DOUBLE  -- 8.1: Tree Canopy (raw Values),
  "n_8_2_proximity_to_parks_raw_values" DOUBLE  -- 8.2: Proximity To Parks (raw Values),
  "n_8_3_proximity_to_trails_raw_values" DOUBLE  -- 8.3: Proximity To Trails (raw Values),
  "n_8_4_presence_of_mix_of_land_uses_raw_values" DOUBLE  -- 8.4: Presence Of Mix Of Land Uses (raw Values),
  "n_8_5_positive_land_uses_raw_values" DOUBLE  -- 8.5: Positive Land Uses (raw Values),
  "n_8_6_flood_plains_raw_values" DOUBLE  -- 8.6: Flood Plains (raw Values),
  "n_9_1_proximity_to_vacant_lots_raw_values" DOUBLE  -- 9.1: Proximity To Vacant Lots (raw Values),
  "n_9_2_streetlight_coverage_raw_values" DOUBLE  -- 9.2: Streetlight Coverage (raw Values),
  "n_9_3_proximity_to_police_department_locations_raw_values" DOUBLE  -- 9.3: Proximity To Police Department Locations (raw Values),
  "n_9_4_proximity_to_fire_stations_raw_values" DOUBLE  -- 9.4: Proximity To Fire Stations (raw Values),
  "n_9_5_proximity_to_high_injury_network_corridors_raw_values" DOUBLE  -- 9.5: Proximity To High Injury Network Corridors (raw Values),
  "n_1_1_proximity_to_schools_percentiles" DOUBLE  -- 1.1: Proximity To Schools (percentiles),
  "n_1_2_proximity_to_modernized_schools_percentiles" DOUBLE  -- 1.2: Proximity To Modernized Schools (percentiles),
  "n_1_3_proximity_to_playgrounds_percentiles" DOUBLE  -- 1.3: Proximity To Playgrounds (percentiles),
  "n_1_4_proximity_to_crossing_guards_percentiles" DOUBLE  -- 1.4: Proximity To Crossing Guards (percentiles),
  "n_1_5_safe_routes_to_school_percentiles" DOUBLE  -- 1.5: Safe Routes To School (percentiles),
  "n_1_6_proximity_to_libraries_percentiles" DOUBLE  -- 1.6: Proximity To Libraries (percentiles),
  "n_1_7_access_to_wireless_hotspots_percentiles" DOUBLE  -- 1.7: Access To Wireless Hotspots (percentiles),
  "n_1_8_access_to_broadband_internet_percentiles" DOUBLE  -- 1.8: Access To Broadband Internet (percentiles),
  "n_1_9_proximity_to_recreation_centers_percentiles" DOUBLE  -- 1.9: Proximity To Recreation Centers (percentiles),
  "n_2_1_travel_time_to_work_percentiles" DOUBLE  -- 2.1: Travel Time To Work (percentiles),
  "n_3_1_proximity_to_banking_institutions_percentiles" DOUBLE  -- 3.1: Proximity To Banking Institutions (percentiles),
  "n_3_2_proximity_to_cash_checking_institutions_percentiles" DOUBLE  -- 3.2: Proximity To Cash Checking Institutions (percentiles),
  "n_4_1_housing_stock_quality_percentiles" DOUBLE  -- 4.1: Housing Stock Quality (percentiles),
  "n_4_2_share_of_homes_built_since_1970_percentiles" DOUBLE  -- 4. 2: Share Of Homes Built Since 1970 (percentiles),
  "n_4_3_distribution_of_affordable_housing_percentiles" DOUBLE  -- 4.3: Distribution Of Affordable Housing (percentiles),
  "n_4_4_proximity_to_vacant_or_blighted_houses_percentiles" DOUBLE  -- 4.4: Proximity To Vacant Or Blighted Houses (percentiles),
  "n_5_1_proximity_to_metro_bus_percentiles" DOUBLE  -- 5.1: Proximity To Metro Bus (percentiles),
  "n_5_2_proximity_to_metro_station_percentiles" DOUBLE  -- 5.2: Proximity To Metro Station (percentiles),
  "n_5_3_proximity_to_capital_bikeshare_locations_percentiles" DOUBLE  -- 5.3: Proximity To Capital Bikeshare Locations (percentiles),
  "n_5_4_access_to_bike_lanes_percentiles" DOUBLE  -- 5.4: Access To Bike Lanes (percentiles),
  "n_5_5_sidewalk_quality_percentiles" DOUBLE  -- 5.5: Sidewalk Quality (percentiles),
  "n_5_6_parking_availability_percentiles" DOUBLE  -- 5.6: Parking Availability (percentiles),
  "n_6_1_proximity_to_grocery_stores_percentiles" DOUBLE  -- 6.1: Proximity To Grocery Stores (percentiles),
  "n_6_2_low_food_access_areas_percentiles" DOUBLE  -- 6.2: Low Food Access Areas (percentiles),
  "n_6_3_proximity_to_farmers_markets_percentiles" DOUBLE  -- 6.3: Proximity To Farmers Markets (percentiles),
  "n_6_4_availability_of_healthy_food_within_stores_percentiles" DOUBLE  -- 6.4: Availability Of Healthy Food Within Stores (percentiles),
  "n_6_5_proximity_to_restaurants_percentiles" DOUBLE  -- 6.5: Proximity To Restaurants (percentiles),
  "n_6_6_proximity_to_liquor_stores_percentiles" DOUBLE  -- 6.6: Proximity To Liquor Stores (percentiles),
  "n_7_1_proximity_to_health_care_facilities_percentiles" DOUBLE  -- 7.1: Proximity To Health Care Facilities (percentiles),
  "n_7_2_proximity_to_mental_health_facilities_and_provid_564ad032" DOUBLE  -- 7.2: Proximity To Mental Health Facilities And Providers (percentiles),
  "n_8_1_tree_canopy_percentiles" DOUBLE  -- 8.1: Tree Canopy (percentiles),
  "n_8_2_proximity_to_parks_percentiles" DOUBLE  -- 8.2: Proximity To Parks (percentiles),
  "n_8_3_proximity_to_trails_percentiles" DOUBLE  -- 8.3: Proximity To Trails (percentiles),
  "n_8_4_presence_of_mix_of_land_uses_percentiles" DOUBLE  -- 8.4: Presence Of Mix Of Land Uses (percentiles),
  "n_8_5_positive_land_uses_percentiles" DOUBLE  -- 8.5: Positive Land Uses (percentiles),
  "n_8_6_flood_plains_percentiles" DOUBLE  -- 8.6: Flood Plains (percentiles),
  "n_9_1_proximity_to_vacant_lots_percentiles" DOUBLE  -- 9.1: Proximity To Vacant Lots (percentiles),
  "n_9_2_streetlight_coverage_percentiles" DOUBLE  -- 9.2: Streetlight Coverage (percentiles),
  "n_9_3_proximity_to_police_department_locations_percentiles" DOUBLE  -- 9.3: Proximity To Police Department Locations (percentiles),
  "n_9_4_proximity_to_fire_stations_percentiles" DOUBLE  -- 9.4: Proximity To Fire Stations (percentiles),
  "n_9_5_proximity_to_high_injury_network_corridors_percentiles" DOUBLE  -- 9.5: Proximity To High Injury Network Corridors (percentiles),
  "driver_1_education_percentiles" DOUBLE  -- Driver 1: Education (percentiles),
  "driver_2_employment_percentiles" DOUBLE  -- Driver 2: Employment (percentiles),
  "driver_3_financial_institutions_percentiles" DOUBLE  -- Driver 3: Financial Institutions (percentiles),
  "driver_4_housing_percentiles" DOUBLE  -- Driver 4: Housing (percentiles),
  "driver_5_transportation_percentiles" DOUBLE  -- Driver 5: Transportation (percentiles),
  "driver_6_food_environment_percentiles" DOUBLE  -- Driver 6: Food Environment (percentiles),
  "driver_7_medical_care_percentiles" DOUBLE  -- Driver 7: Medical Care (percentiles),
  "driver_8_outdoor_environment_percentiles" DOUBLE  -- Driver 8: Outdoor Environment (percentiles),
  "driver_9_community_safety_percentiles" DOUBLE  -- Driver 9: Community Safety (percentiles),
  "overall_driver_score_percentiles" DOUBLE  -- Overall Driver Score (percentiles),
  "bottom_10th_percentile_census_tracts" BIGINT,
  "driver_1_education_raw_values" DOUBLE  -- Driver 1: Education (raw Values),
  "driver_2_employment_raw_values" DOUBLE  -- Driver 2: Employment (raw Values),
  "driver_3_financial_institutions_raw" DOUBLE  -- Driver 3: Financial Institutions (raw),
  "driver_4_housing_raw_values" DOUBLE  -- Driver 4: Housing (raw Values)
);