Category: Other

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

Unknown's avatarsmathermather6 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

Unknown's avatarsmathermather3 Comments
Other, PostGIS, PostgreSQL, SQL

Happy #postgis day, everybody! A big and fun day

All goes well, the PostGIS Cookbook will be out in January here’s some of the official info: If you are a web developer or a software architect, … and want to expand the range of techniques you are using with PostGIS, then this book is for you… . An easy-to-use guide, full of hands-on recipes for manipulating spatial data in a PostGIS database. Each topic … Continue reading Happy #postgis day, everybody! A big and fun day

Unknown's avatarsmathermather2 Comments