25 places near Ripalta Nuova, Cremona, Lombardia, Italia
  1. Madignano
    Madignano, Cremona, Lombardia, Italia (Town)
  2. Marchessa
    Marchessa, Cremona, Lombardia, Italia (Town)
  3. Ripalta Nuova
    Ripalta Nuova, Cremona, Lombardia, Italia (Town)
  4. Ripalta Vecchia
    Ripalta Vecchia, Cremona, Lombardia, Italia (Town)
  5. Trampolino
    Trampolino, Cremona, Lombardia, Italia (Town)
  6. Zappello
    Zappello, Cremona, Lombardia, Italia (Town)
  7. San Michele
    San Michele, Cremona, Lombardia, Italia (Town)
  8. Donau
    Donau, Magyarország (Drainage)
  9. Adda River
    Adda River, Lodi, Lombardia, Italia (Drainage)
  10. Crema
    Crema, Cremona, Lombardia, Italia (LocalAdmin)

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

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

        
0.023 seconds ⌛

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