This page last changed on May 12, 2007 by cholmes.

H2 Binding for Spatial DB in a Box

This page (hopefully will) describe the Spatial DB in a Box bindings for the H2 database. H2 is similar to hsql - an embedded java database but is a complete rewrite from scratch, which is much faster and has pluggable indexes and two phase commits.

Installing

Example queries:

sql> call totext(intersection(
         GeomFromWKT('LINESTRING(0.1 0.1, 1 1)'),
         GeomFromWKT('LINESTRING(0 0, 0.5 0.5)')));

LINESTRING (0.1 0.1, 0.5 0.5)

sql> call GeometryType(GeomFromWKT('POINT(0 0)'));

Point

sql> call relate(GeomFromWKT('POINT(0 0)'),GeomFromWKT('LINESTRING(0 0, 10 10)'));

F0FFFF102

Notes/To Do

Document generated by Confluence on May 14, 2014 23:00