City Of Tempe 2018 Community Survey Data

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "id_gis" BIGINT,
  "id" BIGINT,
  "method" VARCHAR,
  "q1_01_quality_of_local_fire_ser" BIGINT,
  "q1_02_quality_of_medical_rescue" BIGINT,
  "q1_03_quality_of_local_police_s" BIGINT,
  "q1_04_enforcement_of_local_traf" BIGINT,
  "q1_05_efforts_by_the_city_to_pr" BIGINT,
  "q1_06_overall_feeling_of_safety" BIGINT,
  "q1_07_feeling_of_safety_in_your" BIGINT,
  "q2_01_neighborhood_parks" BIGINT,
  "q2_02_city_parks_like_kiwanis_a" BIGINT,
  "q2_03_desert_parks_like_papago" BIGINT,
  "q2_04_city_athletic_and_recreat" BIGINT,
  "q2_05_tempe_public_library_comp" BIGINT,
  "q2_06_city_hall" BIGINT,
  "q2_07_mill_avenue" BIGINT,
  "q2_08_neighborhood_parks" BIGINT,
  "q2_09_city_parks_like_kiwanis_a" BIGINT,
  "q2_10_desert_parks_like_papago" BIGINT,
  "q2_11_city_athletic_and_recreat" BIGINT,
  "q2_12_tempe_public_library_comp" BIGINT,
  "q2_13_city_hall" BIGINT,
  "q2_14_mill_avenue" BIGINT,
  "q3_01_getting_mugged" BIGINT,
  "q3_02_having_your_home_burglari" BIGINT,
  "q3_03_being_attacked_or_threate" BIGINT,
  "q3_04_having_your_car_stolen_or" BIGINT,
  "q3_05_being_a_victim_of_identit" BIGINT,
  "q4_1_in_the_past_6_months_have" BIGINT,
  "q4_1a_were_the_police_informed" DOUBLE,
  "q4_2_in_the_past_6_months_has_a" BIGINT,
  "q4_2a_were_the_police_informed" DOUBLE,
  "q4a_what_was_the_reason_it_was" DOUBLE,
  "q4a_6_please_define_other" VARCHAR,
  "q6_01_the_overall_quality_of_se" BIGINT,
  "q6_02_leadership_of_the_citys_e" BIGINT,
  "q6_03_how_ethical_city_employee" BIGINT,
  "q6_04_availability_of_informati" BIGINT,
  "q6_05_availability_of_informati" BIGINT,
  "q6_06_availability_of_informati" BIGINT,
  "q6_07_how_easy_the_citys_3_1_1" BIGINT,
  "q6_08_usefulness_of_the_citys_w" BIGINT,
  "q6_09_tempes_online_services_re" BIGINT,
  "q6_10_your_ability_to_participa" BIGINT,
  "q6_11_the_accessibility_and_tra" BIGINT,
  "q6_12_how_well_the_city_treats" BIGINT,
  "q6_13_overall_quality_of_custom" BIGINT,
  "q7_01_city_council_meetings_sch" BIGINT,
  "q7_02_boards_and_commission_mee" BIGINT,
  "q7_03_city_elections_election_i" BIGINT,
  "q7_04_campaign_finance_and_lobb" BIGINT,
  "q7_05_open_books_financial_info" BIGINT,
  "q7_06_open_data" BIGINT,
  "q7_07_citys_performance_on_stra" BIGINT,
  "q8_01_how_courteous_and_respect" DOUBLE,
  "q8_02_the_hours_of_service_7_00" DOUBLE,
  "q8_03_the_ability_of_the_call_t" DOUBLE,
  "q8_04_the_call_taker_helped_you" DOUBLE,
  "q9_have_you_contacted_the_city" BIGINT,
  "q9a_which_department_did_you_co" VARCHAR,
  "q9b_01_were_you_treated_fairly" DOUBLE,
  "q9b_02_did_the_employee_s_liste" DOUBLE,
  "q9b_03_did_the_employee_care_ab" DOUBLE,
  "q9b_04_was_the_employee_honest" DOUBLE,
  "q9b_05_was_the_information_you" DOUBLE,
  "q9b_06_did_staff_respond_to_you" DOUBLE,
  "q10_01_fire_services" DOUBLE,
  "q10_02_tempe_public_librar2" DOUBLE,
  "q10_03_parks" DOUBLE,
  "q10_04_walking_biking_trails" DOUBLE,
  "q10_05_cit5_athletic_fields" DOUBLE,
  "q10_06_kid_zone" DOUBLE,
  "q10_07_police_services" DOUBLE,
  "q10_08_tempe_histor8_museum" DOUBLE,
  "q10_09_cit9_golf_courses" DOUBLE,
  "q10_10_cit10_swimming_pools" DOUBLE,
  "q10_11_kiwanis_recreation_cente" DOUBLE,
  "q10_12_tempe_311" DOUBLE,
  "q10_13_bus_orbit_or_light_rail" DOUBLE,
  "q10_14_tempe_center_for_the_art" DOUBLE,
  "q10_15_arts_and_recreation_prog" DOUBLE,
  "q10_16_household_products_colle" DOUBLE,
  "q10_17_multigenerational_commun" DOUBLE,
  "q10_18_human_services" DOUBLE,
  "q10_19_trash_composting_and_rec" DOUBLE,
  "q11_01_tempe_11_cable_tv" BIGINT,
  "q11_02_recreation_opportunities" BIGINT,
  "q11_03_cit3_website" BIGINT,
  "q11_04_water_bill_newsletter_te" BIGINT,
  "q11_05_social_media_twitter_fac" BIGINT,
  "q11_07_television_news" BIGINT,
  "q11_08_cit8_meetings" BIGINT,
  "q11_09_e_mail_subscriptions" BIGINT,
  "q11_10_tempe_311" BIGINT,
  "q11_11_radio" BIGINT,
  "q11_12_newspapers" BIGINT
);