19 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. Alps
    Alps (Colloquial)
  8. Cremona
    Cremona, Lombardia, Italia (County)
  9. Lodi
    Lodi, Lombardia, Italia (County)
  10. Europe/Rome
    Europe/Rome (Timezone)

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

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

        
0.022 seconds ⌛

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