5

I used to have no problem importing kmls to fusion tables and making lots of great maps but now it only brings in three columns - name, description and geography. The remaining attributes show up when a feature is clicked on but you can't make any map setting/theme changes based on any of them and they don't show up in table view. Table view appears to be restricted to name, description and geography. I've tried with multiple datasets.

Is anyone else having this issue.

Odi
  • 6,916
  • 3
  • 34
  • 52
user1803636
  • 51
  • 2

2 Answers2

1

If you use <Schema> and <SchemaData> elements in your KML then Google Fusion tables will import those as columns.

<ExtendedData>                   
  <SchemaData schemaUrl="anyURI">
    <SimpleData name=""> ... </SimpleData>
  </SchemaData>
</ExtendedData>

Likewise, if you use <Data> in ExtendedData for your metadata then that also is imported as columns in the import.

<ExtendedData>                       
  <Data name="string">
    <value>...</value>
  </Data>
</ExtendedData>

See related tutorial with examples:
https://developers.google.com/kml/documentation/extendeddata

CodeMonkey
  • 22,825
  • 4
  • 35
  • 75
0

I've had this issue with attributes that didn't appear in the first couple of Placemarks in the KML document.

The workaround was to either re-arrange the placemarks, or to add the missing attributes with some default value to all placemarks.

No difference if you use Data or SchemaData.

ejain
  • 3,456
  • 2
  • 34
  • 52