Import Cell Sites

Summary

Creates cell site points and sector polygons from a cell site table containing input latitude, longitude, latitude, azimuth, beamwidth, and radius information.

Usage

  • Disclaimer: Output sector polygons are generated by the values provided in the input cell site table or the default values specified in the default start azimuth, beamwidth, and radius parameters. The polygons are a visual representation of the values provided and should not be interpreted as the actual sector boundaries as there is potential for beamwidth extents and radial distance to vary.
  • Some wireless network provider tables combine cell phone call data records and the site information into the same row. In these cases, it is recommended to separate the site information (identifier fields, azimuth, beamwidth, radius) into its own table and to use the newly separated table as the input to this tool.
  • Some wireless network provider tables use multiple combinations of identifier field types to define a unique record within the same table. For example, Site Identifier and Sector Identifier field types uniquely define some records, but other records in the table are uniquely defined with a Location Area Code Identifier and Cell Identifier field type. In this case all of the identifier types that are used in the input cell site table should be selected in the Cell Sector Identifier Field(s) parameter and the tool will determine the different identifier type combinations automatically.
  • Each row of the input cell site table should represent a unique site sector antenna, however, if the tool determines there are duplicates based on the inputs of the cell phone identifiers parameter then only one of the records will be preserved in the final output.
  • If the input cell site table's rows contain information about more than one sector then it is recommended to move additional sector information into its own row in the table. For example, if the input cell site table has 10 records with the following fields: Beginning Switch Identifier, Beginning Site Identifier, Beginning Sector Identifier, Beginning Sector Latitude, Beginning Sector Longitude, Beginning Sector Beamwidth, Ending Switch Identifier, Ending Site Identifier, Ending Sector Identifier, Ending Sector Latitude, Ending Sector Longitude, and Ending Sector Beamwidth; then this table should be formatted into a new table with following fields: Switch Identifier, Site Identifier, Sector Identifier, Sector Latitude, Sector Longitude, Sector Azimuth, Sector Beamwidth. The new table would contain 20 records with the first 10 records being the values of the beginning sector information and the last 10 records being the values of the ending sector information. In the scenario where the beginning and ending sector having the same information for given record in the original table, the tool will determine that the ending sector is a duplicate and it will be ignored.
  • Is it required for output to be created in a projected coordinate system.
  • If an input cell site table's records contain null or empty values for XY coordinate information those records will be ignored.
  • Intended to be used together with the Import Cell Phone Records tool.
  • The following fields will be generated:
    • Identifier fields as specified in the Cell Sector Identifier Fields parameter.
    • sitex: X coordinate (or longitude) of the input cell site feature.
    • sitey: Y coordinate (or latitude) of the input cell site feature.
    • azimuth: a numerical value representing the azimuth angles for the major axis rotations of the output sectors. The values are measured clockwise from North.
    • azimsrc: "INPUT" or "DEFAULT". INPUT will be generated when the sector was generated using the input azimuth from the cell site record. DEFAULT will be generated when the default value from the default azimuth start parameter is used.
    • beamwidth: full beamwidth in degrees of the sector antenna.
    • beamsrc: "INPUT" or "DEFAULT". INPUT will be generated when the sector was generated using the input beamwidth from the cell site record. DEFAULT will be generated when the default value from the default beamwidth parameter is use.
    • radius: distance value of the radius of the sector antenna.
    • radiusunit: linear unit of the distance value of the radius.
    • radiussrc: "INPUT" or "DEFAULT". INPUT will be generated when the sector was generated using the input radius from the cell site record. DEFAULT will be generated when the default value from the default radius parameter is used.

Syntax

ImportCellSites_crime (Input_Cell_Site_Table, Output_Cell_Site_Points, Output_Cell_Site_Sectors, Cell_Sector_Identifier_Fields, X_Field, Y_Field, Input_Coordinate_System, Output_Coordinate_System, {Azimuth_Field}, {Default_Start_Azimuth}, {Beamwidth_Field}, {Beamwidth_Option}, {Default_Beamwidth}, {Radius_Field}, {Radius_Unit}, {Default_Radius_Length})

Parameter Explanation Data Type
Input Cell Site Table Input cell site information table as provided by the wireless network provider. Column names are required to be at the top of the table in order for the tool to interpret field names correctly. Refer to the tool usage section for the expected format of the input cell site table. Table View
Output Cell Site Points Output cell site point feature class. Feature Layer
Output Cell Site Sectors Output cell site sector polygons. Feature Layer
Cell Sector Identifier Fields Cell Sector Identifier Fields Value Table
X Field X coordinate (or longitude) of the cell site. Field
Y Field Y coordinate (or latitude) of the cell site. Field
Input Coordinate System The coordinate system that defines the coordinate pairs in the input cell site table. Coordinate System
Output Coordinate System Output projected coordinate system of the sites and sectors. A projected coordinate system is required to calculate sector radius, beamwidth, and azimuth properties more accurately. The output coordinate system should be the same coordinate system as the map. Coordinate System
Azimuth Field (Optional) Field containing azimuth values. Values are assumed to integers values in degrees from North. Field
Default Start Azimuth (Optional) If the input cell site table does not have azimuth values this option may used to specify a start azimuth value for each sector on a cell site. For example, if 3 sectors were found to be at the same latitude and longitude from the input cell site table and the Default Start Azimuth was 0 degrees, the first sector would be drawn at an azimuth of 0 degrees, the second sector at an azimuth of 120 degrees, and the third sector at an azimuth of 240 degrees using the default beamwidth and radius values as designated below. If no value is specified a default start azimuth value of 0 will be used. Double
Beamwidth Field (Optional) Field containing the full or half beamwidth values of the cell sector. Values are assumed to be in degrees. It is assumed that omnidirectional antennas will have a beamwidth value of 360. Field
Beamwidth Option (Optional) Use this option specify whether the beamwidth values provided in the input cell site table represent the full or half beamwidth. If half beamwidth is chosen the beamwidth values in the output feature class will be converted to full beamwidth. String
Default Beamwidth (Optional) If the input table does not have a beamwidth field or if the some of records have null or empty beamwidth values this option can be used to draw the sectors using a default full beamwidth value. If no value is specified a default beamwidth value of 90 degrees will be used. Double
Radius Field (Optional) Field with values specifying the radial length of the cell sector. Field
Radius Unit (Optional) The linear unit of the radial distance values in the input table or in the Default Radius Length. String

Licensing information

  • ArcGIS Desktop Basic: Yes
  • ArcGIS Desktop Standard: Yes
  • ArcGIS Desktop Advanced: Yes
Top