5 places near Casaletto Ceredano, Cremona, Lombardia, Italia
filter by placetype:
  1. Capergnanica
    Capergnanica, Cremona, Lombardia, Italia (LocalAdmin)
  2. Casaletto Ceredano
    Casaletto Ceredano, Cremona, Lombardia, Italia (LocalAdmin)
  3. Cavenago d'Adda
    Cavenago d'Adda, Lodi, Lombardia, Italia (LocalAdmin)
  4. Credera Rubbiano
    Credera Rubbiano, Cremona, Lombardia, Italia (LocalAdmin)
  5. Abbadia Cerreto
    Abbadia Cerreto, Lodi, Lombardia, Italia (LocalAdmin)

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

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

        
0.019 seconds ⌛

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