25 places near Stadtteil Sandhofen, Stadtkreis Mannheim, Baden-Württemberg, Deutschland
  1. Coleman Army Air Field
    Coleman Army Air Field, Bergstraße, Hessen, Deutschland (Airport)
  2. Scharhof
    Scharhof, Stadtkreis Mannheim, Baden-Württemberg, Deutschland (Suburb)
  3. Kirschgartshausen
    Kirschgartshausen, Stadtkreis Mannheim, Baden-Württemberg, Deutschland (Suburb)
  4. Blumenau
    Blumenau, Stadtkreis Mannheim, Baden-Württemberg, Deutschland (Suburb)
  5. Sandtorf
    Sandtorf, Stadtkreis Mannheim, Baden-Württemberg, Deutschland (Suburb)
  6. Lampertheim
    Lampertheim, Bergstraße, Hessen, Deutschland (Town)
  7. Mannheim
    Mannheim, Stadtkreis Mannheim, Baden-Württemberg, Deutschland (Town)
  8. Rhein
    Rhein, Deutschland (Drainage)
  9. Main River
    Main River, Deutschland (Drainage)
  10. Gemeinde Lampertheim
    Gemeinde Lampertheim, Bergstraße, Hessen, Deutschland (LocalAdmin)

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": [
                  8.4648,
                  49.570179
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}