17 places near 常州市, 常州市, 江苏省, 中國
filter by placetype:
  1. 常州
    常州, 常州市, 江苏省, 中國 (Town)
  2. Yangtze River
    Yangtze River, 中國 (Drainage)
  3. 常州市
    常州市, 常州市, 江苏省, 中國 (LocalAdmin)
  4. 武进区
    武进区, 常州市, 江苏省, 中國 (LocalAdmin)
  5. 镇 江市
    镇 江市, 江苏省, 中國 (County)
  6. 苏州市
    苏州市, 江苏省, 中國 (County)
  7. 无锡市
    无锡市, 江苏省, 中國 (County)
  8. 常州市
    常州市, 江苏省, 中國 (County)
  9. Asia/Shanghai
    Asia/Shanghai, 中國 (Timezone)
  10. 江苏省
    江苏省, 江苏省, 中國 (State)

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

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

        
0.019 seconds ⌛

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