26 places near Crespiatica, Lodi, Lombardia, Italia
  1. Bagnolo Cremasco
    Bagnolo Cremasco, Cremona, Lombardia, Italia (Town)
  2. Crespiatica
    Crespiatica, Lodi, Lombardia, Italia (Town)
  3. Vaiano Cremasco
    Vaiano Cremasco, Cremona, Lombardia, Italia (Town)
  4. Monte Cremasco
    Monte Cremasco, Cremona, Lombardia, Italia (Town)
  5. San Rocco
    San Rocco, Cremona, Lombardia, Italia (Town)
  6. Frazione Tormo
    Frazione Tormo, Lodi, Lombardia, Italia (Town)
  7. Frazione Benzona
    Frazione Benzona, Lodi, Lombardia, Italia (Town)
  8. Donau
    Donau, Magyarország (Drainage)
  9. Adda River
    Adda River, Lodi, Lombardia, Italia (Drainage)
  10. Crespiatica
    Crespiatica, Lodi, Lombardia, Italia (LocalAdmin)

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

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

        
0.036 seconds ⌛

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