?

?

?

We have been thinking about developing a way to take data transmitted from D-RATS forms into a database.? Since D-RATS transmits only the data from forms, an app could populate a database or a spreadsheet for further analysis or filtering.? The key is to make it versatile enough to handle data from a variety of forms and not develop it based on one particular application.

?

Several years ago, a similar application was developed using packet to support medical information from the Peachtree Road Race in Atlanta with 50,000+ runners.? When someone visited (or brought) to one of several medical tents, their info was entered and included their location and if they were transported to a hospital.? When someone inquired on a runner’s status, the query would provide their location and status.

?

Developing something similar with D-RATS as the transport would be great.? The application could allow you to define the fields because you would already know the order and format from a form.? Once the data was captured, typical database functions could be used for query or reporting.? How do you capture the data from the radio as data entry?

?

D-RATS would offer a great front end for data entry with the custom form capability.? We are looking for ideas or other programs that may be adaptable for this purpose.? Thoughts and input is appreciated.

?

John WB4QDX

?

?

?

Yes that is what we use at the Medtronic Twin Cities Marathon to track runners in any of a dozen aid stations, medical tents and busses in real time.? We are handed a spreadsheet of starter information by our events for loading.? ?In a disaster, we would need to support ad-hoc person entry.? We years ago developed trivnetdb, a Linux database replacement for ARES-DATA on PostgreSQL.? Trivnetdb allows TCP/IP users and AX.25 Packet users to access mail, live status messages and databases that can be built on the fly for shelter operations, etc. ?A new version/rewrite under test has a web front end and messaging/query platform and are working on a dashboard for aid station /hospital capacity etc.? It works for us over mesh and DD mode.? We like an API for access to chip timing systems and could be used to upload information to other systems.?

?

A basic database would be a nice back end for D-RATS.? If you could use the keypad on the radio or a cheap tablet individual hams could do queries or updates.? One update is to query a runner bib number and indicate “got on a SAG bus” or “entered an aid station” via a button.? Any system has to scale massively and support real time updates.? ???

From: [email protected] [mailto:[email protected]] On Behalf Of John WB4QDX
Sent: Tuesday, September 29, 2020 6:02 PM
To: [email protected]
Subject: Re: [d-rats] Need a database please

?

We have been thinking about developing a way to take data transmitted from D-RATS forms into a database.? Since D-RATS transmits only the data from forms, an app could populate a database or a spreadsheet for further analysis or filtering.? The key is to make it versatile enough to handle data from a variety of forms and not develop it based on one particular application.

?

Several years ago, a similar application was developed using packet to support medical information from the Peachtree Road Race in Atlanta with 50,000+ runners.? When someone visited (or brought) to one of several medical tents, their info was entered and included their location and if they were transported to a hospital.? When someone inquired on a runner’s status, the query would provide their location and status.

?

Developing something similar with D-RATS as the transport would be great.? The application could allow you to define the fields because you would already know the order and format from a form.? Once the data was captured, typical database functions could be used for query or reporting.? How do you capture the data from the radio as data entry?

?

D-RATS would offer a great front end for data entry with the custom form capability.? We are looking for ideas or other programs that may be adaptable for this purpose.? Thoughts and input is appreciated.

?

John WB4QDX

?

From: [email protected] <[email protected]> On Behalf Of Patrick Connor via groups.io
Sent: Tuesday, September 29, 2020 6:22 PM
To: [email protected]
Subject: Re: [d-rats] Need a database please

?

The forms included in D-RATS can be edited to suit your needs. New forms can also created for specific situations. If you wish to print the received message on paper, an associated XSL style sheet must must be created to format the data for printing.

?

Patrick (N3TSZ)

?

?

On Tuesday, September 29, 2020, 06:10:00 PM EDT, ny9d@... <ny9d@...> wrote:

?

?

If anyone is digging into D-rats we need a database.? We are very well supplied with messaging and file transfer apps.? Radiograms scream "it is still 1917" to me.? Medical command center, missing persons and family reunification use cases need a database.? Leadership will ask about trends, shelter capacity, supply levels.? And where is a given person.? Dashboards are all the rage.? ?Simple fields are key.? Adding new entries on the fly is key.? Scale is key.? "Better data better decisions" etc.??

First name

Last name?

Phone number and or email

Age and or DOB

Gender?

Location/status (no PII/HIPAA details please)?

?

The American Red Cross is rolling out a large database project - cloud based- called RC Care.? After the big Microsoft Office cloud outage yesterday I realized I missed a memo on why we must all use the cloud in natural disasters.? ?We built a fleet of eight mesh tower trailers and are adding a local virtualized compute capability.? The idea is you roll to a disaster, start collecting data, operate locally and then upload via an API if the cloud comes back up lol.??

?

?

Erik, NY9D?

Medtronic Twin Cities Marathon?