7 places near San Cristoforo, Alessandria, Piemonte, Italia
filter by placetype:
  1. Gavi
    Gavi, Alessandria, Piemonte, Italia (LocalAdmin)
  2. San Cristoforo
    San Cristoforo, Alessandria, Piemonte, Italia (LocalAdmin)
  3. Capriata d'Orba
    Capriata d'Orba, Alessandria, Piemonte, Italia (LocalAdmin)
  4. Castelletto d'Orba
    Castelletto d'Orba, Alessandria, Piemonte, Italia (LocalAdmin)
  5. Francavilla Bisio
    Francavilla Bisio, Alessandria, Piemonte, Italia (LocalAdmin)
  6. Montaldeo
    Montaldeo, Alessandria, Piemonte, Italia (LocalAdmin)
  7. Parodi Ligure
    Parodi Ligure, Alessandria, Piemonte, Italia (LocalAdmin)

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

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

        
0.022 seconds ⌛

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