Tag: PostGIS Cookbook

PostGIS, PostGIS Cookbook

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

smathermatherLeave a comment
Database, PostGIS, PostGIS Cookbook, PostgreSQL, SQL

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)

smathermather3 Comments
PostGIS

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

smathermatherLeave a comment
3D, Analysis, Database, Drone, Other, Photogrammetry, PostGIS, PostgreSQL, SQL, UAS

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

smathermather6 Comments
3D, Analysis, Database, Drone, Image Processing, Optics, Other, Photogrammetry, PostGIS, PostgreSQL, QGIS, SFCGAL, SQL, UAS

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

smathermather3 Comments
3D, Database, PostGIS, PostgreSQL, SFCGAL, SQL

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

smathermatherLeave a comment