Strategic Measure Community Survey Reporting Dataset

CREATE TABLE table_1 (
  "id" VARCHAR,
  "year" VARCHAR,
  "method" VARCHAR,
  "cll_a_1_quality_of_cultural_and_learning_services_and__a2b773e1" DOUBLE  -- CLL.A.1 Quality Of Cultural And Learning Services And Programs In Austin (e.g. Libraries, Museums, Cultural Centers And Events),
  "cll_a_3_quality_of_the_city_s_cultural_and_learning_fa_2190a3ad" DOUBLE  -- CLL.A.3 Quality Of The City's Cultural And Learning Facilities (e.g. Libraries, Cultural Centers, City Museums),
  "cll_a_4_attended_a_cultural_event_or_program_organized_75c3d293" DOUBLE  -- CLL.A.4 Attended A Cultural Event Or Program Organizedby The City In The Past 6 Months,
  "cll_a_5_overall_quality_of_life_in_the_city" DOUBLE,
  "cll_a_5_have_you_participated_in_a_city_of_austin_recr_dad61fbf" BIGINT  -- CLL.A.5 Have You Participated In A City Of Austin Recreation Program/event?,
  "cll_c_1_the_city_of_austin_as_a_place_where_i_feel_welcome" DOUBLE,
  "cll_d_1_austin_is_a_place_that_honors_and_preserves_my_e8ae9987" DOUBLE  -- CLL.D.1 Austin Is A Place That Honors And Preserves My Personal Heritage,
  "cll_e_1_cll_e_2_have_you_participated_in_a_lifelong_le_fe9c8692" DOUBLE  -- CLL.E.1 CLL.E.2 Have You Participated In A Lifelong Learning Activity In The Past 3 Months (learning Activity Or Class Unrelated To Work),
  "cll_e_3_city_offered_lifelong_learning_events_activiti_cbb2fc75" DOUBLE  -- CLL.E.3 City-offered Lifelong Learning Events, Activities, And Resources (Classes Or Learning Materials),
  "he_c_3_overall_quality_of_city_of_austin_parks_and_rec_ba956406" DOUBLE  -- HE.C.3 Overall Quality Of City Of Austin Parks And Recreation Programs Or Classesoffered By The City,
  "he_c_3_quality_of_city_of_austin_park_facilities_inclu_0133f74a" DOUBLE  -- HE.C.3 Quality Of City Of Austin Park Facilities (includes Recreation, Senior, Nature,cultural Centers And Museums),
  "he_c_3_special_weighted_measure" DOUBLE,
  "he_e_2_i_have_frequent_contact_with_friends_and_neighb_64ab339b" DOUBLE  -- HE.E.2 I Have Frequent Contact With Friends And Neighbors Outside Of My Home,
  "s_a_1_i_feel_safe_in_my_neighborhood_during_the_day" DOUBLE,
  "s_a_1_i_feel_safe_in_my_neighborhood_at_night" DOUBLE,
  "s_a_1_i_feel_safe_walking_alone_downtown_during_the_day" DOUBLE,
  "s_a_1_i_feel_safe_in_my_home" DOUBLE,
  "s_a_1_i_feel_safe_walking_alone_downtown_at_night" BIGINT,
  "s_a_1_s_b_4_i_feel_safe_in_my_workplace" DOUBLE,
  "s_a_1_i_feel_safe_in_city_parks" DOUBLE,
  "s_a_1_special_weighted_measure" DOUBLE,
  "s_a_2_i_trust_austin_police_department_apd" DOUBLE  -- S.A.2 I Trust Austin Police Department (APD),
  "s_a_2_i_trust_austin_fire_department_afd" DOUBLE  -- S.A.2 I Trust Austin Fire Department (AFD),
  "s_a_2_i_trust_emergency_medical_services_ems" DOUBLE  -- S.A.2 I Trust Emergency Medical Services (EMS),
  "s_a_2_special_weighted_measure" DOUBLE,
  "s_a_3_i_am_confident_that_in_case_of_an_emergency_my_r_7bf05477" DOUBLE  -- S.A.3 I Am Confident That In Case Of An Emergency, My Response Will Be Delivered Effectively,
  "s_b_3_i_have_sufficient_knowledge_and_understanding_of_95000496" DOUBLE  -- S.B.3 I Have Sufficient Knowledge And Understanding Of Community Laws, Codes, And Ordinances,
  "s_c_2_i_have_access_to_information_and_education_on_di_72bdf46d" DOUBLE  -- S.C.2 I Have Access To Information And Education On Disasters And Other Major Emergencies,
  "s_c_3_i_feel_prepared_to_help_myself_my_family_and_my__6494d8b6" DOUBLE  -- S.C.3 I Feel Prepared To Help Myself, My Family, And My Neighbors To Respond To Disasters And Major Emergencies,
  "s_d_2_i_feel_i_was_treated_fairly_during_my_enforcemen_988e313e" DOUBLE  -- S.D.2 I Feel I Was Treated Fairly During My Enforcement Process (arrests, Tickets, Warnings, Code Violations),
  "s_d_2_i_feel_i_was_treated_fairly_during_my_judicial_p_00ba1f5a" DOUBLE  -- S.D.2 I Feel I Was Treated Fairly During My Judicial Process (traffic And Parking Ticket Processing, Fine Collections, Misdemeanor Court Case Appearances),
  "s_d_2_special_weighted_measure" DOUBLE,
  "m_b_2_cost_of_transportation_to_get_around_austin" DOUBLE,
  "m_b_3_did_your_household_reduce_the_total_number_of_ca_4a32dcae" DOUBLE  -- M.B.3 Did Your Household Reduce The Total Number Of Cars Owned/leased In The Household By One Or More Within The Last Year?,
  "m_c_2_transportation_options_aside_from_personal_vehic_67309983" DOUBLE  -- M.C.2 Transportation Options (aside From Personal Vehicle) To Get Around Austin (e.g. Ride Share, But/train, Bike, Walk),
  "m_e_1_condition_of_major_city_streets_congress_ave_lam_0b76797f" DOUBLE  -- M.E.1 Condition Of Major City Streets (Congress Ave, Lamar, South First, Burnet, Etc.),
  "m_e_2_overall_maintenance_of_city_sidewalks" DOUBLE,
  "gtw_b_6_condition_of_city_facilities_and_buildings_e_g_7bb6068e" DOUBLE  -- GTW.B.6 Condition Of City Facilities And Buildings (e.g. Clean, Safe, Accessible),
  "gtw_b_6_special_weighted_measure" DOUBLE,
  "gtw_c_1_services_provided_by_the_city_s_3_1_1_assistan_21cf4203" DOUBLE  -- GTW.C.1 Services Provided By The City’s 3-1-1 Assistance Telephone Number,
  "gtw_c_2_gtw_f_1_overall_quality_of_services_provided_b_45e6a060" DOUBLE  -- GTW.C.2 GTW.F.1 Overall Quality Of Services Provided By The City Of Austin,
  "gtw_c_3_overall_value_that_you_receive_for_your_city_t_efd2b89a" DOUBLE  -- GTW.C.3 Overall Value That You Receive For Your City Tax Dollars And Fees,
  "gtw_e_2_civic_engagement_experience_with_the_city" DOUBLE,
  "gtw_e_3_the_city_s_effort_to_support_dialogue_between__70d9680b" DOUBLE  -- GTW.E.3 The City’s Effort To Support Dialogue Between Residents And Government,
  "gtw_g_1_employees_of_the_city_of_austin_are_ethical_in_f813ff92" DOUBLE  -- GTW.G.1 Employees Of The City Of Austin Are Ethical In The Way They Conduct City Business.,
  "gtw_g_6_the_city_s_efforts_to_be_fair" DOUBLE,
  "gtw_g_6_the_city_s_efforts_to_be_transparent" DOUBLE,
  "gtw_g_6_special_weighted_measure" DOUBLE,
  "city" VARCHAR,
  "council_district" BIGINT,
  "block_level_x_longitude" DOUBLE,
  "block_level_y_latitude" DOUBLE
);