Terry
Since yesterday's post I have done a bit of work with the ACMA database and here are just a few excerpts from locally generated data files :
Beacons with freq, emission mode, lat, long, location :
VK3RXX,B,10368.432000,T,200HA1A,-37.828787,144.956744,68 Clark St SOUTH MELBOURNE,VIC
VK3RXX,B,1296.530000,T,200HA1A,-37.828787,144.956744,68 Clark St SOUTH MELBOURNE,VIC
VK3RXX,B,2403.432000,T,200HA1A,-37.828787,144.956744,68 Clark St SOUTH MELBOURNE,VIC
VK3RXX,B,3398.432000,T,200HA1A,-37.848606,145.093766,Amateur Site 19 Darling Avenue Camberwell,VIC
VK3RXX,B,5760.432000,T,200HA1A,-37.828787,144.956744,68 Clark St SOUTH MELBOURNE,VIC
VK4RBB,B,10368.440000,T,100HA1A,-27.707811,153.163313,28 Hillside Crescent EDENS LANDING,QLD
VK4RBB,B,10368.440000,T,630HF1DEN,-27.707811,153.163313,28 Hillside Crescent EDENS LANDING,QLD
VK4RBB,B,1296.440000,T,100HA1A,-27.707811,153.163313,28 Hillside Crescent EDENS LANDING,QLD
VK4RBB,B,1296.440000,T,630HF1DEN,-27.707811,153.163313,28 Hillside Crescent EDENS LANDING,QLD
VK4RBB,B,2403.440000,T,100HA1A,-27.707811,153.163313,28 Hillside Crescent EDENS LANDING,QLD
Repeaters with freq, Tx or Rx, emission mode, lat, long, location :
VK2RAY,R,52.700000,R,16K0F9W,-36.022594,146.945887,Albury Wodonga Amateur Radio Club 161 Shaw Street SPRINGDALE HEIGHTS,NSW
VK2RAY,R,53.700000,T,16K0F9W,-36.022594,146.945887,Albury Wodonga Amateur Radio Club 161 Shaw Street SPRINGDALE HEIGHTS,NSW
VK2RAZ,R,433.700000,R,16K0F3E,-34.138707,150.664759,Metwide 2MCR Razorback Mt Prudhoe RAZORBACK RANGE,NSW
VK2RAZ,R,438.700000,T,16K0F3E,-34.138707,150.664759,Metwide 2MCR Razorback Mt Prudhoe RAZORBACK RANGE,NSW
VK2RBA,R,431.837500,R,11K3F9W,-36.924324,149.235232,Walabadah Mawson Street BOMBALA,NSW
VK2RBA,R,438.837500,T,11K3F9W,-36.924324,149.235232,Walabadah Mawson Street BOMBALA,NSW
VK2RBB,R,146.025000,R,16K0F3E,-28.602217,153.435042,Goonengerry Trig Near MULLUMBIMBY,NSW
VK2RBB,R,146.625000,T,16K0F3E,-28.602217,153.435042,Goonengerry Trig Near MULLUMBIMBY,NSW
VK2RBB,R,430.400000,T,16K0F2D,-28.602217,153.435042,Goonengerry Trig Near MULLUMBIMBY,NSW
VK2RBB,R,440.400000,R,16K0F2D,-28.602217,153.435042,Goonengerry Trig Near MULLUMBIMBY,NSW
Operators list by callsign, licence level, name + address, postcode :
**** REMOVED ****
The operators list is a pseudo callbook and just a few lines have been shown above. The total listing is some 14861 entries.
While postcodes could be used as a basis for plotting, the inclusion of PO Boxes defeats that option.
These details are correct as of yesterday. Note the positional info for repeaters (R in 2nd field) and beacons (B in second field) that can be used to create KML files for Google Earth - just haven't written that code as yet (hey, it was only yesterday I started this !) but I have found the structure to generate same..
Per Bo's idea, I also have a world-wide callsign list with grid squares from my FT8 operations and my LogView software but that is mostly 4-char details so not particularly accurate for your purpose :
VK3HGQ,QF33
VK3HY,QF22
VK3IK,QF22
VK3IRM,QF22
VK3JX,QF22
VK3MDH,QF22
VK3MH,QF22
VK3MY,QF22
Currently 3820 unique calls in that grids vs calls data file.
I will continue to work on generating some KMLs in the next week or so, easy to do for the beacons and repeaters lists. The normal operators list remains a challenge.
73 Doug
Terry (et al)
The positional info is derived from postcode/locality data file that centres mainly on postal delivery stuff. I would be very surprised if it was less than 1-2KM in error, and could easily be 5KM or more. It is not based on an individual's address at all, other than locality name.
It is amazing how many entries in the ACMA system data have incorrect locality spelling, postcodes etc. and I have even noted at least one that has the wrong state ID (NT in lieu NSW).
The work on the beacon, repeater and general operator data files has progressed a bit more to the point that is considered nearly complete, and then I can move onto other tasks.
Today I tried it on the browser-based Google Earth and it does work - but takes "many" minutes to paste all of the yellow thumbtacks, just for eg VK4..
The beacon listing now has a grid square detail:
6. Data records processed : 160
VK3RXX,B,3398.432000,T,200HA1A,-37.8,145.0,Amateur Site 19 Darling Avenue Camberwell,VIC,QF22ND
VK3RXX,B,5760.432000,T,200HA1A,-37.8,144.9,68 Clark St SOUTH MELBOURNE,VIC,QF22LE
VK4RBB,B,10368.440000,T,100HA1A,-27.7,153.1,28 Hillside Crescent EDENS LANDING,QLD,QG62NH
VK4RBB,B,10368.440000,T,630HF1DEN,-27.7,153.1,28 Hillside Crescent EDENS LANDING,QLD,QG62NH
Ditto the repeater listing :
6. Data records processed : 3703
VK2RAY,R,438.575000,T,16K0F9W,-36.0,146.9,Albury Wodonga Amateur Radio Club 161 Shaw Street SPRINGDALE HEIGHTS,NSW,QF33LX
VK2RAY,R,52.700000,R,16K0F9W,-36.0,146.9,Albury Wodonga Amateur Radio Club 161 Shaw Street SPRINGDALE HEIGHTS,NSW,QF33LX
VK2RAY,R,53.700000,T,16K0F9W,-36.0,146.9,Albury Wodonga Amateur Radio Club 161 Shaw Street SPRINGDALE HEIGHTS,NSW,QF33LX
VK2RAZ,R,433.700000,R,16K0F3E,-34.1,150.6,Metwide 2MCR Razorback Mt Prudhoe RAZORBACK RANGE,NSW,QF55HU
VK2RAZ,R,438.700000,T,16K0F3E,-34.1,150.6,Metwide 2MCR Razorback Mt Prudhoe RAZORBACK RANGE,NSW,QF55HU
VK2RBA,R,431.837500,R,11K3F9W,-36.9,149.2,Walabadah Mawson Street BOMBALA,NSW,QF43OB
VK2RBA,R,438.837500,T,11K3F9W,-36.9,149.2,Walabadah Mawson Street BOMBALA,NSW,QF43OB
The operator listing has an approx lat/long plus grid square :
7. Data records processed : 14861
**** REMOVED ****
Your location detail comes out as "-35.88,140.05,QF04AC" and you might like to advise how far out that is.
Cheers
Doug