18 places near Santa Rosa, El Oro, Ecuador
filter by placetype:
  1. Buenavista
    Buenavista, Pasaje, El Oro, Ecuador (LocalAdmin)
  2. Santa Rosa
    Santa Rosa, Santa Rosa, El Oro, Ecuador (LocalAdmin)
  3. La Victoria
    La Victoria, Santa Rosa, El Oro, Ecuador (LocalAdmin)
  4. Machala
    Machala, El Oro, Ecuador (County)
  5. Pasaje
    Pasaje, El Oro, Ecuador (County)
  6. Santa Rosa
    Santa Rosa, El Oro, Ecuador (County)
  7. America/Bogota
    America/Bogota (Timezone)
  8. America/Guayaquil
    America/Guayaquil, Ecuador (Timezone)
  9. America/Lima
    America/Lima (Timezone)
  10. El Oro
    El Oro, El Oro, Ecuador (State)

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

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

        
0.038 seconds ⌛

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