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.

View this topic in a long page with up to 500 replies per page Create new topic
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
1312 posts

Uber Geek

Trusted

  Reply # 486909 28-Jun-2011 14:49 Send private message

Ok.

I've uploaded my whole end-to-end Process of creating the KMLs 7.7MB Zip file, if you want a copy just PM me :).

It needs Java to run as I am using Saxon and mdb2sqlite.  It's pretty much written for Windows but would be very easy to port over to Linux due to most of it being java based.

Also done a new extract out for the new 2Degrees Sites in Wanganui and Palmy.

KML and Google Maps

Also updated my Blog with the latest and greatest from RSM as of 20 June, which is the date of the file.

Enjoy!




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.



1716 posts

Uber Geek
+1 received by user: 80

Trusted

  Reply # 487027 28-Jun-2011 17:20 Send private message

Don't forget Hawkes Bay is on the list to get towers also :)

1312 posts

Uber Geek

Trusted

  Reply # 487057 28-Jun-2011 18:34 Send private message

DjShadow: Don't forget Hawkes Bay is on the list to get towers also :)


Nothing registered there I could see as part of my export.  Taupo however had some sites as per the above KML.




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.



1716 posts

Uber Geek
+1 received by user: 80

Trusted

  Reply # 487074 28-Jun-2011 19:22 Send private message

Where do you edit the query to find all the 2D backhaul frequencies?

1312 posts

Uber Geek

Trusted

  Reply # 487117 28-Jun-2011 20:31 Send private message

DjShadow: Where do you edit the query to find all the 2D backhaul frequencies?


If you look in SQL\2-2Degrees.SQL that's the reduced query as the two below bolded items removed from the main SQL\2-ExportCSV.SQL


SELECT "2DEG900",T1.locationid,T1.licenceid,L2.locationname,G1.easting,G1.northing,L1.Licencecode,S1.frequency
FROM clientname C1,geographicreference G1,licence L1,location L2,transmitconfiguration T1,spectrum S1
WHERE C1.name like 'TWO DEG%' and L1.Licencecode like 'S%' and S1.frequency like '9%' and G1.georeferencetypeid = '3' and C1.clientid=L1.clientid AND T1.licenceid=L1.licenceid AND S1.licenceid=L1.licenceid AND T1.locationid=L2.locationid AND G1.locationid=T1.locationid;

The L1.Licensecode is used to restrict which type of license, SZ are the transmitter sites, FR is a point-to-point microwave link.

S1.frequency is the transmission frequency, 9% are all the 9xx Mhz ranges.

So the where doesn't need to restrict the transmission freq's to 9* and only be broadcast transmitting sites.

So if you did at step 2:

bin\sqlite3 1-DB\prism.db3 < SQL\2-2Degrees.SQL

instead of.

2-ExportCSV.bat

However after the 2-CSV\DataDump.csv has been created you need to do a search through it, as there was a special character which for some reason made the file not get properly processed.

45 ORORKE ROAD (AKL-007-114-D)

Needs to change to

45 O'RORKE ROAD (AKL-007-114-D)

Then it should process fine, and you can easily remove the lines you don't care about.  You will see that from License ID 43208 starts from the newer ones.

Then it should process from step 3 onwards.




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.

3402 posts

Uber Geek
+1 received by user: 800

Trusted

  Reply # 487213 29-Jun-2011 00:04 Send private message

You are awesome bartender! Much appreciated!

1825 posts

Uber Geek
+1 received by user: 43


  Reply # 487389 29-Jun-2011 12:30

BarTender: Ok.

I've uploaded my whole end-to-end Process of creating the KMLs 7.7MB Zip file, if you want a copy just PM me :).

It needs Java to run as I am using Saxon and mdb2sqlite.  It's pretty much written for Windows but would be very easy to port over to Linux due to most of it being java based.

Also done a new extract out for the new 2Degrees Sites in Wanganui and Palmy.

KML and Google Maps

Also updated my Blog with the latest and greatest from RSM as of 20 June, which is the date of the file.

Enjoy!


Is that list just the new sites which are to be built or which are already built? 




Digital Recruitment Consultant - UXD, Service Design, Front-end dev & pretty much anything creative in the digital space. Follow me on Twitter

3402 posts

Uber Geek
+1 received by user: 800

Trusted

  Reply # 487399 29-Jun-2011 13:13 Send private message

Its the sites which are licensed, so you can't tell if they are built or not.

Though generally if you can see the backhaul microwave links but not the actual cell broadcasts on 900/2100mhz it means the tower is not completed but is somewhere between planning and being turned on. At least this is how it appeared to be for 2deg in hamilton.

