13 places near Boa Esperança, João Costa, Piauí, Brasil
filter by placetype:
  1. Boa Esperança
    Boa Esperança, João Costa, Piauí, Brasil (Town)
  2. Sao Francisco River
    Sao Francisco River, Brasil (Drainage)
  3. São João do Piauí
    São João do Piauí, Piauí, Brasil (County)
  4. João Costa
    João Costa, Piauí, Brasil (County)
  5. America/Fortaleza
    America/Fortaleza, Brasil (Timezone)
  6. Maranhão
    Maranhão, Maranhão, Brasil (State)
  7. Piauí
    Piauí, Piauí, Brasil (State)
  8. Brasil
    Brasil, Brasil (Country)
  9. Atlantic Ocean
    Atlantic Ocean (Ocean)
  10. Pacific Ocean
    Pacific Ocean (Ocean)

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

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

        
0.037 seconds ⌛

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