21 places near 63125, Offenbach, Hessen, Deutschland
  1. Dietzenbach
    Dietzenbach, Offenbach, Hessen, Deutschland (Town)
  2. Frankfurt am Main
    Frankfurt am Main, Stadtkreis Frankfurt am Main, Hessen, Deutschland (Town)
  3. Steinberg
    Steinberg, Offenbach, Hessen, Deutschland (Town)
  4. Hexenberg
    Hexenberg, Offenbach, Hessen, Deutschland (Town)
  5. Rhein
    Rhein, Deutschland (Drainage)
  6. Main River
    Main River, Deutschland (Drainage)
  7. Gemeinde Dietzenbach
    Gemeinde Dietzenbach, Offenbach, Hessen, Deutschland (LocalAdmin)
  8. Gemeinde Dreieich
    Gemeinde Dreieich, Offenbach, Hessen, Deutschland (LocalAdmin)
  9. Gemeinde Rödermark
    Gemeinde Rödermark, Offenbach, Hessen, Deutschland (LocalAdmin)
  10. Offenbach
    Offenbach, Hessen, Deutschland (County)

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

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

        
0.018 seconds ⌛

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