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.



1327 posts

Uber Geek
+1 received by user: 6

Trusted

Topic # 68691 26-Sep-2010 15:12 Send private message

I've just posted my work of the extracts ouf the RSM Database.  To display the location of all the Cell Sites of all the mobile providers as per what is registered in the RSM Database as KML files that can be used with Google Earth, or Google Maps online.

This doesn't necesarily mean that the telco actually has a transmitter there, it just means they are allowed to transmit from there.

It's based on the new LAT/LONG Geocodes in the RSM Database, so the pin-points should be more accurate than they were before.

Check it out in my blog.




Check out my Mobile Cell Site Google Maps KML Files in my blog.
Now using Google Fusion Tables or Address Lookup or GPS using Smartphone
I update it on a monthly basis automatically from RSM.

Create new topic
482 posts

Ultimate Geek
+1 received by user: 5

Trusted

  Reply # 384620 26-Sep-2010 18:55 Send private message

Awesome.

[Edit: Click the link, dont right-click-and-save-as. Sigh]

:/





2143 posts

Uber Geek
+1 received by user: 162

Trusted
Subscriber

  Reply # 385238 27-Sep-2010 23:28 Send private message

Just checked it out and it looks pretty good around hawkes bay.
A few are off but i suspect this is because of the RSM database.

Eg. At McLean park, napier - the light towers have cell stations ont them. TC's is pinned near the vodafone one and the vodafone is pinned closer to the telecom one so they are around the wrong way. - but its still within 100m so still pretty spot on.

Looking down towards dannivirke, norsewood and out in the country areas around the mahia peninsular, it is really interesting to see how remote some of these cell sites are - although some of these more remote ones were probably placed there because its better suited for the microwave backhaul than its local cell coverage.

So again this is very well done. :-)




Ray Taylor
www.ruralkiwi.com

There is no place like localhost
For my general guide to extending your wireless network Click Here




482 posts

Ultimate Geek
+1 received by user: 5

Trusted

  Reply # 385286 28-Sep-2010 08:23 Send private message

RSM Database should be accurate, so that's a problem for someone :-)

I assume the datum used was correct, and it's not a case of the whole-lot-are-off-by-300m ? :)  (they did look pretty rational to me when I looked around Auckland CBD...)






1327 posts

Uber Geek
+1 received by user: 6

Trusted

  Reply # 385330 28-Sep-2010 09:19 Send private message

BlakJak: RSM Database should be accurate, so that's a problem for someone :-)

I assume the datum used was correct, and it's not a case of the whole-lot-are-off-by-300m ? :)  (they did look pretty rational to me when I looked around Auckland CBD...)


Prior to the Sept 20 RSM Database, they only included the NZGD1949, which was very off and I could never be bothered re-writing LINZ's NZGD1949 -> NZGD2000 in something other than C (Java would have been nice for my purpose).  But now after I asked the RSM folks when they were planning to add the NZGD2000 Lat/Long into their database they did it for me as part of the release.

So.. As accurate as RSM store the location, is as accurate as it's shown.

RSM primarily store the locations in TOPO50 Format with two decimal points of accuracy.

So if you go to Smart, enter in locationid 122340 for Wellington Central Exchange.  You will see that you get given the TOPO50 Location, all the other locations are derrived from that location.




Check out my Mobile Cell Site Google Maps KML Files in my blog.
Now using Google Fusion Tables or Address Lookup or GPS using Smartphone
I update it on a monthly basis automatically from RSM.

3543 posts

Uber Geek
+1 received by user: 854

Trusted

  Reply # 385493 28-Sep-2010 15:02 Send private message

I've been using these, made by another geekzone user. Are these the same as yours?
http://cid-21228dfc4e937fda.skydrive.live.com/browse.aspx/Public/Cellsite%20Locations

509 posts

Ultimate Geek
+1 received by user: 33


  Reply # 385506 28-Sep-2010 15:34 Send private message

eXDee: I've been using these, made by another geekzone user. Are these the same as yours?
http://cid-21228dfc4e937fda.skydrive.live.com/browse.aspx/Public/Cellsite%20Locations


Should be.  I used the same data source (RSM database) and had to do some conversions from NZMG to WGS84 lat/long.  Also my last update was in July, so BarTender's are more recent.

BTW BarTender how do you know which of Telecom's frequencies are CDMA and which are WCDMA in the 850 band?



1327 posts

Uber Geek
+1 received by user: 6

Trusted

  Reply # 385531 28-Sep-2010 16:01 Send private message

wongtop:
eXDee: I've been using these, made by another geekzone user. Are these the same as yours?
http://cid-21228dfc4e937fda.skydrive.live.com/browse.aspx/Public/Cellsite%20Locations


Should be.  I used the same data source (RSM database) and had to do some conversions from NZMG to WGS84 lat/long.  Also my last update was in July, so BarTender's are more recent.

BTW BarTender how do you know which of Telecom's frequencies are CDMA and which are WCDMA in the 850 band?


The advantage of putting them on a google site is you can link to them externally and load them up in Google Maps, your kml's you needed to download and then load up into Google Earth.

And to answer the question of CDMA vs WCDMA 850, CDMA is 875 or or 875.01, and you notice they were registered back in 1995, the WCDMA XT Frequency 882.5Mhz was registered in 2008.

If you check out locationid = 577 = HAWERA WATER TOWER

Licensee                135877     TELECOM MOBILE LIMITED
Licence ID               45675    
Commencement           01-Sep-1995
Expiry                       08-Sep-2012

Licensee                135877     TELECOM MOBILE LIMITED
Licence ID             122534    
Commencement           25-Jul-2008
Expiry                       29-Oct-2012

The Commencement date was a dead giveaway for me.




Check out my Mobile Cell Site Google Maps KML Files in my blog.
Now using Google Fusion Tables or Address Lookup or GPS using Smartphone
I update it on a monthly basis automatically from RSM.

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 »

Trending now »
Hot discussions in our forums right now:

Hierarchy of a mistake: Gerry Brownlee
Created by joker97, last reply by nathan on 26-Jul-2014 04:30 (68 replies)
Pages... 3 4 5


Geekzone giveaway: Thecus N2310 NAS
Created by freitasm, last reply by ottenpat on 25-Jul-2014 21:15 (89 replies)
Pages... 4 5 6


MH 17 "shot down" all dead
Created by joker97, last reply by ScuL on 24-Jul-2014 21:40 (203 replies)
Pages... 12 13 14


Huge Fuss, didn't even make it a year.
Created by networkn, last reply by Glassboy on 22-Jul-2014 19:50 (121 replies)
Pages... 7 8 9


Is chorus going to deliberately slow adsl internet down
Created by rugrat, last reply by juha on 26-Jul-2014 14:25 (54 replies)
Pages... 2 3 4


Skinny's new aggressive ad campaign
Created by Yabanize, last reply by Yabanize on 22-Jul-2014 23:35 (52 replies)
Pages... 2 3 4


Pursuing someone who owes money - What to do?
Created by TimA, last reply by insane on 26-Jul-2014 16:48 (16 replies)
Pages... 2


Sickening floral smell in car, What next?
Created by TimA, last reply by Athlonite on 26-Jul-2014 14:42 (48 replies)
Pages... 2 3 4



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.