5 places near DE21 7TQ, Derbyshire, England, United Kingdom
filter by placetype:
  1. Borrowash
    Borrowash, Derbyshire, England, United Kingdom (Town)
  2. Derby
    Derby, Derbyshire, England, United Kingdom (Town)
  3. Elvaston
    Elvaston, Derbyshire, England, United Kingdom (Town)
  4. Ockbrook
    Ockbrook, Derbyshire, England, United Kingdom (Town)
  5. Spondon
    Spondon, Derbyshire, England, United Kingdom (Town)

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

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

        
0.059 seconds ⌛

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