22 places near 63509, Offenbach, Hessen, Deutschland
filter by placetype:
  1. Hainstadt Bahnhof
    Hainstadt Bahnhof, Offenbach, Hessen, Deutschland (POI)
  2. Großkrotzenburg
    Großkrotzenburg, Main-Kinzig-Kreis, Hessen, Deutschland (Town)
  3. Hainstadt
    Hainstadt, Offenbach, Hessen, Deutschland (Town)
  4. Hainburg
    Hainburg, Offenbach, Hessen, Deutschland (Town)
  5. Rhein
    Rhein, Deutschland (Drainage)
  6. Main River
    Main River, Deutschland (Drainage)
  7. Gemeinde Großkrotzenburg
    Gemeinde Großkrotzenburg, Main-Kinzig-Kreis, Hessen, Deutschland (LocalAdmin)
  8. Gemeinde Hanau
    Gemeinde Hanau, Main-Kinzig-Kreis, Hessen, Deutschland (LocalAdmin)
  9. Gemeinde Hainburg
    Gemeinde Hainburg, Offenbach, Hessen, Deutschland (LocalAdmin)
  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.01 seconds ⌛; show me the details?

        
0.01 seconds ⌛

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