6 places near Stazione di Madignano, Cremona, Lombardia, Italia
filter by placetype:
  1. Crema
    Crema, Cremona, Lombardia, Italia (Town)
  2. Izano
    Izano, Cremona, Lombardia, Italia (Town)
  3. Madignano
    Madignano, Cremona, Lombardia, Italia (Town)
  4. Ripalta Vecchia
    Ripalta Vecchia, Cremona, Lombardia, Italia (Town)
  5. San Bernardino
    San Bernardino, Cremona, Lombardia, Italia (Town)
  6. Vergonzana
    Vergonzana, Cremona, Lombardia, Italia (Town)

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

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

        
0.058 seconds ⌛

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