27 places near San Martino la Mandria, Pavia, Lombardia, Italia
  1. Pieve del Cairo
    Pieve del Cairo, Pavia, Lombardia, Italia (Town)
  2. Suardi
    Suardi, Pavia, Lombardia, Italia (Town)
  3. Cambiò
    Cambiò, Pavia, Lombardia, Italia (Town)
  4. Gambarana
    Gambarana, Pavia, Lombardia, Italia (Town)
  5. San Martino la Mandria
    San Martino la Mandria, Pavia, Lombardia, Italia (Town)
  6. Cascina Candele
    Cascina Candele, Pavia, Lombardia, Italia (Town)
  7. Donau
    Donau, Magyarország (Drainage)
  8. Po River
    Po River, Rovigo, Veneto, Italia (Drainage)
  9. Bassignana
    Bassignana, Alessandria, Piemonte, Italia (LocalAdmin)
  10. Suardi
    Suardi, Pavia, Lombardia, Italia (LocalAdmin)

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

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

        
0.012 seconds ⌛

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