26 places near Cascina Colomberone, Bergamo, Lombardia, Italia
  1. Capralba
    Capralba, Cremona, Lombardia, Italia (Town)
  2. Castel Gabbiano
    Castel Gabbiano, Cremona, Lombardia, Italia (Town)
  3. Mozzanica
    Mozzanica, Bergamo, Lombardia, Italia (Town)
  4. Cascina Colomberone
    Cascina Colomberone, Bergamo, Lombardia, Italia (Town)
  5. Trezzolasco
    Trezzolasco, Cremona, Lombardia, Italia (Town)
  6. Donau
    Donau, Magyarország (Drainage)
  7. Adda River
    Adda River, Lodi, Lombardia, Italia (Drainage)
  8. Caravaggio
    Caravaggio, Bergamo, Lombardia, Italia (LocalAdmin)
  9. Casale Cremasco-vidolasco
    Casale Cremasco-vidolasco, Cremona, Lombardia, Italia (LocalAdmin)
  10. Mozzanica
    Mozzanica, Bergamo, Lombardia, Italia (LocalAdmin)

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

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

        
0.02 seconds ⌛

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