Google地图上的Fusion Tables v2 POI：Android示例？(Fusion Tables v2 POIs on Google Maps: Android example?)

 我正在寻找一个关于如何在谷歌地图上显示兴趣点（保存在融合表中）的示例。 
 
 要在html和javascript中做到这一点，这是相当微不足道的，检查我的JavaScript地图与融合表的例子 
 
 请参阅包含我的POI的Fusion Tables页面 
 
 我的目标/问题是如何（在编码时需要帮助）在Android应用程序中实现相同目标。 我对android开发很陌生，并且我已经投入了数小时的基础知识并检查文档和示例。 
 
 检查这个非常好的谷歌地图示例Android我已经发现开始（我的测试应用程序是基于此代码）。 
 
 Fusion Tables v2参考 （指向google api客户端） 
 
 github上的Google API Java客户端示例 （大多数过时：v1上的示例） 
 
 到目前为止，我已经实现了显示以我最后一个已知位置为中心的地图并在其上显示标记。 
 
 因为我找不到这方面的好例子，所以我决定发布并分享我的发现，请参阅： github上的firepol / android-google-maps-fusion-tables 
 
 现在我想显示来自融合表的标记。 我被困在执行请求，我试图通过谷歌API客户端。 
 
 适用于Android的Google API客户端示例 
 
ActivityFeed feed = listActivities.execute();
 
 在这里我的代码（我把它放在onCreate中）： 
 
protected void prepareFusion() {
    // Normally READONLY should be enough (see credential with one scope), but I checked online a console
    // and I could see a public table only if I would grant both permissions
    List<String> scopes = new ArrayList<>(Arrays.asList(FusiontablesScopes.FUSIONTABLES, FusiontablesScopes.FUSIONTABLES_READONLY));
    credential = GoogleAccountCredential.usingOAuth2(this, scopes);
    //credential = GoogleAccountCredential.usingOAuth2(this, Collections.singleton(FusiontablesScopes.FUSIONTABLES_READONLY));

    // TODO : get account name automatically
    // http://stackoverflow.com/questions/35789071/getting-the-gmail-id-of-the-user-in-android-6-0-marshmallow
    credential.setSelectedAccountName("YOUR_GOOGLE_ACCOUNT");

    client = new Fusiontables.Builder(
            transport, jsonFactory, credential).setApplicationName("TestMap/1.0")
            .build();

    try {
        String tableId = "1774o_WcrqSQlepLXlz1kgH_01NpCJ-6OyId9Pm1J";

        Fusiontables.Query.Sql sql = client.query().sql("SELECT FileName,Name,Location FROM " + tableId);
        //sql.execute();
        //java.lang.IllegalStateException: Calling this from your main thread can lead to deadlock

        Fusiontables.Table.Get table = client.table().get(tableId);
        table.setFields("items(FileName,Name,Location)");
        //table.execute();

        // TODO : can't execute like this on main thread as the documentation example "suggests"
        //https://developers.google.com/api-client-library/java/google-api-java-client/android

    } catch (IOException e) {
        e.printStackTrace();
    }
}
 
 如果我尝试做同样的事情，并调用sql.execute（）或table.execute（），我会得到： 
 
 
 
 java.lang.IllegalStateException：从你的主线程调用这个会导致死锁 
 
 
 所以我有点卡在这里，我想知道如何从有经验的谷歌API客户端开始，如果你能帮助我在地图上得到结果更好！ 谢谢。 
 
 如何在地图上显示融合表POI？ 
 
@Override
public void onMapReady(GoogleMap googleMap) {
    mMap = googleMap;

    // Add a marker to Zurich Oerlikon and move the camera
    mMap.addMarker(new MarkerOptions().position(mDefaultLatLng).title("Zurich Oerlikon"));
    mMap.animateCamera(CameraUpdateFactory.newLatLngZoom(
            mDefaultLatLng, 13));

    // TODO: add fusion tables POIs
}
 
 要查看我卡在哪里并帮助我，请在github 上将我的github repo firepol / android-google-maps-fusion-tables克隆，在Android Studio中打开它，添加您自己的Google Maps API密钥并在设备上进行调试。 感谢您的建设性意见，答案和帮助。 随意推动Github以及。 

