26 places near Margny-aux-Cerises, Oise, Picardie, France
  1. Avricourt
    Avricourt, Oise, Picardie, France (Town)
  2. Champien
    Champien, Somme, Picardie, France (Town)
  3. Roiglise
    Roiglise, Somme, Picardie, France (Town)
  4. Solente
    Solente, Oise, Picardie, France (Town)
  5. Margny-aux-Cerises
    Margny-aux-Cerises, Oise, Picardie, France (Town)
  6. Le Pavé
    Le Pavé, Oise, Picardie, France (Town)
  7. Champien
    Champien, Somme, Picardie, France (LocalAdmin)
  8. Roiglise
    Roiglise, Somme, Picardie, France (LocalAdmin)
  9. Avricourt
    Avricourt, Oise, Picardie, France (LocalAdmin)
  10. Beaulieu-les-Fontaines
    Beaulieu-les-Fontaines, Oise, Picardie, France (LocalAdmin)

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

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

        
0.034 seconds ⌛

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