Write some Software

Cancelled Posted 6 years ago Paid on delivery
Cancelled 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"

ASP.NET Geospatial Google Earth Mathematics SQL

Project ID: #13651494

About the project

1 proposal Remote project Active 6 years ago