6 places near DE72 3RB, Derbyshire, England, United Kingdom
filter by placetype:
  1. Borrowash
    Borrowash, Derbyshire, England, United Kingdom (Town)
  2. Dale Abbey
    Dale Abbey, Derbyshire, England, United Kingdom (Town)
  3. Derby
    Derby, Derbyshire, England, United Kingdom (Town)
  4. Draycott
    Draycott, Derbyshire, England, United Kingdom (Town)
  5. Ockbrook
    Ockbrook, Derbyshire, England, United Kingdom (Town)
  6. 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.062 seconds ⌛; show me the details?

        
0.062 seconds ⌛

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