23 places near Rothof, Landkreis Bamberg, Bayern, Deutschland
  1. Mühlendorf
    Mühlendorf, Landkreis Bamberg, Bayern, Deutschland (Town)
  2. Seehöflein
    Seehöflein, Landkreis Bamberg, Bayern, Deutschland (Town)
  3. Weipelsdorf
    Weipelsdorf, Landkreis Bamberg, Bayern, Deutschland (Town)
  4. Rothof
    Rothof, Landkreis Bamberg, Bayern, Deutschland (Town)
  5. Main River
    Main River, Deutschland (Drainage)
  6. Gemeinde Bischberg
    Gemeinde Bischberg, Landkreis Bamberg, Bayern, Deutschland (LocalAdmin)
  7. Gemeinde Stegaurach
    Gemeinde Stegaurach, Landkreis Bamberg, Bayern, Deutschland (LocalAdmin)
  8. Gemeinde Bamberg
    Gemeinde Bamberg, Stadtkreis Bamberg, 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.02 seconds ⌛; show me the details?

        
0.02 seconds ⌛

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