18 places near Lake Ladoga, Leningradskaya Oblast, Rossija
filter by placetype:
  1. Lake Ladoga
    Lake Ladoga, Leningradskaya Oblast, Rossija (Drainage)
  2. St. Petersburg River
    St. Petersburg River, Leningradskaya Oblast, Rossija (Drainage)
  3. Barents Region
    Barents Region (Colloquial)
  4. Fennoscandia
    Fennoscandia (Colloquial)
  5. Europe/Helsinki
    Europe/Helsinki (Timezone)
  6. Europe/Oslo
    Europe/Oslo (Timezone)
  7. Europe/Moscow
    Europe/Moscow, Rossija (Timezone)
  8. Kareliya
    Kareliya, Kareliya, Rossija (State)
  9. Leningradskaya Oblast
    Leningradskaya Oblast, Leningradskaya Oblast, Rossija (State)
  10. Rossija
    Rossija, Rossija (Country)

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

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

        
0.046 seconds ⌛

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