H2GIS

H2GIS version 1.5.0 use:

• H2 version 1.4.197
• JTS version 1.15
• CTS 1.5.2

Change log

This release introduces a significant change in package naming. The JTS library has switched from com.vividsolutions to org.locationtech packages and all H2GIS functions has been updated to follow it.

Enhancements

For a complete description of the changes, please consult this list.

Download

Download H2GIS : https://github.com/orbisgis/h2gis/releases/tag/v1.5.0

H2GIS version 1.4.0 use H2 version 1.4.196 and JTS version 1.14.

Change log

Bugs

• Fix ST_GRAPH : remove temporary tables
• Fix ST_TRANSFORM : reset cache of cloned geometries
• Fix ST_OSMDOWNLOADER

Enhancements

• Drivers support empty tables

Features

• Add ST_DRAPE()
• Add ST_NODE()
• Add ST_POINT()
• Add ST_SVF()
• Add JSON write driver

Download

Download H2GIS : https://github.com/orbisgis/h2gis/releases/tag/v1.4.0

H2GIS version 1.3.2 use H2 version 1.4.196 and JTS version 1.14.

Change log

Bugs

• Fix Invalid cost of PK Index,
• Fix on geojson driver.

Enhancements

• Add support to 2008 and RFC 7946 specification for GeoJson driver,
• Update H2 database to 1.4.196.

Features

• Fix the readme to have the correct alias/classname CREATE ALIAS IF NOT EXISTS H2GIS_SPATIAL FOR “org.h2gis.functions.factory.H2GISFunctions.load”,
• Set postgis-jts-osgi to LPGL,
• Add docs for DoubleRange and IntegerRange functions,
• Add on ST_RemoveRepeatedPoint with tolerance,
• Improve ST_Expand,
• Update OSMRead, GPXRead and ST_Graph due to the new argument “delete the existing tables”.

Download

Download H2GIS : https://github.com/orbisgis/h2gis/releases/tag/v1.3.2

H2GIS version 1.3.1 use H2 version 1.4.193 and JTS version 1.14.

Change log

Bugs

• Read the .prj file and set the SRID from FILE_TABLE interface,
• Align ST_NumInteriorRing() to SQL/MM,
• ST_Length() works only with Line, Curve and MultiLine and MultiCurve,
• Fixes on GeoJSON driver.

Enhancements

• ST_Graph() is now compatible with a PostGIS database,
• Add ST_Expand() support distance for X and Y,
• Update to JTS 1.14,
• Update to H2 1.4.193,
• CSV, OSM and GPX drivers support options (encoding, field separators, delete existing tables…),
• Add cancel action on the CSV driver,
• ST_OSMDownloader() supports a delete argument to remove the downloaded file.

Features

• H2GISversion() returns the H2GIS version,
• ST_Collect() is an alias of ST_Accum(),
• Add ST_NPoints() and fix ST_NumPoints() to be conform to SQL/MM,
• Add TSV importer and exporter drivers and functions,
• Add ST_GeomFromWKB(),
• Add ST_RemoveRepeatedPoints() and ST_RemoveDuplicatedCoordinates(),
• Add ST_MakeValid() to return a valid geometry.

Documentation

ST_Accum(), ST_Collect(), ST_NPoints(), ST_RemoveRepeatedPoints(), ST_RemoveDuplicatedCoordinates(), ST_MakeValid(), ST_Graph() H2 Network examples up to date.

Download

Download H2GIS : https://github.com/orbisgis/h2gis/releases/tag/v1.3.1

H2GIS version 1.3.0 use H2 version 1.4.190

Change log

This version introduces two major changes in H2GIS.

H2GIS new license

The H2GIS license has been changed from GPL 3 to LGPL3. This modification has been decided by the OrbisGIS team to facilitate innovation by promoting technology transfer. Communities are welcome to use H2GIS in commercial application as a library and re-distribute their application under any license you choose. The effort received from the OrbisGIS team is an invitation to distribute scientific tools in your network and build innovative applications based on it. Feel free to support the H2GIS development and promote it!

H2GIS refactoring

The version 1.3.0 proposes a new organization for H2GIS modules and packages to make it easier to understand. Now all spatial and drivers functions are collected in the H2GIS-functions module. H2Network functions are stored in the H2Network module. This module is loaded by the H2GIS-EXT project. H2GIS-EXT project is the main project to extend H2GIS-functions with new features (Raster, Topology in the future).

If the user needs only the basic spatial functions it must apply the SQL syntax

CREATE ALIAS IF NOT EXISTS H2GIS_SPATIAL FOR "org.h2gis.functions.H2GISFunctions.load";
CALL H2GIS_SPATIAL()

Otherwise please run the command

CREATE ALIAS IF NOT EXISTS H2GIS_EXTENSION FOR "org.h2gis.ext.H2GISExtension.load";
CALL H2GIS_EXTENSION();

Download

Download H2GIS : https://github.com/orbisgis/h2gis/releases/tag/v1.3.0

H2GIS version 1.2.4 use H2 version 1.4.189

Change log

• Fix ST_SetSRID on null argument.
• Fix ST_Transform on null argument.
• Fix the KML, KMZ, geoJSON export with postgis.
• Fix GPX and geoJSON datatype for postgresql
• Add the support of TSV file (read and write).
• Upgrade H2 database from version 1.4.188 to version 1.4.189.

Download

Download H2GIS : https://github.com/orbisgis/h2gis/releases/tag/v1.2.4

H2GIS version 1.2.3 use H2 version 1.4.188

