

Table of Contents
1.0 Introduction
1.1 Location
1.2 Cellular Phone Technology 101
1.3 On-Line Cellular Coverage Maps
2.0 Sources of Data
3.0 GIS Line of Site Analysis Process
4.0 Analysis Results
5.0 Field Validation of the Results
6.0 Conclusion
Listing of Figures
Listing of Tables
1.0 Introduction
Cellular Phone Coverage (CPC) is dependent on optimal placement of cellular towers. Based on experiences, as a Sprint Personal communication System (PCS) user, analysis should find that the southern area of Sarpy county is lacking in sufficient coverage. Through the use of Geospatial Information Systems (GIS), it is possible to assess cellular coverage areas using viewshed analysis, available through three dimensional analysis functionality. This type of functionality will be used to perform a line of site analysis of Sprint PCS coverage in the Sarpy county area of eastern Nebraska. Field verification of the analysis will be performed using a Sprint PCS phone to measure signal strength and a GPS receiver to record locations by geographic coordinates.

Fig. 1. Location of Sarpy County in Nebraska
GIS data was derived from U.S. Census Bureau Tiger 2000 files available from: http://www.nrc.state.ne.us/databank/spat.html.
1.1 Location
Sarpy county is located in the extreme eastern portion of Nebraska. A majority of the boundary outline is defined by major Midwestern tributaries, the Missouri River and the Platte River. To the north is Douglas county. Most of Omaha falls within Douglas county, making it the most populous county in Nebraska. As a result of the proximity to Douglas county, northeastern Sarpy county is densely populated. The remainder of the county is very rural.

