22 places near Appendorf, Landkreis Bamberg, Bayern, Deutschland
  1. Appendorf
    Appendorf, Landkreis Bamberg, Bayern, Deutschland (Town)
  2. Lauter
    Lauter, Landkreis Bamberg, Bayern, Deutschland (Town)
  3. Sandhof
    Sandhof, Landkreis Bamberg, Bayern, Deutschland (Town)
  4. Sandhof
    Sandhof, Landkreis Bamberg, Bayern, Deutschland (Town)
  5. Main River
    Main River, Deutschland (Drainage)
  6. Gemeinde Baunach
    Gemeinde Baunach, Landkreis Bamberg, Bayern, Deutschland (LocalAdmin)
  7. Gemeinde Lauter
    Gemeinde Lauter, Landkreis Bamberg, Bayern, Deutschland (LocalAdmin)
  8. Gemeinde Oberhaid
    Gemeinde Oberhaid, Landkreis 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.016 seconds ⌛; show me the details?

        
0.016 seconds ⌛

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