Lab 3 - Vector Operations in PostGIS
Building on from Lab 2, where we created a physical database with entities relevant to a study of home values and proximity to beaches, in this new lab we completed scripts in SQL (which by the way use a combination of spatial and non-spatial functions) to answer the following 3 questions:
Because I shouldn't show all my script answers in this blog so that other students don't cheat, I provided only one screenshot of my final SQL statement and the results returned of parcel points and their associated distance to the beaches line (answer to Question 1).
- How far is each parcel point from the beach?
- What is the average (inflation-adjusted) value for a given parcel based on historical sales?
- Do homes that are near the beach tend to be more expensive?
Because I shouldn't show all my script answers in this blog so that other students don't cheat, I provided only one screenshot of my final SQL statement and the results returned of parcel points and their associated distance to the beaches line (answer to Question 1).
Comments
Post a Comment