Bocher Erwan

H2GIS 1.5 driver

3

**Describe the solution you'd like** It would be great if CloudBeaver could offer an H2GIS base in demonstration. You will have an easy way to init a temporary spatial database....

Add function to export and import geometry in TWKB encoding

5

Check the Tiny Well-known Binary specification https://github.com/TWKB/Specification/blob/master/twkb.md

Replace the_geom by geom

6

It'd be nice to replace the_geom column name by geom to be aligned with PostGIS.

Same as https://postgis.net/docs/ST_AsEWKB.html

ST_DUMP

4

Add ST_DUMP function as https://postgis.net/docs/ST_Dump.html Not sure if H2 is today able to support a set-returning function @katzyn

ST_MemSize

5

Implement ST_MemSize as PostGIS does to help people to know the memory size of the Geometry https://postgis.net/docs/ST_MemSize.html

Update ST_Force2D, ST_Force3D, ST_Force3DM, ST_Force4D functions

1

We must update these functions to be inline with PostGIS. Consequently the function ST_UpdateZ will be adpated.

The following script fails in H2. ``` DROP TABLE IF EXISTS PARCELS,TRIANGLES,slope_by_parcels; CREATE TABLE PARCELS ( THE_GEOM GEOMETRY(MULTIPOLYGON) ); INSERT INTO PARCELS VALUES('MULTIPOLYGON (((184661.64063 2431733.5, 184652.21875 2431759.5, 184646.03125 2431775, 184641.5...

ST_Subdivide function

1

Implements a function to split a geometry as POSTGIS does : https://postgis.net/docs/ST_Subdivide.html It would be useful to perform overlay op on large geometry.

Study the interest of https://github.com/flatgeobuf/flatgeobuf to export large collection of geometries.