topic Re: Display layer based on Google Fusion Tables in ArcGIS API for Silverlight Questions

Display layer based on Google Fusion Tables

KirkKuykendall — Mon, 26 Sep 2011 22:15:50 GMT

I've been asked to add a layer to a silverlight map depicting information in a Google Fusion Table, specifically this one: http://www.google.com/fusiontables/DataSource?snapid=S232942v7U3

Does anyone know an easy way to do this?

Are there any plans to provide a new layer type in future versions of the Silverlight API that would let me just config a layer using the url like I would any other mapservice layer?

Thanks,

Kirk

Re: Display layer based on Google Fusion Tables

DanielWalton — Tue, 27 Sep 2011 12:57:01 GMT

It's something you can do yourself. Just create a class that inherits GraphicsLayer, and in the overriden Initialize() method place code to download the fusion table exported as a csv file (the URL for your table is http://www.google.com/fusiontables/exporttable?query=select%20*%20from%201236296%20), parse it and create Point graphics features with whatever symbol you want. The 'geometry' column is XML formatted according to the KML <Geometry> spec.

Re: Display layer based on Google Fusion Tables

KirkKuykendall — Tue, 27 Sep 2011 13:47:11 GMT

Hey Dan -

Thanks for responding! This makes sense.

Does anyone know if Esri has exposed a method to convert Kml geometries to Esri geometries?

The KmlLayer must be doing this somewhere behind the scenes.

Kirk

Re: Display layer based on Google Fusion Tables

DanielWalton — Tue, 27 Sep 2011 13:50:42 GMT

Look here.

Re: Display layer based on Google Fusion Tables

DominiqueBroux — Tue, 27 Sep 2011 14:56:05 GMT

Does anyone know if Esri has exposed a method to convert Kml geometries to Esri geometries?

The KmlLayer must be doing this somewhere behind the scenes.

You are right the KML layer is doing that behind the scene but it's not exposed publicly.

You can get the kml sources on codeplex and extract the code converting the geometries (look at Extractxxxx methods called by KmlToFeatureDefinition.CreateFeatureDefinition)

Re: Display layer based on Google Fusion Tables

KirkKuykendall — Sat, 11 Dec 2021 22:15:14 GMT

Thanks Dominique ...

It turns out it looks like I can set KmlLayer.Url to this url:

http://www.google.com/fusiontables/exporttable?query=select+col8+from+1236296+&o=kmllink&g=col8

(Found using Fiddler and clicking download to kml from the fusion map page).

Now the only pain is converting to web mercator.

The code for the Kml sample sure will be a lot messier when Esri retires the WGS84 basemaps and replaces with web mercator.
http://help.arcgis.com/en/webapi/silverlight/samples/start.htm#KmlLayerSimple

Re: Display layer based on Google Fusion Tables

DominiqueBroux — Tue, 27 Sep 2011 16:05:16 GMT

It turns out it looks like I can set KmlLayer.Url to this url

Great idea. Much simpler 🙂

Now the only pain is converting to web mercator.

This Mortens's post should help.

Re: Display layer based on Google Fusion Tables

KirkKuykendall — Tue, 27 Sep 2011 16:15:48 GMT

Hey Dominique -

I'm aware of that strategy.

I really think 99% of the time anyone using a kmllayer will be wanting to display it in web mercator. So I think bending the no-projection-on-the-client rule makes sense in this situation.

See more discussion here:
http://forums.arcgis.com/threads/40409-Can-KmlLayer-project-to-Web-Mercator-on-the-fly

Re: Display layer based on Google Fusion Tables

DominiqueBroux — Tue, 27 Sep 2011 16:30:30 GMT

OK. I got it.
I guess with your post, this enhancement will move up in the priority list:)