7 places near Ilietesheim, Offenbach, Hessen, Deutschland
filter by placetype:
  1. Dörnigheim
    Dörnigheim, Main-Kinzig-Kreis, Hessen, Deutschland (Town)
  2. Ilietesheim
    Ilietesheim, Offenbach, Hessen, Deutschland (Town)
  3. Kesselstadt
    Kesselstadt, Main-Kinzig-Kreis, Hessen, Deutschland (Town)
  4. Lämmerspiel
    Lämmerspiel, Offenbach, Hessen, Deutschland (Town)
  5. Mühlheim am Main
    Mühlheim am Main, Offenbach, Hessen, Deutschland (Town)
  6. Offenbach
    Offenbach, Stadtkreis Offenbach am Main, Hessen, Deutschland (Town)
  7. Dietesheim
    Dietesheim, Offenbach, Hessen, Deutschland (Town)

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

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

        
0.018 seconds ⌛

{
  "query": {
    "bool": {
      "must": [
        {
          "geo_shape": {
            "geometry": {
              "shape": {
                "type": "circle",
                "radius": "1km",
                "coordinates": [
                  8.8667,
                  50.116699
                ]
              }
            }
          }
        },
        {
          "term": {
            "woe:placetype": 7
          }
        }
      ],
      "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"
      }
    }
  ]
}