25 places near Stadtteil Sandhofen, Stadtkreis Mannheim, Baden-Württemberg, Deutschland
  1. Stadtteil Sandhofen
    Stadtteil Sandhofen, Stadtkreis Mannheim, Baden-Württemberg, Deutschland (LocalAdmin)
  2. Rhein-Neckar-Kreis
    Rhein-Neckar-Kreis, Baden-Württemberg, Deutschland (County)
  3. Bergstraße
    Bergstraße, Hessen, Deutschland (County)
  4. Ludwigshafen
    Ludwigshafen, Rheinland-Pfalz, Deutschland (County)
  5. Stadtkreis Mannheim
    Stadtkreis Mannheim, Baden-Württemberg, Deutschland (County)
  6. Europe/Berlin
    Europe/Berlin (Timezone)
  7. Europe/Paris
    Europe/Paris (Timezone)
  8. Baden-Württemberg
    Baden-Württemberg, Baden-Württemberg, Deutschland (State)
  9. Deutschland
    Deutschland, Deutschland (Country)
  10. Atlantic Ocean
    Atlantic Ocean (Ocean)

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

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

        
0.029 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"
      }
    }
  ],
  "from": 10
}