Nova vers\u00e3o: PostGIS 3.6.0 (lan\u00e7ada em 2 de setembro de 2025)<\/p>\n\n\n\n

O PostGIS 3.6.0 est\u00e1 dispon\u00edvel desde 2 de setembro de 2025. Ele foi projetado para funcionar com o PostgreSQL 12 a 18 beta 3, requer GEOS 3.8+ (com otimiza\u00e7\u00f5es para GEOS 3.14+) e Proj 6.1+. Para ativar todos os recursos do SFCGAL, \u00e9 necess\u00e1ria a vers\u00e3o 2.2.0+. (PostGIS)<\/p>\n\n\n\n

<\/span>Disponibilidade e download do PostGIS<\/span><\/h2>\n\n\n\n
O PostGIS \u00e9 a extens\u00e3o espacial mais utilizada para o PostgreSQL, mas sua disponibilidade varia de acordo com o sistema operacional e a vers\u00e3o do PostgreSQL. \u00c9 importante escolher a vers\u00e3o est\u00e1vel adequada ao seu ambiente para evitar problemas de compatibilidade e garantir a confiabilidade de seus processamentos geoespaciais.<\/p>\n\n\n\n
A tabela abaixo resume as vers\u00f5es est\u00e1veis e experimentais dispon\u00edveis de acordo com os principais sistemas:<\/p>\n\n\n\n
Sistema<\/th> Vers\u00e3o PostgreSQL<\/th> Vers\u00e3o PostGIS est\u00e1vel<\/th> Vers\u00e3o experimental \/ Beta<\/th> Link para download \/ Instala\u00e7\u00e3o<\/th><\/tr><\/thead>
Windows<\/strong><\/td> 15<\/td> 3.5.3<\/td> 3.6 (apenas testes)<\/td> Via StackBuilder inclu\u00eddo no PostgreSQL: Extens\u00f5es > Extens\u00f5es espaciais > PostGIS 3.5.3 Documentation PostGIS Windows<\/a><\/td><\/tr>
Ubuntu \/ Debian<\/strong><\/td> 15<\/td> 3.5<\/td> 3.6 (compila\u00e7\u00e3o de c\u00f3digo-fonte)<\/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 (compila\u00e7\u00e3o de c\u00f3digo-fonte)<\/td> `sudo dnf install postgis31_15<\/code> PostGIS packages RPM<\/a><\/td><\/tr>`
Linux(todas as distribui\u00e7\u00f5es)<\/strong><\/td> Todas<\/td> Compila\u00e7\u00e3o de c\u00f3digo-fonte<\/td> \u00daltima vers\u00e3o dev (3.6+)<\/td> PostGIS source<\/a><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\n\n\n\n
<\/span>Dicas pr\u00e1ticas<\/span><\/h2>\n\n\n\n
\n
A vers\u00e3o 3.6 ainda n\u00e3o est\u00e1 oficialmente dispon\u00edvel para Windows.<\/li>\n\n\n\n
As vers\u00f5es experimentais destinam-se apenas a testes e \u00e0 descoberta de novas funcionalidades.<\/li>\n\n\n\n
No Windows, o StackBuilder facilita a instala\u00e7\u00e3o e a atualiza\u00e7\u00e3o das depend\u00eancias.<\/li>\n\n\n\n
No Linux, a compila\u00e7\u00e3o a partir das fontes permite aceder \u00e0s funcionalidades mais recentes, mas requer uma configura\u00e7\u00e3o correta do PostgreSQL e das bibliotecas de desenvolvimento.<\/li>\n<\/ul>\n\n\n\n
\n\n\n\n
<\/span>Compatibilidade e ambientes necess\u00e1rios<\/span><\/h2>\n\n\n\n
\n
Vers\u00f5es compat\u00edveis: PostgreSQL 12 \u2192 18 beta 3<\/li>\n\n\n\n
Pr\u00e9-requisitos essenciais:\n
\n
GEOS \u2265 3.8, idealmente 3.14+ para desempenho e novas fun\u00e7\u00f5es<\/li>\n\n\n\n
PROJ \u2265 6.1<\/li>\n\n\n\n
SFCGAL \u2265 2.2 para explorar plenamente as fun\u00e7\u00f5es 3D (PostGIS<\/a>)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
\n\n\n\n
<\/span>Novas funcionalidades importantes<\/span><\/h2>\n\n\n\n
CG_Simplify, CG_3DAlphaWrapping para manipula\u00e7\u00e3o de elementos 3D<\/p>\n\n\n\n
Transforma\u00e7\u00f5es geom\u00e9tricas: escala, rota\u00e7\u00e3o, transla\u00e7\u00e3o, buffer 3D, etc. (PostGIS)<\/p>\n\n\n\n
Cobertura e topologia:<\/p>\n\n\n\n
ST_CoverageClean(…): garante uma cobertura limpa (sem sobreposi\u00e7\u00f5es, bordas alinhadas, preenchimento de lacunas). Exemplo de uso: CREATE TABLE example_clean AS SELECT id, ST_CoverageClean(geom) OVER () AS geom FROM example; \u00datil para validar a geometria de uma cobertura. (PostGIS)<\/p>\n\n\n\n
Processamentos raster:<\/p>\n\n\n\n
ST_AsRasterAgg: converte eficientemente uma geometria em raster durante a agrega\u00e7\u00e3o.<\/p>\n\n\n\n
ST_ReclassExact: reclassifica\u00e7\u00e3o r\u00e1pida e precisa dos valores raster.<\/p>\n\n\n\n
ST_IntersectionFractions: c\u00e1lculo das fra\u00e7\u00f5es de sobreposi\u00e7\u00e3o das c\u00e9lulas raster com UE geom\u00e9trica (requer GEOS 3.14).<\/p>\n\n\n\n
postgis.gdal_cpl_debug (GUC): registro de mensagens GDAL no PostgreSQL. (PostGIS)<\/p>\n\n\n\n
Altera\u00e7\u00f5es importantes\/altera\u00e7\u00f5es significativas a serem observadas<\/p>\n\n\n\n
ST_TileEnvelope: os envelopes agora est\u00e3o restritos \u00e0 extens\u00e3o dos blocos (tile plane extent). (PostGIS)<\/p>\n\n\n\n
geometry_columns: remo\u00e7\u00e3o das verifica\u00e7\u00f5es de restri\u00e7\u00f5es, afetando fluxos de trabalho antigos. (PostGIS)<\/p>\n\n\n\n
Deprecia\u00e7\u00e3o das fun\u00e7\u00f5es topol\u00f3gicas integer: agora substitu\u00eddas por sua vers\u00e3o bigint. (PostGIS)<\/p>\n\n\n\n
Altera\u00e7\u00e3o para TIN \/ PolyhedralSurface: use ST_NumPatches e ST_PatchN em vez de ST_NumGeometries, que n\u00e3o retornam mais as subgeometrias. (PostGIS)<\/p>\n\n\n\n
Remo\u00e7\u00e3o de st_approxquantil<\/p>\n\n\n\n
<\/span>3D \/ SFCGAL :<\/span><\/h3>\n\n\n\n
\n
`CG_Simplify<\/code>, CG_3DAlphaWrapping<\/code> para manipula\u00e7\u00e3o de elementos 3D<\/li>\n\n\n\n`
`Transforma\u00e7\u00f5es geom\u00e9tricas: escala, rota\u00e7\u00e3o, transla\u00e7\u00e3o, buffer 3D, etc.. (`PostGIS<\/a>)<\/li>\n<\/ul>\n\n\n\n<\/span>Cobertura e topologia:<\/span><\/h3>\n\n\n\n\nST_CoverageClean(...)<\/code><\/strong> : garante uma cobertura limpa (sem sobreposi\u00e7\u00f5es, bordas alinhadas, preenchimento de lacunas). Exemplo de uso: CREATE TABLE example_clean AS SELECT id, ST_CoverageClean(geom) OVER () AS geom FROM example; \u00datil para validar a geometria de uma cobertura. (PostGIS<\/a>)<\/li>\n<\/ul>\n\n\n\n<\/span>Processamentos raster:<\/span><\/h3>\n\n\n\n\nST_AsRasterAgg<\/code> : converte eficientemente uma geometria em raster durante a agrega\u00e7\u00e3o.<\/li>\n\n\n\n ST_ReclassExact<\/code> : reclassifica\u00e7\u00e3o r\u00e1pida e precisa dos valores raster.<\/li>\n\n\n\n ST_IntersectionFractions<\/code> : c\u00e1lculo das fra\u00e7\u00f5es de sobreposi\u00e7\u00e3o das c\u00e9lulas raster com UE geom\u00e9trica (requer GEOS 3.14).<\/li>\n\n\n\npostgis.gdal_cpl_debug<\/code> (GUC) : registro de mensagens GDAL no PostgreSQL. (PostGIS<\/a>)<\/li>\n<\/ul>\n\n\n\n \n\n\n\n<\/span>Altera\u00e7\u00f5es importantes\/altera\u00e7\u00f5es significativas a serem observadas<\/span><\/h2>\n\n\n\n\nST_TileEnvelope<\/code><\/strong> : os envelopes agora est\u00e3o restritos \u00e0 extens\u00e3o dos blocos (tile plane extent). (PostGIS<\/a>)<\/li>\n\n\n\n geometry_columns<\/code> : remo\u00e7\u00e3o das verifica\u00e7\u00f5es de restri\u00e7\u00f5es, afetando fluxos de trabalho antigos. (PostGIS<\/a>)<\/li>\n\n\n\n Deprecia\u00e7\u00e3o das fun\u00e7\u00f5es topol\u00f3gicas integer:<\/strong> agora substitu\u00eddas por sua vers\u00e3o bigint. (PostGIS<\/a>)<\/li>\n\n\n\n Altera\u00e7\u00e3o para TIN \/ PolyhedralSurface: <\/strong>use ST_NumPatches <\/em>e ST_PatchN <\/em>em vez de ST_NumGeometries<\/em>, que n\u00e3o retornam mais as subgeometrias. (PostGIS<\/a>)<\/li>\n\n\n\n Remo\u00e7\u00e3o de st_approxquantile<\/strong>(raster, precis\u00e3o dupla), inutiliz\u00e1vel na pr\u00e1tica.(PostGIS<\/a>)<\/li>\n<\/ul>\n\n\n\n \n\n\n\n<\/span>Processo de atualiza\u00e7\u00e3o<\/span><\/h2>\n\n\n\nPara migrar para o PostGIS 3.6 (3.0 para 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 Para vers\u00f5es \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> Observa\u00e7\u00e3o: execute esses comandos ap\u00f3s a migra\u00e7\u00e3o do PostgreSQL ou a restaura\u00e7\u00e3o das extens\u00f5es.<\/p>\n\n\n\n <\/span>Casos de uso avan\u00e7ados<\/span><\/h2>\n\n\n\n<\/span>Limpeza de cobertura impura<\/span><\/h3>\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>Reclassifica\u00e7\u00e3o 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>Simula\u00e7\u00e3o 3D simples<\/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","protected":false},"excerpt":{"rendered":" Nova vers\u00e3o: PostGIS 3.6.0 (lan\u00e7ada em 2 de setembro de 2025) O PostGIS 3.6.0 est\u00e1 dispon\u00edvel desde 2 de setembro de 2025. Ele foi projetado para funcionar com o PostgreSQL 12 a 18 beta 3, requer…<\/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_post_was_ever_published":false,"_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":""},"categories":[2136],"tags":[3707,3709,2158,3134,2243],"class_list":["post-15664","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-postgis","tag-3-6","tag-3d-pt","tag-postgis-pt","tag-raster-pt","tag-topologia"],"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-44E","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/posts\/15664","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=15664"}],"version-history":[{"count":0,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/posts\/15664\/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=15664"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/categories?post=15664"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/tags?post=15664"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}

