How to plot WSPR sumary data by maidenhead gridsquare?

[Vincent Leveque]

I want to plot summary WSPR data by grid square for North America, such as  SNR, and number of observations per grid square.

I found an Excel spreadsheet that I adapted for my use but it is very clumsy looking and does not include state boundaries or major cites:

I've briefly reviewed some alternatives such as Arcinfo and Google maps, but they all seem to require a paid subscription.  I haven't found anything with Maidenhead grid squares pre-defined for thematic mapping.

Does such a thing exist?  Has anyone done this before?  Ideally, I would just like to plug in a list of grid squares and the data for each and let the mapping software handle everything else.

I'm willing to pay a subscription fee if I can be assured the mapping software meets my need.

[Rob Robinett]

Check out the many wspr.live graph pages like this one:  https://wspr.live/gui/d/TZTyor97k/general-wspr-statistics?orgId=1&from=now-7d&to=now&timezone=browser&refresh=1m

--
Please follow the HamSCI Community Participation Guidelines at http://hamsci.org/hamsci-community-participation-guidelines.
---
You received this message because you are subscribed to the Google Groups "HamSCI" group.
To unsubscribe from this group and stop receiving emails from it, send an email to hamsci+un...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/hamsci/2aa5398b-e87d-42c2-a18e-45f04f9ecb66n%40googlegroups.com.

--

Rob Robinett

AI6VN

r...@robinett.us

mobile: +1 650 218 8896

[Vincent Leveque]

Those are some very nice pre-defined graphics. However, I'd like to plot my own data by gridsquare.  Is there anything that allows this?

[Tom Talley]

could you ask alpha ...

Tom Talley

Progress every day...even if just a little...

is a good thing...!

To view this discussion visit https://groups.google.com/d/msgid/hamsci/6bb29ce2-8f5e-475b-b204-646e3897d0acn%40googlegroups.com.

[Architect of the Risk Flux Framework]

Can you provide the structure of the data?

I use R, and I push the data into an R data table. I am assuming your data has a date variable and a bunch of numeric ones.  

R has a package called "rworldmap", which does the aggregation of the data at the state-level or country-level, and then it maps the aggregated data to the map, either at the full country level or at the subdivisions you define -in your case, it seems state-level.  The density of aggregated values at the state level will be given a color gradient to reflect the variability and density of data at that location.

If you share the data, we will be able to tell you more. 

Other than that, you need to create gridded bins defined by latitude and longitude, and then aggregate and map your data onto these lat/lon bins.

Hope this helps.

 

Warm regards,

Lawrence Habahbeh

Architect of the Risk Flux Framework

--

[Vincent Leveque]

The summary data has a gridquare variable and aggregates/averages of other variables:

In this case, I have the 4-char gridsquare designation, the total number of transmissions received by station KPH (near San Francisco), the total transmissions from the gridsquare, and the fraction received by KPH.

Maidenhead gridsquares do not map to counties or states.  They overlay counties and states, but do not align to them

[Architect of the Risk Flux Framework]

How is the grid square defined?

So your receiving station is KPH, and the fraction of all transmissions from gridsquere(i) -----> KPH is the KPHCount/AllCount 
Do you have any geographic data on the transmission stations? location that can be transformed into lon/lat coordinates?

Warm regards,

Lawrence Habahbeh

Architect of the Risk Flux Framework

To view this discussion visit https://groups.google.com/d/msgid/hamsci/3e7c2ac8-9fa6-41c0-8bcd-cd9f24d67c40n%40googlegroups.com.

[vincent....@gmail.com]

The Maidenhead grid square is provided in the WSPR data for each transmitting station.  Detailed data on WSPR information format is supposed to be available at http://physics.princeton.edu/pulsar/K1JT/ but that site is no longer available.

 

Wikipedia has an excellent article on it at : https://en.wikipedia.org/wiki/Maidenhead_Locator_System . This describes how the grid square is defined.

 

This gridsquare is a very convenient geographic unit for platting data.  Converting the gridsquare to lat/long would not give me any more precision.  WSPR does not have any more precise data on the location of the transmitting station other than gridsquare

 

From: 'Architect of the Risk Flux Framework' via HamSCI <ham...@googlegroups.com>
Sent: Tuesday, May 5, 2026 07:26 PM
To: ham...@googlegroups.com
Subject: Re: [HamSCI] How to plot WSPR sumary data by maidenhead gridsquare?

 

How is the grid square defined?

 

So your receiving station is KPH, and the fraction of all transmissions from gridsquere(i) -----> KPH is the KPHCount/AllCount 
Do you have any geographic data on the transmission stations? location that can be transformed into lon/lat coordinates?

 

 

Warm regards,

Lawrence Habahbeh

Architect of the Risk Flux Framework

On Wednesday, May 6th, 2026 at 4:56 AM, Vincent Leveque <vincent....@gmail.com> wrote:

The summary data has a gridquare variable and aggregates/averages of other variables:

 

 

In this case, I have the 4-char gridsquare designation, the total number of transmissions received by station KPH (near San Francisco), the total transmissions from the gridsquare, and the fraction received by KPH.

 

Maidenhead gridsquares do not map to counties or states. They overlay counties and states, but do not align to them

 

On Tuesday, May 5, 2026 at 6:37:31 PM UTC-7 Architect of the Risk Flux Framework wrote:

