<div dir="ltr">Hello<div><br></div><div>I'm trying to import a KML file that has a bunch of SimpleData fields inside of  ExtendedData into mysql.</div><div><br></div><div>I've gotten the basic syntax down for importing the file, but I can't seem to get the simpledata fileds to transfer over.</div><div><br></div><div>Here's an example.  I don't really need all the fields -- I'm only really interested in storing the polygon and the GEOID10 field, but I can manipulate the database to remove them later easily enough.</div><div><br></div><div><div><span class="" style="white-space:pre">       </span><Placemark></div><div><span class="" style="white-space:pre">                  </span><styleUrl>#falseColor0</styleUrl></div><div><span class="" style="white-space:pre">                      </span><ExtendedData></div><div><span class="" style="white-space:pre">                               </span><SchemaData schemaUrl="#S_tl_2015_26_tabblock10_SSSSSSSS</div><div>SSSDDSS"></div><div><span class="" style="white-space:pre">                                   </span><SimpleData name="STATEFP10">13</SimpleData></div><div><span class="" style="white-space:pre">                                 </span><SimpleData name="COUNTYFP10">131</SimpleData></div><div><span class="" style="white-space:pre">                                       </span><SimpleData name="TRACTCE10">970100</SimpleData></div><div><span class="" style="white-space:pre">                                     </span><SimpleData name="BLOCKCE10">1125</SimpleData></div><div><span class="" style="white-space:pre">                                       </span><SimpleData name="GEOID10">131319701001125</Simp</div><div>leData></div><div><span class="" style="white-space:pre">                                       </span><SimpleData name="NAME10">Block 1125</SimpleData</div><div>></div><div><span class="" style="white-space:pre">                                     </span><SimpleData name="MTFCC10">G5040</SimpleData></div><div><span class="" style="white-space:pre">                                        </span><SimpleData name="UR10">R</SimpleData></div><div><span class="" style="white-space:pre">                                       </span><SimpleData name="UACE10"></SimpleData></div><div><span class="" style="white-space:pre">                                      </span><SimpleData name="UATYPE"></SimpleData></div><div><span class="" style="white-space:pre">                                      </span><SimpleData name="FUNCSTAT10">S</SimpleData></div><div><span class="" style="white-space:pre">                                 </span><SimpleData name="ALAND10">9.67522e+06</SimpleDa</div><div>ta></div><div><span class="" style="white-space:pre">                                   </span><SimpleData name="AWATER10">4866</SimpleData></div><div><span class="" style="white-space:pre">                                        </span><SimpleData name="INTPTLAT10">+46.7776681</Simpl</div><div>eData></div><div><span class="" style="white-space:pre">                                        </span><SimpleData name="INTPTLON10">-088.9520440</Simp</div><div>leData></div><div><span class="" style="white-space:pre">                               </span></SchemaData></div><div><span class="" style="white-space:pre">                        </span></ExtendedData></div><div><span class="" style="white-space:pre">                      </span><Polygon></div><div><span class="" style="white-space:pre">                            </span><outerBoundaryIs></div><div><span class="" style="white-space:pre">                                    </span><LinearRing></div><div><span class="" style="white-space:pre">                                         </span><coordinates></div></div><div><br></div></div>