27 places near Crespiatica, Lodi, Lombardia, Italia
  1. Dovera
    Dovera, Cremona, Lombardia, Italia (LocalAdmin)
  2. Vaiano Cremasco
    Vaiano Cremasco, Cremona, Lombardia, Italia (LocalAdmin)
  3. Corte Palasio
    Corte Palasio, Lodi, Lombardia, Italia (LocalAdmin)
  4. Abbadia Cerreto
    Abbadia Cerreto, Lodi, Lombardia, Italia (LocalAdmin)
  5. Alps
    Alps (Colloquial)
  6. Cremona
    Cremona, Lombardia, Italia (County)
  7. Lodi
    Lodi, Lombardia, Italia (County)
  8. Europe/Rome
    Europe/Rome (Timezone)
  9. Lombardia
    Lombardia, Italia (State)
  10. Italia
    Italia, Italia (Country)

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

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

        
0.045 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"
      }
    }
  ],
  "from": 10
}