14 places near Cerro Negro, Santa Catarina, Brasil
filter by placetype:
  1. Parana River
    Parana River, Argentina (Drainage)
  2. Anita Garibaldi
    Anita Garibaldi, Santa Catarina, Brasil (County)
  3. Campo Belo do Sul
    Campo Belo do Sul, Santa Catarina, Brasil (County)
  4. São José do Cerrito
    São José do Cerrito, Santa Catarina, Brasil (County)
  5. Cerro Negro
    Cerro Negro, Santa Catarina, Brasil (County)
  6. America/Sao_Paulo
    America/Sao_Paulo, Brasil (Timezone)
  7. Rio Grande do Sul
    Rio Grande do Sul, Rio Grande do Sul, Brasil (State)
  8. Santa Catarina
    Santa Catarina, Santa Catarina, Brasil (State)
  9. Brasil
    Brasil, Brasil (Country)
  10. Atlantic Ocean
    Atlantic Ocean (Ocean)

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

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

        
0.051 seconds ⌛

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