7 places near Rote Warte, Offenbach, Hessen, Deutschland
filter by placetype:
  1. Dörnigheim
    Dörnigheim, Main-Kinzig-Kreis, Hessen, Deutschland (Town)
  2. Mühlheim am Main
    Mühlheim am Main, Offenbach, Hessen, Deutschland (Town)
  3. Offenbach
    Offenbach, Stadtkreis Offenbach am Main, Hessen, Deutschland (Town)
  4. Rote Warte
    Rote Warte, Offenbach, Hessen, Deutschland (Town)
  5. Rumpenheim
    Rumpenheim, Stadtkreis Offenbach am Main, Hessen, Deutschland (Town)
  6. Waldheim
    Waldheim, Stadtkreis Offenbach am Main, Hessen, Deutschland (Town)
  7. Biebernsee
    Biebernsee, Stadtkreis Offenbach am Main, Hessen, Deutschland (Town)

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

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

        
0.038 seconds ⌛

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