24 places near Casale Cremasco, Cremona, Lombardia, Italia
  1. Mozzanica
    Mozzanica, Bergamo, Lombardia, Italia (Town)
  2. Sergnano
    Sergnano, Cremona, Lombardia, Italia (Town)
  3. Casale Cremasco
    Casale Cremasco, Cremona, Lombardia, Italia (Town)
  4. Trezzolasco
    Trezzolasco, Cremona, Lombardia, Italia (Town)
  5. Donau
    Donau, Magyarország (Drainage)
  6. Adda River
    Adda River, Lodi, Lombardia, Italia (Drainage)
  7. Casale Cremasco-vidolasco
    Casale Cremasco-vidolasco, Cremona, Lombardia, Italia (LocalAdmin)
  8. Mozzanica
    Mozzanica, Bergamo, Lombardia, Italia (LocalAdmin)
  9. Sergnano
    Sergnano, 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.021 seconds ⌛; show me the details?

        
0.021 seconds ⌛

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