Difference between revisions of "TIF Project"

From edegan.com
Jump to navigation Jump to search
Line 303: Line 303:
  
 
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
 
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
 +
 +
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).
  
 
===Philly===
 
===Philly===

Revision as of 17:51, 13 February 2018


McNair Project
TIF Project
Project logo 02.png
Project Information
Project Title TIF Project
Owner Cindy Ryoo, Yunnie Huang
Start Date 11/20/2017
Deadline 12/09/2017
Keywords TIF; city; data; GIS; Tax Increment Finance; KML
Primary Billing
Notes
Has project status Active
Copyright © 2016 edegan.com. All Rights Reserved.


TIF Data

Data is in

E:\McNair\Projects\Agglomeration\TIF

Cities in our sample with TIF Data

Name (City, State) Shape File? Yes/No Start/End Dates? Yes/No Notes Link to Data
Chicago, IL Yes Yes Upto 2016. All good. https://data.cityofchicago.org/Community-Economic-Development/Boundaries-Tax-Increment-Financing-Districts/fz5x-7zak
Columbus, OH Yes Yes Date is in 'passage' (change type in db) http://data-columbus.opendata.arcgis.com/datasets/tax-increment-financing-areas
Washington, DC Yes No Data coverage unknown but posted in 2018 http://opendata.dc.gov/datasets/tax-increment-financing-tif-areas\
Houston, TX Yes No Data coverage unknown but appears updated in 2017 (says 2013 elsewhere) http://data.houstontx.gov/dataset/city-tax-increment-reinvestment-zones-tirz
Dallas, TX Yes No Maybe 15% have dates (only 2013/14) http://www.dallascad.org/GISDataProducts.aspx
Vermont Yes No Appears last updated in Apr 2017 http://geodata.vermont.gov/datasets/cd53b08d40fc4e7dbc2757c36d038af5_7/data
Allegheny County (Pittsburgh), PA Yes No Do this one last! (Appears created 2017) https://data.wprdc.org/dataset/allegheny-county-tif-boundaries
Atlanta, GA Yes Yes Only ~13 records. Ends 2006. Might be up to date? INSERT LINK
Dublin, OH Yes Yes All bar 2 have dates. Last date 2015. http://data-dublinohio.opendata.arcgis.com/datasets/ff0af920c18e4aa78459137b6efcd3d3_0?uiTab=table&selectedAttributes%5B%5D=TIF_ID&chartType=bar

Cities not in our saple with TIF Data

Name (City, State) Shape File? Yes/No Date Last Updated Link to Data
Bloomington, IN No https://data.bloomington.in.gov/en/dataset/tax-increment-financing-tif-district-maps
Oakland, MI Yes 2016 http://accessoakland.oakgov.com/datasets/e90026448daa4d568daa3ef727d8d758_2
St. Louis, MO No 2018 http://www.bettertogetherstl.com/studies/economic-development/tif-database
Philadelphia, PA No
Larimer County, CO No
New Hampshire No http://www.swrpc.org/files/data/com_econ_dev/ed/December%202003_%20TIF%20Handbook_7232010forweb.pdf
Sherman, TX Yes 2017 https://koordinates.com/layer/16403-finance-tax-increment-finance-tif/
Cincinnati, OH No
Michigan No

Cities in our sample that have GIS data

Chicago,IL

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

2017 GIS Data it appears to contain everything that we might need (the CSV contains everything)!!! https://data.cityofchicago.org/Community-Economic-Development/Boundaries-Tax-Increment-Financing-Districts/fz5x-7zak

Other Data on all tifs (inc start and end date) up to 2012 https://data.cityofchicago.org/Community-Economic-Development/TIF-Status-and-Eligibility/3qsz-jemf

Map (but not GIS) based data of Chicago TIFs up to 2017. Included CDC date. https://data.cityofchicago.org/Community-Economic-Development/Tax-Increment-Financing-TIF-Projects-Map/v3a3-hhqn

This dataset is a comprehensive list of every project in every TIF District that has received funding from the City of Chicago via the TIF program from the inception of TIF to current. https://data.cityofchicago.org/Community-Economic-Development/Tax-Increment-Financing-TIF-Projects/mex4-ppfc

Chicago KML from another source https://catalog.data.gov/dataset/boundaries-tax-increment-financing-districts

Columbus, OH

Columbus,OH is in our data with 29 max active KML with start dates! http://catalog.smartcolumbuside.com/en/dataset/tax-increment-financing-areas1

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

