7,612
edits
Changes
Jump to navigation
Jump to search
|-
| tl_2016_51_place
| Virginia
|-
| tl_2016_51_place
| Virginia
|-
| tl_2016_51_place
| Virginia
|}==Tiger Geocoder Extension==This section details the process to install and use the Tiger Geocoder Extension of PostGIS. The official docmentation can be found [https://postgis.net/docs/Extras.html here]. [https://postgis.net/docs/postgis_installation.html#install_tiger_geocoder_extension This link] outlines the process to enable our Postgres Database to support Tiger functionality. This documentation has been moved to the [[Tiger Geocoder]] wiki page.
→Tiger Geocoder Extension
$ sudo apt-get install --no-install-recommends postgis</nowiki>
Note the last line. Without the <code>--no-install-recommends</code> line postgres assumes you're using the default configuration (in this case, postgis for postgresql 9.6). Since we're using a different flavor of postgispostgresql, we do not want this.
The <code>postgis</code> apt package is not the extension to postgres. It is a collection of command line utilities for importing and exporting data to a postgis db.
> select count(*) from nyu_2451_34505;
> \q</nowiki>
== To get into tigertest database ==
ssh researcher@128.42.44.181
cd /bulk
psql tigertest
== Translating Table names to corresponding States ==
See: https://www.census.gov/geo/reference/ansi_statetables.html
(note that the numbers are FIPS state numeric codes)
{| class="wikitable"
|-
|-
| tl_2016_14_place
| Georgia
|-
| tl_2016_15_place
| tl_2016_50_place
| Vermont
|-
| tl_2016_51_place
| tl_2016_56_place
| Wyoming
|-
| tl_2016_57_place
|
|-
| tl_2016_58_place
|
|-
| tl_2016_59_place
|
|-
| tl_2016_60_place
| American Samoa
|-
| tl_2016_61_place
|
|-
| tl_2016_62_place
|
|-
| tl_2016_63_place
|
|-
| tl_2016_64_place
|
|-
| tl_2016_65_place
|
|-
| tl_2016_66_place
| Guam
|-
| tl_2016_67_place
|
|-
| tl_2016_68_place
|
|-
| tl_2016_69_place
| Northern Marinas Islands
|-
| tl_2016_70_place
|
|-
| tl_2016_71_place
|
|-
| tl_2016_72_place
| Puerto Rico
|-
| tl_2016_73_place
|
|-
| tl_2016_74_place
|
|-
| tl_2016_75_place
|
|-
| tl_2016_76_place
|
|-
| tl_2016_77_place
|
|-
| tl_2016_78_place
| Virgin Islands
|}
