25 places near 15068, Alessandria, Piemonte, Italia
  1. Pozzolo Formigaro
    Pozzolo Formigaro, Alessandria, Piemonte, Italia (Town)
  2. Pollastra
    Pollastra, Alessandria, Piemonte, Italia (Town)
  3. Bettole
    Bettole, Alessandria, Piemonte, Italia (Town)
  4. Bandetti
    Bandetti, Alessandria, Piemonte, Italia (Town)
  5. Brusadini
    Brusadini, Alessandria, Piemonte, Italia (Town)
  6. Donau
    Donau, Magyarország (Drainage)
  7. Bosco Marengo
    Bosco Marengo, Alessandria, Piemonte, Italia (LocalAdmin)
  8. Novi Ligure
    Novi Ligure, Alessandria, Piemonte, Italia (LocalAdmin)
  9. Pozzolo Formigaro
    Pozzolo Formigaro, Alessandria, Piemonte, Italia (LocalAdmin)
  10. Tortona
    Tortona, Alessandria, Piemonte, Italia (LocalAdmin)

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

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

        
0.052 seconds ⌛

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