35 places near Crestwood, Alameda, California, United States
filter by placetype:
  1. Pioneer Elementary School
    Pioneer Elementary School, Alameda, California, United States (POI)
  2. Ardenwood
    Ardenwood, Alameda, California, United States (Suburb)
  3. Lakes and Birds
    Lakes and Birds, Alameda, California, United States (Suburb)
  4. Bay Colony
    Bay Colony, Alameda, California, United States (Suburb)
  5. Contempo
    Contempo, Alameda, California, United States (Suburb)
  6. Crestwood
    Crestwood, Alameda, California, United States (Suburb)
  7. Ponderosa Cove
    Ponderosa Cove, Alameda, California, United States (Suburb)
  8. Fremont
    Fremont, Alameda, California, United States (Town)
  9. Hayward
    Hayward, Alameda, California, United States (Town)
  10. Newark
    Newark, Alameda, California, United States (Town)

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

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

        
0.013 seconds ⌛

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