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

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

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

        
0.347 seconds ⌛

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