14 places near Befandriana, Befandriana Avaratra, Mahajanga, Madagascar
filter by placetype:
  1. Befandriana
    Befandriana, Befandriana Avaratra, Mahajanga, Madagascar (Town)
  2. Madagascar
    Madagascar, Madagascar (Island)
  3. Befandriana Avaratra
    Befandriana Avaratra, Mahajanga, Madagascar (County)
  4. Analalava
    Analalava, Mahajanga, Madagascar (County)
  5. Indian/Antananarivo
    Indian/Antananarivo (Timezone)
  6. Indian/Kerguelen
    Indian/Kerguelen (Timezone)
  7. Antsiranana
    Antsiranana, Antsiranana, Madagascar (State)
  8. Mahajanga
    Mahajanga, Mahajanga, Madagascar (State)
  9. Toamasina
    Toamasina, Toamasina, Madagascar (State)
  10. Madagascar
    Madagascar, Madagascar (Country)

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

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

        
0.026 seconds ⌛

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