6 places near Colma, Alessandria, Piemonte, Italia
filter by placetype:
  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)

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

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

        
0.116 seconds ⌛

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