27 places near 63075, Stadtkreis Offenbach am Main, Hessen, Deutschland
  1. Gemeinde Offenbach am Main
    Gemeinde Offenbach am Main, Stadtkreis Offenbach am Main, Hessen, Deutschland (LocalAdmin)
  2. Gemeinde Mühlheim am Main
    Gemeinde Mühlheim am Main, Offenbach, Hessen, Deutschland (LocalAdmin)
  3. Stadtteil Fechenheim
    Stadtteil Fechenheim, Stadtkreis Frankfurt am Main, Hessen, Deutschland (LocalAdmin)
  4. Main-Kinzig-Kreis
    Main-Kinzig-Kreis, Hessen, Deutschland (County)
  5. Offenbach
    Offenbach, Hessen, Deutschland (County)
  6. Stadtkreis Frankfurt am Main
    Stadtkreis Frankfurt am Main, Hessen, Deutschland (County)
  7. Stadtkreis Offenbach am Main
    Stadtkreis Offenbach am Main, Hessen, Deutschland (County)
  8. Europe/Berlin
    Europe/Berlin (Timezone)
  9. Europe/Paris
    Europe/Paris (Timezone)
  10. Hessen
    Hessen, Hessen, Deutschland (State)

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

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

        
0.02 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"
      }
    }
  ],
  "from": 10
}