Baselight

City Of Tempe 2023 Business Survey Data

City of Tempe

@usgov.city_of_tempe_city_of_tempe_2023_business_survey_data

Loading...
Loading...

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 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.

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
  • 197.44 KB
  • 401 rows
  • 200 columns
Loading...

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "q1_01_01_police_services" BIGINT,
  "q1_02_02_fire_services" BIGINT,
  "q1_03_03_emergency_medical" BIGINT,
  "q1_04_04_water_and_sewer_s" BIGINT,
  "q1_05_05_parks" BIGINT,
  "q1_06_06_recreation_servic" BIGINT,
  "q1_07_07_street_maintenanc" BIGINT,
  "q1_08_08_street_lighting" BIGINT,
  "q1_09_09_street_sweeping" BIGINT,
  "q1_10_10_stormwater_draina" BIGINT,
  "q1_11_11_public_transporta" BIGINT,
  "q1_12_12_planning" BIGINT,
  "q1_13_13_enforcement_of_co" BIGINT,
  "q1_14_14_construction_code" BIGINT,
  "q1_15_15_public_landscapin" BIGINT,
  "q1_16_16_traffic_on_city_s" BIGINT,
  "q1_17_17_economic_business" BIGINT,
  "q1_18_18_quality_and_safet" BIGINT,
  "q1_19_19_maintenance_of_ci" BIGINT,
  "q1_20_20_overall_image_of" BIGINT,
  "q1_21_21_social_human_serv" BIGINT,
  "q1_22_22_trash_and_recycli" BIGINT,
  "q1_23_23_housing" BIGINT,
  "q1_24_24_transit_service_f" BIGINT,
  "q1_25_25_education_career" BIGINT,
  "q1_26_26_overall_quality_o" BIGINT,
  "q1_27_27_how_well_the_city" BIGINT,
  "q1_28_28_overall_quality_o" BIGINT,
  "q1_29_29_quality_of_public" BIGINT,
  "q1_30_30_overall_feeling_o" BIGINT,
  "q1_31_31_overall_value_you" BIGINT,
  "q1_32_32_quality_of_your_i" BIGINT,
  "q2_01_1st" BIGINT,
  "q2_02_2nd" DOUBLE,
  "q2_03_3rd" DOUBLE,
  "q3_how_would_you_rate_the_phys" BIGINT,
  "q4_01_01_overall_image_of_t" BIGINT,
  "q4_02_02_quality_of_local_s" BIGINT,
  "q4_03_03_low_crime_rate" BIGINT,
  "q4_04_04_availability_of_tr" BIGINT,
  "q4_05_05_level_of_taxation" BIGINT,
  "q4_06_06_access_to_highways" BIGINT,
  "q4_07_07_access_to_sky_harb" BIGINT,
  "q4_08_08_availability_of_qu" BIGINT,
  "q4_09_09_availability_of_ho" BIGINT,
  "q4_10_10_proximity_to_other" BIGINT,
  "q4_11_11_availability_of_pu" BIGINT,
  "q4_12_12_availability_of_li" BIGINT,
  "q4_13_13_attitude_of_local" BIGINT,
  "q4_14_14_availability_of_te" BIGINT,
  "q4_15_15_proximity_to_arizo" BIGINT,
  "q4_16_16_quality_attractive" BIGINT,
  "q4_17_17_availability_of_pa" BIGINT,
  "q4_18_18_appearance_of_priv" BIGINT,
  "q4_19_19_up_to_date_constru" BIGINT,
  "q4_20_20_ease_of_obtaining" BIGINT,
  "q4_21_21_workforce_developm" BIGINT,
  "q4_22_22_insurance_services" BIGINT,
  "q4_23_23_access_to_enhanced" BIGINT,
  "q4_24_24_other" BIGINT,
  "q5_01_1st" BIGINT,
  "q5_02_2nd" DOUBLE,
  "q5_03_3rd" DOUBLE,
  "q6_do_you_think_that_the_city" BIGINT,
  "q7_do_you_see_tempe_as_a_welco" BIGINT,
  "q8_do_you_value_the_economic_a" BIGINT,
  "q9_how_safe_do_you_think_your" BIGINT,
  "q10_how_safe_do_you_think_your" BIGINT,
  "q11_01_1_the_availability" BIGINT,
  "q11_02_2_the_quality_of_wo" BIGINT,
  "q11_03_3_the_stability_of" BIGINT,
  "q11_04_4_the_education_tec" BIGINT,
  "q12_01_1_land_use_codes" BIGINT,
  "q12_02_2_landscaping_codes" BIGINT,
  "q12_03_3_requirement_for_pr" BIGINT,
  "q12_04_4_business_signage" BIGINT,
  "q12_05_5_business_parking" BIGINT,
  "q12_06_6_trash_disposal_re" BIGINT,
  "q12_07_7_alternatives_to_l" BIGINT,
  "q12_08_8_construction_code" BIGINT,
  "q12_09_9_commercial_trash" BIGINT,
  "q12_10_10_uniform_fire_cod" BIGINT,
  "q13_01_1_expanding_1our_bu" DOUBLE,
  "q13_02_2_renovating_2our_b" DOUBLE,
  "q13_03_3_relocating_to_ano" DOUBLE,
  "q13_04_4_relocating_to_ano" DOUBLE,
  "q13_05_5_downsizing" DOUBLE,
  "q13_06_6_closing" DOUBLE,
  "q13_07_7_none_of_these" DOUBLE,
  "q13_09_9_don_t_know" DOUBLE,
  "q14_overall_how_would_you_rat" BIGINT,
  "q15_01_01_tempe_11_cable" DOUBLE,
  "q15_02_02_recreation_oppor" DOUBLE,
  "q15_03_03_cit3_websites" DOUBLE,
  "q15_04_04_water_bill_newsl" DOUBLE,
  "q15_05_05_newspapers" DOUBLE,
  "q15_06_06_tv_news" DOUBLE
);

Share link

Anyone who has the link will be able to view this.