6 places near Spinone al Lago, Bergamo, Lombardia, Italia
filter by placetype:
  1. Casazza
    Casazza, Bergamo, Lombardia, Italia (Town)
  2. Monasterolo del Castello
    Monasterolo del Castello, Bergamo, Lombardia, Italia (Town)
  3. Bianzano
    Bianzano, Bergamo, Lombardia, Italia (Town)
  4. Ranzanico
    Ranzanico, Bergamo, Lombardia, Italia (Town)
  5. Spinone al Lago
    Spinone al Lago, Bergamo, Lombardia, Italia (Town)
  6. San Felice Al Lago
    San Felice Al Lago, Bergamo, Lombardia, Italia (Town)

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

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

        
0.024 seconds ⌛

{
  "query": {
    "bool": {
      "must": [
        {
          "geo_shape": {
            "geometry": {
              "shape": {
                "type": "circle",
                "radius": "1km",
                "coordinates": [
                  9.91908,
                  45.7659
                ]
              }
            }
          }
        },
        {
          "term": {
            "woe:placetype": 7
          }
        }
      ],
      "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"
      }
    }
  ]
}