5 places near Mikitamäe, Põlvamaa, Eesti
filter by placetype:
  1. Pechorskiy Raion
    Pechorskiy Raion, Pskovskaya Oblast, Rossija (County)
  2. Pskovskiy Raion
    Pskovskiy Raion, Pskovskaya Oblast, Rossija (County)
  3. Räpina
    Räpina, Põlvamaa, Eesti (County)
  4. Mikitamäe
    Mikitamäe, Põlvamaa, Eesti (County)
  5. Värska
    Värska, Põlvamaa, Eesti (County)

Search again including deprecated places, unknown places, places that visit Null Island or everything?

This query took 0.024 seconds ⌛; show me the details?

        
0.024 seconds ⌛

{
  "query": {
    "bool": {
      "must": [
        {
          "geo_shape": {
            "geometry": {
              "shape": {
                "type": "circle",
                "radius": "1km",
                "coordinates": [
                  27.54093,
                  58.023201
                ]
              }
            }
          }
        },
        {
          "term": {
            "woe:placetype": 9
          }
        }
      ],
      "must_not": [
        {
          "terms": {
            "woe:placetype": [
              0,
              11,
              25
            ]
          }
        },
        {
          "term": {
            "geom:latitude": {
              "value": 0.0
            }
          }
        },
        {
          "term": {
            "geom:longitude": {
              "value": 0.0
            }
          }
        },
        {
          "exists": {
            "field": "woe:superseded_by"
          }
        }
      ]
    }
  },
  "aggs": {
    "placetypes": {
      "terms": {
        "field": "woe:placetype_name",
        "size": 10000
      }
    }
  },
  "sort": [
    {
      "woe:scale": {
        "order": "desc",
        "mode": "max"
      }
    },
    {
      "woe:id": {
        "order": "asc",
        "mode": "max"
      }
    }
  ]
}