25 places near Ripalta Cremasca, Cremona, Lombardia, Italia
  1. Cascine San Carlo
    Cascine San Carlo, Cremona, Lombardia, Italia (Town)
  2. Ripalta Guerina
    Ripalta Guerina, 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. Credera Rubbiano
    Credera Rubbiano, Cremona, Lombardia, Italia (LocalAdmin)

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

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

        
0.027 seconds ⌛

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