spring Java中MongoDB集合中的2dsphere索引未获取

Question

我的问题与[这里][1]相同。我已经创建了一个索引“2dsphere”，但从spring Java获取数据时，它告诉我在该特定列上创建一个索引，以触发对该列的地理空间查询。您能告诉我如何从spring Java获取地理空间索引吗？

这是我在mongoDB中的收藏结构：

{
"_id" : ObjectId("5729f6f0daf5583ade68b277"),
"type" : "Feature",
"geometry" : {
    "type" : "Polygon",
    "coordinates" : [ 
        [ 
            [ 
                -61.392147064209, 
                12.5836229324341
            ], 
            [ 
                -61.3972930908203, 
                12.5838899612427
            ], 
            [ 
                -61.401252746582, 
                12.5869073867798
            ], 
            [ 
                -61.3977165222168, 
                12.5903301239014
            ], 
            [ 
                -61.3904685974121, 
                12.5893573760986
            ], 
            [ 
                -61.388843536377, 
                12.587965965271
            ], 
            [ 
                -61.3890991210938, 
                12.5845184326172
            ], 
            [ 
                -61.392147064209, 
                12.5836229324341
            ]
        ]
    ]
},
"properties" : {
    "TZID" : "America/St_Vincent"
}
}

以及要创建索引查询的查询：

db.timezone.createIndex({"geometry":"2dsphere"})

@Repository
public class MongoDaoImpl extends BaseMongoDaoImpl implements MongoDao{

public static final Logger logger=LoggerFactory.getLogger(MongoDaoImpl.class);

@Autowired
MongoTemplate mongoTemplate;

@Override
public String getTimezoneIdFromLatLong(Double lat, Double longi){
    String TZId=null;
    try{
        Query query = new Query(new Criteria()
                        .and("geometry")
                        .near(new Point(lat, longi)).maxDistance(0)).limit(1);
        query.fields().include("properties.TZID").exclude("_id");   
        logger.info("Mongo query : " + query.toString());
        TZId =  mongoTemplate.find(query, String.class,"timezone").get(0);

        logger.info("Getting the TimezoneId of Lat and long : "+ TZId);
    }catch(Exception e){
        logger.error("Exception occured while getting TimezoneId from lat & long", e);
    }
    return TZId;

}
}

所以，我试图运行上面的代码，然后它在控制台给我下面的错误。

2016-06-03 12:15:52185[http-nio-8321-exec-3:a7827b0e-eb2e-4485-a385-e6a8a1dd765d]信息：：，-Mongo查询：查询：{“geometry”：{“$near”：{$java:Point[x=-61.338249，y=12.691054]}，“$maxDistance”：0.0}，字段：{“properties.TZID”：1，“\u id”：0}，排序：null

524e89638c4d]错误：：，-从lat获取TimezoneId时发生异常




Answer 1

经过这么多挣扎，我找到了不使用标准的答案。下面这个是使用不使用Spring...也就是说只有java这绝对会帮助你

MongoClient mongoClient = new MongoClient("localhost" , 27017 );
DB db = mongoClient.getDB("services");
DBCollection collection=  db.getCollection("timezone");
BasicDBObject point = new BasicDBObject("type", "Point");
double[] ptCordinate={lat,longi};
point.put("coordinates", ptCordinate);

BasicDBObject query = new BasicDBObject(
    "geometry", new BasicDBObject(
        "$near", new BasicDBObject(
            "$geometry", point
        )
    )
);
collection.findOne(query);