Yup, I’m going for hits with the above title. So, I’ve been playing with triggers in PostGIS (PostgreSQL) trying to streamline a process that I go through quarterly. We have a geographic boundary layer for our public entity: The green area is the area with public access. The purple without. I want to maintain a version of the boundary with this very simple distinction, and … Continue reading PostGIS Triggers
So, loading was easy, and all worked well. Viewing was fine. What is my gripe? B-tree Indexing. What if I wanted to ensure I had only unique geometric records in my database? Continue reading PostGIS Gripe—Limits to Postgre’s B-tree indexing
Well, I have to put it out there: is this an original, the one and only PostGIS onesie? My son was born recently, and as he was sleeping quietly, I surfed to the PostGIS website. One look at that baby elephant icon, and another to our newborn, and I realized I had the perfect inspiration, so time to go make my own onesie, and start … Continue reading PostGIS Onesie
Smathermather's Weblog 