6 places near Frétoy-le-Château, Oise, Picardie, France
filter by placetype:
  1. Ercheu
    Ercheu, Somme, Picardie, France (LocalAdmin)
  2. Campagne
    Campagne, Oise, Picardie, France (LocalAdmin)
  3. Fréniches
    Fréniches, Oise, Picardie, France (LocalAdmin)
  4. Frétoy-le-Château
    Frétoy-le-Château, Oise, Picardie, France (LocalAdmin)
  5. Libermont
    Libermont, Oise, Picardie, France (LocalAdmin)
  6. Muirancourt
    Muirancourt, Oise, Picardie, France (LocalAdmin)

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

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

        
0.077 seconds ⌛

{
  "query": {
    "bool": {
      "must": [
        {
          "geo_shape": {
            "geometry": {
              "shape": {
                "type": "circle",
                "radius": "1km",
                "coordinates": [
                  2.97234,
                  49.66119
                ]
              }
            }
          }
        },
        {
          "term": {
            "woe:placetype": 10
          }
        }
      ],
      "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"
      }
    }
  ]
}