PostgreSQL , SFCGAL , 3D
PostGIS 整合 SFCGAL，優雅的處理3D空間資料。
<a href="https://github.com/digoal/blog/blob/master/201710/20171026_02_pdf_001.pdf">PDF: 3D and exact geometries for PostGIS , FOSDEM PGDay</a>
<a href="http://www.sfcgal.org/">http://www.sfcgal.org/</a>
<a href="https://www.tuicool.com/articles/jAjIBn">https://www.tuicool.com/articles/jAjIBn</a>
<a href="https://wiki.postgresql.org/images/3/36/Postgis_3d_pgday2013_hm.pdf">https://wiki.postgresql.org/images/3/36/Postgis_3d_pgday2013_hm.pdf</a>
<a href="http://postgis.net/docs/manual-2.4/reference.html">http://postgis.net/docs/manual-2.4/reference.html</a>
This was a quiet outcome of the Boston Code Sprint, after Paul Ramsey declared exact rational number representation would not make its way into PostGIS.
(I promise, that’s the only animated gif I’ll ever do, hat tip James Fee who did it for years before it was cool).
What does this mean for a typical PostGIS user? Well, so far it adds a nice suite of new 2D and 3D functions :
ST_Extrude is fun，this is a function for doing things like this:
Simulated extruded building footprints.
Extruded footprints from (ahem) City Engine. Ssssh. Don’t tell.
ST_StraightSkeleton does in one step the first phase of what I’ve been going on about for a couple years re: Voronoi diagrams (and bypasses Voronoi altogether):
Approximation of straight skeleton / skeletonization of stream polygon。
Plus more! I’ve just started exploring.