23 places near Melotta, Cremona, Lombardia, Italia
  1. Ticengo
    Ticengo, Cremona, Lombardia, Italia (Town)
  2. Casaletto di Sopra
    Casaletto di Sopra, Cremona, Lombardia, Italia (Town)
  3. Melotta
    Melotta, Cremona, Lombardia, Italia (Town)
  4. Fontanella
    Fontanella, Bergamo, Lombardia, Italia (Town)
  5. Donau
    Donau, Magyarország (Drainage)
  6. Adda River
    Adda River, Lodi, Lombardia, Italia (Drainage)
  7. Soncino
    Soncino, Cremona, Lombardia, Italia (LocalAdmin)
  8. Romanengo
    Romanengo, Cremona, Lombardia, Italia (LocalAdmin)
  9. Ticengo
    Ticengo, Cremona, Lombardia, Italia (LocalAdmin)
  10. Casaletto di Sopra
    Casaletto di Sopra, Cremona, Lombardia, Italia (LocalAdmin)

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

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

        
0.026 seconds ⌛

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