GIS6105 Lab3

Vector Operations

For this lab our first assignment was to revise the ERD we created in our prior lab. 

 I had already included attributes and spatial data types in my original ERD. The main change that I made was the relationship between beaches and parcel sales. After working on lab 3 it became clear that there is a direct relationship between proximity to the beach and the parcel sales. In my original ERD I did not have any relationship between beaches and parcel sales.

Next, we were asked to write and run SQL that would return parcel point parcelid and associated distances to the beaches line. We also had to visually check the points distances using ArcGIS Pro.

Our next task was to write and run SQL to find real home values. The results of our query were expected to return pin and real price columns.