Change log

• Fix DBF decimal operator overflow error.
• Fix URI storage error when importing database from other operating system (Windows/Linux) Thanks to @bedla for providing the patch #556
• Range index support on system column GID for FileDrivers
• GeoJSON support for mixed geometry types. Thanks for @AngryGamy for reporting the issue #548
• Add ST_GeomFromGML
• Add ST_GeomFromGeoJSON
• Add ST_OSMMapLink
• Add ST_GoogleMapLink
• Add ST_AsGML
• Add ST_GeomFromWKB
• Upgrade H2 database from version 1.4.186 to version 1.4.188

Download

Download H2GIS : https://github.com/orbisgis/h2gis/releases/tag/v1.2.3

H2GIS version 1.2.2 use H2 version 1.4.186

Change log

• Ability to use request in ST_EXPLODE
• Add CSV DriverFunction implementation
• Add a driver to import OSM file
• Create function ARRAY_RANGE and accept ARRAY in ST_TRIANGLECONTOURING
• Add ST_PointFromWKB
• All functions are now documented.
• SHP driver, Read the prj file and store the CRS with a user id in database
• SHP driver, Check if Polygon is saved with POLYGONZ
• SHP driver, Throw an exception when trying to export mixed geometry type.
• Fix DBFWrite column offset.
• Rename ST_CollectExtract to ST_CollectionExtract

New Function list:

• ST_3DArea
• ST_3DPerimeter
• ST_BoundingCircleCenter
• ST_FlipCoordinates
• ST_GeometryShadow
• ST_LongestLine
• ST_MaxDistance
• ST_MinimumBoundingCircle
• ST_Perimeter
• ST_Tessellate
• ST_Voronoi
• ST_SunPosition
• ST_GeometryShadow
• ST_LineMerge

Download

Download H2GIS : https://github.com/orbisgis/h2gis/releases/tag/v1.2.2

H2GIS version 1.1.1 use H2 version 1.3.176

Change log

• OpenStreetMap import functions. Read large OpenStreetMap .osm or .osm.bz2 and convert lossless to database tables.
• autoincrement primary key column is added for linked/imported files

New Function list:

• ST_OSMDownloader
• ST_ProjectPoint
• ST_OffSetCurve
• ST_ShortestPathTree
• ST_LineIntersector
• OSMRead
• ST_CollectExtract
• DoubleRange
• IntegerRange
• ST_SideBuffer
• ST_RingSideBuffer

Download

Download H2GIS : https://github.com/orbisgis/h2gis/releases/tag/v1.1.1

H2GIS version 1.1.0 use H2 version 1.3.176

Change log

• Handle GeoJSON format
• Handle GPX format
• Handle KML format
• Fix DBFReader with more file encoding
• Fix CTS issues with mutable Geometry
• H2 Network functions

New Function list:

• GPXRead
• GeoJsonRead
• GeoJsonWrite
• KMLWrite
• ST_3DLength
• ST_AddPoint
• ST_AddZ
• ST_AsGeoJSON
• ST_AsKml
• ST_BoundingCircle
• ST_ClosestCoordinate
• ST_ClosestPoint
• ST_CompactnessRatio
• ST_ConstrainedDelaunay
• ST_Covers
• ST_DWithin
• ST_Delaunay
• ST_Densify
• ST_Expand
• ST_Explode
• ST_Extent
• ST_Extrude
• ST_FurthestCoordinate
• ST_Holes
• ST_Interpolate3DLine
• ST_IsRectangle
• ST_IsValid
• ST_LocateAlong
• ST_MakeEllipse
• ST_MakeEnvelope
• ST_MakeGrid
• ST_MakeGridPoints
• ST_MakeLine
• ST_MakePoint
• ST_MinimumRectangle
• ST_MultiplyZ
• ST_Normalize
• ST_OctogonalEnvelope
• ST_Polygonize
• ST_PrecisionReducer
• ST_RemoveHoles
• ST_RemovePoint
• ST_RemoveRepeatedPoints
• ST_Reverse
• ST_Reverse3DLine
• ST_Rotate
• ST_Scale
• ST_Simplify
• ST_SimplifyPreserveTopology
• ST_Snap
• ST_Split
• ST_ToMultiLine
• ST_ToMultiPoint
• ST_ToMultiSegments
• ST_Translate
• ST_TriangleAspect
• ST_TriangleContouring
• ST_TriangleDirection
• ST_TriangleSlope
• ST_UpdateZ
• ST_XMax
• ST_XMin
• ST_YMax
• ST_YMin
• ST_ZMax
• ST_ZMin
• ST_ZUpdateLineExtremities
• ST_MinimumDiameter
• ST_RingBuffer
• ST_Force2D
• ST_Force3D
• ST_Azimuth
• ST_MakePolygon
• ST_IsValidReason
• ST_IsValidDetail
• ST_Accessibility
• ST_ConnectedComponents
• ST_Graph
• ST_GraphAnalysis
• ST_ShortestPath
• ST_ShortestPathLength

Download

Download H2GIS : https://github.com/orbisgis/h2gis/releases/tag/v1.1.0

Change log

This release fixes a few errors in the various poms.

Download

Download H2GIS : https://github.com/orbisgis/h2gis/releases/tag/v1.0.2

Change log

We are proud to announce the first major release of H2GIS!

This release includes the implentations of all functions given by the OpenGIS Simple Features Implementation Specification for SQL version 1.2.1.

Download

Download H2GIS : https://github.com/orbisgis/h2gis/releases/tag/v1.0.1