如何处理地理位置数据

    //与hibernate-core版本一致的spatial版本
    implementation "org.hibernate:hibernate-spatial:5.6.14.Final"
    //配置json输出
    implementation 'com.graphhopper.external:jackson-datatype-jts:2.14'
    //runtimeOnly("com.h2database:h2)
    //增加H2GIS的类库支持
    implementation('org.orbisgis:h2gis:2.2.0')

hibernate:
  hbm2ddl:
    auto: update  # one of create, create-drop, update, validate
  dialect: org.hibernate.spatial.dialect.h2geodb.GeoDBDialect #org.hibernate.dialect.H2Dialect

@Configuration
class Config {
    @Autowired ObjectMapper objectMapper;
    @Bean
    public JtsModule jtsModule(){
        JtsModule jtsModule=new JtsModule();
        objectMapper.registerModule(jtsModule);
        return jtsModule;
    }
}

@Configuration
class Config {
    @Autowired ObjectMapper objectMapper;
    @Autowired DataSource dataSource;
    @Bean
    public JtsModule jtsModule(){
        JtsModule jtsModule=new JtsModule();
        objectMapper.registerModule(jtsModule);
        return jtsModule;
    }
    @Bean
    public Connection dataSourceConnection(){
        Connection connection=dataSource.getConnection()
        H2GISFunctions.load(connection);
        return connection;
    }
}

import grails.gorm.annotation.Entity
import org.locationtech.jts.geom.Point
@Entity
class NewsEvent {
    String name
    Point location
}

//
        Point  point=wktToGeometry("POINT (20 15)")
        new NewsEvent(name:'地点2',location: point).save(flush: true);
        private Geometry wktToGeometry(String wellKnownText) throws ParseException {
            GeometryFactory geometryFactory=new GeometryFactory(new PrecisionModel(),4326)
            return new WKTReader(geometryFactory).read(wellKnownText);
        }

//
        GeometryFactory geometryFactory=new GeometryFactory(new PrecisionModel(),4326)
        Point point1 =geometryFactory.createPoint(new Coordinate( 10, 5 ))
        println point1.toString()
        println point1.SRID
        new NewsEvent(name:'地点3',location: point1).save(flush: true);

        println NewsEvent.findByName('地点3').location.x
        println NewsEvent.findByName('地点3').location.y

        // 查询距离
        println NewsEvent.executeQuery("select n,distance(n.location, :center) as jl from NewsEvent n where distance(n.location, :center) < :radius order by jl ", [center:one,radius:300d])
        //查询圆形内的点
        println NewsEvent.executeQuery("from NewsEvent n where within(n.location, :circle) =true", [circle:createCircle(0.0, 0.0, 105)])
    private Geometry createCircle(double x, double y, double radius) {
        GeometryFactory geometryFactory=new GeometryFactory(new PrecisionModel(),4326)
        GeometricShapeFactory shapeFactory = new GeometricShapeFactory(geometryFactory);
        //设置图形内总点数
        shapeFactory.setNumPoints(32);
        shapeFactory.setCentre(new Coordinate(x, y));
        shapeFactory.setSize(radius * 2);
        return shapeFactory.createCircle();
    }