25 places near Colma, Alessandria, Piemonte, Italia
  1. Terruggia
    Terruggia, Alessandria, Piemonte, Italia (Town)
  2. Berroni
    Berroni, Alessandria, Piemonte, Italia (Town)
  3. Colma
    Colma, Alessandria, Piemonte, Italia (Town)
  4. Garriano
    Garriano, Alessandria, Piemonte, Italia (Town)
  5. Rosignano Monferrato
    Rosignano Monferrato, Alessandria, Piemonte, Italia (Town)
  6. San Giorgio Monferrato
    San Giorgio 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.029 seconds ⌛; show me the details?

        
0.029 seconds ⌛

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