v2.2.5

Changelog for v2.2.5

Minor release to exclude graalvm native image dependencies

v2.2.4

Changelog for v2.2.4

• Add ST_EnvelopeAsText function
• Add ST_AsOverpassBbox function
• Add ST_OverpassDownloader function
• Add ST_SimplifyVW function
• Fix bug when read GeometryCollection with the ST_GeomFromGeoJSON function
• Fix write empty table to FGB file
• Fix github actions
• Fix mixed srid error on empty geometry with ST_Extent #1400
• Remove transitive dependency from flatgeobuffer to JTS version 1.19 (should use 1.20 of jts-core)
• Allow ST_GRAPH to be executed with empty geometry
• Allow ST_GRAPH to be executed when the input table contains an autoincrement column and not only a PK
• Fix bug when read GeometryCollection with the ST_GeomFromGeoJSON function
• ST_MAKEGRID and ST_MAKEGRIDPOINTS : add an option to order the cells starting from the upper left corner
• Change ST_Collect to scalar function
• Upgrade the version of FlatGeoBuffer driver (update of guava, flatbuffer)
• Fix ST_MemSize typo
• Fix doc for ST_SimplifyVW
• Fix typo on FlatGeobuf driver
• Fix doc on ST_MaximumInscribedCircle
• Fix typo on ST_Force3DM
• ST_Force3DM returns MULTIPOINT instead of GEOMETRYCOLLECTION M -
• Implement ST_M correctly
• Fix write empty table in FGB file
• Fix ST_FORCE2D to return 2D coordinates
• Use central portal to publish snapshots
• New readthedoc documentation
• Add native compilation using graalvm (creates lib and executable)
• Exposes C API using graalvm to allow the lib to communicate with other programs
• Fix an error for C API fetch_rows
• Replace Poly2Tri by Tinfour library, signature of ST_ConstrainedDelaunay now have a minDistancePoint parameter for merging input coordinates
• Fix storage of Boolean and Byte type of the Flat GeoBuffer storage driver issue #1437
• Fix transformation from 27700 to 4326
• Update to CTS 1.7.2-SNAPSHOT
• Rename ST_TESSELLATE to ST_Tesselate
• Use JTS algorithm in ST_Tesselate
• Add ST_TriangulatePolygon
• Add ST_MaximumInscribedCircleRadius
• Add ST_SimplifyPolygonHull
• Use RelateNG instead of Relate algorithm
• Add missing implementation on PostGIS datasource wrapper (unwrap and iswrapper)
• Use connection isWrapperFor instead of static class package search for checking if connection is H2 or POSTGIS
• Fix timestamp and data IO with FlatGeoBuffer
• Fix writing varchar with FlatGeoBuffer
• Fix FlatGeoBuffer driver, do not read the first row multiple times
• Prepare H2GIS 2.2.4 release

H2SPATIAL

For historical reasons, release of the first version of H2GIS called H2Spatial.

H2GIS's mother ;-)

v2.2.3

This release has been uploaded to fix the declaration of the Flat GeoBuffer driver.

Changelog for v2.2.3

• Forgot to declare FGB driver(W/R) as function

v2.2.2

Changelog for v2.2.2

• Read CPG file attached to the shapefile-
• Declare the schema for the spatial_ref_sys table
• Add SnapToGrid function
• Write empty geometry with the shapefile driver
• Do not ask for SRID when geometry is empty
• Add the name of the file in the FGB header
• Fix null way id on OSM file
• Use new sonatype auth
• Add ST_SnapToSelf function
• Upgrade to H2 2.3.230
• Upgrade to JTS 1.20
• Upgrade to H2 2.3.232
• Add ST_CoverageUnion function

v2.2.1

IMPORTANT

Cost of spatial indexes was historically hard-coded in H2, but all other indexes use a complex formula. The same formula will be used for spatial indexes too in the next H2 version (up to 2.2.224).

See : h2database/h2database#3941 and h2database/h2database#3940

This fix is not available in version 2.2.224 used by H2GIS.
As a consequence, some complex spatial queries may take longer to execute.

Changelog for v2.2.1

