22 places near Roye, Somme, Picardie, France
filter by placetype:
  1. Carrépuis
    Carrépuis, Somme, Picardie, France (Town)
  2. Laucourt
    Laucourt, Somme, Picardie, France (Town)
  3. Roye
    Roye, Somme, Picardie, France (Town)
  4. St.-Mard
    St.-Mard, Somme, Picardie, France (Town)
  5. Verpillières
    Verpillières, Somme, Picardie, France (Town)
  6. Laucourt
    Laucourt, Somme, Picardie, France (LocalAdmin)
  7. Roye
    Roye, Somme, Picardie, France (LocalAdmin)
  8. St.-Mard
    St.-Mard, Somme, Picardie, France (LocalAdmin)
  9. Calf Islands
    Calf Islands, Cork, Ireland (Island)
  10. Oise
    Oise, Picardie, France (County)

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

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

        
0.018 seconds ⌛

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