OGN Devices DataBase
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
css
download
language
pict
templates
.gitignore
INSTALL.md
README.md
composer.json
database_schema.sql
index.php
ogn-ddb-schema-1.0.0.json
robots.txt
sql.php.dist

README.md

ogn-ddb: OGN Devices DataBase

Offical server at http://ddb.glidernet.org.

Installation

This project uses the PHP template engine Twig, available via Composer.

  1. Download and install Composer

  2. Clone repository

    git clone https://github.com/glidernet/ogn-ddb
    
  3. Install all dependencies defined in composer.json (this will install Twig)

    cd ogn-ddb
    composer update
    

There is an installation guide to run a local development instance of the DDB with Vagrant.

API-Endpoints

/download

This returns a CSVish-File. Each value is quoted with ', Each line starting with # is a comment.

Field Possible Values
device_type ^[FIO]$
device_id ^[A-F0-9]{6}$
aircraft_model any string
registration any string
cn any string
tracked ^[YN]$
identified ^[YN]$
aircraft_type ^[1-6] (optional, with t flag)

Example:

#DEVICE_TYPE,DEVICE_ID,AIRCRAFT_MODEL,REGISTRATION,CN,TRACKED,IDENTIFIED
'F','0123BC','LS-4','X-0123','23','Y','Y'
'F','DEADBE','DR-400','X-EABC','','N','N'

URL parameters

parameter values default effect
t 0/1 0 show field aircraft_type if set to 1
j 0/1 0 forces JSON output when set to 1 (regardless of accept header)
device_id csv n/a select a comma separated list of device ID's
registration csv n/a select a comma separated list of registrations
cn csv n/a select a comma separated list of callsigns

/download/?j=1

This returns all devices of the DDB in JSON. The output validates against the ogn-ddb-schema-1.0.0.

/download/download-fln.php

This returns the device database in a flarmnet-compatible format.

ToDo

  • finish multi languages management
  • document accurate meaning of tracked and identified