15 places near Betatao, Anjozorobe, Antananarivo, Madagascar
filter by placetype:
  1. Betatao
    Betatao, Anjozorobe, Antananarivo, Madagascar (Town)
  2. Madagascar
    Madagascar, Madagascar (Island)
  3. Anjozorobe
    Anjozorobe, Antananarivo, Madagascar (County)
  4. Moramanga
    Moramanga, Toamasina, Madagascar (County)
  5. Indian/Antananarivo
    Indian/Antananarivo (Timezone)
  6. Indian/Kerguelen
    Indian/Kerguelen (Timezone)
  7. Eastern
    Eastern, Eastern, Fiji (State)
  8. Mahajanga
    Mahajanga, Mahajanga, Madagascar (State)
  9. Toamasina
    Toamasina, Toamasina, Madagascar (State)
  10. Antananarivo
    Antananarivo, Antananarivo, Madagascar (State)

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

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

        
0.023 seconds ⌛

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