19 places near Dereyevka, Kirovohrads´ka Oblast´, Ukrayina
filter by placetype:
  1. Dereyevka
    Dereyevka, Kirovohrads´ka Oblast´, Ukrayina (Town)
  2. Deriyevka
    Deriyevka, Kirovohrads´ka Oblast´, Ukrayina (Town)
  3. Dnieper River
    Dnieper River, Ukrayina (Drainage)
  4. Europe/Moscow
    Europe/Moscow, Rossija (Timezone)
  5. Europe/Kiev
    Europe/Kiev, Ukrayina (Timezone)
  6. Dnipropetrovs´ka Oblast´
    Dnipropetrovs´ka Oblast´, Dnipropetrovs´ka Oblast´, Ukrayina (State)
  7. Kirovohrads´ka Oblast´
    Kirovohrads´ka Oblast´, Kirovohrads´ka Oblast´, Ukrayina (State)
  8. Poltavs´ka Oblast´
    Poltavs´ka Oblast´, Poltavs´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.021 seconds ⌛; show me the details?

        
0.021 seconds ⌛

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