329
edits
Changes
Jump to navigation
Jump to search
PostGIS Installation (view source)
Revision as of 22:46, 20 September 2017
, 22:46, 20 September 2017→Creating a Postgis DB
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.
<nowiki>
$ curl --insecure https://archive.nyu.edu/retrieve/74704/nyu_2451_34505.zip > /tmp/boroughs.zip
$ cd /tmp
$ unzip boroughs.zip
$ shp2pgsql nyu_2451_34505/nyu_2451_34505.shp
$ shp2pgsql -I nyu_2451_34505/nyu_2451_34505.shp | psql -U researcher -d tigertest
$ psql --username researcher --dbname tigertest
> select count(*) from nyu_2451_34505;
> \q
</nowiki>
=== Initial Setup ===
