Integrating Hibernate Spatial with Spring Boot and PostGIS

00:00 Workshop Introduction

A special workshop covers the integration of Hibernate Spatial with Spring Boot, PostGIS, and GeoJSON. The tutorial outlines the creation of a base application, saving JTS geometry objects, converting them to and from GeoJSON, and performing spatial queries.

01:10 Base Application Setup

The presenter generates a Spring Boot application using Spring Initializr, selecting Maven, Java 11, and necessary dependencies. Configuration of the data source for the PostgreSQL database and Hibernate Spatial setup is discussed.

02:30 Defining Sample Entity

A sample entity named "SpatialLab" is defined along with its JTS geometry fields. The importance of importing the correct JTS classes is emphasized, and the application is run to create the necessary database tables.

04:00 Saving JTS Geometries

An initialization service is created to save JTS geometry objects into the database upon application startup. The presenter demonstrates how to create geometry instances using JTS's GeometryFactory.

06:50 Converting to GeoJSON

The tutorial shows how to convert JTS geometries to GeoJSON using the Ultimate GeoJSON library, including creating integration tests to validate the conversion process.

09:30 Custom JSON Serializer

A custom JSON serializer is implemented to enable proper serialization of JTS geometries to GeoJSON format for API responses. The necessity of a configuration for the object mapper is highlighted.

12:00 Custom Deserializer

A custom deserializer is defined to convert GeoJSON back to JTS geometries. This step includes handling various geometry types and the potential errors that may arise.

14:00 Performing Spatial Queries

The tutorial concludes with examples of executing spatial queries using Hibernate Spatial, such as intersection queries and distance-based searches, showcasing the capability of handling geospatial data effectively.