12 places near Mahanoro, Toamasina, Madagascar
filter by placetype:
  1. Madagascar
    Madagascar, Madagascar (Island)
  2. Mahanoro
    Mahanoro, Toamasina, Madagascar (County)
  3. Indian/Antananarivo
    Indian/Antananarivo (Timezone)
  4. Indian/Kerguelen
    Indian/Kerguelen (Timezone)
  5. Eastern
    Eastern, Eastern, Fiji (State)
  6. Fianarantsoa
    Fianarantsoa, Fianarantsoa, Madagascar (State)
  7. Toamasina
    Toamasina, Toamasina, Madagascar (State)
  8. Madagascar
    Madagascar, Madagascar (Country)
  9. Indian Ocean
    Indian Ocean (Ocean)
  10. Pacific Ocean
    Pacific Ocean (Ocean)

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

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

        
0.014 seconds ⌛

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