13 places near Manjakandriana, Antananarivo, Madagascar
filter by placetype:
  1. Madagascar
    Madagascar, Madagascar (Island)
  2. Manjakandriana
    Manjakandriana, Antananarivo, Madagascar (County)
  3. Indian/Antananarivo
    Indian/Antananarivo (Timezone)
  4. Indian/Kerguelen
    Indian/Kerguelen (Timezone)
  5. Eastern
    Eastern, Eastern, Fiji (State)
  6. Mahajanga
    Mahajanga, Mahajanga, Madagascar (State)
  7. Toamasina
    Toamasina, Toamasina, Madagascar (State)
  8. Antananarivo
    Antananarivo, Antananarivo, Madagascar (State)
  9. Madagascar
    Madagascar, Madagascar (Country)
  10. Indian Ocean
    Indian Ocean (Ocean)

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

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

        
0.017 seconds ⌛

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