2D Hamilton Towers

Forums › 2degrees › 2D Hamilton Towers

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

3219 posts

Uber Geek

Trusted

Lifetime subscriber

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

and

DjShadow

3321 posts

Uber Geek

Trusted

#487027 28-Jun-2011 17:20

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

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

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

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

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

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

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

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

321 posts

Ultimate Geek

Lifetime subscriber

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

I aim to misbehave.

tritex

188 posts

Master Geek

Trusted

#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

Trusted

#490169 6-Jul-2011 17:24

Check bartenders maps above for yourself. I believe not.

loganjames

272 posts

Ultimate Geek

#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