18 places near Macherla, Mahbubnagar, Andhra Pradesh, India
filter by placetype:
  1. Macherla
    Macherla, Mahbubnagar, Andhra Pradesh, India (Town)
  2. Balgera
    Balgera, Mahbubnagar, Andhra Pradesh, India (Town)
  3. Krishna River
    Krishna River, India (Drainage)
  4. Kurnool
    Kurnool, Andhra Pradesh, India (County)
  5. Mahbubnagar
    Mahbubnagar, Andhra Pradesh, India (County)
  6. Raichur
    Raichur, Karnataka, India (County)
  7. Asia/Kolkata
    Asia/Kolkata (Timezone)
  8. Andhra Pradesh
    Andhra Pradesh, Andhra Pradesh, India (State)
  9. Puducherry
    Puducherry, India (State)
  10. India
    India, India (Country)

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

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

        
0.026 seconds ⌛

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