329
edits
Changes
Jump to navigation
Jump to search
PostGIS Installation (view source)
Revision as of 22:37, 20 September 2017
, 22:37, 20 September 2017→Creating a Postgis DB
== Creating a Postgis DB ==
=== Bulk Download TIGER Shapefiles ===
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.
=== 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>
== Enabling Commands ==
