current (view)
Data source: City of Tampa Open Data
2 rows where COUNCILDISTRICT = 4 and NEIGHBORHOOD = "Davis Islands" sorted by LASTUPDATE descending
This data as json, geojson, CSV (advanced)
| RECORDID | ADDRESS | UNIT | Type | CRA | NEIGHBORHOOD | COUNCILDISTRICT | CREATEDDATE | LASTUPDATE ▲ | URL | geometry |
|---|---|---|---|---|---|---|---|---|---|---|
| REZ-26-0000038 | 150 E Davis Blvd | Rezoning | Davis Islands | 4 | 2026-01-15T00:00:00Z | 2026-04-30T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=26CAP&capID2=00000&capID3=002RS&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.45481285939903, 27.928545637940505]} | ||
| VRB-21-0000037 | 82 Adalia Ave | Variance Review Board | Davis Islands | 4 | 2021-01-06T00:00:00Z | 2021-10-04T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=21CAP&capID2=00000&capID3=000PH&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.46065699154315, 27.93160874181089]} |
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;