Washington, DC

Washington, DC is in our data with 63 max active Data from 2011 available with TIF dates: http://opendata.dc.gov/datasets/tax-increment-financing-tif-areas See also, high tech dev zones (2013): http://opendata.dc.gov/datasets/111b31a212814aad9320d301ccf9d6a9_20 Econ dev zones (2004) http://opendata.dc.gov/datasets/a3aefd57db394fd68d739556253dc44d_18

Houston, TX

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

Dallas, TX

Has a map: http://www.arcgis.com/home/webmap/viewer.html?url=https://gis.dallascityhall.com/wwwgis/rest/services/Eco_public/EconomicDevelopment/MapServer/1 But the data doesn't contain dates and doesn't appear to be exportable. It looks like there is Dallas data with dates from 2016: http://www.dallascad.org/GISDataProducts.aspx

Vermont

Burlington, VT is in our data with 10 max active

GIS KML file, but doesn't contain creation date http://geodata.vermont.gov/datasets/cd53b08d40fc4e7dbc2757c36d038af5_7/data

Think the same thing is here: https://catalog.data.gov/dataset/vt-tax-increment-financing-tif-districts

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

Allegheny County, PA

PA cities in our data:

Bethlehem              PA	10	Lehigh and Northampton counties
Chesterbrook           PA	11	Chester County
Horsham                PA	10	Montgomery County
King of Prussia        PA	15	Montgomery County
Philadelphia	       PA	123	Philadelphia County
Pittsburgh	       PA	150	Allegheny County
West Conshohocken      PA	        Montgomery County

Pittsburgh,PA is in Allegheny County, and may be covered in the data KML that is supposed to have dates but doesn't appear to https://data.wprdc.org/dataset/allegheny-county-tif-boundaries


Cities not in our sample

Bloomington, IN

Bloomington, IN is not in our data

Some maps that plot TIFs, suggesting underlying data... https://data.bloomington.in.gov/en/dataset/tax-increment-financing-tif-district-maps

They don't host the GIS data on their own site: https://data.bloomington.in.gov/en/dataset?sort=score+desc%2C+metadata_modified+desc&res_format=KML&q=&page=2

Dublin, OH

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

Oakland, MI

Oakland, MI is not in our data KML that has TIFs without dates http://accessoakland.oakgov.com/datasets/e90026448daa4d568daa3ef727d8d758_2

Cities We Couldn't Find

  • Denver, CO
  • Bellevue, WA
  • Nashville-Davidson metropolitan government (balance), TN
  • Washington, DC
  • South San Francisco, CA
  • Portland, OR
  • Durham, NC
  • Pleasanton, CA
  • Baltimore, MD
  • Burlington, MA
  • Carlsbad, CA
  • Milpitas, CA
  • Richardson, TX
  • Lexington, MA
  • Los Gatos, CA
  • Memphis, TN
  • Oakland, CA
  • Charlotte, NC
  • Reston, VA
  • Tysons Corner, VA
  • Sandy Springs, GA
  • Campbell, CA
  • Madison, WI
  • St. Louis, MO
  • Alpharetta, GA
  • Berkeley, CA
  • Raleigh, NC
  • Phoenix, AZ
  • Ann Arbor, MI
  • Woburn, MA
  • Cary, NC
  • Emeryville, CA
  • Marlborough, MA
  • Burlingame, CA
  • Salt Lake City, UT
  • San Carlos, CA
  • Plano, TX
  • Scottsdale, AZ
  • Stamford, CT
  • Alexandria, VA
  • Newton, MA
  • Pasadena, CA
  • Albuquerque, NM
  • Arlington, VA
  • Bethesda, MD
  • Columbus, OH
  • Florence-Graham, CA
  • Kirkland, WA
  • Los Altos, CA
  • Cleveland, OH
  • Minneapolis, MN
  • Boca Raton, FL
  • Gaithersburg, MD
  • New Haven, CT
  • Cincinnati, OH
  • Eden Prairie, MN
  • Foster City, CA
  • Indianapolis city (balance), IN
  • Peachtree Corners, GA
  • Columbia, MD
  • Hayward, CA
  • Irving, TX
  • Bothell, WA
  • Watertown Town, MA
  • Chantilly, VA
  • Culver City, CA
  • Norwalk, CT
  • El Segundo, CA
  • Herndon, VA
  • Providence, RI

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

