Spatial Database Management



Lesson 3 is one week in length, see the Calendar in Canvas for specific due dates. To finish this lesson you must complete the activities listed below:

  1. If you haven't already done so, please download and install Postgres, PostGIS and QGIS (an open-source desktop GIS package we'll use to view our PostGIS data):
    • Download and install Postgres 9.6.4 - Though there is a 64-bit version available, please select the 32-bit version. The additional computing power is not really necessary for what we're doing. If you go on to use Postgres in a production environment, you may want to go with the 64-bit version then.
      When running the installation you will need to have access to the Internet.

      - When prompted to provide a password for the superuser (postgres) specify a password you will remember. Using a user name/password combination of postgres/postgres might be smart, you can always change the password later.
      - Leave the Port set to 5432.
      - After Postgres is installed, you'll be asked if you want to launch the Stack Builder, a separate package that allows for the installation of add-ons to Postgres. Check the box for Stack Builder may be used... and in the next window choose PostgreSQL 9.6 (x86) on Port 5432 as the installation you are installing software for.
      - Under the category of Spatial Extensions, choose the PostGIS 2.3. Bundle... Installing this add-on will enable you to execute the spatial queries covered in Lessons 3-4.
      - Make your way through the installation accepting the defaults.  When the Choose Components dialog appears, check the Create spatial database box. 
      - Answer Yes when asked whether you'd like to register the GDAL_DATA environment variable.
      - Answer Yes to set the POSTGIS_ENABLED_DRIVERS variable to common values.
      - Answer Yes to enable out db rasters.

    • Installing PostGIS if Postgres is already installed - A separate installer file is available for the version that accompanies the 32-bit version of Postgres. If for some reason you do not use the Stack Builder noted above, you can use this installer. From the PostGIS Home page follow the Download link. Under the Binary Installers heading follow the Windows Downloads link. Under Released Versions follow the first windows download link (about 8 paragraphs down), which will take you to an Index list of installer versions. Go into the pg96 directory. Download the following installer:
    • Install QGIS - click the QGIS Standalone Installer Version 2.18 32-bit link under the Windows heading and run the downloaded setup file to install QGIS. 
  2. In addition to these software downloads please also download and unzip the data needed for the Lesson 3 data zip here.
  3. Work through Lesson 3 here on the course website.
  4. Complete Project 3 and upload its deliverables to the Project 3 Drop Box in Canvas.
  5. Complete the Lesson 3 Quiz in Canvas.