24 places near DE75 7JF, Derbyshire, England, United Kingdom
filter by placetype:
  1. Awsworth
    Awsworth, Nottinghamshire, England, United Kingdom (Town)
  2. Derby
    Derby, Derbyshire, England, United Kingdom (Town)
  3. Eastwood
    Eastwood, Nottinghamshire, England, United Kingdom (Town)
  4. Heanor
    Heanor, Derbyshire, England, United Kingdom (Town)
  5. Ilkeston
    Ilkeston, Derbyshire, England, United Kingdom (Town)
  6. Shipley
    Shipley, Derbyshire, England, United Kingdom (Town)
  7. Amber Valley Borough
    Amber Valley Borough, Derbyshire, England, United Kingdom (LocalAdmin)
  8. Erewash Borough
    Erewash Borough, Derbyshire, England, United Kingdom (LocalAdmin)
  9. Broxtowe Borough
    Broxtowe Borough, Nottinghamshire, England, United Kingdom (LocalAdmin)
  10. East Midlands
    East Midlands, England, United Kingdom (Colloquial)

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

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

        
0.104 seconds ⌛

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