22 places near Staffelbach, Landkreis Bamberg, Bayern, Deutschland
  1. Roßstadt
    Roßstadt, Haßberge, Bayern, Deutschland (Town)
  2. Staffelbach
    Staffelbach, Landkreis Bamberg, Bayern, Deutschland (Town)
  3. Trunstadt
    Trunstadt, Landkreis Bamberg, Bayern, Deutschland (Town)
  4. Main River
    Main River, Deutschland (Drainage)
  5. Gemeinde Oberhaid
    Gemeinde Oberhaid, Landkreis Bamberg, Bayern, Deutschland (LocalAdmin)
  6. Viereth-trunstadt
    Viereth-trunstadt, Landkreis Bamberg, Bayern, Deutschland (LocalAdmin)
  7. Gemeinde Eltmann
    Gemeinde Eltmann, Haßberge, Bayern, Deutschland (LocalAdmin)
  8. Gemeinde Stettfeld
    Gemeinde Stettfeld, Haßberge, Bayern, Deutschland (LocalAdmin)
  9. Bamberg gemeindefreies Gebiet
    Bamberg gemeindefreies Gebiet, Landkreis Bamberg, Bayern, Deutschland (LocalAdmin)
  10. Oberfranken
    Oberfranken, Bayern, Deutschland (Colloquial)

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

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

        
0.016 seconds ⌛

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