Part 5 - Geospatial queries

To demonstrate Geospatial queries we create a new entity class Location with a field location of type org.springframework.data.geo.Point. We also have to create a geo index on this field. We can do so by annotating the field with @GeoIndexed(geoJson = true). As you probably remember we have already used an index in our Character class but we annotated the type and not the affected fields. Spring Data ArangoDB offers two ways of defining an index. With @<IndexType>Indexed annotations indexes for single fields can be defined. If the index should include multiple fields the @<IndexType>Index annotations can be used on the type instead. Take a look here for more information.

Create a new class Location:

package com.arangodb.spring.demo.entity;
 
import com.arangodb.springframework.annotation.Document;
import com.arangodb.springframework.annotation.GeoIndexed;
import org.springframework.data.annotation.Id;
import org.springframework.data.geo.Point;
 
import java.util.Arrays;
 
@Document("locations")
public class Location {
 
    @Id
    private String id;
    private final String name;
    @GeoIndexed(geoJson = true)
    private final Point location;
 
    public Location(final String name, final Point location) {
        super();
        this.name = name;
        this.location = location;
    }
 
    // getter & setter
 
}

and the corresponding repository LocationRepository:

package com.arangodb.spring.demo.repository;
 
import com.arangodb.spring.demo.entity.Location;
import com.arangodb.springframework.repository.ArangoRepository;
 
public interface LocationRepository extends ArangoRepository<Location, String> {
 
}

After that we create a new CommandLineRunner, add it to our DemoApplication and perform some insert operations with some popular locations from Game of Thrones with the coordinates of their real counterparts.

package com.arangodb.spring.demo.runner;
 
import com.arangodb.spring.demo.entity.Location;
import com.arangodb.spring.demo.repository.LocationRepository;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.CommandLineRunner;
 
import java.util.Arrays;
 
public class GeospatialRunner implements CommandLineRunner {
 
    @Autowired
    private LocationRepository repository;
 
    @Override
    public void run(final String... args) throws Exception {
        System.out.println("# Geospatial");
 
        repository.saveAll(Arrays.asList(
                new Location("Dragonstone",     new Point(-6.815096, 55.167801)),
                new Location("King's Landing",  new Point(18.110189, 42.639752)),
                new Location("The Red Keep",    new Point(14.446442, 35.896447)),
                new Location("Yunkai",          new Point(-7.129532, 31.046642)),
                new Location("Astapor",         new Point(-9.774249, 31.50974)),
                new Location("Winterfell",      new Point(-5.581312, 54.368321)),
                new Location("Vaes Dothrak",    new Point(-6.096125, 54.16776)),
                new Location("Beyond the wall", new Point(-21.094093, 64.265473))));
    }
}

DemoApplication:

Class<?>[]runner=new Class<?>[]{
        CrudRunner.class,
        ByExampleRunner.class,
        DerivedQueryRunner.class,
        RelationsRunner.class,
        AQLRunner.class,
        GeospatialRunner.class
};