current (view)
Data source: City of Tampa Open Data
74 rows where Type = "Rezoning" sorted by LASTUPDATE descending
This data as json, geojson, CSV (advanced)
NEIGHBORHOOD >10
Type 1
- Rezoning · 74 ✖
| RECORDID | ADDRESS | UNIT | Type | CRA | NEIGHBORHOOD | COUNCILDISTRICT | CREATEDDATE | LASTUPDATE ▲ | URL | geometry |
|---|---|---|---|---|---|---|---|---|---|---|
| REZ-26-0000022 | 1915 W Palmetto St | Rezoning | West Tampa | Old West Tampa | 5 | 2025-12-04T00:00:00Z | 2026-05-07T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=25CAP&capID2=00000&capID3=02WWF&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.4790494390738, 27.96228171346]} | |
| REZ-26-0000023 | 2522 W Kennedy Blvd | Rezoning | Palma Ceia Pines | 6 | 2025-12-08T00:00:00Z | 2026-05-07T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=25CAP&capID2=00000&capID3=02XHG&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.48540733041628, 27.944719960834757]} | ||
| REZ-26-0000034 | 4400 W Boy Scout Blvd | Rezoning | Carver City Lincoln Gardens | 6 | 2026-01-06T00:00:00Z | 2026-05-07T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=26CAP&capID2=00000&capID3=000F1&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.5179203018456, 27.960984645213646]} | ||
| REZ-26-0000039 | 1301 E Columbus Dr | Rezoning | East Tampa | VM Ybor | 5 | 2026-01-16T00:00:00Z | 2026-05-07T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=26CAP&capID2=00000&capID3=002VJ&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.44543573280185, 27.966784321972604]} | |
| REZ-26-0000044 | 6734 S West Shore Blvd | Rezoning | Port Tampa City, Inc. Civic Association | 4 | 2026-02-11T00:00:00Z | 2026-05-07T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=26CAP&capID2=00000&capID3=008VV&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.52690705945544, 27.86928365732846]} | ||
| REZ-26-0000054 | 2704 W Azeele St | Rezoning | Palma Ceia Pines | 4 | 2026-03-06T00:00:00Z | 2026-05-07T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=26CAP&capID2=00000&capID3=00E31&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.48778401237361, 27.941060521406342]} | ||
| REZ-26-0000061 | 205 S Fremont Ave | Rezoning | South Howard | 6 | 2026-03-17T00:00:00Z | 2026-05-07T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=26CAP&capID2=00000&capID3=00G5Z&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.47891820519624, 27.943196764803417]} | ||
| REZ-26-0000063 | 2115 W Saint John St | Rezoning | West Tampa | Old West Tampa | 5 | 2026-04-07T00:00:00Z | 2026-05-07T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=26CAP&capID2=00000&capID3=00K7C&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.48109726404206, 27.96453023354888]} | |
| REZ-26-0000064 | 6206 S 6th St | Rezoning | Interbay - South of Gandy | 4 | 2026-04-09T00:00:00Z | 2026-05-07T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=26CAP&capID2=00000&capID3=00KOY&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.49596077615868, 27.878983111050047]} | ||
| REZ-26-0000065 | 4911 E 10th Ave | Rezoning | East Side Commercial | 5 | 2026-04-10T00:00:00Z | 2026-05-07T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=26CAP&capID2=00000&capID3=00KWE&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.403761411104, 27.963094577979813]} | ||
| REZ-26-0000067 | 2018 Grant St | Rezoning | Palmetto Beach | 5 | 2026-04-13T00:00:00Z | 2026-05-07T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=26CAP&capID2=00000&capID3=00LAJ&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.43637872986696, 27.94376343484413]} | ||
| REZ-26-0000068 | 107 W Virginia Ave | Rezoning | Tampa Heights | 6 | 2026-04-14T00:00:00Z | 2026-05-07T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=26CAP&capID2=00000&capID3=00LPF&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.46120978207253, 27.980058296126387]} | ||
| REZ-26-0000069 | 8878 N Florida Ave | Rezoning | Lowry Park Central | 6 | 2026-04-15T00:00:00Z | 2026-05-07T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=26CAP&capID2=00000&capID3=00LR8&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.45955980424603, 28.029824307240183]} | ||
| REZ-26-0000070 | 3817 N 54th St | Rezoning | East Tampa | Grant Park | 5 | 2026-04-15T00:00:00Z | 2026-05-07T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=26CAP&capID2=00000&capID3=00LXJ&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.39524158783452, 27.979951411823972]} | |
| REZ-26-0000076 | 109 W Amelia Ave | Rezoning | Tampa Heights | 5 | 2026-04-19T00:00:00Z | 2026-05-07T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=26CAP&capID2=00000&capID3=00ML2&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.46106221391292, 27.966055362764465]} | ||
| REZ-26-0000082 | 620 W Dr Martin Luther King Jr Blvd | Rezoning | 2026-05-01T00:00:00Z | 2026-05-07T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=26CAP&capID2=00000&capID3=00PE2&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.28509766472166, 27.98151185989683]} | ||||
| REZ-26-0000075 | 5250 E Broadway Ave | Rezoning | East Side Commercial | 5 | 2026-04-17T00:00:00Z | 2026-05-06T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=26CAP&capID2=00000&capID3=00MJP&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.39639395209491, 27.96326473433073]} | ||
| REZ-26-0000036 | 1506 N Morgan St | Rezoning | Tampa Heights | 5 | 2026-01-14T00:00:00Z | 2026-05-05T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=26CAP&capID2=00000&capID3=002BR&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.4581219221073, 27.95742166946406]} | ||
| REZ-26-0000041 | 4208 W Bay To Bay Blvd | Rezoning | Virginia Park | 4 | 2026-01-26T00:00:00Z | 2026-05-05T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=26CAP&capID2=00000&capID3=004J0&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.51443315541232, 27.91978868217267]} | ||
| REZ-26-0000043 | 5024 N 30th St | Rezoning | East Tampa | East Tampa 1 | 5 | 2026-02-11T00:00:00Z | 2026-05-05T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=26CAP&capID2=00000&capID3=008T2&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.42651988587318, 27.99164163157633]} | |
| REZ-26-0000051 | 9710 N Armenia Ave | -9720 | Rezoning | Historic Forest Hills | 7 | 2026-02-26T00:00:00Z | 2026-05-05T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=26CAP&capID2=00000&capID3=00C58&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.48207909423907, 28.038785594821476]} | |
| REZ-26-0000053 | 3817 Temple St | Rezoning | East Tampa | Grant Park | 5 | 2026-03-02T00:00:00Z | 2026-05-05T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=26CAP&capID2=00000&capID3=00CU8&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.40095245085233, 27.979986997441326]} | |
| REZ-26-0000062 | 5600 Mariner St | Rezoning | Beach Park | 6 | 2026-03-30T00:00:00Z | 2026-05-05T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=26CAP&capID2=00000&capID3=00INY&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.53705678239649, 27.942903026209194]} | ||
| REZ-26-0000078 | 3209 N 22nd St | Rezoning | East Tampa | North Ybor | 5 | 2026-04-20T00:00:00Z | 2026-05-05T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=26CAP&capID2=00000&capID3=00MWS&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.4346812595557, 27.971876223158915]} | |
| REZ-25-0000119 | 915 E 23rd Ave | Rezoning | East Tampa | VM Ybor | 5 | 2025-08-25T00:00:00Z | 2026-05-04T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=25CAP&capID2=00000&capID3=02ASI&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.45086197474551, 27.97189622122064]} | |
| REZ-26-0000028 | 2316 E 7th Ave | Rezoning | Ybor City 2 | Historic East Ybor and Gary | 5 | 2025-12-15T00:00:00Z | 2026-05-04T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=25CAP&capID2=00000&capID3=02YL2&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.43326453848026, 27.960303295283992]} | |
| REZ-26-0000052 | 5200 S Manhattan Ave | Rezoning | Gandy / Sun Bay South | 4 | 2026-02-27T00:00:00Z | 2026-05-04T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=26CAP&capID2=00000&capID3=00CCI&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.51835698203926, 27.887558435848756]} | ||
| REZ-26-0000055 | 107 N Armenia Ave | Rezoning | West Tampa | North Hyde Park | 5 | 2026-03-10T00:00:00Z | 2026-05-04T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=26CAP&capID2=00000&capID3=00ERD&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.48499862401358, 27.944892711305275]} | |
| REZ-26-0000060 | 1605 Waters Ct | Rezoning | Central Park | Historic Ybor | 5 | 2026-03-16T00:00:00Z | 2026-05-04T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=26CAP&capID2=00000&capID3=00FWE&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.45007566818072, 27.95916233587554]} | |
| REZ-26-0000073 | 1010 W Hillsborough Ave | Rezoning | Wellswood | 6 | 2026-04-17T00:00:00Z | 2026-05-04T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=26CAP&capID2=00000&capID3=00MD3&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.47046499950132, 27.995990703915737]} | ||
| REZ-25-0000118 | 4714 E Hillsborough Ave | Rezoning | East Tampa | Northeast Community Crimewatch & Civic Association | 5 | 2025-08-25T00:00:00Z | 2026-05-01T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=25CAP&capID2=00000&capID3=02ARD&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.40422371575139, 27.99615982474478]} | |
| REZ-26-0000026 | 2602 E Dr Martin Luther King Jr Blvd | Rezoning | East Tampa | East Tampa 1 | 5 | 2025-12-12T00:00:00Z | 2026-05-01T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=25CAP&capID2=00000&capID3=02YC7&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.43055600306248, 27.98152529585089]} | |
| REZ-26-0000074 | 2009 N Armenia Ave | Rezoning | West Tampa | Old West Tampa | 5 | 2026-04-17T00:00:00Z | 2026-05-01T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=26CAP&capID2=00000&capID3=00MI4&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.48489397031055, 27.95948013866218]} | |
| REZ-26-0000016 | 3206 N Tampa St | Rezoning | Tampa Heights | 5 | 2025-11-14T00:00:00Z | 2026-04-30T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=25CAP&capID2=00000&capID3=02TLH&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.4609398448963, 27.973437085990742]} | ||
| 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]} | ||
| REZ-26-0000066 | 2910 E Clark St | Rezoning | Palmetto Beach | 5 | 2026-04-10T00: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=00L1R&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.42750020633378, 27.94942229537737]} | ||
| REZ-26-0000079 | 1206 Holmes Ave | A-B | Rezoning | East Tampa | VM Ybor | 5 | 2026-04-29T00: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=00OVC&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.44687796645361, 27.9702384088195]} |
| REZ-26-0000080 | 306 S Plant Ave | Rezoning | Hyde Park Spanishtown Creek | 4 | 2026-04-30T00: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=00OXF&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.4627376389943, 27.941107838301793]} | ||
| REZ-26-0000081 | 4707 E Henry Ave | Rezoning | Northeast Community Crimewatch & Civic Association | 5 | 2026-04-30T00: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=00P22&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.40580814203015, 27.999664052826336]} | ||
| REZ-26-0000046 | 3705 N Darwin Ave | Rezoning | Tampa Heights | 6 | 2026-02-13T00:00:00Z | 2026-04-29T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=26CAP&capID2=00000&capID3=009GB&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.46449566937798, 27.977977640436485]} | ||
| REZ-26-0000047 | 1701 N Florida Ave | Rezoning | Tampa Heights | 5 | 2026-02-16T00:00:00Z | 2026-04-29T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=26CAP&capID2=00000&capID3=009QD&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.45938500585072, 27.96048405771898]} | ||
| REZ-26-0000077 | 4001 N Riverside Dr | Rezoning | South Seminole Heights | 6 | 2026-04-20T00:00:00Z | 2026-04-29T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=26CAP&capID2=00000&capID3=00MVJ&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.47336754151745, 27.981591953553394]} | ||
| REZ-26-0000072 | 2522 N 55th St | Rezoning | East Side Commercial | 5 | 2026-04-16T00:00:00Z | 2026-04-21T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=26CAP&capID2=00000&capID3=00M9I&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.39435604472436, 27.96539648584218]} | ||
| REZ-25-0000115 | 3717 W Obispo St | Rezoning | Palma Ceia | 4 | 2025-08-13T00:00:00Z | 2026-04-20T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=25CAP&capID2=00000&capID3=0281U&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.5043380158683, 27.917061612976383]} | ||
| REZ-26-0000019 | 1350 S Howard Ave | Rezoning | Historic Hyde Park | 4 | 2025-11-20T00:00:00Z | 2026-04-20T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=25CAP&capID2=00000&capID3=02UVI&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.48315102858678, 27.929544646267075]} | ||
| REZ-26-0000012 | 1704 W North B St | Rezoning | West Tampa | North Hyde Park | 5 | 2025-11-11T00:00:00Z | 2026-04-20T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=25CAP&capID2=00000&capID3=02SQG&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.47692688099922, 27.946814703974546]} | |
| REZ-26-0000071 | 1801 N Manhattan Ave | Rezoning | Carver City Lincoln Gardens | 6 | 2026-04-15T00:00:00Z | 2026-04-20T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=26CAP&capID2=00000&capID3=00M1C&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.5178920946037, 27.958079362583376]} | ||
| REZ-26-0000040 | 2722 W Chestnut St | Rezoning | Macfarlane Park | 6 | 2026-01-17T00:00:00Z | 2026-04-17T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=26CAP&capID2=00000&capID3=0031M&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.48754756484719, 27.9586180596252]} | ||
| REZ-26-0000042 | 2701 E 2nd Ave | Rezoning | Historic East Ybor and Gary | 5 | 2026-02-04T00:00:00Z | 2026-04-17T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=26CAP&capID2=00000&capID3=007E0&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.42934151781758, 27.95658025442202]} | ||
| REZ-26-0000048 | 11607 N Florida Ave | Rezoning | East Forest Hills | 7 | 2026-02-17T00:00:00Z | 2026-04-17T00:00:00Z | https://aca-prod.accela.com/TAMPA/Cap/CapDetail.aspx?Module=Planning&TabName=Planning&capID1=26CAP&capID2=00000&capID3=009RH&agencyCode=TAMPA | {"type": "Point", "coordinates": [-82.45931542602935, 28.054202498014188]} |
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;