MiCR0 Posted December 15, 2010 Share Posted December 15, 2010 I am trying to work out how to convert DMS to WGS84 I have the coordinate in mysql like latitude longitude 52°39'03.1 N 0°40'36.1 E 52°46'45.2 N 0°06'59.9 W Any help would be great thanks. Quote Link to comment Share on other sites More sharing options...
MiCR0 Posted December 15, 2010 Author Share Posted December 15, 2010 I have found how to do this in perl foreach (@{$r->{data}{array}}) { if (length($_->{latitude})) { print " <item rdf:about=\"$_->{objectno}\">\n"; print " <title>$_->{objectno} - $_->{objectname}</title>\n"; print " <description>$_->{postext}</description>\n"; print " <georss:point>"; if ($_->{latitude} =~ /(\d+).*?(\d+).*?(\d+\.\d*)\s+([sN])/) { my $latitude = $1+$2/60+$3/3600; $latitude *= -1 if ($4 eq 'S'); print $latitude; } print ' '; if ($_->{longitude} =~ /(\d+).*?(\d+).*?(\d+\.\d*)\s+([EW])/) { my $longitude = $1+($2/60+$3/3600); $longitude *= -1 if ($4 eq 'W'); print $longitude; } print "</georss:point>\n"; print " </item>\n"; } } Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.