17 places near Piedras, Pinas, El Oro, Ecuador
filter by placetype:
  1. Saracay
    Saracay, Pinas, El Oro, Ecuador (Town)
  2. La Avanzada
    La Avanzada, Santa Rosa, El Oro, Ecuador (LocalAdmin)
  3. Piedras
    Piedras, Pinas, El Oro, Ecuador (LocalAdmin)
  4. Pinas
    Pinas, El Oro, Ecuador (County)
  5. Santa Rosa
    Santa Rosa, El Oro, Ecuador (County)
  6. America/Bogota
    America/Bogota (Timezone)
  7. America/Guayaquil
    America/Guayaquil, Ecuador (Timezone)
  8. America/Lima
    America/Lima (Timezone)
  9. El Oro
    El Oro, El Oro, Ecuador (State)
  10. Loja
    Loja, Loja, 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.914238,
                  -3.63238
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}