25 places near Rowthorne, Derbyshire, England, United Kingdom
filter by placetype:
  1. Ault Hucknall
    Ault Hucknall, Derbyshire, England, United Kingdom (Town)
  2. Chesterfield
    Chesterfield, Derbyshire, England, United Kingdom (Town)
  3. Glapwell
    Glapwell, Derbyshire, England, United Kingdom (Town)
  4. Mansfield Woodhouse
    Mansfield Woodhouse, Nottinghamshire, England, United Kingdom (Town)
  5. New Houghton
    New Houghton, Derbyshire, England, United Kingdom (Town)
  6. Sutton in Ashfield
    Sutton in Ashfield, Nottinghamshire, England, United Kingdom (Town)
  7. Rowthorne
    Rowthorne, Derbyshire, England, United Kingdom (Town)
  8. Bramley Vale
    Bramley Vale, Derbyshire, England, United Kingdom (Town)
  9. Bolsover District
    Bolsover District, Derbyshire, England, United Kingdom (LocalAdmin)
  10. North East Derbyshire District
    North East Derbyshire District, Derbyshire, England, United Kingdom (LocalAdmin)

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

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

        
0.028 seconds ⌛

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