24 places near Casaletto di Sopra, Cremona, Lombardia, Italia
  1. Ticengo
    Ticengo, Cremona, Lombardia, Italia (Town)
  2. Casaletto di Sopra
    Casaletto di Sopra, Cremona, Lombardia, Italia (Town)
  3. Melotta
    Melotta, Cremona, Lombardia, Italia (Town)
  4. Fontanella
    Fontanella, Bergamo, Lombardia, Italia (Town)
  5. Donau
    Donau, Magyarország (Drainage)
  6. Adda River
    Adda River, Lodi, Lombardia, Italia (Drainage)
  7. Fontanella
    Fontanella, Bergamo, Lombardia, Italia (LocalAdmin)
  8. Romanengo
    Romanengo, Cremona, Lombardia, Italia (LocalAdmin)
  9. Ticengo
    Ticengo, Cremona, Lombardia, Italia (LocalAdmin)
  10. Casaletto di Sopra
    Casaletto di Sopra, Cremona, Lombardia, Italia (LocalAdmin)

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

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

        
0.011 seconds ⌛

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