21 places near 63090, 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.014 seconds ⌛; show me the details?

        
0.014 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"
      }
    }
  ]
}