Like to import an airspace from OpenAir data - but how to do it?

[guest29729]

Hi,

I have three more observations about Plan-G and Open Air format data.
I attach a zip archive with a set of files. You can find in it: screenshots (Plan-G, X-Plane - to see differences), Plan-G_Log.txt (here you can see that number of imported airspaces does not correspond to number of airspaces in imported files) and some open air formatted files with faked areas used for tests.
1. The last airspace in file is ignored and not importing. File that contains only one airspace imports nothing. Any other file with two or more airspaces imports all before last but not last.
2. Plan-G does not draw any circles (DC) on the map. It draws arcs (DB) but not circles.
3. There is an exception while writing airspace with coordinates where space is omitted. Example: 50:00:00N makes an exception (50:00:00 N is correct). You can see it in attached log file. This exception is only logged in log file. There is no any message in runtime and Plan-G continues its work. Maybe it is not important. X-Plane crashes on start in this case. I think, that I wouldn't change that if it does not stop writing any other well formatted data after that. I have not tested it.

Update:
There is a workaround to import last (or one and the only) airspace to Plan-G. I suspect Plan-G is sensitive for AC entry. When I add simple entry "AC C" at the end of the imported file it works well. That "hack" entry does not stop X-Plane.

[andrzejkif]

When i try to import data i have only error message.

14:52:37.3 Short data: Need 15 got 1
14:59:29.7 Short data: Need 15 got 8

Unknown format of data - what is required to prepare "by hand"
There was post ...with no answer with detailed description :(

Plan-G compatible airspace data format?
« on: July 21, 2015, 05:57:00 AM »
The first look's like type of airspace (which number for which airspace?)|Name|?|?|lowAlt|Lat|Lon|hightAlt|Lat|Lon| coords of all points|?|?|?

[tim arnot]

The link to the airspace format is given on the previous page. I repeat it here: http://www.winpilot.com/UsersGuide/UserAirspace.asp

The Plan-G implementation is still in beta, and is quite likely to be buggy. You will need to supply the airspace file you believe to be faulty, and once I have a usable PC again, I shall be able to look at it. I cannot give a timeframe.

[dempsey]

Tim,

I use this airspace web link: http://soaringweb.org/Airspace/NA/HomePage.html.

Are you processing the Open Air format in you latest beta?

What about Terrain?

[andrzejkif]

I try to update airspace first as current view is very out of date (as CTR for EPBY)
I have data to check above - i will dig in details afternoon.
Thanky you.
Bye
-Andrzej

[andrzejkif]

Using latest. v3v1v3v113
Importing Airspace data gives ERRORS.

___Could i gt/know detailed specification of import format, please?___
It could save loads of my time... i am digging and checking...

i.e. analyzing wrong(out dated)
4|BYDGOSZCZ/SZWEDEROWO CTR|1|2|0|52.95667|17.53611|9500|53.32695|18.49417|53.32694   53.30056   52.9675   52.95667   53.12083   53.32694|18.29583   18.45278   18.49417   17.55583   17.53611   18.29583|0|0|0

Points of area are most obvious...but there looks "rectangle" non-visible which includes all points inside ...etc...
How would i add all points by myself??????????????

G-plan shows degrees, minutes, seconds... why or why i need to put         degrees,fraction part of it  in import file?
Seems we have double conversion.. i need to convert to import...g-plan converts it to show it?

As example - XC Soar gets data and shows them very well... but Plan-G for PC as i am not soaring ;) 

[guest29729]

See attached file, please. Plan-G can successfully import it. It is OpenAir format discussed in this topic.

[andrzejkif]

Plan-G seems to not listen to me...
0 records imported (left as txt or renamed to csv...same result)

07:23:37.8 Short data: Need 15 got 1
07:23:37.9 Short data: Need 15 got 1
07:23:37.9 Short data: Need 15 got 1
07:23:37.9 Short data: Need 15 got 1

to be sure - I use
Data > Data tools > Airspace Table/Import Data
Plan-G v.3.1.3.113
PL system settings.
Own FSX ... Display FSX Data

[guest29729]

Oh, now I see. I think that export/import from Data tools is based on csv file. Not OpenAir format.
I've exported my airspaces this way. Attached file contains valid content for EPBY. It is importable IMHO. My try was successful.
Maybe you can diff my file with yours. Maybe it will help.

The way I use airspaces is to import them at building navigation database. I fly X-Plane. Plan-G reads X-Plane data from known locations. OpenAir formatted airspaces also.

[andrzejkif]

Seb,

I got 1 line from standard databasa...but it is outdated...very much...
The thing is to update all airpace data into plan-G for EPWW FIR... but as you can see - my Plan-G does not want to...

This is main reaso i want to know structure of data format - have no answer so far.

When i know - i would be able to convert all data from Airspace FORMAT into csv readable by plan-G.

I prepared excell sheet fo convert  Degrees;Minutes;seconds into  Degrees,xxxxxsomething....
For example      53°08'46''N   017°40'46''E >>>>>
53   8   46      17   40   46    getting     53,1461   17,6794 ..to be loaded into Plan-G

[andrzejkif]

Trial/Try as below gives hanging plan-G :(

4|BYDGOSZCZ/SZWEDEROWO CTR|1|2|0|52.95667|17.53611|9500|53.32695|18.49417|53,1461   53,1783   53,2158   53,1989   53,1603   53,1014   53,0622   53,0028   52,9431   52,9433   52,9622   52,9789   53,0631   53,1364   53,1461|17,6794   17,8964   18,2408   18,3161   18,3658   18,3775   18,3542   18,2450   17,8992   17,8042   17,7361   17,6917   17,6606   17,6675   17,6794|0|0|0

[guest29729]

Unfortunately, I don't know expected format of the csv file.
All I know about Open Air data import is a result of reverse engineering that I have made myself already.

I thought earlier that successfully exported data may be useful to know expectations.
It brings information that dot is a decimal separator (it is forced, simple experiment proofs that system settings are ignored) and TABs are used where coordinates are enumerated.
Exported data are importable back, so these files are well formatted.
For CTR airspace 4 first fields are different than yours. My data starts with: 1|BYDGOSZCZ/Szwederowo CTR|2|1|

Previous post has a line of data where digits have mixed decimal separator. It must fail but of course it shouldn't hang the app.

At last I'm sorry if I couldn't help. I've done my best.

[andrzejkif]

The link to the airspace format is given on the previous page. I repeat it here: http://www.winpilot.com/UsersGuide/UserAirspace.asp

The Plan-G implementation is still in beta, and is quite likely to be buggy. You will need to supply the airspace file you believe to be faulty, and once I have a usable PC again, I shall be able to look at it. I cannot give a timeframe.

Could you share csv format, please?
I feel left alone.

[andrzejkif]

Unfortunately, I don't know expected format of the csv file.
All I know about Open Air data import is a result of reverse engineering that I have made myself already.

I thought earlier that successfully exported data may be useful to know expectations.
It brings information that dot is a decimal separator (it is forced, simple experiment proofs that system settings are ignored) and TABs are used where coordinates are enumerated.
Exported data are importable back, so these files are well formatted.
For CTR airspace 4 first fields are different than yours. My data starts with: 1|BYDGOSZCZ/Szwederowo CTR|2|1|

Previous post has a line of data where digits have mixed decimal separator. It must fail but of course it shouldn't hang the app.

At last I'm sorry if I couldn't help. I've done my best.

Seb!- thank you very much for your efforts.
I need to search / ask for mor... administrator maybe :)
-Andrzej