21 places near Mandelbachtal, Saarpfalz-Kreis, Saarland, Deutschland
  1. Ommersheim
    Ommersheim, Saarpfalz-Kreis, Saarland, Deutschland (Town)
  2. Ormesheim
    Ormesheim, Saarpfalz-Kreis, Saarland, Deutschland (Town)
  3. Wittersheim
    Wittersheim, Saarpfalz-Kreis, Saarland, Deutschland (Town)
  4. Mandelbachtal
    Mandelbachtal, Saarpfalz-Kreis, Saarland, Deutschland (Town)
  5. Rhein
    Rhein, Deutschland (Drainage)
  6. Gemeinde Mandelbachtal
    Gemeinde Mandelbachtal, Saarpfalz-Kreis, Saarland, Deutschland (LocalAdmin)
  7. Stadtteil Ensheim
    Stadtteil Ensheim, Landkreis Saarbrücken, Saarland, Deutschland (LocalAdmin)
  8. Saarpfalz-Kreis
    Saarpfalz-Kreis, Saarland, Deutschland (County)
  9. Landkreis Saarbrücken
    Landkreis Saarbrücken, Saarland, Deutschland (County)
  10. Moselle
    Moselle, Lorraine, France (County)

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

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

        
0.027 seconds ⌛

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