20 places near 绵竹, 德阳市, 四川省, 中國
filter by placetype:
  1. 绵竹
    绵竹, 德阳市, 四川省, 中國 (Town)
  2. Yangtze River
    Yangtze River, 中國 (Drainage)
  3. Mekong River
    Mekong River, Cambodia (Drainage)
  4. 绵竹市
    绵竹市, 德阳市, 四川省, 中國 (LocalAdmin)
  5. 什邡市
    什邡市, 德阳市, 四川省, 中國 (LocalAdmin)
  6. 绵阳市
    绵阳市, 四川省, 中國 (County)
  7. 眉山市
    眉山市, 四川省, 中國 (County)
  8. 德阳市
    德阳市, 四川省, 中國 (County)
  9. 成都市
    成都市, 四川省, 中國 (County)
  10. 阿壩藏族羌族自治州
    阿壩藏族羌族自治州, 四川省, 中國 (County)

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

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

        
0.031 seconds ⌛

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