current (view)
Data source: City of Tampa Open Data
2 rows where COUNCILDISTRICT = 4, NEIGHBORHOOD = "Gandy / Sun Bay South" and Type = "General Land Use" sorted by LASTUPDATE descending
This data as json, geojson, CSV (advanced)
| RECORDID | ADDRESS | UNIT | Type | CRA | NEIGHBORHOOD | COUNCILDISTRICT | CREATEDDATE | LASTUPDATE ▲ | URL | geometry |
|---|---|---|---|---|---|---|---|---|---|---|
| LND-26-0000053 | 5210 S Lois Ave | 1A | General Land Use | Gandy / Sun Bay South | 4 | 2026-02-04T00:00:00Z | 2026-04-28T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=26CAP&capID2=00000&capID3=007EO&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.51540883880219, 27.887645998897952]} | |
| LND-26-0000076 | 4908 W Price Ave | General Land Use | Gandy / Sun Bay South | 4 | 2026-04-02T00:00:00Z | 2026-04-15T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=26CAP&capID2=00000&capID3=00JBZ&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.52899017289167, 27.890673462539638]} |
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;