7 places near Neu Sandhorst, Landkreis Aurich, Niedersachsen, Deutschland
filter by placetype:
  1. Aurich
    Aurich, Landkreis Aurich, Niedersachsen, Deutschland (Town)
  2. Egels
    Egels, Landkreis Aurich, Niedersachsen, Deutschland (Town)
  3. Koldehörn
    Koldehörn, Landkreis Aurich, Niedersachsen, Deutschland (Town)
  4. Neu Sandhorst
    Neu Sandhorst, Landkreis Aurich, Niedersachsen, Deutschland (Town)
  5. Plaggenburg
    Plaggenburg, Landkreis Aurich, Niedersachsen, Deutschland (Town)
  6. Sandhorst
    Sandhorst, Landkreis Aurich, Niedersachsen, Deutschland (Town)
  7. Wallinghausen
    Wallinghausen, Landkreis Aurich, Niedersachsen, Deutschland (Town)

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

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

        
0.028 seconds ⌛

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