23 places near Hougang, North East, Singapore
filter by placetype:
  1. Hougang
    Hougang, North East, Singapore (Town)
  2. Sengkang
    Sengkang, North East, Singapore (Town)
  3. Paya Lebar
    Paya Lebar, North East, Singapore (Town)
  4. Sumatra
    Sumatra, Republik Indonesia (Island)
  5. Riau Islands
    Riau Islands, Republik Indonesia (Island)
  6. Johor Bahru
    Johor Bahru, Johor, Malaysia (County)
  7. Kota Tinggi
    Kota Tinggi, Johor, Malaysia (County)
  8. Asia/Jakarta
    Asia/Jakarta, Republik Indonesia (Timezone)
  9. Asia/Singapore
    Asia/Singapore (Timezone)
  10. Asia/Kuala_Lumpur
    Asia/Kuala_Lumpur, Malaysia (Timezone)

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

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

        
0.027 seconds ⌛

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