Longer-term Query/Report

[W B McCarty]

I'm interested in tracking spots over a period longer than 24 hours. Is there an interface or method that makes it possible to query the PSKReporter database for records more than 24 hours old?

I'm aware of possible resource usage implications of a query such as this and don't want to upset any resource-related apple carts. I don't know if it mitigates these but the query would pertain only to spots by a single station.

Thanks for any information.

Cheers

[Philip Gladstone]

What sort of data do you want? Do you want it filtered by a single
sender/receiver or a bulk download?

Philip

[W B McCarty]

I specifically DO NOT want to generate a large volume of rows. Filtering by a single callsign would be a great way to go. I'm basically after spot data: date, time, frequency, mode, callsigns, and grids. Plus distance, bearing, and other derived data that's available. 

I'm trying to monitor spots over an extended period of time. I could monitor a series of 24-hour results. But I've elsewhere learned the hard way that if my database access malfunctions I may not discover the problem until after the data has become available. So I then end up with a hole in my data and have to restart the entire monitoring project. Big ouch!

So the idea is, Accessing a week or a month of data would avoid the problems of failed or forgotten daily access.

To be frank, I'm not immediately sure what I'm doing. I'll have to get my hands on data to be able to think up some study hypotheses and the appropriate statistical treatments. For what it's worth, I'm a PhD-level, trained researcher and computer science professor at a small, private university. But I haven't previously done any work at all in this area. All that means nothing more than that I SHOULD know, or be able to figure out, what it is that I'm doing. The big picture is that, ideally, I'd like to create one or more publishable studies. But there are many other demands on my time and this sort of research is not nearly my top priority. 

If I should be lucky enough to actually manage to create anything credible, I'd be happy to run any submitted manuscripts by you and to offer you full co-authorship, in view of your work in having created and provided access to the database. Since the authors of a paper are listed alphabetically by last name, I only wish that G, for Gladstone, were alphabetically later than M, for McCarty. Would you consider changing your last name to something alphabetically later? jk :-)

Cheers,

[Philip Gladstone]

You can always download the 'logbook' -- this is the set of spots in ADIF form. Alternatively, there is the

https://pskreporter.info/cgi-bin/pskdata.pl?callsign=ABCDEF

this should return the last seven days of data for that callsign. There are various different formats. Try adding &nozip=1 or &adif=1 to the end of the URL.

Let me know how it goes....

Philip

--
You received this message because you are subscribed to the Google Groups "PSK Reporter" group.
To unsubscribe from this group and stop receiving emails from it, send an email to psk-reporter...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.