14 places near Antetezantany, Befandriana Avaratra, Mahajanga, Madagascar
filter by placetype:
  1. Antetezantany
    Antetezantany, Befandriana Avaratra, Mahajanga, Madagascar (Town)
  2. Madagascar
    Madagascar, Madagascar (Island)
  3. Bealanana
    Bealanana, Mahajanga, Madagascar (County)
  4. Befandriana Avaratra
    Befandriana Avaratra, Mahajanga, Madagascar (County)
  5. Andapa
    Andapa, Antsiranana, Madagascar (County)
  6. Indian/Antananarivo
    Indian/Antananarivo (Timezone)
  7. Indian/Kerguelen
    Indian/Kerguelen (Timezone)
  8. Antsiranana
    Antsiranana, Antsiranana, Madagascar (State)
  9. Mahajanga
    Mahajanga, Mahajanga, 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.012 seconds ⌛; show me the details?

        
0.012 seconds ⌛

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