• Next version
• Update EPSG 2100 definition for GGRS87 / Greek Grid transformation
• Add geojson utility to convert a resultset to JSON map
• Update postgresql dependency to 42.3.8
• Fix empty polygon with ST_TESSELLATE
• Add ST_ConcaveHull function
• Improve ST_Graph function to keep a list of columns for the edges
• Upgrade H2 database from 2.1.214 to 2.2.220
• Add ST_LineSubstring and ST_LineInterpolatePoint functions
• Add ST_MaximumInscribedCircle function
• Extend ST_CollectionExtract to filter with one or two dimensions
• Add ST_Clip function to a [Multi]Polygon or [Multi]LineString geometry with another [Multi]Polygon or [Multi]LineString geometry
• Add two utilities to return a list of numeric columns or the first one
• Add ST_ForcePolygonCCW and ST_ForcePolygonCW functions
• Add ST_MakeArcLine and ST_MakeArcPolygon functions
• Fix ST_MakeEllipse to keep the SRID of the input point
• Add ST_MinimumBoundingRadius function
• Extend ST_MinimumBoundingRadius to support table or select query
• Extend ST_MinimumBoundingRadius to copy all fields when the input data is a table or a select query
• Add ST_Project function
• Update H2 to 2.2.224 and SLFJ
• Change the h2gis-dist main class from org.h2.tools.Server to org.h2.tools.Console
• Set scope as test for slf4j-simple
• Zip and unzip functions with subfolders
• GeoJson driver must be able to read json extension
• GeoJson handle the M ordinate. The limitation is only ZM is supported (default Z value to 0 if M is given but not Z)
• GeoJson read the optional ID field on feature as an attribute, but currently it will be saved back into feature attribute.
• FlatGeobuf driver. Read Write driver and FileTable. This driver does not support mixed geometry type. On write a spatial index is created by default. The spatial index on file table is not currently supported.
• Expose FlatGeobuf driver to the IOMethods
• FlatGeobuf must supports Unknown geometry type for SQL GEOMETRY
• FlatGeobuf improve data types
• FlatGeobuf enable select query on writer
• Fix geojson about issue #1374 geojson without coordinates give h2 problems with coordinate dimension incompatibilities
• Add ST_IsProjectedCRS and ST_IsGeographicCRS to check if the CRS is projected or geographic

v2.2.0

What's Changed

• Removed User_Spatial_Ref table to manage local srid when a prj is read by @ebocher in #1319
• Fix DBFReader to use VarChar instead of Char by @ebocher in #1320
• Some cleanup by @ebocher in #1323
• Update api osm url by @bbrangeo in #1326
• Overlay Next Generation by @ebocher in #1328
• Use OverlayNGRobust instead of OverlayNG by @ebocher in #1329
• Rebase ST_Union by @ebocher in #1330
• Add ESRI defs to spatial_ref_sys.sql by @ebocher in #1332
• Update CTS to 1.7.0-SNAPSHOT by @ebocher in #1333
• Update to CTS 1.7.0 by @ebocher in #1334

New Contributors

• @bbrangeo made their first contribution in #1326

Full Changelog: v2.1.0...v2.2.0

v2.1.0

This release introduces several major changes in H2GIS synchronized with the new H2 2.X series.

Changelog for v2.1.0

