Grails + Spatial Data using PostgreSQL, PostGIS
PostgreSQL
http://www.postgresql.org/
Downloads for Windows, Linux, Mac, ...
http://www.postgresql.org/download/
PostGIS
PostGIS adds support for geographic objects to the PostgreSQL object-relational database. In effect, PostGIS "spatially enables" the PostgreSQL server, allowing it to be used as a backend spatial database for geographic information systems (GIS), much like ESRI's SDE or Oracle's Spatial extension. PostGIS follows the OpenGIS "Simple Features Specification for SQL" and has been certified as compliant with the "Types and Functions" profile.
http://postgis.refractions.net/
Cheatsheet
http://www.bostongis.com/postgis_quickguide.bqg?outputformat=PDF
Hibernate Spatial
Hibernate Spatial is a generic extension to Hibernate for handling geographic data. Hibernate Spatial is open source and licensed, like Hibernate, under the LGPL license.
Hibernate Spatial allows you to deal with geographic data in a standardized way. It abstracts away from the specific way your database supports geographic data, and provides a standardized, cross-database interface to geographic data storage and query functions.
Hibernate Spatial supports most of the functions of the OGC Simple Feature Specification. Supported databases are: Oracle 10g/11g, Postgresql/Postgis, and MySQL.
http://www.hibernatespatial.org/
Hibernate Spatial for PostGIS
http://www.hibernatespatial.org/hibernate-spatial-postgis/source-repository.htm
Grails and PostGIS
http://blog.mollusca.ch/2008/10/4/grails-spatial-data-postgis
http://blog.mollusca.ch/2009/5/11/grails-spatial-data-2-0
http://blog.mollusca.ch/2008/10/16/calling-stored-procedures-from-grails
http://www.nabble.com/grails-and-postgis-td19666057.html
JTS Topology Suite
The JTS Topology Suite is an API of 2D spatial predicates and functions. It has the following design goals:
* JTS conforms to the Simple Features Specification for SQL published by the Open GIS Consortium
* JTS provides a complete, consistent, robust implementation of fundamental 2D spatial algorithms
* JTS is fast enough for production use
* JTS is written in 100% pure JavaTM
* JTS is open source (under the LGPL license)
http://www.vividsolutions.com/jts/jtshome.htm
