Thanks Sean for the wonderful GpsTest database, and your series of articles! It's an amazing resource!
A couple thoughts on possible DB improvements.
Recommend adding a column containing an ordered, enumerated list of GPS Navigation message types received (if NAV_MSGS supported). For instance, I'd like to know if a phone actually sends the L5 CNAV message, vs just the LNAV from L1.
With respect to SBAS, if a phone supports one SBAS it should support them all. I totally understand why you're doing it the way you are, because of the various software/firmware lockouts, etc. I was thinking a column for specifics on unexpected behaviors w.r.t. SBAS usage. Like it utilizes EGNOS, but not WAAS or MSAS. This would indicate a software/firmware implemented lock-out, either by PRN (unlikely since PRN assignments change over time) or via the "Service Provider ID" in SBAS Message Type 17.
https://www.gps.gov/technical/prn-codes/
It also might be interesting to understand if the phone is able to process one SBAS service message, and not the other. A MSG Type 27 (EGNOS), but not a 28 (WAAS)....or vice versa. EGNOS' plan as I understand it, is to migrate to utilizing a MSG Type 28 eventually, deprecating its usage of T27 completely.
For SBAS, it would be nice to know if the chipset utilizes SBAS satellites as additional ranging sources, or just as a message provider. I think you mentioned in one of your articles that may not be possible given the current API?
I really like that you included the SBAS carrier frequencies column. I know WAAS is currently broadcasting the same message set on both L1 & L5 on all three GEOs. However the L5 message stream will diverge from L1 in the future when WAAS upgrades to DF operations. Once SBAS's begin sending corrections for Galileo (currently only GPS), I wonder if the API will provide a mechanism for discerning that, or if you'll have to cross-reference against known PRN's.
Thanks again!