[postgis-users] PostGIS 2.1.0 released

Sat Aug 17 18:46:28 PDT 2013

The 2.1.0 release of PostGIS is now available.
http://download.osgeo.org/postgis/source/postgis-2.1.0.tar.gz

The PostGIS development team is proud to release PostGIS 2.1.0. As befits a
minor release, the focus is on speed improvements, more features, and bug
fixes. 

If you are currently using PostGIS 2.0+, you can go the soft upgrade path:

ALTER EXTENSION postgis UPDATE TO "2.1.0";

If you are running 2.1.0 of beta or an unreleased version (and the above
step fails with error "extension postgis has no update path from version
x.x.x to version 2.1.0") , you need to first copy the file in
share\extensions\postgis-2.0.3-2.1.0.sql and change the 2.0.3 to the x.x.x
noted in the error you are running. Then follow the above upgrade step
again.

Users of 1.5 and below will need to go the hard-upgrade path documented in
manual:
http://postgis.net/docs/manual-2.1/postgisinstallation.html#hardupgrade

Best served with a bottle of GEOS 3.4.1 and PostgreSQL 9.3beta2 (planned
9.1.0 release is September).

http://download.osgeo.org/postgis/source/postgis-2.1.0.tar.gz

html doc: http://download.osgeo.org/postgis/docs/doc-html-2.1.0.tar.gz
pdf doc: http://download.osgeo.org/postgis/docs/postgis-2.1.0.pdf
epub doc: http://download.osgeo.org/postgis/docs/postgis-2.1.0.epub

This release contains a ton of speed improvements, function additions, and
super sexy new features. It has been over a year in the making.

New functions itemized in
http://postgis.net/docs/manual-2.1/PostGIS_Special_Functions_Index.html#NewF
unctions21

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: lwgeomsethandlers replaces lwgeominitallocators.
    #2150, regularblocking is no longer a constraint. column of same name in
rastercolumns now checks for existance of spatiallyunique and coveragetile
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_LineInterpolatePoint renamed to ST_LineInterpolatePoint
    ST_Line_Substring renamed to ST_LineSubstring
    ST_LineLocatePoint 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

        #310, ST_DumpPoints converted to a C function - much faster (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)
        lwgeomfromgeojson 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 postgissfcgalversion New
function available in PostGIS: ST_ForceSFS (Olivier Courtin and Hugo Mercier
/ Oslandia)

Enhancements

    #823, tiger geocoder: Make loadergeneratescript 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 ndstatsto_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

Happy querying,
Team PostGIS