Find all the geoshapes that insersects with a given latitude/longitude

Vidal_Chriqui · June 8, 2014, 7:42pm

Hi

My goal is to find for a given latitude/longitude all the indexed documents
(circular geoshapes with specific radius for each) that contains this
lat/lon.
If necessary i'm ok to transform the circular zones with envelope, but this
does not seem to be the issue.

I need help to find the way to write the search query.
In this gist, you can find the document mappings, 3 sample docs et 2
attempts to write the query, but, those queries do not return anything
whereas it should (obviously the query is not the correct one).

gist.github.com

https://gist.github.com/anonymous/3e6aa70bf8b31e8eb345

gistfile1.txt


//clear previous data
curl -XDELETE 'http://localhost:9200/campaigns'

//mappings
curl -XPUT 'http://localhost:9200/campaigns?pretty=1' -d '
{
   "mappings" : {
      "campaign" : {
         "properties" : {

This file has been truncated. show original

Thanks for your help to write the correct query.

Best regards
Vidal

--
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/2ba3bd12-8f75-4584-9d89-a90fc8af0f53%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

spinscale · June 16, 2014, 1:37pm

Hey,

this looks like a problem, because you are using an _id object, I filed an
issue here: Indexing: Using _id as object doesnt work for future queries · Issue #6514 · elastic/elasticsearch · GitHub
You can just specify ids manually or make sure, that you _id field is empty
for now.

--Alex

On Sun, Jun 8, 2014 at 9:42 PM, Vidal Chriqui vidal.chriqui@gmail.com
wrote:

Hi

My goal is to find for a given latitude/longitude all the indexed
documents (circular geoshapes with specific radius for each) that contains
this lat/lon.
If necessary i'm ok to transform the circular zones with envelope, but
this does not seem to be the issue.

I need help to find the way to write the search query.
In this gist, you can find the document mappings, 3 sample docs et 2
attempts to write the query, but, those queries do not return anything
whereas it should (obviously the query is not the correct one).

gist:3e6aa70bf8b31e8eb345 · GitHub

Thanks for your help to write the correct query.

Best regards
Vidal

--
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/2ba3bd12-8f75-4584-9d89-a90fc8af0f53%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/2ba3bd12-8f75-4584-9d89-a90fc8af0f53%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

--
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/CAGCwEM9niKkctJhwi%3D8aYrEYfBya%3D-e%3D4_ShMvfpzSPJwnzL%2Bg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.