current (view)
Data source: City of Tampa Open Data
3 rows where NEIGHBORHOOD = "Macfarlane Park" 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-0000131 | 2704 W Palmetto St | General Land Use | Macfarlane Park | 6 | 2026-08-11T00:00:00Z | 2026-08-12T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=26CAP&capID2=00000&capID3=025PB&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.48715237781066, 27.962269585970702]} | ||
| LND-26-0000126 | 3432 W Beach St | General Land Use | Macfarlane Park | 6 | 2026-07-28T00:00:00Z | 2026-07-29T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=26CAP&capID2=00000&capID3=0229N&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.50005943310823, 27.96303866610472]} | ||
| LND-26-0000021 | 2706 W Chestnut St | General Land Use | Macfarlane Park | 6 | 2025-12-18T00:00:00Z | 2025-12-23T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=25CAP&capID2=00000&capID3=02ZAK&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.48723152010537, 27.95861530479136]} |
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;