Hi
This is probablly the wrong forum... but. any pointers would be great. I have about 1000 xml documents that I need to get the long / lat and title out of and import to my sql database, Mysql can import the file but what headings would i need as I only need to get certain some data elements.
Data of intreats
<rdf:Description rdf:about="http://nuts.geovocab.org/id/FI134_geometry">'>http://nuts.geovocab.org/id/FI134_geometry">; =want on every line
<rdf:Description>
<geo:long>28.274320550000056</geo:long>
<geo:lat>63.668830750000069</geo:lat>
</rdf:Description>
XML FILE
<?xml version="1.0" encoding="UTF-8"?>
<rdf:RDF xmlns:ngeo="http://geovocab.org/geometry#";
xmlns:dc="http://purl.org/dc/elements/1.1/";
xmlns:owl="http://www.w3.org/2002/07/owl#";
xmlns:gml="http://www.opengis.net/gml";
xmlns:ogr="http://ogr.maptools.org/";
xmlns:geo="http://www.w3.org/2003/01/geo/wgs84_pos#";
xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#";
xmlns:nuts="http://nuts.geovocab.org/id/">;
<rdf:Description rdf:about="http://nuts.geovocab.org/id/FI134_geometry">'>http://nuts.geovocab.org/id/FI134_geometry">;
<dc:rights>© EuroGeographics for the administrative boundaries.</dc:rights>
<rdf:type rdf:resource="http://geovocab.org/geometry#Polygon"/>;
<ngeo:exterior>
<rdf:Description>
<rdf:type rdf:resource="http://geovocab.org/geometry#LinearRing"/>;
<ngeo:posList rdf:parseType="Collection">
<rdf:Description>
<geo:long>28.274320550000056</geo:long>
<geo:lat>63.668830750000069</geo:lat>
</rdf:Description>
<rdf:Description>
<geo:long>27.743564550000059</geo:long>
<geo:lat>63.908638250000024</geo:lat>
</rdf:Description>
<rdf:Description>
<geo:long>26.870599550000037</geo:long>
<geo:lat>64.036758250000048</geo:lat>
</rdf:Description>
<rdf:Description>
<geo:long>26.78037455000009</geo:long>
<geo:lat>64.057007250000026</geo:lat>
</rdf:Description>
<rdf:Description>
<geo:long>26.767509550000057</geo:long>
<geo:lat>64.26518225</geo:lat>
</rdf:Description>
<rdf:Description>
<geo:long>26.290888050000035</geo:long>
<geo:lat>64.47910275000001</geo:lat>
</rdf:Description>
<rdf:Description>
<geo:long>27.148353550000053</geo:long>
<geo:lat>64.83509025</geo:lat>
</rdf:Description>
<rdf:Description>
<geo:long>27.354580050000067</geo:long>
<geo:lat>64.811851250000046</geo:lat>
</rdf:Description>
<rdf:Description>
<geo:long>27.404724050000084</geo:long>
<geo:lat>64.927063250000089</geo:lat>
</rdf:Description>
<rdf:Description>
<geo:long>27.262201550000043</geo:long>
<geo:lat>65.027481250000079</geo:lat>
</rdf:Description>
<rdf:Description>
<geo:long>27.330337050000026</geo:long>
<geo:lat>65.090568250000047</geo:lat>
</rdf:Description>
<rdf:Description>
<geo:long>27.893339550000093</geo:long>
<geo:lat>65.091476750000083</geo:lat>
</rdf:Description>
<rdf:Description>
<geo:long>28.033794550000039</geo:long>
<geo:lat>65.238540750000027</geo:lat>
</rdf:Description>
<rdf:Description>
<geo:long>28.60936355000004</geo:long>
<geo:lat>65.285812750000048</geo:lat>
</rdf:Description>
<rdf:Description>
<geo:long>28.646398550000072</geo:long>
<geo:lat>65.38960275000008</geo:lat>
</rdf:Description>
<rdf:Description>
<geo:long>29.212856550000026</geo:long>
<geo:lat>65.518280250000061</geo:lat>
</rdf:Description>
<rdf:Description>
<geo:long>29.755178550000096</geo:long>
<geo:lat>65.497230750000057</geo:lat>
</rdf:Description>
<rdf:Description>
<geo:long>29.747020550000059</geo:long>
<geo:lat>65.347762750000015</geo:lat>
</rdf:Description>
<rdf:Description>
<geo:long>29.601873550000079</geo:long>
<geo:lat>65.26001025000005</geo:lat>
</rdf:Description>
<rdf:Description>
<geo:long>29.885624550000017</geo:long>
<geo:lat>65.206405250000046</geo:lat>
</rdf:Description>
<rdf:Description>
<geo:long>29.819372050000055</geo:long>
<geo:lat>65.144180750000089</geo:lat>
</rdf:Description>
<rdf:Description>
<geo:long>29.896435050000093</geo:long>
<geo:lat>65.105209750000029</geo:lat>
</rdf:Description>
<rdf:Description>
<geo:long>29.627224050000052</geo:long>
<geo:lat>65.060310250000015</geo:lat>
</rdf:Description>
<rdf:Description>
<geo:long>29.645586050000077</geo:long>
<geo:lat>64.866271750000038</geo:lat>
</rdf:Description>
<rdf:Description>
<geo:long>29.73990455</geo:long>
<geo:lat>64.789924250000041</geo:lat>
</rdf:Description>
<rdf:Description>
<geo:long>30.086794050000037</geo:long>
<geo:lat>64.77400925</geo:lat>
</rdf:Description>
<rdf:Description>
<geo:long>30.130295050000029</geo:long>
<geo:lat>64.63483425000004</geo:lat>
</rdf:Description>
<rdf:Description>
<geo:long>29.989610550000037</geo:long>
<geo:lat>64.587608250000073</geo:lat>
</rdf:Description>
<rdf:Description>
<geo:long>30.044838050000038</geo:long>
<geo:lat>64.402091750000011</geo:lat>
</rdf:Description>
<rdf:Description>
<geo:long>30.482809050000014</geo:long>
<geo:lat>64.262344250000041</geo:lat>
</rdf:Description>
<rdf:Description>
<geo:long>30.553520050000088</geo:long>
<geo:lat>64.132431250000025</geo:lat>
</rdf:Description>
<rdf:Description>
<geo:long>30.260633550000023</geo:long>
<geo:lat>63.82169325000001</geo:lat>
</rdf:Description>
<rdf:Description>
<geo:long>29.97179605000008</geo:long>
<geo:lat>63.757224750000034</geo:lat>
</rdf:Description>
<rdf:Description>
<geo:long>29.776088550000054</geo:long>
<geo:lat>63.703410750000046</geo:lat>
</rdf:Description>
<rdf:Description>
<geo:long>29.681949550000013</geo:long>
<geo:lat>63.878929250000084</geo:lat>
</rdf:Description>
<rdf:Description>
<geo:long>28.502290550000026</geo:long>
<geo:lat>63.88212925000002</geo:lat>
</rdf:Description>
<rdf:Description>
<geo:long>28.35947605000004</geo:long>
<geo:lat>63.755032250000028</geo:lat>
</rdf:Description>
</ngeo:posList>
</rdf:Description>
</ngeo:exterior>
</rdf:Description>
</rdf:RDF>
Sorry, thanks