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

Uber Geek

Trusted
Lifetime subscriber

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




and 




3077 posts

Uber Geek

Trusted

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

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

 
 
 
 


2901 posts

Uber Geek

Trusted
Lifetime subscriber

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




and 




3077 posts

Uber Geek

Trusted

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

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

2901 posts

Uber Geek

Trusted
Lifetime subscriber

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




and 


4025 posts

Uber Geek

Trusted

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

You are awesome bartender! Much appreciated!

1917 posts

Uber Geek


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

 
 
 
 


4025 posts

Uber Geek

Trusted

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

1917 posts

Uber Geek


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

298 posts

Ultimate Geek


  # 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? :)

2901 posts

Uber Geek

Trusted
Lifetime subscriber

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




and 


DS9

295 posts

Ultimate Geek

Lifetime subscriber

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




I aim to misbehave.


187 posts

Master Geek

Trusted

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

4025 posts

Uber Geek

Trusted

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

Check bartenders maps above for yourself. I believe not.

272 posts

Ultimate Geek


  # 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



Switch your broadband provider now - compare prices


Twitter and LinkedIn »



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 »

Samsung Galaxy Fold now available in New Zealand
Posted 6-Dec-2019 00:01


NZ company oDocs awarded US$ 100,000 Dubai World Expo grant
Posted 5-Dec-2019 16:00


New Zealand Rugby Selects AWS-Powered Analytics for Deeper Game Insights
Posted 5-Dec-2019 11:33


IMAGR and Farro bring checkout-less supermarket shopping to New Zealand
Posted 5-Dec-2019 09:07


Wellington Airport becomes first 5G connected airport in the country
Posted 3-Dec-2019 08:42


MetService secures Al Jazeera as a new weather client
Posted 28-Nov-2019 09:40


NZ a top 10 connected nation with stage one of ultra-fast broadband roll-out completed
Posted 24-Nov-2019 14:15


Microsoft Translator understands te reo Māori
Posted 22-Nov-2019 08:46


Chorus to launch Hyperfibre service
Posted 18-Nov-2019 15:00


Microsoft launches first Experience Center worldwide for Asia Pacific in Singapore
Posted 13-Nov-2019 13:08


Disney+ comes to LG Smart TVs
Posted 13-Nov-2019 12:55


Spark launches new wireless broadband "Unplan Metro"
Posted 11-Nov-2019 08:19


Malwarebytes overhauls flagship product with new UI, faster engine and lighter footprint
Posted 6-Nov-2019 11:48


CarbonClick launches into Digital Marketplaces
Posted 6-Nov-2019 11:42


Kordia offers Microsoft Azure Peering Service
Posted 6-Nov-2019 11:41



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.