24 places near Casaletto di Sopra, Cremona, Lombardia, Italia
  1. Camisano
    Camisano, 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. Casaletto di Sopra
    Casaletto di Sopra, Cremona, Lombardia, Italia (LocalAdmin)
  10. Ricengo
    Ricengo, Cremona, 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.78223,
                  45.41914
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}