<div dir="ltr">Right... but I don't think the question was related to the "State" field. The question was related to the COUNTRY field... which in DX Spider (not CC Cluster) displays a "State" (actually, the "Primary Administrative Subdivision" which is not based on the USDB.<div><br></div><div>So the real question is... "Why does the Country field show "Illinois" for a station that the USDB shows CA?"</div><div><br></div><div><span style="font-size:12.8000001907349px">CC11^14262.0^W9TVX^</span><br style="font-size:12.8000001907349px"><span style="font-size:12.8000001907349px">5-Apr-2015^2332Z^TEST^W9TVX^</span><span style="font-size:12.8000001907349px">226^226^GB7MBC^8^4^8^4^CA^CA^</span><span style="font-size:12.8000001907349px"><span style="background-color:rgb(255,255,0)">Illinois-K^Illinois-K</span>^CM87^</span><span style="font-size:12.8000001907349px">CM87</span><br></div><div><span style="font-size:12.8000001907349px"><br></span></div><div><span style="font-size:12.8000001907349px">Mike, WA9PIE</span></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Apr 8, 2015 at 1:00 PM, Lee Sawkins <span dir="ltr"><<a href="mailto:ve7cc@shaw.ca" target="_blank">ve7cc@shaw.ca</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><u></u>
<div bgcolor="#ffffff">
<div><font face="Arial">Oops a correction to my correction. I
should have said a KH6 in TX will give a string of TX for the state, not
CA.</font></div>
<blockquote style="BORDER-LEFT:#000000 2px solid;PADDING-LEFT:5px;PADDING-RIGHT:0px;MARGIN-LEFT:5px;MARGIN-RIGHT:0px"><span class="">
<div style="FONT:10pt arial">----- Original Message ----- </div>
<div style="FONT:10pt arial;BACKGROUND:#e4e4e4"><b>From:</b>
<a title="ve7cc@shaw.ca" href="mailto:ve7cc@shaw.ca" target="_blank">Lee Sawkins</a> </div>
<div style="FONT:10pt arial"><b>To:</b> <a title="dxspider-support@dxcluster.org" href="mailto:dxspider-support@dxcluster.org" target="_blank">The DXSpider Support list</a>
</div>
</span><div><div class="h5"><div style="FONT:10pt arial"><b>Sent:</b> Wednesday, April 08, 2015 10:57
AM</div>
<div style="FONT:10pt arial"><b>Subject:</b> Re: [Dxspider-support] Incorrect
User details</div>
<div><br></div>
<div><font face="Arial">The cluster does a USDB lookup for <font color="#ff0000">all</font> US and VE calls. The spotter and dx state
fields for W9TVX are both shown as CA, which is correct. The problem is
the CQ and ITU zones appear to derived from the call prefix. The zone
fields are all wrong. They should be 6 and 3, not 8 and 4 as
shown. The country is also determined by the call prefix. A KH6
in TX will give a CC11 string of CA for the state and Hawaii for the
country and wrong zones. Spots for W4s in FL also give the wrong CQ zone
as Spider thinks all W4s are in CQ zone 4. There are many more US
prefixes where the wrong zones are given.</font></div>
<div><font face="Arial"></font> </div>
<div><font face="Arial">CC11^18074.1^KH6MB^
7-Apr-2015^1637Z^^IK6SNR^112^85^IZ8BRI-2^<font color="#ff0000">61</font>^<font color="#ff0000">31</font>^28^15^<font color="#ff0000">TX</font>^^<font color="#ff0000">Hawaii-KH6</font>^Abruzzo-Marche-I^BL11^JN62</font></div>
<div><font face="Arial"></font> </div>
<div><font face="Arial">Lee VE7CC</font></div>
<blockquote style="BORDER-LEFT:#000000 2px solid;PADDING-LEFT:5px;PADDING-RIGHT:0px;MARGIN-LEFT:5px;MARGIN-RIGHT:0px">
<div style="FONT:10pt arial">----- Original Message ----- </div>
<div style="FONT:10pt arial;BACKGROUND:#e4e4e4"><b>From:</b>
<a title="mike@wa9pie.net" href="mailto:mike@wa9pie.net" target="_blank">Michael Carper</a>
</div>
<div style="FONT:10pt arial"><b>To:</b> <a title="dxspider-support@dxcluster.org" href="mailto:dxspider-support@dxcluster.org" target="_blank">The DXSpider Support list</a>
</div>
<div style="FONT:10pt arial"><b>Sent:</b> Wednesday, April 08, 2015 10:35
AM</div>
<div style="FONT:10pt arial"><b>Subject:</b> Re: [Dxspider-support]
Incorrect User details</div>
<div><br></div>
<div dir="ltr">To be clear... the UCDB 'may be' where the stand-alone STATE
fields in the CC11 string are populated. But the STATE in the COUNTRY
field is certainly not populated that way. I think the information in
the COUNTRY field were at the core of Ian's question.
<div><br></div>
<div>The problem with populating the STATE in the COUNTRY field with USDB
data is that it's US specific. In other words - that field contains
the "Primary Administrative Subdivision" (see <a href="http://www.adif.org" target="_blank">www.adif.org</a>) information for ALL countries -
not just the United States. So correcting this problem with regards to
the COUNTRY field in the CC11 string may cause problems with the way the
"Primary Administrative Subdivision" is populated for 'other
countries'.</div>
<div><br></div>
<div>If I were to make a suggestion...</div>
<div><br></div>
<div>I'd (a) remove the "Primary Administrative Subdivision" from the
COUNTRY field in the CC11 string, have it show only country or country
prefix, and (b) populate the "STATE" fields with the "code" for the "Primary
Administrative Subdivisions" for all countries.</div>
<div><br></div>
<div>Mike, WA9PIE</div></div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Mon, Apr 6, 2015 at 6:50 PM, Mike McCarthy, W1NR
<span dir="ltr"><<a href="mailto:lists@w1nr.net" target="_blank">lists@w1nr.net</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT:#ccc 1px solid;MARGIN:0px 0px 0px 0.8ex;PADDING-LEFT:1ex" class="gmail_quote">Actually, USDB is used for both spotter and spotted
callsigns but I<br>don't think it goes along in the normal PC11 messages
between clusters<br>and is looked up each time from each clusters
database.<br><br>The issue is where the CC11 comes from. I am no expert on
the protocols,<br>but I think CC11 is from a user application. It is
possible that it was<br>derived from an outdated buckmaster database on
some spotters computer.<br><br>Mike, W1NR<br>
<div>
<div><br>On 04/06/2015 06:40 PM, Steve Carroll - AA4U
wrote:<br>> Michael - If what you speak is true, then I have a
suggestion for Dirk...<br>><br>> Both of my DXSpider nodes have the
US Database loaded, which shows the<br>> logged in user (almost
instantaneously) the EXACT state of the spot<br>> originator. Here's an
example [last column]:<br>><br>> DX de W3LPL:
10107.0 VU2GSM Heard in MA<br>>
2225Z MD<br>> DX de KD2FLY: 28120.7 LU2DO
PSK31<br>> 2225Z NY<br>> DX de K0GU:
50101.9 CE2AWW
DN70MQ<>FF47FA in/out<br>> 2226Z CO<br>> DX de
K6ND: 24910.0 ZL7E
QSX 24912.1 559 in MA<br>> 2226Z MA<br>> DX de KD2JA:
24910.0 ZL7E Tnx new
one<br>> 2226Z FL<br>> DX de AD4Z: 50072.0
LU4FM/B 599 in EL95tu<br>> 2226Z FL<br>> DX de
WD4AB: 50110.0 LU5VV
EL95UO<>FE48HI 57<br>> 2227Z FL<br>><br>> The USDB file
comes directly from the FCC database, which shows the<br>> current
'home address on record' for each US amateur. In your example,<br>> the
following data is from the USDB file:<br>><br>> sh/usdb
w9tvx<br>> W9TVX -> Mountain View,
CA<br>>><br>> sh/usdb wa9pie<br>> WA9PIE -> Prosper,
TX<br>><br>> Why couldn't this same lookup process be used to
correctly propagate the<br>> CC11 line in the example?<br>><br>>
Just a thought...<br>><br>> 73, Steve -
AA4U<br>><br>><br>><br>> On 4/6/2015 9:24 AM, Michael Carper
wrote:<br>>> DX Spider doesn't do a "callsign lookup" when it sends
out spots. For<br>>> my friends outside the US, this topic
requires a bit of detail.<br>>><br>>> In the US, there are 10
call areas. Many many years ago, the<br>>> governing body here
in the US (the FCC) forced people to change their<br>>> callsign
when they moved to another call area. But this became an<br>>>
administrative problem for the FCC as the volume of people
relocating<br>>> in this country increased.<br>>><br>>>
SO... here's the current significance of the NUMBER in a US
ham's<br>>> callsign.<br>>> - the number is assigned from the
call area that the person lived when<br>>> they were issued their
first license<br>>> - if they move to another call area, they are
not required to change<br>>> their call.<br>>><br>>> A
nice map of this is<br>>> at <a href="http://en.wikipedia.org/wiki/Amateur_radio_licensing_in_the_United_States" target="_blank">http://en.wikipedia.org/wiki/Amateur_radio_licensing_in_the_United_States</a><br>>><br>>>
SO... what this means for DX Spider...<br>>><br>>> The
"COUNTRY" field in the CC11 string for DX Spider is composed of
a<br>>> "US State" followed by the "Country Prefix". So in
this example, we<br>>> know that W9TVX is in the United States... so
the prefix "K" makes<br>>> sense. But here is what I've
figured out about why it shows as<br>>>
"Illinois".<br>>><br>>> The US Call areas and associated
States are as follows:<br>>> US Call Area 1 -
CT,MA,ME,NH,RI,VT<br>>> US Call Area 2 - NJ,NY<br>>> US Call
Area 3 - DC,DE,MD,PA<br>>> US Call Area 4 -
AL,FL,GA,KY,NC,SC,TN,VA<br>>> US Call Area 5 -
AR,LA,MS,NM,OK,TX<br>>> US Call Area 6 - CA<br>>> US Call Area
7 - AZ,ID,MT,NV,OR,UT,WA,WY<br>>> US Call Area 8 -
MI,OH,WV<br>>> US Call Area 9 - IL,IN,WI<br>>> US Call Area 10
- CO,IA,KS,MN,MO,ND,NE,SD<br>>><br>>> Because clusters do not
do a callsign lookup when sending a spot to<br>>> connected users,
the cluster has no idea which US State the spotted<br>>> station or
spotting station are in.<br>>><br>>> So... what DX Spider does
is use the FIRST US State in alphabetical<br>>> order for a given
callarea and sends the full name of the state.<br>>><br>>> For
example...<br>>><br>>> W9TVX... it's got a "9" in it... the
first US State (alphabetically)<br>>> in the list of States in call
area 9 is "IL"... and that's<br>>> "Illinois"... so let's send that
one! That's why you<br>>> get ^Illinois-K^, even though he's
in California.<br>>><br>>> If you spotted me (WA9PIE), you
would also get ^Illinois-K^, even<br>>> though I live in Texas
now.<br>>><br>>> In reality, the only States that ever get
used are the first ones<br>>> alphabetically - Connecticut, New
Jersey, District-of-Columbia,<br>>> Alabama, Arkansas, California,
Arizona, Michigan, Illinois, and<br>>> Colorado. Regardless of
where the station is actually located, DX<br>>> Spider looks at the
number in the call and grabs from these.<br>>><br>>> Most of
the time, the US State in this field will be incorrect.<br>>> Within
Ham Radio Deluxe, we offer the display of a field that strips<br>>>
off the US State (because people complained about it being
wrong).<br>>><br>>> The only fix for this is to re-code DX
Spider so that the Country<br>>> field no longer has the US State in
it. However...<br>>><br>>> If you look at spots for
other countries, you'll see that it also<br>>> populates "Secondary
Administrative Districts" for other countries<br>>> too... in
Canada, you'll see Provinces and Territories that are<br>>>
incorrect for the same reasons.<br>>><br>>> But anyway... a
long-winded answer. But very complete.<br>>><br>>>
Bottom line is - the inclusion of this information into the
Country<br>>> field is an "estimation" and is not related to any
valid callsign<br>>> lookup information.<br>>><br>>>
Mike, WA9PIE<br>>><br>>> On Mon, Apr 6, 2015 at 3:29 AM, Ian
Maude <<a href="mailto:maudeij@gmail.com" target="_blank">maudeij@gmail.com</a><br></div></div><span>>>
<mailto:<a href="mailto:maudeij@gmail.com" target="_blank">maudeij@gmail.com</a>>>
wrote:<br>>><br>>> Hi
all,<br>>> I have a user who is not being shown
correctly in the cluster. He<br>>> sent me
the output from a test spot he sent..<br>>><br>>>
CC11^14262.0^W9TVX^<br>>>
5-Apr-2015^2332Z^TEST^W9TVX^226^226^GB7MBC^8^4^8^4^CA^CA^Illinois-K^Illinois-K^CM87^CM87<br>>><br>>>
W9TVX is in Mountain View CA and sh/usdb puts him in the
right place.<br>>> This is happening for him even
with a direct telnet to the cluster so<br>>> it
would appear to not be a logging program issue. Any thoughts
would<br>>> be
appreciated.<br>>><br>>> 73
Ian<br>>><br>>>
_______________________________________________<br>>>
Dxspider-support mailing list<br></span>>>
<a href="mailto:Dxspider-support@dxcluster.org" target="_blank">Dxspider-support@dxcluster.org</a>
<mailto:<a href="mailto:Dxspider-support@dxcluster.org" target="_blank">Dxspider-support@dxcluster.org</a>><br>
<div>
<div>>> <a href="http://mailman.tobit.co.uk/mailman/listinfo/dxspider-support" target="_blank">http://mailman.tobit.co.uk/mailman/listinfo/dxspider-support</a><br>>><br>>><br>>><br>>><br>>>
_______________________________________________<br>>>
Dxspider-support mailing list<br>>> <a href="mailto:Dxspider-support@dxcluster.org" target="_blank">Dxspider-support@dxcluster.org</a><br>>>
<a href="http://mailman.tobit.co.uk/mailman/listinfo/dxspider-support" target="_blank">http://mailman.tobit.co.uk/mailman/listinfo/dxspider-support</a><br>><br>><br>><br>>
_______________________________________________<br>> Dxspider-support
mailing list<br>> <a href="mailto:Dxspider-support@dxcluster.org" target="_blank">Dxspider-support@dxcluster.org</a><br>>
<a href="http://mailman.tobit.co.uk/mailman/listinfo/dxspider-support" target="_blank">http://mailman.tobit.co.uk/mailman/listinfo/dxspider-support</a><br>><br><br>_______________________________________________<br>Dxspider-support
mailing list<br><a href="mailto:Dxspider-support@dxcluster.org" target="_blank">Dxspider-support@dxcluster.org</a><br><a href="http://mailman.tobit.co.uk/mailman/listinfo/dxspider-support" target="_blank">http://mailman.tobit.co.uk/mailman/listinfo/dxspider-support</a><br></div></div></blockquote></div><br></div>
<p>
</p><hr>
<p></p>_______________________________________________<br>Dxspider-support
mailing
list<br><a href="mailto:Dxspider-support@dxcluster.org" target="_blank">Dxspider-support@dxcluster.org</a><br><a href="http://mailman.tobit.co.uk/mailman/listinfo/dxspider-support" target="_blank">http://mailman.tobit.co.uk/mailman/listinfo/dxspider-support</a><br><p></p></blockquote>
<p>
</p><hr>
<p></p>_______________________________________________<br>Dxspider-support
mailing
list<br><a href="mailto:Dxspider-support@dxcluster.org" target="_blank">Dxspider-support@dxcluster.org</a><br><a href="http://mailman.tobit.co.uk/mailman/listinfo/dxspider-support" target="_blank">http://mailman.tobit.co.uk/mailman/listinfo/dxspider-support</a><br><p></p></div></div></blockquote></div>
<br>_______________________________________________<br>
Dxspider-support mailing list<br>
<a href="mailto:Dxspider-support@dxcluster.org">Dxspider-support@dxcluster.org</a><br>
<a href="http://mailman.tobit.co.uk/mailman/listinfo/dxspider-support" target="_blank">http://mailman.tobit.co.uk/mailman/listinfo/dxspider-support</a><br>
<br></blockquote></div><br></div>