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

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

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

        
0.037 seconds ⌛

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