Rocksolid Light

Welcome to novaBBS (click a section below)

mail  files  register  newsreader  groups  login

Message-ID:  

"It ain't over until it's over." -- Casey Stengel

tech / rec.aviation.soaring / Re: Slice & Dice Glider Accidents Data

SubjectAuthor
* Slice & Dice Glider Accidents DataIdoMillet
`* Re: Slice & Dice Glider Accidents DataShaun Wheeler
 `- Re: Slice & Dice Glider Accidents DataIdoMillet

1
Slice & Dice Glider Accidents Data

<e27c8169-d8fd-44af-9070-036d5d430db8n@googlegroups.com>

  copy mid

https://www.novabbs.com/tech/article-flat.php?id=26573&group=rec.aviation.soaring#26573

  copy link   Newsgroups: rec.aviation.soaring
X-Received: by 2002:a05:622a:18a3:b0:2f1:f958:38cc with SMTP id v35-20020a05622a18a300b002f1f95838ccmr18629677qtc.171.1651062409113;
Wed, 27 Apr 2022 05:26:49 -0700 (PDT)
X-Received: by 2002:a81:ac57:0:b0:2f1:99ec:91a2 with SMTP id
z23-20020a81ac57000000b002f199ec91a2mr26841054ywj.329.1651062408930; Wed, 27
Apr 2022 05:26:48 -0700 (PDT)
Path: i2pn2.org!i2pn.org!aioe.org!newsfeed.hasname.com!weretis.net!feeder6.news.weretis.net!news.misty.com!border2.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: rec.aviation.soaring
Date: Wed, 27 Apr 2022 05:26:48 -0700 (PDT)
Injection-Info: google-groups.googlegroups.com; posting-host=184.56.109.92; posting-account=JZIrmgoAAAAYoYlT1g1unruYKhUJx1NV
NNTP-Posting-Host: 184.56.109.92
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <e27c8169-d8fd-44af-9070-036d5d430db8n@googlegroups.com>
Subject: Slice & Dice Glider Accidents Data
From: ido...@milletsoftware.com (IdoMillet)
Injection-Date: Wed, 27 Apr 2022 12:26:49 +0000
Content-Type: text/plain; charset="UTF-8"
Lines: 17
 by: IdoMillet - Wed, 27 Apr 2022 12:26 UTC

I compiled FAA USA glider accident data into an interactive web page: https://www.milletsoftware.com/Data/Glider_Events.html

This allows you to slice & dice the data using pivot tables & charts. A dropdown allows you to select from predefined report layouts. You can filter, sort, modify and add your own reports (accessible only to you).

Double-clicking a summary cell or a chart node provides a drill-down to the detail rows making up that summary. Hover over details to see the full text via a tooltip.

One of the predefined reports provides accident frequency and damage level by Make, Model, and Registration Number. So you can look up a particular glider.

A video demo is available here: https://youtu.be/Vwt8TXdKU7A?t=667
It uses different data, but the idea is the same.

Please send feedback and ideas for additional report layouts.

Fly Safe!
- ido

Ido Millet
www.MilletSoftware.com

Re: Slice & Dice Glider Accidents Data

<00644401-70d6-4aab-b38c-664cd2ee0e10n@googlegroups.com>

  copy mid

https://www.novabbs.com/tech/article-flat.php?id=26752&group=rec.aviation.soaring#26752

  copy link   Newsgroups: rec.aviation.soaring
X-Received: by 2002:a37:ac13:0:b0:69f:c370:1784 with SMTP id e19-20020a37ac13000000b0069fc3701784mr3607554qkm.459.1651865932105;
Fri, 06 May 2022 12:38:52 -0700 (PDT)
X-Received: by 2002:a81:260a:0:b0:2f4:ca82:a42f with SMTP id
m10-20020a81260a000000b002f4ca82a42fmr4089100ywm.149.1651865931876; Fri, 06
May 2022 12:38:51 -0700 (PDT)
Path: i2pn2.org!i2pn.org!paganini.bofh.team!pasdenom.info!nntpfeed.proxad.net!proxad.net!feeder1-2.proxad.net!209.85.160.216.MISMATCH!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: rec.aviation.soaring
Date: Fri, 6 May 2022 12:38:51 -0700 (PDT)
In-Reply-To: <e27c8169-d8fd-44af-9070-036d5d430db8n@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=2602:306:bd79:cd70:fcdd:42e5:5ad3:6d0c;
posting-account=0usWjwoAAAA9HODx-hI60K4gDOQAGaHK
NNTP-Posting-Host: 2602:306:bd79:cd70:fcdd:42e5:5ad3:6d0c
References: <e27c8169-d8fd-44af-9070-036d5d430db8n@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <00644401-70d6-4aab-b38c-664cd2ee0e10n@googlegroups.com>
Subject: Re: Slice & Dice Glider Accidents Data
From: shaunwhe...@gmail.com (Shaun Wheeler)
Injection-Date: Fri, 06 May 2022 19:38:52 +0000
Content-Type: text/plain; charset="UTF-8"
 by: Shaun Wheeler - Fri, 6 May 2022 19:38 UTC

Very nice work. I went through a pile of these the hard way, this would have saved me a lot of work!

Re: Slice & Dice Glider Accidents Data

<ccd996d6-6e86-4f4e-938b-9229a5fbaac9n@googlegroups.com>

  copy mid

https://www.novabbs.com/tech/article-flat.php?id=26913&group=rec.aviation.soaring#26913

  copy link   Newsgroups: rec.aviation.soaring
X-Received: by 2002:ac8:5d8b:0:b0:2f3:df07:d752 with SMTP id d11-20020ac85d8b000000b002f3df07d752mr1025642qtx.528.1652899021325;
Wed, 18 May 2022 11:37:01 -0700 (PDT)
X-Received: by 2002:a25:2544:0:b0:64d:7ff0:b313 with SMTP id
l65-20020a252544000000b0064d7ff0b313mr956000ybl.149.1652899021145; Wed, 18
May 2022 11:37:01 -0700 (PDT)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!feed1.usenet.blueworldhosting.com!peer01.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: rec.aviation.soaring
Date: Wed, 18 May 2022 11:37:00 -0700 (PDT)
In-Reply-To: <00644401-70d6-4aab-b38c-664cd2ee0e10n@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=184.56.109.92; posting-account=JZIrmgoAAAAYoYlT1g1unruYKhUJx1NV
NNTP-Posting-Host: 184.56.109.92
References: <e27c8169-d8fd-44af-9070-036d5d430db8n@googlegroups.com> <00644401-70d6-4aab-b38c-664cd2ee0e10n@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <ccd996d6-6e86-4f4e-938b-9229a5fbaac9n@googlegroups.com>
Subject: Re: Slice & Dice Glider Accidents Data
From: ido...@milletsoftware.com (IdoMillet)
Injection-Date: Wed, 18 May 2022 18:37:01 +0000
Content-Type: text/plain; charset="UTF-8"
X-Received-Bytes: 1483
 by: IdoMillet - Wed, 18 May 2022 18:37 UTC

Added a 'Phase' column and a couple of displays focusing on flight phase (Landing, Takeoff, etc.).

Reminder: these displays are interactive, so you can Slice & Dice, Drill-Down, Filter, and create your own displays:
https://www.milletsoftware.com/Data/Glider_Events.html

- ido

1
server_pubkey.txt

rocksolid light 0.9.8
clearnet tor