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.


2383 posts

Uber Geek
+1 received by user: 797

Trusted
Lifetime subscriber

Topic # 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)





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

Uber Geek
+1 received by user: 5

Trusted
Subscriber

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

Nice work.




1790 posts

Uber Geek
+1 received by user: 126


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

BarTender,

   Brilliant, well done.

R.

111 posts

Master Geek


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

good work man, cheers

Awesome
4805 posts

Uber Geek
+1 received by user: 1061

Trusted
Subscriber

  Reply # 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


26772 posts

Uber Geek
+1 received by user: 6249

Moderator
Trusted
Biddle Corp
Lifetime subscriber

  Reply # 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.




2383 posts

Uber Geek
+1 received by user: 797

Trusted
Lifetime subscriber

  Reply # 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.





26772 posts

Uber Geek
+1 received by user: 6249

Moderator
Trusted
Biddle Corp
Lifetime subscriber

  Reply # 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!



2383 posts

Uber Geek
+1 received by user: 797

Trusted
Lifetime subscriber

  Reply # 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.





1790 posts

Uber Geek
+1 received by user: 126


  Reply # 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.

Awesome
4805 posts

Uber Geek
+1 received by user: 1061

Trusted
Subscriber

  Reply # 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


26772 posts

Uber Geek
+1 received by user: 6249

Moderator
Trusted
Biddle Corp
Lifetime subscriber

  Reply # 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.


1790 posts

Uber Geek
+1 received by user: 126


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

Guys,

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

R.



2383 posts

Uber Geek
+1 received by user: 797

Trusted
Lifetime subscriber

  Reply # 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.







3000 posts

Uber Geek

Trusted

  Reply # 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"



2383 posts

Uber Geek
+1 received by user: 797

Trusted
Lifetime subscriber

  Reply # 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".





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

Twitter »

Follow us to receive Twitter updates when new discussions are posted in our forums:



Follow us to receive Twitter updates when news items and blogs are posted in our frontpage:



Follow us to receive Twitter updates when tech item prices are listed in our price comparison site:





News »

Intel introduces new NUC kits and NUC mini PCs
Posted 16-Aug-2018 11:03


The Warehouse leaps into the AI future with Google
Posted 15-Aug-2018 17:56


Targus set sights on enterprise and consumer growth in New Zealand
Posted 13-Aug-2018 13:47


Huawei to distribute nova 3i in New Zealand
Posted 9-Aug-2018 16:23


Home robot Vector to be available in New Zealand stores
Posted 9-Aug-2018 14:47


Panasonic announces new 2018 OLED TV line up
Posted 7-Aug-2018 16:38


Kordia completes first live 4K TV broadcast
Posted 1-Aug-2018 13:00


Schools get safer and smarter internet with Managed Network Upgrade
Posted 30-Jul-2018 20:01


DNC wants a safer .nz in the coming year
Posted 26-Jul-2018 16:08


Auldhouse becomes an AWS Authorised Training Delivery Partner in New Zealand
Posted 26-Jul-2018 15:55


Rakuten Kobo launches Kobo Clara HD entry level reader
Posted 26-Jul-2018 15:44


Kiwi team reaches semi-finals at the Microsoft Imagine Cup
Posted 26-Jul-2018 15:38


KidsCan App to Help Kiwi Children in Need
Posted 26-Jul-2018 15:32


FUJIFILM announces new high-performance lenses
Posted 24-Jul-2018 14:57


New FUJIFILM XF10 introduces square mode for Instagram sharing
Posted 24-Jul-2018 14:44



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.

Alternatively, you can receive a daily email with Geekzone updates.