The Utah Back Country Pilots Association (UBCP) maintains a list of back country airstrips. Since I frequently fly over a lot of rugged terrain in Utah, I really wanted to have these airstrips shown on my display in case of engine failure.
For members they offer a great set of ForeFlight Waypoints for these airstrips, unfortunately this did not help me and my G3X displays. For members they do offer a “Developers API” which contains the information about the airstrips, below are instructions to reformat the “Developers API” for G3X displays.
1. Open UBCP Developer API file in Notepad
2. Copy all text and Paste into Word
3. Do search/replace id”:” (must be manually typed in) changed to ^p”id”:” (this places each waypoint on its own line)
4. Do search/replace ,” changed to ~” (sets the tilde as the separator character)
5. Select all text and Copy
6. Paste text into Notepad
7. Save file as Waypoints Formatted.txt
8. Open Excel
9. Select Data, From Text, Delimited
10. Deselect Tab, select Other (and enter ~), and Text qualifier to None
11. Delete all columns EXCEPT:
• title
• land_ownership
• runway_surface
• latitude
• longitude
• elevation
12. Do search/replace ”title”:” with no characters
13. Do search/replace ”land_ownership”:” with no characters
14. Do search/replace ”runway_surface”:” with no characters
15. Manipulate title data to 20 or less characters
16. Merge/Manipulate land_ownership and runway_surface data into a single field of 20 or less characters
17. Do search/replace ”waypoint_id”:” with no characters
18. Do search/replace ”latitude”:” with <wpt lat=”
19. Do search/replace ”longitude”:” with <sp>lon=”
20. Do search/replace ”elevation”: with ><ele>
21. Make a new workbook and copy any columns with a “ suffix from the Waypoints worksheet to New worksheet
22. In the New worksheet do search/replace ” with no characters
23. Copy each column back to its original location in the Waypoints worksheet
24. Insert 13 new Columns
25. Cut/Paste into Column A the column containing <wpt lat=”xxxx.xxxxxxxx”
26. Cut/Paste into Column B the column containing <sp>lon=”xxxx.xxxxxxx”
27. Fill all rows of Column C with ><ele>
28. Make a new workbook and copy the column containing the Elevation values from the Waypoints worksheet to New worksheet in Column A
29. In Column B insert the formula =ROUND((E155*0.3048),2) in all rows
30. Copy Column B and paste it into the Waypoints worksheet Column D
31. Fill all rows of Column E with </ele>
32. Fill all rows of Column F with <name>
33. Cut/Paste into Column G the column that contains the Airport Names
34. Fill all rows of Column H with </name>
35. Fill all rows of Column I with <desc>
36. Cut/Paste into Column J the column that contains the Airport Descriptions
37. Fill all rows of Column K with </desc>
38. Fill all rows of Column L with <sym>Soft Field</sym>
39. Fill all rows of Column M with </wpt>
40. Copy down all rows of Column N with =A1&B1&C1&D1&E1&F1&G1&H1&I1&J1&K1&L1&M1
Each line should look like this <wpt lat=”39.69200000″ lon=”-109.58830000″<ele>6120</ele><name>Agency Draw Oil Fld</name><desc>Private/Overgrown</desc><sym>Soft Field</sym></wpt>
41. Copy all text in Column N and paste into Notepad++
42. Add header (Link to text file with header)
43. Add footer </gpx>
44. Do search/replace \r\n with no characters
45. Save File as NEW WAYPOINTS G3X.txt
46. Rename file to NEW WAYPOINTS G3X.gpx
Done!
No Comments