current (view)
Data source: City of Tampa Open Data
1 row where NEIGHBORHOOD = "Bayshore Beautiful" and Type = "AB Special Use 2" sorted by LASTUPDATE descending
This data as json, CSV (advanced)
Suggested facets: CREATEDDATE (date), LASTUPDATE (date)
| RECORDID | ADDRESS | UNIT | Type | CRA | NEIGHBORHOOD | COUNCILDISTRICT | CREATEDDATE | LASTUPDATE ▲ | URL | geometry |
|---|---|---|---|---|---|---|---|---|---|---|
| AB2-26-0000002 | 4205 S MacDill Ave | A | AB Special Use 2 | Bayshore Beautiful | 4 | 2025-10-06T00:00:00Z | 2025-12-09T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=25CAP&capID2=00000&capID3=02L2F&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.49411699990546, 27.903761999618613]} |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW current AS
SELECT
RECORDID,
ADDRESS,
UNIT,
RECORDALIAS as Type,
CRA,
NEIGHBORHOOD,
COUNCILDISTRICT,
CREATEDDATE,
LASTUPDATE,
URL,
geometry
FROM current_full;