Other Stuff

St. Louis, MO

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

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).

Philly

City of Philly Enterprise Zones:

Enterprise Zones - Data includes commercial and industrial zones, i.e. areas with specific federal enterprise zone designation meant to attract and support businesses in blighted areas. Blighted areas are defined as meeting one of seven city mandated criteria, including unsafe, unsanitary and inadequate conditions; economically or socially undesirable land use; and faulty street and lot layout. https://www.opendataphilly.org/dataset/enterprise-zones

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

Larimer County

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

New Hampshire

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

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

Cincinnati

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

Michigan

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

Academic/Policy papers

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

Uploading TIF Data onto database (tigertest)

Command to upload KML file into a table in database (tigertest)

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)

Command to upload SHP file into a table in database (tigertest)

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
  • "TIFDistrict.shp" is the name of the shapefile and dallstif is the name of the table I wish to name
  • Will be prompted for a password after running inputting this command

To view all columns of a table

\d+ <tablename>

Cities & Tables

Chicago: Included

Table name: chicagotif

   Column    |           Type           | Collation | Nullable |                   Default                   | Storage  | Stats target | Description 
-------------+--------------------------+-----------+----------+---------------------------------------------+----------+--------------+-------------
ogc_fid      | integer                  |           | not null | nextval('chicagotif_ogc_fid_seq'::regclass) | plain    |              | 
wkb_geometry | geometry(Geometry,4326)  |           |          |                                             | main     |              | 
name         | character varying        |           |          |                                             | extended |              | 
description  | character varying        |           |          |                                             | extended |              | 
timestamp    | timestamp with time zone |           |          |                                             | plain    |              | 
begin        | timestamp with time zone |           |          |                                             | plain    |              | 
end          | timestamp with time zone |           |          |                                             | plain    |              | 
altitudemode | character varying        |           |          |                                             | extended |              | 
tessellate   | integer                  |           |          |                                             | plain    |              | 
extrude      | integer                  |           |          |                                             | plain    |              | 
visibility   | integer                  |           |          |                                             | plain    |              | 
draworder    | integer                  |           |          |                                             | plain    |              | 
icon         | character varying        |           |          |                                             | extended |              | 
name_trim    | character varying        |           |          |                                             | extended |              | 
show         | character varying        |           |          |                                             | extended |              | 
approval_d   | character varying        |           |          |                                             | extended |              | 
ref          | character varying        |           |          |                                             | extended |              | 
objectid     | character varying        |           |          |                                             | extended |              | 
ind          | character varying        |           |          |                                             | extended |              | 
repealed_d   | character varying        |           |          |                                             | extended |              | 
comm_area    | character varying        |           |          |                                             | extended |              | 
wards        | character varying        |           |          |                                             | extended |              | 
shape_area   | character varying        |           |          |                                             | extended |              | 
sbif         | character varying        |           |          |                                             | extended |              | 
shape_len    | character varying        |           |          |                                             | extended |              | 
type         | character varying        |           |          |                                             | extended |              | 
expiration   | character varying        |           |          |                                             | extended |              | 
use          | character varying        |           |          |                                             | extended |              |
pull columns: wkb_geometry, approval_d, expiration

Allegheny County, PA

Table name: alleghenycountytif

    Column      |           Type           | Collation | Nullable |                       Default                       | Storage  | Stats target | Description 
----------------+--------------------------+-----------+----------+-----------------------------------------------------+----------+--------------+-------------
ogc_fid         | integer                  |           | not null | nextval('alleghenycountytif_ogc_fid_seq'::regclass) | plain    |              | 
wkb_geometry    | geometry(Geometry,4326)  |           |          |                                                     | main     |              | 
name            | character varying        |           |          |                                                     | extended |              | 
description     | character varying        |           |          |                                                     | extended |              | 
timestamp       | timestamp with time zone |           |          |                                                     | plain    |              | 
begin           | timestamp with time zone |           |          |                                                     | plain    |              | 
end             | timestamp with time zone |           |          |                                                     | plain    |              | 
altitudemode    | character varying        |           |          |                                                     | extended |              | 
tessellate      | integer                  |           |          |                                                     | plain    |              | 
extrude         | integer                  |           |          |                                                     | plain    |              | 
visibility      | integer                  |           |          |                                                     | plain    |              | 
draworder       | integer                  |           |          |                                                     | plain    |              | 
icon            | character varying        |           |          |                                                     | extended |              | 
objectid        | integer                  |           |          |                                                     | plain    |              | 
terminationdate | character varying        |           |          |                                                     | extended |              | 
effectivedate   | character varying        |           |          |                                                     | extended |              | 
sponsor         | character varying        |           |          |                                                     | extended |              | 
active          | character varying        |           |          |                                                     | extended |              | 
verified        | character varying        |           |          |                                                     | extended |              | 
notes           | character varying        |           |          |                                                     | extended |              | 
verified_date   | character varying        |           |          |                                                     | extended |              |