I'm looking for an example on how to display points of interest (saved in fusion tables) on a google map.
 
To do this in html and javascript it's quite trivial, check my javascript map with fusion tables example
 
See Fusion Tables page containing my POIs
 
My goal/question is how (need help in coding it) to achieve the same in an Android app. I'm new to android development and I already invested hours for the basics and checking documentation and examples.
 
Check this very good Google Maps example for Android I've found to get started (my test app is based on this code).
 
Fusion Tables v2 reference (points to google api client)
 
Google API Java client samples on github (most outdated: examples on v1)
 
So far I achieved to display a map centered on my last known location and to show a marker on it.
 
Because I couldn't find good examples for this, I decided to publish and share my findings, see: firepol / android-google-maps-fusion-tables on github
 
Now I'd like to show markers coming from fusion tables. I'm stuck at executing the request, which I try to do via google api client.
 
Google API client example for Android
 
ActivityFeed feed = listActivities.execute();
 
Here my code (which I've put inside onCreate):
 
protected void prepareFusion() {
    // Normally READONLY should be enough (see credential with one scope), but I checked online a console
    // and I could see a public table only if I would grant both permissions
    List<String> scopes = new ArrayList<>(Arrays.asList(FusiontablesScopes.FUSIONTABLES, FusiontablesScopes.FUSIONTABLES_READONLY));
    credential = GoogleAccountCredential.usingOAuth2(this, scopes);
    //credential = GoogleAccountCredential.usingOAuth2(this, Collections.singleton(FusiontablesScopes.FUSIONTABLES_READONLY));

    // TODO : get account name automatically
    // http://stackoverflow.com/questions/35789071/getting-the-gmail-id-of-the-user-in-android-6-0-marshmallow
    credential.setSelectedAccountName("YOUR_GOOGLE_ACCOUNT");

    client = new Fusiontables.Builder(
            transport, jsonFactory, credential).setApplicationName("TestMap/1.0")
            .build();

    try {
        String tableId = "1774o_WcrqSQlepLXlz1kgH_01NpCJ-6OyId9Pm1J";

        Fusiontables.Query.Sql sql = client.query().sql("SELECT FileName,Name,Location FROM " + tableId);
        //sql.execute();
        //java.lang.IllegalStateException: Calling this from your main thread can lead to deadlock

        Fusiontables.Table.Get table = client.table().get(tableId);
        table.setFields("items(FileName,Name,Location)");
        //table.execute();

        // TODO : can't execute like this on main thread as the documentation example "suggests"
        //https://developers.google.com/api-client-library/java/google-api-java-client/android

    } catch (IOException e) {
        e.printStackTrace();
    }
}
 
If I try to do the same and call sql.execute() or table.execute() I get:
 
 
 
java.lang.IllegalStateException: Calling this from your main thread can lead to deadlock
 
 
So I'm kinda stuck here and I'd like to know how to proceed from somebody who has experience with the google api client, even better if you can help me to get the result on the map! Thank you.
 
How to display the fusion tables POIs on the map?
 
@Override
public void onMapReady(GoogleMap googleMap) {
    mMap = googleMap;

    // Add a marker to Zurich Oerlikon and move the camera
    mMap.addMarker(new MarkerOptions().position(mDefaultLatLng).title("Zurich Oerlikon"));
    mMap.animateCamera(CameraUpdateFactory.newLatLngZoom(
            mDefaultLatLng, 13));

    // TODO: add fusion tables POIs
}
 
To see where I'm stuck and help me, clone my github repo firepol / android-google-maps-fusion-tables on github, open it in Android Studio, add your own Google Maps API Key and debug on your device. Thanks for your constructive comments, answers and help. Feel free to push on github as well.

原文：https://stackoverflow.com/questions/41912999