33 places near Stamford Hill, Greater London, England, United Kingdom
filter by placetype:
  1. Stamford Hill Railway Station
    Stamford Hill Railway Station, Greater London, England, United Kingdom (POI)
  2. Stoke Newington Railway Station
    Stoke Newington Railway Station, Greater London, England, United Kingdom (POI)
  3. Yeshivo Horomo Talmudical College
    Yeshivo Horomo Talmudical College, Greater London, England, United Kingdom (POI)
  4. Stoke Newington
    Stoke Newington, Greater London, England, United Kingdom (Suburb)
  5. Tottenham
    Tottenham, Greater London, England, United Kingdom (Suburb)
  6. Upper Clapton
    Upper Clapton, Greater London, England, United Kingdom (Suburb)
  7. Lower Clapton
    Lower Clapton, Greater London, England, United Kingdom (Suburb)
  8. Stamford Hill
    Stamford Hill, Greater London, England, United Kingdom (Suburb)
  9. Finsbury Park
    Finsbury Park, Greater London, England, United Kingdom (Suburb)
  10. Clapton
    Clapton, Greater London, England, United Kingdom (Suburb)

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

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

        
0.12 seconds ⌛

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