Atlanta: Included

Table name: atlantatif

   Column    |           Type           | Collation | Nullable |                   Default                   | Storage  | Stats target | Description 
-------------+--------------------------+-----------+----------+---------------------------------------------+----------+--------------+-------------
ogc_fid      | integer                  |           | not null | nextval('atlantatif_ogc_fid_seq'::regclass) | plain    |              | 
wkb_geometry | geometry(Geometry,4326)  |           |          |                                             | main     |              | 
name         | character varying        |           |          |                                             | extended |              | 
description  | character varying        |           |          |                                             | extended |              | 
timestamp    | timestamp with time zone |           |          |                                             | plain    |              | 
begin        | timestamp with time zone |           |          |                                             | plain    |              | 
end          | timestamp with time zone |           |          |                                             | plain    |              | 
altitudemode | character varying        |           |          |                                             | extended |              | 
tessellate   | integer                  |           |          |                                             | plain    |              | 
extrude      | integer                  |           |          |                                             | plain    |              | 
visibility   | integer                  |           |          |                                             | plain    |              | 
draworder    | integer                  |           |          |                                             | plain    |              | 
icon         | character varying        |           |          |                                             | extended |              | 
objectid     | integer                  |           |          |                                             | plain    |              | 
id           | integer                  |           |          |                                             | plain    |              | 
area         | integer                  |           |          |                                             | plain    |              | 
tad_name     | character varying        |           |          |                                             | extended |              | 
start_       | character varying        |           |          |                                             | extended |              | 
status       | character varying        |           |          |                                             | extended |              | 
shape_length | double precision         |           |          |                                             | plain    |              | 
shape_area   | double precision         |           |          |                                             | plain    |              |
pull columns: wkb_geometry, start_, (say that end is 2020)

Columbus, OH

Table name: columbustif

    Column     |           Type           | Collation | Nullable |                   Default                    | Storage  | Stats target | Description 
---------------+--------------------------+-----------+----------+----------------------------------------------+----------+--------------+-------------
ogc_fid        | integer                  |           | not null | nextval('columbustif_ogc_fid_seq'::regclass) | plain    |              | 
wkb_geometry   | geometry(Geometry,4326)  |           |          |                                              | main     |              | 
name           | character varying        |           |          |                                              | extended |              | 
description    | character varying        |           |          |                                              | extended |              | 
timestamp      | timestamp with time zone |           |          |                                              | plain    |              | 
begin          | timestamp with time zone |           |          |                                              | plain    |              | 
end            | timestamp with time zone |           |          |                                              | plain    |              | 
altitudemode   | character varying        |           |          |                                              | extended |              | 
tessellate     | integer                  |           |          |                                              | plain    |              | 
extrude        | integer                  |           |          |                                              | plain    |              | 
visibility     | integer                  |           |          |                                              | plain    |              | 
draworder      | integer                  |           |          |                                              | plain    |              | 
icon           | character varying        |           |          |                                              | extended |              | 
objectid       | integer                  |           |          |                                              | plain    |              | 
fund_no        | character varying        |           |          |                                              | extended |              | 
orc            | character varying        |           |          |                                              | extended |              | 
ordinance      | character varying        |           |          |                                              | extended |              | 
passage        | character varying        |           |          |                                              | extended |              | 
agreement      | character varying        |           |          |                                              | extended |              | 
dte_status     | character varying        |           |          |                                              | extended |              | 
acres          | double precision         |           |          |                                              | plain    |              | 
url            | character varying        |           |          |                                              | extended |              | 
last_edit_date | character varying        |           |          |                                              | extended |              |

Washington, D.C.

Table name: dctif

   Column    |           Type           | Collation | Nullable |                Default                 | Storage  | Stats target | Description 
