21 places near 63085, Offenbach, Hessen, Deutschland
filter by placetype:
  1. Jügesheim Bahnhof
    Jügesheim Bahnhof, Offenbach, Hessen, Deutschland (POI)
  2. Dudenhofen
    Dudenhofen, Offenbach, Hessen, Deutschland (Town)
  3. Hainhausen
    Hainhausen, Offenbach, Hessen, Deutschland (Town)
  4. Jügesheim
    Jügesheim, Offenbach, Hessen, Deutschland (Town)
  5. Nieder-Roden
    Nieder-Roden, Offenbach, Hessen, Deutschland (Town)
  6. Weiskirchen
    Weiskirchen, Offenbach, Hessen, Deutschland (Town)
  7. Rodgau
    Rodgau, Offenbach, Hessen, Deutschland (Town)
  8. Rhein
    Rhein, Deutschland (Drainage)
  9. Main River
    Main River, Deutschland (Drainage)
  10. Gemeinde Rodgau
    Gemeinde Rodgau, Offenbach, Hessen, Deutschland (LocalAdmin)

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

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

        
0.024 seconds ⌛

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