1825 posts

Uber Geek
+1 received by user: 43


  Reply # 487401 29-Jun-2011 13:27

eXDee: Its the sites which are licensed, so you can't tell if they are built or not.

Though generally if you can see the backhaul microwave links but not the actual cell broadcasts on 900/2100mhz it means the tower is not completed but is somewhere between planning and being turned on. At least this is how it appeared to be for 2deg in hamilton.


I see, it's good to see they got consent for Palmy, last I heard was the council wasn't allowing any new tower construction. Unless its all co-lo. 




Digital Recruitment Consultant - UXD, Service Design, Front-end dev & pretty much anything creative in the digital space. Follow me on Twitter

234 posts

Master Geek
+1 received by user: 3


  Reply # 487452 29-Jun-2011 15:20 Send private message

SteveON:
eXDee: Its the sites which are licensed, so you can't tell if they are built or not.

Though generally if you can see the backhaul microwave links but not the actual cell broadcasts on 900/2100mhz it means the tower is not completed but is somewhere between planning and being turned on. At least this is how it appeared to be for 2deg in hamilton.


I see, it's good to see they got consent for Palmy, last I heard was the council wasn't allowing any new tower construction. Unless its all co-lo. 


Yeah I mean, you wouldn't want to ugly up the place now would ya? :)

1312 posts

Uber Geek

Trusted

  Reply # 487541 29-Jun-2011 19:57 Send private message

PottsyNZ:
SteveON:
eXDee: Its the sites which are licensed, so you can't tell if they are built or not.

Though generally if you can see the backhaul microwave links but not the actual cell broadcasts on 900/2100mhz it means the tower is not completed but is somewhere between planning and being turned on. At least this is how it appeared to be for 2deg in hamilton.


I see, it's good to see they got consent for Palmy, last I heard was the council wasn't allowing any new tower construction. Unless its all co-lo. 


Yeah I mean, you wouldn't want to ugly up the place now would ya? :)


Better go keeping Palmy all nicey nice eh.  The seething metropolis that is.....

Not sure if they are co-lo or not.  When I was talking to the MED RSM folks they told me that they often created new location id's when some operators co-lo.  Other times they use the same id.

So it might be pretty hard to figure out which sites are co-lo's and which one's aren't.




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.

DS9

255 posts

Ultimate Geek


  Reply # 487681 30-Jun-2011 09:14 Send private message

I have no idea if they are going live soon but this morning I had no signal, so I did a manual search and found Vodafone and NZL 24. Though the phone would only connect to Vodafone.

168 posts

Master Geek
+1 received by user: 2


  Reply # 489852 5-Jul-2011 22:52 Send private message

Probably a really dumb question considering the size of this town etc. But i wondered if Masterton was included in any of 2Degrees new plans for cell site building etc.....?

3402 posts

Uber Geek
+1 received by user: 800

Trusted

  Reply # 490169 6-Jul-2011 17:24 Send private message

Check bartenders maps above for yourself. I believe not.

239 posts

Master Geek
+1 received by user: 1


  Reply # 491060 8-Jul-2011 13:22 Send private message

Does any one know if they're planning any towers in the south island other than the ones in Christchurch or queenstown?

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
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 new jobs are posted to our jobs board:



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:

Telecom introduces unlimited broadband data plan
Created by freitasm, last reply by NonprayingMantis on 23-Apr-2014 23:13 (93 replies)
Pages... 5 6 7


Stonedine
Created by Lizard1977, last reply by surfisup1000 on 23-Apr-2014 21:27 (58 replies)
Pages... 2 3 4


Telecom has started metering their TiVo customers' broadband usage (WITHOUT PRENOTIFICATION)
Created by Peteriv, last reply by mxpress on 23-Apr-2014 14:22 (69 replies)
Pages... 3 4 5


Forms of government for New Zealand
Created by charsleysa, last reply by KiwiNZ on 23-Apr-2014 20:57 (169 replies)
Pages... 10 11 12


Parallel imported product
Created by Wills1, last reply by joker97 on 23-Apr-2014 21:01 (53 replies)
Pages... 2 3 4


MH370 - Call for Search & Rescue Help
Created by DS248, last reply by joker97 on 23-Apr-2014 22:37 (737 replies)
Pages... 48 49 50


Labour MP Shane Jones to step down
Created by jeffnz, last reply by jeffnz on 23-Apr-2014 20:41 (32 replies)
Pages... 2 3


Upcoming Freeview Restack AUCKLAND
Created by Brunzy, last reply by richms on 23-Apr-2014 21:05 (13 replies)


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.