forked from postgis/postgis
-
Notifications
You must be signed in to change notification settings - Fork 0
/
NEWS
1260 lines (1115 loc) · 47.1 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.1.0
2013/MM/DD
* Important / Breaking Changes *
- ST_Intersects(raster, geometry) behaves in the same manner as
ST_Intersects(geometry, raster).
- #2026, ST_Union(raster) now unions all bands of all rasters
* Deprecated signatures
- ST_Estimated_Extent renamed to ST_EstimatedExtent
* New Features *
- 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)
- #1643, Tiger Geocoder - Tiger 2011 loader
(Regina Obe / Paragon Corporation) Funded by Hunter Systems Group
- GEOMETRYCOLLECTION support for ST_MakeValid (Sandro Santilli / Vizzuality)
- ST_PixelOfValue (Bborie Park / UC Davis)
- Casts to/from PostgreSQL geotypes (point/path/polygon).
* Enhancements *
- #823, tiger geocoder: Make loader_generate_script download portion less greedy
- #1363, ST_AddBand(raster, ...) array version rewritten in C
- #1364, ST_Union(raster, ...) aggregate function rewritten in C
- #1661, Add aggregate variant of ST_SameAlignment
- #1719, Add support for Point and GeometryCollection ST_MakeValid inputs
- #1796, Big performance boost for distance calculations in geography
- #1802, improved function interruptibility.
- #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)
- #1780, support ST_GeoHash for geography
- #2021, Added multi-band support to ST_Union(raster, ...) aggregate function
* 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
- #1981, cleanup of unused variables causing warnings with gcc 4.6+
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)
* 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)
- Shp-pgsql GUI - support exporting multiple tablee. (Mark Cave-Ayland)
- Extras - upgraded tiger_geocoder from using old TIGER format
to use new TIGER shp and file structure format (Stephen Frost)
- Enhancements and documentation of TIGER geocoder
(Regina Obe, Leo Hsu / Paragon Corporation /
funding provided by Hunter Systems Group)
- Documentation proofreading and corrections. (Kasif Rasul)
* All Fixes and Enhancements *
- http://trac.osgeo.org/postgis/query?status=closed&milestone=PostGIS+2.0.0
* Acknowledgements *
We are most indebted to the numerous members in the PostGIS community
who were brave enough to TEST out the new features in this release.
No major release can be successful without lots of testing.
Below is an incomplete list of some of the many folks who helped
us get to this release.
- Andrea Peri - Lots of testing on topology, checking for correctness
- Andreas Forø Tollefsen - raster testing
- Chris English - topology stress testing loader functions
- Salvatore Larosa - Lots of topology testing
- Brian Hamlin - Benchmarking, general testing all components
- Mike Pease - Tiger geocoder testing, very detailed reports of issues
- Tom van Tilburg - raster testing
PostGIS 1.5.3
2011/06/25
- This is a bug fix release, addressing issues that have been
filed since the 1.5.2 release.
- Bug Fixes
- #1056, produce correct bboxes for arc geometries, fixes index errors
(Paul Ramsey)
- #1007, ST_IsValid crash - fix requires GEOS 3.3.0+ or 3.2.3+
(Sandro Santilli, reported by Birgit Laggner)
- #940, support for PostgreSQL 9.1 beta 1
(Regina Obe, Paul Ramsey, patch submitted by stl)
- #845, ST_Intersects precision error (Sandro Santilli, Nicklas Avén)
Reported by cdestigter
- #884, Unstable results with ST_Within, ST_Intersects (Chris Hodgson)
- #779, shp2pgsql -S option seems to fail on points (Jeff Adams)
- #666, ST_DumpPoints is not null safe (Regina Obe)
- #631, Update NZ projections for grid transformation support (jpalmer)
- #630, Peculiar Null treatment in arrays in ST_Collect (Chris Hodgson)
Reported by David Bitner
- #624, Memory leak in ST_GeogFromText (ryang, Paul Ramsey)
- #609, Bad source code in manual section 5.2 Java Clients
(simoc, Regina Obe)
- #604, shp2pgsql usage touchups (Mike Toews, Paul Ramsey)
- #573 ST_Union fails on a group of linestrings
Not a PostGIS bug, fixed in GEOS 3.3.0
- #457 ST_CollectionExtract returns non-requested type
(Nicklas Avén, Paul Ramsey)
- #441 ST_AsGeoJson Bbox on GeometryCollection error (Olivier Courtin)
- #411 Ability to backup invalid geometries (Sando Santilli)
Reported by Regione Toscana
- #409 ST_AsSVG - degraded (Olivier Courtin)
Reported by Sdikiy
- #373 Documentation syntax error in hard upgrade (Paul Ramsey)
Reported by psvensso
PostGIS 1.5.2
2010/09/27
- This is a bug fix release, addressing issues that have been
filed since the 1.5.1 release.
- Bug Fixes
- Loader: fix handling of empty (0-verticed) geometries in shapefiles.
(Sandro Santilli)
- #536, Geography ST_Intersects, ST_Covers, ST_CoveredBy and
Geometry ST_Equals not using spatial index (Regina Obe, Nicklas Avén)
- #573, Improvement to ST_Contains geography
- Loader: Add support for command-q shutdown in Mac GTK build (Paul Ramsey)
- #393, Loader: Add temporary patch for large DBF files
(Maxime Guillaud, Paul Ramsey)
- #507, Fix wrong OGC URN in GeoJSON and GML output (Olivier Courtin)
- spatial_ref_sys.sql Add datum conversion for projection SRID 3021
(Paul Ramsey)
- Geography - remove crash for case when all geographies are out of
the estimate (Paul Ramsey)
- #469, Fix for array_aggregation error (Greg Stark, Paul Ramsey)
- #532, Temporary geography tables showing up in other user sessions
(Paul Ramsey)
- #562, ST_Dwithin errors for large geographies (Paul Ramsey)
- #513, shape loading GUI tries to make spatial index when loading DBF only
mode (Paul Ramsey)
- #527, shape loading GUI should always append log messages
(Mark Cave-Ayland)
- #504 shp2pgsql should rename xmin/xmax fields (Sandro Santilli)
- #458 postgis_comments being installed in contrib instead of
version folder (Mark Cave-Ayland)
- #474 Analyzing a table with geography column crashes server
(Paul Ramsey)
- #581 LWGEOM-expand produces inconsistent results
(Mark Cave-Ayland)
- #471 DocBook dtd errors (Olivier Courtin)
- Fix further build issues against PostgreSQL 9.0
(Mark Cave-Ayland)
- #572 Password whitespace for Shape File to PostGIS
Import not supported (Mark Cave-Ayland)
- #603: shp2pgsql: "-w" produces invalid WKT for MULTI* objects.
(Mark Cave-Ayland)
- Enhancement
- #513 Add dbf filter to shp2pgsql-gui and allow uploading dbf only
(Paul Ramsey)
PostGIS 1.5.1
2010/03/11
- This is a bug fix release, addressing issues that have been
filed since the 1.5.0 release.
- Bug Fixes
- #410, update embedded bbox when applying ST_SetPoint, ST_AddPoint
ST_RemovePoint to a linestring
(Paul Ramsey)
- #411, allow dumping tables with invalid geometries
(Sandro Santilli, for Regione Toscana-SIGTA)
- #414, include geography_columns view when running upgrade scripts
(Paul Ramsey)
- #419, allow support for multilinestring in ST_Line_Substring
(Paul Ramsey, for Lidwala Consulting Engineers)
- #421, fix computed string length in ST_AsGML()
(Olivier Courtin)
- #441, fix GML generation with heterogeneous collections
(Olivier Courtin)
- #443, incorrect coordinate reversal in GML 3 generation
(Olivier Courtin)
- #450, #451, wrong area calculation for geography features that
cross the date line
(Paul Ramsey)
- Ensure support for upcoming 9.0 PgSQL release
(Paul Ramsey)
PostGIS 1.5.0
2010/02/04
* Important Changes *
- =~ operator now indicates bounding box equality, not feature equality
- GEOS 3.1 is now the minimum accepted version of GEOS
- GEOS 3.2 is needed if you want to use enhanced buffering features
and ST_HausdorffDistance
- GEOS, LibXML2, and Proj4 are now mandatory dependencies
* New Features *
- Added Hausdorff distance calculations (#209) (Vincent Picavet)
- Added parameters argument to ST_Buffer operation to support one-sided
buffering and other buffering styles (Sandro Santilli)
- Performance improvements to ST_Distance (Nicklas Avén)
- Addition of other Distance related visualization and analysis
functions (Nicklas Avén)
- ST_ClosestPoint
- ST_DFullyWithin
- ST_LongestLine
- ST_MaxDistance
- ST_ShortestLine
- KML, GML input via ST_GeomFromGML and ST_GeomFromKML (Olivier Courtin)
- Extract homogeneous collection with ST_CollectionExtract (Paul Ramsey)
- Add measure values to existing linestring with ST_AddMeasure (Paul Ramsey)
- History table implementation in utils (George Silva)
- Win32 support and improvement of core shp2pgsql-gui (Mark Cave-Ayland)
- In place 'make check' support (Paul Ramsey)
- Geography type and supporting functions
- Spherical algorithms from Dave Skea
- Object/index implementation from Paul Ramsey
- Selectivitiy implementation from Mark Cave-Ayland
- Serializations (KML, GML, JSON) from Olivier Courtin
- ST_Area, ST_Distance, ST_DWithin, ST_GeogFromText, ST_GeogFromWKB,
ST_Intersects, ST_Covers, ST_Buffer
- Documentation updates and improvements (Regina Obe, Kevin Neufeld)
- Testing and quality control (Regina Obe)
- PostGIS 1.5 support PostgreSQL 8.5 trunk (Guillaume Lelarge)
- Many many other changes:
http://trac.osgeo.org/postgis/query?status=closed&milestone=PostGIS+1.5.0
PostGIS 1.4.1
2009/11/28
- This is a bug fix release, addressing issues that have been
filed since the 1.4.0 release.
- Bug Fixes
- #241, crash in ST_LineCrossingDirection
- #210, segmentation faults in ST_Union with NULLs
- #277, crash on very large numeric inputs
- #179, ST_MakeLine crash server with NULLs
- #253, inconsistent results when using the ~= operator
- #276, ST_AsGML producing non-compliant GML
- #239, memory issues with ST_As* functions
- #272, ST_LineCrossingDirection should be negatively symmetric
- #316, parsing problem for invalid higher dimensional geometries
PostGIS 1.4.0
2009/06/XX
- API Stability
- As of the 1.4 release series, the public API of PostGIS will not
change during minor releases.
- Compatibility
- The versions below are the *minimum* requirements for PostGIS 1.4
- PostgreSQL 8.2 and higher on all platforms
- GEOS 3.0 and higher only
- PROJ4 4.5 and higher only
- New Features
- ST_Union() uses high-speed cascaded union when compiled against
GEOS 3.1+ (Paul Ramsey)
- ST_ContainsProperly() requires GEOS 3.1+
- ST_Intersects(), ST_Contains(), ST_Within() use high-speed cached
prepared geometry against GEOS 3.1+ (Paul Ramsey / funded by Zonar Systems)
- Vastly improved documentation and reference manual
(Regina Obe & Kevin Neufeld)
- Figures and diagram examples in the reference manual (Kevin Neufeld)
- ST_IsValidReason() returns readable explanations for validity
failures (Paul Ramsey)
- ST_GeoHash() returns a geohash.org signature for geometries
(Paul Ramsey)
- GTK+ multi-platform GUI for shape file loading (Paul Ramsey)
- ST_LineCrossingDirection() returns crossing directions (Paul Ramsey)
- ST_LocateBetweenElevations() returns sub-string based on Z-ordinate.
(Paul Ramsey)
- Geometry parser returns explicit error message about location of
syntax errors (Mark Cave-Ayland)
- ST_AsGeoJSON() return JSON formatted geometry (Olivier Courtin)
- Populate_Geometry_Columns() -- automatically add records to
geometry_columns for TABLES and VIEWS (Kevin Neufeld)
-- ST_MinimumBoundingCircle() -- returns the smallest circle
polygon that can encompass a geometry (Bruce Rindahl)
- Enhancements
- Core geometry system moved into independent library, liblwgeom.
(Mark Cave-Ayland)
- New build system uses PostgreSQL "pgxs" build bootstrapper.
(Mark Cave-Ayland)
- Debugging framework formalized and simplified. (Mark Cave-Ayland)
- All build-time #defines generated at configure time and placed in
headers for easier cross-platform support (Mark Cave-Ayland)
- Logging framework formalized and simplified (Mark Cave-Ayland)
- Expanded and more stable support for CIRCULARSTRING,
COMPOUNDCURVE and CURVEPOLYGON, better parsing, wider support
in functions (Mark Leslie & Mark Cave-Ayland)
- Improved support for OpenSolaris builds (Paul Ramsey)
- Improved support for MSVC builds (Mateusz Loskot)
- Updated KML support (Olivier Courtin)
- Unit testing framework for liblwgeom (Paul Ramsey)
- New testing framework to comprehensively exercise every PostGIS
function (Regine Obe)
- Performance improvements to all geometry aggregate functions
(Paul Ramsey)
- Support for the upcoming PostgreSQL 8.4 (Mark Cave-Ayland, Talha Bin
Rizwan)
- Shp2pgsql and pgsql2shp re-worked to depend on the common
parsing/unparsing code in liblwgeom (Mark Cave-Ayland)
- Use of PDF DbLatex to build PDF docs and preliminary instructions for build (Jean David Techer)
- Automated User documentation build (PDF and HTML) and Developer Doxygen Documentation (Kevin Neufeld)
- Automated build of document images using ImageMagick from WKT geometry text files (Kevin Neufeld)
- More attractive CSS for HTML documentation (Dane Springmeyer)
- Bug fixes
- http://trac.osgeo.org/postgis/query?status=closed&milestone=postgis+1.4.0&order=priority
PostGIS 1.3.6
2009/05/04
- Enhancement - PostgreSQL 8.4 compile support (Talha Rizwan, Mark Cave-Ayland)
- Fix Big fixes for CURVE handling in many functions
(Mark Cave-Ayland, Mark Leslie)
- Enhancement Trac#34 - pgsql2shp now creates .prj files where applicable (Regina Obe)
- Fix Trac#88 - Windows Vista pgsql2shp memory bug (Regina Obe)
- Fix Trac#146 - for distance calculation on collections (Nicklas Avén, Paul Ramsey)
- Fix Trac#116 - crashers for rare EWKB cases (Paul Ramsey)
- Fix to address an SRID of -1 in probe_geometry_columns (Kevin Neufeld)
- Fix Trac#99 shp2pgsql logical error when importing DBF-only (Regina Obe)
- Fix Trac#105 pgsql2shp dbase file creation (EOF marker issue) (Paul Ramsey)
- Fix updated AddGeometryColumn to throw an error if then specified schema does not exist,
rather than throwing a notice and then an error. (Kevin Neufeld)
- Fix - Documentation corrections for better handling with PDF DbLatex (Kevin Neufeld)
PostGIS 1.3.5
2008/12/15
- A quick bug fix release, to remove crashes in cases of
collecting LINESTRING (ST_Force_Collection(), ST_Multi())
that had a large affect on Mapserver with LINE layers.
- Enhancements and Bug Fixes
- GBT#21: improve LRS fix to apply to more platforms
- GBT#72: fix st_estimated_extent for better schema sensitivity
- GBT#80: segfault on st_multi in MULTILINESTRING repaired
- GBT#83: segfault on collecting LINESTRING repaired
PostGIS 1.3.4
2008/11/24
- New Features
- Add new ST_AsGeoJSON() function to allow conversion of
geometries to GeoJSON format within the database. (Olivier Courtin)
- Add forthcoming PostgreSQL 8.4 support
(Paul Ramsey, Mark Cave-Ayland)
- Improved CSS for PostGIS documentation (Dane Springmeyer)
- Inclusion of new "postgis_comments.sql" file to enable detailed
function comments to be installed for PostGIS functions. This
attaches a description and associated parameter information
to each function so that this information is available directly
within psql/pgAdmin (Regina Obe)
- Enhancements and Bug Fixes
- General documentation improvements (Regina Obe, Kevin Neufield)
- Improve PiP code by removing substantial memory leaks and adding
multi-polygon support (Paul Ramsey)
- Improve GiST consistent performance (Paul Ramsey)
- GBT#20: Improved algorithm for ST_DWithin (Paul Ramsey)
- GBT#21: locate_along_measure: wrong values, invalid data
(Mark Cave-Ayland)
- GBT#23: wrong proj4text in spatial_ref_sys for SRID 31300 and 31370
(Paul Ramsey)
- GBT#43: Heap over-read in compute_geometry_stats() (Landon Fuller)
- GBT#44: ST_Relate(geom,geom,pattern) is case sensitive (Paul Ramsey)
- GBT#45: bug in postgis_restore.pl - not passing options to createdb
(Paul Ramsey)
- GBT#58: bounding box of circular string is incorrect (Mark Leslie)
- GBT#65: ST_AsGML kills the backend when fed a CIRCULAR STRING
(Mark Cave-Ayland)
- GBT#66: ST_Dump kills backend when fed CIRCULAR STRING
(Mark Cave-Ayland)
- GBT#68: ST_Shift_Longitude doesn't work with MULTIPOINT
(Mark Cave-Ayland)
- GBT#69: ST_Translate crashes when fed circular string
(Mark Cave-Ayland)
- GBT#70: ST_NPoints Crashes with Curves (Mark Cave-Ayland)
PostGIS 1.3.3
2008/04/12
- shp2pgsql, pgsql2shp improvements
- regression tests on Windows
- OS/X 10.5 compatibility
- DBF-only loading flag (-n)
- fix to Date DBF output
- ST_SimplifyPreserveTopology(geometry, float8)
Allows simplification of polygons without creating
invalid geometries.
- Fix to |>> and <<| operators
- Build system more sensitive to GEOS version number
- KML support updates (from Eduin Carrillo)
- SVG support updates (from Marco Hugentobler)
PostGIS 1.3.2
2007/12/01
- Improvements in the TIGER geocoder
- Fix to ST_EndPoint() crasher bug
- Modified ST_AsGML() improving v2 and adding v3 support
- Fix to ensure ST_Envelope() returns valid geometries
- Change JDBC build to use Ant
- Fix for better OS/X support
- Fix to WKB parser to do simple validity checks
PostGIS 1.3.1
2007/08/13
- Fixed documentation bugs and release number errors
in previous cut
PostGIS 1.3.0
2007/08/09
- Began migration of functions to the SQL-MM-centric naming convension
using the spatial type (SP) prefix
- Performance enhancements:
- Created cached and indexed point-in-polygon short-circuits
for the functions ST_Contains, ST_Intersects, ST_Within
ST_Disjoint.
- Added inline index support for relational functions
(except disjoint)
- Added ST_Covers, ST_CoveredBy and ST_DWithin relational functions
- Extended curved geometry support to geometry accessor functions and
some geometry processing functions
- JDBC: Added Hibernate Dialect from Norman Barker
- Enhanced regression tests for curved geometries and kml functions
PostGIS 1.2.1
2007/01/11
- Fix point-in-polygon shortcut bug in Within()
- Fix PgSQL 8.2 null handling for indexes
- Update RPM spec files
- Add AsKML() function
- Add short-circuit for transform() in no-op case
- JDBC: - Fixed JTS handling for multi-dimensional geometries
(thanks to Thomas Marti for hint and partial patch)
- Additionally, now JavaDoc is compiled and packaged
- Fixed classpath problems with GCJ
- Fixed pgjdbc 8.2 compatibility, losing support for
jdk 1.3 and older.
PostGIS 1.2.0
2006/12/08
- Added curved geometry type support for serialization/deserialization.
- Added point-in-polygon shortcircuit to Contains and Within functions.
- JDBC: Added awt.shape implementation for JTS geometries
- EJB3: Fixed NullPointer bug, thanks to Norman Barker
PostGIS 1.1.6
2006/11/02
- fixed CAPI change that broke 64-bit platforms
- use Z ordinate in reprojections
- spatial_ref_sys.sql updated to EPSG 6.11.1
- Simplified Version.config infrastructure to use a single
pack of version variables for everything.
- Include the Version.config in loader/dumper USAGE messages
- Replace hand-made, fragile JDBC version parser with Properties
- Fixed setSRID() bug in JDBC, thanks to Thomas Marti
- loader/dumper: fixed regression tests and usage output
PostGIS 1.1.5
2006/10/13
- Java:
- Removed obsolete synchronization from Jts code.
- fixed nullpointer Exception in Geometry.equals() method
- Added EJB3Spatial.odt to fulfill the GPL requirement of
distributing the "preferred form of modification"
- Added -S option for non-multi geometries to shp2pgsql
- Updated heavily outdated README files for shp2pgsql/pgsql2shp by
merging them with the manpages.
- Fixed MingW link error that was causing pgsql2shp to
segfault on Win32 when compiled for PostgreSQL 8.2
PostGIS 1.1.4
2006/09/27
- Fixed support for PostgreSQL 8.2
- Fixed bug in collect() function discarding SRID of
input
- Added SRID match check in MakeBox2d and MakeBox3d
- Fixed regress tests to pass with GEOS-3.0.0
- Improved pgsql2shp run concurrency.
- Java:
- reworked JTS support to reflect new upstream
JTS developers' attitude to SRID handling.
Simplifies code and drops build depend on GNU trove.
- Added EJB2 support generously donated by the
"Geodetix s.r.l. Company" http://www.geodetix.it/
- Added EJB3 tutorial / examples donated by
Norman Barker <nbarker@ittvis.com>
- Reorganized java directory layout a little.
PostGIS 1.1.3
2006/06/30
- NEW Long Transactions support.
- Can run the regress tests with 'make check' now.
- New regress test support for loader/dumper.
- BUGFIX in pgsql2shp successful return code.
- BUGFIX in shp2pgsql handling of MultiLine WKT.
- BUGFIX in affine() failing to update bounding box.
- WKT parser: forbidden construction of multigeometries with
EMPTY elements (still supported for GEOMETRYCOLLECTION).
- Added --with-proj-libdir and --with-geos-libdir configure
switches.
- JDBC:
- Improved regression tests: MultiPoint and scientific ordinates
- Fixed some minor bugs in jdbc code
- Added proper accessor functions for all fields in preparation of
making those fields private later
- Support for build Tru64 build.
- Use Jade for generating documentation.
- NEW DumpRings() function.
- BUGFIX in distance(poly,poly) giving wrong results.
- NEW AsHEXEWKB(geom, XDR|NDR) function.
- Don't link pgsql2shp to more libs then required.
- Initial support for PostgreSQL 8.2.
PostGIS 1.1.2
2006/03/30
- Regress tests can now be run *before* postgis intallation
- BUGFIX in SnapToGrid() computation of output bounding box
- More portable ./configure script
- Changed ./run_test script to have more sane default behaviour
- Fixed support for 64bit archs
- jdbc2 SRID handling fixes in JTS code
- New affine() matrix transformation functions
- New rotate{,X,Y,Z}() function
- Old translating and scaling functions now use affine() internally
- BUGFIX in EnforceRHR()
- Embedded access control in estimated_extent() for builds against
pgsql >= 8.0.0
PostGIS 1.1.1
2006/01/23
- Source code cleanups
- Solaris 2.7 and MingW support improvements
- added NumInteriorRing() alias due to OpenGIS ambiguity
- BUGFIX in geometrycollection handling of GEOS-CAPI connector
- BUGFIX in line_locate_point()
- Fixed handling of postgresql paths
- Fixed a premature exit in postgis_restore.pl
- BUGFIX in line_substring()
- New Z and M interpolation in line_substring()
- New Z and M interpolation in line_interpolate_point()
- Added support for localized cluster in regress tester
PostGIS 1.1.0
2005/12/21
- New functions:
- scale() and transscale() companion methods to translate()
- line_substring()
- line_locate_point()
- M(point)
- LineMerge(geometry)
- shift_longitude(geometry)
- azimuth(geometry)
- locate_along_measure(geometry, float8)
- locate_between_measures(geometry, float8, float8)
- SnapToGrid by point offset (up to 4d support)
- BuildArea(any_geometry)
- OGC BdPolyFromText(linestring_wkt, srid)
- OGC BdMPolyFromText(linestring_wkt, srid)
- RemovePoint(linestring, offset)
- ReplacePoint(linestring, offset, point)
- Bug fixes:
- Fixed memory leak in polygonize()
- Fixed bug in lwgeom_as_anytype cast funcions
- Fixed USE_GEOS, USE_PROJ and USE_STATS elements
of postgis_version() output to always reflect
library state.
- Function semantic changes:
- SnapToGrid doesn't discard higher dimensions
- Changed Z() function to return NULL if requested
dimension is not available
- Peformance improvements:
- Much faster transform() function, caching proj4 objects
- Removed automatic call to fix_geometry_columns() in
AddGeometryColumns() and update_geometry_stats()
- jdbc2 works:
- Makefile improvements
- JTS support improvements
- Improved regression test system
- Basic consistency check method for geometry collections
- Support for (Hex)(E)wkb
- Autoprobing DriverWrapper for HexWKB / EWKT switching
- fix compile problems in ValueSetter for ancient jdk releases.
- fix EWKT constructors to accept SRID=4711; representation
- added preliminary read-only support for java2d geometries
- Other new things:
- Full autoconf-based configuration, with
PostgreSQL source dependency relief
- GEOS C-API support (2.2.0 and higher)
- Initial support for topology modelling
- Debian and RPM specfiles
- New lwpostgis_upgrade.sql script
- Other changes:
- JTS support improvements
- Stricter mapping between DBF and SQL integer and
string attributes
- Wider and cleaner regression test suite
- old jdbc code removed from release
- obsoleted direct use of postgis_proc_upgrade.pl
- scripts version unified with release version
PostGIS 1.0.6
2005/12/06
- Fixed palloc(0) call in collection deserializer (only gives
problem with --enable-cassert)
- Fixed bbox cache handling bugs
- Fixed geom_accum(NULL, NULL) segfault
- Initial support for postgresql 8.2
- Fixed segfault in addPoint()
- Fixed short-allocation in lwcollection_clone()
- Fixed bug in segmentize()
- Added missing SRID mismatch checks in GEOS ops
- Fixed bbox computation of SnapToGrid output
PostGIS 1.0.5
2005/11/25
- New "Reporting Bugs" chapter in manual
- Segfault fix in shp2pgsql (utf8 encoding)
- Fixed computation of null values fraction in analyzer
- Fixed return code of shp2pgsql
- Fixed handling of trailing dots in dbf numerical attributes
- Schema aware postgis_proc_upgrade.pl, support for pgsql 7.2+
- Fixed a small bug in the getPoint4d_p() low-level function
- Fixed memory alignment problems
- Speedup of serializer functions
- Bug fix in force_4d, force_3dm and force_3dz functions
PostGIS 1.0.4
2005/09/09
- Memory leak plugged in GiST indexing
- Segfault fix in transform() handling of proj4 errors
- Fixed some proj4 texts in spatial_ref_sys (missing +proj)
- GiST indexing cleanup
- Loader: fixed string functions usage, reworked NULL objects check,
fixed segfault on MULTILINESTRING input.
- Fixed bug in MakeLine dimension handling
- Looser syntax acceptance in box3d parser
- Documentation improvements
- More robust selectivity estimator
- Minor speedup in distance()
- Minor cleanups
- Fixed bug in translate() corrupting output bounding box
- Initial implementation of postgis_proc_upgrade script
PostGIS 1.0.3
2005/08/08
- Severe bugfix in lwgeom's 2d bounding box computation
- Bugfix in WKT (-w) POINT handling in loader
- Bugfix in dumper on 64bit machines
- Bugfix in dumper handling of user-defined queries
- Bugfix in create_undef.pl script
- Small performance improvement in canonical input function
- Minor cleanups in loader
- Support for multibyte field names in loader
- Improvement in the postgis_restore.pl script
- New rebuild_bbox_caches.pl util script
PostGIS 1.0.2
2005/07/04
- Fault tolerant btree ops
- Memory Leak fix in pg_error
- Rtree index fix. See:
http://archives.postgresql.org/pgsql-hackers/2005-06/msg01108.php
- Initial support for postgresql 8.1dev
- Cleaner build scripts: avoided mix of CFLAGS and CXXFLAGS
- NEW -I switch for pgsql2shp (GiST index)
PostGIS 1.0.1
2005/05/24
- BUGFIX in shp2pgql escape functions
- BUGFIX in 3d computation of lenght_spheroid
- better support for concurrent postgis in multiple schemas
- documentation fixes
- BUGFIX in join selectivity estimator returning invalid estimates (>1)
- jdbc2: compile with "-target 1.2 -source 1.2" by default
- NEW support for custom createdb options in postgis_restore.pl
- NEW -k switch for pgsql2shp
- BUGFIX in pgsql2shp attribute names unicity enforcement
- BUGFIX in Paris projections definitions
- postgis_restore.pl cleanups
PostGIS 1.0.0
2005/04/19
- NEW manual pages for loader/dumper
- NEW shp2pgsql support for old (HWGEOM) postgis versions
- NEW -p flag for shp2pgsql
- BUGFIX in transform() releasing random memory address
- BUGFIX in force_3dm() allocating less memory then required
- NEW chapter about OGC compliancy enforcement
- BUGFIX in shp2pgsql escape of values starting with "'" or "\t"
- NEW autoconf support for JTS lib
- BUGFIX in estimator testers (support for LWGEOM and schema parsing)
- BUGFIX in join selectivity estimator (defaults, leaks, tuplecount, sd)
PostGIS 1.0.0RC6
2005/03/30
- BUGFIX dumper 64bit
- BUGFIX in multi()
- BUGFIX in postgis_restore.pl script
- early return [when noop] from multi()
- dropped {x,y}{min,max}(box2d) functions
PostGIS 1.0.0RC5
2005/03/25
- small build scripts refinements
- BUGFIX in box3d computation (yes, another!)
- BUGFIX in estimated_extent()
- additional performance tips documented
PostGIS 1.0.0RC4
2005/03/18
- early return from force_collection
- segfault fix in geom_accum()
- consistency check fix in SnapToGrid()
- jdbc2: code cleanups, Makefile improvements
- FLEX & YACC variables set *after* pgsql Makefile.global
is included and only if the pgsql *stripped* version
evaulates to the empty string
- added already generated parser in release
- build scripts refinements
- MultiLine handling BUG fix in loader and dumper
- improved version handling, central Version.config
- added distance_sphere function
- subselects support in selectivity estimator
- bug fixes for 64bit architectures
- bugfix in loaded, skipping all but first hole of polygons.
- changed get_proj4_from_srid implementation to use plpgsql
instead of sql to workaround a pgsql80x bug.
- box2d output changed back to 15 significant digits
- BUGFIX in box3d computation function with collections
- improvements in postgis_restore.pl
PostGIS 1.0.0RC3
2005/02/24
- transform(): missing SRID bugfix, better error handling
- jdbc2: small patches, box2d/3d tests, revised docs and license.
- jdbc2: bug fix and testcase in for pgjdbc 8.0 type autoregistration
- few changes in autoconf
- reduced precision of box2d output.
- some functions made IMMUTABLE from STABLE,
for performance improvement
- new performance tips chapter in manual
- BUILDDATE extraction made more portable
- fixed bogus 72 index bindings
- prefixed DEBUG macros with PGIS_ to avoid clash with pgsql one
- fixes in probe_geometry_columns() to work with PG72 and support
multiple geometry columns in a single table
- fixed spatial_ref_sys.sql to avoid vacuuming the whole database.
- jdbc2: Removed use of jdk1.4 only features to enable build with
older jdk releases.
- jdbc2: Added support for building against pg72jdbc2.jar
- documentation updates: pgsql72 requirement, lwpostgis.sql
- memory alignment handling
- fixed bug in force_collection causing mapserver connector
failures on simple (single) geometry types.
- jdbc2: updated and cleaned makefile
- plugged a leak in GEOS2POSTGIS converter
- jdbc2: added BETA support for jts geometry classes
- jdbc2: Skip known-to-fail tests against older PostGIS servers.
- jdbc2: Fixed handling of measured geometries in EWKT.
- Reduced memory usage by early releasing query-context palloced one.
- Added bool::text cast in lwpostgis.sql
- bug fix in GeometryFromText() missing to add a bbox cache.
- spatial_ref_sys: changed Paris entries to match the ones
distributed with 0.x.
PostGIS 1.0.0RC2
2005/01/26
- More correct STABLE, IMMUTABLE, STRICT uses in lwpostgis.sql
- GEOMETRYCOLLECTION(EMPTY) syntax support for backward compatibility
- faster and more robust loader (both i18n and not)
- faster binary outputs
- bug fix in pointarray box3d computation
- initial autoconf script
- bug fix in distance_spheroid definition
- stricter OGC WKB constructors
- stricter OGC WKT constructors
- bug fix in transform() missing to update bbox cache
- LWGEOM aware JDBC driver (jdbc2)
PostGIS 1.0.0RC1
2005/01/13
- New Things
- Objects are all now "lightweight" with a smaller disk
and index representation. Large databases should see a moderate
to large performance increase.
- Objects now have a hexidecimal canonical representation.
To see a "user friendly" version of the objects use the
AsText() function.
- The loader and dumper use the hexidecimal canonical representation,
so coordinate drift due to floating point string parsing is now
eliminated.
- New functions: UpdateGeometrySRID(), AsGML(), SnapToGrid(),
ForceRHR(), estimated_extent(), Accum().
- Vertical positioning operators.
- Geometry constructors/editors.
- Coordinate dimensions handling (up to 4d).
- API.
- Join selectivity.
- Bug Fixes
- Numerous small fixes.
PostGIS 0.9.0
2004/09/10
- New Things
- GEOMETRY_COLUMNS management functions
- fix_geometry_columns(), probe_geometry_columns()
- Support for PgSQL 8.0 / Support for Win32
- Support for GEOS 2.0
- Bug Fixes
- Schema support in shp2pgsql/pgsql2shp improved
- Spatial index estimator improved
- Build system streamlined
PostGIS 0.8.2
2004/05/27
- New Things
- PgSQL 7.5 Support
- Integrated PgSQL 7.5 statistics rathering
- Improved schema support
- Optional experimental lightweight geometries (LWGEOM)
- Faster performance
- Lower disk usage
- Multi() function to create MULTI* geometries
- line_interpolate_point() function for linear referencing
- Bug Fixes