Find periods of time where two ILS objects are located at a maximum of X degrees longitude from each other

Value

Value

Script

float ang= Float.parseFloat(angle);

where_clause="t1.time>='"+start+"' and t1.time<='"+end+"' and t2.time>='"+start+"' and t2.time<='"+end+"' and " +
  "t1.time=t2.time and t1.target_obj='" +
  planet1+"' and t2.target_obj='"+ planet2+


  "' and  if(abs(t1.long_hci-t2.long_hci)>180,360-abs(t1.long_hci-t2.long_hci)<=" + angle +
  ", abs(t1.long_hci-t2.long_hci)<=" + angle +") order by t1.time";

Script

import java.text.SimpleDateFormat;

int cad = Integer.parseInt(cadence) * 60 *60 * 1000;

end_dates=new ArrayList();
start_dates= new ArrayList();

if(dates.size()==0){
  return;	
}


String tz="+0000";

SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ssZ");

int first=-1;
long date1;
long date2;
 
for(int i=0; i

Value

Value

Script

votable = 
"\n" +
"\n" +
"Object alignment selection based on ILS query\n" +
"\n" +
"SELECT t1.time FROM trajectories AS t1, trajectories AS t2 WHERE t1.time=t2.time and t1.target_obj='"+obj1+"' and t2.target_obj='"+obj2+"' and  if(t1.long_hci>(360-"+angle+"),abs(t1.long_hci-360-t2.long_hci)<"+angle+", if(t2.long_hci>(360-"+angle+"),abs(t1.long_hci-(t2.long_hci-360))<"+angle+",abs(t1.long_hci-t2.long_hci)<"+angle+")) ORDER BY t1.time\n"+
"\n" +
"\n" +
"\n" +
"\n" +
"\n" +
"\n" +
"\n"+
"\n";

for(int i=0; i< start.size(); i++) {
votable = votable +
"  \n"+
"    \n"+
"    \n"+
"  \n";	
}

votable = votable +
"\n"+
"\n"+
"
"+start.get(i)+"
"+end.get(i)+"
\n"+
"\n"+
"";


    

Wsdl

Wsdl Operation