付録A リリースノート

#5688, [topology] トポロジー構築関数が許容値0 (以前のデフォルト値)を実際の0にして、-1 (新しいデフォルト値)が「トポロジーの精度」にするようにしました (Sandro Santilliさん)

#6024, PostgreSQL 12と13とへの対応を削除 (Regina Obeさん)

#6040, ST_GeoHashとST_GeomFromGeoHashとの往復 (Paul Ramseyさん)

#6053, [address_standardizer] エクステンションの削除とhttps://github.com/postgis/address_standardizerへの移動 (Paul Ramseyさん)

#6052, [tiger_geocoder] エクステンションの削除とhttps://git.osgeo.org/postgis/postgis_tiger_geocoderへの移動 (Regina Obeさん)

#6079, GEOS < 3.10対応を削除 (Sandro Santilliさん)

#1793, 集約関数ST_MemCollectを削除 (Darafei Praliaskouskiさん)

GH-848, CG_AlphaShapeはマルチポリゴンを返すようになりました (Jean Felderさん)

#1124, #2935, #3033, #4658, #4659, [loader] ローダー引数の手直し: shp2pgsqlはUNLOGGEDテーブルを作ることができ、地物IDカラム名を選択することができます。shp2pgsql --drop-tableは準備より前にDROP TABLEを吐くことができます。raster2pgsql/shp2pgsqlはローダーのどうさタイプを長いオプション名で指定できます。両方のローダー共に既存オプションの長い別名を受け付けることができます。また、

-if-not-existsでべき等アクションを生成します (Darafei Praliaskouskiさん)

#4208, ST_MaxDistanceとST_LongestLineにおいて単一ジオメトリーに対応する形式を追加しました。

[topology] FindVertexSegmentPairsBelowDistance関数 (Sandro Santilliさん)

ポリゴンカバレッジの明確にエッジを共有しているマルチラインストリングを返すST_CoverageEdges (Paul Ramseyさん)

最小接続木を計算するウィンドウ関数ST_MinimumSpanningTree (Paul Ramseyさん)

#5993, [topology] TopoGeo_AddLinestringへのmax_edgesパラメーターの追加 (Sandro Santilliさん)

#6001, ST_MakeLineのマルチラインストリング対応 (Paul Ramseyさん)

#2858, ST_MMinとST_MMax (Paul Ramseyさん)

#5941, [raster] GDALピクセルタイプGDT_Float16対応 (Darafei Praliaskouskiさん)

#5992, トポロジーでのエッジ分割の繰返しでのGiSTインデックス最適化 (Darafei Praliaskouskiさん)

#5702, Allow the compiler to detect the parallelism -flto=auto (Darafei Praliaskouski)

#4798, ST_AsGeoJSON warns about duplicate property keys (Darafei Praliaskouski)

#5950, Document POSTGIS_REGRESS_DB_OWNER for sandboxed regression roles (Darafei Praliaskouski)

#4332, Clarify the scope of several Function Reference categories (Darafei Praliaskouski)

#4222, [raster] ST_DumpAsPolygons honours PostgreSQL interrupts (Darafei Praliaskouski)

#5109, Document the meaning of topology.next_left_edge and topology.next_right_edge links (Darafei Praliaskouski)

#5889, [topology] Include representative locations in topology build errors (Darafei Praliaskouski)

#2614, Use GEOSPreparedDistance and caching to accelerate ST_DWithin (Paul Ramsey)

#6022, Document ST_AsMVTGeom tile-coordinate simplification (Darafei Praliaskouski)

GH-839, ST_Multi support for TIN and surfaces (Loïc Bartoletti)

#4398, Add ST_CatmullSmoothing smoothes but retains original vertices (Paul Ramsey)

#4560, ST_3DInterpolatePoint for M interpolation from XYZ inputs (Paul Ramsey)

#1291, ST_MakePolygonの曲線リング対応 (Darafei Praliaskouskiさん)

GT-270, NURBS曲線の追加 (Loïc Bartolettiさん)

