6 places near Vailate, Cremona, Lombardia, Italia
filter by placetype:
  1. Calvenzano
    Calvenzano, Bergamo, Lombardia, Italia (Town)
  2. Misano di Gera d'Adda
    Misano di Gera d'Adda, Bergamo, Lombardia, Italia (Town)
  3. Vailate
    Vailate, Cremona, Lombardia, Italia (Town)
  4. Azzano
    Azzano, Cremona, Lombardia, Italia (Town)
  5. Donizzetti
    Donizzetti, Bergamo, Lombardia, Italia (Town)
  6. Farinate
    Farinate, Cremona, Lombardia, Italia (Town)

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

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

        
0.031 seconds ⌛

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