About this Dataset

Police Sentiment Survey (detail)

This data supports the 1.05 Feeling of Safety in Your Neighborhood and 2.06 Police Trust Score performance measures.

This data is the result of a community survey of approximately 500 residents collected electronically and monthly by Zencity on behalf of Tempe Police Department. The scores are provided to TPD monthly in PDF form, and are then transferred to Excel for Open Data.

The trust score is a 0 to 100 measure, and is a combination of two questions: How much do you agree with this statement? Trust-Respect: The police in my neighborhood treat people with respect. How much do you agree with this statement? Trust-Listen: The police in my neighborhood listen to and take into account the concerns of local residents.

The safety score is a 0 to 100 measure, and scores residents' feelings of safety in their neighborhood.

The performance measure pages are available at 1.05 Feeling of Safety in Your Neighborhood and 2.06 Police Trust Score.

Additional Information

Source: Zencity

Contact (author): Carlena Orosco

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

Contact (maintainer): Carlena Orosco

Contact E-Mail (maintainer): Carlena_Orosco@tempe.gov

Data Source Type: Zencity REST API

Preparation Method: This data is from a citizen survey collected monthly by Zencity and provided in an automated survey feed to the City of Tempe.

Publish Frequency: Monthly

Publish Method: Zencity REST API Automated Survey Feed Updates ArcGIS Online feature layer.

Data Dictionary
Organization: City of Tempe
Last updated: 2024-02-09T14:57:07.371001
Tags: automation, etl, open-data, police-sentiment, public-facing, public-sentiment

Tables

Table 1

@usgov.city_of_tempe_police_sentiment_survey_detail_cb4b1.table_1

484.64 kB
690 rows
82 columns

CREATE TABLE table_1 (
  "org_level" BIGINT,
  "level_0" VARCHAR,
  "level_1" VARCHAR,
  "level_2" VARCHAR,
  "level_3" VARCHAR,
  "level_4" VARCHAR,
  "level_0_type" VARCHAR,
  "level_1_type" VARCHAR,
  "level_2_type" VARCHAR,
  "level_3_type" VARCHAR,
  "level_4_type" VARCHAR,
  "safety" DOUBLE,
  "safety_race_african_american" DOUBLE,
  "safety_race_asian_american" DOUBLE,
  "safety_race_other" DOUBLE,
  "safety_race_hispanic" DOUBLE,
  "safety_race_white" DOUBLE,
  "safety_age_low" DOUBLE,
  "safety_age_medium" DOUBLE,
  "safety_age_high" DOUBLE,
  "safety_sex_female" DOUBLE,
  "safety_sex_male" DOUBLE,
  "safety_education_low" DOUBLE,
  "safety_education_medium" DOUBLE,
  "safety_education_high" DOUBLE,
  "safety_income_low" DOUBLE,
  "safety_income_medium" DOUBLE,
  "safety_income_high" DOUBLE,
  "trust" DOUBLE,
  "trust_race_african_american" DOUBLE,
  "trust_race_asian_american" DOUBLE,
  "trust_race_other" DOUBLE,
  "trust_race_hispanic" DOUBLE,
  "trust_race_white" DOUBLE,
  "trust_age_low" DOUBLE,
  "trust_age_medium" DOUBLE,
  "trust_age_high" DOUBLE,
  "trust_sex_female" DOUBLE,
  "trust_sex_male" DOUBLE,
  "trust_education_low" DOUBLE,
  "trust_education_medium" DOUBLE,
  "trust_education_high" DOUBLE,
  "trust_income_low" DOUBLE,
  "trust_income_medium" DOUBLE,
  "trust_income_high" DOUBLE,
  "trust_listen" DOUBLE,
  "trust_listen_race_african_ameri" DOUBLE,
  "trust_listen_race_asian_america" DOUBLE,
  "trust_listen_race_other" DOUBLE,
  "trust_listen_race_hispanic" DOUBLE,
  "trust_listen_race_white" DOUBLE,
  "trust_listen_age_low" DOUBLE,
  "trust_listen_age_medium" DOUBLE,
  "trust_listen_age_high" DOUBLE,
  "trust_listen_sex_female" DOUBLE,
  "trust_listen_sex_male" DOUBLE,
  "trust_listen_education_low" DOUBLE,
  "trust_listen_education_medium" DOUBLE,
  "trust_listen_education_high" DOUBLE,
  "trust_listen_income_low" DOUBLE,
  "trust_listen_income_medium" DOUBLE,
  "trust_listen_income_high" DOUBLE,
  "trust_respect" DOUBLE,
  "trust_respect_race_african_amer" DOUBLE,
  "trust_respect_race_asian_americ" DOUBLE,
  "trust_respect_race_other" DOUBLE,
  "trust_respect_race_hispanic" DOUBLE,
  "trust_respect_race_white" DOUBLE,
  "trust_respect_age_low" DOUBLE,
  "trust_respect_age_medium" DOUBLE,
  "trust_respect_age_high" DOUBLE,
  "trust_respect_sex_female" DOUBLE,
  "trust_respect_sex_male" DOUBLE,
  "trust_respect_education_low" DOUBLE,
  "trust_respect_education_medium" DOUBLE,
  "trust_respect_education_high" DOUBLE,
  "trust_respect_income_low" DOUBLE,
  "trust_respect_income_medium" DOUBLE,
  "trust_respect_income_high" DOUBLE,
  "start_date" TIMESTAMP,
  "end_date" TIMESTAMP,
  "objectid" BIGINT
);