23 places near Malaya Sofiyevka, Odes´ka Oblast´, Ukrayina
filter by placetype:
  1. Bol'shaya Sofiyevka
    Bol'shaya Sofiyevka, Odes´ka Oblast´, Ukrayina (Suburb)
  2. Malaya Sofiyevka
    Malaya Sofiyevka, Odes´ka Oblast´, Ukrayina (Suburb)
  3. Llubashivka
    Llubashivka, Odes´ka Oblast´, Ukrayina (Town)
  4. Nistru River
    Nistru River, Stinga Nistrul, Moldova (Drainage)
  5. Pivdenny Buh River
    Pivdenny Buh River, Ukrayina (Drainage)
  6. Dnieper River
    Dnieper River, Ukrayina (Drainage)
  7. Moldavia
    Moldavia (Colloquial)
  8. Europe/Moscow
    Europe/Moscow, Rossija (Timezone)
  9. Europe/Kiev
    Europe/Kiev, Ukrayina (Timezone)
  10. Kirovohrads´ka Oblast´
    Kirovohrads´ka Oblast´, Kirovohrads´ka Oblast´, Ukrayina (State)

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

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

        
0.019 seconds ⌛

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