25 places near Berroni, Alessandria, Piemonte, Italia
  1. Terruggia
    Terruggia, Alessandria, Piemonte, Italia (Town)
  2. San Martino
    San Martino, Alessandria, Piemonte, Italia (Town)
  3. Berroni
    Berroni, Alessandria, Piemonte, Italia (Town)
  4. Colma
    Colma, Alessandria, Piemonte, Italia (Town)
  5. Garriano
    Garriano, Alessandria, Piemonte, Italia (Town)
  6. Rosignano Monferrato
    Rosignano Monferrato, Alessandria, Piemonte, Italia (Town)
  7. Rhone River
    Rhone River, Gard, Languedoc-Roussillon, France (Drainage)
  8. Durance River
    Durance River, Provence-Alpes-Côte d'Azur, France (Drainage)
  9. Casale Monferrato
    Casale Monferrato, Alessandria, Piemonte, Italia (LocalAdmin)
  10. Terruggia
    Terruggia, Alessandria, Piemonte, Italia (LocalAdmin)

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": [
                  8.42729,
                  45.071499
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}