25 places near Crotta d'Adda, Cremona, Lombardia, Italia
  1. Crotta d'Adda
    Crotta d'Adda, Cremona, Lombardia, Italia (Town)
  2. Meleti
    Meleti, Lodi, Lombardia, Italia (Town)
  3. Il Cavo
    Il Cavo, Lodi, Lombardia, Italia (Town)
  4. Maccastorna
    Maccastorna, Lodi, Lombardia, Italia (Town)
  5. Donau
    Donau, Magyarország (Drainage)
  6. Po River
    Po River, Rovigo, Veneto, Italia (Drainage)
  7. Adda River
    Adda River, Lodi, Lombardia, Italia (Drainage)
  8. Crotta d'Adda
    Crotta d'Adda, Cremona, Lombardia, Italia (LocalAdmin)
  9. Grumello Cremonese Ed Uniti
    Grumello Cremonese Ed Uniti, Cremona, Lombardia, Italia (LocalAdmin)
  10. Meleti
    Meleti, Lodi, Lombardia, Italia (LocalAdmin)

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

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

        
0.029 seconds ⌛

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