#2863, 次元補助ST_XSize, ST_YSize, ST_ZSize, ST_MSizeの追加 (Darafei Praliaskouskiさん)

[fuzzers] Centralize OSS-Fuzz build/dependency logic in PostGIS scripts, prefer requested CXX over pg_config --cc for internal C++ checks, and make fuzzer linking/runtime dependency packaging portable (Darafei Praliaskouski)

#2045, pgsql2shp query dumps no longer require temporary table privileges (Darafei Praliaskouski)

#1577, [loader] Report unsupported .zip archive input before trying to open shapefile sidecar files (Darafei Praliaskouski)

#3158, Move geometry and geography typmod bit helpers out of the public liblwgeom header (Darafei Praliaskouski)

#4678, [raster] Move st_sum4ma neighborhood callback to C (Darafei Praliaskouski)

#2116, [raster] Add ST_Value nearest-neighbor boundary options (Darafei Praliaskouski)

#2804, #4315, [raster] Support two-argument ST_MapAlgebra callbacks and pass callback call data as actual arguments (Darafei Praliaskouski)

#2898, Document SQL function cost tiers for contributors

#6062, [topology] Stop using recursive snapping, for improved robustness (Sandro Santilli)

#6065, Improved winding order computation robustness for rings having collapsed elements (Sandro Santilli)

#3743, #4385, [raster loader] Document raster2pgsql -s FROM_SRID:SRID reprojection support and clarify index creation timing for append loads (Darafei Praliaskouski)

#2137, [raster] Reuse matching source raster overviews in raster2pgsql -l (Darafei Praliaskouski)

#4749, Use point-in-polygon predicate fast paths for point-only GeometryCollections (Darafei Praliaskouski)

#5532, Validate the manual against DocBook XMLSchema in check-xml (Darafei Praliaskouski)

#6087, Add a repository-owned CI status checker and static dashboard generator (Darafei Praliaskouski)

#2807, [raster] Preserve missing NODATA values in ST_MapAlgebra outputs (Darafei Praliaskouski)

#2832, [raster] Avoid padding single-tile raster2pgsql overviews when padding is not requested (Darafei Praliaskouski)

#2623, Generate a pgsql2shp GID field when exporting geometry-only shapefiles (Darafei Praliaskouski)

#2850, Preserve pgsql2shp numeric precision and scale in DBF metadata (Darafei Praliaskouski)

#2386, Add raster2pgsql man page (Darafei Praliaskouski)

Build PostgreSQL extension modules with `-fno-semantic-interposition` when available so LTO can optimize same-DSO calls to exported PostGIS entry points directly instead of routing through the module PLT; in a local PostgreSQL 18 `pgbench` microbenchmark over 100k four-point groups this reduced `ST_Collect` aggregate latency by about 4% (Darafei Praliaskouski)

#5973, Install PostGIS utilities under `pg_config --bindir` by default and document `pg_config`-derived install paths more accurately (Darafei Praliaskouski)

#2808, Clarify postgis_full_version() output when installed component scripts are newer than core scripts (Darafei Praliaskouski)

#5593, Docs: render manual images with GraphicsMagick without temporary files, enabling parallel builds, keeping ImageMagick fallbacks working, and documenting the generator workflow for contributors (Darafei Praliaskouski)

#5645, Docs: keep code operators ("=>") intact in translated manuals by enforcing verbatim CSS (Darafei Praliaskouski)

#1408, Docs: flatten transparent manual images onto white backgrounds for PDF builds while keeping HTML images transparent (Darafei Praliaskouski)

#2838, Emit valid X3D Coordinate nodes for 2D polygon output (Darafei Praliaskouski)

#1705, Infer constraint metadata for direct view and materialized view geometry columns (Darafei Praliaskouski)

GH-899, [raster] Honor PostgreSQL interrupts in long-running GDAL progress callbacks (Darafei Praliaskouski)

#2583, Preserve Z/ZM dimensional qualifiers in ST_AsEWKT output for TIN (Darafei Praliaskouski)