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

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

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

        
0.017 seconds ⌛

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