6 places near Campagnola Cremasca, 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. Cremosano
    Cremosano, Cremona, Lombardia, Italia (Town)
  5. Pianengo
    Pianengo, 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.046 seconds ⌛; show me the details?

        
0.046 seconds ⌛

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