5 places near San Bernardino, Cremona, Lombardia, Italia
filter by placetype:
  1. Crema
    Crema, Cremona, Lombardia, Italia (Town)
  2. Madignano
    Madignano, Cremona, Lombardia, Italia (Town)
  3. Offanengo
    Offanengo, Cremona, Lombardia, Italia (Town)
  4. San Bernardino
    San Bernardino, Cremona, Lombardia, Italia (Town)
  5. San Moria Della Croce
    San Moria Della Croce, Cremona, Lombardia, Italia (Town)

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

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

        
0.045 seconds ⌛

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