21 places near Madignano, Cremona, Lombardia, Italia
  1. Madignano
    Madignano, Cremona, Lombardia, Italia (Town)
  2. Ripalta Vecchia
    Ripalta Vecchia, Cremona, Lombardia, Italia (Town)
  3. Donau
    Donau, Magyarország (Drainage)
  4. Adda River
    Adda River, Lodi, Lombardia, Italia (Drainage)
  5. Castelleone
    Castelleone, Cremona, Lombardia, Italia (LocalAdmin)
  6. Crema
    Crema, Cremona, Lombardia, Italia (LocalAdmin)
  7. Madignano
    Madignano, Cremona, Lombardia, Italia (LocalAdmin)
  8. Ripalta Cremasca
    Ripalta Cremasca, Cremona, Lombardia, Italia (LocalAdmin)
  9. Alps
    Alps (Colloquial)
  10. Cremona
    Cremona, Lombardia, Italia (County)

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

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

        
0.043 seconds ⌛

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