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

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

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

        
0.021 seconds ⌛

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