-------------+--------------------------+-----------+----------+----------------------------------------+----------+--------------+-------------
ogc_fid      | integer                  |           | not null | nextval('dctif_ogc_fid_seq'::regclass) | plain    |              | 
wkb_geometry | geometry(Geometry,4326)  |           |          |                                        | main     |              | 
name         | character varying        |           |          |                                        | extended |              | 
description  | character varying        |           |          |                                        | extended |              | 
timestamp    | timestamp with time zone |           |          |                                        | plain    |              | 
begin        | timestamp with time zone |           |          |                                        | plain    |              | 
end          | timestamp with time zone |           |          |                                        | plain    |              | 
altitudemode | character varying        |           |          |                                        | extended |              | 
tessellate   | integer                  |           |          |                                        | plain    |              | 
extrude      | integer                  |           |          |                                        | plain    |              | 
visibility   | integer                  |           |          |                                        | plain    |              | 
draworder    | integer                  |           |          |                                        | plain    |              | 
icon         | character varying        |           |          |                                        | extended |              | 
objectid     | integer                  |           |          |                                        | plain    |              | 
url          | character varying        |           |          |                                        | extended |              | 
dc_code      | character varying        |           |          |                                        | extended |              | 
type         | character varying        |           |          |                                        | extended |              | 
gis_id       | character varying        |           |          |                                        | extended |              | 
shape_length | double precision         |           |          |                                        | plain    |              | 
shape_area   | double precision         |           |          |                                        | plain    |              |

Dublin, OH: Included

Table name: dublintif

   Column     |           Type           | Collation | Nullable |                  Default                   | Storage  | Stats target | Description 
--------------+--------------------------+-----------+----------+--------------------------------------------+----------+--------------+-------------
ogc_fid       | integer                  |           | not null | nextval('dublintif_ogc_fid_seq'::regclass) | plain    |              | 
wkb_geometry  | geometry(Geometry,4326)  |           |          |                                            | main     |              | 
name          | character varying        |           |          |                                            | extended |              | 
description   | character varying        |           |          |                                            | extended |              | 
timestamp     | timestamp with time zone |           |          |                                            | plain    |              | 
begin         | timestamp with time zone |           |          |                                            | plain    |              | 
end           | timestamp with time zone |           |          |                                            | plain    |              | 
altitudemode  | character varying        |           |          |                                            | extended |              | 
tessellate    | integer                  |           |          |                                            | plain    |              | 
extrude       | integer                  |           |          |                                            | plain    |              | 
visibility    | integer                  |           |          |                                            | plain    |              | 
draworder     | integer                  |           |          |                                            | plain    |              | 
icon          | character varying        |           |          |                                            | extended |              | 
objectid      | integer                  |           |          |                                            | plain    |              | 
tif_id        | integer                  |           |          |                                            | plain    |              | 
tif_name      | character varying        |           |          |                                            | extended |              | 
tif_type      | character varying        |           |          |                                            | extended |              | 
ord_date      | character varying        |           |          |                                            | extended |              | 
ord_num       | character varying        |           |          |                                            | extended |              | 
ord_mod1      | character varying        |           |          |                                            | extended |              | 
ord_mod2      | character varying        |           |          |                                            | extended |              | 
ord_mod3      | character varying        |           |          |                                            | extended |              | 
pr_imp_st     | character varying        |           |          |                                            | extended |              | 
pr_imp_val    | integer                  |           |          |                                            | plain    |              | 
pub_imp_st    | character varying        |           |          |                                            | extended |              | 
pub_imp_val   | integer                  |           |          |                                            | plain    |              | 
num_jobs      | integer                  |           |          |                                            | plain    |              | 
exp_date      | integer                  |           |          |                                            | plain    |              | 
globalid      | character varying        |           |          |                                            | extended |              | 
shapestarea   | double precision         |           |          |                                            | plain    |              | 
shapestlength | double precision         |           |          |                                            | plain    |              |
pull columns: wkb_geometry, ord_date, exp_date

Vermont

Table name: vermonttif

   Column     |           Type           | Collation | Nullable |                   Default                   | Storage  | Stats target | Description 
