24 places near Cassano Spinola, Alessandria, Piemonte, Italia
  1. Cassano Spinola
    Cassano Spinola, Alessandria, Piemonte, Italia (Town)
  2. Gavazzana
    Gavazzana, Alessandria, Piemonte, Italia (Town)
  3. Case Serventi
    Case Serventi, Alessandria, Piemonte, Italia (Town)
  4. Donau
    Donau, Magyarország (Drainage)
  5. Cassano Spinola
    Cassano Spinola, Alessandria, Piemonte, Italia (LocalAdmin)
  6. Novi Ligure
    Novi Ligure, Alessandria, Piemonte, Italia (LocalAdmin)
  7. Serravalle Scrivia
    Serravalle Scrivia, Alessandria, Piemonte, Italia (LocalAdmin)
  8. Stazzano
    Stazzano, Alessandria, Piemonte, Italia (LocalAdmin)
  9. Gavazzana
    Gavazzana, Alessandria, Piemonte, Italia (LocalAdmin)
  10. Alps
    Alps (Colloquial)

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

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

        
0.02 seconds ⌛

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