current (view)
Data source: City of Tampa Open Data
1 row where NEIGHBORHOOD = "Bayshore Beautiful" and Type = "Design Exception 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 |
|---|---|---|---|---|---|---|---|---|---|---|
| DE2-26-0000004 | 3017 W Asbury Pl | Design Exception 2 | Bayshore Beautiful | 4 | 2025-11-18T00:00:00Z | 2025-12-04T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=25CAP&capID2=00000&capID3=02U6P&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.49166000043085, 27.898748999654853]} |
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;