SAFE-T Tower Google earth waypoints & DDD to DMS Spread sheet

Status
Not open for further replies.

dagooch0525

Member
Joined
May 31, 2004
Messages
41
I thought it would be more appropriate to post this in a separate thread.

The attachment contains one excel file with corrected coordinates for each SAFE-T site and a Google earth *.kmz file so you can look at the pretty towers too.

The excel file started from a CVS file posted previously by Racin06 (Thanks again!) I have updated it with some correction (additional sites, Frequencies and coordinates) as well as added some additional columns I thought would be useful.

I've added 2 columns that take the Lat Long in DDD format and convert it to DMS. This can then be copied into the free UASD software for the BCD996T. There is also a column that has the lat / long in a format that can be easily copied into Google earth. (BTW all of Indiana is in high resolution). The BCD996T tab just has the pertinent data transposed. (Again for easy of copying into UASD system editor)

I have verified most of the sites coordinates via Google Earth (The sites highlighted in green have been verified with Google earth). If anyone could verify the coordinates of those not highlighted I would greatly appreciate it.

Enjoy the files

EDIT:
I have updated the files see 01/09/07 Post further down
 
Last edited:

spooney

Member
Joined
Dec 19, 2002
Messages
424
Location
Indiana
Indiana Safe-T

Here are some additional locations. I was unable to zoom in on the Henderson Ky Tower
with Google, but it is there.
GTW
 

spooney

Member
Joined
Dec 19, 2002
Messages
424
Location
Indiana
Indiana Safe-T

My files aren't uploading for some reason. If you want the files I can e-mail them.
 

trido

Active Member
Premium Subscriber
Joined
Dec 19, 2002
Messages
1,194
Location
Southern In
spooney said:
Here are some additional locations. I was unable to zoom in on the Henderson Ky Tower
with Google, but it is there.
GTW
I dont have Henderson in his file?
 

trido

Active Member
Premium Subscriber
Joined
Dec 19, 2002
Messages
1,194
Location
Southern In
dagooch0525 said:
I thought it would be more appropriate to post this in a separate thread.

The attachment contains one excel file with corrected coordinates for each SAFE-T site and a Google earth *.kmz file so you can look at the pretty towers too.

The excel file started from a CVS file posted previously by Racin06 (Thanks again!) I have updated it with some correction (additional sites, Frequencies and coordinates) as well as added some additional columns I thought would be useful.

I've added 2 columns that take the Lat Long in DDD format and convert it to DMS. This can then be copied into the free UASD software for the BCD996T. There is also a column that has the lat / long in a format that can be easily copied into Google earth. (BTW all of Indiana is in high resolution). The BCD996T tab just has the pertinent data transposed. (Again for easy of copying into UASD system editor)

I have verified most of the sites coordinates via Google Earth (The sites highlighted in green have been verified with Google earth). If anyone could verify the coordinates of those not highlighted I would greatly appreciate it.

Enjoy the files

thanks this is great can we get all the sites from excel file into the google maps file?

My man site isnt in map the henderson,Ky site

thanks
 

dagooch0525

Member
Joined
May 31, 2004
Messages
41
Hi All,

I updated the files again. I was able to find sites 402 Petersburg (Pike) and 420 Leavenworth (Crawford).

402 was a little south of the original coordinates posted. I have tweaked them so it is closer to the tower.

Site 420 had site 418 Rockport (Spencer) coordinated. The SAFE-T RR database has the Site license and site Neighbors call sign flipped on the Additional Site Information Page. Instead of looking up the location for call sign WQEE929 (420), it was looking up the location for WQED853 (418). I went to the FCC website to find correct coordinates.

Per Trido’s request I placed the posted coordinates for the 428 Henderson site in the *.KMZ. Unfortunately, I can’t verify that there really is a tower there because the resolution on Google earth is poor in that location. Looks like Spooney is confirming it is truly there so I may highlight it green next go round.

I also added the posted coordinates for the 423 Princeton (Gibson) site in the *.KMZ file. There again I didn’t see a tower there, however that could be because the satellite picture was taken before it was built. I can’t say for sure.

Spooney, I mean no disrespect, but I don’t give out my email address in any of the forums I frequent. If you could post the additional information for everyone, that would be the best way. Thanks.

EDIT: Updated files again See my post on 01/10/2007
 
Last edited:

trido

Active Member
Premium Subscriber
Joined
Dec 19, 2002
Messages
1,194
Location
Southern In
dagooch0525 said:
Hi All,

I updated the files again. I was able to find sites 402 Petersburg (Pike) and 420 Leavenworth (Crawford).

402 was a little south of the original coordinates posted. I have tweaked them so it is closer to the tower.

Site 420 had site 418 Rockport (Spencer) coordinated. The SAFE-T RR database has the Site license and site Neighbors call sign flipped on the Additional Site Information Page. Instead of looking up the location for call sign WQEE929 (420), it was looking up the location for WQED853 (418). I went to the FCC website to find correct coordinates.

Per Trido’s request I placed the posted coordinates for the 428 Henderson site in the *.KMZ. Unfortunately, I can’t verify that there really is a tower there because the resolution on Google earth is poor in that location. Looks like Spooney is confirming it is truly there so I may highlight it green next go round.

I also added the posted coordinates for the 423 Princeton (Gibson) site in the *.KMZ file. There again I didn’t see a tower there, however that could be because the satellite picture was taken before it was built. I can’t say for sure.

