23 places near 01890 Coldstream, United Kingdom
  1. Duns
    Duns, The Scottish Borders, Scotland, United Kingdom (Town)
  2. Ladykirk
    Ladykirk, The Scottish Borders, Scotland, United Kingdom (Town)
  3. Whitsome
    Whitsome, The Scottish Borders, Scotland, United Kingdom (Town)
  4. Blackadder
    Blackadder, The Scottish Borders, Scotland, United Kingdom (Town)
  5. Berwick-upon-Tweed District
    Berwick-upon-Tweed District, Northumberland, England, United Kingdom (LocalAdmin)
  6. The Scottish Borders
    The Scottish Borders, The Scottish Borders, Scotland, United Kingdom (LocalAdmin)
  7. Northern England
    Northern England, England, United Kingdom (Colloquial)
  8. North East England
    North East England, England, United Kingdom (Colloquial)
  9. Great Britain
    Great Britain, United Kingdom (Colloquial)
  10. England and Wales
    England and Wales, United Kingdom (Colloquial)

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

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

        
0.092 seconds ⌛

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