Satellite Internet

Satellite Internet Forum.

Welcome, Guest.
Welcome to this satellite broadband discussion forum. Wherever you are and whatever your problem we are here to help each other. Connecting to the internet via satellite is not always easy but is critically important to those in remote places or with poor terrestrial infrastructure. Both service providers and customers are encouraged to contribute. Register at the bottom of the forum home page if you wish to contribute or ask question. May 2018: GDPR: Updates to Privacy and Cookies policies: As you may know, a new EU data protection law called GDPR will apply from Friday 25th May 2018. As part of satsig's commitment to protecting the privacy of site visitors and forum members, I have therefore updated the Privacy and Cookie policies. There are now links leading to these policies: Disclaimer, Terms of Use and Privacy, Forum User Agreement, Forum Rules and Cookies at the bottom of the home page and all forum pages. Read the Forum rules.
      Satellite internet forum          
Pages: 1

Geo Coordinates

(Read 3880 times)
Ex Member
Ex Member


Apr 7th, 2012 at 11:58pm  
how I can generate the Geo Coordinates report of all vsat sites in iDirect network , but report format should be  degree/minutes/seconds .

Can any one help me.

Best Regards,

Farrukh Shahzad,
Back to top
 
 
IP Logged
 
Eric Johnston
Senior Member
***
Offline


Personal text from Profile,
Options, Top line

Posts: 2108
Reply #1 - Apr 8th, 2012 at 7:59pm  
If you have the list in the form of positive decimal degrees, like 10.019 deg, then put the list in the left column of a spreadsheet, starting on row 2, cell A2
Along the top line type: Input, Deg, Min, Sec
On the second line enter formulas
B2    =INT(A2)         gives whole degrees
C2    =INT((A2-B2)*60)  gives minutes
D2    =INT(60*60*A2-B2-C2/60))   gives seconds
Copy the three formulas all the way down.

I hope that works, but I suggest you check a few values manually using a calculator!

For example
10.019 deg =  10 deg.
.019 * 60 minutes = 1.14 min = 1 min.
0.14 * 60 sec = 8.4 sec = 8 sec.

Best regards, Eric.
Back to top
 
 
IP Logged
 
Ex Member
Ex Member


Reply #2 - Apr 10th, 2012 at 3:24pm  
Thanks Eric,

But i am looking for to pull all GEO location in one short , as per you way i have to put value one by one , and i have more than 1500 remotes.
Back to top
 
 
IP Logged
 
Eric Johnston
Senior Member
***
Offline


Personal text from Profile,
Options, Top line

Posts: 2108
Reply #3 - Apr 10th, 2012 at 4:41pm  
If someone knows how to extract the lat long data from iDirect hub please say.

Here is an idea:
Can you access a directory which has all your options files ?
If so, concatonate the option files together into one giant file, type .txt

Save the txt file.

This file contains multiple sequencies like so:
     hub_long = 245.1278
     remote_lat = 30.285000
     remote_long = 268.739700
     spacecraft_long = -90.000000
Edit this file (with Microsoft Word, for example).

Replace all new line characters with space.
Replace all instances of remote_lat = with <new line> remote_lat = ,
Replace all instances of remote_long with , remote_long =
Replace all instances of spacecraft_long with <new line> spacecraft_long =

You should now have a file containing two types of line.

Long lines of rubbish
Short wanted lines, like this:
remote_lat = , 30.285000, remote_long = , 268.739700

Save the txt file.

Now load the entire txt file into Excel, with the delimiter set to ,

Sort the whole spread sheet and all the wanted lines will become grouped together.  Delete all the unwanted lines.

Save the Excel file.

Then add formulas like I suggested above, using as input, columns B and D, to convert to new columns of deg minutes and seconds.  If you have site longitudes in the range 180 to 360 deg you might like to subtract from 360 before converting to deg, min, sec so as to get the deg W version.  Note the angles (deg, min and sec) go backwards aound the earth!

Arrange the 6 output columns, put titles at the top, select that area of cells and printout.

Save the Excel file.

Best regards, Eric.
Back to top
« Last Edit: Apr 10th, 2012 at 6:03pm by Eric Johnston »  
 
IP Logged
 
Ex Member
Ex Member


Reply #4 - Apr 11th, 2012 at 4:43pm  
i generate that file ,but how i will get the site codes . i have to enter the site codes manually.?


Many Thanks Eric
Back to top
 
 
IP Logged
 
Eric Johnston
Senior Member
***
Offline


Personal text from Profile,
Options, Top line

Posts: 2108
Reply #5 - Apr 11th, 2012 at 6:34pm  
I'm not sure what is "site code"

If you mean modem_sn or did then it is in the following block of text:

[OPTIONS_FILE]
     modem_sn = 81701
     modem_type = Remote
     modem_hardware = 3100
     did = 2022123
     generated_by = NMS version $Name: NetModem-8_0_2_1 $

I'm not quite sure how to proceed. I do this sort of thing from time to time to get orbital 2 line elements into my version of "1 line elements" and a bit of trial and error is needed with Microsoft Word character replace function prior to inputting the text file into Excel as a .txt or .csv file.

May be replace all did by <new line>remote_did
Then replace all generated by <new line>generated

You will now have:
many rubbish lines intermingles with
a set of did lines
a set of lat/long lines.

When your sort this list in Excel the did and lat/long lines may get out of sync.
I suggest
replace remote_did with remote,did,
replace remote_lat with remote,lat,
replace remote_long with remote,long,

When you sort, use the column with the the word remote and hopefully the data will be like so

remote,did,
remote,lat,    remote,long,
remote,did,
remote,lat,    remote,long,
etc.

This is not a complete answer !! Some experimentation may be needed.

Does anyone know how to get the data out of the iDirect hub directly ?  Are there linux commands that will extract the relevant data fields ?  Can someone write a suitable script ?  Please .....

Best regards, Eric
Back to top
 
 
IP Logged
 
Ex Member
Ex Member


Reply #6 - May 31st, 2012 at 11:27am  
Hi,

you can retrieve the Geolocation points of all your satmodem by the Mysql database on your NMS server.

db: nms
table: GeoLocation

Example:
mysql> select * from nms.GeoLocation;

| GeoLocationId | LatDegrees | LatMinutes | LatSeconds | LongDegrees | LongMinutes | LongSeconds | Elevation | LatSouth | LongWest |
...




Regards

Back to top
« Last Edit: May 31st, 2012 at 1:02pm by N/A »  
 
IP Logged
 
Pages: 1