23 places near Ceretto Lomellina, Pavia, Lombardia, Italia
  1. Castello d'Agogna
    Castello d'Agogna, Pavia, Lombardia, Italia (Town)
  2. Ceretto Lomellina
    Ceretto Lomellina, Pavia, Lombardia, Italia (Town)
  3. Donau
    Donau, Magyarország (Drainage)
  4. Icino River
    Icino River, Milano, Lombardia, Italia (Drainage)
  5. Mortara
    Mortara, Pavia, Lombardia, Italia (LocalAdmin)
  6. Castelnovetto
    Castelnovetto, Pavia, Lombardia, Italia (LocalAdmin)
  7. Sant'angelo Lomellina
    Sant'angelo Lomellina, Pavia, Lombardia, Italia (LocalAdmin)
  8. Castello d'Agogna
    Castello d'Agogna, Pavia, Lombardia, Italia (LocalAdmin)
  9. Ceretto Lomellina
    Ceretto Lomellina, Pavia, Lombardia, Italia (LocalAdmin)
  10. Alps
    Alps (Colloquial)

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

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

        
0.01 seconds ⌛

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