About this Dataset

City Of Tempe 2023 Business Survey Data

These data include the individual responses for the City of Tempe Annual Business Survey conducted by ETC Institute.

These data help determine priorities for the community as part of the City's on-going strategic planning process. Averaged Business Survey results are used as indicators for city performance measures. The performance measures with indicators from the Business Survey include the following (as of 2023):

1. Financial Stability and Vitality

5.01 Quality of Business Services

The location data in this dataset is generalized to the block level to protect privacy. This means that only the first two digits of an address are used to map the location. When they data are shared with the city only the latitude/longitude of the block level address points are provided. This results in points that overlap. In order to better visualize the data, overlapping points were randomly dispersed to remove overlap. The result of these two adjustments ensure that they are not related to a specific address, but are still close enough to allow insights about service delivery in different areas of the city.

Additional Information

Source: Business Survey

Contact (author): Adam Samuels

Contact E-Mail (author): Adam_Samuels@tempe.gov

Contact (maintainer):

Contact E-Mail (maintainer):

Data Source Type: Excel table

Preparation Method: Data received from vendor after report is completed

Publish Frequency: Annual

Publish Method: Manual

Data Dictionary

Methods:

The survey is mailed to a random sample of businesses in the City of Tempe. Follow up emails and texts are also sent to encourage participation. A link to the survey is provided with each communication. To prevent people who do not live in Tempe or who were not selected as part of the random sample from completing the survey, everyone who completed the survey was required to provide their address. These addresses were then matched to those used for the random representative sample. If the respondent’s address did not match, the response was not used.

To better understand how services are being delivered across the city, individual results were mapped to determine overall distribution across the city.

Processing and Limitations:

The data are used by the ETC Institute in the final published PDF report.
Organization: City of Tempe
Last updated: 2024-06-15T06:56:40.750474
Tags: business-survey

Tables

Table 1

@usgov.city_of_tempe_city_of_tempe_2023_business_survey_data.table_1

