24 places near Stadtteil Käfertal, Stadtkreis Mannheim, Baden-Württemberg, Deutschland
  1. Gartenstadt
    Gartenstadt, Stadtkreis Mannheim, Baden-Württemberg, Deutschland (Suburb)
  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. Mannheim
    Mannheim, Stadtkreis Mannheim, Baden-Württemberg, Deutschland (Town)
  7. Viernheim
    Viernheim, Bergstraße, Hessen, Deutschland (Town)
  8. Rhein
    Rhein, Deutschland (Drainage)
  9. Gemeinde Viernheim
    Gemeinde Viernheim, Bergstraße, Hessen, Deutschland (LocalAdmin)
  10. Stadtteil Waldhof
    Stadtteil Waldhof, Stadtkreis Mannheim, Baden-Württemberg, Deutschland (LocalAdmin)

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

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

        
0.038 seconds ⌛

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