6 places near Crestwood, Alameda, California, United States
filter by placetype:
  1. Ardenwood
    Ardenwood, Alameda, California, United States (Suburb)
  2. Lakes and Birds
    Lakes and Birds, Alameda, California, United States (Suburb)
  3. Bay Colony
    Bay Colony, Alameda, California, United States (Suburb)
  4. Contempo
    Contempo, Alameda, California, United States (Suburb)
  5. Crestwood
    Crestwood, Alameda, California, United States (Suburb)
  6. Ponderosa Cove
    Ponderosa Cove, Alameda, California, United States (Suburb)

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

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

        
0.078 seconds ⌛

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