See the Dialect specific pages for usage notes.

Not all databases support all the functions defined by Hibernate Spatial. The table below provides an overview of the functions provided by each database

Function | Description | Postgresql | Oracle 10g/11g | MySQL | SQLServer | GeoDB (H2) |
---|---|---|---|---|---|---|

Basic functions on Geometry | ||||||

int dimension(Geometry) | SFS §2.1.1.1 | |||||

String geometrytype(Geometry) | SFS §2.1.1.1 | |||||

int srid(Geometry) | SFS §2.1.1.1 | |||||

Geometry envelope(Geometry) | SFS §2.1.1.1 | |||||

String astext(Geometry) | SFS §2.1.1.1 | |||||

byte[] asbinary(Geometry) | SFS §2.1.1.1 | |||||

boolean isempty(Geometry) | SFS §2.1.1.1 | |||||

boolean issimple(Geometry) | SFS §2.1.1.1 | |||||

Geometry boundary(Geometry) | SFS §2.1.1.1 | |||||

Functions for testing Spatial Relations between geometric objects | ||||||

boolean equals(Geometry, Geometry) | SFS §2.1.1.2 | |||||

boolean disjoint(Geometry, Geometry) | SFS §2.1.1.2 | |||||

boolean intersects(Geometry, Geometry) | SFS §2.1.1.2 | |||||

boolean touches(Geometry, Geometry) | SFS §2.1.1.2 | |||||

boolean crosses(Geometry, Geometry) | SFS §2.1.1.2 | |||||

boolean within(Geometry, Geometry) | SFS §2.1.1.2 | |||||

boolean contains(Geometry, Geometry) | SFS §2.1.1.2 | |||||

boolean overlaps(Geometry, Geometry) | SFS §2.1.1.2 | |||||

boolean relate(Geometry, Geometry, String) | SFS §2.1.1.2 | |||||

Functions that support Spatial Analysis | ||||||

double distance(Geometry, Geometry) | SFS §2.1.1.3 | |||||

Geometry buffer(Geometry, double) | SFS §2.1.1.3 | |||||

Geometry convexhull(Geometry) | SFS §2.1.1.3 | |||||

Geometry intersection(Geometry, Geometry) | SFS §2.1.1.3 | |||||

Geometry geomunion(Geometry, Geometry) | SFS §2.1.1.3 (renamed from union) | |||||

Geometry difference(Geometry, Geometry) | SFS §2.1.1.3 | |||||

Geometry symdifference(Geometry, Geometry) | SFS §2.1.1.3 | |||||

Common non-SFS functions | ||||||

boolean dwithin(Geometry, Geometry, double) | Returns true if the geometries are within the specified distance of one another | |||||

Geometry transform(Geometry, int) | Returns a new geometry with its coordinates transformed to the SRID referenced by the integer parameter | |||||

Spatial aggregate Functions | ||||||

Geometry extent(Geometry) | Returns a bounding box that bounds the set of returned geometries |