23 places near Mikhaylovka, Vinnyts´ka Oblast´, Ukrayina
filter by placetype:
  1. Cremenciug
    Cremenciug, Soroca, Moldova (Town)
  2. Mikhaylovka
    Mikhaylovka, Vinnyts´ka Oblast´, Ukrayina (Town)
  3. Donau
    Donau, Magyarország (Drainage)
  4. Prut River
    Prut River, Moldova (Drainage)
  5. Nistru River
    Nistru River, Stinga Nistrul, Moldova (Drainage)
  6. Pivdenny Buh River
    Pivdenny Buh River, Ukrayina (Drainage)
  7. Moldavia
    Moldavia (Colloquial)
  8. Europe/Chisinau
    Europe/Chisinau (Timezone)
  9. Europe/Moscow
    Europe/Moscow, Rossija (Timezone)
  10. Europe/Kiev
    Europe/Kiev, Ukrayina (Timezone)

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

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

        
0.017 seconds ⌛

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