3 places near Sankt-Peterburg Raion, Saint Petersburg Federal City, Rossija
filter by placetype:
  1. Lake Ladoga
    Lake Ladoga, Leningradskaya Oblast, Rossija (Drainage)
  2. Neva River
    Neva River, Leningradskaya Oblast, Rossija (Drainage)
  3. St. Petersburg River
    St. Petersburg River, Leningradskaya Oblast, Rossija (Drainage)

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

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

        
0.011 seconds ⌛

{
  "query": {
    "bool": {
      "must": [
        {
          "geo_shape": {
            "geometry": {
              "shape": {
                "type": "circle",
                "radius": "1km",
                "coordinates": [
                  30.35664,
                  59.940769
                ]
              }
            }
          }
        },
        {
          "term": {
            "woe:placetype": 15
          }
        }
      ],
      "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"
      }
    }
  ]
}