329
edits
Changes
Jump to navigation
Jump to search
#!/bin/bash $ for i in $(seq -f "%02g" 1 80); do
PostGIS Installation (view source)
Revision as of 17:39, 22 September 2017
, 17:39, 22 September 2017→Bulk Download TIGER Shapefiles
<nowiki>
wget "https://www2.census.gov/geo/tiger/TIGER2016/PLACE/tl_2016_${i}_place.zip";
sleep 3 # not necessary but a good guy scraper move
done;$ for f in *.zip; do unzip "$f"; done$ for f in *.shp; do shp2pgsql -I "$f" | psql -U researcher -d tigertest; done$ psql --username researcher --dbname tigertest> select count(*) from tl_2016_01_place; -- 585</nowiki>
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.
