15 places near Valabetokana, Faratsiho, Antananarivo, Madagascar
filter by placetype:
  1. Valabetokana
    Valabetokana, Faratsiho, Antananarivo, Madagascar (Town)
  2. Madagascar
    Madagascar, Madagascar (Island)
  3. Faratsiho
    Faratsiho, Antananarivo, Madagascar (County)
  4. Betafo
    Betafo, Antananarivo, Madagascar (County)
  5. Soavinandriana
    Soavinandriana, Antananarivo, Madagascar (County)
  6. Indian/Antananarivo
    Indian/Antananarivo (Timezone)
  7. Indian/Kerguelen
    Indian/Kerguelen (Timezone)
  8. Eastern
    Eastern, Eastern, Fiji (State)
  9. Antananarivo
    Antananarivo, Antananarivo, Madagascar (State)
  10. Toliara
    Toliara, Toliara, Madagascar (State)

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

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

        
0.028 seconds ⌛

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