23 places near Dreieich, Offenbach, Hessen, Deutschland
filter by placetype:
  1. Gemeinde Langen
    Gemeinde Langen, Offenbach, Hessen, Deutschland (LocalAdmin)
  2. Darmstadt-Dieburg
    Darmstadt-Dieburg, Hessen, Deutschland (County)
  3. Offenbach
    Offenbach, Hessen, Deutschland (County)
  4. Europe/Berlin
    Europe/Berlin (Timezone)
  5. Europe/Paris
    Europe/Paris (Timezone)
  6. Hessen
    Hessen, Hessen, Deutschland (State)
  7. Deutschland
    Deutschland, Deutschland (Country)
  8. Atlantic Ocean
    Atlantic Ocean (Ocean)
  9. Pacific Ocean
    Pacific Ocean (Ocean)
  10. Europe
    Europe (Continent)

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

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

        
0.031 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"
      }
    }
  ],
  "from": 10
}