Changes

|Has project status=Active

}}

E:\McNair\Projects\Agglomeration\TIF

{| class="wikitable"

! Name (City, State)

|}

Chicago, IL is in our data with 179 max active.

https://catalog.data.gov/dataset/boundaries-tax-increment-financing-districts

Columbus,OH is in our data with 29 max active

KML with start dates!

http://data-columbus.opendata.arcgis.com/datasets/tax-increment-financing-areas

Washington, DC is in our data with 63 max active

Data from 2011 available with TIF dates:

http://opendata.dc.gov/datasets/a3aefd57db394fd68d739556253dc44d_18

Houston, TX is in our data with 101 max active

Last updated 2017, appears to have dates!

http://data.houstontx.gov/dataset/city-tax-increment-reinvestment-zones-tirz

Has a map: http://www.arcgis.com/home/webmap/viewer.html?url=https://gis.dallascityhall.com/wwwgis/rest/services/Eco_public/EconomicDevelopment/MapServer/1

It looks like there is Dallas data with dates from 2016: http://www.dallascad.org/GISDataProducts.aspx

Burlington, VT is in our data with 10 max active

http://accd.vermont.gov/community-development/funding-incentives/tif

Dublin, OH is not in our data

KML GIS data, has creation and expiration date!

http://data-dublinohio.opendata.arcgis.com/datasets/ff0af920c18e4aa78459137b6efcd3d3_0?uiTab=table&selectedAttributes%5B%5D=TIF_ID&chartType=bar

PA cities in our data:

Bloomington, IN is not in our data

https://data.bloomington.in.gov/en/dataset?sort=score+desc%2C+metadata_modified+desc&res_format=KML&q=&page=2

Oakland, MI is not in our data

KML that has TIFs without dates

http://accessoakland.oakgov.com/datasets/e90026448daa4d568daa3ef727d8d758_2

*Denver, CO

*Bellevue, WA

There's data on a couple of places that we don't care about on https://ckan.geoplatform.gov/#?q=tax%20increment

St. Louis has data but without GIS shapes. The data is here: http://www.bettertogetherstl.com/studies/economic-development/tif-database . It was apparently extracted from a 2015 report here: http://dor.mo.gov/pdf/2015TIFAnnualReport.pdf . The locations are google mapped here: http://www.bettertogetherstl.com/tax-incremental-financing-map. Data with dates is here: https://worldmap.harvard.edu/data/geonode:stlcitif_0u1

The St. Louis County appears to have shapefiles with start dates here: https://worldmap.harvard.edu/data/geonode:slcounty_tif_aqt (but not sure if they cover the city too).

City of Philly Enterprise Zones:

Also Empowerment Zones. https://www.opendataphilly.org/dataset/empowerment-zones

Larimer County Colorado: https://www.larimer.org/assessor/tif (no data)

New Hampshire report (2003) says that "some have GIS data" http://www.swrpc.org/files/data/com_econ_dev/ed/December%202003_%20TIF%20Handbook_7232010forweb.pdf

We have Nashua, NH (max 14 active) in our data, but it isn't one that has GIS data.

Sherman, TX has GIS data without dates: https://koordinates.com/layer/16403-finance-tax-increment-finance-tif/

Cincinnati has TIFs (http://choosecincy.com/Economic-Development/Programs-Services/Incentives-Financing/Tax-Increment-Financing.aspx) but no GIS data...

Michigan as some state level data (not GIS) in summary somewhere because it is reference in this report: http://www.senate.michigan.gov/SFA/Publications/Notes/2016Notes/NotesWin16dk.pdf

A policy paper on the econ effects of TIFs https://projects.cberdata.org/reports/TifEconEffects-012815.pdf

researcher@McNairDBServ:/bulk/tigertest$ ogr2ogr -f PostgreSQL PG:"dbname=tigertest" chicagotif.kml -nln chicagotif

(chicagotif.kml is the name of the KML file and chicagotif is the name I wish to name the table)

researcher@McNairDBServ:/bulk/Jeemin/Dallas$ shp2pgsql -I "TIFDistrict.shp" dallastif | psql -U postgres -W -d tigertest

* Run this command in a folder with all files for the table, such as files of type .shp, .dbf, .shx, .cpg, and .prj

* Will be prompted for a password after running inputting this command

\d+ <tablename>

Table name: chicagotif

verified_date | character varying | | | | extended | |

Table name: atlantatif

pull columns: wkb_geometry, start_, (say that end is 2020)

Table name: columbustif

last_edit_date | character varying | | | | extended | |

Table name: dctif

shape_area | double precision | | | | plain | |

Table name: dublintif

pull columns: wkb_geometry, ord_date, exp_date

Table name: vermonttif

shapestlength | double precision | | | | plain | |

Table name: dallastif

pull columns: geom, created_da, (assume 2020 as end date)

Table name: houstontif

The following were found later and are yet to be reviewed:

*http://maps.vermont.gov/vcgi/html5viewer/?viewer=vtmapviewer

**Contains economic opportunity zones and data!