24 places near Spondon, Derbyshire, England, United Kingdom
filter by placetype:
  1. Spondon Railway Station
    Spondon Railway Station, Derbyshire, England, United Kingdom (POI)
  2. Chaddesden
    Chaddesden, Derbyshire, England, United Kingdom (Suburb)
  3. Borrowash
    Borrowash, Derbyshire, England, United Kingdom (Town)
  4. Derby
    Derby, Derbyshire, England, United Kingdom (Town)
  5. Spondon
    Spondon, Derbyshire, England, United Kingdom (Town)
  6. Amber Valley Borough
    Amber Valley Borough, Derbyshire, England, United Kingdom (LocalAdmin)
  7. Erewash Borough
    Erewash Borough, Derbyshire, England, United Kingdom (LocalAdmin)
  8. South Derbyshire District
    South Derbyshire District, Derbyshire, England, United Kingdom (LocalAdmin)
  9. Derby City
    Derby City, Derbyshire, 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.126 seconds ⌛; show me the details?

        
0.126 seconds ⌛

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