20 places near Schlappenreuth, Landkreis Bamberg, Bayern, Deutschland
  1. Burgellern
    Burgellern, Landkreis Bamberg, Bayern, Deutschland (Town)
  2. Burglesau
    Burglesau, Landkreis Bamberg, Bayern, Deutschland (Town)
  3. Demmelsdorf
    Demmelsdorf, Landkreis Bamberg, Bayern, Deutschland (Town)
  4. Ehrl
    Ehrl, Landkreis Bamberg, Bayern, Deutschland (Town)
  5. Schlappenreuth
    Schlappenreuth, Landkreis Bamberg, Bayern, Deutschland (Town)
  6. Main River
    Main River, Deutschland (Drainage)
  7. Gemeinde Scheßlitz
    Gemeinde Scheßlitz, Landkreis Bamberg, Bayern, Deutschland (LocalAdmin)
  8. Bamberg gemeindefreies Gebiet
    Bamberg gemeindefreies Gebiet, Landkreis Bamberg, Bayern, Deutschland (LocalAdmin)
  9. Oberfranken
    Oberfranken, Bayern, Deutschland (Colloquial)
  10. Landkreis Bamberg
    Landkreis Bamberg, Bayern, Deutschland (County)

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

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

        
0.026 seconds ⌛

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