7,649
edits
Changes
Jump to navigation
Jump to search
Urban Start-up Agglomeration and Venture Capital Investment (view source)
Revision as of 13:23, 17 September 2019
, 13:23, 17 September 2019→TIF work
It should also be noted that firms located in the DC Ballpark TIF area are specifically excluded from being Qualified High Technology Companies[https://otr.cfo.dc.gov/sites/default/files/dc/sites/otr/publication/attachments/48605_FR-399_22416.pdf]. Checked the old version, and it didn't have dates either... so the labelling on [[TIF Project]] appears incorrect.
Call: 202 727 1140 -- Aisa Reed, senior data analyst.
202 727 4364 Nate Cruz, deputy director of Office of Economic Development Finance
202 478 9152 Nancy Fox, Senior Policy Analyst, Office of Economic Development Finance
Note that we might be able to infer them, one by one, from financial statements or by looking at their creating acts: https://cfo.dc.gov/node/230912
ogr2ogr -f PostgreSQL PG:"dbname=vcdb3" WashingtonDC.kml -nln tifwashingtondc Houston - no longer exists... But we have the shape files from the previous round of work. http://data.houstontx.gov/dataset/city-tax-increment-reinvestment-zones-tirz now leads to a dead link for the zip, but it does say that the file was created June 30, 2017, 2:27 PM (UTC-04:00) and last updated July 20, 2017, 2:22 PM (UTC-04:00). Again, though, '''no dates'''!Can go one by one through the creation docs found at https://www.houstontx.gov/ecodev/tirz_info.html This site lists 27 TIRZ, whereas there are only 23 in the old data. Harris County says that it participates in just 5 Houston TIRZs [https://hcoed.harriscountytx.gov/tirz.aspx].
In z:/vcdb3/Houston:
shp2pgsql -I "TIRZ.shp" tifhouston | psql -U researcher -W -d vcdb3
drop table tifhouston;
In z:/vcdb3/HarrisCounty
shp2pgsql -I "TIRZ.shp" tifharriscounty | psql -U researcher -W -d vcdb3
drop table tifharriscounty;
See https://www.bostongis.com/pgsql2shp_shp2pgsql_quickguide.bqg for a cheatsheet for shp2pgsql.
Found City of Houston KML data here: https://cohgis-mycity.opendata.arcgis.com/datasets/coh-tirz It doesn't have dates but does have 27 rows and was last updated 7/10/2019.
ogr2ogr -f PostgreSQL PG:"dbname=vcdb3" Houston.kml -nln tifhouston
One TIF had a null name, which was changed to UNKNOWN. By process of elimination, this was Village Enclaves (Terminated).
Found the dates in a review: https://www.houstontx.gov/finance/COHTIRZPerformanceAudit-FINAL(INCLUDINGAPPENDICES-NOMAPS).pdf
This was processed and extracted to E:\projects\agglomeration\TIF\HoustonDatesAndData.txt. Note that the total increment and project costs were $830,822k and $1,732,558k, respectively.
Also, the Texas Comptroller's office has a nice chapter on TIFs: https://www.cdfa.net/cdfa/cdfaweb.nsf/ordredirect.html?open&id=tifintexas.html
Dallas - downloaded 'latest' data [http://www.dallascad.org/GISDataProducts.aspx]. But no meta data is available. Shockingly, the data looks good and up to date. In contains legalstart and legalend fields for all 214 rows!
ogr2ogr -f PostgreSQL PG:"dbname=vcdb3" Atlanta.kml -nln tifatlanta
AlleghenyCounty (Pittsburg), PA -- Available from https://data.wprdc.org/dataset/allegheny-county-tif-boundaries but dates are "None" through out. Looks up to date (says August 20, 2019, 5:00 PM), and has 34 records.Same data available from http://openac-alcogis.opendata.arcgis.com/datasets/allegheny-county-tif-boundaries and https://catalog.data.gov/dataset/allegheny-county-tif-boundaries-a1715
ogr2ogr -f PostgreSQL PG:"dbname=vcdb3" AlleghenyCounty.kml -nln tifalleghenycounty
A report online [https://www.alleghenycontroller.com/admin/attachments/7880501fe636c1fe90fa572eb72b54292019MarTue13550615536085066512bd43d9caa6e02c990b0a82652dca36830bb3ce75baae6d5313ca822b2dc2FinalEconomicDevelopmentTaxSubsidiesReport.pdf], saved to the TIF folder, has end dates for 28 of 34 TIFs, which was used to infer start dates (T-20 from ). Note that the following TIF boundaries do not have dates:
CENTER TRIANGLE - LAZARUS
CENTER TRIANGLE - MELLON CLIENT SERVICE CENTER
MCCLAREN ROAD TIF
NORTH SHORE
PENN LIBERTY PLAZA
SCHENLEY CENTER
SEWICKLEY
SOUTH SIDE WORKS
WASHINGTON PARK
Also the following TIFs do not have boundaries:
Hazelwood‐Almono
Summerset at Frick Park
Robinson Mall Peripheral is lumped in with Robinson Mall in the boundary data.
==Other==
