Hello,
In my Index i have several locations with some information and geo data. In
the detail view of an location i try to query for locations which are near
by the current one.
I am confused, cause my query does not return the correct order of
locations. If you check the geo locations you will see, that the order is
wrong.
The bool query is there for preventing getting the current location in the
result ( identified by the locations slug ).
In the following example, please notice that the query is run with the geo
point of "adlon hotel", so the first returned location should be "Hotel
Prens Berlin Kreuzberg".
Here is the query:
curl -XGET 'http://localhost:9200/search/location/_search' -d
'{"sort":[{"_geo_distance":{"pin":[52.51515,13.38019],"order":"asc","unit":"km","distance_type":"arc"}}],"query":{"bool":{"must_not":[{"match":{"slug":"adlon-hotel"}}]}},"size":3}'
Here is my mapping:
{
"search" : {
"mappings" : {
"location" : {
"_meta" : {
"model" :
"AnchorVentures\Bundle\LocationBundle\Entity\Location"
},
"_all" : {
"auto_boost" : true
},
"properties" : {
"address" : {
"properties" : {
"pin" : {
"type" : "geo_point",
"store" : true,
"lat_lon" : true
},
"zipcode" : {
"type" : "string",
"store" : true
}
}
},
"city" : {
"type" : "nested",
"properties" : {
"name" : {
"type" : "string",
"boost" : 10.0,
"store" : true
}
}
},
"countedRatings" : {
"type" : "string",
"store" : true
},
"createdAt" : {
"type" : "string",
"store" : true
},
"details" : {
"type" : "nested",
"properties" : {
"guestsQuantity" : {
"type" : "string",
"store" : true
},
"isCatering" : {
"type" : "string",
"store" : true
},
"isIndoor" : {
"type" : "string",
"store" : true
},
"isOutdoor" : {
"type" : "string",
"store" : true
},
"isOvernightAccommodation" : {
"type" : "string",
"store" : true
},
"price" : {
"type" : "string",
"store" : true
},
"roomQuantity" : {
"type" : "string",
"store" : true
}
}
},
"name" : {
"type" : "string",
"store" : true
},
"slug" : {
"type" : "string",
"store" : true
},
"updatedAt" : {
"type" : "string",
"store" : true
}
}
}
}
}
}
And finally some documents
{
"took" : 2,
"timed_out" : false,
"_shards" : {
"total" : 5,
"successful" : 5,
"failed" : 0
},
"hits" : {
"total" : 10,
"max_score" : 1.0,
"hits" : [ {
"_index" : "search",
"_type" : "location",
"_id" : "207",
"_score" : 1.0,
"_source":{"name":"Badeschiff","slug":"badeschiff","countedRatings":0,
"createdAt":"2014-10-13T10:40:58+02:00","updatedAt":
"2014-10-13T10:40:58+02:00","details":{"price":1,"isIndoor":true,"isOutdoor"
:true,"isCatering":true,"isOvernightAccommodation":false,"roomQuantity":1,
"guestsQuantity":50},"city":{"name":"Berlin"},"address":{"zipcode":"12435",
"pin":"52.4970479,13.4525442"}}
}, {
"_index" : "search",
"_type" : "location",
"_id" : "214",
"_score" : 1.0,
"_source":{"name":"Le Plat du Jour","slug":"le-plat-du-jour",
"countedRatings":0,"createdAt":"2014-10-13T10:40:58+02:00","updatedAt":
"2014-10-13T10:40:58+02:00","details":{"price":5,"isIndoor":true,"isOutdoor"
:true,"isCatering":true,"isOvernightAccommodation":false,"roomQuantity":4,
"guestsQuantity":50},"city":{"name":"Hamburg"},"address":{"zipcode":"20095",
"pin":"53.54911,9.99439"}}
}, {
"_index" : "search",
"_type" : "location",
"_id" : "206",
"_score" : 1.0,
"_source":{"name":"Spreequartier","slug":"spreequartier",
"countedRatings":0,"createdAt":"2014-10-13T10:40:58+02:00","updatedAt":
"2014-10-13T10:40:58+02:00","details":{"price":5,"isIndoor":true,"isOutdoor"
:true,"isCatering":true,"isOvernightAccommodation":false,"roomQuantity":3,
"guestsQuantity":80},"city":{"name":"Berlin"},"address":{"zipcode":"10245",
"pin":"52.5018737,13.4484104"}}
}, {
"_index" : "search",
"_type" : "location",
"_id" : "213",
"_score" : 1.0,
"_source":{"name":"Club Heim im Schanzenpark","slug":
"club-heim-im-schanzenpark","countedRatings":1,"createdAt":
"2014-10-13T10:40:58+02:00","updatedAt":"2014-10-13T10:40:58+02:00",
"details":{"price":5,"isIndoor":true,"isOutdoor":true,"isCatering":true,
"isOvernightAccommodation":false,"roomQuantity":4,"guestsQuantity":150},
"city":{"name":"Hamburg"},"address":{"zipcode":"20357","pin":
"53.56473,9.97387"}}
}, {
"_index" : "search",
"_type" : "location",
"_id" : "209",
"_score" : 1.0,
"_source":{"name":"Hotel Prens Berlin Kreuzberg","slug":
"hotel-prens-berlin-kreuzberg","countedRatings":0,"createdAt":
"2014-10-13T10:40:58+02:00","updatedAt":"2014-10-13T10:40:58+02:00",
"details":{"price":4,"isIndoor":true,"isOutdoor":true,"isCatering":true,
"isOvernightAccommodation":false,"roomQuantity":50,"guestsQuantity":500},
"city":{"name":"Berlin"},"address":{"zipcode":"10967","pin":
"52.49517,13.42109"}}
}, {
"_index" : "search",
"_type" : "location",
"_id" : "211",
"_score" : 1.0,
"_source":{"name":"Bahrenfelder Trabrennbahn","slug":
"bahrenfelder-trabrennbahn","countedRatings":1,"createdAt":
"2014-10-13T10:40:58+02:00","updatedAt":"2014-10-13T10:40:58+02:00",
"details":{"price":2,"isIndoor":true,"isOutdoor":false,"isCatering":true,
"isOvernightAccommodation":false,"roomQuantity":1,"guestsQuantity":300},
"city":{"name":"Hamburg"},"address":{"zipcode":"22761","pin":
"53.57829,9.89291"}}
}, {
"_index" : "search",
"_type" : "location",
"_id" : "208",
"_score" : 1.0,
"_source":{"name":"Die Fabrik","slug":"die-fabrik","countedRatings":0,
"createdAt":"2014-10-13T10:40:58+02:00","updatedAt":
"2014-10-13T10:40:58+02:00","details":{"price":4,"isIndoor":true,"isOutdoor"
:true,"isCatering":true,"isOvernightAccommodation":false,"roomQuantity":20,
"guestsQuantity":250},"city":{"name":"Berlin"},"address":{"zipcode":"10997",
"pin":"52.49875,13.44583"}}
}, {
"_index" : "search",
"_type" : "location",
"_id" : "210",
"_score" : 1.0,
"_source":{"name":"Ivbergs Hotel Charlottenburg","slug":
"ivbergs-hotel-charlottenburg","countedRatings":0,"createdAt":
"2014-10-13T10:40:58+02:00","updatedAt":"2014-10-13T10:40:58+02:00",
"details":{"price":3,"isIndoor":true,"isOutdoor":true,"isCatering":true,
"isOvernightAccommodation":false,"roomQuantity":35,"guestsQuantity":150},
"city":{"name":"Berlin"},"address":{"zipcode":"14057","pin":
"52.507,13.29408"}}
}, {
"_index" : "search",
"_type" : "location",
"_id" : "205",
"_score" : 1.0,
"_source":{"name":"Adlon Hotel","slug":"adlon-hotel","countedRatings":
4,"createdAt":"2014-10-13T10:40:58+02:00","updatedAt":
"2014-10-13T10:40:58+02:00","details":{"price":2,"isIndoor":true,"isOutdoor"
:false,"isCatering":true,"isOvernightAccommodation":true,"roomQuantity":4,
"guestsQuantity":150},"city":{"name":"Berlin"},"address":{"zipcode":"10117",
"pin":"52.51515,13.38019"}}
}, {
"_index" : "search",
"_type" : "location",
"_id" : "212",
"_score" : 1.0,
"_source":{"name":"Astrabar","slug":"astrabar","countedRatings":0,
"createdAt":"2014-10-13T10:40:58+02:00","updatedAt":
"2014-10-13T10:40:58+02:00","details":{"price":1,"isIndoor":true,"isOutdoor"
:false,"isCatering":true,"isOvernightAccommodation":false,"roomQuantity":1,
"guestsQuantity":50},"city":{"name":"Hamburg"},"address":{"zipcode":"20359",
"pin":"53.5488403,9.9607657"}}
} ]
}
}
--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/a20a6cbc-5b1b-4696-aa0b-17adca4c36ba%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.