33 places near Ambrose, Contra Costa, California, United States
filter by placetype:
  1. Shore Acres
    Shore Acres, Contra Costa, California, United States (Suburb)
  2. Bailey to Canal
    Bailey to Canal, Contra Costa, California, United States (Suburb)
  3. Westwood Village
    Westwood Village, Contra Costa, California, United States (Suburb)
  4. Bay Point
    Bay Point, Contra Costa, California, United States (Town)
  5. Mcavoy
    Mcavoy, Contra Costa, California, United States (Town)
  6. Pittsburg
    Pittsburg, Contra Costa, California, United States (Town)
  7. West Pittsburg
    West Pittsburg, Contra Costa, California, United States (Town)
  8. Ambrose
    Ambrose, Contra Costa, 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.222 seconds ⌛; show me the details?

        
0.222 seconds ⌛

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