• Fix javadoc issues.
• Remove slf4j-simple dependency (#1261)
• Fix geometry_columns view function in order to escape table name with reserved database word (#1269)
• Add an option in ASC file reader in order to add the asc content into an existing table (#1270)
• Change batch size to use the optimal size (#1275)
• Add new constructors to TableLocation (#1264)
• Add ST_AsEWKB function(#1271)
• Add ST_Multi function (#1268)
• Fix GeoJSON driver on H2GIS does not use the good object type for geometry (#1277)
• Fix estimated extend on schema (#1286)
• TableLocation.parse now restore a TableLocation.toString() to the initial state
• Make test run again without PostGIS instance
• ST_DistanceSphere throws an exception when the two input srids are different (#1292)
• Remove OrbisParent dependency
• Update H2 to 2.1.212 and fix poly2tri dep
• Move all OSGI dependencies to h2gis-functions-osgi and to postgis-jts-osgi
• Move classes used for datasource creation (H2GISOsgiDBFactory and DataSourceFactoryImpl) to *-osgi package and keep test purpose class (HGISSimpleDBFactory) in h2gis-functions
• Fix ST_OrderingEquals and ST_AsBinary parameters to handle the case of a null geometry
• Fix ST_Accum and ST_Union to filter empty geometry
• Fix FindGeometryMetadata to handle the case of case-sensitive names
• Move header url into valid html <a> tags.
• Make the method PostGISDBFactory.createDataSource(Properties) static
• Fix ST_Union to return null if the entry geometry is null
• Improve st_node to remove duplicate lines
• Update H2 to 2.1.214
• Fix an issue on writing as geojson a table with a null value typed as TIME
• Add a mechanism to manage non-standardized prj file
• Upgrade to JTS 1.19.0

v2.0.0

This release introduces several major changes in H2GIS synchronized with the new H2 2.X series.
Besides many dozens of fixed bugs, performance improvements, more adherence to a standard SQL syntax and new data type (e.g JSON),
the H2GIS geometry encoding and syntax declaration is now aligned with the PostGIS one.

The geometry encoding to store the value in H2 is the EWKB (extended well-known binary) format. The EWKB format is not an OGC standard, but a PostGIS specific format that includes the spatial reference system (SRID) identifier. Its textual representation using the WKT (well-known text) uses the pattern :

'SRID=4326;POINT(0 0)'

H2 supports POINT, LINESTRING, POLYGON, MULTIPOINT, MULTILINESTRING, MULTIPOLYGON, and GEOMETRYCOLLECTION geometries with the following coordinate dimension 2D (XY), Z (XYZ), M (XYM), and ZM (XYZM).

H2 provides the same syntax as PostGIS to build a table with a geometry data type.

e.g
CREATE TABLE mygeometrytable (ID INTEGER, GEOM GEOMETRY);
CREATE TABLE mygeometrytable (ID INTEGER, GEOM GEOMETRY(POINT));
CREATE TABLE mygeometrytable (ID INTEGER, GEOM GEOMETRY(POINT, 4326));
CREATE TABLE mygeometrytable (ID INTEGER, GEOM GEOMETRY(POINTZ, 4326));
CREATE TABLE mygeometrytable (ID INTEGER, GEOM GEOMETRY(POINTZM, 4326));
CREATE TABLE mygeometrytable (ID INTEGER, GEOM GEOMETRY(POINTM, 4326));

Note that

• all databases created by H2 1.4.200 and older versions won't be compatible.
• H2GIS needs at least JAVA 11

Please check the H2 change log since 2.X series here https://github.com/h2database/h2database/releases

Changelog for v2.0.0

• Add changelog, contributing, header markdown files.
• Fix SHPRead function to support null value (#1132)
• Remove encoding argument on GeoJSONWrite / GeoJSONRead (#1130)
• Improve TSVRead function (#1129)
• AscRead and GeoJson read functions supports gz file (#1122 #1127)
• Improve FileDriver (Shp and Dbf) to limit the number of columns (#1008)
• Align create table geometry with PostGIS (#921)
• Add ST_SVF function (#885)
• Add ST_Point function (#848)
• Add support to create index on a linked file (shp or dbf file) (#720)
• Upgrade Java to 11
• Upgrade H2 to 2.0.202
• Upgrade to JTS 1.18.2
• Add new function ST_VariableBuffer
• Add new function ST_SubDivide (#1152)
• Update H2 from 2.0.202 to 2.0.204
• Added a workaround due to the new column type name returned for geometry data type
  eg GEOMETRY(POINT) instead of only GEOMETRY
• Update H2 from 2.0.204 to 2.0.206
• Add a new module to run sql script tests (disable by default)
• Update ST_Force3D, ST_Force4D and ST_Force3DM to be inline with PostGIS
• Update ST_UpdateZ to force the dimension when the z value is updated.
• Update H2 from 2.0.206 to 2.1.210 to fix a memory issue and improve Geometry dimension check
  (#1233 and #1243)
• Fix ST_MenSize to avoid expensive conversion (#1247)
• Add method to create Datasource object
• Update the dependencies Poly2Tri and java-network-analyzer
• Restore transaction with batch setAutoCommit to false

H2GIS Version 1.5.0

This release is aligned with CTS 1.5.2 (https://github.com/orbisgis/cts/releases)
It's based on H2 1.4.197 and uses JTS 1.15. It 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.

For a detailed list of issues go to : https://github.com/orbisgis/h2gis/milestone/6?closed=1