25 places near Höfen, Landkreis Bamberg, Bayern, Deutschland
  1. Gemeinde Bamberg
    Gemeinde Bamberg, Stadtkreis Bamberg, Bayern, Deutschland (LocalAdmin)
  2. Bamberg gemeindefreies Gebiet
    Bamberg gemeindefreies Gebiet, Landkreis Bamberg, Bayern, Deutschland (LocalAdmin)
  3. Oberfranken
    Oberfranken, Bayern, Deutschland (Colloquial)
  4. Unterfranken
    Unterfranken, Bayern, Deutschland (Colloquial)
  5. Landkreis Bamberg
    Landkreis Bamberg, Bayern, Deutschland (County)
  6. Stadtkreis Bamberg
    Stadtkreis Bamberg, Bayern, Deutschland (County)
  7. Europe/Berlin
    Europe/Berlin (Timezone)
  8. Bayern
    Bayern, Bayern, 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.017 seconds ⌛; show me the details?

        
0.017 seconds ⌛

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