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
BarTender
3219 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


DjShadow

3321 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 :)

 
 
 
 


BarTender
3219 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


DjShadow

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

BarTender
3219 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


eXDee
4025 posts

Uber Geek

Trusted

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

You are awesome bartender! Much appreciated!

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

 
 
 
 


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

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

PottsyNZ
303 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? :)

BarTender
3219 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

DS9
321 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.


tritex
188 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.....?

eXDee
4025 posts

Uber Geek

Trusted

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

Check bartenders maps above for yourself. I believe not.

loganjames
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





News »

Vodafone enables 5G roaming - for when international travel comes
Posted 30-Oct-2020 15:03


Spark awards funding to Kiwi businesses in 5G funding initiative
Posted 30-Oct-2020 14:58


Huawei launches IdeaHub Pro in New Zealand
Posted 27-Oct-2020 16:41


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









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.