14 places near Cachoeirinha, São Paulo, São Paulo, Brasil
filter by placetype:
  1. Casa Verde
    Casa Verde, São Paulo, São Paulo, Brasil (Suburb)
  2. Brasilandia
    Brasilandia, São Paulo, São Paulo, Brasil (Suburb)
  3. Cachoeirinha
    Cachoeirinha, São Paulo, São Paulo, Brasil (Town)
  4. São Paulo
    São Paulo, São Paulo, São Paulo, Brasil (Town)
  5. Uberlândia
    Uberlândia, Uberlândia, Minas Gerais, Brasil (Town)
  6. São Paulo
    São Paulo, São Paulo, Brasil (County)
  7. America/Sao_Paulo
    America/Sao_Paulo, Brasil (Timezone)
  8. São Paulo
    São Paulo, São Paulo, 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.013 seconds ⌛; show me the details?

        
0.013 seconds ⌛

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