6 places near Cascina Torchio, Cremona, Lombardia, Italia
filter by placetype:
  1. Campagnola Cremasca
    Campagnola Cremasca, Cremona, Lombardia, Italia (Town)
  2. Casaletto Vaprio
    Casaletto Vaprio, Cremona, Lombardia, Italia (Town)
  3. Cascina Torchio
    Cascina Torchio, Cremona, Lombardia, Italia (Town)
  4. Pianengo
    Pianengo, Cremona, Lombardia, Italia (Town)
  5. San Moria Della Croce
    San Moria Della Croce, Cremona, Lombardia, Italia (Town)
  6. Cascina Colombara
    Cascina Colombara, Cremona, 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.67824,
                  45.399021
                ]
              }
            }
          }
        },
        {
          "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"
      }
    }
  ]
}