7,613
edits
Changes
Jump to navigation
Jump to search
ogr2ogr Some date data taken from: https://cfo.dc.gov/sites/default/files/dc/sites/ocfo/publication/attachments/FY%202018%20DC%20CAFR_Full%20Report.pdfOthers can be taken directly from the legislation either http://lims.dccouncil.us or https://code.dccouncil.us/dc/council/code/sections (better through Google). In 2 cases, I also took data from a news article [https://ggwash.org/view/12907/what-can-dc-learn-from-its-f PostgreSQL PGsuccessful-subsidies]. See also, DC's TIF legislation: https:"dbname=vcdb3" WashingtonDC//code.kml -nln tifwashingtondcdccouncil.us/dc/council/code/titles/2/chapters/12/subchapters/IX/
Urban Start-up Agglomeration and Venture Capital Investment (view source)
Revision as of 19:01, 17 September 2019
, 19:01, 17 September 2019→TIF work
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'''!
Found the data on the dates here: https://www.stlouis-mo.gov/government/departments/sldc/documents/upload/Summary-of-TIF-Redevelopment-Projects-Updated-12-31-18.pdf
ogr2ogr -f PostgreSQL PG:"dbname=vcdb3" StLouisCounty.kml -nln tifstlouiscounty
--There are 46 records and we'd have to work to pull the passed field out of the description
DROP TABLE tifstlouiscounty;
shp2pgsql -I "TIF_DISTRICTS_20190830.shp" tifstlouis | psql -U researcher -W -d vcdb3
--118 records
These were put together with the dates using some regexes:
^(.*) Retired.*$
^(.*) Active.*$
^(.*) Terminated.*$
^(.*) Never Approved.*$
^(.*) On Hold.*$
.* (\d\d?\-\w\w\w-\d\d).*
==Other==
