30 places near 93636, Madera, California, United States
filter by placetype:
  1. Mexico International Border States
    Mexico International Border States, United States (Colloquial)
  2. Intermountain States
    Intermountain States, United States (Colloquial)
  3. Middle America
    Middle America, United States (Colloquial)
  4. Continental United States
    Continental United States, United States (Colloquial)
  5. Mojave Desert
    Mojave Desert, United States (Colloquial)
  6. Great Basin
    Great Basin, United States (Colloquial)
  7. Cascadia
    Cascadia, United States (Colloquial)
  8. Northern California
    Northern California, California, United States (Colloquial)
  9. San Joaquin Valley
    San Joaquin Valley, California, United States (Colloquial)
  10. Mountain States
    Mountain States, United States (Colloquial)

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

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

        
0.043 seconds ⌛

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