23 places near Marina, Central Singapore, Singapore
filter by placetype:
  1. Singapore
    Singapore, Central Singapore, Singapore (Town)
  2. Marina
    Marina, Central Singapore, Singapore (Town)
  3. Marina South
    Marina South, Central Singapore, Singapore (Town)
  4. Marina Centre
    Marina Centre, Central Singapore, 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.865028,
                  1.27618
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}