4 places near Manjakandriana, Antananarivo, Madagascar
filter by placetype:
  1. Eastern
    Eastern, Eastern, Fiji (State)
  2. Mahajanga
    Mahajanga, Mahajanga, Madagascar (State)
  3. Toamasina
    Toamasina, Toamasina, Madagascar (State)
  4. Antananarivo
    Antananarivo, Antananarivo, Madagascar (State)

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

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

        
0.012 seconds ⌛

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