7 places near Zappello, Cremona, Lombardia, Italia
filter by placetype:
  1. Capergnanica di Sotto
    Capergnanica di Sotto, Cremona, Lombardia, Italia (Town)
  2. Bolzone
    Bolzone, Cremona, Lombardia, Italia (Town)
  3. Cascine San Carlo
    Cascine San Carlo, Cremona, Lombardia, Italia (Town)
  4. Ripalta Nuova
    Ripalta Nuova, Cremona, Lombardia, Italia (Town)
  5. Trampolino
    Trampolino, Cremona, Lombardia, Italia (Town)
  6. Zappello
    Zappello, Cremona, Lombardia, Italia (Town)
  7. San Michele
    San Michele, Cremona, Lombardia, Italia (Town)

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

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

        
0.034 seconds ⌛

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