23 places near Ripalta Vecchia, 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. Donau
    Donau, Magyarország (Drainage)
  7. Adda River
    Adda River, Lodi, Lombardia, Italia (Drainage)
  8. Crema
    Crema, Cremona, Lombardia, Italia (LocalAdmin)
  9. Madignano
    Madignano, Cremona, Lombardia, Italia (LocalAdmin)
  10. Ripalta Cremasca
    Ripalta Cremasca, Cremona, Lombardia, Italia (LocalAdmin)

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

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

        
0.046 seconds ⌛

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