20 places near Kochkovskiy Raion, Novosibirskaya Oblast, Rossija
filter by placetype:
  1. Ob River
    Ob River, Novosibirskaya Oblast, Rossija (Drainage)
  2. Irtysh River
    Irtysh River, Omskaya Oblast, Rossija (Drainage)
  3. Siberia
    Siberia, Rossija (Colloquial)
  4. Kochkovskiy Raion
    Kochkovskiy Raion, Novosibirskaya Oblast, Rossija (County)
  5. Asia/Krasnoyarsk
    Asia/Krasnoyarsk, Rossija (Timezone)
  6. Asia/Yekaterinburg
    Asia/Yekaterinburg, Rossija (Timezone)
  7. Asia/Almaty
    Asia/Almaty, Kazakhstan (Timezone)
  8. Asia/Novosibirsk
    Asia/Novosibirsk, Rossija (Timezone)
  9. Novosibirskaya Oblast
    Novosibirskaya Oblast, Novosibirskaya Oblast, Rossija (State)
  10. Krasnoyarsk Krai
    Krasnoyarsk Krai, Rossija (State)

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

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

        
0.027 seconds ⌛

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