18 places near Berezovka, Vinnyts´ka Oblast´, Ukrayina
filter by placetype:
  1. Berezovka
    Berezovka, Vinnyts´ka Oblast´, Ukrayina (Town)
  2. Donau
    Donau, Magyarország (Drainage)
  3. Prut River
    Prut River, Moldova (Drainage)
  4. Pivdenny Buh River
    Pivdenny Buh River, Ukrayina (Drainage)
  5. Moldavia
    Moldavia (Colloquial)
  6. Europe/Moscow
    Europe/Moscow, Rossija (Timezone)
  7. Europe/Kiev
    Europe/Kiev, Ukrayina (Timezone)
  8. Vinnyts´ka Oblast´
    Vinnyts´ka Oblast´, Vinnyts´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.014 seconds ⌛; show me the details?

        
0.014 seconds ⌛

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