Google Maps Fusion图层忽略WHERE子句

Question

我有一个问题，让我的融合表层中的where子句实际上做任何事情。

下面应该做的是从我的fusion表中选择'income‘大于100的所有行(或者，如果您在where子句中交换了代码，则选择一个特定的geom (MSOA) )。

融合表列average_income是类型Number，MSOA11CD是类型Text。

这里有一个老问题，它是关于同一主题的，但通过一个我没有的语法错误得到了解决。"WHERE" clauses being ignored in Fusion Table Layer in Google Maps

小提琴在这里：http://jsfiddle.net/dqthnw7s/

layer = new google.maps.FusionTablesLayer({
    map: map,
    heatmap: {
        enabled: false
    },
    query: {
        select: "*",
        from: "1QEMdQUSmsdEZs9vAchHeKPG_CsKa7L0zW0SBJSCu",
        where: "average_income > 100",
        //tried this too
        //where: 'MSOA11CD = \'E02004590\''

    },
    styles: [{
       where: "average_income > 1000",
        polygonOptions: {
            fillColor: '#002951'
        }
    }, {
        where: "average_income > 800 AND average_income <= 1000",
        polygonOptions: {
            fillColor: '#003466'
        }
    }, {
        where: 'average_income > 100 AND average_income <= 800',
        polygonOptions: {
            fillColor: '#376798'
        }
    }]
});

融合表：https://www.google.com/fusiontables/DataSource?docid=1QEMdQUSmsdEZs9vAchHeKPG_CsKa7L0zW0SBJSCu#rows:id=1

任何帮助都将不胜感激！

Answer 1

选择"*“无效。这需要是一个“几何”列。

layer = new google.maps.FusionTablesLayer({
    map: map,
    heatmap: {
        enabled: false
    },
    query: {
        select: "geometry",
        from: "1QEMdQUSmsdEZs9vAchHeKPG_CsKa7L0zW0SBJSCu",
        where: "average_income > 100",
        //tried this too
        //where: 'MSOA_CODE = \'E02004590\''

    },
    styles: [{
       where: "average_income > 1000",
        polygonOptions: {
            fillColor: '#002951'
        }
    }, {
        where: "average_income > 800 AND average_income <= 1000",
        polygonOptions: {
            fillColor: '#003466'
        }
    }, {
        where: 'average_income > 100 AND average_income <= 800',
        polygonOptions: {
            fillColor: '#376798'
        }
    }]
});

updated fiddle