22 places near Marina East, South East, Singapore
filter by placetype:
  1. Marine Parade
    Marine Parade, South East, Singapore (Town)
  2. Marina East
    Marina East, South East, Singapore (Town)
  3. Katong
    Katong, South East, Singapore (Town)
  4. Tanjong Rhu
    Tanjong Rhu, South East, Singapore (Town)
  5. Sumatra
    Sumatra, Republik Indonesia (Island)
  6. Riau Islands
    Riau Islands, Republik Indonesia (Island)
  7. Rukan Kepulauan
    Rukan Kepulauan, Kepulauan Riau, Republik Indonesia (Island)
  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.023 seconds ⌛; show me the details?

        
0.023 seconds ⌛

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