5 places near Ceretto Lomellina, Pavia, Lombardia, Italia
filter by placetype:
  1. Mortara
    Mortara, Pavia, Lombardia, Italia (LocalAdmin)
  2. Castelnovetto
    Castelnovetto, Pavia, Lombardia, Italia (LocalAdmin)
  3. Sant'angelo Lomellina
    Sant'angelo Lomellina, Pavia, Lombardia, Italia (LocalAdmin)
  4. Castello d'Agogna
    Castello d'Agogna, Pavia, Lombardia, Italia (LocalAdmin)
  5. Ceretto Lomellina
    Ceretto Lomellina, Pavia, Lombardia, Italia (LocalAdmin)

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

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

        
0.028 seconds ⌛

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