20 places near Gemeinde Oberhaid, Landkreis Bamberg, Bayern, Deutschland
  1. Oberhaid
    Oberhaid, Landkreis Bamberg, Bayern, Deutschland (Town)
  2. Unterhaid
    Unterhaid, Landkreis Bamberg, Bayern, Deutschland (Town)
  3. Sandhof
    Sandhof, 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. Bamberg gemeindefreies Gebiet
    Bamberg gemeindefreies Gebiet, Landkreis Bamberg, Bayern, Deutschland (LocalAdmin)
  8. Oberfranken
    Oberfranken, Bayern, Deutschland (Colloquial)
  9. Unterfranken
    Unterfranken, 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.024 seconds ⌛; show me the details?

        
0.024 seconds ⌛

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