23 places near Trosdorf, Landkreis Bamberg, Bayern, Deutschland
  1. Bischberg
    Bischberg, Landkreis Bamberg, Bayern, Deutschland (Town)
  2. Oberhaid
    Oberhaid, Landkreis Bamberg, Bayern, Deutschland (Town)
  3. Trosdorf
    Trosdorf, Landkreis Bamberg, Bayern, Deutschland (Town)
  4. Viereth
    Viereth, Landkreis Bamberg, Bayern, Deutschland (Town)
  5. Weipelsdorf
    Weipelsdorf, Landkreis Bamberg, Bayern, Deutschland (Town)
  6. Main River
    Main River, Deutschland (Drainage)
  7. Gemeinde Bischberg
    Gemeinde Bischberg, Landkreis Bamberg, Bayern, Deutschland (LocalAdmin)
  8. Gemeinde Oberhaid
    Gemeinde Oberhaid, Landkreis Bamberg, Bayern, Deutschland (LocalAdmin)
  9. Viereth-trunstadt
    Viereth-trunstadt, Landkreis Bamberg, Bayern, Deutschland (LocalAdmin)
  10. Bamberg gemeindefreies Gebiet
    Bamberg gemeindefreies Gebiet, Landkreis Bamberg, Bayern, Deutschland (LocalAdmin)

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

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

        
0.018 seconds ⌛

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