¿ªÔÆÌåÓý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) ? ? ? ? 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? |
