22 places near Kesselstadt, Main-Kinzig-Kreis, Hessen, Deutschland
  1. Hanau
    Hanau, Main-Kinzig-Kreis, Hessen, Deutschland (Town)
  2. Kesselstadt
    Kesselstadt, Main-Kinzig-Kreis, Hessen, Deutschland (Town)
  3. Klein Steinheim
    Klein Steinheim, Main-Kinzig-Kreis, Hessen, Deutschland (Town)
  4. Steinheim am Main
    Steinheim am Main, Main-Kinzig-Kreis, Hessen, Deutschland (Town)
  5. Wilhelmsbad
    Wilhelmsbad, Main-Kinzig-Kreis, Hessen, Deutschland (Town)
  6. Rhein
    Rhein, Deutschland (Drainage)
  7. Main River
    Main River, Deutschland (Drainage)
  8. Gemeinde Hanau
    Gemeinde Hanau, Main-Kinzig-Kreis, Hessen, Deutschland (LocalAdmin)
  9. Gemeinde Maintal
    Gemeinde Maintal, Main-Kinzig-Kreis, Hessen, Deutschland (LocalAdmin)
  10. Gemeinde Mühlheim am Main
    Gemeinde Mühlheim am Main, Offenbach, Hessen, Deutschland (LocalAdmin)

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

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

        
0.015 seconds ⌛

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