Vjylku

What does the "3am" section means in manpages?

Giant Toughroad SLR 2 for 200 miles in two days, will it make it?

Have I saved too much for retirement so far?

Female=gender counterpart?

Why does this part of the Space Shuttle launch pad seem to be floating in air?

Perfect riffle shuffles

Should my PhD thesis be submitted under my legal name?

Are Warlocks Arcane or Divine?

How to prevent YouTube from showing already watched videos?

Can somebody explain Brexit in a few child-proof sentences?

The One-Electron Universe postulate is true - what simple change can I make to change the whole universe?

What (else) happened July 1st 1858 in London?

Would it be legal for a US State to ban exports of a natural resource?

Can a Gentile theist be saved?

Does "Dominei" mean something?

Simulating a probability of 1 of 2^N with less than N random bits

Simple image editor tool to draw a simple box/rectangle in an existing image

Why is delta-v is the most useful quantity for planning space travel?

Can the harmonic series explain the origin of the major scale?

Adding empty element to declared container without declaring type of element

How to deal with or prevent idle in the test team?

"lassen" in meaning "sich fassen"

Can the electrostatic force be infinite in magnitude?

Can I create an upright 7-foot × 5-foot wall with the Minor Illusion spell?

Exporting time series of multiple polygons to .csv

time series NDVI - Modis products - GEEAutomatically exporting time series of multiple polygons to .csvExporting time series of multiple polygons to .csv without using ui.Chart.image.seriesByRegion commandMonthly GIMMS NDVI time seriesExporting time series of multiple polygons to .csv. format tableExtract seasonality and trend values for each time in a MODIS time seriesCreate time series and export it to csv GEEExporting Polygons (RGB color bands) nto CSVRegarding Time Series analysis in earth engine

2

I defined (by drawing) a significant number of polygons and need to export the time series of the average values inside each one. Following this example, that allows to display charts for each region, how can I export the data to a .csv? Ideally I will have in the first row the names of the regions.

// Define a FeatureCollection: regions of the American West.

var regions = ee.FeatureCollection([

  ee.Feature(    // San Francisco.

    ee.Geometry.Rectangle(-122.45, 37.74, -122.4, 37.8), {label: 'City'}),

  ee.Feature(  // Tahoe National Forest.

    ee.Geometry.Rectangle(-121, 39.4, -120.8, 39.8), {label: 'Forest'}),

  ee.Feature(  // Black Rock Desert.

    ee.Geometry.Rectangle(-119.15, 40.8, -119, 41), {label: 'Desert'})

]);



// Load Landsat 8 brightness temperature data for 1 year.

var temps2013 = ee.ImageCollection('LANDSAT/LC8_L1T_32DAY_TOA')

    .filterDate('2012-12-25', '2013-12-25')

    .select('B11');



// Create a time series chart.

var tempTimeSeries = ui.Chart.image.seriesByRegion(

    temps2013, regions, ee.Reducer.mean(), 'B11', 200, 'system:time_start', 'label')

        .setChartType('ScatterChart')

        .setOptions({

          title: 'Temperature over time in regions of the American West',

          vAxis: {title: 'Temperature (Kelvin)'},

          lineWidth: 1,

          pointSize: 4,

          series: {

            0: {color: 'FF0000'}, // urban

            1: {color: '00FF00'}, // forest

            2: {color: '0000FF'}  // desert

}});



// Display.

print(tempTimeSeries);

google-earth-engine

share|improve this question

edited Aug 9 '17 at 8:24

Kersten

7,33332446

asked Aug 8 '17 at 3:42

RaimundoRaimundo

78111

add a comment | 

2

I defined (by drawing) a significant number of polygons and need to export the time series of the average values inside each one. Following this example, that allows to display charts for each region, how can I export the data to a .csv? Ideally I will have in the first row the names of the regions.

// Define a FeatureCollection: regions of the American West.

var regions = ee.FeatureCollection([

  ee.Feature(    // San Francisco.

    ee.Geometry.Rectangle(-122.45, 37.74, -122.4, 37.8), {label: 'City'}),

  ee.Feature(  // Tahoe National Forest.

    ee.Geometry.Rectangle(-121, 39.4, -120.8, 39.8), {label: 'Forest'}),

  ee.Feature(  // Black Rock Desert.

    ee.Geometry.Rectangle(-119.15, 40.8, -119, 41), {label: 'Desert'})

]);



// Load Landsat 8 brightness temperature data for 1 year.

var temps2013 = ee.ImageCollection('LANDSAT/LC8_L1T_32DAY_TOA')

    .filterDate('2012-12-25', '2013-12-25')

    .select('B11');



// Create a time series chart.

var tempTimeSeries = ui.Chart.image.seriesByRegion(

    temps2013, regions, ee.Reducer.mean(), 'B11', 200, 'system:time_start', 'label')

        .setChartType('ScatterChart')

        .setOptions({

          title: 'Temperature over time in regions of the American West',

          vAxis: {title: 'Temperature (Kelvin)'},

          lineWidth: 1,

          pointSize: 4,

          series: {

            0: {color: 'FF0000'}, // urban

            1: {color: '00FF00'}, // forest

            2: {color: '0000FF'}  // desert

}});



