23 places near Dreieich, Offenbach, Hessen, Deutschland
filter by placetype:
  1. Dreieichenhain Bahnhof
    Dreieichenhain Bahnhof, Offenbach, Hessen, Deutschland (POI)
  2. Dreieich
    Dreieich, Offenbach, Hessen, Deutschland (Town)
  3. Offenthal
    Offenthal, Offenbach, Hessen, Deutschland (Town)
  4. Dreieichenhain
    Dreieichenhain, Offenbach, Hessen, Deutschland (Town)
  5. Sprendlingen
    Sprendlingen, Offenbach, Hessen, Deutschland (Town)
  6. Götzenhain
    Götzenhain, Offenbach, Hessen, Deutschland (Town)
  7. Rhein
    Rhein, Deutschland (Drainage)
  8. Main River
    Main River, Deutschland (Drainage)
  9. Gemeinde Dreieich
    Gemeinde Dreieich, Offenbach, Hessen, Deutschland (LocalAdmin)
  10. Gemeinde Egelsbach
    Gemeinde Egelsbach, Offenbach, Hessen, Deutschland (LocalAdmin)

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

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

        
0.013 seconds ⌛

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