15 places near Tsarahonenana, Befandriana Avaratra, Mahajanga, Madagascar
filter by placetype:
  1. Tsarahonenana
    Tsarahonenana, Befandriana Avaratra, Mahajanga, Madagascar (Town)
  2. Madagascar
    Madagascar, Madagascar (Island)
  3. Befandriana Avaratra
    Befandriana Avaratra, Mahajanga, Madagascar (County)
  4. Mandritsara
    Mandritsara, Mahajanga, Madagascar (County)
  5. Antsohihy
    Antsohihy, Mahajanga, 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. Toamasina
    Toamasina, Toamasina, Madagascar (State)

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

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

        
0.025 seconds ⌛

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