// Display.

print(tempTimeSeries);

google-earth-engine

share|improve this question

edited Aug 9 '17 at 8:24

Kersten

7,33332446

asked Aug 8 '17 at 3:42

RaimundoRaimundo

78111

add a comment | 

I defined (by drawing) a significant number of polygons and need to export the time series of the average values inside each one. Following this example, that allows to display charts for each region, how can I export the data to a .csv? Ideally I will have in the first row the names of the regions.

// Define a FeatureCollection: regions of the American West.

var regions = ee.FeatureCollection([

  ee.Feature(    // San Francisco.

    ee.Geometry.Rectangle(-122.45, 37.74, -122.4, 37.8), {label: 'City'}),

  ee.Feature(  // Tahoe National Forest.

    ee.Geometry.Rectangle(-121, 39.4, -120.8, 39.8), {label: 'Forest'}),

  ee.Feature(  // Black Rock Desert.

    ee.Geometry.Rectangle(-119.15, 40.8, -119, 41), {label: 'Desert'})

]);



// Load Landsat 8 brightness temperature data for 1 year.

var temps2013 = ee.ImageCollection('LANDSAT/LC8_L1T_32DAY_TOA')

    .filterDate('2012-12-25', '2013-12-25')

    .select('B11');



// Create a time series chart.

var tempTimeSeries = ui.Chart.image.seriesByRegion(

    temps2013, regions, ee.Reducer.mean(), 'B11', 200, 'system:time_start', 'label')

        .setChartType('ScatterChart')

        .setOptions({

          title: 'Temperature over time in regions of the American West',

          vAxis: {title: 'Temperature (Kelvin)'},

          lineWidth: 1,

          pointSize: 4,

          series: {

            0: {color: 'FF0000'}, // urban

            1: {color: '00FF00'}, // forest

            2: {color: '0000FF'}  // desert

}});



// Display.

print(tempTimeSeries);

google-earth-engine

share|improve this question

edited Aug 9 '17 at 8:24

Kersten

7,33332446

asked Aug 8 '17 at 3:42

RaimundoRaimundo

78111

// Define a FeatureCollection: regions of the American West.

var regions = ee.FeatureCollection([

  ee.Feature(    // San Francisco.

    ee.Geometry.Rectangle(-122.45, 37.74, -122.4, 37.8), {label: 'City'}),

  ee.Feature(  // Tahoe National Forest.

    ee.Geometry.Rectangle(-121, 39.4, -120.8, 39.8), {label: 'Forest'}),

  ee.Feature(  // Black Rock Desert.

    ee.Geometry.Rectangle(-119.15, 40.8, -119, 41), {label: 'Desert'})

]);



// Load Landsat 8 brightness temperature data for 1 year.

var temps2013 = ee.ImageCollection('LANDSAT/LC8_L1T_32DAY_TOA')

    .filterDate('2012-12-25', '2013-12-25')

    .select('B11');



// Create a time series chart.

var tempTimeSeries = ui.Chart.image.seriesByRegion(

    temps2013, regions, ee.Reducer.mean(), 'B11', 200, 'system:time_start', 'label')

        .setChartType('ScatterChart')

        .setOptions({

          title: 'Temperature over time in regions of the American West',

          vAxis: {title: 'Temperature (Kelvin)'},

          lineWidth: 1,

          pointSize: 4,

          series: {

            0: {color: 'FF0000'}, // urban

            1: {color: '00FF00'}, // forest

            2: {color: '0000FF'}  // desert

}});



// Display.

print(tempTimeSeries);

share|improve this question

edited Aug 9 '17 at 8:24

Kersten

7,33332446

asked Aug 8 '17 at 3:42

RaimundoRaimundo

78111

share|improve this question

edited Aug 9 '17 at 8:24

Kersten

7,33332446

asked Aug 8 '17 at 3:42

RaimundoRaimundo

78111

edited Aug 9 '17 at 8:24

Kersten

7,33332446

edited Aug 9 '17 at 8:24

Kersten

7,33332446

asked Aug 8 '17 at 3:42

RaimundoRaimundo

78111

asked Aug 8 '17 at 3:42

RaimundoRaimundo

78111

2 Answers
2

active

oldest

votes

1

After printing the chart to the console tab:

1. In the console tab, click on the "enlarge icon" to display the chart in a full window.


2. In the full window, click on "Download CSV"

The first row of the resulting CSV file includes the names of the regions.

system:time_start,City,Forest,Desert

"Apr 7, 2013",297.119,273.622,286.196

"May 9, 2013",300.654,299.472,275.405

"Jun 10, 2013",287.004,300.091,320.261

"Jul 12, 2013",286.198,298.332,315.787

"Aug 13, 2013",307.255,295.935,311.532

"Sep 14, 2013",291.677,276.471,294.359

"Oct 16, 2013",285.385,283.333,279.032

"Nov 17, 2013",282.925,273.038,264.722

"Dec 19, 2013",286.648,277.89,256.074

share|improve this answer

