2D Hamilton Towers

Forums › 2degrees › 2D Hamilton Towers

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11

2206 posts

Uber Geek
+1 received by user: 623

Trusted

Reply # 486909 28-Jun-2011 14:49

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!

DjShadow

2427 posts

Uber Geek
+1 received by user: 284

Trusted

Reply # 487027 28-Jun-2011 17:20

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

BarTender

2206 posts

Uber Geek
+1 received by user: 623

Trusted

Reply # 487057 28-Jun-2011 18:34

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.

DjShadow

2427 posts

Uber Geek
+1 received by user: 284

Trusted

Reply # 487074 28-Jun-2011 19:22

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

BarTender

2206 posts

Uber Geek
+1 received by user: 623

Trusted

Reply # 487117 28-Jun-2011 20:31

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.

eXDee

4025 posts

Uber Geek
+1 received by user: 1076

Trusted

Reply # 487213 29-Jun-2011 00:04

You are awesome bartender! Much appreciated!

SteveON

1916 posts

Uber Geek
+1 received by user: 110

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?

eXDee

4025 posts

Uber Geek
+1 received by user: 1076

Trusted

Reply # 487399 29-Jun-2011 13:13

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

1916 posts

Uber Geek
+1 received by user: 110

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.

PottsyNZ

284 posts

Ultimate Geek
+1 received by user: 14

Reply # 487452 29-Jun-2011 15:20

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

2206 posts

Uber Geek
+1 received by user: 623

Trusted

Reply # 487541 29-Jun-2011 19:57

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.

DS9

267 posts

Ultimate Geek

Reply # 487681 30-Jun-2011 09:14

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.

tritex

185 posts

Master Geek
+1 received by user: 6

Reply # 489852 5-Jul-2011 22:52

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
+1 received by user: 1076

Trusted

Reply # 490169 6-Jul-2011 17:24

Check bartenders maps above for yourself. I believe not.

loganjames

272 posts

Ultimate Geek
+1 received by user: 18

Reply # 491060 8-Jul-2011 13:22

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