Can you provide the structure of the data?

I use R, and I push the data into an R data table. I am assuming your data has a date variable and a bunch of numeric ones.

 

R has a package called "rworldmap", which does the aggregation of the data at the state-level or country-level, and then it maps the aggregated data to the map, either at the full country level or at the subdivisions you define -in your case, it seems state-level. The density of aggregated values at the state level will be given a color gradient to reflect the variability and density of data at that location.

 

If you share the data, we will be able to tell you more.

 

Other than that, you need to create gridded bins defined by latitude and longitude, and then aggregate and map your data onto these lat/lon bins.

 

Hope this helps.

 

Warm regards,

Lawrence Habahbeh

Architect of the Risk Flux Framework

 

On Tuesday, May 5th, 2026 at 8:29 PM, Vincent Leveque <vincent....@gmail.com> wrote:

I want to plot summary WSPR data by grid square for North America, such as SNR, and number of observations per grid square.

 

 

I found an Excel spreadsheet that I adapted for my use but it is very clumsy looking and does not include state boundaries or major cites:

 

I've briefly reviewed some alternatives such as Arcinfo and Google maps, but they all seem to require a paid subscription. I haven't found anything with Maidenhead grid squares pre-defined for thematic mapping.

 

Does such a thing exist? Has anyone done this before? Ideally, I would just like to plug in a list of grid squares and the data for each and let the mapping software handle everything else.

 

I'm willing to pay a subscription fee if I can be assured the mapping software meets my need.

--

Please follow the HamSCI Community Participation Guidelines at http://hamsci.org/hamsci-community-participation-guidelines.
---
You received this message because you are subscribed to the Google Groups "HamSCI" group.
To unsubscribe from this group and stop receiving emails from it, send an email to hamsci+un...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/hamsci/2aa5398b-e87d-42c2-a18e-45f04f9ecb66n%40googlegroups.com.

--
Please follow the HamSCI Community Participation Guidelines at http://hamsci.org/hamsci-community-participation-guidelines.
---
You received this message because you are subscribed to the Google Groups "HamSCI" group.
To unsubscribe from this group and stop receiving emails from it, send an email to hamsci+un...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/hamsci/3e7c2ac8-9fa6-41c0-8bcd-cd9f24d67c40n%40googlegroups.com.

--
Please follow the HamSCI Community Participation Guidelines at http://hamsci.org/hamsci-community-participation-guidelines.
---

You received this message because you are subscribed to a topic in the Google Groups "HamSCI" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/hamsci/ylgBgV_ieqw/unsubscribe.
To unsubscribe from this group and all its topics, send an email to hamsci+un...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/hamsci/9xkwvu_cMWT6ctSJjNp-Y_thuLnDjc0zL6_bNtmtkYRXEUiWPZEz048gTcpM_vfy_G5ezQr0_0v8KUmk3CCwON6DxSobSRy5yEdXCWawR5M%3D%40pm.me.

[Rob Robinett]

if you can't find what you want among the operators pages, ask him for what you want

To view this discussion visit https://groups.google.com/d/msgid/hamsci/6bb29ce2-8f5e-475b-b204-646e3897d0acn%40googlegroups.com.

[Architect of the Risk Flux Framework]

I had a quick look, and this is more involved because you have to get the field for your data, and then look at the 100 squares in that field, and then you need the information on the coding of each transmission. The 6-digit grid square is more precise than the 4-digit grid of the coding BL11BH16" in each square in the field. Then extract the information from each 6-digit grid coding in each square from this string to give you more accurate location information, so that you can do the aggregation and mapping to the information in the coding instead of just the lon/lat variable.

Warm regards,

Lawrence Habahbeh

Architect of the Risk Flux Framework

To view this discussion visit https://groups.google.com/d/msgid/hamsci/1e3301dcdd01%24d4c5f080%247e51d180%24%40gmail.com.

[Jim Willis]

From: Jim Willis <jimwi...@gmail.com>
Sent: Wednesday, May 6, 2026 3:04 AM
To: ham...@googlegroups.com <ham...@googlegroups.com>
Subject: Re: [HamSCI] How to plot WSPR summary data by maidenhead gridsquare?

I have an EXCEL spreadsheet that plots WSPR data by maidenhead grid square. Link:  AZIMUTHAL projection UNIQUE HD8G DXpedition.xlsx.

It is a little complicated to use but if you have experience with EXCEL, it is manageable. 

Best regards,

Jim KG6TW

---

From: 'Architect of the Risk Flux Framework' via HamSCI <ham...@googlegroups.com>

Sent: Tuesday, May 5, 2026 8:13 PM
To: ham...@googlegroups.com <ham...@googlegroups.com>
Subject: RE: [HamSCI] How to plot WSPR sumary data by maidenhead gridsquare?

To view this discussion visit https://groups.google.com/d/msgid/hamsci/BVUlzq17vcQr9L8DMFi1D8l4Qy_1PgzPM1PQNWxBvyELaE88sAk205WeM3D9oq2gKl-ATiWW0rT4o0VdXIYBlSm5N4ZLqTWFM2qnKYgEkas%3D%40pm.me.

[Vincent Leveque]

Jim,

The Excel spreadsheet looks very useful.

I will see if I can adapt it.

Vince