7 places near Campagnola Cremasca, Cremona, Lombardia, Italia
filter by placetype:
  1. Sergnano
    Sergnano, Cremona, Lombardia, Italia (Town)
  2. Campagnola Cremasca
    Campagnola Cremasca, Cremona, Lombardia, Italia (Town)
  3. Casaletto Vaprio
    Casaletto Vaprio, Cremona, Lombardia, Italia (Town)
  4. Cascina Torchio
    Cascina Torchio, Cremona, Lombardia, Italia (Town)
  5. Cremosano
    Cremosano, Cremona, Lombardia, Italia (Town)
  6. Pianengo
    Pianengo, Cremona, Lombardia, Italia (Town)
  7. 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.03 seconds ⌛; show me the details?

        
0.03 seconds ⌛

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