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

3219 posts

Uber Geek

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
juha
1319 posts

Uber Geek

Trusted

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

Nice work.




Rickles
2255 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
4891 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
29282 posts

Uber Geek

Moderator
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

3219 posts

Uber Geek

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
29282 posts

Uber Geek

Moderator
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

3219 posts

Uber Geek

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
2255 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
4891 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
29282 posts

Uber Geek

Moderator
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
2255 posts

Uber Geek

Trusted

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

Guys,

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

R.

BarTender

3219 posts

Uber Geek

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

3219 posts

Uber Geek

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 »

Southland-based IT specialist providing virtual services worldwide
Posted 27-Oct-2020 15:55


NASA discovers water on sunlit surface of Moon
Posted 27-Oct-2020 08:30


Huawei introduces new features to Petal Search, Maps and Docs
Posted 26-Oct-2020 18:05


Nokia selected by NASA to build first ever cellular network on the Moon
Posted 21-Oct-2020 08:34


Nanoleaf enhances lighting line with launch of Triangles and Mini Triangles
Posted 17-Oct-2020 20:18


Synology unveils DS16211+
Posted 17-Oct-2020 20:12


Ingram Micro introduces FootfallCam to New Zealand channel
Posted 17-Oct-2020 20:06


Dropbox adopts Virtual First working policy
Posted 17-Oct-2020 19:47


OPPO announces Reno4 Series 5G line-up in NZ
Posted 16-Oct-2020 08:52


Microsoft Highway to a Hundred expands to Asia Pacific
Posted 14-Oct-2020 09:34


Spark turns on 5G in Auckland
Posted 14-Oct-2020 09:29


AMD Launches AMD Ryzen 5000 Series Desktop Processors
Posted 9-Oct-2020 10:13


Teletrac Navman launches integrated multi-camera solution for transport and logistics industry
Posted 8-Oct-2020 10:57


Farmside hits 10,000 RBI customers
Posted 7-Oct-2020 15:32


NordVPN starts deploying colocated servers
Posted 7-Oct-2020 09:00









Geekzone Live »

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


Support Geekzone »

Our community of supporters help make Geekzone possible. Click the button below to join them.

Support Geezone on PressPatron



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.