202.18 kB
401 rows
200 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "q1_01_01_police_services" BIGINT  -- Q1–01, , 01, Police Services,
  "q1_02_02_fire_services" BIGINT  -- Q1–02, , 02, Fire Services,
  "q1_03_03_emergency_medical" BIGINT  -- Q1–03, , 03, Emergency Medical,
  "q1_04_04_water_and_sewer_s" BIGINT  -- Q1–04, , 04, Water And Sewer S,
  "q1_05_05_parks" BIGINT  -- Q1–05, , 05, Parks,
  "q1_06_06_recreation_servic" BIGINT  -- Q1–06, , 06, Recreation Servic,
  "q1_07_07_street_maintenanc" BIGINT  -- Q1–07, , 07, Street Maintenanc,
  "q1_08_08_street_lighting" BIGINT  -- Q1–08, , 08, Street Lighting,
  "q1_09_09_street_sweeping" BIGINT  -- Q1–09, , 09, Street Sweeping,
  "q1_10_10_stormwater_draina" BIGINT  -- Q1–10, , 10, Stormwater Draina,
  "q1_11_11_public_transporta" BIGINT  -- Q1–11, , 11, Public Transporta,
  "q1_12_12_planning" BIGINT  -- Q1–12, , 12, Planning,
  "q1_13_13_enforcement_of_co" BIGINT  -- Q1–13, , 13, Enforcement Of Co,
  "q1_14_14_construction_code" BIGINT  -- Q1–14, , 14, Construction Code,
  "q1_15_15_public_landscapin" BIGINT  -- Q1–15, , 15, Public Landscapin,
  "q1_16_16_traffic_on_city_s" BIGINT  -- Q1–16, , 16, Traffic On City S,
  "q1_17_17_economic_business" BIGINT  -- Q1–17, , 17, Economic Business,
  "q1_18_18_quality_and_safet" BIGINT  -- Q1–18, , 18, Quality And Safet,
  "q1_19_19_maintenance_of_ci" BIGINT  -- Q1–19, , 19, Maintenance Of Ci,
  "q1_20_20_overall_image_of" BIGINT  -- Q1–20, , 20, Overall Image Of,
  "q1_21_21_social_human_serv" BIGINT  -- Q1–21, , 21, Social Human Serv,
  "q1_22_22_trash_and_recycli" BIGINT  -- Q1–22, , 22, Trash And Recycli,
  "q1_23_23_housing" BIGINT  -- Q1–23, , 23, Housing,
  "q1_24_24_transit_service_f" BIGINT  -- Q1–24, , 24, Transit Service F,
  "q1_25_25_education_career" BIGINT  -- Q1–25, , 25, Education, Career,
  "q1_26_26_overall_quality_o" BIGINT  -- Q1–26, , 26, Overall Quality O,
  "q1_27_27_how_well_the_city" BIGINT  -- Q1–27, , 27, How Well The City,
  "q1_28_28_overall_quality_o" BIGINT  -- Q1–28, , 28, Overall Quality O,
  "q1_29_29_quality_of_public" BIGINT  -- Q1–29, , 29, Quality Of Public,
  "q1_30_30_overall_feeling_o" BIGINT  -- Q1–30, , 30, Overall Feeling O,
  "q1_31_31_overall_value_you" BIGINT  -- Q1–31, , 31, Overall Value You,
  "q1_32_32_quality_of_your_i" BIGINT  -- Q1–32, , 32, Quality Of Your I,
  "q2_01_1st" BIGINT  -- Q2–01, , 1st,,
  "q2_02_2nd" DOUBLE  -- Q2–02, , 2nd,,
  "q2_03_3rd" DOUBLE  -- Q2–03, , 3rd,,
  "q3_how_would_you_rate_the_phys" BIGINT  -- Q3, How Would You Rate The Phys,
  "q4_01_01_overall_image_of_t" BIGINT  -- Q4–01, , 01, Overall Image Of T,
  "q4_02_02_quality_of_local_s" BIGINT  -- Q4–02, , 02, Quality Of Local S,
  "q4_03_03_low_crime_rate" BIGINT  -- Q4–03, , 03, Low Crime Rate,
  "q4_04_04_availability_of_tr" BIGINT  -- Q4–04, , 04, Availability Of Tr,
  "q4_05_05_level_of_taxation" BIGINT  -- Q4–05, , 05, Level Of Taxation,
  "q4_06_06_access_to_highways" BIGINT  -- Q4–06, , 06, Access To Highways,
  "q4_07_07_access_to_sky_harb" BIGINT  -- Q4–07, , 07, Access To Sky Harb,
  "q4_08_08_availability_of_qu" BIGINT  -- Q4–08, , 08, Availability Of Qu,
  "q4_09_09_availability_of_ho" BIGINT  -- Q4–09, , 09, Availability Of Ho,
  "q4_10_10_proximity_to_other" BIGINT  -- Q4–10, , 10, Proximity To Other,
  "q4_11_11_availability_of_pu" BIGINT  -- Q4–11, , 11, Availability Of Pu,
  "q4_12_12_availability_of_li" BIGINT  -- Q4–12, , 12, Availability Of Li,
  "q4_13_13_attitude_of_local" BIGINT  -- Q4–13, , 13, Attitude Of Local,
  "q4_14_14_availability_of_te" BIGINT  -- Q4–14, , 14, Availability Of Te,
  "q4_15_15_proximity_to_arizo" BIGINT  -- Q4–15, , 15, Proximity To Arizo,
  "q4_16_16_quality_attractive" BIGINT  -- Q4–16, , 16, Quality Attractive,
  "q4_17_17_availability_of_pa" BIGINT  -- Q4–17, , 17, Availability Of Pa,
  "q4_18_18_appearance_of_priv" BIGINT  -- Q4–18, , 18, Appearance Of Priv,
  "q4_19_19_up_to_date_constru" BIGINT  -- Q4–19, , 19, Up To Date Constru,
  "q4_20_20_ease_of_obtaining" BIGINT  -- Q4–20, , 20, Ease Of Obtaining,
  "q4_21_21_workforce_developm" BIGINT  -- Q4–21, , 21, Workforce Developm,
  "q4_22_22_insurance_services" BIGINT  -- Q4–22, , 22, Insurance Services,
  "q4_23_23_access_to_enhanced" BIGINT  -- Q4–23, , 23, Access To Enhanced,
  "q4_24_24_other" BIGINT  -- Q4–24, , 24, Other,
  "q5_01_1st" BIGINT  -- Q5–01, , 1st,,
  "q5_02_2nd" DOUBLE  -- Q5–02, , 2nd,,
  "q5_03_3rd" DOUBLE  -- Q5–03, , 3rd,,
  "q6_do_you_think_that_the_city" BIGINT  -- Q6, Do You Think That The City,
  "q7_do_you_see_tempe_as_a_welco" BIGINT  -- Q7, Do You See Tempe As A Welco,
  "q8_do_you_value_the_economic_a" BIGINT  -- Q8, Do You Value The Economic A,
  "q9_how_safe_do_you_think_your" BIGINT  -- Q9, How Safe Do You Think Your,
  "q10_how_safe_do_you_think_your" BIGINT  -- Q10, How Safe Do You Think Your,
  "q11_01_1_the_availability" BIGINT  -- Q11–01, , 1, The Availability,
  "q11_02_2_the_quality_of_wo" BIGINT  -- Q11–02, , 2, The Quality Of Wo,
  "q11_03_3_the_stability_of" BIGINT  -- Q11–03, , 3, The Stability Of,
  "q11_04_4_the_education_tec" BIGINT  -- Q11–04, , 4, The Education Tec,
  "q12_01_1_land_use_codes" BIGINT  -- Q12–01, , 1, Land Use Codes,
  "q12_02_2_landscaping_codes" BIGINT  -- Q12–02, , 2, Landscaping Codes,
  "q12_03_3_requirement_for_pr" BIGINT  -- Q12–03, , 3, Requirement For Pr,
  "q12_04_4_business_signage" BIGINT  -- Q12–04, , 4, Business Signage,
  "q12_05_5_business_parking" BIGINT  -- Q12–05, , 5, Business Parking,
  "q12_06_6_trash_disposal_re" BIGINT  -- Q12–06, , 6, Trash Disposal Re,
  "q12_07_7_alternatives_to_l" BIGINT  -- Q12–07, , 7, Alternatives To L,
  "q12_08_8_construction_code" BIGINT  -- Q12–08, , 8, Construction Code,
  "q12_09_9_commercial_trash" BIGINT  -- Q12–09, , 9, Commercial Trash,
  "q12_10_10_uniform_fire_cod" BIGINT  -- Q12–10, , 10, Uniform Fire Cod,
  "q13_01_1_expanding_1our_bu" DOUBLE  -- Q13–01, , 1, Expanding 1our Bu,
  "q13_02_2_renovating_2our_b" DOUBLE  -- Q13–02, , 2, Renovating 2our B,
  "q13_03_3_relocating_to_ano" DOUBLE  -- Q13–03, , 3, Relocating To Ano,
  "q13_04_4_relocating_to_ano" DOUBLE  -- Q13–04, , 4, Relocating To Ano,
  "q13_05_5_downsizing" DOUBLE  -- Q13–05, , 5, Downsizing,
  "q13_06_6_closing" DOUBLE  -- Q13–06, , 6, Closing,
  "q13_07_7_none_of_these" DOUBLE  -- Q13–07, , 7, None Of These,
  "q13_09_9_don_t_know" DOUBLE  -- Q13–09, , 9, Don T Know,
  "q14_overall_how_would_you_rat" BIGINT  -- Q14, Overall, How Would You Rat,
  "q15_01_01_tempe_11_cable" DOUBLE  -- Q15–01, , 01, Tempe 11, Cable,
  "q15_02_02_recreation_oppor" DOUBLE  -- Q15–02, , 02, Recreation Oppor,
  "q15_03_03_cit3_websites" DOUBLE  -- Q15–03, , 03, Cit3 Websites,
  "q15_04_04_water_bill_newsl" DOUBLE  -- Q15–04, , 04, Water Bill Newsl,
  "q15_05_05_newspapers" DOUBLE  -- Q15–05, , 05, Newspapers,
  "q15_06_06_tv_news" DOUBLE  -- Q15–06, , 06, TV News
);