24 places near Ripalta Guerina, Cremona, Lombardia, Italia
  1. Montodine
    Montodine, Cremona, Lombardia, Italia (Town)
  2. Moscazzano
    Moscazzano, Cremona, Lombardia, Italia (Town)
  3. Ripalta Arpina
    Ripalta Arpina, Cremona, Lombardia, Italia (Town)
  4. Ripalta Guerina
    Ripalta Guerina, Cremona, Lombardia, Italia (Town)
  5. Donau
    Donau, Magyarország (Drainage)
  6. Adda River
    Adda River, Lodi, Lombardia, Italia (Drainage)
  7. Montodine
    Montodine, Cremona, Lombardia, Italia (LocalAdmin)
  8. Moscazzano
    Moscazzano, Cremona, Lombardia, Italia (LocalAdmin)
  9. Ripalta Cremasca
    Ripalta Cremasca, Cremona, Lombardia, Italia (LocalAdmin)
  10. Ripalta Arpina
    Ripalta Arpina, Cremona, Lombardia, Italia (LocalAdmin)

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

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

        
0.024 seconds ⌛

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