25 places near San Martino, Alessandria, Piemonte, Italia
  1. Frassinello
    Frassinello, Alessandria, Piemonte, Italia (Town)
  2. Terruggia
    Terruggia, Alessandria, Piemonte, Italia (Town)
  3. San Martino
    San Martino, Alessandria, Piemonte, Italia (Town)
  4. Berroni
    Berroni, Alessandria, Piemonte, Italia (Town)
  5. Rosignano Monferrato
    Rosignano Monferrato, Alessandria, Piemonte, Italia (Town)
  6. Stevani
    Stevani, 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.41833,
                  45.063881
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}