GEE學習筆記 五十一：Fusion Table将在2019年12月3日關閉

由于在知乎專欄上發表GEE的文章被警告過政治态度有問題，是以暫時更新的内容放在CSDN上，後續有可能會回到知乎上繼續更新專欄内容。

關于GEE更多的文章可以參考我在知乎的專欄：https://zhuanlan.zhihu.com/c_123993183

目前的文章更新會在這裡暫時更新。

剛剛看到的一則消息，Google運作了9年之久的Fusion Table将在2019年12月3日關閉相關服務，同時也就是未來Google Earth Engine（GEE）上将不會存在Fusion Table這一資料，GEE官方也不再建議使用者使用Fusion Table資料。

目前在GEE上依然可以使用Fusion Table，但是GEE官方建議使用者将資料轉換為Assets方式上傳到GEE上使用。轉換導出的代碼非常簡單，這裡需要注意的是導出到Asset需要的時間可能會比導出到Drive時間要久一些，這其中應該涉及到了資料轉換的過程，是以大家需要等待一下。

這是導出目前比較流行的矢量邊界資料的一個例子：

var countries = ee.FeatureCollection("ft:1tdSwUL7MVpOauSgRzqVTOwdfy17KDbw-1d9omPw");
var taiwan = countries.filter(ee.Filter.eq("Country", "Taiwan"));
Map.addLayer(taiwan, {color: "red"}, "taiwan");
Map.centerObject(taiwan, 6);

//導出需要差不多7分鐘。優點是友善不需要在重新上傳矢量檔案，缺點是速度慢
Export.table.toAsset({
  collection: taiwan,
  description: "taiwan",
  assetId: "taiwan"
});

//導出差不多需要20秒。優點是導出速度快，缺點是需要重新向Asset上傳矢量檔案
Export.table.toDrive({
  collection: taiwan,
  description: "Drive-taiwan",
  fileNamePrefix: "taiwan",
  fileFormat: "SHP"
});
           

Google Fusion Tables關閉的相關通知位址：

https://support.google.com/fusiontables/answer/9185417

具體内容如下：

Notice: Google Fusion Tables Turndown

Last updated: December 11, 2018

Google Fusion Tables and the Fusion Tables API will be turned down December 3, 2019. Embedded Fusion Tables visualizations — maps, charts, tables and cards — will also stop working that day. Maps using the Fusion Tables Layer in the Maps JavaScript API v3.37 will start to see errors in August 2019.

Explore these Google tools

Fusion Tables was launched almost nine years ago as a research project in Google Labs, later evolving into an experimental product. For a long time, it was one of the few free tools for easily visualizing large datasets, especially on a map. Since then, several Google alternatives have been developed, providing deeper experiences in more specialized domains.

• Google BigQuery – Fast, highly scalable, cost-effective, and fully managed cloud data warehouse for analytics, with built-in machine learning. With BigQuery GIS (beta), you can easily analyze and visualize geospatial data in BigQuery.
• Google Cloud SQL – Fully-managed database service that makes it easy to set up, maintain, manage, and administer your relational MySQL and PostgreSQL databases in the cloud. See this example: Using MySQL and PHP with Google Maps.
• Google Sheets – Your Fusion Tables can be imported into Google Sheets. Sheets provides excellent filtering and scripting features, and an API similar to that of Fusion Tables. In addition to its own charting/visualization functionality, Sheets may be used as a data source in visualization products like Google Data Studio.
• Google Data Studio – Data Studio is Google’s free-to-use business intelligence tool. It lets you visualize and interactively explore data in compelling dashboards or reports, easily share and publish insights, and collaborate in real-time with colleagues. You can easily access and analyze data from 500+ sources including BigQuery and Sheets, with a GUI for producing map visualizations and charts.
• Coming soon – Teams at Google have developed internal tools that can create powerful map visualizations. We are working to make some of these tools publicly available and will have more to share in the coming months—sign up to stay in touch.  

Download your data

You can access your tables in Google Drive by filtering by “type:table”. Download data from a table by following these instructions, and then consider migrating that data to one of the tools listed above. If you have a lot of tables, we will make it easy to download all your data in one step via Google Takeout starting in March 2019.