24 places near Cascina Colombara, Cremona, Lombardia, Italia
  1. Crema
    Crema, Cremona, Lombardia, Italia (Town)
  2. Cascina Colombara
    Cascina Colombara, Cremona, Lombardia, Italia (Town)
  3. Campagnola Cremasca
    Campagnola Cremasca, Cremona, Lombardia, Italia (Town)
  4. Cremosano
    Cremosano, Cremona, Lombardia, Italia (Town)
  5. Santa Maria Dei Mosi
    Santa Maria Dei Mosi, Cremona, Lombardia, Italia (Town)
  6. Santo Stefano in Vairano
    Santo Stefano in Vairano, Cremona, Lombardia, Italia (Town)
  7. Donau
    Donau, Magyarország (Drainage)
  8. Adda River
    Adda River, Lodi, Lombardia, Italia (Drainage)
  9. Crema
    Crema, Cremona, Lombardia, Italia (LocalAdmin)
  10. Campagnola Cremasca
    Campagnola Cremasca, 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.66065,
                  45.381409
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}