Tag: Skeletonization

Analysis, Database, PostGIS, PostgreSQL, SQL

ST_ApproximateMedialAxis(geom)

Trying out PostGIS 2.2’s ST_ApproximateMedialAxis capabilities today. I’m going to use it to label parcels. So here is my parcel fabric: And here’s what the skeleton of that fabric looks like: It get’s pretty interesting where the parcels are more complicated: more: Oh, the code you say? Well, it couldn’t be much easier: SELECT gid, ST_ApproximateMedialAxis(geom) AS geom FROM cuy_parcel_2015; Or the full version for … Continue reading ST_ApproximateMedialAxis(geom)

Unknown's avatarsmathermather2 Comments
3D, Analysis, Database, PostGIS, PostgreSQL, SQL

PostGIS with SFCGAL — Videos, how did I miss these videos?

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?

Unknown's avatarsmathermather3 Comments
3D, Analysis, Database, PostGIS, PostgreSQL, SQL

PostGIS with SFCGAL

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

Unknown's avatarsmathermather2 Comments