Write some Software
$30-250 USD
Paid on delivery
Need to develop a formula to spit out LAT LONG and ELEVATION values to generate a KML file to visually show 3D Fresnel zone. There is an exact example of what is needed here on attached KML file. Currently I have a generic handler that queries sql and spits out a LINESTRING with both endpoints, I want to enhance this with 3d polygons that show fresnel zone information.
The LoxcelFrenselZone KML is what I want to emulate. The second KML is what I have now. Basically just need to enhance the LineString to include all the polygons to give me the full 3d path to be visualized.
SQL for existing output is here:
[url removed, login to view] = "SELECT TOP 10 ll_lat, ll_long, ISNULL(ll_meters, 0) + ISNULL(ll_asl, 0) as asl, ISNULL(ll_name, '') as [name], ISNULL(ll_description, '') as [desc], ll_createdBy, " & _
"ACOS(SIN(@lat * PI() / 180) * SIN(ll_lat * PI() / 180) + COS(@lat * PI() / 180) * COS(ll_lat * PI() / 180) * " & _
"COS((@lng - ll_long) * PI() / 180)) * 180 / PI() * 60 * 1.1515 * 1.609344 AS distance, " & _
"ll_azimuths " & _
"FROM latlongs WHERE ll_type = 'ap' AND ll_createdBy in ('master', @user) " & _
"ORDER BY distance"
Project ID: #13651494