31 places near Waterford, Alameda, California, United States
filter by placetype:
  1. Baylands
    Baylands, Alameda, California, United States (Suburb)
  2. Murietta
    Murietta, Alameda, California, United States (Suburb)
  3. Waterford
    Waterford, Alameda, California, United States (Suburb)
  4. 28 Palms
    28 Palms, Alameda, California, United States (Suburb)
  5. Blacow
    Blacow, Alameda, California, United States (Suburb)
  6. Fremont
    Fremont, Alameda, California, United States (Town)
  7. Newark
    Newark, Alameda, California, United States (Town)
  8. San Jose
    San Jose, Santa Clara, California, United States (Town)
  9. Central Valley
    Central Valley, California, United States (Colloquial)
  10. San Francisco Bay Area
    San Francisco Bay Area, California, United States (Colloquial)

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

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

        
0.035 seconds ⌛

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