current (view)
Data source: City of Tampa Open Data
2 rows where COUNCILDISTRICT = 7 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-0000030 | 9408 Orange Grove Dr | Design Exception 1 | Historic Forest Hills | 7 | 2025-11-20T00:00:00Z | 2025-11-26T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=25CAP&capID2=00000&capID3=02UTQ&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.48447800005556, 28.03540499967295]} | ||
| DE1-25-0000192 | 4702 E Busch Blvd | 101-105 | Design Exception 1 | Terrace Park | 7 | 2025-09-25T00:00:00Z | 2025-11-10T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=25CAP&capID2=00000&capID3=02IQR&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.40881949974724, 28.033100999998325]} |
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;