(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
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
UAS (drone) Footprint Geometries Calculated in PostGIS (viewed in QGIS nightly), taking into account relative elevation, bearing, pitch, and roll: Continue reading UAS (drone) Footprint Geometries Calculated in PostGIS with SFCGAL
Still working furiously on final edits for the PostGIS Cookbook. My last chapter is the last one that the Packt editors and managers are waiting for, but it will be the best I’ve contributed to the book, so I think it will be worth everyone’s time. The trick with this chapter is that when I first wrote it, it was before the heavy lifting the … Continue reading O man. Epic 3D on its way. I could drone on and on about #postgis
I have been working a bit to get horao working to visualize PostGIS 3D data. In the mean time, I have a little work around for viewing 3D extrudes a 3Dish way (i.e. isometric) The nightly build of QGIS now allows you to visualize polyhedral surfaces, the output type of ST_Extrude. So, I cheated. ST_Extrude takes 4 parameters: an input geometry, and extrusion along the … Continue reading ST_Extrude screen shot: PostGIS with SFCGAL
The guys from Oslandia are really ripping things up in the PostGIS 3D world. (They are nice guys too– Olivier and Hugo had a skeletonization approach punched up and ready to test before I left the Boston Code Sprint this past Spring.) So I missed these two videos in my first few views of the SFCGAL website: ————————————————————————————- Just one question– what is “Horoa plugin … Continue reading PostGIS with SFCGAL — Videos, how did I miss these videos?
So, for those of you who haven’t seen it, SFCGAL, “a C++ wrapper library around CGAL with the aim of supporting ISO 19107:2013 and OGC Simple Features Access 1.2 for 3D operations” is now an optional include in PostGIS (I believe beginning with 2.1, forgive me if I’m wrong). This was a quiet outcome of the Boston Code Sprint, after Paul Ramsey declared exact rational number … Continue reading PostGIS with SFCGAL
Smathermather's Weblog 