9 places near Sandhurst, Berkshire, England, United Kingdom
filter by placetype:
  1. Blackwater
    Blackwater, Hampshire, England, United Kingdom (Town)
  2. Camberley
    Camberley, Surrey, England, United Kingdom (Town)
  3. College Town
    College Town, Berkshire, England, United Kingdom (Town)
  4. Crowthorne
    Crowthorne, Berkshire, England, United Kingdom (Town)
  5. Frogmore
    Frogmore, Hampshire, England, United Kingdom (Town)
  6. Little Sandhurst
    Little Sandhurst, Berkshire, England, United Kingdom (Town)
  7. Owlsmoor
    Owlsmoor, Berkshire, England, United Kingdom (Town)
  8. Reading
    Reading, Berkshire, England, United Kingdom (Town)
  9. Sandhurst
    Sandhurst, Berkshire, England, United Kingdom (Town)

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

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

        
0.115 seconds ⌛

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