5 places near Sandgruben, Landkreis Stade, Niedersachsen, Deutschland
filter by placetype:
  1. Kohlenhausen
    Kohlenhausen, Landkreis Stade, Niedersachsen, Deutschland (Town)
  2. Oersdorf
    Oersdorf, Landkreis Stade, Niedersachsen, Deutschland (Town)
  3. Ottendorf
    Ottendorf, Landkreis Stade, Niedersachsen, Deutschland (Town)
  4. Wohlerst
    Wohlerst, Landkreis Stade, Niedersachsen, Deutschland (Town)
  5. Sandgruben
    Sandgruben, Landkreis Stade, Niedersachsen, Deutschland (Town)

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

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

        
0.017 seconds ⌛

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