XML : Uploading a xml fille into google maps API

Sorry I am new to this but I have uploaded a excel spreadsheet into phpmyadmin to create tables and then I have done a XML dump of the data base. I know want to use that XML file and implement it into Google maps API but im struggling here.. Any suggestions would be great!

This is how my XML file looks:

  <pre><?xml version="1.0" encoding="UTF-8"?>    <!-- - phpMyAdmin XML Dump - version 4.1.14.8 - http://www.phpmyadmin.net - - Host: infongd5473 - Generation Time: Nov 08, 2015 at 09:43 PM - Server version: 5.5.46-0+deb7u1 - PHP Version: 5.4.45-0+deb7u2 -->    -<pma_xml_export xmlns:pma="http://www.phpmyadmin.net/some_doc_url/"   version="1.0">    <!-- - Structure schemas -->        -<pma:structure_schemas>      -<pma:database charset="latin1" collation="latin1_swedish_ci" name="db599909206">    <pma:table name="transport_questions"> CREATE TABLE `transport_questions` ( `Question` varchar(72) CHARACTER SET utf8 NOT NULL, `Year` varchar(72) CHARACTER SET utf8 NOT NULL, `Area` varchar(72) CHARACTER SET utf8 NOT NULL, `Percentage` varchar(72) CHARACTER SET utf8 NOT NULL, `Latitude` varchar(72) CHARACTER SET utf8 NOT NULL, `Longitude` varchar(72) CHARACTER SET utf8 NOT NULL, `Location` varchar(72) CHARACTER SET utf8 NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; </pma:table>    </pma:database>    </pma:structure_schemas>    <!-- - Database: 'db599909206' -->        -<database name="db599909206">    <!-- Table transport_questions -->        -<table name="transport_questions">    <column name="Question">% respondents who go to work (as driver) by car</column>    <column name="Year">2013</column>    <column name="Area">Ashley</column>    <column name="Percentage">25.3</column>    <column name="Latitude">51.46619</column>    <column name="Longitude">-2.583456</column>    <column name="Location">(51.46619 -2.583456)</column>    </table>      -<table name="transport_questions">     <column name="Question">% respondents who go to work (as passenger) by  car</column>    <column name="Year">2013</column>    <column name="Area">Ashley</column>    <column name="Percentage">3.7</column>    <column name="Latitude">51.46619</column>    <column name="Longitude">-2.583456</column>    <column name="Location">(51.46619 -2.583456)</column>    </table>      -<table name="transport_questions">    <column name="Question">% respondents who go to work by another         mode</column>    <column name="Year">2013</column>    <column name="Area">Ashley</column>    <column name="Percentage">0</column>    <column name="Latitude">51.46619</column>    <column name="Longitude">-2.583456</column>    <column name="Location">(51.46619 -2.583456)</column>    </table>      -<table name="transport_questions">    <column name="Question">% respondents who go to work by bus</column>    <column name="Year">2013</column>    <column name="Area">Ashley</column>    <column name="Percentage">10.9</column>    <column name="Latitude">51.46619</column>    <column name="Longitude">-2.583456</column>    <column name="Location">(51.46619 -2.583456)</column>    </table>      -<table name="transport_questions">    <column name="Question">% respondents who go to work by car</column>    <column name="Year">2013</column>    <column name="Area">Ashley</column>    <column name="Percentage">29</column>    <column name="Latitude">51.46619</column>    <column name="Longitude">-2.583456</column>    <column name="Location">(51.46619 -2.583456)</column>    </table> <code>    

No comments:

Post a Comment