13 places near Betafo, Betafo, Antananarivo, Madagascar
filter by placetype:
  1. Betafo
    Betafo, Betafo, Antananarivo, Madagascar (Town)
  2. Madagascar
    Madagascar, Madagascar (Island)
  3. Betafo
    Betafo, Antananarivo, Madagascar (County)
  4. Indian/Antananarivo
    Indian/Antananarivo (Timezone)
  5. Indian/Kerguelen
    Indian/Kerguelen (Timezone)
  6. Eastern
    Eastern, Eastern, Fiji (State)
  7. Antananarivo
    Antananarivo, Antananarivo, Madagascar (State)
  8. Toliara
    Toliara, Toliara, 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.035 seconds ⌛; show me the details?

        
0.035 seconds ⌛

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