Fig. 2. Sarpy County Population Density by Census Tracts.
Derived from 1990 U.S. Census Data (http://www.ciesin.org/)
The physical geography of the region is predominately rolling hills, except in the extreme eastern, southern, and western areas of the county that consist of floodplain. The most extensive floodplain is in western Sarpy county. In this area, the Platte River has formed a broad floodplain. As the river turns east to form the Southern boundary of the county, the floodplain narrows and the bluffs become more abrupt as a result of the sedimentary rock outcrops in this area.


Fig. 3.
Sarpy County Land Cover Diagram.
Derived from Landsat TM imagery dated 1992. Available from: http://seamless.usgs.gov
1.2 Cellular Phone Technology 101
The cellular phones that we enjoy today are the result of advancements in electronic and computer technology. Electronic technology has enabled cell phones to become smaller yet more powerful. Computer technology has greatly improved the signal/reception quality of the personal cellular phone. Computers enable the processing of thousands of encoded digital signals at a given point of time. Computers also convert the encoded signals to a discernable audible voice. This manipulation goes undetected by cellular users.
Cellular phones are dependent on a network of towers for receiving/sending calls. The basic concept of cellular communication is that signals travel in a linear direction (straight line). The influence of the ground surface enables a degraded signal to be received by a cellular user who is outside the line of site buffer of a cellular tower network.
Signal intensity is a function of line of site access to the cellular tower network. As a cellular phone user travels
away from a tower, the signal will decrease. As you loose site of a tower, the amount of signal loss increases, until
which point the signal is lost completely.
Another factor that influences cellular signal intensity is land cover. Heavily forested areas and buildings tend to
decrease (absorb) signal intensity. In Sarpy county, tree coverage is significant along the Platte and Missouri
Rivers, as well as in established populated areas such as Papillion, LaVista, Springfield, and Bellevue. The trees in
these areas tend to degrade signal intensity (reference Fig. 3).
The placement of towers is directly proportional to population densities. Transmitters/receivers that are located
on the cellular towers are limited to the number of calls that can be processed at any given time. To compensate for
this limitation, the tower heights are decreased and the numbers of towers are increased in proportion to the
population density. By decreasing the tower height, the area coverage and potential customer base that have access
to the tower transmitters/receivers is also decreased.
1.3 On-Line Cellular Coverage Maps
A number of cellular companies have on-line services for assessing coverage in given geographical areas.


![]()
![]()
![]()
![]()
![]()
![]()
Fig. 4. NEXTEL Coverage Graphic (http://www.nextel.com)

![]()
![]()
![]()

Fig. 5. Sprint PCS Coverage Graphic (http://www1.sprintpcs.com)
Verizon Wireless

Fig. 6. Verizon Wireless Local Coverage Graphic (http://www.verizonwireless.com)
Verizon Wireless National Coverage

Fig. 7. Verizon Wireless National Coverage (http://www.verizonwireless.com)
Cricket Cellular

Fig. 8. Cricket Cellular Local Coverage (http://www.letstalk.com)
The above maps are an example of the types of cellular coverage that is available in the greater Omaha area. All of the on-line coverage maps provide a generalized representation of coverage areas. The Cricket coverage map showed the most detail, listing major roads (interstates and highways) and surrounding cities in the Omaha area. Verizon Wireless provides the most extensive communication network of all the cellular plans reviewed for this project. Both NEXTEL and Sprint PCS networks are limited to major cities and significant transportation networks. For this project, a more detailed coverage analysis and field validation will be performed on the Sprint PCS network in the Sarpy county region of eastern Nebraska.
2.0 Sources of Data
The collection of source information for this project was a very time intensive process. Of significant challenge was deriving accurate data on the Sprint PCS cellular towers in the Omaha region. Initially, cellular tower locations were derived from the Federal Communication Commission’s (FCC) National Vertical Obstruction Database website (http://wireless.fcc.gov/cgi-bin/wtb-datadump.pl). The initial database file contained over 750,000 records. From this listing, Sprint PCS cellular towers in the Douglas/Sarpy county region were extracted. The initial dataset listed geographic location in degrees, minutes, and seconds. Locations were converted to decimal degrees in Microsoft Excel using the following formula:
Decimal Degrees=SUM(degrees+((minutes/60)+(seconds/3600))).
A major drawback to the FCC database is that cellular towers under 33 meters are not required to be reported. As a result, any analysis performed using this dataset would not be an accurate representation of the true line of site area. Contact was made with the Sprint PCS technical representative for the eastern Nebraska region. An agreement was made to provide a complete list of Sprint PCS tower locations that impact reception in Sarpy county.
Listing of FCC SPRINT PCS Towers over the Greater Omaha Area
|
Latitude dd |
Longitude dd |
HGL(M) |
AGL(M) |
AMSL(M) |
City |
Business Name |
|
41.171583333 |
95.936944444 |
350.6 |
28 |
378.6 |
BELLEVUE |
SPRINT PCS |
|
41.177111111 |
95.922888889 |
325.5 |
33.5 |
359.1 |
BELLEVUE |
SPRINT SPECTRUM LP |
|
41.303722222 |
95.855277778 |
379.5 |
34.1 |
413.6 |
COUNCIL BLUFFS |
SPRINT SPECTRUM |
|
41.152361111 |
96.145611111 |
362.1 |
61.0 |
423.1 |
GRETNA |
SPRINT SITES USA |
|
41.214138889 |
96.133083333 |
322.5 |
27.1 |
349.6 |
MILLARD |
SPRINT SPECTRUM LP |
|
41.141444444 |
95.995777778 |
342.0 |
22.9 |
364.8 |
OMAHA |
SPRINT SITES USA |
|
41.141361111 |
95.995833333 |
342.0 |
21.9 |
363.9 |
OMAHA |
SPRINT SPECTRUM |
|
41.153583333 |
95.922222222 |
340.8 |
34.1 |
374.9 |
OMAHA |
SPRINT SPECTRUM |
|
41.232472222 |
96.153333333 |
330.7 |
40.2 |
370.9 |
OMAHA |
SPRINT SPECTRUM |
|
41.152388889 |
96.145583333 |
362.4 |
40.2 |
402.6 |
OMAHA |
SPRINT SPECTRUM |
|
41.185250000 |
96.080277778 |
344.7 |
31.1 |
375.8 |
OMAHA |
SPRINT SPECTRUM |
|
41.221833333 |
96.123277778 |
363.4 |
34.1 |
397.5 |
OMAHA |
SPRINT SPECTRUM |
|
41.180388889 |
96.120250000 |
335.9 |
42.1 |
378 |
OMAHA |
SPRINT SPECTRUM LP |
|
41.232222222 |
96.085972222 |
332.2 |
35.1 |
367.3 |
OMAHA |
SPRINT SPECTRUM LP |
|
41.139527778 |
95.924166667 |
307.2 |
33.5 |
340.8 |
OMAHA |
SPRINT SPECTRUM LP |
|
41.214138889 |
96.133083333 |
322.5 |
48.8 |
371.2 |
OMAHA |
SPRINT SPECTRUM LP |
|
41.173805556 |
96.041027778 |
346.6 |
33.5 |
380.1 |
PAPILLION |
SPRINT SPECTRUM LP |
HGL = Ground elevation at Base of the tower AGL = Height of tower
AMSL = Above Mean Sea Level M = Meters Note: Tower elevations are in meters
Table 1. FCC Sprint PCS cellular tower locations in the Douglas/Sarpy county region of eastern Nebraska. Extraction date: October 2003.
The elevation of the top of the towers is necessary for performing line of site analysis. The original dataset did not include the elevation in for the top of each tower. Only tower height information was provided. To establish the elevation at the top of each tower, the base elevation had to be established first. Base elevations were derived using ArcGIS to extract elevations from United States Geological Survey (USGS) Digital Elevation Model (DEM) 10 meter data. The base elevation height was then added to the tower height to determine the elevation for the top of each tower.
Complete Listing of SPRINT PCS Towers in the Sarpy County Area
|
Location Name |
AGL(M) |
Lat. dd |
Long. dd |
HGL(M) |
AMSL(M) |
|
KayJayTower |
39.93 |
41.2141 |
-95.9489 |
357.02 |
396.95 |
|
Holy Ghost Parish |
18.29 |
41.2079 |
-95.9939 |
348.45 |
366.74 |
|
Zivney |
24.38 |
41.1716 |
-95.9369 |
350.99 |
375.37 |
|
Bryan High School |
27.74 |
41.1769 |
-95.9804 |
337.84 |
365.58 |
|
OPPDColo |
7.01 |
41.1544 |
-95.9215 |
344.55 |
351.56 |
|
HamTower |
32.93 |
41.1419 |
-95.8981 |
364.71 |
397.64 |
|
Capeheart (haddix) |
38.41 |
41.1213 |
-95.9566 |
338.21 |
376.62 |
|
Rumsey |
18.60 |
41.1414 |
-95.9958 |
342.00 |
360.60 |
|
KeystoneDrug |
6.70 |
41.2044 |
-96.0590 |
345.38 |
352.08 |
|
AliantColo (Brentwo |
31.09 |
41.1927 |
-96.0354 |
346.73 |
377.82 |
|
PapillionWaterTower |
21.00 |
41.1406 |
-96.0481 |
349.45 |
370.45 |
|
IpsyFoods |
24.41 |
41.1852 |
-96.0803 |
349.46 |
373.87 |
|
WTC |
27.43 |
41.2156 |
-96.0850 |
365.75 |
393.18 |
|
MillardWaterTower |
24.00 |
41.2050 |
-96.1392 |
358.23 |
382.23 |
|
KOA |
36.28 |
41.0939 |
-96.2650 |
382.62 |
418.90 |
|
I-80 Refrigeratior |
36.58 |
4.1524 |
-96.1456 |
360.90 |
397.48 |
|
Millard West HS |
45.72 |
412044 |
-96.1940 |
376.02 |
421.74 |
|
DeMontigny Property |
36.58 |
41.1806 |
-96.1202 |
338.62 |
375.20 |
|
Builders Surplus |
27.43 |
41.2044 |
-96.0228 |
307.00 |
334.43 |
|
Keller Farm |
33.53 |
41.1758 |
-96.1586 |
357.02 |
390.55 |
|
Milt`s Storage |
22.86 |
41.2072 |
-96.0926 |
333.79 |
356.65 |
|
St. Mary`s School |
21.34 |
41.2044 |
-95.9666 |
366.44 |
387.78 |
|
Cape Truck Toppers |
36.58 |
41.1149 |
-95.9308 |
298.21 |
334.79 |
|
Oak Leaf Farms |
58.00 |
41.1106 |
-96.0216 |
340.97 |
398.97 |
|
Fireside |
30.00 |
41.1738 |
-96.0410 |
345.88 |
375.88 |
|
Bellevue Fleet Main |
30.48 |
41.1395 |
-95.9242 |
307.00 |
337.48 |
|
Southroads Mall |
30.48 |
41.1771 |
-95.9229 |
328.26 |
358.74 |
|
American Legion Mil |
24.38 |
41.2142 |
-96.1331 |
323.15 |
347.53 |
|
Gretna Fire Station |
48.77 |
41.1474 |
-96.2326 |
386.32 |
435.09 |
HGL = Ground elevation at Base of the tower AGL = Height of tower
AMSL = Above Mean Sea Level M = Meters Note: Tower elevations are in meters
Table 2. Sprint PCS cellular tower locations in the Sarpy county region of eastern Nebraska. Data provided by Sprint PCS. Extraction date: November 2003.
The digital elevation data, as well as land cover was derived from the USGS Seamless National Database http://seamless.usgs.gov/. Other GIS sources of information included the following:
n Vector Data (Census TIGER/Line data) http://www.census.gov
To include: roads, drainage, city, county, and census tract boundaries.
n Population Data (1990 U.S. Census) http://www.ciesin.org.
3.0 GIS Line of Site Analysis Process







![]()
![]()
![]()
![]()
![]()
![]()
Fig. 9. Line of Site Process Flow Diagram
Fig. 9 reflects the steps taken to complete the line of site analysis for this project. The Albers equal area projection was selected since area analysis was being performed.
The Albers equal area projection parameters:
Latitude of Origin 37.5, False Easting 0, False Northing 0, Prime Meridian 0
Central Meridian -096.0, Standard Parallels 40.75 & 41.50
GCS North American 1983, Datum NAD83.
Projections were modified using functions in the ArcGIS Toolbox. Both the vector and the raster data were clipped to the project extent to reduce file/project size and decrease processing time to create the TIN model. Vector data was clipped using the ArcGIS GeoProcessing Wizard. Raster data was clipped using ERDAS Imagine 8.5.
Viewshed analysis was performed using ArcGIS 8.3 ArcMAP and the 3D Analyst extension. The Sprint PCS tower line of site coverage area was established using the 3D Analyst viewshed.
4.0 GIS Line of Site Analysis Results

Using GIS to establish line of site coverage of the Sarpy county Sprint PCS cellular tower network verifies that the most significant coverage corresponds to the populous region of the county (reference Fig. 2). The only significantly populated area not covered by the cellular network line of site coverage is Springfield in the south central region of the county. The southern region, as a whole, does not have significant line of site coverage.
Fig 10. Sarpy County Sprint PCS Line of Site Analysis
5.0 Field Validation
To validate actual Sprint PCS signal coverage, field readings were taken.

Fig. 11. SPRINT PCS Signal Intensity Field Validation Locations
Signal intensities were measured throughout the county using capabilities available through the personal cell phone debug screen. Signal intensities were measured in decibels. Optimum signal reception ranges were provided by
Sprint PCS:
· < -85 db Good
· -85 to -95 db Marginal
· -95 to -105 db Poor
· > -105 db Potential loss of Signal

Field Validation
locations were recorded as geographic coordinates (latitude/longitude) using a
Global Positioning System (GPS) device.
Fig. 12. SPRINT PCS Signal Validation Graphic
The final Sprint PCS Signal Intensity Graphic was created using ArcGIS Spatial Analyst. Interpolation of the surface model was established using inverse distance weighted computations. Fig. 12 reflects a much greater area coverage then what was
represented by the by of line of site analysis (Fig.10) due to the attenuation of the cellular signal as a result of interaction with land cover elements. This phenomenon tends to extend reduced signal reception beyond the limits of the line of site buffer. The signal eventually becomes so weak that it is undetectable by cellular phone.
The Field Validation graphic shows Springfield as an area void of optimum signal coverage. Southern Sarpy county, between Louisville and Schramm State Park is also a significant void area. Loss of signal in this region is mostly due to significant changes in topography, as well as tree coverage. Of particular interest is the attenuation of signal strength due to trees and buildings in the downtown Papillion area and the loess hills area in the northeastern corner of the county.
6.0 Conclusion
Cellular maps that are available on line are very generic in their representation of coverages. Of the on line coverage maps reviewed, Verizon has
the most extensive. To precisely define the cellular coverage extent, GIS provides a platform for performing detailed analysis.
The positioning of the Sprint PCS tower network is directly related to the populous areas of Sarpy county. The populated area of note that is lacking optimum signal coverage is Springfield. This is an area that would benefit greatly from the addition of a cellular tower. It’s apparent though GIS analysis performed that void areas exist in Sprint PCS signal coverage over Sarpy county. Graphics generated from this analysis could serve several uses; as a reference to Sprint PCS users in Sarpy county to identify limited use areas, and as an aid in determining future tower placement in Sarpy county.
Listing of Figures
Fig. 1 Location of Sarpy County in Nebraska. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1.0
Fig. 2 Sarpy County Population Density by Census Tract. . . . . . . . . . . . . . . . . . . . . . . 1.1
Fig. 3 Sarpy County Land Cover Diagram. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .1.1
Fig. 4 Nextel Coverage Graphic . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .1.3
Fig. 5 SPRINT PCS Coverage Graphic . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .1.3
Fig. 6 Verizon Wireless Local Coverage Graphic . . . . . . . . . . . . . . . . . . . . . . . . . . . . .1.3
Fig. 7 Verizon Wireless National Coverage . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1.3
Fig. 8 Cricket Cellular Local Coverage . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1.3
Fig. 9 Line of Site Process Flow Diagram . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3.0
Fig. 10 Sarpy County SPRINT PCS Line of Site Analysis . . . . . . . . . . . . . . . . . . . . . . 4.0
Fig. 11 SPRINT PCS Signal Intensity Field Validation Locations. . . . . . . . . . . . . . . . . 5.0
Fig. 12 SPRINT PCS Signal Validation Graphic . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5.0
Listing of Tables
Table 1 FCC SPRINT PCS Cellular Tower Locations in Douglas/Sarpy County. . . . . .2.0
Table 2 Complete Listing of SPRINT PCS Towers in The Sarpy County Area . . . . . . .2.0