6 places near Crespiatica, Lodi, Lombardia, Italia
filter by placetype:
  1. Bagnolo Cremasco
    Bagnolo Cremasco, Cremona, Lombardia, Italia (LocalAdmin)
  2. Crespiatica
    Crespiatica, Lodi, Lombardia, Italia (LocalAdmin)
  3. Dovera
    Dovera, Cremona, Lombardia, Italia (LocalAdmin)
  4. Vaiano Cremasco
    Vaiano Cremasco, Cremona, Lombardia, Italia (LocalAdmin)
  5. Corte Palasio
    Corte Palasio, Lodi, Lombardia, Italia (LocalAdmin)
  6. Abbadia Cerreto
    Abbadia Cerreto, Lodi, Lombardia, Italia (LocalAdmin)

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

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

        
0.027 seconds ⌛

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