current (view)
Data source: City of Tampa Open Data
2 rows where COUNCILDISTRICT = 5, NEIGHBORHOOD = "Tampa Heights" and Type = "Design Exception 1" sorted by LASTUPDATE descending
This data as json, geojson, CSV (advanced)
| RECORDID | ADDRESS | UNIT | Type | CRA | NEIGHBORHOOD | COUNCILDISTRICT | CREATEDDATE | LASTUPDATE ▲ | URL | geometry |
|---|---|---|---|---|---|---|---|---|---|---|
| DE1-26-0000136 | 205 W Ross Ave | Design Exception 1 | Tampa Heights Riverfront | Tampa Heights | 5 | 2026-06-05T00:00:00Z | 2026-06-22T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=26CAP&capID2=00000&capID3=00W0O&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.46247251283103, 27.963291295908633]} | |
| DE1-26-0000091 | 2106 N Jefferson St | Design Exception 1 | Tampa Heights | 5 | 2026-03-18T00:00:00Z | 2026-06-08T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=26CAP&capID2=00000&capID3=00GE6&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.45662036891363, 27.963315687825762]} |
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;