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
ST_3DIntersection performs volumetric intersections for us in PostGIS, if we have SFCGAL enabled for our PostGIS back end. Much like a normal PostGIS intersection, this is the mathematical definition of an interesection, so it returns the volumetric portion of the intersection, plus 3D linestrings and 3D points and other bits and pieces that qualify for the intersection. As a little patch, I wrote a quick … Continue reading More cutting room floor stuff… .
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
GitHub week for me: https://github.com/smathermather/pov-viewshed More to come, but in the meantime, enjoy. Continue reading pov-viewshed on GitHub
I am working on a project, well, I guess just read the README from the repo (a project which will require a creative rename in the future): https://github.com/smathermather/shape-pov shape-pov ATM, this is a script to write shapefiles to PovRay docs for rendering. Long-term, will be a map tile renderer with 3D support and more. Whats more? Well, while compositing in TileMill and all the Mapnik … Continue reading shape-pov on GitHub
I’ve shared bits and pieces of tree interpolation code (3D tree canopies from LiDAR) on this blog for a few years. I finally got things together enough to post some of this code on GitHub. Currently it has a LasTools dependency, so you’ll have to watch for that license gotcha, but I’ll be phasing out that dependency in future versions. In the future, I’ll do … Continue reading Tree Interpolator on GitHub
Recent exploration into PostGIS 3D tools has reminded me of my love of renderers. First, there’s PovRay. PovRay is and always will be my first love. I’ve done so many fun things with it. In short, PovRay is a mathematicians renderer– mathematical primitives, advanced ray tracing tools, and a C-like control language make for an abstract but powerful environment. I like to use it with … Continue reading 3D Renderers– a woefully incomplete survey
Smathermather's Weblog 