25 places near Hochstätt, Stadtkreis Mannheim, Baden-Württemberg, Deutschland
  1. Stadtteil Seckenheim
    Stadtteil Seckenheim, Stadtkreis Mannheim, Baden-Württemberg, Deutschland (LocalAdmin)
  2. Stadtteil Friedrichsfeld
    Stadtteil Friedrichsfeld, Stadtkreis Mannheim, Baden-Württemberg, Deutschland (LocalAdmin)
  3. Rhein-Neckar-Kreis
    Rhein-Neckar-Kreis, Baden-Württemberg, Deutschland (County)
  4. Bergstraße
    Bergstraße, Hessen, 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.015 seconds ⌛; show me the details?

        
0.015 seconds ⌛

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