329
edits
Changes
Jump to navigation
Jump to search
=== Initial Setup ===
<nowiki>
$ createdb --username researcher tigertest
$ psql --username researcher --dbname tigertest
> create extension postgis;
> select postgis_full_version(); -- sanity test and make sure installed and enabled
> \q</nowiki>
PostGIS Installation (view source)
Revision as of 22:48, 20 September 2017
, 22:48, 20 September 2017→Creating a Postgis DB
== Creating a Postgis DB ==
=== Initial Setup ===
<nowiki>
$ createdb --username researcher tigertest
$ psql --username researcher --dbname tigertest
> create extension postgis;
> select postgis_full_version(); -- sanity test and make sure installed and enabled
> \q</nowiki>
=== Bulk Download TIGER Shapefiles ===
<nowiki>
# TODO
# ftp://ftp2.census.gov/geo/tiger/TIGER2016/PLACE/</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.
> \q
</nowiki>
