11 places near Sunnyvale, Santa Clara, California, United States
filter by placetype:
  1. North Valley
    North Valley, Santa Clara, California, United States (Suburb)
  2. Cherry Chase
    Cherry Chase, Santa Clara, California, United States (Suburb)
  3. Cherry Orchard
    Cherry Orchard, Santa Clara, California, United States (Suburb)
  4. Community Center
    Community Center, Santa Clara, California, United States (Suburb)
  5. Cumberland South
    Cumberland South, Santa Clara, California, United States (Suburb)
  6. Downtown Sunnyvale
    Downtown Sunnyvale, Santa Clara, California, United States (Suburb)
  7. Heritage District
    Heritage District, Santa Clara, California, United States (Suburb)
  8. Old Orchard
    Old Orchard, Santa Clara, California, United States (Suburb)
  9. Sunnyvale Town Center
    Sunnyvale Town Center, Santa Clara, California, United States (Suburb)
  10. North San Jose
    North San Jose, Santa Clara, California, United States (Suburb)

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

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

        
0.011 seconds ⌛

{
  "query": {
    "bool": {
      "must": [
        {
          "geo_shape": {
            "geometry": {
              "shape": {
                "type": "circle",
                "radius": "1km",
                "coordinates": [
                  -122.038254,
                  37.371609
                ]
              }
            }
          }
        },
        {
          "term": {
            "woe:placetype": 22
          }
        }
      ],
      "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"
      }
    }
  ]
}