Selecting a field from a Fusion Table

Question

I would like to select this row (it is a polygon) from this fusion table (called CDM_areas). I am struggling with the code to select such a field...

I have so far (uncertain in bold):

var ndviclip = ndvichange.clip(CDM_areas.select('name' **= '40'**));

Answer 1

A FeatureCollection has Features with one or many properties. When you call select on a FeatureCollection you'll get the same but each Feature will keep only the properties you have indicated in the select method. See this example:

var geometry = ee.FeatureCollection(
        [ee.Feature(
            ee.Geometry.Point([-115.59062499999999, 39.72805832737948]),
            {
              "system:index": "0",
              "id": "0",
              "name": "zero"
            }),
        ee.Feature(
            ee.Geometry.Point([-104.25273437499999, 45.78644775647758]),
            {
              "system:index": "1",
              "id": "1",
              "name": "one"
            }),
        ee.Feature(
            ee.Geometry.Point([-91.50859374999999, 37.74005100886954]),
            {
              "system:index": "2",
              "id": "2",
              "name": "two"
            })]);

print(geometry.first())
print(geometry.select('name').first())

What you are looking for is to filter the FeatureCollection by name, and as you know name are unique, you get only the Feature you need.

var myfeature = ee.Feature(CDM_areas.filterMetadata('name', 'equals', 40).first()); // If it is a string column you have to quote it: '40'
var ndviclip = ndvichange.clip(myfeature);