id en en en en fr en en en pt en id en en en en en en ca en en ca en en en en en en en pa en en en en en en en en en en en en en en en en en en en en uk en en en en en en en en en en ar en en eo en az en de en en en en
The PostGIS Team is pleased to release the third alpha of upcoming PostGIS 3.1.0 release. This version is exposes some of the new performance and feature enhancements in not yet relesed GEOS 3.9 as well as numerous speed enhancements not requiring newer GEOS. Requires GEOS 3.6+ and PostgreSQL 9.6+. To use MVT you will need protobuf-c 1.1. or higher.
PostgreSQL 13.1, GEOS 3.7 or higher is recommended.
View all tickets for 3.1.0 milestone.
#4737, Bump minimum protobuf-c requirement to 1.1.0 (Raúl Marín) The configure step will now fail if the requirement isn't met or explicitly disabled (--without-protobuf)
#4258, Untangle postgis_sfcgal from postgis into its own lib file (Regina Obe)
#4698, Add a precision parameter to ST_AsEWKT (Raúl Marín)
Add a gridSize optional parameter to ST_Union, ST_UnaryUnion, ST_Difference, ST_Intersection, ST_SymDifference, ST_Subdivide Requires GEOS 3.9 (Sandro Santilli)
#4789, Speed up TopoJSON output for areal TopoGeometry with many holes (Sandro Santilli)
#4758, Improve topology noding robustness (Sandro Santilli)
Make ST_Subdivide interruptable (Sandro Santilli)
#4660, Changes in double / coordinate printing (Raúl Marín)
Use the shortest representation (enough to guarantee roundtrip).
Uses scientific notation for absolute numbers smaller than 1e-8. The previous behaviour was to output 0 for absolute values smaller than 1e-12 and fixed notation for anything bigger than that.
Uses scientific notation for absolute numbers greater than 1e+15 (same behaviour).
The precision parameter now also affects the scientific notation (before it was fixed [5-8]).
All output functions now respect the requested precision (without any limits).
The default precision is the same (9 for GeoJSON, 15 for everything else).
#4729, WKT/KML: Print doubles directly into stringbuffers (Raúl Marín)
#4533, Use the standard coordinate printing system for box types (Raúl Marín)
#4686, Avoid decompressing geographies when possible (Raúl Marín) Affects ANALYZE, _ST_PointOutside, postgis_geobbox, ST_CombineBbox(box2d, geometry), ST_ClipByBox2D when the geometry is fully inside or outside the bbox and ST_BoundingDiagonal.
#4741, Don't use ST_PointInsideCircle if you need indexes, use ST_DWithin instead. Documentation adjusted (Darafei Praliaskouski)
#4737, Improve performance and reduce memory usage in ST_AsMVT, especially in queries involving parallelism (Raúl Marín)
#4746, Micro optimizations to the serialization process (Raúl Marín)
#4719, Fail fast when srids don't match ST_Intersection(geometry,raster) Also schema qualify calls in function. (Regina Obe)
#4784, Add ST_CollectionExtract(geometry) with default behaviour of extracting the components of highest coordinate dimension. (Paul Ramsey)
#4691, Fix segfault during gist index creation with empty geometries (Raúl Marín)
Fix handling of bad WKB inputs (Oracle types) and unit tests for malformed WKB. Remove memory leaks in malformed WKB cases. (Paul Ramsey)
#4740, Round values in geography_distance_tree as we do on geography_distance (Raúl Marín, Paul Ramsey, Regina Obe)
#4739, Ensure all functions using postgis_oid initialize the internal cache (Raúl Marín)
#4767, #4768, #4771, #4772, Fix segfault when parsing invalid WKB (Raúl Marín)
#4769, Fix segfault in ST_AddBand (Raúl Marín)
#4790, Fix ST_3dintersects calculations with identical vertices (Nicklas Avén)
#4742, tiger geocoder reverted to 2018 version on tiger upgrade (Regina Obe)
#3372, TopoElementArray cannot be null - change domain constraint (Regina Obe)
Upgrading postgis_sfcgal to 3.1 or higher
NEWS 197 EVENTS 15 TIPS 13 CASESTUDY 9 RFCS 3
RELEASE 158 EVENTS 19 2.4 16 2.1 14 2.3 14 3 14 2.5 13 3.1 13 NEWBIE 13 2.2 10 EOL 10 1 9 3.2 9 1.1 8
0.11 0.21 0.51 0.63 0.76 0.7.01 0.83 0.93 19 1.04 1.18 1.22 1.36 1.43 1.58 27 2.114 2.210 2.314 2.416 2.513 314 3.01 3.113 3.29 3.37 3D1 ACADEMIC1 AGRICULTURE1 AWARDS1 BIOINFORMATICS1 BRAZIL1 CZ1 DATA-VISUALIZATION1 DECISION-SUPPORT1 DEVELOPERS1 EOL10 EVENTS19 FDW1 FOSS4G4 FRANCE1 GEOCONCEPT1 GEOGRAPHY3 GEOMETRY5 GEOS2 GEOS-2.12 GHANA1 GOVERNMENT1 GSOC1 HANGOUT1 IMAGERY1 NEUROSCIENCE1 NEWBIE13 OGC1 OGR1 ORACLE1 OSDB21 OSGIS1 PGCON2 PGCONEU1 PGOPEN1 PGROUTING1 PGSESSIONS1 PHD1 POSTGISDAY7 POSTGRESVISION2 POWER-USAGE1 PROJ1 PROPERTY-APPRAISAL2 RASTER4 RELEASE158 RESEARCH1 SFCGAL2 SFSQL1 ST_COVEREDBY1 ST_DWITHIN1 ST_FLIPCOORDINATES1 ST_INTERSECTION1 ST_INTERSECTS1 ST_SETSRID1 ST_TRANSFORM1 ST_VALUE1 ST_VALUECOUNT1 TILE-SERVER1 UK1 UNIVERSITY1 UPGRADE4 URBAN-RESEARCH1 US5 WEB-APPS1