This dataset is updated daily and contains a log of citizen requests to the Mayor's Action Center dating back to June 2014. These records describe requests for assistance with City services or reported problems, such as potholes, graffiti, broken sidewalks, storm drain issues, traffic signal/sign problems, special pick-up of dumped items, codes violations, etc. This data is used to power the city's St Pete Stat application at stat.stpete.org. Visit this site to see maps and stats about the City's closure rates for Action Center tickets, or search tickets in your neighborhood. Citizens submit requests for service through St. Pete's See Click Fix application. See http://www.stpete.org/action-center.php for more information.
This dataset has the following 17 columns:
Column Name | API Column Name | Data Type | Sample Values |
---|---|---|---|
Ticket ID | ticket_id | number | 6966600 4054788 11505622 9847546 1653694 view top 100 |
Issue Type | issue_type | text | Codes Compliance Sanitation Department Tree Trimming/Removal Traffic Issue Other view top 100 |
Secondary Issue Type | secondary_issue_type | text | Codes Compliance Sanitation Department Other Traffic Issue Tree Trimming/Removal view top 100 |
Issue Description | issue_description | text | pothole Rise up street Low limbs over street. yard parking Raised up over road view top 100 |
Street Address | street_address | text | Saint Petersburg FL 1744 9th Avenue North Saint Petersburg, FL 1744 9th Ave N Saint Petersburg, FL, 33713, USA St. Petersburg FL St. Petersburg Saint Petersburg, FL, USA view top 100 |
City | city | text | St. Petersburg view top 100 |
State | state | text | Florida view top 100 |
ZIP Code | zip_code | text | 33713 33701 33705 33710 33704 view top 100 |
Neighborhood / District | neighborhood_district | text | St. Petersburg / No Neighborhood view top 100 |
Ticket Created Date/Time | ticket_created_date_time | calendar_date | 2018-05-01T15:53:39.000 2018-05-01T15:53:40.000 2018-05-01T15:53:37.000 2017-08-22T15:03:10.000 2018-02-23T15:45:52.000 view top 100 |
Ticket Last Updated Date/Time | ticket_last_updated_date_time | calendar_date | 2018-09-26T05:48:09.000 2018-09-27T17:52:05.000 2018-09-26T05:48:11.000 2018-09-26T05:48:12.000 2018-09-26T04:51:20.000 view top 100 |
Ticket Closed Date/Time | ticket_closed_date_time | calendar_date | 2015-11-13T08:48:17.000 2015-11-13T08:45:58.000 2015-11-13T08:47:13.000 2015-10-08T09:28:38.000 2015-08-20T16:19:11.000 view top 100 |
Ticket Status | ticket_status | text | Archived Acknowledged Closed Open view top 100 |
Image | image | url | view top 100 |
lat | lat | number | 27.7614249606194 27.7804868 27.780200999999998 27.780075 27.7788534421483 view top 100 |
lng | lng | number | -82.6429415171946 -82.656868 -82.657008 -82.6567965 -82.6548205 view top 100 |
Location | location | location | view top 100 |