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

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

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

        
0.016 seconds ⌛

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