Changes

For example, say we want all of the state-level place data.

Also say we want to separate New York City, New York into a more granular by-borough set of polygons. Using [https://geo.nyu.edu/catalog/nyu_2451_34505 City University of New York data], we will import this shapefile.

$ cd /tmp

$ unzip boroughs.zip

$ shp2pgsql -I nyu_2451_34505/nyu_2451_34505.shp | psql -U researcher -d tigertest

$ psql --username researcher --dbname tigertest