# How to find polygons that contain a given point in Elasticsearch
**URL:** https://discuss.elastic.co/t/how-to-find-polygons-that-contain-a-given-point-in-elasticsearch/343769
**Category:** Elasticsearch
**Created:** [September 25, 2023, 1:29pm UTC](https://discuss.elastic.co/t/how-to-find-polygons-that-contain-a-given-point-in-elasticsearch/343769 "2023-09-25T13:29:43Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@Pranav\_Kapur](https://discuss.elastic.co/u/Pranav_Kapur)
#### Post date: [September 25, 2023, 1:29pm UTC](https://discuss.elastic.co/t/how-to-find-polygons-that-contain-a-given-point-in-elasticsearch/343769/1 "2023-09-25T13:29:43Z")
I need to build a query on a database with around 50k terrain polygons (stored as geo\_shape polygons on ES) where I give a point and it returns every polygon that contains this point.
I tried to create it, but getting incorrect result.
// Code
1. Create Index
```auto
{
"mappings": {
"TYPE_NAME": {
"properties": {
"location": {
"type": "geo_shape"
}
}
}
}
}
```
1. Insert document:
```auto
{
"location": {
"type": "polygon",
"coordinates": [
[
[
88.357934264,
22.55818208
],
[
88.365144042,
22.556745416
],
[
88.363384513,
22.551920096
],
[
88.360412625,
22.552474967
],
[
88.360788135,
22.553614427
],
[
88.35667899,
22.55359461
],
[
88.357934264,
22.55818208
]
]
]
}
}
```
1. Search for all polygons that contain the point:
```auto
{
"query": {
"geo_shape": {
"location": {
"shape": {
"type": "point",
"coordinates": [88.360, 22.555]
},
"relation": "within"
}
}
}
}
```
Result:
```auto
{
"took": 1,
"timed_out": false,
"_shards": {
"total": 5,
"successful": 5,
"skipped": 0,
"failed": 0
},
"hits": {
"total": 0,
"max_score": null,
"hits": []
}
}
```
Please let me know if I am missing out something as it is returning WRONG result.
---
### Author:  [@stephenb](https://discuss.elastic.co/u/stephenb)
#### Post date: [September 25, 2023, 2:38pm UTC](https://discuss.elastic.co/t/how-to-find-polygons-that-contain-a-given-point-in-elasticsearch/343769/2 "2023-09-25T14:38:19Z")
Hi @Pranav_Kapur
Try this
```auto
GET discuss-geo/_search
{
"query": {
"geo_shape": {
"location": {
"shape": {
"type": "point",
"coordinates": [
88.36,
22.555
]
},
"relation": "contains"
}
}
}
}
```
Read the [spatial relationship](https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-geo-shape-query.html#geo-shape-spatial-relations) a little closer
> - `WITHIN` - Return all documents whose `geo_shape` or `geo_point` field is within the query geometry. Line geometries are not supported.
When you said `within` I believe you were asking for your shape that was `within` the point 🙂 which is not correct for Point in Polygon
You want to use `contains`
> - `CONTAINS` - Return all documents whose `geo_shape` or `geo_point` field contains the query geometry.
And this is the result
```auto
{
"took": 2,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 1,
"relation": "eq"
},
"max_score": 0,
"hits": [
{
"_index": "discuss-geo",
"_id": "Zwy9zIoBC8AxxyqEFesV",
"_score": 0,
"_source": {
"location": {
"type": "polygon",
"coordinates": [
[
[
88.357934264,
22.55818208
],
[
88.365144042,
22.556745416
],
[
88.363384513,
22.551920096
],
[
88.360412625,
22.552474967
],
[
88.360788135,
22.553614427
],
[
88.35667899,
22.55359461
],
[
88.357934264,
22.55818208
]
]
]
}
}
}
]
}
}
```
---
### Author:  [@Pranav\_Kapur](https://discuss.elastic.co/u/Pranav_Kapur)
#### Post date: [September 25, 2023, 3:33pm UTC](https://discuss.elastic.co/t/how-to-find-polygons-that-contain-a-given-point-in-elasticsearch/343769/3 "2023-09-25T15:33:29Z")
Hi @stephenb
I tried using **relation: "contains"** ,
```auto
{
"query": {
"geo_shape": {
"location": {
"shape": {
"type": "point",
"coordinates": [
88.36,
22.555
]
},
"relation": "contains"
}
}
}
}
```
but I am getting the following error:
```auto
{
"error": {
"root_cause": [
{
"type": "query_shard_exception",
"reason": "CONTAINS query relation not supported for Field [location]",
"index_uuid": "a4PebYDsRHiXSJmIU6U5eA",
"index": "test"
}
],
"type": "search_phase_execution_exception",
"reason": "all shards failed",
"phase": "query",
"grouped": true,
"failed_shards": [
{
"shard": 0,
"index": "test",
"node": "vchTHFfmRVGTtVELK5UquQ",
"reason": {
"type": "query_shard_exception",
"reason": "CONTAINS query relation not supported for Field [location]",
"index_uuid": "a4PebYDsRHiXSJmIU6U5eA",
"index": "test"
}
}
]
},
"status": 400
}
```
---
### Author:  [@stephenb](https://discuss.elastic.co/u/stephenb)
#### Post date: [September 25, 2023, 3:43pm UTC](https://discuss.elastic.co/t/how-to-find-polygons-that-contain-a-given-point-in-elasticsearch/343769/4 "2023-09-25T15:43:00Z")
@Pranav_Kapur Forgot .. Welcome to the community
My entire code is below, try mine and see what you get.
What version are you on?
```auto
PUT discuss-geo
{
"mappings": {
"properties": {
"location": {
"type": "geo_shape"
}
}
}
}
POST discuss-geo/_doc
{
"location": {
"type": "polygon",
"coordinates": [
[
[
88.357934264,
22.55818208
],
[
88.365144042,
22.556745416
],
[
88.363384513,
22.551920096
],
[
88.360412625,
22.552474967
],
[
88.360788135,
22.553614427
],
[
88.35667899,
22.55359461
],
[
88.357934264,
22.55818208
]
]
]
}
}
GET discuss-geo/_search
{
"query": {
"geo_shape": {
"location": {
"shape": {
"type": "point",
"coordinates": [
88.36,
22.555
]
},
"relation": "contains"
}
}
}
}
# Result
{
"took": 2,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 1,
"relation": "eq"
},
"max_score": 0,
"hits": [
{
"_index": "discuss-geo",
"_id": "Zwy9zIoBC8AxxyqEFesV",
"_score": 0,
"_source": {
"location": {
"type": "polygon",
"coordinates": [
[
[
88.357934264,
22.55818208
],
[
88.365144042,
22.556745416
],
[
88.363384513,
22.551920096
],
[
88.360412625,
22.552474967
],
[
88.360788135,
22.553614427
],
[
88.35667899,
22.55359461
],
[
88.357934264,
22.55818208
]
]
]
}
}
}
]
}
}
```
You code here do not look correct
```auto
{
"mappings": {
"TYPE_NAME": {