20 places near 63263, Offenbach, Hessen, Deutschland
  1. Sachsenhausen
    Sachsenhausen, Stadtkreis Frankfurt am Main, Hessen, Deutschland (Suburb)
  2. Frankfurt am Main
    Frankfurt am Main, Stadtkreis Frankfurt am Main, Hessen, Deutschland (Town)
  3. Sprendlingen
    Sprendlingen, Offenbach, Hessen, Deutschland (Town)
  4. Neu-Isenburg
    Neu-Isenburg, Offenbach, Hessen, Deutschland (Town)
  5. Rhein
    Rhein, Deutschland (Drainage)
  6. Main River
    Main River, Deutschland (Drainage)
  7. Gemeinde Dreieich
    Gemeinde Dreieich, Offenbach, Hessen, Deutschland (LocalAdmin)
  8. Gemeinde Neu-Isenburg
    Gemeinde Neu-Isenburg, Offenbach, Hessen, Deutschland (LocalAdmin)
  9. Offenbach
    Offenbach, Hessen, Deutschland (County)
  10. Stadtkreis Frankfurt am Main
    Stadtkreis Frankfurt am Main, Hessen, Deutschland (County)

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.67684,
                  50.04068
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}