24 places near Sergnano, Cremona, Lombardia, Italia
  1. Capralba
    Capralba, Cremona, Lombardia, Italia (Town)
  2. Mozzanica
    Mozzanica, Bergamo, Lombardia, Italia (Town)
  3. Sergnano
    Sergnano, Cremona, Lombardia, Italia (Town)
  4. Trezzolasco
    Trezzolasco, Cremona, Lombardia, Italia (Town)
  5. Donau
    Donau, Magyarország (Drainage)
  6. Adda River
    Adda River, Lodi, Lombardia, Italia (Drainage)
  7. Caravaggio
    Caravaggio, Bergamo, Lombardia, Italia (LocalAdmin)
  8. Casale Cremasco-vidolasco
    Casale Cremasco-vidolasco, Cremona, Lombardia, Italia (LocalAdmin)
  9. Mozzanica
    Mozzanica, Bergamo, Lombardia, Italia (LocalAdmin)
  10. Sergnano
    Sergnano, Cremona, Lombardia, Italia (LocalAdmin)

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

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

        
0.042 seconds ⌛

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