25 places near Debring, Landkreis Bamberg, Bayern, Deutschland
  1. Bamberg gemeindefreies Gebiet
    Bamberg gemeindefreies Gebiet, Landkreis Bamberg, Bayern, Deutschland (LocalAdmin)
  2. Oberfranken
    Oberfranken, Bayern, Deutschland (Colloquial)
  3. Unterfranken
    Unterfranken, Bayern, Deutschland (Colloquial)
  4. Landkreis Bamberg
    Landkreis Bamberg, Bayern, Deutschland (County)
  5. Haßberge
    Haßberge, 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.038 seconds ⌛; show me the details?

        
0.038 seconds ⌛

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