21 places near Heusenstamm, Offenbach, Hessen, Deutschland
  1. Frankfurt am Main
    Frankfurt am Main, Stadtkreis Frankfurt am Main, Hessen, Deutschland (Town)
  2. Heusenstamm
    Heusenstamm, Offenbach, Hessen, Deutschland (Town)
  3. Patershausen
    Patershausen, Offenbach, Hessen, Deutschland (Town)
  4. Rhein
    Rhein, Deutschland (Drainage)
  5. Main River
    Main River, Deutschland (Drainage)
  6. Gemeinde Offenbach am Main
    Gemeinde Offenbach am Main, Stadtkreis Offenbach am Main, Hessen, Deutschland (LocalAdmin)
  7. Gemeinde Heusenstamm
    Gemeinde Heusenstamm, Offenbach, Hessen, Deutschland (LocalAdmin)
  8. Main-Kinzig-Kreis
    Main-Kinzig-Kreis, Hessen, Deutschland (County)
  9. Offenbach
    Offenbach, Hessen, Deutschland (County)
  10. Stadtkreis Frankfurt am Main
    Stadtkreis Frankfurt am Main, Hessen, Deutschland (County)

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

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

        
0.01 seconds ⌛

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