27 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. San Rocco
    San Rocco, Cremona, Lombardia, Italia (Town)
  5. Frazione Tormo
    Frazione Tormo, Lodi, Lombardia, Italia (Town)
  6. Frazione Benzona
    Frazione Benzona, Lodi, Lombardia, Italia (Town)
  7. Donau
    Donau, Magyarország (Drainage)
  8. Adda River
    Adda River, Lodi, Lombardia, Italia (Drainage)
  9. Bagnolo Cremasco
    Bagnolo Cremasco, Cremona, Lombardia, Italia (LocalAdmin)
  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.03 seconds ⌛; show me the details?

        
0.03 seconds ⌛

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