Difference between revisions of "TIF Project"
Jump to navigation
Jump to search
| Line 7: | Line 7: | ||
|Has project status=Active | |Has project status=Active | ||
}} | }} | ||
| − | |||
| − | Data is in | + | ==Data== |
| + | |||
| + | New data is in | ||
| + | E:\projects\agglomeration\TIF | ||
| + | |||
| + | Old data is in | ||
E:\McNair\Projects\Agglomeration\TIF | E:\McNair\Projects\Agglomeration\TIF | ||
| − | ==Cities in our sample with TIF Data== | + | ==Summary== |
| + | |||
| + | |||
| + | ==Old Work== | ||
| + | |||
| + | ===Cities in our sample with TIF Data=== | ||
{| class="wikitable" | {| class="wikitable" | ||
! Name (City, State) | ! Name (City, State) | ||
| Line 128: | Line 137: | ||
|} | |} | ||
| − | ==Cities in our sample that have GIS data== | + | ===Cities in our sample that have GIS data=== |
| − | ===Chicago,IL=== | + | ====Chicago,IL==== |
Chicago, IL is in our data with 179 max active. | Chicago, IL is in our data with 179 max active. | ||
| Line 149: | Line 158: | ||
https://catalog.data.gov/dataset/boundaries-tax-increment-financing-districts | https://catalog.data.gov/dataset/boundaries-tax-increment-financing-districts | ||
| − | ===Columbus, OH=== | + | ====Columbus, OH==== |
Columbus,OH is in our data with 29 max active | Columbus,OH is in our data with 29 max active | ||
KML with start dates! | KML with start dates! | ||
| Line 155: | Line 164: | ||
http://data-columbus.opendata.arcgis.com/datasets/tax-increment-financing-areas | http://data-columbus.opendata.arcgis.com/datasets/tax-increment-financing-areas | ||
| − | ===Washington, DC=== | + | ====Washington, DC==== |
Washington, DC is in our data with 63 max active | Washington, DC is in our data with 63 max active | ||
Data from 2011 available with TIF dates: | Data from 2011 available with TIF dates: | ||
| Line 164: | Line 173: | ||
http://opendata.dc.gov/datasets/a3aefd57db394fd68d739556253dc44d_18 | http://opendata.dc.gov/datasets/a3aefd57db394fd68d739556253dc44d_18 | ||
| − | ===Houston, TX=== | + | ====Houston, TX==== |
Houston, TX is in our data with 101 max active | Houston, TX is in our data with 101 max active | ||
Last updated 2017, appears to have dates! | Last updated 2017, appears to have dates! | ||
http://data.houstontx.gov/dataset/city-tax-increment-reinvestment-zones-tirz | http://data.houstontx.gov/dataset/city-tax-increment-reinvestment-zones-tirz | ||
| − | ===Dallas, TX=== | + | ====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 | Has a map: http://www.arcgis.com/home/webmap/viewer.html?url=https://gis.dallascityhall.com/wwwgis/rest/services/Eco_public/EconomicDevelopment/MapServer/1 | ||
| Line 175: | Line 184: | ||
It looks like there is Dallas data with dates from 2016: http://www.dallascad.org/GISDataProducts.aspx | It looks like there is Dallas data with dates from 2016: http://www.dallascad.org/GISDataProducts.aspx | ||
| − | ===Vermont=== | + | ====Vermont==== |
Burlington, VT is in our data with 10 max active | Burlington, VT is in our data with 10 max active | ||
| Line 187: | Line 196: | ||
http://accd.vermont.gov/community-development/funding-incentives/tif | http://accd.vermont.gov/community-development/funding-incentives/tif | ||
| − | ===Dublin, OH=== | + | ====Dublin, OH==== |
Dublin, OH is not in our data | Dublin, OH is not in our data | ||
KML GIS data, has creation and expiration date! | 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 | http://data-dublinohio.opendata.arcgis.com/datasets/ff0af920c18e4aa78459137b6efcd3d3_0?uiTab=table&selectedAttributes%5B%5D=TIF_ID&chartType=bar | ||
| − | ===Allegheny County, PA=== | + | ====Allegheny County, PA==== |
PA cities in our data: | PA cities in our data: | ||
| Line 208: | Line 217: | ||
| − | ==Cities not in our sample== | + | ===Cities not in our sample=== |
| − | ===Bloomington, IN=== | + | ====Bloomington, IN==== |
Bloomington, IN is not in our data | Bloomington, IN is not in our data | ||
| Line 219: | Line 228: | ||
https://data.bloomington.in.gov/en/dataset?sort=score+desc%2C+metadata_modified+desc&res_format=KML&q=&page=2 | https://data.bloomington.in.gov/en/dataset?sort=score+desc%2C+metadata_modified+desc&res_format=KML&q=&page=2 | ||
| − | ===Oakland, MI=== | + | ====Oakland, MI==== |
Oakland, MI is not in our data | Oakland, MI is not in our data | ||
KML that has TIFs without dates | KML that has TIFs without dates | ||
http://accessoakland.oakgov.com/datasets/e90026448daa4d568daa3ef727d8d758_2 | http://accessoakland.oakgov.com/datasets/e90026448daa4d568daa3ef727d8d758_2 | ||
| − | ==Cities We Couldn't Find== | + | ===Cities We Couldn't Find=== |
| + | We looked for but couldn't find the following: | ||
*Denver, CO | *Denver, CO | ||
*Bellevue, WA | *Bellevue, WA | ||
| Line 298: | Line 308: | ||
There's data on a couple of places that we don't care about on https://ckan.geoplatform.gov/#?q=tax%20increment | There's data on a couple of places that we don't care about on https://ckan.geoplatform.gov/#?q=tax%20increment | ||
| − | ==Other Stuff== | + | ===Other Stuff=== |
| − | ===St. Louis, MO=== | + | ====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. Data with dates is here: https://worldmap.harvard.edu/data/geonode:stlcitif_0u1 | 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 | ||
| Line 306: | Line 316: | ||
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). | 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==== |
City of Philly Enterprise Zones: | City of Philly Enterprise Zones: | ||
| Line 314: | Line 324: | ||
Also Empowerment Zones. https://www.opendataphilly.org/dataset/empowerment-zones | Also Empowerment Zones. https://www.opendataphilly.org/dataset/empowerment-zones | ||
| − | ===Larimer County=== | + | ====Larimer County==== |
Larimer County Colorado: https://www.larimer.org/assessor/tif (no data) | Larimer County Colorado: https://www.larimer.org/assessor/tif (no data) | ||
| − | ===New Hampshire=== | + | ====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 | 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. | We have Nashua, NH (max 14 active) in our data, but it isn't one that has GIS data. | ||
| − | ===Sherman, TX=== | + | ====Sherman, TX==== |
Sherman, TX has GIS data without dates: https://koordinates.com/layer/16403-finance-tax-increment-finance-tif/ | Sherman, TX has GIS data without dates: https://koordinates.com/layer/16403-finance-tax-increment-finance-tif/ | ||
| − | ===Cincinnati=== | + | ====Cincinnati==== |
Cincinnati has TIFs (http://choosecincy.com/Economic-Development/Programs-Services/Incentives-Financing/Tax-Increment-Financing.aspx) but no GIS data... | Cincinnati has TIFs (http://choosecincy.com/Economic-Development/Programs-Services/Incentives-Financing/Tax-Increment-Financing.aspx) but no GIS data... | ||
| − | ===Michigan=== | + | ====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 | 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== | + | ===Academic/Policy papers=== |
A policy paper on the econ effects of TIFs https://projects.cberdata.org/reports/TifEconEffects-012815.pdf | A policy paper on the econ effects of TIFs https://projects.cberdata.org/reports/TifEconEffects-012815.pdf | ||
| − | =Uploading TIF Data onto database (tigertest)= | + | ==Uploading TIF Data onto database (tigertest)== |
| − | == Command to upload KML file into a table in 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 | 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) | (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) == | + | === 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 | 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 | * Run this command in a folder with all files for the table, such as files of type .shp, .dbf, .shx, .cpg, and .prj | ||
| Line 352: | Line 362: | ||
* Will be prompted for a password after running inputting this command | * Will be prompted for a password after running inputting this command | ||
| − | == To view all columns of a table == | + | === To view all columns of a table === |
\d+ <tablename> | \d+ <tablename> | ||
| − | == Cities & Tables == | + | === Cities & Tables === |
| − | === Chicago: Included === | + | ==== Chicago: Included ==== |
Table name: chicagotif | Table name: chicagotif | ||
| Line 423: | Line 433: | ||
verified_date | character varying | | | | extended | | | verified_date | character varying | | | | extended | | | ||
| − | === Atlanta: Included === | + | ==== Atlanta: Included ==== |
Table name: atlantatif | Table name: atlantatif | ||
| Line 453: | Line 463: | ||
pull columns: wkb_geometry, start_, (say that end is 2020) | pull columns: wkb_geometry, start_, (say that end is 2020) | ||
| − | === Columbus, OH === | + | ==== Columbus, OH ==== |
Table name: columbustif | Table name: columbustif | ||
| Line 483: | Line 493: | ||
last_edit_date | character varying | | | | extended | | | last_edit_date | character varying | | | | extended | | | ||
| − | === Washington, D.C. === | + | ==== Washington, D.C. ==== |
Table name: dctif | Table name: dctif | ||
| Line 510: | Line 520: | ||
shape_area | double precision | | | | plain | | | shape_area | double precision | | | | plain | | | ||
| − | === Dublin, OH: Included === | + | ==== Dublin, OH: Included ==== |
Table name: dublintif | Table name: dublintif | ||
| Line 550: | Line 560: | ||
pull columns: wkb_geometry, ord_date, exp_date | pull columns: wkb_geometry, ord_date, exp_date | ||
| − | === Vermont === | + | ==== Vermont ==== |
Table name: vermonttif | Table name: vermonttif | ||
| Line 588: | Line 598: | ||
shapestlength | double precision | | | | plain | | | shapestlength | double precision | | | | plain | | | ||
| − | === Dallas, TX: Included === | + | ==== Dallas, TX: Included ==== |
Table name: dallastif | Table name: dallastif | ||
| Line 617: | Line 627: | ||
pull columns: geom, created_da, (assume 2020 as end date) | pull columns: geom, created_da, (assume 2020 as end date) | ||
| − | === Houston, TX === | + | ==== Houston, TX ==== |
Table name: houstontif | Table name: houstontif | ||
| Line 634: | Line 644: | ||
| − | =Newly Found Data= | + | ==Newly Found Data== |
The following were found later and are yet to be reviewed: | The following were found later and are yet to be reviewed: | ||
*http://maps.vermont.gov/vcgi/html5viewer/?viewer=vtmapviewer | *http://maps.vermont.gov/vcgi/html5viewer/?viewer=vtmapviewer | ||
**Contains economic opportunity zones and data! | **Contains economic opportunity zones and data! | ||
Revision as of 11:31, 18 October 2019
| TIF Project | |
|---|---|
| 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. | |
Contents
- 1 Data
- 2 Summary
- 3 Old Work
- 4 Cities not in our sample with TIF Data
- 5 Uploading TIF Data onto database (tigertest)
- 6 Newly Found Data
Data
New data is in
E:\projects\agglomeration\TIF
Old data is in
E:\McNair\Projects\Agglomeration\TIF
Summary
Old Work
Cities in our sample with TIF Data
Cities not in our sample 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
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
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
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
We looked for but couldn't find the following:
- 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. 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).
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 | |
Newly Found Data
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!
