11 places near Tsaratanana, Tsaratanana, Mahajanga, Madagascar
filter by placetype:
  1. Tsaratanana
    Tsaratanana, Tsaratanana, Mahajanga, Madagascar (Town)
  2. Madagascar
    Madagascar, Madagascar (Island)
  3. Tsaratanana
    Tsaratanana, Mahajanga, Madagascar (County)
  4. Indian/Antananarivo
    Indian/Antananarivo (Timezone)
  5. Indian/Kerguelen
    Indian/Kerguelen (Timezone)
  6. Mahajanga
    Mahajanga, Mahajanga, Madagascar (State)
  7. Madagascar
    Madagascar, Madagascar (Country)
  8. Indian Ocean
    Indian Ocean (Ocean)
  9. Pacific Ocean
    Pacific Ocean (Ocean)
  10. Africa
    Africa (Continent)

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": [
                  47.651581,
                  -16.79763
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}