# How to filter based on a pair of matching geopoints within a radius?

**URL:** <https://discuss.elastic.co/t/how-to-filter-based-on-a-pair-of-matching-geopoints-within-a-radius/350265>\
**Category:** Elasticsearch\
**Created:** [January 2, 2024, 9:18pm UTC](https://discuss.elastic.co/t/how-to-filter-based-on-a-pair-of-matching-geopoints-within-a-radius/350265 "2024-01-02T21:18:41Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![mike\_mivance](https://avatars.discourse-cdn.com/v4/letter/m/7c8e57/32.png) [@mike\_mivance](https://discuss.elastic.co/u/mike_mivance)\
**Post date:** [January 2, 2024, 9:18pm UTC](https://discuss.elastic.co/t/how-to-filter-based-on-a-pair-of-matching-geopoints-within-a-radius/350265/1 "2024-01-02T21:18:41Z")

</div>

Hi All, I am trying to match based on two geopoints (origin and destination) within a radius so that if both the query geopoints are within their respective radiuses, they will be included in the results. For instance, if the range is 100 miles from the center of New York for the origin and the range is 100 miles from the center of Miami for the destination then if my query/filter values are both in those respective ranges then they are in the result set. Make sense? Is this possible? Do you have any sample queries?

---

<div class="post-metadata">

**Author:** ![stephenb](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stephenb/32/40856_2.png) [@stephenb](https://discuss.elastic.co/u/stephenb)\
**Post date:** [January 3, 2024, 6:39pm UTC](https://discuss.elastic.co/t/how-to-filter-based-on-a-pair-of-matching-geopoints-within-a-radius/350265/2 "2024-01-03T18:39:17Z")

</div>

Hi @mike_mivance, Welcome to the community.

It would be helpful if you could provide some sample documents with locations and the values to filter on and the desired result. I think I understand from your description but concrete examples always help more.

Then we can see if we can build a query...

---

<div class="post-metadata">

**Author:** ![mike\_mivance](https://avatars.discourse-cdn.com/v4/letter/m/7c8e57/32.png) [@mike\_mivance](https://discuss.elastic.co/u/mike_mivance)\
**Post date:** [January 3, 2024, 7:56pm UTC](https://discuss.elastic.co/t/how-to-filter-based-on-a-pair-of-matching-geopoints-within-a-radius/350265/3 "2024-01-03T19:56:41Z")

</div>

Hi @stephenb , Thank you for the welcome. We are super excited to be here. We are in the process of creating a document for this scenario and we will share it with you shortly. We appreciate any help you can provide at that point. I'm glad my description was somewhat intelligible! 🙂

---

<div class="post-metadata">

**Author:** ![stephenb](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stephenb/32/40856_2.png) [@stephenb](https://discuss.elastic.co/u/stephenb)\
**Post date:** [January 4, 2024, 4:14am UTC](https://discuss.elastic.co/t/how-to-filter-based-on-a-pair-of-matching-geopoints-within-a-radius/350265/4 "2024-01-04T04:14:00Z")

</div>

@mike_mivance

So here is my sample ....

It is a collection of `geo_point` with two `keyword` fields...  
Notice I create the mapping first...  
Then I post the documents  
Then I do a search I also put these on a map...

```auto
DELETE /city

PUT /city
{
  "mappings": {
    "properties": {
      "name" : {"type" : "keyword"},
      "type" : {"type" : "keyword"},
      "location": {
        "type": "geo_point"
      }
    }
  }
}

POST /city/_doc/
{
  "name": "stamford",
  "type": "city",
  "location": [-73.554212, 41.053923]
}

POST /city/_doc
{
  "name": "greenwich",
  "type": "city",
  "location": [-74.624998,42.047451]
}

POST /city/_doc
{
  "name": "armonk",
  "type": "city",
  "location": [-75.708180,43.126757]
}

POST /city/_doc
{
  "name": "stamford",
  "type": "town",
  "location": [-75.718180,43.136757]
}

POST /city/_doc
{
  "name": "north stamford",
  "type": "city",
  "location": [-76.572866,44.142307]
}

POST /city/_doc
{
  "name": "greenwich2",
  "type": "city",
  "location": [-73.681591,41.098201]
}

POST /city/_doc
{
  "name": "rye brook",
  "type": "town",
  "location": [-73.683025,41.017221]
}

```

Then perform bool search with a [geo\_distance search](https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-geo-distance-query.html) with a filter for `"type": "town"` in 1 radius

```auto
GET /city/_search
{
  "query": {
    "bool": {
      "filter": [
        {
          "exists": {
            "field": "location"
          }
        },
        {
          "term": {
            "type": "town"
          }
        },
        {
          "geo_distance": {
            "distance": "7.71km",
            "location": [
              -75.73,
              43.0983
            ]
          }
        }
      ]
    }
  }
}

# Result

{
  "took": 1,
  "timed_out": false,
  "_shards": {
    "total": 1,
    "successful": 1,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": {
      "value": 1,
      "relation": "eq"
    },
    "max_score": 0,
    "hits": [
      {
        "_index": "city",
        "_id": "Ru-N0owBsqdyNt92KLqz",
        "_score": 0,
        "_source": {
          "name": "stamford",
          "type": "town",
          "location": [
            -75.71818,
            43.136757
          ]
        }
      }
    ]
  }
}

```

Then, a search in another radius

```auto
GET /city/_search
{
  "query": {
    "bool": {
      "filter": [
        {
          "exists": {
            "field": "location"
          }
        },
        {
          "term": {
            "type": "town"
          }
        },
        {
          "geo_distance": {
            "distance": "7.71km",
            "location": [
              -75.73,
              43.0983
            ]
          }
        }
      ]
    }
  }
}

# Result

{
  "took": 1,
  "timed_out": false,
  "_shards": {
    "total": 1,
    "successful": 1,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": {
      "value": 1,
      "relation": "eq"
    },
    "max_score": 0,
    "hits": [
      {
        "_index": "city",
        "_id": "Ru-N0owBsqdyNt92KLqz",
        "_score": 0,
        "_source": {
          "name": "stamford",
          "type": "town",
          "location": [
            -75.71818,
            43.136757
          ]
        }
      }
    ]
  }
}

```

Now the tricky part, and I am not sure this is exactly what you want  
This filters on `"type": "town"`  
and then the [bool query](https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-bool-query.html) `should` is like anOR... you have to use the `should` because if you do a `must` (AND) a point would never exist at the same time in the 2 disjoint radii.

```auto
GET /city/_search
{
  "query": {
    "bool": {
      "filter": [
        {
          "exists": {
            "field": "location"
          }
        },
        {
          "term": {
            "type": "town"
          }
        }
      ],
      "should": [
        {
          "geo_distance": {
            "distance": "13km",
            "location": [
              -73.625,
              41.049
            ]
          }
        },
        {
          "geo_distance": {
            "distance": "7.71km",
            "location": [
              -75.73,
              43.0983
            ]
          }
        }
      ]
    }
  }
}
# Result 

{
  "took": 3,
  "timed_out": false,
  "_shards": {
    "total": 1,
    "successful": 1,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": {
      "value": 2,
      "relation": "eq"
    },
    "max_score": 1,
    "hits": [
      {
        "_index": "city",
        "_id": "Ru-N0owBsqdyNt92KLqz",
        "_score": 1,
        "_source": {
          "name": "stamford",
          "type": "town",
          "location": [
            -75.71818,
            43.136757
          ]
        }
      },
      {
        "_index": "city",
        "_id": "Se-N0owBsqdyNt92KLrd",
        "_score": 1,
        "_source": {
          "name": "rye brook",
          "type": "town",
          "location": [
            -73.683025,
            41.017221
          ]
        }
      }
    ]
  }
}

```

This is how it looks on a map BUT you can not do the should (OR) on the map...  
It only supports must / AND  
This picture has the radii drawn but the actual filters turned off, I did this for Visualization purposes

If you want to put the geo data on a map You need to create a data view to put the data on a map. And then use layer documents.

 ![Screenshot 2024-01-03 at 8.13.37 PM](https://us1.discourse-cdn.com/elastic/original/3X/b/9/b91aeb8a96fe11e33c49aa60517c0e756e6fc71e.jpeg)

---

<div class="post-metadata">

**Author:** ![mike\_mivance](https://avatars.discourse-cdn.com/v4/letter/m/7c8e57/32.png) [@mike\_mivance](https://discuss.elastic.co/u/mike_mivance)\
**Post date:** [January 5, 2024, 8:26pm UTC](https://discuss.elastic.co/t/how-to-filter-based-on-a-pair-of-matching-geopoints-within-a-radius/350265/5 "2024-01-05T20:26:25Z")

</div>

Thanks for this. We are working to create an example and then we can have a back and forth where you understand where we are coming from. Really appreciate the help thus far!

---

<div class="post-metadata">

**Author:** ![mike\_mivance](https://avatars.discourse-cdn.com/v4/letter/m/7c8e57/32.png) [@mike\_mivance](https://discuss.elastic.co/u/mike_mivance)\
**Post date:** [January 18, 2024, 8:31pm UTC](https://discuss.elastic.co/t/how-to-filter-based-on-a-pair-of-matching-geopoints-within-a-radius/350265/6 "2024-01-18T20:31:34Z")

</div>

Hi there, sorry for the delay. This is what we were thinking:

```auto
"mappings": {
            "properties": {
                "destination": {
                    "type": "geo_point"
                },
                "name": {
                    "type": "text"
                },
                "source": {
                    "type": "geo_point"
                }
            }
        },

```

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [February 15, 2024, 8:32pm UTC](https://discuss.elastic.co/t/how-to-filter-based-on-a-pair-of-matching-geopoints-within-a-radius/350265/7 "2024-02-15T20:32:08Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.