marky9074
asked on
Using PHP to parse a text file and return a 'route' in Google Earth kml
I am a noob trying to parse a basic text file and create a kml file. I have seen this done with MySQL etc and the examples on google, but to be honest I want to avoid using a database to keep it portable.
I have seen lots of code examples for Google Earth, but not any that create a 'route' just ones that create points on the map.
In the code snippet I am trying to extract the following from the V records:
510949.54N 120108.50W (This would be 51°09'49.54"N, I am still confused about when it goes above 100, but get to that later....)
Latitude (d.m.s. N/S) 26-35
Longitude (d.m.s. E/W) 36-46
Any help much appreciated. I just need some ideas to get me going then I am sure I will get the hang of it..
Thanks,
Mark
I have seen lots of code examples for Google Earth, but not any that create a 'route' just ones that create points on the map.
In the code snippet I am trying to extract the following from the V records:
510949.54N 120108.50W (This would be 51°09'49.54"N, I am still confused about when it goes above 100, but get to that later....)
Latitude (d.m.s. N/S) 26-35
Longitude (d.m.s. E/W) 36-46
Any help much appreciated. I just need some ideas to get me going then I am sure I will get the hang of it..
Thanks,
Mark
V005A002 1 1001510949.54N 120108.50W 708426.45672377.31453.8202100643
Z005A002 1 1001510950.24N 120107.11W 708452.65672400.11453.8202100643
T005A002 1 1 1001511305.45N 115358.70W 716516.95678772.91453.8202100643
S005A002 11 1001510951.74N 120102.79W 708534.65672450.01453.8202100643
C005A002 111 1001510953.66N 120058.95W 708606.75672512.31453.8202100643
R 1 708678.85672574.5 8.2 1
V005A002 1 1002510949.03N 120109.89W 708400.15672360.41453.3202100658
Z005A002 1 1002510949.76N 120108.54W 708425.45672384.11453.3202100658
T005A002 1 1 1002511304.92N 115400.05W 716491.45678755.31453.3202100658
S005A002 11 1002510951.27N 120104.22W 708507.45672434.21453.3202100658
C005A002 111 1002510953.18N 120100.37W 708579.65672496.11453.3202100658
R 1 708651.95672558.1 8.2 1
V005A002 1 1003510948.48N 120111.23W 708374.85672342.41452.5202100713
Z005A002 1 1003510949.24N 120109.92W 708399.25672367.11452.5202100713
T005A002 1 1 1003511304.34N 115401.35W 716467.05678736.61452.5202100713
S005A002 11 1003510950.80N 120105.65W 708480.15672418.71452.5202100713
C005A002 111 1003510952.68N 120101.78W 708552.95672479.81452.5202100713
R 1 708625.75672541.0 8.1 1
V005A002 1 1004510947.95N 120112.59W 708349.05672325.01452.3202100728
Z005A002 1 1004510948.70N 120111.27W 708373.75672349.31452.3202100728
T005A002 1 1 1004511303.79N 115402.67W 716442.15678718.61452.3202100728
S005A002 11 1004510950.33N 120107.07W 708453.35672403.11452.3202100728
C005A002 111 1004510952.18N 120103.16W 708526.85672463.21452.3202100728
R 1 708600.35672523.3 8.1 1
V005A002 1 1005510947.40N 120113.95W 708323.35672306.91452.1202100742
Z005A002 1 1005510948.15N 120112.63W 708348.05672331.31452.1202100742
T005A002 1 1 1005511303.24N 115404.00W 716416.95678700.21452.1202100742
S005A002 11 1005510949.82N 120108.47W 708426.75672386.21452.1202100742
C005A002 111 1005510951.64N 120104.54W 708500.75672445.51452.1202100742
ASKER
OK, I realised what happens at 100, the space that is seen in the code is used for the extra digit....dooh!
ASKER
OK, I have had a play manually extracting the fields in excel and creating the xml code which seems to work ok in google maps and google earth.
It would seem best to keep appending the file with <placemark> events every time a new file is parsed (because then I can use it in google maps).....but this means I will end up with a large file...
It would seem best to keep appending the file with <placemark> events every time a new file is parsed (because then I can use it in google maps).....but this means I will end up with a large file...
<?xml version="1.0" encoding="UTF-8"?>
<kml xmlns="http://earth.google.com/kml/2.2">
<Document>
<name>Providence Resources Dunquin 2D 2006</name>
<description>2D Seismic Post Plot</description>
<Style id="BrownLine">
<LineStyle>
<color>7d000080</color>
<width>1</width>
</LineStyle>
</Style>
<Placemark>
<name>001A003</name>
<description>Prime Line</description>
<styleUrl>#BrownLine</styleUrl>
<LineString>
<coordinates>
-12.296289,51.039664
-12.296533,51.039900
-12.296797,51.040128
-12.297067,51.040350
-12.297328,51.040578
-12.297575,51.040808
</coordinates>
</LineString>
</Placemark>
</Document>
</kml>
ASKER
OK, I used this perl script in cygwin to strip out what I need from the files...
#!/usr/bin/perl -w
while ( <> )
{
if ( /^V/ )
{
$latitude = substr($_,25,10);
$longitude = substr($_,35,11);
print "$longitude,$latitude\n";
}
}ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER