This dataset has the following 21 columns:
Column Name | API Column Name | Data Type | Sample Values |
---|---|---|---|
Id | id | text | 8201971 8024091 8651811 8240611 7611179 view top 100 |
Reporter Display | reporter_display | text | St. Petersburg, FL Neighbor An anonymous SeeClickFix user Shaka Reed CSR 2 CSR1 view top 100 |
Status | status | text | In Progress view top 100 |
Summary | summary | text | Sidewalk/Curb Repair Stormwater Issue Pothole / Road Surface Issue Other City Park Maintenance view top 100 |
Address | address | text | 5361 34th Ave N St Petersburg, FL, 33710, USA 24th St S & 13th Ave S Saint Petersburg, FL, 33712, USA 100 31st St S Saint Petersburg, FL, 33712, USA 1005 16th St N Saint Petersburg, FL, 33705, USA 100 9th Ave N Saint Petersburg, FL, 33701, USA view top 100 |
Description | description | text | City Sidewalk is lifting and needs to be shaved down because it's a tripping hazard. Sidewalk cracked in many places sidewalk deep crack needs repair Raised curb along Anastasia Way causing standing water near catch basin. Cracked curb along Cordova Way causing vegetation to grow through and block stormwater flow. There is a section of re-bar sticking up in the street gutter. It is getting high enough to blow out a tire. view top 100 |
Agency Name | agency_name | text | City of St. Petersburg view top 100 |
URL | url | url | view top 100 |
Remote Integration IDs | remote_integration_ids | text | view top 100 |
Lat | lat | number | 27.7800122644579 27.793224 27.7574900620419 27.7671684659472 27.8165347537148 view top 100 |
Lng | lng | number | -82.6650399075193 -82.692846 -82.7548515 -82.7526285 -82.7511975 view top 100 |
Export tagged places | export_tagged_places | text | City Council District 7,City of St. Petersburg,CSR/PD/PARKS Dist 1,NA - JORDAN PARK RESIDENT MGMT AND CNL,South St Petersburg CRA City Council District 4,City of St. Petersburg,CSR/PD/PARKS Dist 2,NA - HISTORIC OLD NORTHEAST NBRHD ASSN City Council District 8,City of St. Petersburg,CSR/PD/PARKS Dist 3,NA - DISSTON HEIGHTS CIVIC ASSN City Council District 3,City of St. Petersburg,CSR/PD/PARKS Dist 2,NA - NORTH EAST PARK NBRHD ASSN City Council District 2,City of St. Petersburg,CSR/PD/PARKS Dist 2 view top 100 |
Plus account notes | plus_account_notes | text | view top 100 |
Request type answers as text | request_type_answers_as_text | text | Q: Is this a curb or sidewalk issue? A: Sidewalk Q: Location of sidewalk/curb issue? A: near driveway Q: Is the sidewalk made of hex blocks? A: No Q: NOTE: ***Please make sure that the address you are providing is the location of the issue being reported*** A: Q: Is this a curb or sidewalk issue? A: Sidewalk Q: Location of sidewalk/curb issue? A: in front of this address Q: Is the sidewalk made of hex blocks? A: No Q: NOTE: ***Please make sure that the address you are providing is the location of the issue being reported*** A: Q: Is this a curb or sidewalk issue? A: Sidewalk Q: Location of sidewalk/curb issue? A: BY ADDRESS Q: Is the sidewalk made of hex blocks? A: No Q: NOTE: ***Please make sure that the address you are providing is the location of the issue being reported*** A: Q: Is this a curb or sidewalk issue? A: Sidewalk Q: Location of sidewalk/curb issue? A: 795 21st Ave N Q: Is the sidewalk made of hex blocks? A: Yes Q: Is this a curb or sidewalk issue? A: Curb Q: Location of sidewalk/curb issue? A: stated above Q: Is the sidewalk made of hex blocks? A: No view top 100 |
Updated at local | updated_at_local | text | 08/12/2020 - 06:24AM 08/12/2020 - 05:29AM 07/10/2020 - 10:56AM 07/10/2020 - 11:05AM 07/10/2020 - 11:06AM view top 100 |
Created at local | created_at_local | text | 02/09/2020 - 04:03PM 02/10/2020 - 10:20AM 02/11/2020 - 11:52AM 02/12/2020 - 04:31PM 02/12/2020 - 12:11PM view top 100 |
Acknowledged at local | acknowledged_at_local | text | 07/16/2020 - 09:00AM 06/18/2020 - 07:52AM 07/16/2020 - 09:39AM 07/16/2020 - 09:58AM 07/16/2020 - 09:21AM view top 100 |
Assignee name | assignee_name | text | Pavement & Traffic view top 100 |
Parsed street and number | parsed_street_and_number | text | 24th St S & 13th Ave S 2846 22nd St N 5361 34th Ave N 405 15th Ave NE Pennsylvania Ave NE & Venetian Blvd NE view top 100 |
Category | category | text | Sidewalk/Curb Repair view top 100 |
New Georeferenced Column | geocoded_column | point | {"coordinates":[-82.6650399075193,27.7574900620419],"type":"Point"} {"coordinates":[-82.648926,27.793224],"type":"Point"} {"coordinates":[-82.636389,27.816435],"type":"Point"} {"coordinates":[-82.6469439268112,27.8206600528171],"type":"Point"} {"coordinates":[-82.6955703,27.7815588],"type":"Point"} view top 100 |