19 places near Saint-Étienne-Roilaye, Oise, Picardie, France
  1. Pierrefonds
    Pierrefonds, Oise, Picardie, France (Town)
  2. Saint-Étienne-Roilaye
    Saint-Étienne-Roilaye, Oise, Picardie, France (Town)
  3. Roilaye
    Roilaye, Oise, Picardie, France (Town)
  4. Seine River
    Seine River, Seine-St.-Denis, Île-de-France, France (Drainage)
  5. Chelles
    Chelles, Oise, Picardie, France (LocalAdmin)
  6. Pierrefonds
    Pierrefonds, Oise, Picardie, France (LocalAdmin)
  7. Saint-Étienne-Roilaye
    Saint-Étienne-Roilaye, Oise, Picardie, France (LocalAdmin)
  8. Calf Islands
    Calf Islands, Cork, Ireland (Island)
  9. Oise
    Oise, Picardie, France (County)
  10. Aisne
    Aisne, Picardie, France (County)

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

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

        
0.03 seconds ⌛

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