24 places near Gerach, Landkreis Bamberg, Bayern, Deutschland
  1. Gerach
    Gerach, Landkreis Bamberg, Bayern, Deutschland (Town)
  2. Gräfenholz
    Gräfenholz, Haßberge, Bayern, Deutschland (Town)
  3. Laimbach
    Laimbach, Landkreis Bamberg, Bayern, Deutschland (Town)
  4. Mauschendorf
    Mauschendorf, Landkreis Bamberg, Bayern, Deutschland (Town)
  5. Reckendorf
    Reckendorf, Landkreis Bamberg, Bayern, Deutschland (Town)
  6. Sendelbach
    Sendelbach, Haßberge, Bayern, Deutschland (Town)
  7. Main River
    Main River, Deutschland (Drainage)
  8. Gemeinde Gerach
    Gemeinde Gerach, Landkreis Bamberg, Bayern, Deutschland (LocalAdmin)
  9. Gemeinde Reckendorf
    Gemeinde Reckendorf, Landkreis Bamberg, Bayern, Deutschland (LocalAdmin)
  10. Gemeinde Rentweinsdorf
    Gemeinde Rentweinsdorf, Haßberge, Bayern, Deutschland (LocalAdmin)

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

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

        
0.022 seconds ⌛

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