-
Notifications
You must be signed in to change notification settings - Fork 1
/
NEWS
2063 lines (1820 loc) · 83.5 KB
/
NEWS
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
PostGIS 2.3.1
2016/11/28
* Bug Fixes
- #1973, st_concavehull() returns sometimes empty geometry collection
Fix from gde
- #3501, add raster constraint max extent exceeds array size limit
for large tables
- #3643, PostGIS not building on latest OSX XCode
- #3644, Deadlock on interrupt
- #3650, Mark ST_Extent, ST_3DExtent and ST_Mem*
agg functions as parallel safe so they can be parallelized
- #3652, Crash on Collection(MultiCurve())
- #3656, Fix upgrade of aggregates from 2.2 or lower version
- #3659, Crash caused by raster GUC define after CREATE EXTENSION
using wrong memory context. (manaeem)
- #3665, Index corruption and memory leak in BRIN indexes
patch from Julien Rouhaud (Dalibo)
- #3667, geography ST_Segmentize bug
patch from Hugo Mercier (Oslandia)
PostGIS 2.3.0
2016/09/26
* Important / Breaking Changes *
- #3466, Casting from box3d to geometry now returns a 3D
geometry (Julien Rouhaud of Dalibo)
- #3604, pgcommon/Makefile.in orders CFLAGS incorrectly leading to
wrong liblwgeom.h (Greg Troxel)
- #3396, ST_EstimatedExtent, throw WARNING instead of ERROR
(Regina Obe)
* Deprecated signatures *
* New Features *
- Add support for custom TOC in postgis_restore.pl
(Christoph Moench-Tegeder)
- Add support for negative indexing in ST_PointN and ST_SetPoint
(Rémi Cura)
- Add parameters for geography ST_Buffer (Thomas Bonfort)
- TopoGeom_addElement, TopoGeom_remElement (Sandro Santilli)
- populate_topology_layer (Sandro Santilli)
- #454, ST_WrapX and lwgeom_wrapx (Sandro Santilli)
- #1758, ST_Normalize (Sandro Santilli)
- #2236, shp2pgsql -d now emits "DROP TABLE IF EXISTS"
- #2259, ST_VoronoiPolygons and ST_VoronoiLines (Dan Baston)
- #2841 and #2996, ST_MinimumBoundingRadius and new ST_MinimumBoundingCircle
implementation using Welzl's algorithm (Dan Baston)
- #2991, Enable ST_Transform to use PROJ.4 text (Mike Toews)
- #3059, Allow passing per-dimension parameters in ST_Expand (Dan Baston)
- #3339, ST_GeneratePoints (Paul Ramsey)
- #3362, ST_ClusterDBSCAN (Dan Baston)
- #3364, ST_GeometricMedian (Dan Baston)
- #3391, Add table inheritance support in ST_EstimatedExtent
(Alessandro Pasotti)
- #3424, ST_MinimumClearance (Dan Baston)
- #3428, ST_Points (Dan Baston)
- #3465, ST_ClusterKMeans (Paul Ramsey)
- #3469, ST_MakeLine with MULTIPOINTs (Paul Norman)
- #3549, Support PgSQL 9.6 parallel query mode, as far as possible
(Paul Ramsey, Regina Obe)
- #3557, Geometry function costs based on query stats (Paul Norman)
- #3591, Add support for BRIN indexes. PostgreSQL 9.4+ required.
(Giuseppe Broccolo of 2nd Quadrant, Julien Rouhaud
and Ronan Dunklau of Dalibo)
- #3496, Make postgis non-relocateable for extension install,
schema qualify calls in functions (Regina Obe)
Should resolve once and for all for extensions #3494, #3486, #3076
- #3547, Update tiger geocoder to support TIGER 2016
and to support both http and ftp.
- #3613, Segmentize geography using equal length segments
(Hugo Mercier of Oslandia)
* Bug Fixes
- #2841, ST_MinimumBoundingCircle not covering original
* Performance Enhancements *
- #75, Enhancement to PIP short circuit (Dan Baston)
- #3383, Avoid deserializing small geometries during index operations
(Dan Baston)
- #3400, Minor optimization of PIP routines (Dan Baston)
- Make adding a line to topology interruptible (Sandro Santilli)
- Documentation updates from Mike Toews
PostGIS 2.3.0beta1
2016/09/06
See PostGIS 2.3.0 section for details
PostGIS 2.2.2
2016/03/22
* Bug Fixes *
- #3463, Fix crash on face-collapsing edge change
- #3422, Improve ST_Split robustness on standard precision double
systems (arm64, ppc64el, s390c, powerpc, ...)
- #3427, Update spatial_ref_sys to EPSG version 8.8
- #3433, ST_ClusterIntersecting incorrect for MultiPoints
- #3435, ST_AsX3D fix rendering of concave geometries
- #3436, memory handling mistake in ptarray_clone_deep
- #3437, ST_Intersects incorrect for MultiPoints
- #3461, ST_GeomFromKML crashes Postgres when there are
innerBoundaryIs and no outerBoundaryIs
- #3429, upgrading to 2.3 or from 2.1 can cause loop/hang on some platforms
- #3460, ST_ClusterWithin 'Tolerance not defined' error after upgrade
- #3490, Raster data restore issues, materialized views
Scripts postgis_proc_set_search_path.sql,
rtpostgis_proc_set_search_path.sql refer to
http://postgis.net/docs/manual-2.2/RT_FAQ.html#faq_raster_data_not_restore
- #3426, failing POINT EMPTY tests on fun architectures
PostGIS 2.2.1
2016/01/06
* Bug Fixes *
- #2232, avoid accumulated error in SVG rounding
- #3321, Fix performance regression in topology loading
- #3329, Fix robustness regression in TopoGeo_addPoint
- #3349, Fix installation path of postgis_topology scripts
- #3351, set endnodes isolation on ST_RemoveIsoEdge
(and lwt_RemIsoEdge)
- #3355, geography ST_Segmentize has geometry bbox
- #3359, Fix toTopoGeom loss of low-id primitives from
TopoGeometry definition
- #3360, _raster_constraint_info_scale invalid input syntax
- #3375, crash in repeated point removal for collection(point)
- #3378, Fix handling of hierarchical TopoGeometries
in presence of multiple topologies
- #3380, #3402, Decimate lines on topology load
- #3388, #3410, Fix missing end-points in ST_RemoveRepeatedPoints
- #3389, Buffer overflow in lwgeom_to_geojson
- #3390, Compilation under Alpine Linux 3.2 gives an error when
compiling the postgis and postgis_topology extensions
- #3393, ST_Area NaN for some polygons
- #3401, Improve ST_Split robustness on 32bit systems
- #3404, ST_ClusterWithin crashes backend
- #3407, Fix crash on splitting a face or an edge
defining multiple TopoGeometry objects
- #3411, Clustering functions not using spatial index
- #3412, Improve robustness of snapping step in TopoGeo_addLinestring
- #3415, Fix OSX 10.9 build under pkgsrc
- Fix memory leak in lwt_ChangeEdgeGeom [liblwgeom]
PostGIS 2.2.0
2015/10/07
* Important / Breaking Changes *
- PROJ4 4.6 and higher only
- #2703, KNN <-> operator now returns the correct distance ordering
for all geometry types, not just for points. Code that expects
the looser "centroid distance" ordering should be updated.
- #3022, ValidateTopology swapped meaning of id1 and id2 for the
'edge crosses node' error (now edge_id,node_id)
- #2565, ST_SummaryStats(tablename, rastercolumn, ...) uses
ST_SummaryStatsAgg()
- #2567, ST_Count(tablename, rastercolumn, ...) uses ST_CountAgg()
- #2842, raster - Hide unselectable tables from raster_overview
and raster_columns
- By default, PostGIS raster disables all GDAL drivers affecting
out-db rasters, ST_FromGDALRaster() and ST_AsGDALRaster() variants
- #3181, POINT EMPTY is now stored as POINT(NaN NaN) in WKB, instead of as MULTIPOINT EMPTY
- Java binding moved to separate repository:
https://github.com/postgis/postgis-java
* Deprecated signatures *
- #2748, ST_Shift_Longitude renamed to ST_ShiftLongitude,
ST_Find_Extent renamed to ST_FindExtent,
ST_Combine_BBox renamed to ST_CombineBbox,
ST_Length_Spheroid renamed to ST_LengthSpheroid,
ST_Distance_Spheroid renamed to ST_DistanceSpheroid,
ST_Distance_Sphere renamed to ST_DistanceSphere,
ST_3DLength_Spheroid deprecated (use ST_LengthSpheroid)
- #2769, ST_Mem_Size renamed to ST_MemSize
- #2565, ST_SummaryStats(tablename, rastercolumn, ...)
- #2567, ST_Count(tablename, rastercolumn, ...)
* New Features *
- Topology API in liblwgeom
(Sandro Santilli / Regione Toscana - SITA)
- New lwgeom_version method in liblwgeom
- New lwgeom_unaryunion method in liblwgeom
- New lwgeom_linemerge method in liblwgeom
- New lwgeom_is_simple method in liblwgeom
- #3117, Add SFCGAL 1.1 support: add ST_3DDifference, ST_3DUnion,
ST_Volume, ST_MakeSolid, ST_IsSolid (Vincent Mora / Oslandia)
- #3169, ST_ApproximateMedialAxis (Sandro Santilli)
- ST_CPAWithin (Sandro Santilli / Boundless)
- Add |=| operator with CPA semantic and KNN support with PgSQL 9.5+
(Sandro Santilli / Boundless)
- #3131, KNN support for the geography type (Paul Ramsey / CartoDB)
- #3023, ST_ClusterIntersecting / ST_ClusterWithin (Dan Baston)
- #2703, Exact KNN results for all geometry types, aka "KNN re-check" (Paul Ramsey / CartoDB)
- #1137, Allow a tolerance value in ST_RemoveRepeatedPoints (Paul Ramsey / CartoDB)
- #3062, Allow passing M factor to ST_Scale (Sandro Santilli / Boundless)
- #3139, ST_BoundingDiagonal (Sandro Santilli / Boundless)
- #3129, ST_IsValidTrajectory (Sandro Santilli / Boundless)
- #3128, ST_ClosestPointOfApproach (Sandro Santilli / Boundless)
- #3152, ST_DistanceCPA (Sandro Santilli / Boundless)
- Canonical output for index key types
- ST_SwapOrdinates (Sandro Santilli / Boundless)
- #2918, Use GeographicLib functions for geodetics (Mike Toews)
- #3074, ST_Subdivide to break up large geometry (Paul Ramsey / CartoDB)
- #3040, KNN GiST index based centroid (<<->>)
n-D distance operators (Sandro Santilli / Boundless)
- Interruptibility API for liblwgeom (Sandro Santilli / CartoDB)
- #2939, ST_ClipByBox2D (Sandro Santilli / CartoDB)
- #2247, ST_Retile and ST_CreateOverview: in-db raster overviews creation
(Sandro Santilli / Vizzuality)
- #899, -m shp2pgsql attribute names mapping -m switch
(Regina Obe / Sandro Santilli)
- #1678, Added GUC postgis.gdal_datapath to specify GDAL config
variable GDAL_DATA
- #2843, Support reprojection on raster import
(Sandro Santilli / Vizzuality)
- #2349, Support for encoded_polyline input/output (Kashif Rasul)
- #2159, report libjson version from postgis_full_version()
- #2770, ST_MemSize(raster)
- Add postgis_noop(raster)
- Added missing variants of ST_TPI(), ST_TRI() and ST_Roughness()
- Added GUC postgis.gdal_enabled_drivers to specify GDAL config
variable GDAL_SKIP
- Added GUC postgis.enable_outdb_rasters to enable access to
rasters with out-db bands
- #2387, address_standardizer extension as part of PostGIS
Stephen Woodbridge (imaptools.com), Walter Sinclair, Regina Obe
- #2816, address_standardizer_data_us extension
provides reference lex,gaz,rules for address_standardizer
Stephen Woodbridge (imaptools.com), Walter Sinclair, Regina Obe
- #2341, New mask parameter for ST_MapAlgebra
- #2397, read encoding info automatically in shapefile loader
- #2430, ST_ForceCurve
- #2565, ST_SummaryStatsAgg()
- #2567, ST_CountAgg()
- #2632, ST_AsGML() support for curved features
- #2652, Add --upgrade-path switch to run_test.pl
- #2754, sfcgal wrapped as an extension
- #2227, Simplification with Visvalingam-Whyatt algorithm
ST_SimplifyVW, ST_SetEffectiveArea (Nicklas Avén)
- Functions to encode and decode TWKB
ST_AsTWKB, ST_GeomFromTWKB (Paul Ramsey / Nicklas Avén / CartoDB)
* Enhancements *
- #3223, Add memcmp short-circuit to ST_Equals (Daniel Baston)
- #3227, Tiger geocoder upgraded to support Tiger 2015 census
- #2278, Make liblwgeom potentially ABI-compatible between micro releases
- #897, ST_AsX3D support for GeoCoordinates and systems "GD" "WE"
ability to flip x/y axis (use option = 2, 3)
- ST_Split: allow splitting lines by multilines, multipoints
and (multi)polygon boundaries
- #3070, Simplify geometry type constraint
- #2839, Implement selectivity estimator for functional indexes,
speeding up spatial queries on raster tables.
(Sandro Santilli / Vizzuality)
- #2361, Added spatial_index column to raster_columns view
- #2390, Testsuite for pgsql2shp
- #2527, Added -k flag to raster2pgsql to skip checking that
band is NODATA
- #2616, Reduce text casts during topology building and export
- #2717, support startpoint, endpoint, pointn, numpoints for compoundcurve
- #2747, Add support for GDAL 2.0
- #2754, SFCGAL can now be installed with CREATE EXTENSION
Vincent Mora (Oslandia)
- #2828, Convert ST_Envelope(raster) from SQL to C
- #2829, Shortcut ST_Clip(raster) if geometry fully contains the raster
and no NODATA specified
- #2906, Update tiger geocoder to handle tiger 2014 data
- #3048, Speed up geometry simplification (J.Santana @ CartoDB)
- #3092, Slow performance of geometry_columns with many tables
* Bug Fixes *
- #2893, Allow interruptibility of ST_Segmentize(geometry)
(Sandro Santilli / CartoDB)
- #2540, Change GUC name for GDAL_DATA to postgis.gdal_datapath
- #2777, Raster max extent constraint based upon envelope to behave
like geometry extent
- #2822, Use @ operator instead of ST_CoveredBy() for raster
max extent constraint
- #3018, GROUP BY geography sometimes returns duplicate rows
- #3020, ST_AddBand out-db bug where height using width value
- #3048, shp2pgsql - illegal number format when specific system locale set
- #3061, Allow duplicate points in JSON, GML, GML ST_GeomFrom* functions
- #3086, ST_DumpValues() crashes backend on cleanup with invalid
band indexes
* Code refactoring *
- Split raster/rt_core/rt_api.c and raster/rt_pg/rt_pg.c files into
smaller files for ease of long-term maintenance and development
- #1220, lwerror and lwnotice function became internal to liblwgeom
PostGIS 2.1.8
2015/07/07
* Bug Fixes *
- #3159, do not force a bbox cache on ST_Affine
- #3018, GROUP BY geography sometimes returns duplicate rows
- #3048, shp2pgsql - illegal number format when specific system locale set
- #3094, Malformed GeoJSON inputs crash backend
- #3104, st_asgml introduces random characters in ID field
- #3155, Remove liblwgeom.h on make uninstall
- #3177, gserialized_is_empty cannot handle nested empty cases
- Fix crash in ST_LineLocatePoint
PostGIS 2.1.7
2015/03/30
* Bug Fixes *
- #3086, ST_DumpValues() crashes backend on cleanup with invalid
band indexes
- #3088, Do not (re)define strcasestr in a liblwgeom.h
- #3094, Malformed GeoJSON inputs crash backend
PostGIS 2.1.6
2015/03/20
* Enhancements *
- #3000, Ensure edge splitting and healing algorithms use indexes
- #3048, Speed up geometry simplification (J.Santana @ CartoDB)
- #3050, Speep up geometry type reading (J.Santana @ CartoDB)
* Bug Fixes *
- #2941, allow geography columns with SRID other than 4326
- #3069, small objects getting inappropriately fluffed up w/ boxes
- #3068, Have postgis_typmod_dims return NULL for unconstrained dims
- #3061, Allow duplicate points in JSON, GML, GML ST_GeomFrom* functions
- #3058, Fix ND-GiST picksplit method to split on the best plane
- #3052, Make operators <-> and <#> available for PostgreSQL < 9.1
- #3045, Fix dimensionality confusion in &&& operator
- #3016, Allow unregistering layers of corrupted topologies
- #3015, Avoid exceptions from TopologySummary
- #3020, ST_AddBand out-db bug where height using width value
- #3031, Allow restore of Geometry(Point) tables dumped with empties in them
PostGIS 2.1.5
2014/12/18
* Enhancements *
- #2933, Speedup construction of large multi-geometry objects
* Bug Fixes *
- #2947, Fix memory leak in lwgeom_make_valid for single-component
collection input
- #2949, Fix memory leak in lwgeom_mindistance2d for curve input
- #2931, BOX representation is case sensitive
- #2942, PostgreSQL 9.5 support
- #2953, 2D stats not generated when Z/M values are extreme
- #3009, Geography cast may effect underlying tuple
PostGIS 2.1.4
2014/09/10
* Enhancements *
- #2745, Speedup ST_Simplify calls against points
- #2747, Support for GDAL 2.0
- #2749, Make rtpostgis_upgrade_20_21.sql ACID
- #2811, Do not specify index names when loading shapefiles/rasters
- #2829, Shortcut ST_Clip(raster) if geometry fully contains the raster
and no NODATA specified
- #2895, Raise cost of ST_ConvexHull(raster) to 300 for better query plans
* Bug Fixes *
- #2605, armel: _ST_Covers() returns true for point in hole
- #2911, Fix output scale on ST_Rescale/ST_Resample/ST_Resize of rasters
with scale 1/-1 and offset 0/0.
- Fix crash in ST_Union(raster)
- #2704, ST_GeomFromGML() does not work properly with array of gml:pos
(Even Roualt)
- #2708, updategeometrysrid doesn't update srid check when schema
not specified. Patch from Marc Jansen
- #2720, lwpoly_add_ring should update maxrings after realloc
- #2759, Fix postgis_restore.pl handling of multiline object comments
embedding sql comments
- #2774, fix undefined behavior in ptarray_calculate_gbox_geodetic
- Fix potential memory fault in ST_MakeValid
- #2784, Fix handling of bogus argument to --with-sfcgal
- #2772, Premature memory free in RASTER_getBandPath (ST_BandPath)
- #2755, Fix regressions tests against all versions of SFCGAL
- #2775, lwline_from_lwmpoint leaks memory
- #2802, ST_MapAlgebra checks for valid callback function return value
- #2803, ST_MapAlgebra handles no userarg and STRICT callback function
- #2834, ST_Estimated_Extent and mixedCase table names (regression bug)
- #2845, Bad geometry created from ST_AddPoint
- #2870, Binary insert into geography column results geometry being inserted
- #2872, make install builds documentation (Greg Troxell)
- #2819, find isfinite or replacement on Centos5 / Solaris
- #2899, geocode limit 1 not returning best answer (tiger geocoder)
- #2903, Unable to compile on FreeBSD
- #2927 reverse_geocode not filling in direction prefix (tiger geocoder)
get rid of deprecated ST_Line_Locate_Point called
PostGIS 2.1.3
2014/05/13
* Important / Breaking Changes *
- Add control of GDAL drivers with the environment variable
POSTGIS_GDAL_ENABLED_DRIVERS. By default, all GDAL drivers are disabled
- Add ability to disable out-db raster bands with the environment variable
POSTGIS_ENABLE_OUTDB_RASTERS. By default, out-db raster bands are disabled
* Bug Fixes *
- #2697, invalid GeoJSON Polygon input crashes server process
- #2700, Fix dumping of higher-dimension datasets with null rows
- #2706, ST_DumpPoints of EMPTY geometries crashes server
PostGIS 2.1.2
2014/03/31
* Important Changes *
* Bug Fixes *
- #2666, Error out at configure time if no SQL preprocessor can be found
- #2534, st_distance returning incorrect results for large geographies
- #2539, Check for json-c/json.h presence/usability before json/json.h
- #2543, invalid join selectivity error from simple query
- #2546, GeoJSON with string coordinates parses incorrectly
- #2547, Fix ST_Simplify(TopoGeometry) for hierarchical topogeoms
- #2552, Fix NULL raster handling in ST_AsPNG, ST_AsTIFF and
ST_AsJPEG
- #2555, Fix parsing issue of range arguments of ST_Reclass
- #2556, geography ST_Intersects results depending on insert order
- #2580, Do not allow installing postgis twice in the same database
- #2589, Remove use of unnecessary void pointers
- #2607, Cannot open more than 1024 out-db files in one process
- #2610, Ensure face splitting algorithm uses the edge index
- #2615, EstimatedExtent (and hence, underlying stats) gathering wrong bbox
- #2619, Empty rings array in GeoJSON polygon causes crash
- #2634, regression in sphere distance code
- #2638, Geography distance on M geometries sometimes wrong
- #2648, #2653, Fix topology functions when "topology" is not in search_path
- #2654, Drop deprecated calls from topology
- #2655, Let users without topology privileges call postgis_full_version()
- #2674, Fix missing operator = and hash_raster_ops opclass on raster
- #2675, #2534, #2636, #2634, #2638, Geography distance issues with tree optimization
* Enhancements *
- #2494, avoid memcopy in GiST index (hayamiz)
- #2560, soft upgrade: avoid drop/recreate of aggregates that hadn't changed
PostGIS 2.1.1
2013/11/08
* Important Changes *
- #2514, Change raster license from GPL v3+ to v2+, allowing
distribution of PostGIS Extension as GPLv2.
* Bug Fixes *
- #2396, Make regression tests more endian-agnostic
- #2434, Fix ST_Intersection(geog,geog) regression in rare cases
- #2454, Fix behavior of ST_PixelAsXXX functions regarding
exclude_nodata_value parameter
- #2449, Fix potential infinite loop in index building
- #2489, Fix upgrades from 2.0 leaving stale function signatures
- #2493, Fix behavior of ST_DumpValues when passed an empty raster
- #2502, Fix postgis_topology_scripts_installed() install schema
- #2504, Fix segfault on bogus pgsql2shp call
- #2512, Support for foreign tables and materialized views in
raster_columns and raster_overviews
- #2525, Fix handling of SRID in nested collections
- #2528, Fix memory leak in ST_Split / lwline_split_by_line
- #2532, Add missing raster/geometry commutator operators
- #2533, Remove duplicated signatures
* Enhancements *
- #2463, support for exact length calculations on arc geometries
- #2478, support for tiger 2013
- #2527, Added -k flag to raster2pgsql to skip checking that
band is NODATA
PostGIS 2.1.0
2013/08/17
* Important / Breaking Changes *
- #1653, Removed srid parameter from ST_Resample(raster) and variants
with reference raster no longer apply reference raster's SRID.
- #1962 ST_Segmentize - As a result of
the introduction of geography support, The construct:
SELECT ST_Segmentize('LINESTRING(1 2, 3 4)',0.5);
will result in ambiguous function error
- #2026, ST_Union(raster) now unions all bands of all rasters
- #2089, liblwgeom: lwgeom_set_handlers replaces lwgeom_init_allocators.
- #2150, regular_blocking is no longer a constraint. column of same name
in raster_columns now checks for existance of spatially_unique
and coverage_tile constraints
- ST_Intersects(raster, geometry) behaves in the same manner as
ST_Intersects(geometry, raster).
- point variant of ST_SetValue(raster) previously did not check SRID
of input geometry and raster.
- ST_Hillshade parameters azimuth and altitude are now in degrees
instead of radians.
- ST_Slope and ST_Aspect return pixel values in degrees instead of radians.
* Deprecated signatures *
- #2104, ST_World2RasterCoord, ST_World2RasterCoordX and
ST_World2RasterCoordY renamed to ST_WorldToRasterCoord,
ST_WorldToRasterCoordX and ST_WorldToRasterCoordY.
ST_Raster2WorldCoord, ST_Raster2WorldCoordX and
ST_Raster2WorldCoordY renamed to ST_RasterToWorldCoord,
ST_RasterToWorldCoordX and ST_RasterToWorldCoordY
- ST_Estimated_Extent renamed to ST_EstimatedExtent
- ST_Line_Interpolate_Point renamed to ST_LineInterpolatePoint
- ST_Line_Substring renamed to ST_LineSubstring
- ST_Line_Locate_Point renamed to ST_LineLocatePoint
- ST_Force_XXX renamed to ST_ForceXXX
- ST_MapAlgebraFctNgb and 1 and 2 raster variants of ST_MapAlgebraFct.
Use ST_MapAlgebra instead
- 1 and 2 raster variants of ST_MapAlgebraExpr.
Use expression variants of ST_MapAlgebra instead
* New Features *
Refer to http://postgis.net/docs/manual-2.1/PostGIS_Special_Functions_Index.html#NewFunctions_2_1
for complete list of new functions
- #310, ST_DumpPoints converted to a C function (Nathan Wagner)
- #739, UpdateRasterSRID()
- #945, improved join selectivity, N-D selectivity calculations,
user accessible selectivity and stats reader functions for
testing (Paul Ramsey / OpenGeo)
- toTopoGeom with TopoGeometry sink (Sandro Santilli / Vizzuality)
- clearTopoGeom (Sandro Santilli / Vizzuality)
- ST_Segmentize(geography) (Paul Ramsey / OpenGeo)
- ST_DelaunayTriangles (Sandro Santilli / Vizzuality)
- ST_NearestValue, ST_Neighborhood (Bborie Park / UC Davis)
- ST_PixelAsPoint, ST_PixelAsPoints (Bborie Park / UC Davis)
- ST_PixelAsCentroid, ST_PixelAsCentroids (Bborie Park / UC Davis)
- ST_Raster2WorldCoord, ST_World2RasterCoord (Bborie Park / UC Davis)
- Additional raster/raster spatial relationship functions
(ST_Contains, ST_ContainsProperly, ST_Covers, ST_CoveredBy, ST_Disjoint,
ST_Overlaps, ST_Touches, ST_Within, ST_DWithin, ST_DFullyWithin)
(Bborie Park / UC Davis)
- Added array variants of ST_SetValues() to set many pixel values of a band
in one call (Bborie Park / UC Davis)
- #1293, ST_Resize(raster) to resize rasters based upon width/height
- #1627, package tiger_geocoder as a PostgreSQL extension
- #1643, #2076, Upgrade tiger geocoder to support loading tiger 2011 and 2012
(Regina Obe / Paragon Corporation) Funded by Hunter Systems Group
- GEOMETRYCOLLECTION support for ST_MakeValid (Sandro Santilli / Vizzuality)
- #1709, ST_NotSameAlignmentReason(raster, raster)
- #1818, ST_GeomFromGeoHash and friends (Jason Smith (darkpanda))
- #1856, reverse geocoder rating setting for prefer numbered highway name
- ST_PixelOfValue (Bborie Park / UC Davis)
- Casts to/from PostgreSQL geotypes (point/path/polygon).
- Added geomval array variant of ST_SetValues() to set many pixel values of
a band using a set of geometries and corresponding values in one call
(Bborie Park / UC Davis)
- ST_Tile(raster) to break up a raster into tiles (Bborie Park / UC Davis)
- #1895, new r-tree node splitting algorithm (Alex Korotkov)
- #2011, ST_DumpValues to output raster as array (Bborie Park / UC Davis)
- #2018, ST_Distance support for CircularString, CurvePolygon, MultiCurve,
MultiSurface, CompoundCurve
- #2030, n-raster (and n-band) ST_MapAlgebra (Bborie Park / UC Davis)
- #2193, Utilize PAGC parser as drop in replacement for tiger normalizer
(Steve Woodbridge, Regina Obe)
- #2210, ST_MinConvexHull(raster)
- lwgeom_from_geojson in liblwgeom (Sandro Santilli / Vizzuality)
- #1687, ST_Simplify for TopoGeometry (Sandro Santilli / Vizzuality)
- #2228, TopoJSON output for TopoGeometry (Sandro Santilli / Vizzuality)
- #2123, ST_FromGDALRaster
- #613, ST_SetGeoReference with numerical parameters instead of text
- #2276, ST_AddBand(raster) variant for out-db bands
- #2280, ST_Summary(raster)
- #2163, ST_TPI for raster (Nathaniel Clay)
- #2164, ST_TRI for raster (Nathaniel Clay)
- #2302, ST_Roughness for raster (Nathaniel Clay)
- #2290, ST_ColorMap(raster) to generate RGBA bands
- #2254, Add SFCGAL backend support.
(Backend selection throught postgis.backend var)
Functions available both throught GEOS or SFCGAL:
ST_Intersects, ST_3DIntersects, ST_Intersection, ST_Area,
ST_Distance, ST_3DDistance
New functions available only with SFCGAL backend:
ST_3DIntersection, ST_Tesselate, ST_3DArea, ST_Extrude, ST_ForceLHR
ST_Orientation, ST_Minkowski, ST_StraightSkeleton
postgis_sfcgal_version
New function available in PostGIS: ST_ForceSFS
(Olivier Courtin and Hugo Mercier / Oslandia)
* Enhancements *
- #823, tiger geocoder: Make loader_generate_script download portion
less greedy
- #826, raster2pgsql no longer defaults to padding tiles. Flag -P
can be used to pad tiles
- #1363, ST_AddBand(raster, ...) array version rewritten in C
- #1364, ST_Union(raster, ...) aggregate function rewritten in C
- #1655, Additional default values for parameters of ST_Slope
- #1661, Add aggregate variant of ST_SameAlignment
- #1719, Add support for Point and GeometryCollection ST_MakeValid inputs
- #1780, support ST_GeoHash for geography
- #1796, Big performance boost for distance calculations in geography
- #1802, improved function interruptibility.
- #1823, add parameter in ST_AsGML to use id column for GML 3 output
(become mandatory since GML 3.2.1)
- #1856, tiger geocoder: reverse geocoder rating setting for prefer
numbered highway name
- #1938, Refactor basic ST_AddBand to add multiple new bands in one call
- #1978, wrong answer when calculating length of a closed circular
arc (circle)
- #1989, Preprocess input geometry to just intersection with raster
to be clipped
- #2021, Added multi-band support to ST_Union(raster, ...) aggregate function
- #2006, better support of ST_Area(geography) over poles and dateline
- #2065, ST_Clip(raster, ...) now a C function
- #2069, Added parameters to ST_Tile(raster) to control padding of tiles
- #2078, New variants of ST_Slope, ST_Aspect and ST_HillShade to provide
solution to handling tiles in a coverage
- #2097, Added RANGE uniontype option for ST_Union(raster)
- #2105, Added ST_Transform(raster) variant for aligning output to
reference raster
- #2119, Rasters passed to ST_Resample(), ST_Rescale(), ST_Reskew(),
and ST_SnapToGrid() no longer require an SRID
- #2141, More verbose output when constraints fail to be added
to a raster column
- #2143, Changed blocksize constraint of raster to allow multiple values
- #2148, Addition of coverage_tile constraint for raster
- #2149, Addition of spatially_unique constraint for raster
- TopologySummary output now includes unregistered layers and a count
of missing TopoGeometry objects from their natural layer.
- ST_HillShade(), ST_Aspect() and ST_Slope() have one new optional
parameter to interpolate NODATA pixels before running the
operation.
- Point variant of ST_SetValue(raster) is now a wrapper around geomval
variant of ST_SetValues(rast).
- Proper support for raster band's isnodata flag in core API and loader.
- Additional default values for parameters of ST_Aspect and ST_HillShade
- #2178, ST_Summary now advertises presence of known srid with an [S] flag
- #2202, Make libjson-c optional (--without-json configure switch)
- #2213, Add support libjson-c 0.10+
- #2231, raster2pgsql supports user naming of filename column with -n
- #2200, ST_Union(raster, uniontype) unions all bands of all rasters
- #2264, postgis_restore.pl support for restoring into databases
with postgis in a custom schema
- #2244, emit warning when changing raster's georeference if raster has
out-db bands
- #2222, add parameter OutAsIn to flag whether ST_AsBinary should
return out-db bands as in-db bands
* Fixes *
- #1839, handling of subdatasets in GeoTIFF in raster2pgsql.
- #1840, fix logic of when to compute # of tiles in raster2pgsql.
- #1870, align the docs and actual behavior of raster's ST_Intersects
- #1872, fix ST_ApproxSummarystats to prevent division by zero
- #1875, ST_SummaryStats returns NULL for all parameters except count
when count is zero
- #1932, fix raster2pgsql of syntax for index tablespaces
- #1936, ST_GeomFromGML on CurvePolygon causes server crash
- #1939, remove custom data types: summarystats, histogram, quantile,
valuecount
- #1951, remove crash on zero-length linestrings
- #1957, ST_Distance to a one-point LineString returns NULL
- #1976, Geography point-in-ring code overhauled for more reliability
- #1981, cleanup of unused variables causing warnings with gcc 4.6+
- #1996, support POINT EMPTY in GeoJSON output
- #2062, improve performance of distance calculations
- #2057, Fixed linking issue for raster2psql to libpq
- #2077, Fixed incorrect values returning from ST_Hillshade()
- #2019, ST_FlipCoordinates does not update bbox
- #2100, ST_AsRaster may not return raster with specified pixel type
- #2126, Better handling of empty rasters from ST_ConvexHull()
- #2165, ST_NumPoints regression failure with CircularString
- #2168, ST_Distance is not always commutative
- #2182, Fix issue with outdb rasters with no SRID and ST_Resize
- #2188, Fix function parameter value overflow that caused problems
when copying data from a GDAL dataset
- #2198, Fix incorrect dimensions used when generating bands of out-db
rasters in ST_Tile()
- #2201, ST_GeoHash wrong on boundaries
- #2203, Changed how rasters with unknown SRID and default geotransform
are handled when passing to GDAL Warp API
- #2215, Fixed raster exclusion constraint for conflicting name of
implicit index
- #2251, Fix bad dimensions when rescaling rasters with default
geotransform matrix
- #2133, Fix performance regression in expression variant of ST_MapAlgebra
- #2257, GBOX variables not initialized when testing with empty geometries
- #2271, Prevent parallel make of raster
- #2282, Fix call to undefined function nd_stats_to_grid() in debug mode
- #2307, ST_MakeValid outputs invalid geometries
- #2309, Remove confusing INFO message when trying to get SRS info
- #2336, FIPS 20 (KS) causes wildcard expansion to wget all files
- #2348, Provide raster upgrade path for 2.0 to 2.1
- #2351, st_distance between geographies wrong
- #2359, Fix handling of schema name when adding overview constraints
- #2371, Support GEOS versions with more than 1 digit in micro
- #2383, Remove unsafe use of \' from raster warning message
- #2384, Incorrect variable datatypes for ST_Neighborhood
* Known Issues *
- #2111, Raster bands can only reference the first 256 bands of out-db rasters
PostGIS 2.0.6
2014/05/14
* Important Changes *
- Add control of GDAL drivers with the environment variable
POSTGIS_GDAL_ENABLED_DRIVERS. By default, all GDAL drivers are disabled
- Add ability to disable out-db raster bands with the environment variable
POSTGIS_ENABLE_OUTDB_RASTERS. By default, out-db raster bands are disabled
* Bug Fixes *
- #2772, fix premature memory free in RASTER_getBandPath (ST_BandPath)
PostGIS 2.0.5
2014/03/31
* Important Changes *
- #2514, Change raster license from GPL v3+ to v2+, allowing
distribution of PostGIS Extension as GPLv2.
* Bug Fixes *
- #2494, avoid memcpy in GIST index
- #2502, Fix postgis_topology_scripts_installed() install schema
- #2504, Fix segfault on bogus pgsql2shp call
- #2528, Fix memory leak in ST_Split / lwline_split_by_line
- #2532, Add missing raster/geometry commutator operators
- #2533, Remove duplicated signatures
- #2552, Fix NULL raster handling in ST_AsPNG, ST_AsTIFF and ST_AsJPEG
- #2555, Fix parsing issue of range arguments of ST_Reclass
- #2589, Remove use of unnecessary void pointers
- #2607, Cannot open more than 1024 out-db files in process
- #2610, Ensure face splitting algorithm uses the edge index
- #2619, Empty ring array in GeoJSON polygon causes crash
- #2638, Geography distance on M geometries sometimes wrong
PostGIS 2.0.4
2013/09/06
* Bug Fixes *
- #2110, Equality operator between EMPTY and point on origin
- Allow adding points at precision distance with TopoGeo_addPoint
- #1968, Fix missing edge from toTopoGeom return
- #2165, ST_NumPoints regression failure with CircularString
- #2168, ST_Distance is not always commutative
- #2186, gui progress bar updates too frequent
- #2201, ST_GeoHash wrong on boundaries
- #2257, GBOX variables not initialized when testing with empty geometries
- #2271, Prevent parallel make of raster
- #2267, Server crash from analyze table
- #2277, potential segfault removed
- #2307, ST_MakeValid outputs invalid geometries
- #2351, st_distance between geographies wrong
- #2359, Incorrect handling of schema for overview constraints
- #2371, Support GEOS versions with more than 1 digit in micro
- #2372, Cannot parse space-padded KML coordinates
- Fix build with systemwide liblwgeom installed
- #2383, Fix unsafe use of \' in warning message
- #2410, Fix segmentize of collinear curve
- #2415, ST_Multi support for COMPOUNDCURVE and CURVEPOLYGON
- #2412, ST_LineToCurve support for lines with less than 4 vertices
- #2420, ST_LineToCurve: require at least 8 edges to define a full circle
- #2423, ST_LineToCurve: require all arc edges to form the same angle
- #2424, ST_CurveToLine: add support for COMPOUNDCURVE in MULTICURVE
- #2427, Make sure to retain first point of curves on ST_CurveToLine
* Enhancements *
- #2269, Avoid uselessly de-toasting full geometries on ANALYZE
* Known Issues *
- #2111, Raster bands can only reference the first 256 bands of out-db rasters
PostGIS 2.0.3
2013/03/01
* Bug Fixes *
- #2134, Fixed handling of SRS strings as they are passed to GDAL functions
PostGIS 2.0.2
2012/12/03
* Bug Fixes *
- #1287, Drop of "gist_geometry_ops" broke a few clients
package of legacy_gist.sql for these cases
- #1391, Errors during upgrade from 1.5
- #1828, Poor selectivity estimate on ST_DWithin
- #1838, error importing tiger/line data
- #1869, ST_AsBinary is not unique -
added to legacy_minor/legacy.sql scripts
- #1885, Missing field from tabblock table in tiger2010 census_loader.sql
- #1891, Use LDFLAGS environment when building liblwgeom
- #1899, Enhance toTopoGeom error on unsupported input
- #1900, Fix pgsql2shp for big-endian systems
- #1932, Fix raster2pgsql for invalid syntax for setting index tablespace
- #1936, ST_GeomFromGML on CurvePolygon causes server crash
- #1955, ST_ModEdgeHeal and ST_NewEdgeHeal for doubly connected edges
- #1957, ST_Distance to a one-point LineString returns NULL
- #1976, Geography point-in-ring code overhauled for more reliability
- #1978, wrong answer calculating length of closed circular arc (circle)
- #1981, Remove unused but set variables as found with gcc 4.6+
- #1987, Restore 1.5.x behaviour of ST_Simplify
- #1989, Preprocess input geometry to just intersection with raster
to be clipped
- #1991, geocode really slow on PostgreSQL 9.2
- #1996, support POINT EMPTY in GeoJSON output
- #1998, Fix ST_{Mod,New}EdgeHeal joining edges sharing both endpoints
- #2001, ST_CurveToLine has no effect if the geometry doesn't actually
contain an arc
- #2015, ST_IsEmpty('POLYGON(EMPTY)') returns False
- #2019, ST_FlipCoordinates does not update bbox
- #2025, Fix side location conflict at TopoGeo_AddLineString
- #2062, improve performance of distance calculations
- #2033, Fix adding a splitting point into a 2.5d topology
- #2051, Fix excess of precision in ST_AsGeoJSON output
- #2052, Fix buffer overflow in lwgeom_to_geojson
- #2056, Fixed lack of SRID check of raster and geometry in ST_SetValue()
- #2057, Fixed linking issue for raster2psql to libpq
- #2060, Fix "dimension" check violation by GetTopoGeomElementArray
- #2072, Removed outdated checks preventing ST_Intersects(raster) from
working on out-db bands
- #2077, Fixed incorrect answers from ST_Hillshade(raster)
- #2092, Namespace issue with ST_GeomFromKML,ST_GeomFromGML for libxml 2.8+
- #2099, Fix double free on exception in ST_OffsetCurve
- #2100, ST_AsRaster() may not return raster with specified pixel type
- #2108, Ensure ST_Line_Interpolate_Point always returns POINT
- #2109, Ensure ST_Centroid always returns POINT
- #2117, Ensure ST_PointOnSurface always returns POINT
- #2129, Fix SRID in ST_Homogenize output with collection input
- #2130, Fix memory error in MultiPolygon GeoJson parsing
- Update URL of Maven jar
* Enhancements *
- #1581, ST_Clip(raster, ...) no longer imposes NODATA on a band if the
corresponding band from the source raster did not have NODATA
- #1928, Accept array properties in GML input multi-geom input
(Kashif Rasul and Shoaib Burq / SpacialDB)
- #2082, Add indices on start_node and end_node of topology edge tables
- #2087, Speedup topology.GetRingEdges using a recursive CTE
PostGIS 2.0.1
2012/06/22
* Bug Fixes *
- #1264, fix st_dwithin(geog, geog, 0).
- #1468 shp2pgsql-gui table column schema get shifted
- #1694, fix building with clang. (vince)
- #1708, improve restore of pre-PostGIS 2.0 backups.
- #1714, more robust handling of high topology tolerance.
- #1755, ST_GeographyFromText support for higher dimensions.
- #1759, loading transformed shapefiles in raster enabled db.
- #1761, handling of subdatasets in NetCDF, HDF4 and HDF5 in raster2pgsql.
- #1763, topology.toTopoGeom use with custom search_path.
- #1766, don't let ST_RemEdge* destroy peripheral TopoGeometry objects.
- #1774, Clearer error on setting an edge geometry to an invalid one.
- #1775, ST_ChangeEdgeGeom collision detection with 2-vertex target.
- #1776, fix ST_SymDifference(empty, geom) to return geom.
- #1779, install SQL comment files.
- #1782, fix spatial reference string handling in raster.
- #1789, fix false edge-node crossing report in ValidateTopology.
- #1790, fix toTopoGeom handling of duplicated primitives.
- #1791, fix ST_Azimuth with very close but distinct points.
- #1797, fix (ValidateTopology(xxx)).* syntax calls.
- #1805, put back the 900913 SRID entry.
- #1813, Only show readable relations in metadata tables.
- #1819, fix floating point issues with ST_World2RasterCoord and
ST_Raster2WorldCoord variants.
- #1820 compilation on 9.2beta1.
- #1822, topology load on PostgreSQL 9.2beta1.
- #1825, fix prepared geometry cache lookup
- #1829, fix uninitialized read in GeoJSON parser
- #1834, revise postgis extension to only backup
user specified spatial_ref_sys
- #1839, handling of subdatasets in GeoTIFF in raster2pgsql.
- #1840, fix logic of when to compute # of tiles in raster2pgsql.
- #1851, fix spatial_ref_system parameters for EPSG:3844
- #1857, fix failure to detect endpoint mismatch in ST_AddEdge*Face*
- #1865, data loss in postgis_restore.pl when data rows have leading
dashes.
- #1867, catch invalid topology name passed to topogeo_add*
- #1870, align the docs and actual behavior of raster's ST_Intersects
- #1872, fix ST_ApproxSummarystats to prevent division by zero
- #1873, fix ptarray_locate_point to return interpolated Z/M values for
on-the-line case
- #1875, ST_SummaryStats returns NULL for all parameters except count
when count is zero
- #1881, shp2pgsql-gui -- editing a field sometimes triggers
removing row
- #1883, Geocoder install fails trying to run
create_census_base_tables() (Brian Panulla)
* Enhancements *
- More detailed exception message from topology editing functions.
- #1786, improved build dependencies
- #1806, speedup of ST_BuildArea, ST_MakeValid and ST_GetFaceGeometry.
- #1812, Add lwgeom_normalize in LIBLWGEOM for more stable testing.
PostGIS 2.0.0
2012/04/03
* Important / Breaking Changes *
- Upgrading to PostGIS 2.0 REQUIRES a dump and restore. See the
"Hard Upgrade" section of the documentation.
- Functions deprecated during the 1.X series (mostly non-ST variants)
have been removed. Update your application to the new signatures.
If you cannot update your application, see the legacy.sql file
to enable the old signatures.
- GEOMETRY_COLUMNS is now a view, not a table. Code that manually
updates the table must be changed to either use the management
functions (eg AddGeometryColumn) or the new geometry typmod options
(eg CREATE TABLE t (g GEOMETRY(Polgyon, 4326)))
- ST_AsBinary and ST_AsText now return 3D/4D results in ISO SQL/MM
format when called on 3D/4D features.
- The "unknonwn SRID" is now 0, not -1.
(eg ST_SRID(ST_GeomFromText('POINT(0 0)')) returns 0)
- ST_NumGeometries returns 1 for singletons. ST_GeometryN returns the
the geometry for singletons.
- probe_geometry_columns(), rename_geometry_table_constraints(),
fix_geometry_columns(), have been removed since GEOMETRY_COLUMNS
is now a view.
- 3D analysis functions are now named with "3D" as a prefix
instead of a suffix (eg ST_Length3D has become ST_3DLength)
- Operator && does not check for SRID mismatch anymore
* New Features *
- KNN Gist index based centroid (<->) and box (<#>) distance
operators (Paul Ramsey / funded by Vizzuality)
- PostgreSQL 9.1+ "extension" support (Regina Obe)
- Typmod support for geometry (Paul Ramsey)
- Support for TIN and PolyHedralSurface (Olivier Courtin / Oslandia)
- Raster support integrated and documented
(Pierre Racine, Jorge Arévalo, Mateusz Loskot, Sandro Santilli,
Regina Obe, David Zwarg)
(Company developer and funding: University Laval, Deimos Space, CadCorp,
Michigan Tech Research Institute, Paragon Corporation, Azavea)
- N-Dimensional spatial indexes (Paul Ramsey / OpenGeo)
- Topology support improved, documented, testing, bug fixes
(Sandro Santilli / Faunalia for RT-SIGTA, Regina Obe, Andrea Peri,
Jose Carlos Martinez Llari)
- 3D relationship support functions (Nicklas Avén)
ST_3DDistance, ST_3DClosestPoint, ST_3DIntersects,
ST_3DShortestLine
- ST_Split (Sandro Santilli / Faunalia for RT-SIGTA)
- ST_Node (Sandro Santilli)
- ST_isValidDetail (Sandro Santilli / Faunalia for RT-SIGTA)
- ST_MakeValid (Sandro Santilli / Faunalia for RT-SIGTA)
- ST_RemoveRepeatedPoints (Sandro Santilli / Faunalia for RT-SIGTA)
- ST_GeometryN and ST_NumGeometries support for non-collections
(Sandro Santilli)
- ST_IsCollection (Sandro Santilli, Maxime van Noppen)
- ST_SharedPaths (Sandro Santilli / Faunalia for RT-SIGTA)
- ST_Snap (Sandro Santilli)
- ST_RelateMatch (Sandro Santilli / Faunalia for RT-SIGTA)
- ST_ConcaveHull (Regina Obe and Leo Hsu / Paragon Corporation)
- ST_UnaryUnion (Sandro Santilli)
- ST_Relate with boundary node rule (Sandro Santilli / Faunalia for RT-SIGTA)
- ST_AsX3D (Regina Obe / Arrival 3D)
- ST_OffsetCurve (Sandro Santilli, Rafal Magda)
- ST_GeomFromGeoJSON (Kashif Rasul, Paul Ramsey / Vizzuality)
- ST_AsBinary byte endian support for geography
* Enhancements *
- Made loader tolerant of truncated multibyte values found
in some free worldwide shapefiles (Sandro Santilli)
- Lots of bug fixes and enhancements to shp2pgsql
Beefing up regression tests for loaders
Reproject support for both geometry and geography during import
(Jeff Adams / Azavea, Mark Cave-Ayland)
- pgsql2shp conversion from predefined list
(Loic Dachary / Mark Cave-Ayland)
- Shp-pgsql GUI - support loading multiple files. (Mark Leslie)