27 places near 63075, Stadtkreis Offenbach am Main, Hessen, Deutschland
  1. Bürgel
    Bürgel, Stadtkreis Offenbach am Main, Hessen, Deutschland (Town)
  2. Frankfurt am Main
    Frankfurt am Main, Stadtkreis Frankfurt am Main, Hessen, Deutschland (Town)
  3. Mühlheim am Main
    Mühlheim am Main, Offenbach, Hessen, Deutschland (Town)
  4. Offenbach
    Offenbach, Stadtkreis Offenbach am Main, Hessen, Deutschland (Town)
  5. Rumpenheim
    Rumpenheim, Stadtkreis Offenbach am Main, Hessen, Deutschland (Town)
  6. Waldheim
    Waldheim, Stadtkreis Offenbach am Main, Hessen, Deutschland (Town)
  7. Biebernsee
    Biebernsee, Stadtkreis Offenbach am Main, Hessen, Deutschland (Town)
  8. Rhein
    Rhein, Deutschland (Drainage)
  9. Main River
    Main River, Deutschland (Drainage)
  10. Gemeinde Maintal
    Gemeinde Maintal, Main-Kinzig-Kreis, Hessen, Deutschland (LocalAdmin)

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

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

        
0.042 seconds ⌛

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