answered Aug 8 '17 at 5:31

Tyler EricksonTyler Erickson

2,974716

add a comment | 

0

Instead of cart use ToDrive for exporting as CSV

Export.table.toDrive({
collection: table1,
description: 'this file is time series',
fileNamePrefix: 'this is discription',
fileFormat: 'CSV'
});

share

answered 2 mins ago

moeen zoharymoeen zohary

252

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "79"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f251319%2fexporting-time-series-of-multiple-polygons-to-csv%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

1

After printing the chart to the console tab:

1. In the console tab, click on the "enlarge icon" to display the chart in a full window.


2. In the full window, click on "Download CSV"

The first row of the resulting CSV file includes the names of the regions.

system:time_start,City,Forest,Desert

"Apr 7, 2013",297.119,273.622,286.196

"May 9, 2013",300.654,299.472,275.405

"Jun 10, 2013",287.004,300.091,320.261

"Jul 12, 2013",286.198,298.332,315.787

"Aug 13, 2013",307.255,295.935,311.532

"Sep 14, 2013",291.677,276.471,294.359

"Oct 16, 2013",285.385,283.333,279.032

"Nov 17, 2013",282.925,273.038,264.722

"Dec 19, 2013",286.648,277.89,256.074

share|improve this answer

answered Aug 8 '17 at 5:31

Tyler EricksonTyler Erickson

2,974716

add a comment | 

1

After printing the chart to the console tab:

1. In the console tab, click on the "enlarge icon" to display the chart in a full window.


2. In the full window, click on "Download CSV"

The first row of the resulting CSV file includes the names of the regions.

system:time_start,City,Forest,Desert

"Apr 7, 2013",297.119,273.622,286.196

"May 9, 2013",300.654,299.472,275.405

"Jun 10, 2013",287.004,300.091,320.261

"Jul 12, 2013",286.198,298.332,315.787

"Aug 13, 2013",307.255,295.935,311.532

"Sep 14, 2013",291.677,276.471,294.359

"Oct 16, 2013",285.385,283.333,279.032

"Nov 17, 2013",282.925,273.038,264.722

"Dec 19, 2013",286.648,277.89,256.074

share|improve this answer

answered Aug 8 '17 at 5:31

Tyler EricksonTyler Erickson

2,974716

add a comment | 

After printing the chart to the console tab:

1. In the console tab, click on the "enlarge icon" to display the chart in a full window.


2. In the full window, click on "Download CSV"

The first row of the resulting CSV file includes the names of the regions.

system:time_start,City,Forest,Desert

"Apr 7, 2013",297.119,273.622,286.196

"May 9, 2013",300.654,299.472,275.405

"Jun 10, 2013",287.004,300.091,320.261

"Jul 12, 2013",286.198,298.332,315.787

"Aug 13, 2013",307.255,295.935,311.532

"Sep 14, 2013",291.677,276.471,294.359

"Oct 16, 2013",285.385,283.333,279.032

"Nov 17, 2013",282.925,273.038,264.722

"Dec 19, 2013",286.648,277.89,256.074

share|improve this answer

answered Aug 8 '17 at 5:31

Tyler EricksonTyler Erickson

2,974716

system:time_start,City,Forest,Desert

"Apr 7, 2013",297.119,273.622,286.196

"May 9, 2013",300.654,299.472,275.405

"Jun 10, 2013",287.004,300.091,320.261

"Jul 12, 2013",286.198,298.332,315.787

"Aug 13, 2013",307.255,295.935,311.532

"Sep 14, 2013",291.677,276.471,294.359

"Oct 16, 2013",285.385,283.333,279.032

"Nov 17, 2013",282.925,273.038,264.722

"Dec 19, 2013",286.648,277.89,256.074

share|improve this answer

answered Aug 8 '17 at 5:31

Tyler EricksonTyler Erickson

2,974716

answered Aug 8 '17 at 5:31

Tyler EricksonTyler Erickson

2,974716

answered Aug 8 '17 at 5:31

Tyler EricksonTyler Erickson

2,974716

0

Instead of cart use ToDrive for exporting as CSV

Export.table.toDrive({
collection: table1,
description: 'this file is time series',
fileNamePrefix: 'this is discription',
fileFormat: 'CSV'
});

share

answered 2 mins ago

moeen zoharymoeen zohary

252

add a comment | 

0

Instead of cart use ToDrive for exporting as CSV

Export.table.toDrive({
collection: table1,
description: 'this file is time series',
fileNamePrefix: 'this is discription',
fileFormat: 'CSV'
});

share

answered 2 mins ago

moeen zoharymoeen zohary

252

add a comment | 

Instead of cart use ToDrive for exporting as CSV

Export.table.toDrive({
collection: table1,
description: 'this file is time series',
fileNamePrefix: 'this is discription',
fileFormat: 'CSV'
});

share

answered 2 mins ago

moeen zoharymoeen zohary

252

share

answered 2 mins ago

moeen zoharymoeen zohary

252

answered 2 mins ago

moeen zoharymoeen zohary

252

answered 2 mins ago

moeen zoharymoeen zohary

252