Spooney, I mean no disrespect, but I don’t give out my email address in any of the forums I frequent. If you could post the additional information for everyone, that would be the best way. Thanks.
Henderson looks right ,it is on existing WFIE ch 14 TV tower. But that sure looks close

thanks
 

dfoutch

Member
Premium Subscriber
Joined
Dec 12, 2004
Messages
3,403
Location
Anderson, Indiana,46013
Anderson site notes

Notice there are two towers at that site:
South tower:
Tower # 1201751; File # A0115481; 129.5 meters AGL
40 10 30.1 N 085 40 24.9 W
owner: Philip T or Paul A, Parton dba http://www.lectrocom.com
SAFE-T is on this tower
Other users are:
Madison, Co of KNJY225 (Co roads maintenance)
Madison, Co of KNNF707 (Co 800 sys}
Madison, Co of KRG800 (EMA)
Madison, Co of KSC965 (Fire/EMS mutual aid)
Lectro Comm WPNV328 (UHF SMR)
Indiana, State of WQDC300 SAFE-T)
Indiana, State of WQES202 (856.4875 MDT)

North Tower:
Tower # 1061750; File # A0072247; 115 Meters AGL
40 10 38.0 N, 085 40 23.0 W
Owner: Lectro Communications Inc
Users are:
Lectro Comm KFB470 (IG)
Clan Farms KNAK767 (IG)
NexTel Holdings KNRV410 (YX)
Donahue Gas Inc KTD587 (IG)
Indiana Radio Partners Inc WAQ298 (AS)
Weidner Chevrolet (IG)
AG ONE CO OP WNZK930 (IG)
Anderson Community Schools WPMP546 (GB)

dean
 

dfoutch

Member
Premium Subscriber
Joined
Dec 12, 2004
Messages
3,403
Location
Anderson, Indiana,46013
Pendleton Site notes

Tower # 1027684; File # A0032852; 152.4 Meters AGL
Owner: Indiana, State of
39 58 21.1 N, 085 46 13.9 W
Users are:
KNBR745 DNR P~P 155.370 PW
KSA461 ISP VHF Lo/HI
WNXG826 IPSC SAFE-T YF
WPAM932 DNR District (159.24, 159.345, 159.465)

dean
 

spooney

Member
Joined
Dec 19, 2002
Messages
424
Location
Indiana
Indiana Safe-T

Princeton (Gibson) location is: N38.389511/W87.407685
Bramble (Martin) location is : N38.790568/W86.914983
Winslow (Pike) location is : N38.327993/W87.184837

The Princeton location that R/R has is incorrect which put it on the east side of the county line road which is in Pike County. It is a little hard to see on Google, but it is there on the west side of the county line road between the road and the pond.

Bramble and Winslow are not operational yet, but are under construction at this time.

You should be OK with the Henderson,Ky. site. It is on WFIE-14's tower.
GTW
 

spooney

Member
Joined
Dec 19, 2002
Messages
424
Location
Indiana
Indiana Safe-T

also: Under Construction
Birdseye (Crawford) location is : N38.383735/W86.644287
GTW
 

spooney

Member
Joined
Dec 19, 2002
Messages
424
Location
Indiana
Indiana Safe-T

Here's another one under construction.
Rosewood (Harrison) location is: N38.173617/W85.913397

Just south of the Harrah's Casino Boat
 

dagooch0525

Member
Joined
May 31, 2004
Messages
41
THANK YOU to all who have contributed!

Here is what I have done today:

Highlighted site 428 Henderson (Henderson, KY) green as Spooney and Trido both confirmed the coordinates were correct.

Tweaked 423 Princeton (Gibson) site coordinates and highlighted it green per Dfoutch & Spooney’s confirmation.

Added coordinates for 308 Rosewood (Harrison), 419 Bramble (Martin), 426 Birdseye (Crawford), & 429 Winslow (Pike) and high lighted it yellow (Confirmed via Google Earth but looking for SAFE-T control channel frequencies) Thanks Spooney.

Added 308 Rosewood (Harrison), 419 Bramble (Martin), 423 Princeton (Gibson), 426 Birdseye (Crawford), & 429 Winslow (Pike) to the Google Earth *.kmz file

Again THANK YOU to all who have contributed so far!
Please let me know if you find errors in the spread sheet.
 

Attachments

  • Indiana SAFE-T_20070110.zip
    30.3 KB · Views: 146

dagooch0525

Member
Joined
May 31, 2004
Messages
41
SAFE-T spread sheet for BCD996T w/ Google Earth coord.

All,

I have updated several sites and made some improvements to the spread sheet based off the RR SAFE-T database and FCC web site. See the change log tab for details.

I also updated the *.kmz file for Google Earth.

Enjoy!
 

Attachments

  • Indiana_SAFE_T_20070415.zip
    49.6 KB · Views: 145

trido

Active Member
Premium Subscriber
Joined
Dec 19, 2002
Messages
1,194
Location
Southern In
dagooch0525 said:
All,

I have updated several sites and made some improvements to the spread sheet based off the RR SAFE-T database and FCC web site. See the change log tab for details.

I also updated the *.kmz file for Google Earth.

Enjoy!
Thanks this great thanks.
One xl change Henderson Site 866.76250* 868.55000

They changed a couple months ago

thanks
 

dagooch0525

Member
Joined
May 31, 2004
Messages
41
Thanks for the correction, trido. If anyone finds anymore errors please let me know.

Thanks!
 
Status
Not open for further replies.
Top