25 places near Casaletto Ceredano, Cremona, Lombardia, Italia
  1. Casaletto Ceredano
    Casaletto Ceredano, Cremona, Lombardia, Italia (Town)
  2. Abbadia Cerreto
    Abbadia Cerreto, Lodi, Lombardia, Italia (Town)
  3. Le Gere
    Le Gere, Cremona, Lombardia, Italia (Town)
  4. Passarera
    Passarera, Cremona, Lombardia, Italia (Town)
  5. Rubbiano
    Rubbiano, Cremona, Lombardia, Italia (Town)
  6. Donau
    Donau, Magyarország (Drainage)
  7. Adda River
    Adda River, Lodi, Lombardia, Italia (Drainage)
  8. Capergnanica
    Capergnanica, Cremona, Lombardia, Italia (LocalAdmin)
  9. Casaletto Ceredano
    Casaletto Ceredano, Cremona, Lombardia, Italia (LocalAdmin)
  10. Cavenago d'Adda
    Cavenago d'Adda, Lodi, Lombardia, Italia (LocalAdmin)

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

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

        
0.025 seconds ⌛

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