19 places near 60810, Oise, Picardie, France
filter by placetype:
  1. Barbery
    Barbery, Oise, Picardie, France (Town)
  2. Brasseuse
    Brasseuse, Oise, Picardie, France (Town)
  3. Bray
    Bray, Oise, Picardie, France (Town)
  4. Seine River
    Seine River, Seine-St.-Denis, Île-de-France, France (Drainage)
  5. Barbery
    Barbery, Oise, Picardie, France (LocalAdmin)
  6. Brasseuse
    Brasseuse, Oise, Picardie, France (LocalAdmin)
  7. Rully
    Rully, Oise, Picardie, France (LocalAdmin)
  8. Calf Islands
    Calf Islands, Cork, Ireland (Island)
  9. Oise
    Oise, Picardie, France (County)
  10. Europe/Paris
    Europe/Paris (Timezone)

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

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

        
0.039 seconds ⌛

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