Sistema<\/th>	Vers\u00e3o PostgreSQL<\/th>	Vers\u00e3o PostGIS est\u00e1vel<\/th>	Vers\u00e3o experimental \/ Beta<\/th>	Link para download \/ Instala\u00e7\u00e3o<\/th><\/tr><\/thead>
Windows<\/strong><\/td>	15<\/td>	3.5.3<\/td>	3.6 (apenas testes)<\/td>	Via StackBuilder inclu\u00eddo no PostgreSQL: Extens\u00f5es > Extens\u00f5es espaciais > PostGIS 3.5.3 Documentation PostGIS Windows<\/a><\/td><\/tr>
Ubuntu \/ Debian<\/strong><\/td>	15<\/td>	3.5<\/td>	3.6 (compila\u00e7\u00e3o de c\u00f3digo-fonte)<\/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 (compila\u00e7\u00e3o de c\u00f3digo-fonte)<\/td>	`sudo dnf install postgis31_15<\/code> PostGIS packages RPM<\/a><\/td><\/tr>`
Linux(todas as distribui\u00e7\u00f5es)<\/strong><\/td>	Todas<\/td>	Compila\u00e7\u00e3o de c\u00f3digo-fonte<\/td>	\u00daltima vers\u00e3o dev (3.6+)<\/td>	PostGIS source<\/a><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n \n\n\n\n <\/span>Dicas pr\u00e1ticas<\/span><\/h2>\n\n\n\n \n A vers\u00e3o 3.6 ainda n\u00e3o est\u00e1 oficialmente dispon\u00edvel para Windows.<\/li>\n\n\n\n As vers\u00f5es experimentais destinam-se apenas a testes e \u00e0 descoberta de novas funcionalidades.<\/li>\n\n\n\n No Windows, o StackBuilder facilita a instala\u00e7\u00e3o e a atualiza\u00e7\u00e3o das depend\u00eancias.<\/li>\n\n\n\n No Linux, a compila\u00e7\u00e3o a partir das fontes permite aceder \u00e0s funcionalidades mais recentes, mas requer uma configura\u00e7\u00e3o correta do PostgreSQL e das bibliotecas de desenvolvimento.<\/li>\n<\/ul>\n\n\n\n \n\n\n\n <\/span>Compatibilidade e ambientes necess\u00e1rios<\/span><\/h2>\n\n\n\n \n Vers\u00f5es compat\u00edveis: PostgreSQL 12 \u2192 18 beta 3<\/li>\n\n\n\n Pr\u00e9-requisitos essenciais:\n \n GEOS \u2265 3.8, idealmente 3.14+ para desempenho e novas fun\u00e7\u00f5es<\/li>\n\n\n\n PROJ \u2265 6.1<\/li>\n\n\n\n SFCGAL \u2265 2.2 para explorar plenamente as fun\u00e7\u00f5es 3D (PostGIS<\/a>)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n \n\n\n\n <\/span>Novas funcionalidades importantes<\/span><\/h2>\n\n\n\n CG_Simplify, CG_3DAlphaWrapping para manipula\u00e7\u00e3o de elementos 3D<\/p>\n\n\n\n Transforma\u00e7\u00f5es geom\u00e9tricas: escala, rota\u00e7\u00e3o, transla\u00e7\u00e3o, buffer 3D, etc. (PostGIS)<\/p>\n\n\n\n Cobertura e topologia:<\/p>\n\n\n\n ST_CoverageClean(…): garante uma cobertura limpa (sem sobreposi\u00e7\u00f5es, bordas alinhadas, preenchimento de lacunas). Exemplo de uso: CREATE TABLE example_clean AS SELECT id, ST_CoverageClean(geom) OVER () AS geom FROM example; \u00datil para validar a geometria de uma cobertura. (PostGIS)<\/p>\n\n\n\n Processamentos raster:<\/p>\n\n\n\n ST_AsRasterAgg: converte eficientemente uma geometria em raster durante a agrega\u00e7\u00e3o.<\/p>\n\n\n\n ST_ReclassExact: reclassifica\u00e7\u00e3o r\u00e1pida e precisa dos valores raster.<\/p>\n\n\n\n ST_IntersectionFractions: c\u00e1lculo das fra\u00e7\u00f5es de sobreposi\u00e7\u00e3o das c\u00e9lulas raster com UE geom\u00e9trica (requer GEOS 3.14).<\/p>\n\n\n\n postgis.gdal_cpl_debug (GUC): registro de mensagens GDAL no PostgreSQL. (PostGIS)<\/p>\n\n\n\n Altera\u00e7\u00f5es importantes\/altera\u00e7\u00f5es significativas a serem observadas<\/p>\n\n\n\n ST_TileEnvelope: os envelopes agora est\u00e3o restritos \u00e0 extens\u00e3o dos blocos (tile plane extent). (PostGIS)<\/p>\n\n\n\n geometry_columns: remo\u00e7\u00e3o das verifica\u00e7\u00f5es de restri\u00e7\u00f5es, afetando fluxos de trabalho antigos. (PostGIS)<\/p>\n\n\n\n Deprecia\u00e7\u00e3o das fun\u00e7\u00f5es topol\u00f3gicas integer: agora substitu\u00eddas por sua vers\u00e3o bigint. (PostGIS)<\/p>\n\n\n\n Altera\u00e7\u00e3o para TIN \/ PolyhedralSurface: use ST_NumPatches e ST_PatchN em vez de ST_NumGeometries, que n\u00e3o retornam mais as subgeometrias. (PostGIS)<\/p>\n\n\n\n Remo\u00e7\u00e3o de st_approxquantil<\/p>\n\n\n\n <\/span>3D \/ SFCGAL :<\/span><\/h3>\n\n\n\n \n `CG_Simplify<\/code>, CG_3DAlphaWrapping<\/code> para manipula\u00e7\u00e3o de elementos 3D<\/li>\n\n\n\n` `Transforma\u00e7\u00f5es geom\u00e9tricas: escala, rota\u00e7\u00e3o, transla\u00e7\u00e3o, buffer 3D, etc.. (`PostGIS<\/a>)<\/li>\n<\/ul>\n\n\n\n<\/span>Cobertura e topologia:<\/span><\/h3>\n\n\n\n\nST_CoverageClean(...)<\/code><\/strong> : garante uma cobertura limpa (sem sobreposi\u00e7\u00f5es, bordas alinhadas, preenchimento de lacunas). Exemplo de uso: CREATE TABLE example_clean AS SELECT id, ST_CoverageClean(geom) OVER () AS geom FROM example; \u00datil para validar a geometria de uma cobertura. (PostGIS<\/a>)<\/li>\n<\/ul>\n\n\n\n<\/span>Processamentos raster:<\/span><\/h3>\n\n\n\n\nST_AsRasterAgg<\/code> : converte eficientemente uma geometria em raster durante a agrega\u00e7\u00e3o.<\/li>\n\n\n\n ST_ReclassExact<\/code> : reclassifica\u00e7\u00e3o r\u00e1pida e precisa dos valores raster.<\/li>\n\n\n\n ST_IntersectionFractions<\/code> : c\u00e1lculo das fra\u00e7\u00f5es de sobreposi\u00e7\u00e3o das c\u00e9lulas raster com UE geom\u00e9trica (requer GEOS 3.14).<\/li>\n\n\n\npostgis.gdal_cpl_debug<\/code> (GUC) : registro de mensagens GDAL no PostgreSQL. (PostGIS<\/a>)<\/li>\n<\/ul>\n\n\n\n \n\n\n\n<\/span>Altera\u00e7\u00f5es importantes\/altera\u00e7\u00f5es significativas a serem observadas<\/span><\/h2>\n\n\n\n\nST_TileEnvelope<\/code><\/strong> : os envelopes agora est\u00e3o restritos \u00e0 extens\u00e3o dos blocos (tile plane extent). (PostGIS<\/a>)<\/li>\n\n\n\n geometry_columns<\/code> : remo\u00e7\u00e3o das verifica\u00e7\u00f5es de restri\u00e7\u00f5es, afetando fluxos de trabalho antigos. (PostGIS<\/a>)<\/li>\n\n\n\n Deprecia\u00e7\u00e3o das fun\u00e7\u00f5es topol\u00f3gicas integer:<\/strong> agora substitu\u00eddas por sua vers\u00e3o bigint. (PostGIS<\/a>)<\/li>\n\n\n\n Altera\u00e7\u00e3o para TIN \/ PolyhedralSurface: <\/strong>use ST_NumPatches <\/em>e ST_PatchN <\/em>em vez de ST_NumGeometries<\/em>, que n\u00e3o retornam mais as subgeometrias. (PostGIS<\/a>)<\/li>\n\n\n\n Remo\u00e7\u00e3o de st_approxquantile<\/strong>(raster, precis\u00e3o dupla), inutiliz\u00e1vel na pr\u00e1tica.(PostGIS<\/a>)<\/li>\n<\/ul>\n\n\n\n \n\n\n\n<\/span>Processo de atualiza\u00e7\u00e3o<\/span><\/h2>\n\n\n\nPara migrar para o PostGIS 3.6 (3.0 para 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 Para vers\u00f5es \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> Observa\u00e7\u00e3o: execute esses comandos ap\u00f3s a migra\u00e7\u00e3o do PostgreSQL ou a restaura\u00e7\u00e3o das extens\u00f5es.<\/p>\n\n\n\n <\/span>Casos de uso avan\u00e7ados<\/span><\/h2>\n\n\n\n<\/span>Limpeza de cobertura impura<\/span><\/h3>\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>Reclassifica\u00e7\u00e3o 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>Simula\u00e7\u00e3o 3D simples<\/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","protected":false},"excerpt":{"rendered":" Nova vers\u00e3o: PostGIS 3.6.0 (lan\u00e7ada em 2 de setembro de 2025) O PostGIS 3.6.0 est\u00e1 dispon\u00edvel desde 2 de setembro de 2025. Ele foi projetado para funcionar com o PostgreSQL 12 a 18 beta 3, requer…<\/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_post_was_ever_published":false,"_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":""},"categories":[2136],"tags":[3707,3709,2158,3134,2243],"class_list":["post-15664","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-postgis","tag-3-6","tag-3d-pt","tag-postgis-pt","tag-raster-pt","tag-topologia"],"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-44E","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/posts\/15664","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=15664"}],"version-history":[{"count":0,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/posts\/15664\/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=15664"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/categories?post=15664"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/tags?post=15664"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}

<\/span>Compatibilidade e ambientes necess\u00e1rios<\/span><\/h2>\n\n\n\n\nVers\u00f5es compat\u00edveis: PostgreSQL 12 \u2192 18 beta 3<\/li>\n\n\n\n

<\/span>3D \/ SFCGAL :<\/span><\/h3>\n\n\n\n\nCG_Simplify<\/code>, CG_3DAlphaWrapping<\/code> para manipula\u00e7\u00e3o de elementos 3D<\/li>\n\n\n\n