search

glidernet / ogn-ddb

OGN Devices DataBase
11 stars 15 forks source link

More precise naming of aircrafts #50

Open moldhouse opened 3 years ago

moldhouse commented 3 years ago

I was trying to get the corresponding index for gliders registered in the database. Therefore I have added a json mapping to https://github.com/weglide/GliderList/ to link between glider names present in the ogb-ddb and gliders in GliderList. In the process, I detected that many namings in the ogn-ddb were not quite precise or did not conform to manufacturers naming conventions.

Maybe it would be interesting to integrate GliderList id to the ogn-ddb? This would make it more precise which glider is meant and would also have the benefit of following strict naming conventions for gliders checked with all manufacturers.

snip commented 3 years ago

Hi @moldhouse, as you can see in https://github.com/glidernet/ogn-ddb/blob/master/database_schema.sql there is a table aircrafts with all aircraft type referenced yet. So this is not a manual string for each entries in devices table.

For the time being we have 558 entries in this table. If required i can provide an extract of this table.

We prefer to not go in every details of type of every gliders, powered aircraft, paraglider, ... as it will be endless. In your list we are missing all none glider aircrafts.