--------------+--------------------------+-----------+----------+---------------------------------------------+----------+--------------+-------------
ogc_fid       | integer                  |           | not null | nextval('vermonttif_ogc_fid_seq'::regclass) | plain    |              | 
wkb_geometry  | geometry(Geometry,4326)  |           |          |                                             | main     |              | 
name          | character varying        |           |          |                                             | extended |              | 
description   | character varying        |           |          |                                             | extended |              | 
timestamp     | timestamp with time zone |           |          |                                             | plain    |              | 
begin         | timestamp with time zone |           |          |                                             | plain    |              | 
end           | timestamp with time zone |           |          |                                             | plain    |              | 
altitudemode  | character varying        |           |          |                                             | extended |              | 
tessellate    | integer                  |           |          |                                             | plain    |              | 
extrude       | integer                  |           |          |                                             | plain    |              | 
visibility    | integer                  |           |          |                                             | plain    |              | 
draworder     | integer                  |           |          |                                             | plain    |              | 
icon          | character varying        |           |          |                                             | extended |              | 
objectid_1    | integer                  |           |          |                                             | plain    |              | 
status        | character varying        |           |          |                                             | extended |              | 
tif           | character varying        |           |          |                                             | extended |              | 
acresotv      | double precision         |           |          |                                             | plain    |              | 
parcels       | integer                  |           |          |                                             | plain    |              | 
edtaxablev    | integer                  |           |          |                                             | plain    |              | 
munitaxabl    | integer                  |           |          |                                             | plain    |              | 
contactnam    | character varying        |           |          |                                             | extended |              | 
contacttit    | character varying        |           |          |                                             | extended |              | 
contacttel    | character varying        |           |          |                                             | extended |              | 
contactema    | character varying        |           |          |                                             | extended |              | 
stateconta    | character varying        |           |          |                                             | extended |              | 
statetitle    | character varying        |           |          |                                             | extended |              | 
statetelep    | character varying        |           |          |                                             | extended |              | 
stateemail    | character varying        |           |          |                                             | extended |              | 
datelastup    | character varying        |           |          |                                             | extended |              | 
shapestarea   | double precision         |           |          |                                             | plain    |              | 
shapestlength | double precision         |           |          |                                             | plain    |              |

Dallas, TX: Included

Table name: dallastif

  Column   |          Type          | Collation | Nullable |                Default                 | Storage  | Stats target | Description 
-----------+------------------------+-----------+----------+----------------------------------------+----------+--------------+-------------
gid        | integer                |           | not null | nextval('dallastif_gid_seq'::regclass) | plain    |              | 
cvttxdscrp | character varying(150) |           |          |                                        | extended |              | 
nofore     | bigint                 |           |          |                                        | plain    |              | 
noappl     | bigint                 |           |          |                                        | plain    |              | 
nosale     | bigint                 |           |          |                                        | plain    |              | 
sumasvlchg | numeric                |           |          |                                        | main     |              | 
sumtxvlchg | numeric                |           |          |                                        | main     |              | 
sumtxodchg | numeric                |           |          |                                        | main     |              | 
lastupdate | date                   |           |          |                                        | plain    |              | 
cvttxcd    | integer                |           |          |                                        | plain    |              | 
name       | character varying(150) |           |          |                                        | extended |              | 
created_us | character varying(254) |           |          |                                        | extended |              | 
created_da | date                   |           |          |                                        | plain    |              | 
last_edite | character varying(254) |           |          |                                        | extended |              | 
last_edi_1 | date                   |           |          |                                        | plain    |              | 
shape_star | numeric                |           |          |                                        | main     |              | 
shape_stle | numeric                |           |          |                                        | main     |              | 
shape_area | numeric                |           |          |                                        | main     |              | 
shape_len  | numeric                |           |          |                                        | main     |              | 
geom       | geometry(MultiPolygon) |           |          |                                        | main     |              |
pull columns: geom, created_da, (assume 2020 as end date)

Houston, TX

Table name: houstontif

  Column   |          Type          | Collation | Nullable |                 Default                 | Storage  | Stats target | Description 
-----------+------------------------+-----------+----------+-----------------------------------------+----------+--------------+-------------
gid        | integer                |           | not null | nextval('houstontif_gid_seq'::regclass) | plain    |              | 
perimeter  | numeric                |           |          |                                         | main     |              | 
name       | character varying(25)  |           |          |                                         | extended |              | 
siteno     | integer                |           |          |                                         | plain    |              | 
cohgis_coh | numeric                |           |          |                                         | main     |              | 
cohgis_c_1 | numeric                |           |          |                                         | main     |              | 
shape_area | numeric                |           |          |                                         | main     |              | 
shape_len  | numeric                |           |          |                                         | main     |              | 
geom       | geometry(MultiPolygon) |           |          |                                         | main     |              |