18 places near Landkreis Roth, Bayern, Deutschland
  1. Höfstetten
    Höfstetten, Landkreis Roth, Bayern, Deutschland (Town)
  2. Höfstetten
    Höfstetten, Landkreis Roth, Bayern, Deutschland (Town)
  3. Wallersbach
    Wallersbach, Landkreis Roth, Bayern, Deutschland (Town)
  4. Wallesau
    Wallesau, Landkreis Roth, Bayern, Deutschland (Town)
  5. Gemeinde Hilpoltstein
    Gemeinde Hilpoltstein, Landkreis Roth, Bayern, Deutschland (LocalAdmin)
  6. Gemeinde Roth
    Gemeinde Roth, Landkreis Roth, Bayern, Deutschland (LocalAdmin)
  7. Mittelfranken
    Mittelfranken, Bayern, Deutschland (Colloquial)
  8. Landkreis Roth
    Landkreis Roth, Bayern, Deutschland (County)
  9. Weißenburg-Gunzenhausen
    Weißenburg-Gunzenhausen, Bayern, Deutschland (County)
  10. Europe/Berlin
    Europe/Berlin (Timezone)

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

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

        
0.023 seconds ⌛

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