Packt Sale — 2 books for the price of one

Now I feel like a salesman. I feel obliged to mention the Packt buy one get one free sale (ends tomorrow): http://www.packtpub.com/?utm_source=referral&utm_medium=marketingPR&utm_campaign=2000thTitle If you want a postgresql title to go with the PostGIS Cookbook (just sayin’): http://www.packtpub.com/search?keys=postgresql&sort=0&types=0&forthcoming=1&available=1&count=20&op=Go Ok. Enough. Back to fun reading:   Continue reading Packt Sale — 2 books for the price of one

PostGIS Cookbook(s)

This is starting to feel real… PostGIS Cookbook(s).  2904 pages. Page count for a single book can be calculated as in the following code: The preceding query will result in the following: A special thanks to my family, my co-authors, all the contributors to PostGIS, and to Regina Obe for helping me through the hardest bit of code in my part of the book. Check … Continue reading PostGIS Cookbook(s)

Book Complete

For all following along at home, the PostGIS Cookbook is complete!  At 484 pages it’s a tome– but a great one (It’s been out for a few days, actually). A shout out to my brilliant co-authors, Paolo, Bborie, and Tom. I could not have hoped for better. http://www.packtpub.com/postgis-to-store-organize-manipulate-analyze-spatial-data-cookbook/book And for any who wonder, the picture on the front is of the Maumee River, the largest … Continue reading Book Complete

2.5D TINs in PostGIS

(edited: changed TIN to TIN Z) (edited again — function already exists as a flag in ST_DelaunayTriangles… .) Uh, I wrote a function for nothin’… As Regina points out in the commments, this functionality was rolled into 2.1 with a flag. Her example: For the record, my code is about 2% slower on a dataset that takes ~50minutes to triangulate . —————————————— Original Post —————————————— … Continue reading 2.5D TINs in PostGIS

UAS (drone) Footprint Geometries Calculated in PostGIS with SFCGAL — for real this time

In my earlier post, I made a claim that SFCGAL was used in this figure: It dawned on my afterwards, while I was using 3D, I hadn’t actually employed any of the analysis goodies that come with SFCGAL.  Well, here it is– a footprint as calculated using the view angles and a real terrain model: Here it is compared with the initial calculation: Continue reading UAS (drone) Footprint Geometries Calculated in PostGIS with SFCGAL — for real this time

More cutting room floor stuff… — 3D pyramid maker

A little more leftover code from the PostGIS Cookbook— a little tool for making pyramids for SFCGAL enabled PostGIS databases. https://github.com/smathermather/postgis-etc/blob/master/3D/pyramidMaker.sql Edit:  Actually, I think this would work without SFCGAL, but what would be the point… . Edit 2:  Let’s embed some code:   Continue reading More cutting room floor stuff… — 3D pyramid maker