20 places near Crema, Cremona, Lombardia, Italia
  1. Crema
    Crema, Cremona, Lombardia, Italia (Town)
  2. San Bernardino
    San Bernardino, Cremona, Lombardia, Italia (Town)
  3. San Moria Della Croce
    San Moria Della Croce, Cremona, Lombardia, Italia (Town)
  4. Donau
    Donau, Magyarország (Drainage)
  5. Adda River
    Adda River, Lodi, Lombardia, Italia (Drainage)
  6. Crema
    Crema, Cremona, Lombardia, Italia (LocalAdmin)
  7. Madignano
    Madignano, Cremona, Lombardia, Italia (LocalAdmin)
  8. Alps
    Alps (Colloquial)
  9. Cremona
    Cremona, Lombardia, Italia (County)
  10. Lodi
    Lodi, Lombardia, Italia (County)

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

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

        
0.021 seconds ⌛

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