4 places near DE15 0QE, Derbyshire, England, United Kingdom
filter by placetype:
  1. Bretby
    Bretby, Derbyshire, England, United Kingdom (Town)
  2. Derby
    Derby, Derbyshire, England, United Kingdom (Town)
  3. Newton Solney
    Newton Solney, Derbyshire, England, United Kingdom (Town)
  4. Swadlincote
    Swadlincote, Derbyshire, England, United Kingdom (Town)

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

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

        
0.075 seconds ⌛

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