Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.


BarTender

3409 posts

Uber Geek

ID Verified
Trusted
Lifetime subscriber

#11304 15-Jan-2007 12:45
Send private message

Hello

I think a number of you will be interested but I found a fantastic page http://spectrumonline.med.govt.nz/ which details all companies who have a registered radio frequency in NZ, plus the frequencies etc.

In there there is the "Spectrum Search Lite" which is an access database that has every transmitter that is registered with them.  Plus the Lat/Long in different tables.  After a bit of fun with Access I extracted out what I wanted.

So I extracted all the 2067.5Mhz registered frequencies (which is what Woosh uses) and matched them up against the Lat/Long so now I have a list of every location that there is a transmiter, built a quick and dirty Google Maps page with the results.

To be found at: http://wooshinfo.googlepages.com/locations.html

If there are better google maps person out that that could write nicer code I would love to see it.

Thanks

Peter
 
(moderator edit (BG) - Added hyperlinks)




and


View this topic in a long page with up to 500 replies per page Create new topic
 1 | 2
Affiliate link
 
 
 

Affiliate link: Trade NZ and US shares and funds with Sharesies.
juha
1319 posts

Uber Geek

Trusted

  #57949 15-Jan-2007 15:49
Send private message

Nice work.




Rickles
2441 posts

Uber Geek

Trusted

  #57953 15-Jan-2007 16:32
Send private message

BarTender,

   Brilliant, well done.

R.

xrajux
111 posts

Master Geek


#57958 15-Jan-2007 16:57
Send private message

good work man, cheers



ajobbins
Awesome
5050 posts

Uber Geek

Trusted
Subscriber

  #57980 15-Jan-2007 20:30
Send private message

Wow, thats cool. The list doesnt appear to be complete tho as I know of one tower that wasnt on the list.

Maybe some of them operate on a slightly different frequency, or maybe they decomissioned the one I am referring to




Twitter: ajobbins


sbiddle
30853 posts

Uber Geek

Retired Mod
Trusted
Biddle Corp
Lifetime subscriber

  #57986 15-Jan-2007 21:47
Send private message

adamj: Wow, thats cool. The list doesnt appear to be complete tho as I know of one tower that wasnt on the list.

Maybe some of them operate on a slightly different frequency, or maybe they decomissioned the one I am referring to


While the PRISM database is supposed to be accurate there are issues with inaccuracies in it. There are Vodafone sites listed that don't exist, Vodafone sites that do exist that aren't listed and some of the newer Woosh sites in Wellington aren't yet in the database.


BarTender

3409 posts

Uber Geek

ID Verified
Trusted
Lifetime subscriber

  #57990 15-Jan-2007 22:16
Send private message

I just hope that woosh themselves will some day release a detailed list of sites.

Working with a friend of mine to put the sites through SPLAT (http://www.qsl.net/kd2bd/splat.html) for Path Loss Analysis and link to each cell site with signal strength information to know if people should get a booster or not etc.

Also plan to add GPolygons for all the microwave links that Woosh sites as well.

The other issue with the Prism DB is that all the Latitude/Longitude locations are calulations from the NZMS260 Grid references and not exact locations.

Any additional sites people know about just post the grid refs and I will add them.




and


sbiddle
30853 posts

Uber Geek

Retired Mod
Trusted
Biddle Corp
Lifetime subscriber

  #57991 15-Jan-2007 22:22
Send private message

Ever thought of doing another version for for Voda & Telecom? Would obvously require only minor changes!



BarTender

3409 posts

Uber Geek

ID Verified
Trusted
Lifetime subscriber

  #58007 16-Jan-2007 07:00
Send private message

Dude, you are way ahead of me.

Yes I was planning to include Voda/TNZ/Other wireless providers.

Once I figure out layers with Google Maps then it can be a single page and you can turn on / off / have different colours for different providers / different colours for AMPS,DAMPS, 1xRTT, EV-DO, GSM, GPRS, HSPRD, IP Wireless etc...

For the interium I just plan different pages for TNZ/Voda.. and take it from there.

Need to find someone understands the Google Maps API more than I.




and


Rickles
2441 posts

Uber Geek

Trusted

  #58029 16-Jan-2007 10:36
Send private message

BarTender,

   Whilst something is better than nothing Wink, I'm in Thorndon, Wellington using Base Station 12 ... the map tends to indicate that the transmitter is somewhere opposite the Portland Hotel, which would be St Mary's College. 

To my knowledge, the transmitter is actually in the middle of the Hawkestone Street overbridge.

R.

ajobbins
Awesome
5050 posts

Uber Geek

Trusted
Subscriber

  #58032 16-Jan-2007 10:46
Send private message

Rickles: the map tends to indicate that the transmitter is somewhere opposite the Portland Hotel, which would be St Mary's College. 

To my knowledge, the transmitter is actually in the middle of the Hawkestone Street overbridge.


BarTender: The other issue with the Prism DB is that all the Latitude/Longitude locations are calulations from the NZMS260 Grid references and not exact locations.


The Portland Hotel is on Hawkestone St Rickles, so if the map is indicating opposite this is a pretty close match considering BarTenders reference above.




Twitter: ajobbins


sbiddle
30853 posts

Uber Geek

Retired Mod
Trusted
Biddle Corp
Lifetime subscriber

  #58033 16-Jan-2007 10:48
Send private message

Rickles: BarTender,

   Whilst something is better than nothing Wink, I'm in Thorndon, Wellington using Base Station 12 ... the map tends to indicate that the transmitter is somewhere opposite the Portland Hotel, which would be St Mary's College. 

To my knowledge, the transmitter is actually in the middle of the Hawkestone Street overbridge.

R.


That's a Vodafone panel on the bridge. The Woosh site is actually on the hotel. If you look towards the roof you'll see the panels.


Rickles
2441 posts

Uber Geek

Trusted

  #58110 16-Jan-2007 19:43
Send private message

Guys,

   Thanks for the comments ... all noted and appreciated.

R.

BarTender

3409 posts

Uber Geek

ID Verified
Trusted
Lifetime subscriber

  #58137 16-Jan-2007 22:43
Send private message

Two things to bear in mind when thinking about the Google Maps links.
1) The Lat/Long that is calulated in the Prism Database is only an estimate as per the NZMS260 Grid Reference, which I think is ~+-20 meters or something silly like that.

