23 places near 63071, Stadtkreis Offenbach am Main, Hessen, Deutschland
filter by placetype:
  1. Bieber
    Bieber, Stadtkreis Offenbach am Main, Hessen, Deutschland (Town)
  2. Frankfurt am Main
    Frankfurt am Main, Stadtkreis Frankfurt am Main, Hessen, Deutschland (Town)
  3. Heusenstamm
    Heusenstamm, Offenbach, Hessen, Deutschland (Town)
  4. Offenbach
    Offenbach, Stadtkreis Offenbach am Main, Hessen, Deutschland (Town)
  5. Rosenhöhe
    Rosenhöhe, Stadtkreis Offenbach am Main, Hessen, Deutschland (Town)
  6. Lauterborn
    Lauterborn, Stadtkreis Offenbach am Main, Hessen, Deutschland (Town)
  7. Rhein
    Rhein, Deutschland (Drainage)
  8. Main River
    Main River, Deutschland (Drainage)
  9. Gemeinde Offenbach am Main
    Gemeinde Offenbach am Main, Stadtkreis Offenbach am Main, Hessen, Deutschland (LocalAdmin)
  10. Main-Kinzig-Kreis
    Main-Kinzig-Kreis, Hessen, Deutschland (County)

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

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

        
0.022 seconds ⌛

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