27 places near De Esch, Rotterdam, Zuid-Holland, Nederland
filter by placetype:
  1. Zomerland
    Zomerland, Rotterdam, Zuid-Holland, Nederland (Suburb)
  2. Capelle Aan den Ijssel
    Capelle Aan den Ijssel, Capelle aan den Ijssel, Zuid-Holland, Nederland (Town)
  3. Kralingse Veer
    Kralingse Veer, Rotterdam, Zuid-Holland, Nederland (Town)
  4. Rotterdam
    Rotterdam, Rotterdam, Zuid-Holland, Nederland (Town)
  5. Capelle aan den Ijssel
    Capelle aan den Ijssel, Zuid-Holland, Nederland (County)
  6. Rotterdam
    Rotterdam, Zuid-Holland, Nederland (County)
  7. Europe/Amsterdam
    Europe/Amsterdam (Timezone)
  8. Zuid-Holland
    Zuid-Holland, Zuid-Holland, Nederland (State)
  9. Nederland
    Nederland, Nederland (Country)
  10. North Sea
    North Sea (Sea)

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

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

        
0.021 seconds ⌛

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