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

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

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

        
0.181 seconds ⌛

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