26 places near Kelsterbach, Landkreis Groß-Gerau, Hessen, Deutschland
  1. Kelsterbach Bahnhof
    Kelsterbach Bahnhof, Landkreis Groß-Gerau, Hessen, Deutschland (POI)
  2. Goldstein
    Goldstein, Stadtkreis Frankfurt am Main, Hessen, Deutschland (Suburb)
  3. Frankfurt Main
    Frankfurt Main, Stadtkreis Frankfurt am Main, Hessen, Deutschland (Suburb)
  4. Frankfurt am Main
    Frankfurt am Main, Stadtkreis Frankfurt am Main, Hessen, Deutschland (Town)
  5. Kelsterbach
    Kelsterbach, Landkreis Groß-Gerau, Hessen, Deutschland (Town)
  6. Okriftel
    Okriftel, Main-Taunus-Kreis, Hessen, Deutschland (Town)
  7. Rhein
    Rhein, Deutschland (Drainage)
  8. Main River
    Main River, Deutschland (Drainage)
  9. Gemeinde Kelsterbach
    Gemeinde Kelsterbach, Landkreis Groß-Gerau, Hessen, Deutschland (LocalAdmin)
  10. Gemeinde Hattersheim am Main
    Gemeinde Hattersheim am Main, Main-Taunus-Kreis, Hessen, Deutschland (LocalAdmin)

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

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

        
0.032 seconds ⌛

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