23 places near Sperticano, Bologna, Emilia Romagna, Italia
  1. Marzabotto
    Marzabotto, Bologna, Emilia Romagna, Italia (Town)
  2. Sibano
    Sibano, Bologna, Emilia Romagna, Italia (Town)
  3. Panico
    Panico, Bologna, Emilia Romagna, Italia (Town)
  4. Pian di Venola
    Pian di Venola, Bologna, Emilia Romagna, Italia (Town)
  5. Sperticano
    Sperticano, Bologna, Emilia Romagna, Italia (Town)
  6. Donau
    Donau, Magyarország (Drainage)
  7. Sasso Marconi
    Sasso Marconi, Bologna, Emilia Romagna, Italia (LocalAdmin)
  8. Marzabotto
    Marzabotto, Bologna, Emilia Romagna, Italia (LocalAdmin)
  9. Monzuno
    Monzuno, Bologna, Emilia Romagna, Italia (LocalAdmin)
  10. Alps
    Alps (Colloquial)

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

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

        
0.042 seconds ⌛

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