Today I want to introduce you to another one of my really great undergraduate students: Jeff Scarmazzi. Jeff participated in the SUSRC conference that I posted about previously, but unfortunately, his photo and poster got deleted from my camera, so I never posted information about his project – I may eventually get around to posting Jeff’s poster, but for now it will have to wait.
Jeff is an exceptional student, and at this point can run circles around me with PostGIS, Leaflet, and Postgres – at the moment, I am still reserving the right to say that my spatial SQL is better than his, but that may not be true. And, now that Jeff secured a prestigious internship with NASA over the summer, once the Fall rolls around it definitely won’t be true!
What I wanted to show you was a short presentation that Jeff gave on his work with Postgres and PostGIS in my Advanced GIS class. For this project I had students create a geodatabase with ArcGIS that includes domains, subtypes, topology rules, etc. Jeff decided to extend his work on this assignment and recreate the same kind of features using Postgres and PostGIS. This presentation is just a small piece of what Jeff and his fellow students (Austin Barefoot, Carl Flint, and Jordan Roose) created, and focuses specifically on writing triggers and creating roles to automate and quality check digitizing procedures using Postgres.
The presentation is only about 15 minutes long, and you’ll be amazed to see what you can do with PostGIS to creating robust editing rules.
Warning Shameless plug: In case you wanted to learn how to implement PostGIS in an enterprise setting, check out my online course here. Also, I have another course on how to write spatial SQL with PostGIS here.