20 places near Andreyevo-Ivanovka, Odes´ka Oblast´, Ukrayina
filter by placetype:
  1. Andreyevo-Ivanovka
    Andreyevo-Ivanovka, Odes´ka Oblast´, Ukrayina (Town)
  2. Pivdenny Buh River
    Pivdenny Buh River, Ukrayina (Drainage)
  3. Dnieper River
    Dnieper River, Ukrayina (Drainage)
  4. Moldavia
    Moldavia (Colloquial)
  5. Europe/Moscow
    Europe/Moscow, Rossija (Timezone)
  6. Europe/Kiev
    Europe/Kiev, Ukrayina (Timezone)
  7. Mykolayivs´ka Oblast´
    Mykolayivs´ka Oblast´, Mykolayivs´ka Oblast´, Ukrayina (State)
  8. Odes´ka Oblast´
    Odes´ka Oblast´, Odes´ka Oblast´, Ukrayina (State)
  9. Ukrayina
    Ukrayina, Ukrayina (Country)
  10. Pacific Ocean
    Pacific Ocean (Ocean)

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

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

        
0.031 seconds ⌛

{
  "query": {
    "bool": {
      "must": [
        {
          "geo_shape": {
            "geometry": {
              "shape": {
                "type": "circle",
                "radius": "1km",
                "coordinates": [
                  30.464239,
                  47.509628
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}