45 places near El Coloso, Hermosillo, Sonora, México
filter by placetype:
  1. Los Naranjos
    Los Naranjos, Hermosillo, Sonora, México (Suburb)
  2. Revolucion I
    Revolucion I, Hermosillo, Sonora, México (Suburb)
  3. Universidad
    Universidad, Hermosillo, Sonora, México (Suburb)
  4. Pemex
    Pemex, Hermosillo, Sonora, México (Suburb)
  5. Bellavista
    Bellavista, Hermosillo, Sonora, México (Suburb)
  6. Del Razo
    Del Razo, Hermosillo, Sonora, México (Suburb)
  7. Hacienda de la Flor
    Hacienda de la Flor, Hermosillo, Sonora, México (Suburb)
  8. Rinconada de la Cruz
    Rinconada de la Cruz, Hermosillo, Sonora, México (Suburb)
  9. Santa Rosita
    Santa Rosita, Hermosillo, Sonora, México (Suburb)
  10. Revolucion Ii
    Revolucion Ii, Hermosillo, Sonora, México (Suburb)

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

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

        
0.069 seconds ⌛

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