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 statmap.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 24 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| Ticket ID | ticket_id | number | 1134068 1134069 1134369 1134372 1134380 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 2018-07-17T23:04:31.000 2019-08-08T14:17:27.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:45:58.000 2015-11-13T08:48:17.000 2015-11-13T08:47:13.000 2015-08-20T16:19:11.000 2015-10-08T09:28:38.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 | |
| SeeClickFix | seeclickfix | url | URL to issue on SeeClickFix | view top 100 |
| hours to acknowledge | hours_to_acknowledge | number | 0 0.1 0.2 0.3 0.4 view top 100 | |
| Days open | days_open | number | 0.1 0.2 0.7 0.8 0.9 view top 100 | |
| Day created | day_created | text | Tue Mon Wed Thu Fri view top 100 | |
| Day acknowledged | day_acknowledged | text | Mon Tue Wed Thu Fri view top 100 | |
| Day updated | day_updated | text | Thu Fri Wed Mon Sat view top 100 | |
| Day closed | day_closed | text | Mon Fri Tue Thu Wed view top 100 |