35 places near Joaquin Ranch, Contra Costa, California, United States
filter by placetype:
  1. Blackwood
    Blackwood, Contra Costa, California, United States (Suburb)
  2. Joaquin Ranch
    Joaquin Ranch, Contra Costa, California, United States (Suburb)
  3. Meadow Creek
    Meadow Creek, Contra Costa, California, United States (Suburb)
  4. Northgate
    Northgate, Contra Costa, California, United States (Suburb)
  5. Somerset
    Somerset, Contra Costa, California, United States (Suburb)
  6. Sterling Ridge
    Sterling Ridge, Contra Costa, California, United States (Suburb)
  7. Wild Oak
    Wild Oak, Contra Costa, California, United States (Suburb)
  8. Alamo
    Alamo, Contra Costa, California, United States (Town)
  9. Walnut Creek
    Walnut Creek, Contra Costa, California, United States (Town)
  10. Central Valley
    Central Valley, California, United States (Colloquial)

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

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

        
0.065 seconds ⌛

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