4 places near Caldirola, Alessandria, Piemonte, Italia
filter by placetype:
  1. Caldirola
    Caldirola, Alessandria, Piemonte, Italia (Town)
  2. Montecapraro
    Montecapraro, Alessandria, Piemonte, Italia (Town)
  3. Salogni
    Salogni, Alessandria, Piemonte, Italia (Town)
  4. Villaggio la Gioia
    Villaggio la Gioia, Alessandria, Piemonte, Italia (Town)

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

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

        
0.216 seconds ⌛

{
  "query": {
    "bool": {
      "must": [
        {
          "geo_shape": {
            "geometry": {
              "shape": {
                "type": "circle",
                "radius": "1km",
                "coordinates": [
                  9.15174,
                  44.728931
                ]
              }
            }
          }
        },
        {
          "term": {
            "woe:placetype": 7
          }
        }
      ],
      "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"
      }
    }
  ]
}