23 places near 63163, Offenbach, Hessen, Deutschland
filter by placetype:
  1. Stadtmuseum Mühlheim
    Stadtmuseum Mühlheim, Offenbach, Hessen, Deutschland (POI)
  2. Dörnigheim
    Dörnigheim, Main-Kinzig-Kreis, 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. Biebernsee
    Biebernsee, Stadtkreis Offenbach am Main, Hessen, Deutschland (Town)
  6. Rhein
    Rhein, Deutschland (Drainage)
  7. Main River
    Main River, Deutschland (Drainage)
  8. Gemeinde Maintal
    Gemeinde Maintal, Main-Kinzig-Kreis, Hessen, Deutschland (LocalAdmin)
  9. Gemeinde Offenbach am Main
    Gemeinde Offenbach am Main, Stadtkreis Offenbach am Main, 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.021 seconds ⌛; show me the details?

        
0.021 seconds ⌛

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