archived (view)
Data source: City of Tampa Open Data
3 rows where COUNCILDISTRICT = 4, NEIGHBORHOOD = "Sunset Park" and Type = "Design Exception 1" sorted by archived_date descending
This data as json, geojson, CSV (advanced)
| RECORDID | ADDRESS | UNIT | Type | CRA | NEIGHBORHOOD | COUNCILDISTRICT | CREATEDDATE | LASTUPDATE | URL | geometry | archived_date ▲ |
|---|---|---|---|---|---|---|---|---|---|---|---|
| DE1-26-0000021 | 4625 W Lamb Ave | Design Exception 1 | Sunset Park | 4 | 2025-10-29T00:00:00Z | 2025-12-04T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=25CAP&capID2=00000&capID3=02Q5P&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.52363250000981, 27.91727999996838]} | 2025-12-12 00:04:23 | ||
| DE1-25-0000144 | 5007 W San Jose St | Design Exception 1 | Sunset Park | 4 | 2025-07-14T00:00:00Z | 2025-07-14T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=25CAP&capID2=00000&capID3=01ZSF&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.52944650050634, 27.923256000153376]} | 2025-07-17 00:04:31 | ||
| DE1-25-0000089 | 4509 W Leona St | Design Exception 1 | Sunset Park | 4 | 2025-03-25T00:00:00Z | 2025-03-25T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=25CAP&capID2=00000&capID3=00I2Q&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.51994700038286, 27.915534000426298]} | 2025-03-29 00:04:15 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW archived AS
SELECT
RECORDID,
ADDRESS,
UNIT,
RECORDALIAS as Type,
CRA,
NEIGHBORHOOD,
COUNCILDISTRICT,
CREATEDDATE,
LASTUPDATE,
URL,
geometry,
archived_date
FROM archived_full;