Le Sat, Mar 08, 2025 at 07:10:05PM +0100, Landry Breuil a écrit :
> hi,
> 
> now that boost ships its cmake modules, the sfcgal wip i had lying
> arouund finally builds ootb, and all tests pass;
> 
> SFCGAL is a C++ wrapper library around CGAL with the aim of supporting
> ISO 19107:2013 and OGC Simple Features Access 1.2 for 3D operations.
> 
> SFCGAL provides standard compliant geometry types and operations.
> PostGIS uses the C API, to expose some SFCGAL's functions in spatial
> databases.
> 
> www: https://sfcgal.gitlab.io/SFCGAL/
> 
> the second diff is to enable the support in postgis.
> 
> feedback/oks welcome.

oks still welcome, reattaching for convenience.

? fail310.log
? patch-liblwgeom_cunit_cu_geodetic_c
? patch-postgis_Makefile_in
? postgis-2.2.2-liblwgeom-2.2.so.0.0
? postgis-2.2.2-liblwgeom.so.0.0
? q
? test-2.3.0.log
? test-2.3.0_2.log
? test-2.3.2.log
? test-2.4.1.log
? test-2.4.3.log
? test-2.4.4.log
? pkg/PLIST.x
Index: Makefile
===================================================================
RCS file: /cvs/ports/geo/postgis/Makefile,v
diff -u -r1.94 Makefile
--- Makefile	20 Jan 2025 08:01:36 -0000	1.94
+++ Makefile	8 Mar 2025 18:02:30 -0000
@@ -4,7 +4,7 @@
 COMMENT=	geographic objects support for PostgreSQL
 DISTNAME=	postgis-${V}
 CATEGORIES=	geo databases
-REVISION=	0
+REVISION=	1
 
 HOMEPAGE=	http://www.postgis.net/
 
@@ -20,6 +20,7 @@
 WANTLIB += nghttp3 ngtcp2 ngtcp2_crypto_quictls jxl jxl_cms jxl_threads zip
 WANTLIB += archive b2 brotlicommon brotlidec brotlienc bz2 hwy sharpyuv blosc deflate
 WANTLIB += Lerc aom arrow arrow_acero arrow_dataset avif dav1d parquet snappy thrift
+WANTLIB += SFCGAL gmp
 
 COMPILER =		base-clang ports-gcc base-gcc
 
@@ -29,6 +30,7 @@
 
 LIB_DEPENDS=	databases/sqlite3 \
 		geo/gdal \
+		geo/sfcgal \
 		devel/proj \
 		devel/gettext,-runtime \
 		devel/protobuf-c \
Index: pkg/PLIST
===================================================================
RCS file: /cvs/ports/geo/postgis/pkg/PLIST,v
diff -u -r1.54 PLIST
--- pkg/PLIST	20 Jan 2025 08:01:36 -0000	1.54
+++ pkg/PLIST	8 Mar 2025 18:02:30 -0000
@@ -8,6 +8,7 @@
 @so lib/postgresql/address_standardizer-3.so
 @so lib/postgresql/postgis-3.so
 @so lib/postgresql/postgis_raster-3.so
+@so lib/postgresql/postgis_sfcgal-3.so
 @so lib/postgresql/postgis_topology-3.so
 @man man/man1/pgsql2shp.1
 @man man/man1/pgtopo_export.1
@@ -319,7 +320,9 @@
 share/postgresql/contrib/postgis-3.5/rtpostgis.sql
 share/postgresql/contrib/postgis-3.5/rtpostgis_legacy.sql
 share/postgresql/contrib/postgis-3.5/rtpostgis_upgrade.sql
+share/postgresql/contrib/postgis-3.5/sfcgal.sql
 share/postgresql/contrib/postgis-3.5/sfcgal_comments.sql
+share/postgresql/contrib/postgis-3.5/sfcgal_upgrade.sql
 share/postgresql/contrib/postgis-3.5/spatial_ref_sys.sql
 share/postgresql/contrib/postgis-3.5/topology.sql
 share/postgresql/contrib/postgis-3.5/topology_comments.sql
@@ -327,6 +330,7 @@
 share/postgresql/contrib/postgis-3.5/uninstall_legacy.sql
 share/postgresql/contrib/postgis-3.5/uninstall_postgis.sql
 share/postgresql/contrib/postgis-3.5/uninstall_rtpostgis.sql
+share/postgresql/contrib/postgis-3.5/uninstall_sfcgal.sql
 share/postgresql/contrib/postgis-3.5/uninstall_topology.sql
 share/postgresql/extension/address_standardizer--1.0--${V}.sql
 share/postgresql/extension/address_standardizer--2.0.0--ANY.sql
@@ -799,6 +803,124 @@
 share/postgresql/extension/postgis_raster--unpackaged--${V}.sql
 share/postgresql/extension/postgis_raster--unpackaged.sql
 share/postgresql/extension/postgis_raster.control
+share/postgresql/extension/postgis_sfcgal--2.0.0--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.0.1--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.0.2--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.0.3--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.0.4--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.0.5--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.0.6--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.0.7--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.1.0--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.1.1--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.1.2--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.1.3--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.1.4--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.1.5--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.1.6--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.1.7--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.1.8--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.1.9--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.2.0--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.2.1--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.2.2--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.2.3--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.2.4--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.2.5--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.2.6--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.2.7--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.2.8--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.3.0--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.3.1--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.3.10--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.3.11--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.3.2--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.3.3--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.3.4--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.3.5--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.3.6--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.3.7--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.3.8--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.3.9--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.4.0--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.4.1--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.4.10--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.4.2--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.4.3--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.4.4--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.4.5--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.4.6--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.4.7--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.4.8--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.4.9--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.5.0--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.5.1--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.5.2--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.5.3--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.5.4--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.5.5--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.5.6--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.5.7--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.5.8--ANY.sql
+share/postgresql/extension/postgis_sfcgal--2.5.9--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.0.0--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.0.1--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.0.10--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.0.11--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.0.12--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.0.2--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.0.3--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.0.4--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.0.5--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.0.6--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.0.7--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.0.8--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.0.9--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.1.0--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.1.1--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.1.10--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.1.11--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.1.12--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.1.2--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.1.3--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.1.4--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.1.5--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.1.6--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.1.7--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.1.8--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.1.9--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.2.0--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.2.1--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.2.2--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.2.3--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.2.4--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.2.5--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.2.6--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.2.7--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.2.8--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.3.0--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.3.1--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.3.2--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.3.3--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.3.4--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.3.5--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.3.6--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.3.7--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.3.8--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.4.0--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.4.1--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.4.2--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.4.3--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.4.4--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.5.0--ANY.sql
+share/postgresql/extension/postgis_sfcgal--3.5.1--ANY.sql
+share/postgresql/extension/postgis_sfcgal--${V}--ANY.sql
+share/postgresql/extension/postgis_sfcgal--${V}.sql
+share/postgresql/extension/postgis_sfcgal--ANY--${V}.sql
+share/postgresql/extension/postgis_sfcgal--TEMPLATED--TO--ANY.sql
+share/postgresql/extension/postgis_sfcgal--unpackaged--${V}.sql
+share/postgresql/extension/postgis_sfcgal--unpackaged.sql
+share/postgresql/extension/postgis_sfcgal.control
 share/postgresql/extension/postgis_tiger_geocoder--2.0.0--ANY.sql
 share/postgresql/extension/postgis_tiger_geocoder--2.0.1--ANY.sql
 share/postgresql/extension/postgis_tiger_geocoder--2.0.2--ANY.sql

• sfcgal-2.tgz (2K)
• postgis-sfcgal.diff (10K)