26 places near Gemeinde Hainburg, Offenbach, Hessen, Deutschland
  1. Gemeinde Hanau
    Gemeinde Hanau, Main-Kinzig-Kreis, Hessen, Deutschland (LocalAdmin)
  2. Gemeinde Hainburg
    Gemeinde Hainburg, Offenbach, Hessen, Deutschland (LocalAdmin)
  3. Gemeinde Rodgau
    Gemeinde Rodgau, Offenbach, Hessen, Deutschland (LocalAdmin)
  4. Gemeinde Seligenstadt
    Gemeinde Seligenstadt, Offenbach, Hessen, Deutschland (LocalAdmin)
  5. Main-Kinzig-Kreis
    Main-Kinzig-Kreis, Hessen, Deutschland (County)
  6. Offenbach
    Offenbach, Hessen, Deutschland (County)
  7. Europe/Berlin
    Europe/Berlin (Timezone)
  8. Europe/Paris
    Europe/Paris (Timezone)
  9. Hessen
    Hessen, Hessen, Deutschland (State)
  10. Deutschland
    Deutschland, Deutschland (Country)

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

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

        
0.049 seconds ⌛

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