mongo的geo查詢

maven

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-mongodb</artifactId>
        </dependency>

domain

@Document(collection="coffeeShop")
public class CoffeeShop {

    @Id
    private String id;

    private String name;

    @GeoSpatialIndexed
    private double[] location;
    
    //....
    
}    

near查詢

spherical為true則距離單位為空間弧度,false則距離單位為水平單位度

度查詢

spherical為false,參數(shù)為公里數(shù)除以111

public GeoResults<CoffeeShop> near2(double[] poi){
        NearQuery near = NearQuery
                .near(new Point(poi[0],poi[1]))
                .spherical(false)
                .num(1);
        GeoResults<CoffeeShop> results = mongoTemplate.geoNear(near, CoffeeShop.class);
        return results;
    }

輸出

GeoResults: [averageDistance: 0.08294719588991498, results: GeoResult [content: com.codecraft.domain.CoffeeShop@747f6c5a, distance: 0.08294719588991498, ]]

不指定spherical,默認(rèn)為false,結(jié)果中的dis需要乘以111換算為km

public GeoResults<CoffeeShop> near2(double[] poi){
        NearQuery near = NearQuery
                .near(new Point(poi[0],poi[1]))
                .spherical(false)
                .distanceMultiplier(111)
                .num(1);
        GeoResults<CoffeeShop> results = mongoTemplate.geoNear(near, CoffeeShop.class);
        return results;
    }

輸出

GeoResults: [averageDistance: 9.207138743780563 org.springframework.data.geo.CustomMetric@28768e25, results: GeoResult [content: com.codecraft.domain.CoffeeShop@310d57b1, distance: 9.207138743780563 org.springframework.data.geo.CustomMetric@28768e25, ]]

即北京阿里綠地中心距離三里屯星巴克距離9km

若要設(shè)置最大距離,則

public GeoResults<CoffeeShop> near2(double[] poi){
        NearQuery near = NearQuery
                .near(new Point(poi[0],poi[1]))
                .spherical(false)
                .maxDistance(5/111.0d)
                .distanceMultiplier(111)
                .num(1);
        GeoResults<CoffeeShop> results = mongoTemplate.geoNear(near, CoffeeShop.class);
        return results;
    }

結(jié)果為空

弧度查詢

需要數(shù)據(jù)存儲為(經(jīng)度,緯度),不然報(bào)錯(cuò)

org.springframework.dao.DataIntegrityViolationException: Write failed with error code 16755 and error message 'Can't extract geo keys: { _id: ObjectId('58df9c50b45cbc069f6ff548'), _class: "com.codecraft.domain.CoffeeShop", name: "深圳市南山區(qū)星巴克(海岸城店)", location: [ 22.52395, 113.943442 ] }  can't project geometry into spherical CRS: [ 22.52395, 113.943442 ]'; nested exception is com.mongodb.WriteConcernException: Write failed with error code 16755 and error message 'Can't extract geo keys: { _id: ObjectId('58df9c50b45cbc069f6ff548'), _class: "com.codecraft.domain.CoffeeShop", name: "深圳市南山區(qū)星巴克(海岸城店)", location: [ 22.52395, 113.943442 ] }  can't project geometry into spherical CRS: [ 22.52395, 113.943442 ]'
    at org.springframework.data.mongodb.core.MongoExceptionTranslator.translateExceptionIfPossible(MongoExceptionTranslator.java:85)

使用

public GeoResults<CoffeeShop> nearRadian(double[] poi){
        NearQuery near = NearQuery
                .near(new Point(poi[0],poi[1]))
                .spherical(true)
                .maxDistance(10,Metrics.KILOMETERS) //MILES以及KILOMETERS自動設(shè)置spherical(true)
                .distanceMultiplier(6371)
                .num(1);
        GeoResults<CoffeeShop> results = mongoTemplate.geoNear(near, CoffeeShop.class);
        return results;
    }

test

@Test
    public void testInitGeo() {
        //http://map.yanue.net/toLatLng/
        CoffeeShop shop1 = new CoffeeShop("深圳市南山區(qū)星巴克(海岸城店)",new double[]{113.943442,22.52395});
        CoffeeShop shop2 = new CoffeeShop("廣州市白云區(qū)星巴克(萬達(dá)廣場店)",new double[]{113.274643,23.180251});
        CoffeeShop shop3 = new CoffeeShop("北京市朝陽區(qū)星巴克(三里屯店)",new double[]{116.484385,39.923778});
        CoffeeShop shop4 = new CoffeeShop("上海市浦東新區(qū)星巴克(濱江店)",new double[]{121.638481,31.230895});
        CoffeeShop shop5 = new CoffeeShop("南京市鼓樓區(qū)星巴克(山西路店)",new double[]{118.788924,32.075343});
        CoffeeShop shop6 = new CoffeeShop("廈門市思明區(qū)星巴克(中華城店)",new double[]{118.089813,24.458157});
        CoffeeShop shop7 = new CoffeeShop("杭州市西湖區(qū)星巴克(杭州石函店)",new double[]{120.143005,30.280273});

        coffeeShopDao.save(Lists.newArrayList(shop1,shop2,shop3,shop4,shop5,shop6,shop7));

    }

    @Test
    public void testNear(){
        //經(jīng)度\緯度
        double[] bjAli = new double[]{116.492644,40.006313};
        double[] szAli = new double[]{113.950723,22.558888};
        double[] shAli = new double[]{121.387616,31.213301};
        double[] hzAli = new double[]{120.033345,30.286398};
        Arrays.asList(bjAli,szAli,shAli,hzAli).stream().forEach(d -> {
            GeoResults<CoffeeShop> results = locationService.nearRadian(d);
            System.out.println(results);
        });
    }

小結(jié)

  • 經(jīng)度、緯度的坐標(biāo)順序很容易搞錯(cuò),x軸是緯度,軸是經(jīng)度,這也是Point定義的順序。不過這樣的順序?qū)τ谑褂没《萻pherical查詢,很容易出錯(cuò),即spherical查詢要求順序是(經(jīng)度,緯度),即數(shù)據(jù)和參數(shù)都是這樣的順序。
  • 對于只需要取最近N個(gè)的場景,使用num即可;
  • 要使用結(jié)果中的距離時(shí),需要注意單位換算。
  • 對于要指定maxDistance之類的入?yún)r(shí),使用非spherical要注意單位換算;對于使用spherical查詢的時(shí)候,MILES以及KILOMETERS自動設(shè)置spherical(true),無需關(guān)心入?yún)挝晦D(zhuǎn)換。

另外,對于spherical與非spherical查詢,貌似沒啥區(qū)別,就是spherical在使用時(shí)入?yún)o需關(guān)心單位換算,稍微方便點(diǎn)。

doc

最后編輯于
?著作權(quán)歸作者所有,轉(zhuǎn)載或內(nèi)容合作請聯(lián)系作者
【社區(qū)內(nèi)容提示】社區(qū)部分內(nèi)容疑似由AI輔助生成,瀏覽時(shí)請結(jié)合常識與多方信息審慎甄別。
平臺聲明:文章內(nèi)容(如有圖片或視頻亦包括在內(nèi))由作者上傳并發(fā)布,文章內(nèi)容僅代表作者本人觀點(diǎn),簡書系信息發(fā)布平臺,僅提供信息存儲服務(wù)。

相關(guān)閱讀更多精彩內(nèi)容

友情鏈接更多精彩內(nèi)容