current (view)
Data source: City of Tampa Open Data
1 row where NEIGHBORHOOD = "Bayshore Beautiful" and Type = "Design Exception 1" 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 |
|---|---|---|---|---|---|---|---|---|---|---|
| DE1-26-0000033 | 3906 S MacDill Ave | Design Exception 1 | Bayshore Beautiful | 4 | 2025-11-28T00:00:00Z | 2025-12-10T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=25CAP&capID2=00000&capID3=02VWS&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.49361300016201, 27.906659999893662]} |
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;