2 places near Offanengo, Cremona, Lombardia, Italia
filter by placetype:
  1. Donau
    Donau, Magyarország (Drainage)
  2. Adda River
    Adda River, Lodi, Lombardia, Italia (Drainage)

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

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

        
0.038 seconds ⌛

{
  "query": {
    "bool": {
      "must": [
        {
          "geo_shape": {
            "geometry": {
              "shape": {
                "type": "circle",
                "radius": "1km",
                "coordinates": [
                  9.7496,
                  45.386719
                ]
              }
            }
          }
        },
        {
          "term": {
            "woe:placetype": 15
          }
        }
      ],
      "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"
      }
    }
  ]
}