23 places near 63073, Stadtkreis Offenbach am Main, Hessen, Deutschland
filter by placetype:
  1. Offenbach-Bieber Bahnhof
    Offenbach-Bieber Bahnhof, Stadtkreis Offenbach am Main, Hessen, Deutschland (POI)
  2. Bieber
    Bieber, Stadtkreis Offenbach am Main, Hessen, Deutschland (Town)
  3. Heusenstamm
    Heusenstamm, Offenbach, Hessen, Deutschland (Town)
  4. Obertshausen
    Obertshausen, Offenbach, Hessen, Deutschland (Town)
  5. Offenbach
    Offenbach, Stadtkreis Offenbach am Main, Hessen, Deutschland (Town)
  6. Rhein
    Rhein, Deutschland (Drainage)
  7. Main River
    Main River, Deutschland (Drainage)
  8. Gemeinde Offenbach am Main
    Gemeinde Offenbach am Main, Stadtkreis Offenbach am Main, Hessen, Deutschland (LocalAdmin)
  9. Gemeinde Mühlheim am Main
    Gemeinde Mühlheim am Main, Offenbach, Hessen, Deutschland (LocalAdmin)
  10. Gemeinde Obertshausen
    Gemeinde Obertshausen, Offenbach, Hessen, Deutschland (LocalAdmin)

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

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

        
0.014 seconds ⌛

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