2)Google Earth doesn't exacly match up to the Lat/Long co-ordinates all the time either.  Anyone taken a GPS to certain points of interest in NZ and tried to match up those references to Google Earth will also be sadly disapointed by the +-3-5 meters that the map can be out simetimes.

Anyone (who is based in Wellington like me) remember when WCC supplied VERY VERY poor quality imagery to Google Earth back around mid July 06 or so and noticed how all the grid references moved by about 2 meters... <sigh>.  It's all very much an estimate really.

Here is a good example how Google Earth "match" up two different sets of aerial / satelite photography.  The bottom imagery is from WCC and is out of focus and flown from a plane, whereas the top imagery is from Digital Globe taken by a satelite......

http://maps.google.com/maps?f=q&hl=en&q=apple+terrace,+wellington,+new+zealand&sll=37.0625,-95.677068&sspn=28.749334,57.65625&ie=UTF8&z=17&ll=-41.146467,174.845256&spn=0.003329,0.010557&t=h&om=1

But looking at the Aerial shot of Portland towers I can't see where the dish/panels are, if anyone has correct co-ords I will update that site.

http://www.wellington.govt.nz/services/rates/search/popup.php?type=map&account=1120028

The WCC Aerial shots for Rates (which is different than the photography that the WCC provided to Google Earth <sigh>) are the most up to date (think they were flown late 04/early 05) and don't show anything I can see on the roof.






and


paradoxsm
3000 posts

Uber Geek

Trusted

  #58144 17-Jan-2007 00:40
Send private message

Very good! Great info! I could never get the "spectrum search lite" to work. I just get a "cannot open previous database version"



How did you place the html page directly in googlepages by the way? i can only seem to select from the google "pagewizards"





also..... Does anyone still have about a copy of the old (deprecated) "prisms lite"

BarTender

3409 posts

Uber Geek

ID Verified
Trusted
Lifetime subscriber

  #59988 7-Feb-2007 12:40
Send private message

The Prism database is just an Access 97 Database, so you can easily open it up with access 97 or higher and do with it what you want, perhaps you are running some other version of access on your PC which is causing the conflict with Spectrum search lite.

On the googlepages all I did was upload the HTML file I wrote in notepad, plus the XML file with all the locations using the upload file thingie and then just linked to that page.

Busy renovating the house, when that is done I plan to use Google maps to draw lines between the uplink and downlink sites, and as we all know the info in Prism doesn't necessarily reflect reality.

Now if Woosh were smart they would install transmitters in popular holiday destinations such as queenstown / Ohakune / wherever so us lowly sorts that spend 3 weeks or whatever in a location we don't normally live in can get highspeed internet without needing to pay premium dollar to Vodafone/TNZ card and can continue to have highspeed internet.

I think they would pick up a lot of new customers as well by saying "we are in these popular locations as well so you don't need to be without the internet while on holiday".




and


 1 | 2
View this topic in a long page with up to 500 replies per page Create new topic





News and reviews »

D-Link G415 4G Smart Router Review
Posted 27-Jun-2022 17:24


New Zealand Video Game Sales Reaches $540 Million
Posted 26-Jun-2022 14:49


Github Copilot Generally Available to All Developers
Posted 26-Jun-2022 14:37


Logitech G Introduces the New Astro A10 Headset
Posted 26-Jun-2022 14:20


Fitbit introduces Sleep Profiles
Posted 26-Jun-2022 14:11


Synology Introduces FlashStation FS3410
Posted 26-Jun-2022 14:04


Intel Arc A380 Graphics First Available in China
Posted 15-Jun-2022 17:08


JBL Introduces PartyBox Encore Essential Speaker
Posted 15-Jun-2022 17:05


New TVNZ+ streaming brand launches
Posted 13-Jun-2022 08:35


Chromecast With Google TV Review
Posted 10-Jun-2022 17:10


Xbox Gaming on Your Samsung Smart TV No Console Required
Posted 10-Jun-2022 00:01


Xbox Cloud Gaming Now Available in New Zealand
Posted 10-Jun-2022 00:01


HP Envy Inspire 7900e Review
Posted 9-Jun-2022 20:31


Philips Hue Starter Kit Review
Posted 4-Jun-2022 11:10


Sony Expands Its Wireless Speaker X-series Range
Posted 4-Jun-2022 10:25









Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.



Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.