{"id":15554,"date":"2025-09-18T10:00:00","date_gmt":"2025-09-18T08:00:00","guid":{"rendered":"https:\/\/www.sigterritoires.fr\/?p=15554"},"modified":"2025-10-14T10:01:34","modified_gmt":"2025-10-14T08:01:34","slug":"publication-de-postgis-3-6-la-3d-le-raster-et-la-topologie-passent-a-la-vitesse-superieure","status":"publish","type":"post","link":"https:\/\/www.sigterritoires.fr\/index.php\/publication-de-postgis-3-6-la-3d-le-raster-et-la-topologie-passent-a-la-vitesse-superieure\/","title":{"rendered":"Publication de PostGIS 3.6 \u2013 La 3D, le raster et la topologie passent \u00e0 la vitesse sup\u00e9rieure"},"content":{"rendered":"\n

\n\n\n\n\n\n\n

\n\n\n\n

Nouvelle version : PostGIS<\/a> 3.6.0<\/strong> (Publi\u00e9e le 2 septembre 2025)<\/p>\n\n\n\n

PostGIS 3.6.0<\/strong> est disponible depuis le 2 septembre 2025<\/strong>. Elle est con\u00e7ue pour fonctionner avec PostgreSQL 12 \u00e0 18 beta 3<\/strong>, n\u00e9cessite GEOS 3.8+<\/strong> (avec des optimisations pour GEOS 3.14+) et Proj 6.1+<\/strong>. Pour activer toutes les fonctionnalit\u00e9s de SFCGAL<\/strong>, la version 2.2.0+<\/strong> est requise.(PostGIS<\/a>)<\/p>\n\n\n\n

\n\n\n\n
\n
\n
Contenu <\/p>\n Toggle<\/span>
Disponibilit\u00e9 et t\u00e9l\u00e9chargement de PostGIS<\/a>
Conseils pratiques<\/a><\/li><\/ul><\/li>
Compatibilit\u00e9 & environnements requis<\/a><\/li>
Nouvelles fonctionnalit\u00e9s marquantes<\/a>
3D \/ SFCGAL :<\/a><\/li>
Couverture & topologie :<\/a><\/li>
Traitements raster :<\/a><\/li><\/ul><\/li>
Changements majeurs \/ Breaking changes \u00e0 noter<\/a><\/li>
Processus de mise \u00e0 jour<\/a><\/li>
Cas d\u2019usage avanc\u00e9s<\/a>
Nettoyage de couverture impure<\/a><\/li>
Reclassification de raster<\/a><\/li>
Simulation 3D simple<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n
<\/span>Disponibilit\u00e9 et t\u00e9l\u00e9chargement de PostGIS<\/span><\/h2>\n\n\n\n
PostGIS est l\u2019extension spatiale la plus utilis\u00e9e pour PostgreSQL, mais sa disponibilit\u00e9 varie selon le syst\u00e8me d\u2019exploitation et la version de PostgreSQL. Il est important de choisir la version stable adapt\u00e9e \u00e0 votre environnement pour \u00e9viter les probl\u00e8mes de compatibilit\u00e9 et assurer la fiabilit\u00e9 de vos traitements g\u00e9ospatiaux.<\/p>\n\n\n\n
Le tableau ci-dessous r\u00e9sume les versions stables et exp\u00e9rimentales disponibles selon les principaux syst\u00e8mes\u202f:<\/p>\n\n\n\n
Syst\u00e8me<\/th> Version PostgreSQL<\/th> Version PostGIS stable<\/th> Version exp\u00e9rimentale \/ Beta<\/th> Lien de t\u00e9l\u00e9chargement \/ Installation<\/th><\/tr><\/thead>
Windows<\/strong><\/td> 15<\/td> 3.5.3<\/td> 3.6 (tests uniquement)<\/td> Via StackBuilder inclus dans PostgreSQL : Extensions > Spatial Extensions > PostGIS 3.5.3<\/code> Documentation PostGIS Windows<\/a><\/td><\/tr>
Ubuntu \/ Debian<\/strong><\/td> 15<\/td> 3.5<\/td> 3.6 (compilation source)<\/td> sudo apt install postgis postgresql-15-postgis-3.5<\/code> PostGIS packages Ubuntu\/Debian<\/a><\/td><\/tr>
RedHat \/ CentOS \/ Fedora<\/strong><\/td> 15<\/td> 3.5<\/td> 3.6 (compilation source)<\/td> sudo dnf install postgis31_15<\/code> PostGIS packages RPM<\/a><\/td><\/tr>
Linux (toutes distros)<\/strong><\/td> Toutes<\/td> Compilation source<\/td> Derni\u00e8re version dev (3.6+)<\/td> PostGIS source<\/a><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
<\/span>Conseils pratiques<\/strong><\/span><\/h3>\n\n\n\n
\n
La version 3.6<\/strong> n\u2019est pas encore officiellement disponible sur Windows.<\/li>\n\n\n\n
Les versions exp\u00e9rimentales sont destin\u00e9es uniquement aux tests et \u00e0 la d\u00e9couverte des nouvelles fonctionnalit\u00e9s.<\/li>\n\n\n\n
Sur Windows, StackBuilder facilite l\u2019installation et la mise \u00e0 jour des d\u00e9pendances.<\/li>\n\n\n\n
Sur Linux, la compilation depuis les sources permet d\u2019acc\u00e9der aux derni\u00e8res fonctionnalit\u00e9s, mais n\u00e9cessite une configuration correcte de PostgreSQL et des biblioth\u00e8ques de d\u00e9veloppement.<\/li>\n<\/ul>\n\n\n\n
\n\n\n\n
<\/span>Compatibilit\u00e9 & environnements requis<\/span><\/h2>\n\n\n\n
\n
Version compatibles<\/strong> : PostgreSQL 12 \u2192 18 beta 3<\/li>\n\n\n\n
Pr\u00e9-requis essentiels<\/strong> :\n\n
GEOS \u2265 3.8, id\u00e9alement 3.14+ pour performance et nouvelles fonctions<\/li>\n\n\n\n
PROJ \u2265 6.1<\/li>\n\n\n\n
SFCGAL \u2265 2.2 pour exploiter pleinement les fonctions 3D (PostGIS<\/a>)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
\n\n\n\n
<\/span>Nouvelles fonctionnalit\u00e9s marquantes<\/span><\/h2>\n\n\n\n
<\/span>3D \/ SFCGAL :<\/span><\/h3>\n\n\n\n
\n
CG_Simplify<\/code>, CG_3DAlphaWrapping<\/code> pour la manipulation d\u2019\u00e9l\u00e9ments 3D<\/li>\n\n\n\n
Transformations g\u00e9om\u00e9triques : mise \u00e0 l\u2019\u00e9chelle, rotation, translation, buffer 3D, etc. (PostGIS<\/a>)<\/li>\n<\/ul>\n\n\n\n<\/span>Couverture & topologie :<\/span><\/h3>\n\n\n\n\nST_CoverageClean(...)<\/code><\/strong> : assure une couverture propre (sans chevauchements, bords align\u00e9s, remplissage des \u00e9carts). Exemple d\u2019utilisation : CREATE TABLE example_clean AS SELECT id, ST_CoverageClean(geom) OVER () AS geom FROM example;<\/code> Utile pour valider la g\u00e9om\u00e9trie d\u2019un coverage. (PostGIS<\/a>)<\/li>\n<\/ul>\n\n\n\n<\/span>Traitements raster :<\/span><\/h3>\n\n\n\n\nST_AsRasterAgg<\/code> : convertit efficacement une g\u00e9om\u00e9trie en raster durant l\u2019agr\u00e9gation.<\/li>\n\n\n\n ST_ReclassExact<\/code> : reclassification rapide et pr\u00e9cise des valeurs de raster.<\/li>\n\n\n\n ST_IntersectionFractions<\/code> : calcul des fractions de superposition des cellules raster avec UE g\u00e9om\u00e9trique (n\u00e9cessite GEOS 3.14).<\/li>\n\n\n\npostgis.gdal_cpl_debug<\/code> (GUC) : journalisation des messages GDAL<\/a> dans PostgreSQL. (PostGIS<\/a>)<\/li>\n<\/ul>\n\n\n\n \n\n\n\n<\/span>Changements majeurs \/ Breaking changes \u00e0 noter<\/span><\/h2>\n\n\n\n\nST_TileEnvelope<\/code><\/strong> : les enveloppes sont d\u00e9sormais restreintes \u00e0 l\u2019\u00e9tendue des tuiles (tile plane extent). (PostGIS<\/a>)<\/li>\n\n\n\n geometry_columns<\/code> : suppression des v\u00e9rifications de contraintes, impactant anciens workflows. (PostGIS<\/a>)<\/li>\n\n\n\n D\u00e9pr\u00e9ciation des fonctions topologiques integer<\/code><\/strong> : d\u00e9sormais remplac\u00e9es par leur version bigint<\/code>. (PostGIS<\/a>)<\/li>\n\n\n\n Changement pour TIN \/ PolyhedralSurface<\/strong> : utiliser ST_NumPatches<\/code> et ST_PatchN<\/code> \u00e0 la place de ST_NumGeometries<\/code>, qui ne renvoient plus les sous-geometries. (PostGIS<\/a>)<\/li>\n\n\n\n Suppression de st_approxquantile(raster, double precision)<\/code><\/strong>, inutilisable dans la pratique. (PostGIS<\/a>)<\/li>\n<\/ul>\n\n\n\n \n\n\n\n<\/span>Processus de mise \u00e0 jour<\/span><\/h2>\n\n\n\nPour migrer vers PostGIS 3.6 (3.0 \u00e0 3.6) :<\/p>\n\n\n <\/div> <\/div><\/div><\/div><\/p>\n\n\n\nSELECT postgis_extensions_upgrade();\n<\/code><\/pre>\n\n\n\n<\/div><\/div>\n\n\n\n Pour les versions \u2264 2.5 :<\/p>\n\n\n <\/div> <\/div><\/div><\/div>\n\n\n\nALTER EXTENSION postgis UPDATE; SELECT postgis_extensions_upgrade(); \u00ab\u00a0` :contentReference[oaicite:10]{index=10} <\/div><\/div> Nota : lancer ces commandes apr\u00e8s migration PostgreSQL<\/strong> ou restauration des extensions.<\/p>\n\n\n\n <\/span>Cas d\u2019usage avanc\u00e9s<\/span><\/h2>\n\n\n\n<\/span>Nettoyage de couverture impure<\/span><\/h3>\n\n\n\n <\/p>\n\n\n <\/div> <\/div><\/div><\/div><\/p>\n\n\n\n WITH dirty AS ( SELECT id, geom FROM coverage_table ) SELECT id, ST_AsText(ST_CoverageInvalidEdges(geom) OVER ()) AS invalid_geom FROM dirty; CREATE TABLE coverage_clean AS SELECT id, ST_CoverageClean(geom) OVER () FROM dirty; SELECT id, ST_AsText(ST_CoverageInvalidEdges(geom) OVER ()) FROM coverage_clean; <\/div><\/div>\n\n\n\n <\/span>Reclassification de raster<\/span><\/h3>\n\n\n<\/div> <\/div><\/div><\/div><\/p>\n\n\n\nSELECT ST_ReclassExact(rast, '[(1,10,100),(11,20,200)]') AS reclass_rast\nFROM raster_table;\n<\/code><\/pre>\n\n\n\n<\/div><\/div>\n\n\n\n <\/span>Simulation 3D simple<\/span><\/h3>\n\n\n<\/div> <\/div><\/div><\/div><\/p>\n\n\n\nSELECT CG_3DAlphaWrapping(geom) FROM building_wall;\n<\/code><\/pre>\n\n\n\n<\/div><\/div>\n\n\n\n \n\n\n\n<\/p>\n","protected":false},"excerpt":{"rendered":" Nouvelle version : PostGIS 3.6.0 (Publi\u00e9e le 2 septembre 2025) PostGIS 3.6.0 est disponible depuis le 2 septembre 2025. Elle est con\u00e7ue pour fonctionner avec PostgreSQL 12 \u00e0 18 beta 3, n\u00e9cessite GEOS 3.8+ (avec des…<\/p>\n","protected":false},"author":1,"featured_media":15556,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"give_campaign_id":0,"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"sfsi_plus_gutenberg_text_before_share":"","sfsi_plus_gutenberg_show_text_before_share":"","sfsi_plus_gutenberg_icon_type":"","sfsi_plus_gutenberg_icon_alignemt":"","sfsi_plus_gutenburg_max_per_row":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[3198],"tags":[3715,12,3711,17,2241],"class_list":["post-15554","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-postgis-fr","tag-3-6-fr","tag-3d","tag-postgsi","tag-raster","tag-topologie"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2025\/09\/postgis.jpg?fit=745%2C331&ssl=1","jetpack_shortlink":"https:\/\/wp.me\/p6XU0A-42S","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/posts\/15554","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/comments?post=15554"}],"version-history":[{"count":0,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/posts\/15554\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/media\/15556"}],"wp:attachment":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/media?parent=15554"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/categories?post=15554"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/tags?post=15554"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}