37 places near Sgarbina, Pavia, Lombardia, Italia
  1. Casteggio
    Casteggio, Pavia, Lombardia, Italia (Town)
  2. Montebello della Battaglia
    Montebello della Battaglia, Pavia, Lombardia, Italia (Town)
  3. Crotesi
    Crotesi, Pavia, Lombardia, Italia (Town)
  4. Olesi
    Olesi, Pavia, Lombardia, Italia (Town)
  5. Rivazza
    Rivazza, Pavia, Lombardia, Italia (Town)
  6. Sgarbina
    Sgarbina, Pavia, Lombardia, Italia (Town)
  7. Barbieri
    Barbieri, Pavia, Lombardia, Italia (Town)
  8. Ravadazzo
    Ravadazzo, Pavia, Lombardia, Italia (Town)
  9. Cascina Sgarbina
    Cascina Sgarbina, Pavia, Lombardia, Italia (Town)
  10. Cascina Costaiola
    Cascina Costaiola, Pavia, Lombardia, Italia (Town)

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

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

        
0.024 seconds ⌛

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