GIS6105 Lab 2

Physical Spatial Database Design

In this lab we were provided with a scenario for Beaches and house values. Or first task was to create an ERD using 4 identified entities. I used Lucidchart to make my crows foot ERD.

 

The next task we were given was to write an run SQL to create an inflation_index table. Once that was successfully completed we had to import data to fill our tables and provide screenshots of the results. (We utilized a LIMIT clause to stop at the first 10 results)

After completion, we had to determine the correct SRID for our ShapeFile and properly import it into the PGSQL database. Once this was accomplished we again utilized the LIMIT clause to list the first 10 records from the resulting table.

This class was my first exposure to PostGIS. Much of the code reminds me of Python which I found to be intimidating.